An easy to use Excel Spreadsheet to analyse the maths test scores from the 2016 KS2 SATs though Question Level Analysis (QLA). Papers 1 (arithmetic), 2 and 3 (reasoning) are analysed. Will highlight students' areas of strength and weaknesses in key maths areas including number, calculation, problem solving, handling data, shape and measurement. Simply add the students' name and their score and the spreadsheet will update and produce graphs.
Get this resource as part of a bundle and save up to 71%
A bundle is a package of resources grouped together to teach a particular topic, or a series of lessons, in one place.
Bundle
Bundle - Key Stage 2 Mathematics Tests Question Level Analysis (QLA)
Includes: KS2 2024 Maths SATs QLA KS2 2023 Maths SATs QLA KS2 2022 Maths SATs QLA KS2 2019 Maths SATs QLA KS2 2018 Maths SATs QLA KS2 2017 Maths SATs QLA KS2 2016 Maths SATs QLA KS2 Sample Maths SATs QLA Easy to use Excel Spreadsheets to analyse the above maths test scores using Question Level Analysis (QLA). Papers 1 (arithmetic), 2 and 3 (reasoning) are analysed. Will highlight students’ areas of strength and weaknesses in key mathematical areas including: number, calculation, problem solving, handling data, and shape and measurement. Simply add the students’ name and their score and the spreadsheet will update and produce graphs based on their answers.
£7.00
Bundle
Bundle - 2016 Key Stage 2 SATs Question Level Analysis (QLA) - Maths, Reading and SPaG
Includes: KS2 2016 Maths SATs QLA KS2 2016 Spelling, Punctuation and Grammar SATs QLA KS2 2016 Reading SATs QLA Easy to use Excel Spreadsheets to analyse the above SATs test scores using Question Level Analysis (QLA). All papers are analysed and will highlight students' areas of strength and weaknesses in key maths (number, calculation, problem solving, handling data, shape and measurement), reading (giving/explaining meanings in context, retrieving and recording information, summarising main ideas, making inferences and justifying them, predicting from details stated and implied, identifying/explaining how content is related, and identifying/explaining how meaning is enhanced) and SPaG (grammatical terms/word classes; functions of sentences; combining words, phrases and clauses; verb forms, tenses and consistency; punctuation; vocabulary; standard English and formality; and spelling) areas. Simply add the students' name and their score and the spreadsheet will update and produce graphs based on their answers.
£5.00
Something went wrong, please try again later.
While this resource is fab, I want to unlock the grid so I can make some changes. What is the password please? Seems fair as it is a paid for resource.
Great resource has saved me a lot of time. Would you be will to provide an unlocked one?<br /> I have been able to add the formula for calculating the percentage of pupils not attempting the question 'n' marks however this is making it look untidy and I can not format any of the cells. <br /> Any help would be kindly appreciated. <br /> Thank you :)
Hi a good resource, although the totals column on the 70 child spreadsheet is not adding up, is there a way to unprotect the excel spreadsheet so that I can copy and paste the formulas?
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.
£3.00