 |
Archdale-Trinity Middle School
Lesson Plan
|
Date: 05-06-2015
|
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 index finger on the 1
Your middle finger on the 2
Your ring finger on the 3
Your ring finger on the . period key.
The daily bellringers will now be practicing the number pad
Choose exercise 1 and then click on the word "start."
Time will not start until you put your cursor
in the white rectangle and start typing.
Record your typing speed and accuracy in your typing file.
|
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
Database Design (Family example) https://www.youtube.com/watch?v=P_nhBKs25DQ
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.
@ Save to the Database folder then the DB Relationship Project folder.
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)
|
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