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.
Course Code | Lesson Date & Time | Assessment Date & Time |
---|---|---|
SB31 | Jul 4, 5, 6, 7, 8, 9 (Mon to Sat) 02:00 pm - 04:00 pm |
Jul 11 (Mon) 02:00 pm - 03:45 |
SB32 | Jul 11, 12, 13, 14, 15, 18 (Mon to Mon) 09:00 am - 11:00 am |
Jul 23 (Sat) 08:30 am - 10:15 |
SB33 | Jul 12, 14, 16, 19, 21, 23 (Tue, Thu and Sat) 04:00 pm - 06:00 pm |
Jul 26 (Tue) 04:00 pm - 05:45 |
SB34 | Jul 19, 20, 21, 22, 25, 26 (Tue to Tue) 11:00 am - 01:00 pm |
Jul 30 (Sat) 10:30 am - 12:15 |
SB35 | Jul 25, 27, 29, Aug 1, 3, 5 (Mon, Wed and Fri) 11:00 am - 01:00 pm |
Aug 06 (Sat) 10:30 am - 12:15 |
SB36 | Jul 26, 28, Aug 2, 4, 9, 11 (Tue and Thu) 11:00 am - 01:00 pm |
Aug 13 (Sat) 10:30 am - 12:15 |
SB37 | Aug 15, 16, 17, 18, 19, 20 (Mon to Sat) 02:00 pm - 04:00 pm |
Aug 23 (Tue) 02:00 pm - 03:45 |
SB38 | Aug 19, 20, 22, 23, 24, 25 (Fri to Thu) 02:00 pm - 04:00 pm |
Aug 27 (Sat) 01:30 pm - 03:15 |
Note that an Asterisk sign * is put besides the date to indidate the class will start and end 30 minutes eariler on that day.
Course Enrolment
Course Reservation
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
Others