In this module, students use the knowledge and skills developed during Next Steps module ‘Exploring Databases’, and apply it to designing and implementing their own database. In doing this, they will need to consider how databases are used in the real world, and consider the features of a good database. The aim is to allow students to demonstrate that they can consider what features are needed to make a useful database. This includes consideration of how the database will be used, who can enter information, and who can access it.
Students identify the overall purpose of the database, and how it will be used.
Students create a simple database, identifying an appropriate (not necessarily exhaustive) list of fieldnames. Students are able to produce a simple data-entry form to collect their data, so that a small number of records can be added to their database.
Students should be aware that different types of data may benefit from being handled differently. They can show this either in data-entry forms or in how they set up the field types in their database. E.g. students choose an appropriate format (text, number, yes/no or drop-down list) for each field.
In addition to the pass criteria, students need to demonstrate that the database works as expected. Students should be able to describe to the teacher two or three tests to be run.
Students show a basic understanding of how different users might need to see different information from within their database. They should also understand fundamentals of data security, e.g. that only authorised people should be able to change data, and that passwords might be needed to allow different levels of access.
Students use data imported from other associated software packages, e.g. spreadsheet/word-processing packages.
At the end of this course, student will take the ICT Starters Assessment of On Track Stage 1 Module 4 : Databases for a Purpose.
Cambridge Certification is available at TWO stages.
Course Code | Lesson Date & Time | Assessment Date & Time |
---|---|---|
SC41 | Jul 4, 6, 11, 13, 18, 20 (Tue and Thu) 09:00 am - 11:00 am |
Jul 22 (Sat) 08:30 am - 10:15 |
SC42 | Jul 10, 12, 14, 17, 19, 21 (Mon, Wed and Fri) 11:00 am - 01:00 pm |
Jul 22 (Sat) 10:30 am - 12:15 |
SC43 | Jul 18, 19, 20, 21, 24, 25 (Tue to Tue) 02:00 pm - 04:00 pm |
Jul 29 (Sat) 01:30 pm - 03:15 |
SC44 | Jul 24, 26, 28, 31, Aug 2, 4 (Mon, Wed and Fri) 02:00 pm - 04:00 pm |
Aug 05 (Sat) 01:30 pm - 03:15 |
SC45 | 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 |
SC46 | Jul 26, 27, 28, 31, Aug 1, 2 (Wed to Wed) 11:00 am - 01:00 pm |
Aug 05 (Sat) 10:30 am - 12:15 |
SC47 | Aug 3, 4, 7, 8, 9, 10 (Thu to Thu) 09:00 am - 11:00 am |
Aug 12 (Sat) 08:30 am - 10:15 |
SC48 | Aug 14, 15, 16, 21, 22, 23 (Mon, Tue and Wed) 04:00 pm - 06:00 pm |
Aug 26 (Sat) 03:30 pm - 05: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