Published on March 18th, 2010 | by What2Learn0
Database Project – Superheroes & Supervillains
Looking for a fun and stimulating way to introduce databases to your ICT students? This project idea and associated resources is a great way to do just that. It draws on some elements of the National Strategy for ICT unit 7.5 (Data Handling) but builds on it with introducing a range of other skills.
Make sure that you and your students unlock the new W2L topic (share code 850747) to develop their knowledge and to reduce your own marking!
Download the resource pack for this unit, containing teacher presentation, student instructions and Access database… Resources.Zip.
Lesson One: Design your superhero or supervillain
Learning objectives: To learn how to use basic graphic editing techniques to crop an image, move elements and add text.
Main Task: In this lesson students generate the information they will share with other students and that will ultimately form the content of the database. They need to go to http://marvel.com/create_your_own_superhero and design their superhero or supervillain.
The class teacher will need to show how to use a graphics package to:
- Take a screenshot of the completed design on the Marvel website.
- Move and crop the image so that only required elements are seen. Use the ‘student sheet’ in the downloadable resource pack as an examplar of that they are aiming for.
- Add appropriate text to give the details of the character.
Assessment Task: In the final 15-20 minutes of the lesson, students should be given the opportunity to assess the set of activities within W2L for this unit. They will need to log in and enter share code 850747. They will then be able to see a link to the ‘Superheroes Project’ on their dashboard. They should attempt to complete the first three games within this topic.
Of course, make sure all students have entered your teacher share code so that you can track their progress through these activities using the automated marking and recording systems within W2L. For full guidance on this please see our teacher guide.
Lesson Two: Adding data to a database table
Learning objectives: To learn how add data to a table in an Access database. To understand what data validation is and to spot potential problems with data.
Main Task: In this lesson students will share their superhero/supervillain designs with their classmates and populate an Access database with the details of as many characters as possible.
Students need to have saved a copy of resource 3 (the Access database) in their area on the network. They also need to share their designs either electronically (e.g. through a VLE) or by printing out a copy and swapping them around the room.
Once students have got to grips with using the database, the teacher should talk about database structure (fields, records, etc) and highlight the validation that has been added to the gender and continent fields. Students should suggest reasons for the use of such validation techniques.
Assessment Task: In the final 15-20 minutes of the lesson, students should log in to W2L and attempt activity ‘7.5 (3) Checking data for errors’. This will develop and test their understanding of data validation and spotting potential problems in data sets.
Lesson Three: Using database forms
Learning objectives: To learn how add data to an Access database using a form. To develop knowledge of the key vocabulary concerning databases.
Main Task: In this lesson students will need to create a form using a wizard to provide them with a second way of adding data to a database. They will then need to add as much data as possible to the database – lots of data is needed for the next lesson.
Assessment Task: In the final 15-20 minutes of the lesson, students should log in to W2L and attempt activity ‘7.5 (4) Database terms’. This will develop and test their understanding of the key vocabulary concerning databases.
Lesson four coming in a few days time – just trying to tidy up the PowerPoint presentation that goes with it. Please check back.
- Database Task 1: Movie database (Functional Skills ICT)
- Spreadsheet Task: Barry’s burger van
- Database Task 2: Searching the movie database (Functional Skills ICT)