A complete D&T project and skills tracker for KS4 (Years 10-11) - built by a practising D&T teacher. Colour-coded grades, auto targets, intervention alerts and a live department dashboard - all in one editable Excel file.
What’s inside (8 tabs):
- START HERE - quick teacher guide
- SCHOOL SETTINGS - school name, year, intervention thresholds (all editable)
- PROJECT LIBRARY - your project list
- SKILL CRITERIA - 11 skill strands aligned to KS4, with editable 4-point rubric (Emerging / Developing / Secure / Mastery)
- STUDENT TRACKER - up to 100 students: skills, auto-calculated indicative grades, grade-gap flags, behaviour-for-learning
- INTERVENTIONS - automatic alerts with owner, dates, outcome and status
- DASHBOARD - live department overview counters
- CURRICULUM MAP - map projects across the year
Key features:
- Auto-calculated indicative grades from skill assessments
- Automatic intervention flags when a student falls behind target or skills dip low
- Colour-coded cells: Emerging red, Developing amber, Secure green, Mastery blue - a full class reads at a glance
- Students needing intervention have their whole row highlighted
- Everything is editable: criteria wording, thresholds, projects, behaviour categories
Companion free worksheets (all CC licensed, free to download): Finger Joint Design in SketchUp, Finger Joint Cutting Tool Ep3 and Ep4, Finger Joint Tool KS3, and SketchUp to DXF Laser-Ready - all in this shop.
Free video tutorials: every tracker comes with free companion SketchUp tutorials on my YouTube channel - watch the teaching before you buy: https://www.youtube.com/@frasiz5808
Who it’s for: D&T teachers and heads of department tracking KS4 projects and skills (Years 10-11).
**After purchase:** instant download, fully editable Excel workbook (.xlsx), lifetime use, single-teacher licence. Works in Excel, Google Sheets (with minor layout adjustments) and Office 365.
Get this resource as part of a bundle and save up to 25%
A bundle is a package of resources grouped together to teach a particular topic, or a series of lessons, in one place.
Something went wrong, please try again later.
This resource hasn't been reviewed yet
To ensure quality for our reviews, only customers who have purchased this resource can review it
Report this resourceto let us know if it violates our terms and conditions.
Our customer service team will review your report and will be in touch.
£8.00