|
Scheme of Work
Lesson 2 - I can copy cells in a
spreadsheet
Show the class how to copy formulae from one cell to
another. Ask the children to create a set of multiplication
tables such as:
The spreadsheet should extend number B to 12. Ask the
children to investigate changing number A.
Cross Curricular Links - Maths
Times tables
Learning Outcomes - copy formulae to create tables of
results
Lesson 3 - I can use two spreadsheet applications and
make decisions about which one best suits my purpose
Show children how to use Google spreadsheets. Highlight
differences in apps and how to save work. Stress how Google
updates automatically every 30 seconds vs quickest save
without manually doing it in excel is 3mins. Show how cells
become highlighted when they are being updated.
Children to use Excel workbook in shared area to calculate
their weight on other planets and ALSO input whether they
were born in darkness or daylight into Google spreadsheets.
Can children see different benefits of each application?
How could we use each successfully?
Cross Curricular Links -
Science, Earth and Beyond, Maths, Data Handling
Key Vocabulary - Application, File sharing, Fit for
purpose, Benefits, disadvantages
Learning Outcomes - See strengths and weaknesses of
two comparable applications
Lesson 4 - I can use a spreadsheet to draw a graph
Show the class how to create graphs using the spreadsheet.
Ask the children to investigate graphs such as y = x2, y =
2x, y = x + 3.
Cross Curricular Links - Maths
Data handling
Key Vocabulary - X axis, Y axis, Key, algebra
Learning Outcomes - create graphs
|
