Database Task 1: Movie database (Functional Skills ICT)
This activity is part of a series of resources to help teachers delivering Edexcel Level 2 Functional Skills in ICT. All resources provided here are the strict copyright of What2Learn Ltd and must not be published elsewhere without our written consent.
In this lesson students will develop an understanding of the structure of databases, the creation of databases and adding data to databases.
Standards addressed in this activity
- 3.1 manage files, folders and other media storage to enable efficient information retrieval.
- 4.1 use appropriate search techniques to locate and select relevant information.
- 7.3 use appropriate field names and data types to organise information.
- 9.2 work accurately and check accuracy, using software facilities where appropriate.
- 10.1 evaluate the selection, use and effectiveness of ICT tools and facilities used to present information.
Click here to download the worksheet ‘Movies database 1’
Teachers – reduce your marking and develop your student’s knowledge and motivation with W2L games. There are two activities with the title ‘Formal Letters’. The best way to play these is for students to register for W2L accounts, log in and enter share code ‘832263’ to unlock the Functional Skills ICT topic. By logging in to play the activities scores will be recorded and attainment rewarded.
Suggested method of delivery:
To start this lesson the teacher should draw upon the experience students had of databases at KS3 – students should have created simple database structures and added data. Students will likely need to be reminded of how to start a database, set field names and set data types through demonstration (preferably by students).
Students should also be shown how to set data validation for a field (they need to set data validation for the ‘category’ field in the database they create. They should also set an appropriate data validation message.
As plenaries (and home learning) for all lessons, students should be encouraged to complete the interactive assessment tasks detailed above.