Lesson 1: What is a Database?
Starter: Use Google to find out what a Database is, find 15 examples.
Discuss with another student what you found and and also why an electronic Database is useful.
The school uses a database to store all your data in a logical order. Each one of you in the class will have a student record which contains all of your information. Can you think of other business and organisations that will have a database?
The Police use databases to solve crimes, just like the famous and awesome Sherlock. You are going to use a database to solve 10 crimes, click the link below,
The game is on......
Plenary:
Discuss with another student what you found and and also why an electronic Database is useful.
The school uses a database to store all your data in a logical order. Each one of you in the class will have a student record which contains all of your information. Can you think of other business and organisations that will have a database?
The Police use databases to solve crimes, just like the famous and awesome Sherlock. You are going to use a database to solve 10 crimes, click the link below,
The game is on......
Plenary:
- Make a list of the new skills you have learnt, discuss with another student how you might use them in your own games and programs.
- Make a rap about Databases, perform it next lesson.
Lesson 1a: Database Theory
Starter:
Play this game
or
Load up Yell.com and find the answers to the phone number and addresses for the businesses below:
This lesson looks at the structure and features of a database, Complete the first worksheet and share and mark with another student. Task 2 develops your understanding further of what a database is. DB uses a lot of different data types, for example, text. Can you think of some more? Complete task sheet three. As a bonus, try finding out what the terms in task 4 mean, this is a challenge, good luck. Don't forget to share your findings with others.
Play this game
or
Load up Yell.com and find the answers to the phone number and addresses for the businesses below:
- Enterprise Car Hire Durham City
- Evans Halshaw (Renault) Durham City
- Theatre Royal Newcastle upon Tyne
This lesson looks at the structure and features of a database, Complete the first worksheet and share and mark with another student. Task 2 develops your understanding further of what a database is. DB uses a lot of different data types, for example, text. Can you think of some more? Complete task sheet three. As a bonus, try finding out what the terms in task 4 mean, this is a challenge, good luck. Don't forget to share your findings with others.
|
|
| ||||||
| 4_common_database_terms.doc |
Lesson 2:_ Queries
Starter: Click the starter link and play this Database game for 5 minutes, Share with another student what you learnt
In this lesson you will learn about Queries, look this up. It is like a question, a way of filtering out unwanted data to find the exact pieces you need. For example looking for a student's phone number to call home about their missing HW!
Look at the lesson notes which the teacher will talk through, you are going to solve a case using the clues you are given to filter the data and create a query. You will also need to download the suspects database. Your teacher will walk you through case one.
In this lesson you will learn about Queries, look this up. It is like a question, a way of filtering out unwanted data to find the exact pieces you need. For example looking for a student's phone number to call home about their missing HW!
Look at the lesson notes which the teacher will talk through, you are going to solve a case using the clues you are given to filter the data and create a query. You will also need to download the suspects database. Your teacher will walk you through case one.
|
| ||||
Now that you have the hang of it create your own cases using the template below. Share these with other students and challenge them to solve the case, can they?
| make_your_own.pptx |
Lesson 3: Queries part 2
|
Starter: watch the Civil War trailer. You are a film director and looking for superheroes for the new and up and coming sequel. Download and save the Database and cast requirements list.
|
| |||||||||
Lesson 4: Top Trumps Part 1
Lesson Starter - Click here and play the game for 10 minutes.
Do you remember the game of Top Trumps? Some of you may have brought your own in today. Play it to see how the game works.
In this lesson you are going to create your own version of top trumps using a database. This requires two parts. This first is to set up a table, store the details of all the cards and then create a Form to display each card. Your teacher may demonstrate how to get started but you can use the guides below to help you out, if in doubt as another student.
Do you remember the game of Top Trumps? Some of you may have brought your own in today. Play it to see how the game works.
In this lesson you are going to create your own version of top trumps using a database. This requires two parts. This first is to set up a table, store the details of all the cards and then create a Form to display each card. Your teacher may demonstrate how to get started but you can use the guides below to help you out, if in doubt as another student.
|
| ||||
Lesson 5: Top Trumps Part 2
In this lesson you will set up the TT game
Queries
The Games
Queries
The Games
End of Year Test:
This lesson you will complete the end of year test. This covers all the content from the year and is used to measure how much you have learnt and progressed.
- Download the file below an answer the questions.
- Your teacher will enter the password to 'self mark' the questions.
- Hand in the final score to your teacher.
- Check sheet 2 to see how well you did and areas for improvements.
| Year 8 EOY test |