Hi,
Ive created a spreadsheet for our Year 6 Teachers to type into to calculate outcomes for children (the green sections - the rest I want to password protects so they cant delete any formulas which is often an issue! ). The problem I have is that during the year they have to do a variety of tests at different points to make sure the children are on track to meet their target.
They use historical papers over a period of 6 years.
At the moment Ive added in a sheet with the raw scores for the 2019 paper but I want to also add in a sheet for 2018, 2017, 2016 etc etc which all have different amounts depending on the average across the country for that particular SATS Year.
I want to some how have a box above assessment point 1 for example that the teacher can type in the SATS Year exam paper they are using at that time and it will auto change the LOOKUP formula from Raw Scores 2019 to the year of the exam paper they are using.
Im sure its doable but beyond my excel knowledge.
Thank you for any help.
Ive created a spreadsheet for our Year 6 Teachers to type into to calculate outcomes for children (the green sections - the rest I want to password protects so they cant delete any formulas which is often an issue! ). The problem I have is that during the year they have to do a variety of tests at different points to make sure the children are on track to meet their target.
They use historical papers over a period of 6 years.
At the moment Ive added in a sheet with the raw scores for the 2019 paper but I want to also add in a sheet for 2018, 2017, 2016 etc etc which all have different amounts depending on the average across the country for that particular SATS Year.
I want to some how have a box above assessment point 1 for example that the teacher can type in the SATS Year exam paper they are using at that time and it will auto change the LOOKUP formula from Raw Scores 2019 to the year of the exam paper they are using.
Im sure its doable but beyond my excel knowledge.
Thank you for any help.