Unit 3 - 20%

Task 2: System Analysis Project

Apply system analysis skills and create a spreadsheet budget solution.

Open Resource Pack Open Task 2 project hub

Assessment Details

Type
Project
Timing
Week 7-9
Weighting
20%
Topics
System analysisSpreadsheet formulasFunctions & lookupsChartsData validation

Task Overview

Task 2: Project (System Analysis + Spreadsheet Budget)

Outline Reference

  • Assessment type: Project
  • Task weighting: 20% (sample outline)
  • Timing: Term 1, Weeks 7-9
  • Dates (2026): Monday 16 March to Thursday 2 April (Term 1 ends Thu 2 April)

Purpose

Assess systems analysis skills and spreadsheet solution development using a realistic scenario.

Student Resource Pack

Keep the student-facing package concise. The main student workflow uses:

  • Student task sheet: task-2/student-task-sheet.md
  • Case study brief: task-2/case-study-brief.md
  • Report template: task-2/report-template.md
  • Context diagram template: task-2/context-diagram-template.md
  • Spreadsheet starter data: task-2/spreadsheet-budget-starter-data.csv
  • Submission checklist: task-2/submission-checklist.md

Teacher-only marking, authentication and moderation documents remain in the repo but are not part of the student website document set.

Evidence and Submission

  • Written analysis report.
  • Context diagram (Yourdon/DeMarco notation).
  • Spreadsheet budget file.

Conditions

  • Task completed over multiple lessons.
  • Authenticity checks required for non-test conditions.

Print-Ready DOCX Files

Student-facing files used on the website:

  • task-2/print-docx/Task-2-Student-Task-Sheet.docx
  • task-2/print-docx/Task-2-Case-Study-Brief.docx
  • task-2/print-docx/Task-2-Report-Template.docx
  • task-2/print-docx/Task-2-Context-Diagram-Template.docx
  • task-2/print-docx/Task-2-Submission-Checklist.docx

Additional teacher/moderation DOCX files are retained in the print folder:

  • task-2/print-docx/Task-2-Overview.docx
  • task-2/print-docx/Task-2-Incremental-Student-Instructions.docx
  • task-2/print-docx/Task-2-Authentication-Checkpoints.docx
  • task-2/print-docx/Task-2-Marking-Rubric.docx
  • task-2/print-docx/Task-2-Teacher-Marking-Guide.docx
  • task-2/print-docx/Task-2-Complete-Package.docx

School Policy (Assessment and Reporting)

  • Missed assessments: absent without a valid reason may incur a penalty decided by the HOLA; unavoidable absence is completed on return.
  • Absences: parent notification required; sickness/misadventure form for formal assessments; medical certificate may be required.
  • Extensions: request to the HOLA before the due date; acceptable reasons include illness/injury/personal circumstances; adjusted date is generally within two days of return.
  • Late submissions: late without acceptable reason receives a percentage penalty set by the teacher in consultation with the HOLA.
  • Academic integrity: no cheating, collusion, plagiarism, or AI-generated work; correct acknowledgment required.
  • Authentication: drafts/checkpoints may be required; in-class validation may be used.

Glossary Verbs (Use Consistently)

  • Analyse: identify components and relationships.
  • Recommend: advise a suitable option based on evidence.
  • Create: make or construct a solution.
  • Justify: give reasons for choices.