DATABASE PROJECT

 
         
 
TASK:
Design & create a database to hold records of ghost sightings in the local area.
PURPOSE:
To record and locate specific information about ghost sightings.
AUDIENCE:
Scientists and other people interested in ghost sightings.
 
         
         
         
   
LEARNING OBJECTIVES FOR EACH PART OF THE PROJECT
   
         
   
The learning objectives show you what you need to do or know at each level.
You should try to complete the work that will at least allow you to complete your target level.
You need to provide evidence in the form of annotated screenshots & explanations to show your achievements.
   
         
         
         
   
TASK 1: Finding Information about Ghosts
 
Level 3
(a) Find out some information about ghosts on the Internet.
(b) Present the information you have found.

Level 4
(a) Find out detailed information about ghosts on the Internet.
(b) Present the information you have found in an organised way.
(c) Quote the sources of all information you have found.

Level 5
(a) Use advanced searches to find information about ghosts on the Internet.
(b) Explain how you would check the information you have found is
     accurate and reliable.
   
         
   
   
         
         
         
   
TASK 2: Designing a Ghost Sightings Database
 
Level 3
(a) Design a database.
Level 4
(a) Design a database using suitable field names.
Level 5
(a) Use a range of data types in the database design.
(b) Explain why the data types are suitable.
   
         
         
         
   
TASK 3: Creating a Ghost Sightings Database Structure
   
         
   
Level 4
(a) Create a database using Access.
(b) Test the database by adding some 'test' records to it.
Level 5
(a) Select & use a range of suitable data types in the creation of the database.
(b) Improve the database at regular intervals.
(c) Explain how the database is suitable for its purpose and audience.
   
         
   
   
         
         
         
   
TASK 4: Adding Data to a Ghost Sightings Database Table
   
         
   
Level 4
(a) Add data to the database.
(b) Delete data from the database.
(c) Edit (change) data in the database.
(d) Explain the reasons why data may need to be
added, deleted, and edited.
(e) Explain the reasons why data must be entered into a database correctly.
Level 5
(a) Give detailed examples of issues with entry of incorrect data in real life.
   
         
   
   
         
         
         
   
TASK 5: Sorting, Finding, & Filtering a Ghost Sightings Database
   
         
   
Level 4
(a) Sort a database using the sort tool.
(b) Use the 'Find' tool to locate a specific data item.
(c) Use a single search filter to find information.
Level 5
(a) Use multiple filters to find more specific information.
   
         
   
   
         
         
         
    TASK 6: Using Queries to Search a Ghost Database for Information    
         
   
Level 4
(a) Use a single search criteria query to find information.
Level 5
(a) Use a multiple search criteria query to find more
     specific information.
Level 6
(a) Use complex and advanced searches within a query
     to find information which clearly suits a particular
     purpose and audience.
   
         
         
         
    TASK 7: Creating Reports from Ghost Sightings Database Searches    
         
   
Level 4
(a) Present the information found within a database query search as a report.
Level 5
(a) Present the information found within database searches as a variety of
     suitable reports.
Level 6
(a) Present the information found within database searches as a variety of
     suitable reports for different purposes and audiences.
   
         
   
   
         
         
         
    EXTENDED TASK: For those of you who want a bit of a challenge!    
         
   
Level 5
Create a ghosts database from the research you did on ghosts in TASK 1.
(Use the same ghost types as you used in your ghost sightings database)
Level 6
Link your ghost sightings database (created in TASKS 3
& 4) with your ghost database by using 'Ghost Type' as the
common factor.
(You may wish to use the sample ghost sightings database under 'Activities' section of the 'Database Resource Centre' below)
Level 7
Interrogate your linked databases to investigate whether any information given in the ghost sightings can be discredited by your research.
   
oo oo   oo oo
             
             
 
DATABASE RESOURCE CENTRE
 
             
 
TAKING YOUR WORK TO THE NEXT LEVEL
'I CAN' Sheet This is your AFL (Assessment for Learning) sheet that tells you what evidence you have to show to achieve a particular level, and what you have to do to get to the next level.
 
             
 
TEST YOUR KNOWLEDGE
Quiz 1 Rebuild It!
Quiz 2 Breakout!
Quiz 3 Spot the Teacher!
Quiz 4 Bash the Word!
Quiz 5 Catch the Fruit!
Quiz 6 Racing Cubes!
Quiz 7 Maze 1
Quiz 8 Maze 2
Quiz 9 Balloon Attack!
Quiz 10 Dunk the Teacher!
Quiz 11 Hangman!
Quiz 12 Creating a Survey!
Quiz 13 Twister!
Harder Quiz 1 Data (LEVEL 5/6).
Harder Quiz 2 Data Types (LEVEL 5/6).
Harder Quiz 3 Database Terminology (LEVEL 5/6).
 
             
 
IMPROVING YOUR LITERACY
Database Glossary A copy of the database key words and definintions below.
Wordsearch Game Do you know your Key words?
Wordsearch Traditional Wordsearch! (NEEDS TO BE PRINTED)
Sentence Tiles Put the word tiles in the right order! (NEEDS TO BE PRINTED)
Database Terms Have a look at database key words by using your arrow keys!
Wrong Statements Explain why the statements are wrong! (NEEDS TO BE PRINTED)
Comic 1 What is a Database? Can you help Batman & Robin Out?
Comic 2 What is a Hypothesis? Can you help Batman & Robin Out?
Comic 3 Database Terms & Filter Tool! Can you help Batman & Robin Out?
ICT Dictionary You can look up the meanings of words for all ICT (not just this project)
 
             
 
ACTIVITIES
Ghost Sightings Database A sample ghost sightings database to practice filtering and queries.
Sorting, Finding, & Filtering Add screenshots and write in your answers!
Using Queries Add screenshots!
 
             
 
INFORMATION & HELP
Introduction to Databases 1 A short introduction to parts of a database and data types.
Introduction to Databases 2 A more detailed introduction to databases.
Database Video Help Video tutorials to help you use a Microsoft Access database.
Database Information A mini website to give you all sorts of information about databases.
 
             
 
HOMEWORKS (You need to print these out)
Homework 1 Using Databases.
Homework 2 Reading a Database.
Homework 3 Using Codes for Data Entry.
Homework 4 Designing a Database.
Homework 5 Creating a Data Collection Form (LEVEL 5/6).
 
             
             
             
    DATABASE GLOSSARY:


Data:
Information in a form that a computer can understand.

Database:
An organised collection of data that is stored on a computer.

Data Item:
One piece of data in a database.
 
   
o o o o o o o
   

Data Type:
The type of data that is entered into a field, e.g. text, limited text, number, and date.

Data Validation Rule:
Only allows a field to accept the type of data that is selected.

Discontinuous Data:
Data that cannot have values in-between.

Edit:
Change data that is stored on a computer.

Error Alert:
A message that tell us that there is something wrong with the data that has been added to the database.

Field:
A category of information.

Field Check:
A check performed by a data validation rule to see if the data is of the right type to be put into a field.

   
o o o o o
   
Filter:
Narrowing down information by removing unwanted information.

Form:
A screen used to enter data into a database, and which shows all the data in one record.

Group:
Arrange data together that have the same characteristics or features.

Input:
Enter data into a computer.

Input Message:
A message that helps the user of the database to enter the correct data.
   
o o o o o
    Key Field:
A category of information that is unique to that record, so no 2 records could have the same value

Limited Text:
Text data that is shortened in order to save time when entering it into a database, and to save computer memory when it is stored.

Query:
Asking the database a question so that particular information can be found..

Record:
A set of related information about something, which contains a data item from each field.

Report:
A way of presenting data from a database in a written form.

Search:
To find an item (or items) of data in a database.

Search Criteria:
Words used to search a database, e.g. the search criteria ‘mammal’ will find all the mammals listed in an animal database.

Sort:
Arrange data into groups with the same characteristics or features that have been chosen by the person carrying out the sort.

Table:
A structure used to hold and show all the data in a database.