Database Task 2: Searching the 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 their understanding of how to search a database and produce reports of the results.
Standards addressed in this activity
- 3.1 manage files, folders and other media storage to enable efficient information retrieval.
- 7.4 analyse and draw conclusions from a data set by searching, sorting and editing data.
- 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 2’
Click here to download the presentation ‘Search criteria’
|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.Learn more.|
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, added data and carried out simple searches. Students will likely need to be reminded of how to create queries and reports through demonstration (preferably by students).
Students should also be shown the presentation on sample search criteria to help them with forming accurate queries before beginning the tasks on the worksheet.
As plenaries (and home learning) for all lessons, students should be encouraged to complete the interactive assessment tasks detailed above.