A sample lesson for spreadsheet unit of work. Lesson 1 of 6. The whole set is available here: https://www.tes.com/teaching-resource/spreadsheets-unit-1-6-complete-lessons-ks2-12472678 Any feedback greatly appreciated!

18 mixed resources allowing teacher’s to choose the most appropriate resources for their pupil’s needs and abilities. Read and Draw Pictograms A-C Read and Draw Bar Charts A-F Read Tables A-C Bar Chart and Pictogram Problem Solving A-F

20 mixed resources allowing teacher’s to choose the most appropriate resources for their pupil’s needs and abilities. Working With Pounds and Pence A - E Add Money A - D Subtract Money A - C Giving Change A - C Problem Solving With Money A - E

44 mixed resources allowing teacher’s to choose the most appropriate resources for their pupil’s needs and abilities. Following the small steps outlined in the White Rose Curriculum, this set includes practice sheets for: Representing numbers up to 1,000 Reading and drawing place value charts Reading and using place value counters Reading and writing numbers up to 1,000 Number lines to 1,000 Finding 1, 10 and 100 more or less Comparing and ordering objects and numbers Problem solving

25 mixed resources allowing teacher’s to choose the most appropriate resources for their pupil’s needs and abilities. Linked to the small steps outlined in the White Rose Curriculum: Convert between millimetres and centimetres Measure lengths Convert between metres and centimetres Compare lengths Add lengths Subtract lengths Measure perimeter Calculate perimeter

38 mixed resources allowing teacher’s to choose the most appropriate resources for their pupil’s needs and abilities. Following the small steps outlined in the White Rose Curriculum, this set includes practice sheets for: Unit and Non-Unit Fractions Making The Whole Tenths Fractions On Number Lines Fractions Of Amounts Equivalent Fractions Comparing and ordering Fractions Adding and Subtracting Fractions

50 mixed resources allowing teacher’s to choose the most appropriate resources for their pupil’s needs and abilities. Equal groups, Arrays and Repeated Addition Sort and Make Equal Groups A & B Use equal groups to male repeated addition and multiplication sentences Use Arrays To Make Multiplication and Division Sentences Arrays To Show Multiplication and Division Number Sentences Multiplying and Dividing By 3 Multiply By 3 A & B Divide By 3 A & B The 3 Times Table A & B Multiplying and Dividing By 4 Multiply By 4 A & B Divide By 4 A & B The 4 Times Table A & B Multiplying and Dividing By 8 Multiply By 8 A & B Divide By 8 A & B The 8 Times Table A & B Comparing Statements and Related Calculations Comparing Number Sentences A & B Related Calculations A & B Multiplying 2-Digits By 1-Digit Multiply 2-digits by 1-digit A - E Dividing 2-Digits By 1-Digit Use Place Value Grids To Divide 2-Digits By 1-Digit (no exchange) Use Part-Whole Models to Divide 2-Digits By 1-Digit (no exchange) Divide 2-Digit numbers By 1-Digit numbers with exchange A & B Division With A Remainder A - C Scaling and Combinations Use Multiplication and Division To Scale A & B Combinations A & B Mixed Multiplication and Division Multiplication and Division Problem Solving A - G

70 resources to cover the 5 week teaching period suggested by the White Rose Maths group, this set allows teacher’s to choose the most appropriate resources for their pupil’s needs and abilities. While a great deal of emphasis is placed on moving pupils towards using column methods for addition and subtraction through associating them with other representations, this set also encourages pupils to make their own choice of methods or representations and make a choice of the most suitable for a calculation. Adding and Subtracting Multiples of 1, 10 and 100 Add Multiples of 1, 10 and 100 Subtract Multiples of 1, 10 and 100 Adding Up To 2-Digit Numbers Add 2-Digit and 1-Digit Numbers A & B Add 2-Digit and 1-Digit Numbers With Exchange A & B Add Two 2-Digit Numbers Add Two 2-Digit Numbers With Exchange Column Method To Add 2-Digit and 1-Digit Numbers Addition: Reasoning and Problem Solving With Up To 2-Digit Numbers Subtracting Up To 2-Digit Numbers Subtract a 1-Digit Number From a 2-Digit Number A & B Subtract a 1-Digit Number From a 2-Digit Number With Exchange A & B Subtract Two 2-Digit Numbers A & B Subtract Two 2-Digit Numbers With Exchange A & B Column Method To Subtract 2-Digit and 1-Digit Numbers Subtraction: Reasoning and Problem Solving With Up To 2-Digit Numbers Adding Up To 3-Digit Numbers Add 3-Digit and 1-Digit Numbers A & B Add 3-Digit and 1-Digit Numbers With Exchange A & B Column Method To Add 3-Digit and 1-Digit Numbers Add 3-Digit and 2-Digit Numbers A & B Add 3-Digit and 2-Digit Numbers With Exchange A & B Column Method To Add 3-Digit and 2-Digit Numbers Add Two 3-Digit Numbers A & B Add Two 3-Digit Numbers With Exchange A & B Column Method To Add Two 3-Digit Numbers Column Method To Add Two 3-Digit Numbers with Exchanging Twice Column Method To Add Up To 3-Digit Numbers Column Method To Add Up To 3-Digit Numbers with Exchanging Twice Addition: Reasoning and Problem Solving With Up To 3-Digit Numbers A & B Subtracting Up To 3-Digit Numbers Subtract a 1-Digit Number From a 3-Digit Number A & B Subtract a 1-Digit Number From a 3-Digit Number With Exchange A & B Column Method To Subtract a 1-Digit Number From a 3-Digit Number Subtract a 2-Digit Number From a 3-Digit Number A & B Subtract a 2-Digit Number From a 3-Digit Number With Exchange A & B Column Method To Subtract a 2-Digit Number From a 3-Digit Number Subtract Two 3-Digit Numbers A & B Subtract Two 3-Digit Numbers With Exchange A & B Column Method To Subtract Two 3-Digit Numbers Column Method To Subtract Two 3-Digit Numbers with Exchanging Twice Column Method To Subtract Up To 3-Digit Numbers Column Method To Subtract Up To 3-Digit Numbers with Exchanging Twice Subtraction: Reasoning and Problem Solving With Up To 3-Digit Numbers A & B Mixed Addition and Subtraction Checking Answers Column Method Addition and Subtraction A & B Addition and Subtraction Word Problems A - E

UNIT OF 6 COMPLETE LESSONS. Suitable for year 4 or 5 as an introduction to spreadsheets. Uses google sheets as the example spreadsheet program but all presentations are editable and can be amended for excel, libreoffice or any spreadsheet program. Includes presentations, recording sheets, worksheets, learning journal front cover and pages for each lesson, and vocabulary recording sheets. Teachers notes with resource lists and lesson outlines. Lesson 1: Use a spreadsheet program. Lesson 2: Input data into a spreadsheet. Lesson 3: Keep a spreadsheet organised. Lesson 4: Perform calculations on a spreadsheet. Lesson 5: Use a spreadsheet to solve word problems Lesson 6: Create a chart in a spreadsheet Any feedback greatly appreciated. Free sample lesson is available to give you a better idea of what the lessons look like https://www.tes.com/teaching-resource/spreadsheets-sample-lesson-12472707