In this module, students are introduced to spreadsheet software. They learn to enter data, text and formulas into cells. They can copy data, replicate formulas and understand that spreadsheets carry out calculations automatically. They can use spreadsheet software to create graphs or charts. They begin to understand the power of spreadsheets for modelling situations, and how data and formulas can be modified to test predictions, or to work out what happens when something is changed.
Students should be able to enter text and data into spreadsheet software to create a working spreadsheet.
Students should be able to enter simple formulas like =A1+A2. They should be able to use the SUM function to total a range of cells. (Note: This should involve creating the SUM function and not just using AutoSum from the toolbar.) They should be able to copy a formula to another location. The assessment may prescribe which formulas to put where.
Students can select a given range of data and use it to create an appropriate graph. Students give the graph a meaningful title.
In addition to the pass criteria, students can manage to change the data as instructed and make appropriate checks to make sure that their spreadsheet still works.
Students need to demonstrate an understanding of the effect of changing data and should be able to answer questions to modelled scenarios, such as: ‘If the cost goes up by … would there still be a profit?’.
At the end of this course, student will take the ICT Starters Assessment of Next Steps Stage 1 Module 3 : Exploring Spreadsheets.
Cambridge Certification is available at TWO stages.
School Fee Collection Policy
Class Arrangement for Typhoon and Rainstorm
|When signal(s)* is/are removed||Arrangement of Classes|
|Before 6:30 am||All classes will be held as scheduled|
|Before 8:30 am||Classes starting from 10:30am will be held as scheduled|
|Before 10:30 am||Classes starting from 12:30pm will be held as scheduled|
|Before 12:30 pm||Classes starting from 2:30pm will be held as scheduled|
|Before 2:30 pm||Classes starting from 4:30pm will be held as scheduled|
|After 2:30 pm||All classes will be cancelled|
*Typhoon Signal No. 8 or above OR "Black" Rainstorm Warning Signal
Make-Up Class or Assessment Policy