An easy to use Excel Spreadsheet to analyse the maths test scores from the 2024 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, and 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 72%
A bundle is a package of resources grouped together to teach a particular topic, or a series of lessons, in one place.
Bundle
Comprehensive Key Stage 2 Question Level Analysis (QLA) Bundle - Maths, SPaG and Reading
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 2024 Spelling, Punctuation and Grammar SATs QLA KS2 2023 Spelling, Punctuation and Grammar SATs QLA KS2 2022 Spelling, Punctuation and Grammar SATs QLA KS2 2019 Spelling, Punctuation and Grammar SATs QLA KS2 2018 Spelling, Punctuation and Grammar SATs QLA KS2 2017 Spelling, Punctuation and Grammar SATs QLA KS2 2024 Reading SATs QLA KS2 2023 Reading SATs QLA KS2 2022 Reading SATs QLA KS2 2019 Reading SATs QLA KS2 2018 Reading SATs QLA KS2 2017 Reading SATs QLA Easy to use Excel Spreadsheets to analyse the above test scores using Question Level Analysis (QLA). Will highlight students’ areas of strength and weaknesses in key maths (number, calculation, problem solving, handling data, shape and measurement), reading (giving/explaining meanings of words in context, retrieving and recording information/identifying key details from fiction and non-fiction, summarising main ideas from one or more paragraphs, making inferences from the text/explaining and justifying inferences with evidence from the text, identifying/explaining how information/narrative content is related and contributes to meaning as a whole, identifying/explaining how meaning is enhanced through choice of words and phrases, and making comparisons within the text) 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.
£15.00
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
NEW Bundle - 2024 Key Stage 2 SATs Question Level Analysis (QLA) - Maths, Reading and SpaG
Includes: KS2 2024 Maths SATs QLA KS2 2024 Spelling, Punctuation and Grammar SATs QLA KS2 2024 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 of words in context, retrieving and recording information/identifying key details from fiction and non-fiction, summarising main ideas from one or more paragraphs, making inferences from the text/explaining and justifying inferences with evidence from the text, and making comparisons within the text) 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.
Great work - could the content domain references be added so we can identify issues with more specificity? Also, could the graphs be made to pull the names of students who have the correct answers through when hovered over?
Hi, just purchased and downloaded. Have begun using but on Paper 1, Q33 should be 1 mark and Q36 should be 2? I am unable to change without a password. Any help please?
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