Course refinement report

Scope and audit

Reviewed both Quarto configurations, all eight course pages, every include, course CSS and JavaScript, the publishing workflow, image/video references, PDFs and the V8 workbook XML before editing. Existing unrelated working-tree changes and backup folders were left untouched. Previous tracked versions remain available in Git.

The audit identified repeated orientation and platform explanations; 15 separate navigation partials; undefined layout classes and obsolete progress styles; an intercepted new-window utility; checklist controls missing persistence keys; a reflection control without an explicit label; and an unnecessary formula-transcription task. Browser testing subsequently identified invalid ARIA attributes generated by Quarto’s collapsible callouts.

Files changed

  • All eight top-level .qmd pages in dla-course-2/.
  • _quarto.yml, styles.css, README.md and this report.
  • Shared navigation/utility includes and course-navigation.lua, replacing the 15 per-page navigation partials.
  • course-state.html, _decide-checklist.qmd and _reflect-reflection-input.qmd.
  • Both V8 .xlsx workbooks: platform/scaffolding instructions and reflection prompts; the student workbook also receives the supplied first sensitivity row.
  • Corresponding rendered output in docs/dla-course-2/.

Learning and presentation

Start now has four high-level outcomes and a shorter orientation. Excel is primary; Sheets remains a compatibility pathway. Detailed alignment lives on Reviewer Rationale, with direct links to evidence and a concise performance rubric. Redundant stage-purpose paragraphs were removed while stage outcomes and evidence remain visible.

Build adds one copied-reference diagnosis using the actual tariff cell. Test supplies B8:E8 as infrastructure, retaining the fill-down task, mixed-reference inspection, scenario manipulation and crossover interpretation. The reference workbook’s existing annual-term NPV engine is reused without changing its financial logic. Reflect closes the loop through Revisit, Explain and Transfer.

Navigation uses one ordered stage list at render time and works without JavaScript. Mobile progress wraps rather than requiring horizontal scrolling. Shared components have consistent spacing, formula treatment and focus states. Answer reveals use native details/summary controls. The new-window link retains its target, explicit anchors retain their destinations, and checklist state now persists.

Preserved

The case, Rand inputs, supplier evidence task, learning sequence, visual identity, five workbook sheets, cell addresses, download filenames and deployment path remain. The PDFs and historical V7 workbooks remain unchanged; their numerical guidance is still valid. Payback ranking remains optional. The video remains available in an optional disclosure rather than delaying the core orientation.

Validation

  • Complete standalone Quarto course: all eight pages render successfully with no render warnings.
  • 188 local references checked: no missing pages, fragments, assets or downloads.
  • 32 browser layout checks across 320, 375, 768 and 1440 pixel widths: no horizontal overflow or broken images.
  • Final accessibility rerun on all eight pages at 375 pixels: no reported WCAG A/AA or best-practice violations in the default page state. This is an automated check, not a conformance certification.
  • Independently evaluated all 21 reference-workbook NPV formulas against cached results; crossover is 73.9588%. Student seed formulas match the reference; remaining learner calculation cells remain blank.
  • Browser interaction checks cover prediction/reflection/checklist persistence, formative feedback, workbook download, iframe navigation and navigation without JavaScript.

Manual review remaining

  • Review the original video’s audio and supply verified captions/transcript if it contains meaningful speech or sound. A visual description is provided, but media accessibility is not fully verified.
  • Check the actual published Google Sites embed, including its outer frame height and browser-specific third-party storage/download restrictions.
  • Open the revised workbook in desktop Excel and import it into Google Sheets for final application-level recalculation/formatting checks. XML integrity and numeric results were checked here; neither application was automated.

The local publishing output is updated; no live deployment was performed.