xlsx, 140.65 KB
xlsx, 140.65 KB
I am currently a visiting moderator for Edexcel and feel that this resource is essential for all teacher who wish to track pupils grades based on their estimated practical grades. This information will then allow you to easily identify what % each pupil needs to achieve in their summer exam in order to reach specific overall grades.
Please note that this is only an estimate as practical grades and grade boundaries are subject to change.
The excel document also allows you to track pupils homework on past paper questions.
This is also excellent for motivating students as it allows them to see how much they need to improve from mock exams/ past pares/ etc.
Hit rates based on pupils target grades can easily be identified as pupils overall grades for each topic are automatically generated.
I am relatively new to excel but this document took me approximately 5-6 hours of work, so will be a huge time saver for anyone who purchases this. PLEASE LEAVE A REVIEW if you purchase.
Below are the simple instructions to follow which may give a clearer picture of what the excel sheets can do for you:

Instructions
1. Copy and paste your own PE2MS results into the PE2MS tab. The main date you need is candidate number, gender, name, and practical total
2. This will then automatically add the to the pupils and figures to the Theory needs and HMK accumulation tabs

Theory needs' tab
3. You will then be able to see what your pupils need to achieve in the theory paper to attain for each grade
4. If you fill in a past paper grade into the column labelled 'theory %' you will then see their total grade which includes their practical scores

HMK accumulation' tab
5. If you wanted to track pupils past paper scores you could then use this tab over a series of different topics or past papers
6. If you want to see a running average of past papers that includes their practical grade, you will need to enter and auto sum in column AP and select the grades you want to average out.

Review

1

Something went wrong, please try again later.

pshepherd2

7 years ago
1

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.