Spreadsheets in Action

Year 6 Spreadsheet in Action Lessons
Main Aim Using spreadsheets for Investigation (Revised February 8th 2007)
This has been recovered from files deleted by the school hence the poor formatting
There is a pdf version of the original planning here
Learning Objective Lesson 1 Lesson Plan Investigating Shadow Height
Science QuestionHow does the distance from torch to object affect the size (height) of the shadow in cm?

ICT L.O.

To know how to create a scatter graph for use within a science experiment

 

This will be much more successful if the previous science lesson includes some introduction to this in the way of prediction writing, method writing or question raising.This lesson lends itself to pupils carrying out the experiment on the floor near the computers and inputting data directly onto a spreadsheet before graphing the results.

Average and High ability pupils should be able to create the spreadsheet themselves and graph the results using a scatter graph.

Low ability pupils can work from the spreadsheet template on the Year 6 Science Resources called shadow before creating their own graph.

I recommend demonstrating how to do the test (Make sure there is 20cm between the wall and the 4 unicube high object and use the larger torches under the computer tables)

First column should be distance of the torch to the object, start at 2cm and go up in 2cm increments. (don’t type in the cm after the number or Excel will think the cell is not a number cell)

Second column would be height of the shadow in cm (don’t type in the cm after the number or Excel will think the cell is not a number cell)

Highlight column headings and all the data in those two columns to make the graph. (don’t highlight any extra columns with no data in them or you will get an inaccurate graph)

Use a joined up xy scatter as this includes the data in the first column as the y axis.

ICT Skills Able & SEN Support Notes Resources
Using the chart wizardInputting data into a spreadsheet

 

SEN pupils use shadow (Learning Resource inside Year 6 Science Resources)  Pupils work in pairs to carry out the test but record the results individuallyYou may wish to analyse the data in more detail in further science lessons TorchesObjects

Sheets of card to show the shadows

Rulers

Learning Objective Lesson 2 Lesson Plan Investigating Shadow 2
Science QuestionHow does the angle of the torch (10° from flat increasing) affect the length of the shadow in cm?

ICT L.O.

To know how to create a scatter graph for use within a science experiment

 

This will be much more successful if the previous science lesson includes some introduction to this in the way of prediction writing, method writing or question raising.
This lesson lends itself to pupils carrying out the experiment on the floor near the computers and inputting data directly onto a spreadsheet before graphing the results.Average and High ability pupils should be able to create the spreadsheet themselves and graph the results using a scatter graph.

SEN ability pupils can work from the spreadsheet template on the Year 6 Science Resources called angle before creating their own graph.

First column should be angle of the torch to the object, start at flat and increase by 10° increments (don’t type in the degrees after the number or Excel will think the cell is not a number cell)

Second column would be length of the shadow in cm (don’t type in the cm after the number or Excel will think the cell is not a number cell)

Highlight column headings and all the data in those two columns to make the graph. (don’t highlight any extra columns with no data in them or you will get an inaccurate graph)

Use a joined up xy scatter as this includes the data in the first column as the y axis

ICT Skills Able & SEN Support Notes Resources
Using the chart wizardInputting data into a spreadsheet

 

SEN ability pupils can work from the spreadsheet template on the Year 6 Science Resources called angle before creating their own graph. angle Spreadsheet Template
Learning Objective Lesson 3 Lesson Plan Addition & Multiplication Pyramids
·         Maths L.O. Using an addition and multiplication pyramid to investigate the importance of the order operations are completed in·         ICT L.O. Creating addition and multiplication formula to investigate a maths problem Outside the suite order your class into three groups. Those who are in the top maths sets, Those in the middle and those in the bottom maths sets. If you don’t want to use this language then find out who teaches these sets before so you can refer to the set by its teachers name. Sit pupils in these three groups together so it is easy later to stop a group independently of the class.Create your own three cell addition pyramid. Remind pupils how to create the addition formula starting with an = sign.

Demonstrate how you can now use this to investigate the importance of the order numbers are inputted in at the base of the pyramid. Use 1,2&3

8
3 5
1 2 3

Now direct your top group to download pyramid1, middle pyramid2 and low pyramid3 from the learning resources Year 6 Spreadsheet Module. The instructions are on the sheet see bottom tabs. There are extension activities on the tabs too.

At the end ask pupils if they can explain what combinations make the highest and lowest totals?

ICT Skills Able & SEN Support Notes Resources
·         Addition Formula·         Multiplication Formula Able will be investigating multiplication pyramidsSEN will have almost complete prepared pyramids This idea was adapted fromImproving Numeracy Through Spreadsheets

By Bob Sykes

Brilliant Publications ISBN 1 897675 53 4

pyramid1 pyramid2 pyramid3Addition and multiplication video help files
Learning Objective Lesson 4 Lesson Plan Random Number Generators
·         Maths L.O. Using a spreadsheet to investigate totals created by throwing dice Create a three sided spinner from a pencil and card before the lesson as an aid to understanding.Download dice from the Y6 Spreadsheet resources area of the learning resources.

As a teacher model how to complete the three spinners investigation with the whole class

Now allow pupils to move onto investigating 3 dice and then 5 dice and then finally creating there own investigation.

(It is best to get pupils to look at the formulas and adjust the ones that are there other than write their own. If they fail to see what is happening you could look at the formula with those who need it. The number to the right of the asterix* sets the maximum number that can be thrown =INT(RAND()*6+1). The +1 at the end stops it throwing a zero.)

In conclusion what have the class discovered?

ICT Skills Able & SEN Support Notes Resources
·         Filling in a spreadsheet·         Creating a graph

 

Able pupils will move onto creating there own investigation and looking at the formula involved. SEN pupils may not move any further than 3 dice. This idea was adapted fromImproving Numeracy Through Spreadsheets

By Bob Sykes

Brilliant Publications ISBN 1 897675 53 4

Download dice from the Y6 Spreadsheet resources area of the learning resources. Pupils bring in there general workbooks to keep tally charts
Learning Objective Lesson 5 Lesson Plan
Science QuestionHow does the mass of an object (in g) affect how much force is needed (in n) to move it?

ICT L.O.

To know how to create a scatter graph for use within a science experiment

 

See Mr Dale’s planning for detailed science objectives.This will be much more successful if the previous science lesson includes some introduction to this in the way of prediction writing, method writing or question raising.
This lesson lends itself to pupils carrying out the experiment on the floor near the computers and inputting data directly onto a spreadsheet before graphing the results.

Average and High ability pupils should be able to create the spreadsheet themselves and graph the results using a scatter graph.

SEN ability pupils can work from the spreadsheet template on the Year 6 Science Resources called force before creating their own graph.

First column should be weight in g, 100g increasing by 100g increments to 1kg (don’t type in the g or kg after the number or Excel will think the cell is not a number cell)

Second column would be force needed to move it in n (don’t type in the n after the number or Excel will think the cell is not a number cell)

To extend this you could have separate columns for different surfaces

  • Carpet
  • Table
  • Concrete

Highlight column headings and all the data in those two or more columns to make the graph. (don’t highlight any extra columns with no data in them or you will get an inaccurate graph)

Use a joined up xy scatter as this includes the data in the first column as the y axis

ICT Skills Able & SEN Support Notes Resources
Using the chart wizardInputting data into a spreadsheet

 

SEN pupils use force (Learning Resource inside Year 6 Science Resources)
A piece of card with the angles marked on would help
Pupils work in pairs to carry out the test but record the results individuallyYou may wish to analyse the data in more detail in further science lessons Newton metersBoards with hooks

Weights

 

Learning Objective Lesson 6 Lesson PlanAssessment Lesson
·         To know how to create a graph to show the affects of air resistance on different size objects. ·         How does the size of a parachute (in cm2) affect how long it takes to fall to the ground (in seconds)? or·         How does the area of a spinner (in cm2) affect how long it takes to fall to the ground (in seconds)?

Go over the importance of only changing one variable (size of parachute canopy or area of spinner rotor blade) Also go over the variables that need to be kept the same to ensure that the test is fair (height of drop, method of drop etc)

I would create a standard parachute or spinner template that can be cut out for a number of different sizes with the area in cm2 recorded on the spinners/parachutes.

Once you are clear that pupils understand what to do then let them get on with the lesson whilst you observe and record for assessment purposes. See report statement below.

ICT Skills Able & SEN Support Notes Resources
·         Using a spreadsheet within science·         Creating a graph from real data As you are observing pupils to determine levels don’t provide too much help unless you note this and reduce the level accordingly Parachutes must have central holes cut in the middle or they will go all over the place (to do with aerodynamics) I would use squared paper with the spinners and attach a paper clip to the bottom. StopwatchesPaper for parachutes

Scissors, small paperclips, string for parachutes. Sellotape for parachutes

 

 

Report Statement Can use a spreadsheet within science and maths to investigate real problems
Below Pupils need help producing their graph either from the teacher or other pupils
Within Pupils can set up their own graph correctly choosing the right amount of columns and rows. They can choose the correct graph type. Their axis are labelled correctly.
High Can work independently recording data accurately using a relevant graph type. The graph will be easy to interpret and pupils should be able to use the graph to answer the key question. They would be able to spot anomalies on the graph if there are any and explain why they have occurred.