Spreadsheets come alive
In this lesson sequence use the ‘Odds and evens’ problem as a springboard. Students construct interactive spreadsheets designed to address particular needs. This lesson also demonstrates an approach to programming known as rapid application development (RAD).
Additional details
| Year band(s) | 9-10 |
|---|---|
| Content type | Lesson ideas |
| Format | Web page |
| Core and overarching concepts | Implementation (programming) |
| Australian Curriculum Digital Technologies code(s) |
AC9TDI10P02
Analyse and visualise data interactively using a range of software, including spreadsheets and databases, to draw conclusions and make predictions by identifying trends and outliers
AC9TDI10P03
Model and query entities and their relationships using structured data |
| Keywords | Spreadsheets, Data manipulation, Odd and evens |
| Integrated, cross-curriculum, special needs | Mathematics |
| Organisation | ESA |
| Copyright | Creative Commons Attribution 4.0, unless otherwise indicated. |
Related resources
-
Behaving with real class - Using a text-based language
This lesson sequence offers an approaches to teaching object-oriented principles using text-based programming.
-
Behaving with real class – Using a visual language
This lesson sequence offers an approaches to teaching object-oriented principles using visual programming.
-
Breaking up can be good
This lesson sequence provides an introduction to the skill of decomposition by having students develop discrete modules which together serve a single need: a maths teacher asks for a program that can be used to demonstrate aspects of maths.
-
Fibonacci served three ways
In this lesson sequence students learn to code separate modules that perform discrete functions but collectively meet the needs of the solution.
-
Getting warmer
This lesson sequence intentionally uses a visual based programming tool to introduce designing and validating algorithms.