Wednesday, Jan 7th- 8th Grade- Review for Database Relationship Test

	Archdale-Trinity Middle School Lesson Plan
Date: 1-07-2015

Teacher:	Witkowski
Lesson/Unit Topic:	Review for Thursday’s Database Relationships Test
Standards:	DB-1  Know the Use and Purpose of a Database DB-2  Know Data Types associated with a Database DB-3  Demonstrate the Management of a Database

“I Can…” Statement	Criteria for Success-Formative/Summative Assessments
I can remember database relationship definitions. Test on Database Relationships on Thursday.	Students will remember database relationship definitions.

Literacy/Vocabulary Strategies (Word Wall)

What type of table is Fact_Sales? In the Dim_Store table is Id a primary key or a secondary key? In the Fact_Sales table is Store-Id a primary or secondary key? http://en.wikipedia.org/wiki/Star_schema

Bell-Ringer/Connecting Strategy

On page 423, type the 3rd and 4th sentences that start “A faster way of doing things”.

Guided Lesson: @ Students will finish their vocabulary word presentations. @ Miss W will review the review the questions and answers for tomorrow’s test. Independent Exercise: @ Students will review the review the questions and answers for tomorrow’s test.

Higher Order Thinking Questions

How can you understand the different database relationships (one to one, one to many, many to many)?

Student Technology/Differentiation

Students use various software programs to review for Thursday’s test.

Closure Strategy

Exit Activity #14: Database relationships http://www.quia.com/rr/475949.html?AP_rand=1592723462 Exit Activity #15: Typing Symbols http://www.quia.com/rr/142292.html