Data Analysis tools designed to help teachers with their tracking and evidence.
Takes the difficulties out of data analysis and helps teachers effectively show performance and save their time.
I have worked analysing data in schools for 10 years and have worked with an experienced HOD to design resources for teachers which can save them time and give them the information they need quickly and effectively.
Let's face it - teachers have enough to be doing!
Data Analysis tools designed to help teachers with their tracking and evidence.
Takes the difficulties out of data analysis and helps teachers effectively show performance and save their time.
I have worked analysing data in schools for 10 years and have worked with an experienced HOD to design resources for teachers which can save them time and give them the information they need quickly and effectively.
Let's face it - teachers have enough to be doing!
This spreadsheet is designed for any class teacher who uses SIMS software.
It is designed so that the class teacher can export out any of their class marksheets from SIMS and copy and paste the student data into it. Instructions are also included.
The dashboard will then produce number breakdowns & percentage graphs for:
Gender
FSM
EAL
SEN
PP
Video preview. Designed for 2 and 3 unit GCSE exam subjects with 9-1 Grades. Current Tracking spreadsheets are available to purchase from the links below (the grade boundaries within each one are subject and spec specific). Please check back, more subjects and exam boards coming soon.
Biology Foundation AQA https://www.tes.com/teaching-resource/gcse-9-1-aqa-biology-foundation-mock-exam-tracking-spreadsheet-12050668
Biology Higher AQA https://www.tes.com/teaching-resource/gcse-9-1-aqa-biology-higher-mock-exam-tracking-spreadsheet-12050687
Chemistry Foundation AQA https://www.tes.com/teaching-resource/gcse-9-1-aqa-chemistry-foundation-mock-exam-tracking-spreadsheet-12050693
Chemistry Higher AQA https://www.tes.com/teaching-resource/gcse-9-1-aqa-chemistry-higher-mock-exam-tracking-spreadsheet-12050695
Citizenship Studies AQA https://www.tes.com/teaching-resource/gcse-9-1-aqa-citizenship-studies-mock-exam-tracking-spreadsheet-12050391
Computer Science AQA https://www.tes.com/teaching-resource/gcse-9-1-aqa-computer-science-mock-exam-tracking-spreadsheet-12050561
Computer Science OCR https://www.tes.com/teaching-resource/gcse-9-1-ocr-computer-science-mock-exam-tracking-spreadsheet-12051304
English Language AQA https://www.tes.com/teaching-resource/gcse-9-1-aqa-english-language-mock-exam-tracking-spreadsheet-2018-12049057
English Language OCR https://www.tes.com/teaching-resource/gcse-9-1-ocr-english-language-exam-tracking-spreadsheet-12050956
English Literature AQA https://www.tes.com/teaching-resource/gcse-9-1-aqa-english-literature-mock-exam-tracking-spreadsheet-12050431
English Literature OCR https://www.tes.com/teaching-resource/gcse-9-1-ocr-english-literature-mock-exam-tracking-spreadsheet-12050957
English Language & Literature AQA Bundle https://www.tes.com/teaching-resource/gcse-9-1-aqa-english-language-and-literature-mock-exam-tracking-spreadsheet-12050435
English Language & Literature OCR Bundle https://www.tes.com/teaching-resource/gcse-9-1-ocr-english-language-and-literature-mock-exam-tracking-spreadsheet-12050966
Food Preparation & Nutrition AQA https://www.tes.com/teaching-resource/gcse-9-1-aqa-food-preparation-and-nutrition-mock-exam-tracking-spreadsheet-12050563
Physics Foundation AQA https://www.tes.com/teaching-resource/gcse-9-1-aqa-physics-foundation-mock-exam-tracking-spreadsheet-12050935
Physics Higher AQA https://www.tes.com/teaching-resource/gcse-9-1-aqa-physics-higher-mock-exam-tracking-spreadsheet-12050942
By simply entering your unit marks the spreadsheet will automatically calculate:
Unit 1 Grade
Unit 2 Grade
Unit 3 Grade (if applicable)
Overall Marks
Overall Grade
Distance from Target Grade (if target grade is entered)
Overall Grade and student name will RAG automatically compared to target grade
Grade distribution graph for each unit and overall
Average grade for each unit and overall
% of students on or above their target grades
Average mark for each unit and overall
Overall class performance against targets figure
