In this unit children learn to use a spreadsheet to explore a mathematical model.
Children will be taught to use formulae in spreadsheets to answer 'what if ...?' questions. They will explore how changes in a spreadsheet affect results and identify simple rules.
Children will apply what they have learnt in this unit when exploring mathematical and scientific models.
Where this unit fits in
This unit builds on Unit 5D 'Introduction to spreadsheets'.
This unit assumes that children:
- can calculate total costs
- can recognise number patterns
- know the formula for the area of a rectangle
Technical vocabulary
- spreadsheet
- cell
- formula
- calculate
- data
- model
Resources
- spreadsheet software
- a variety of receipts
Images
Google Images http://www.google.co.uk/imghp
Flicker http://www.flickr.com/
Yahoo http://uk.images.search.yahoo.com/
AlterVista http://www.altavista.com/image/default
Bing Images http://www.bing.com/images
Shutterstock Images http://www.shutterstock.com/?gclid=CMGR2q_7waQCFQ_-2AoddR8oEw
Clip Art
Free Clipart
Classroom Clipart http://classroomclipart.com/
Animation Factory http://www.animationfactory.com/en/
Animation
Heather's Animations http://www.heathersanimations.com/ (One of my Favourites)
Sparklee Text Maker http://www.sparklee.com/
Text Maker http://textspace.net/
Cool Text Maker http://cooltext.com/
Animation Factory http://www.heathersanimations.com/
Best Animations http://bestanimations.com/
Sounds
Free Wavs http://www.thefreesite.com/Free_Sounds/Free_WAVs/
Simply the best Sounds http://simplythebest.net/sounds/WAV/sound_effects_WAV/index.html
Freebies List http://www.freebielist.com/reviews/category/free-midi-and-wav-sounds
Video
Google Videos http://video.google.co.uk/
UTube http://www.youtube.com/
Meta Cafe http://www.metacafe.com/
Keep Vid http://keepvid.com/
An excellent site to get ONLY the video you want to put on a secure sites to inspire learning. Helps get over blocking of Utube etc in schools. Just remember to check any content you chose all the way through before posting.
Software suitable to use: (CTS has those highlighted in orange)
Microsoft Office Excel (Microsoft)
2Calculate (2Simple) www.2simple.com/2calculate/
2ICTAssess (2Simple) http://www.2simple.com/2AssessICT
Number Magic (RM)
Numberbox(BlackCat)
The Model Shop (Sherston)
Grananda Spreadsheets (Granada)
The Wizards Apprentice (Sherston)
Online Resources-for Teachers:
SPREADSEETS & DATABASES(primary resources)
http://www.primaryresources.co.uk/ict/ict2.htm
SPREADSHEET LESSONS (ngfl)
http://www.ngfl-cymru.org.uk/vtc/going_going/eng/Introduction/default.htm
Online Resources- for Pupils:
Google Images http://www.google.co.uk/imghp
Flicker http://www.flickr.com/
Yahoo http://uk.images.search.yahoo.com/
AlterVista http://www.altavista.com/image/default
Bing Images http://www.bing.com/images
Shutterstock Images http://www.shutterstock.com/?gclid=CMGR2q_7waQCFQ_-2AoddR8oEw
Clip Art
Free Clipart
Classroom Clipart http://classroomclipart.com/
Animation Factory http://www.animationfactory.com/en/
Animation
Heather's Animations http://www.heathersanimations.com/ (One of my Favourites)
Sparklee Text Maker http://www.sparklee.com/
Text Maker http://textspace.net/
Cool Text Maker http://cooltext.com/
Animation Factory http://www.heathersanimations.com/
Best Animations http://bestanimations.com/
Sounds
Free Wavs http://www.thefreesite.com/Free_Sounds/Free_WAVs/
Simply the best Sounds http://simplythebest.net/sounds/WAV/sound_effects_WAV/index.html
Freebies List http://www.freebielist.com/reviews/category/free-midi-and-wav-sounds
Video
Google Videos http://video.google.co.uk/
UTube http://www.youtube.com/
Meta Cafe http://www.metacafe.com/
Keep Vid http://keepvid.com/
An excellent site to get ONLY the video you want to put on a secure sites to inspire learning. Helps get over blocking of Utube etc in schools. Just remember to check any content you chose all the way through before posting.
Software suitable to use: (CTS has those highlighted in orange)
Microsoft Office Excel (Microsoft)
2Calculate (2Simple) www.2simple.com/2calculate/
2ICTAssess (2Simple) http://www.2simple.com/2AssessICT
Number Magic (RM)
Numberbox(BlackCat)
The Model Shop (Sherston)
Grananda Spreadsheets (Granada)
The Wizards Apprentice (Sherston)
Online Resources-for Teachers:
SPREADSEETS & DATABASES(primary resources)
http://www.primaryresources.co.uk/ict/ict2.htm
SPREADSHEET LESSONS (ngfl)
http://www.ngfl-cymru.org.uk/vtc/going_going/eng/Introduction/default.htm
Online Resources- for Pupils:
Objectives
key idea: that mathematical models can be explored using a spreadsheet
technique: to identify formulae and enter them into a spreadsheet
technique: to copy cells
technique: to use a spreadsheet to draw a graph
most children will: explore the effects of changing data in a spreadsheet
some children will not have made so much progress and will: use a spreadsheet to calculate totals
some children will have progressed further and will: explore the effects of changing data in a spreadsheet; make predictions and use a spreadsheet to test them
Assessment
2Simple 2Assess
2ICTAssess (2Simple) http://www.2simple.com/2AssessICT
Activities
cm and inches,
Miles and Kilometers,
Area Formula,
Discount formulas,
Spreadsheet Graph.
key idea: that mathematical models can be explored using a spreadsheet
technique: to identify formulae and enter them into a spreadsheet
technique: to copy cells
technique: to use a spreadsheet to draw a graph
- to change the data and formulae in a spreadsheet to answer 'what if ...?' questions and check predictions
most children will: explore the effects of changing data in a spreadsheet
some children will not have made so much progress and will: use a spreadsheet to calculate totals
some children will have progressed further and will: explore the effects of changing data in a spreadsheet; make predictions and use a spreadsheet to test them
Assessment
2Simple 2Assess
2ICTAssess (2Simple) http://www.2simple.com/2AssessICT
Activities
cm and inches,
Miles and Kilometers,
Area Formula,
Discount formulas,
Spreadsheet Graph.
