KS4 Hospitality & Catering | Practical Mock Assessment Tracking Sheet & Mark Scheme (WJEC / Vocation
Streamline your NEA and practical exam preparations with this comprehensive, easy-to-use Practical Mock Assessment Tracking Sheet, custom-built for Key Stage 4 Hospitality and Catering courses (such as WJEC Level 1/2).
Designed by an experienced Food Preparation and Nutrition teacher, this Excel-based tracker removes the administrative headache of recording multi-dish practical assessments. It allows you to track individual student performance across multiple dishes, break down marks by precise technical skills, and instantly generate clear attainment data.
Key Features:
Multi-Dish Breakdown: Separates scoring cleanly across different dishes and practical tasks to give students granular, actionable feedback.
Automated Calculations: Built-in formulas instantly calculate total scores, percentages, and grade boundaries (0–100% scale), saving hours of manual data entry.
Vocational Criteria Aligned: Tailored for rigorous vocational standards, focusing on hygiene, safety, knife skills, thermal-processing, and final presentation.
Fully Editable: Provided as an Excel spreadsheet so you can easily adapt weightings, grade boundaries, or student names to fit your specific cohort.
Buyer’s Guide & Instructions for Teachers
How to Use This Tracking Sheet
Input Student Details: Setup.
Open the Excel spreadsheet and enter your student names or candidate numbers into the designated column on the master tracking sheet.
Verification: Student names populate across all individual dish rows and summary sheets.
Enter Practical Marks: Assessment.
As you assess each practical mock session, input the raw marks for each specific dish and skill category into the corresponding cells.
Verification: Total scores automatically update in real-time as marks are entered.
Review Percentage & Grade Outputs: Analysis.
Check the summary columns where automated formulas calculate the final percentage (0–100%) and projected grade indicators against your specification’s boundaries.
Verification: Percentage fields reflect accurate math without #VALUE! or reference errors.
Export & Share Feedback: Action.
Use the generated data to identify individual student gaps or whole-class misconceptions to drive targeted intervention ahead of formal NEA assessments.

