 |
Archdale-Trinity Middle School
Lesson Plan
|
Date: 12-02-2014
|
Teacher:
|
Witkowski
| |
Lesson/Unit Topic:
|
Database- Relationship vocabulary
| |
Standards:
|
DB-3 Demonstrate the management of a database
|
“I Can…” Statement
|
Criteria for Success-Formative/Summative Assessments
|
I can tell the difference between a one-to-one database and a one-to-many database.
|
Students can tell the difference between a one-to-one database and a one-to-many database.
|
Literacy/Vocabulary Strategies (Word Wall)
|
A good example of a one to many database relationship is Netflix
or the International Movie database http://www.imdb.com/ .
There is only ONE movie named The Last Airbender however
you can click on MANY links such as “director” or “cast”.
 |
Bell-Ringer/Connecting Strategy
|
We are learning the numeric keypad.
Your thumb goes on the 0 at the bottom.
Your index finger on the 4
Your middle finger on the 5
Your ring finger on the 6
Your pinky will hit the plus sign +
The daily bellringers will now be practicing the number pad
Choose exercise 2 and then click on the word "start."
|
Guided Lesson:
@ Miss W will explain the difference between a one-to-one database
and a one-to-many database.
Database Design 13 - One-to-Many Relationships
until minute 2
Primary and Foreign Keys https://www.youtube.com/watch?v=8vKjhuQj0gk
Independent Exercise:
students will create a visual definition of the following vocabulary words:
one-to-one database,
one-to-many database,
primary key,
foreign key,
and join line.
Use the database relationship definition sheet.
Rubric:
10 points Your Name
10 points definition of one-to-one database used correctly.
10 points definition of one-to-many database used correctly.
10 points definition of primary key used correctly.
10 points definition of foreign key used correctly.
10 points definition of join lines used correctly.
10 points spelling and grammar.
10 points for citation (may use one citation if you get all images from imdb)
10 points for using text boxes
10 points for creativity (having pictures of movie, stars, director and design elements- white space, balance, alignment, repetition, contrast
and proximity/unity)
@ Save to the Database folder then the DB Relationship Project folder.
@ Students will open their Inn database.
@ Students will open 9 Independent Practice Filtering and Sorting a Database.
@ Students will open their Word filter file.
@ Students will screen print their answers for questions 1 to 7 to their filter file.
@ Students will crop their answers so they are readable.
@ Students will save the file to their lunch number.
|
Higher Order Thinking Questions
|
What is the difference between a one-to-one database and a one-to-many database?
|
Student Technology/Differentiation
|
Students will use a Word document and the online IMDB database to create a visual definition of different database relationship vocabulary words.
|
Closure Strategy
|
Exit Activity #14: Database relationships
|
No comments:
Post a Comment