Take the stress out of GCSE Music target-setting, intervention planning, and parent progress reporting with this automated, fully interactive Edexcel GCSE Music (1MU0) Grade & Target Calculator.

By inputting candidates’ raw coursework marks across Unit 1 (Performing) and Unit 2 (Composing), the spreadsheet instantly calculates the exact score (out of 80) each student must achieve in their Unit 3 (Listening & Appraising) exam to reach Grades 9 through 1.

• Dynamic Grade Boundary Selector: Toggle historical and current grade boundary series (e.g., 2025, 2024, 2023) via a simple drop-down menu—all grade threshold formulas recalculate automatically across the entire cohort.
• Exact Exam Target Forecasting: Instantly shows required marks (1–80) for every single grade tier.
• Intelligent Status Flags: Automatically displays Achieved if coursework marks already meet a grade boundary, or N/A if a grade is mathematically unattainable on an 80-mark paper.
• Automated Coursework Totals: Auto-calculates total coursework scores out of 120 (60% weighting) across solo/ensemble and free/brief component submissions.
• Template Protection & Data Validation: Pre-configured with cell input validation to prevent formula corruption while keeping student data entry smooth and intuitive.
• Google Sheets & Excel Compatible: Ready to open in Microsoft Excel or Google Sheets (includes a one-click Google Drive copy link).

1. Interactive Spreadsheet Template: Pre-loaded with candidate tracker and dynamic grade boundary matrix.
2. Professional PDF Quick-Start Guide: A printable 1-page visual guide explaining setup, mark entry, and calculation interpretation.

• Unit 1: Performing: 60 Raw Marks (30%)
• Unit 2: Composing: 60 Raw Marks (30%)
• Unit 3: Listening & Appraising Exam: 80 Raw Marks (40%)