KS3 D&T Project Tracker | Progress, Skills, Targets

A complete D&T project and skills tracker for KS3 (Years 7-9) - 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 - 10 skill strands 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 KS3 projects and skills.

Single-teacher licence. Works in Excel, Google Sheets (with minor layout adjustments) and Office 365.