In this module, students use spreadsheet software to create a working spreadsheet with a clear purpose. Students work methodically through a design and development process, being able to test, correct and modify the spreadsheet as they progress. They are able to create a final spreadsheet which suits its purpose and is presented in an appropriate way for its audience. They begin to understand how to evaluate their work, and can assess how well their spreadsheet meets its objectives.
Students are able to design a spreadsheet to model a real-life scenario, e.g. researching which bicycle to purchase. They are able to talk or write about what the objective of the spreadsheet is, and how their spreadsheet will help them to meet that objective. They understand enough about the data and formulas they need to include in the spreadsheet to make a start on it.
Students enter data, text and formulas to create their spreadsheet. They are able to make modifications to their design to make it work.
Students are able to test their spreadsheet to check for errors and to see that formulas are correct. They make any corrections required to create an accurate spreadsheet with very few errors.
In addition to the pass criteria, depending on the purpose of the spreadsheet, students should be able to make the spreadsheet user friendly, e.g., good use of titles and formatting, OR presenting the results of the spreadsheet in a way that is easy to understand by using appropriate graphs or charts.
Students can evaluate how well their spreadsheet manages to suit its purpose. They are able to make suggestions for improvements, or give reasons for modifications they have already made.
At the end of this course, student will take the ICT Starters Assessment of On Track Stage 1 Module 3 : Spreadsheets for a Purpose.
Cambridge Certification is available at TWO stages.
Course Code | Lesson Date & Time | Assessment Date & Time |
---|---|---|
SC31 | Jul 3, 4, 5, 6, 7, 8 (Mon to Sat) 02:00 pm - 04:00 pm |
Jul 10 (Mon) 02:00 pm - 03:45 |
SC32 | Jul 10, 11, 12, 13, 14, 17 (Mon to Mon) 09:00 am - 11:00 am |
Jul 22 (Sat) 08:30 am - 10:15 |
SC33 | Jul 11, 13, 15, 18, 20, 22 (Tue, Thu and Sat) 04:00 pm - 06:00 pm |
Jul 25 (Tue) 04:00 pm - 05:45 |
SC34 | Jul 18, 19, 20, 21, 24, 25 (Tue to Tue) 11:00 am - 01:00 pm |
Jul 29 (Sat) 10:30 am - 12:15 |
SC35 | Jul 24, 26, 28, 31, Aug 2, 4 (Mon, Wed and Fri) 11:00 am - 01:00 pm |
Aug 05 (Sat) 10:30 am - 12:15 |
SC36 | Jul 25, 27, Aug 1, 3, 8, 10 (Tue and Thu) 11:00 am - 01:00 pm |
Aug 12 (Sat) 10:30 am - 12:15 |
SC37 | Aug 14, 15, 16, 17, 18, 19 (Mon to Sat) 02:00 pm - 04:00 pm |
Aug 22 (Tue) 02:00 pm - 03:45 |
SC38 | Aug 18, 19, 21, 22, 23, 24 (Fri to Thu) 02:00 pm - 04:00 pm |
Aug 26 (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