Introduction to spreadsheets |
In this unit pupils learn to enter numbers, labels and simple formulae into a spreadsheet and to use the data to calculate totals. Pupils will be introduced to spreadsheet software and will explore how changes in price and quantity can affect total cost. Pupils will apply what they have learnt in this unit when exploring mathematical and scientific models.
 5d Lite (ICT Lites are concise sheets showing the objectives, key skills and techniques to be taught, without the suggested teaching activities.)
Assessment: Pupil Self Review Statements
Teaching Activities l Resources
Teaching Activities
Textease Resources
www.learn-ict.org.uk
Using Spreadsheets in Mathematics
Spreadsheets in Science
Olympics data handling project - Olympic Project
The project took place during the 2000 Olympics fortnight. Details of past winners were taken from the database of track and field events, published by the Centre for Innovation in Mathematics Teaching at Exeter University. The data was entered into a spreadsheet, then graphed to show trends in performance over the years. Graphs were also used to predict this year's results.
 Suggested Cross Curricular Activities
Children could:
- plan a party, based on a given budget.
- create a self marking tables test
- calculate their weight on different planets
- work out the area and perimeter of different shapes
Textease 'Organising a Party' spreadsheet
Template for own Party
D&T
5D Biscuits Making
5E Earth, Sun and Moon D&T
5B Bread Making
Teaching Resources
Lesson plan with resources from Lancashire
lancsngfl.ac.uk
ICT Scheme of work from Greenwich
A complete set of resources linked to the QCA scheme of work with lesson plans, activities, downloadable resources and more.
lgfl.net/lgfl/leas/greenwich
Ideas and Examples of Spreadsheets from Devon
A good site for resources
www.devon.gov.uk/dcs/ict/models
|
