GCSE (9-1) Automated Progress Tracking and Analysis Spreadsheet

GCSE (9-1) Automated Progress Tracking and Analysis Spreadsheet

If, like I was, you are fed up with analysing data manually, this spreadsheet is for you. Originally created for my science department and then rolled out whole-school, this GCSE progress tracking spreadsheet will save you hours of analysing, putting relevant data right at your fingertips within seconds of assessments being graded. Use is easy - once the initial population of student data (lifted straight from an export from your school's data system) is done, the only data that needs to be entered is the grades for each assessment/homework/piece of work. You can use grades 1-9, but plus and minus subgrades are catered for too. Colour coded cells automatically show progress (above or below target grade) and the sheet does all the analysis for you, producing a data table detailing the following: - progress & attainment of Low, Middle and High Prior Attainment (KS2) - progress & attainment of girls vs boys - progress & attainment of SEND vs non-SEND, Pupil premium vs non Pupil Premium and EAL vs non EAL. - progress & attainment of individual classes or teachers - progress & attainment of the whole cohort For demonstrating progress and attainment over time, the graph tab provides four line graphs detailing the following: - percentage of work completed/submitted - percentage of students achieving grade 5 + - percentage of students meeting targets - percentage of students exceeding targets You can filter each column and the analysis table and graphs will automatically update. For example, perhaps you want to look at how pupil premium boys with low prior attainment are performing in your subject? Colleagues have used it with great success in department meetings, leadership meetings, appraisal meetings, performance management and even with inspectors. Only the white cells are editable, the others are locked and the sheets are password protected (PW is 2016) to avoid any accidental changes to the formulae.
kellylouise_mckaig
Year 7 - Full Year Resources for Bio, Chem, Phys 2017 Spec

Year 7 - Full Year Resources for Bio, Chem, Phys 2017 Spec

Full years worth of resources for Year 7 All lessons include: > a presentation with annotated notes for lesson plans > lesson objectives that are differentiated - exit ticket at the end of every lesson to check for levels > associated resources, ready to go > differentiated worksheets > homework, if needed - Cells, Tissues, Organs and Systems - Sexual Reproduction in Animals - Muscles and Bones - Ecosystems - Mixtures and Separation - Acids and Alkalis - The Particle Model - Atoms, Elements and Compounds - Energy - Current Electricity - Forces - Sound Presentations, worksheets, plenaries, full notes for detailed lesson plans on all presentations. AFL, ATD, ACTIVATE, DEMONSTRATE, ASSESSMENT INCLUDED
kellylouise_mckaig
KS3 Full Lessons Bundles - Year 7, 8, 9 Lessons and Resources

KS3 Full Lessons Bundles - Year 7, 8, 9 Lessons and Resources

Full years worth of resources for Years 7, 8 and 9 All lessons include: > a presentation with annotated notes for lesson plans > lesson objectives that are differentiated - exit ticket at the end of every lesson to check for levels > associated resources, ready to go > differentiated worksheets > homework, if needed Presentations, worksheets, plenaries, full notes for detailed lesson plans on all presentations. AFL, ATD, ACTIVATE, DEMONSTRATE, ASSESSMENT INCLUDED Fully Differentiated for G&T, EAL, SEN
kellylouise_mckaig
Year 8 - Full Year Resources for Bio, Chem, Phys 2017 Spec

Year 8 - Full Year Resources for Bio, Chem, Phys 2017 Spec

Full years worth of resources for Year 8 All lessons include: > a presentation with annotated notes for lesson plans > lesson objectives that are differentiated - exit ticket at the end of every lesson to check for levels > associated resources, ready to go > differentiated worksheets > homework, if needed - Food and Nutrition - Plants and their Reproduction - Breathing and Respiration - Unicellular Organism - Combustion - The Periodic Table - Metals and their Uses - Rocks - Fluids - Light - Energy Transfers - Earth and Space Presentations, worksheets, plenaries, full notes for detailed lesson plans on all presentations. AFL, ATD, ACTIVATE, DEMONSTRATE, ASSESSMENT INCLUDED
kellylouise_mckaig
Year 9 - Full Year Resources for Bio, Chem, Phys 2017 Spec

Year 9 - Full Year Resources for Bio, Chem, Phys 2017 Spec

Full years worth of resources for Year 9 All lessons include: > a presentation with annotated notes for lesson plans > lesson objectives that are differentiated - exit ticket at the end of every lesson to check for levels > associated resources, ready to go > differentiated worksheets > homework, if needed - Genetics and Evolution - Plant Growth - Biology Revision and Projects - Biology Transition to GCSE - Making Materials - Reactivity - Chemistry Revision and Projects - Chemistry Transition to GCSE - Forces and Motion - Force Fields and Electromagnets - Physics Revision and Projects - Physics Transition to GCSE Presentations, worksheets, plenaries, full notes for detailed lesson plans on all presentations. AFL, ATD, ACTIVATE, DEMONSTRATE, ASSESSMENT INCLUDED
kellylouise_mckaig
Full Unit 8E - Combustion

Full Unit 8E - Combustion

Full Unit for 8E Presentations, worksheets, plenaries, full notes for detailed lesson plans on all presentations. AFL, ATD, ACTIVATE, DEMONSTRATE, ASSESSMENT INCLUDED
kellylouise_mckaig
DNA Modelling Lesson

DNA Modelling Lesson

- Practical and Theory lesson on DNA - Lesson Presentation with key info for students to note - Slides are annotated with Lesson Plan Info - Practical worksheet (DNA Model with sweets) - Risk assessment inc. Ready to go! Full learning objectives included and revisited at the end to show progress.
kellylouise_mckaig