Transcript YEAR 7 DATABASES – LESSON 2 Key Stage 3 - ICT

YEAR 7 DATABASES –
LESSON 2
Key Stage 3 - ICT
STARTER



Using a word processor…
List all the places in society you think would use
a database.
Review in two minutes
OBJECTIVES


WALT (We Are Learning To):
 Apply previous database knowledge to a scenario.
 Understand where databases are used in society.
 Develop database searching skills.
WILF (What I’m Looking For):
 You can say what a database is and what information is
made up of.
 You know what a field, record and table is.
 You can create a basic database query to find
information
QUICK REVIEW
What is a database?
 What is a field?
 What is a record?
 What is a table?

PAST AND PRESENT
We have looked at internet databases.
 We will now look at a real one.



This is what is used behind the website you see
on places such as eBay.
Sample Database

See if you can spot, fields, records and tables.
TEACHERS NOTES
BEFORE
starting the next task,
please make sure you copy the
file ‘Y7 DB L2 TEMPLATE’ and
rename it to the class you are
teaching.
At
the END of the lesson, delete
the copied file.
TASK 2

More than one person can use a database at any one time.

Let’s try it out



Open the database from the shared area. Enter in your
information.
RM Shared  BITE  ICT KS3  YEAR 7 
DATABASES  Lesson 2  YOUR CASS NAME.mdb
I will display the table on the board, which will show the
information being displayed.
QUERIES DEMO
Like when we used eBay, we searched a
database, we can also do it to the database we
have just created.
 This is called QUERYING the data.


Let’s look at some queries already set up in the
database we have just used.
TASK 3



It’s time you did some basic searches, like you did
using an internet database.
Use the queries in your database to complete the
worksheet:
RM Shared  BITE  ICT KS3  Year 7 
Databases  Lesson 2  Queries Task.doc
OBJECTIVES REVIEW


WALT (We Are Learning To):
 Apply previous database knowledge to a scenario.
 Understand where databases are used in society.
 Develop database searching skills.
WILF (What I’m Looking For):
 You can say what a database is and what information is
made up of.
 You know what a field, record and table is.
 You can create a basic database query to find
information
HOMEWORK

Find a definition of the word ‘query’