9Uploads
6k+Views
3k+Downloads
All resources
Spreadsheets Sample lesson
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!
Spreadsheets Unit 1 - 6 complete lessons (KS2)
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
Year 3 Fractions
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
Year 3 Length and Perimeter
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
Year 3 Number and Place Value Set
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
Year 3 Statistics Set
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
Year 3 Money
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
Year 3 Multiplication and Division Set
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
Year 3 Number Addition & Subtraction Set
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