7+database+3

=Databases= REMEMBER TO LOGON TO GOOGLE CLASSROOM!

Lesson 1 Lesson 2 Lesson 3 Lesson 4 Lesson 5 Lesson 6

Lesson Objectives

 * Understand how to search a database
 * Be able to create a search/query with multiple criteria
 * Create 3 queries

Success Criteria
(5-6) Be able to describe how criteria are used to perform a query (5-6) Define a query with multiple criteria (4-5) Define a query with single criteira

Starter (10 mins)
Folder sort On the label write
 * YOUR name
 * Year 7 ICT
 * Mrs Evans
 * Monday 3 - Wednesday 4

As work is returned - see if you need to add comments (SITS marking!) before putting it into your folder

Homework
Last weeks homework has been marked on Google Classroom - this weeks homework is to download the keywords spreadsheet and learn at least 3 keywords for this unit

Activity (10 mins)
Download and open the database from Google Classroom
 * Using a Google Document
 * Name this document **DATABASE CLASSWORK**
 * Add your name in the **header**
 * Make a LIST of all the **fields** in the **table** of your classmates

Class Activity (10 mins)
We will design some queries for our database

Task (15 mins)
Take screenshots of your queries in design view Add these to your **Database Classwork** document Crop your queries appropriately

Plenary (5 mins)
Define a keyword for this unit