Wednesday, Oct 29th- 8th Grade- Database Test and Designing a Database

s

	Archdale-Trinity Middle School Lesson Plan
Date: 10-29-2014

Teacher:	Witkowski
Lesson/Unit Topic:	Databases- Test and Designing a Database
Standards:	DB-2 Know Data Types associated with a database

“I Can…” Statement	Criteria for Success-Formative/Summative Assessments
I can do well on the today’s test.	Students make good grades.

Literacy/Vocabulary Strategies (Word Wall)

A database is an efficient means of storing and retrieving data and printing report from stored data. This database stores genealogy information and can print reports about individual relatives. Each person would be a record, which is a group of related fields. Fields are one item of information in a record, represented by a column. In this example, date and place are fields.    http://en.wikipedia.org/wiki/Genealogy

Bell-Ringer/Connecting Strategy

On page 72, type lines 13 and 14. We are using our right INDEX finger for the 7  key.

Lesson-Instructional Strategies & Procedures for Teacher and Students (Detailed Plans Including Best Practices, Researched Based Strategies)

Students will take data type and field property test.   @ CareerBuilder Top Jobs of 2014: Database Administrator http://www.youtube.com/watch?v=nD_wk8upHg4 Guided Lesson: @  The Database Design Sketch  http://www.youtube.com/watch?v=n3TU3yFUubc    until 3:33     @ Students will brainstorm different information needed for the database. Music Database @Students will brain storm as a group the different fields needed Independent Lesson: @ Complete the "Design" database assignment on the last slide of the   Worksheet Steps to Create a Database PowerPoint @Customizing tables    *alternate row colors http://www.gcflearnfree.org/access2010/5.5   *additional formatting- gridline colors, background colors, etc. http://www.gcflearnfree.org/access2010/5.6 Students will change the size of their records and fields. Students will change the borders of their records. Students will change the color of alternate rows. Students will change the color of the gridlines.

Higher Order Thinking Questions

Why would you want to sketch a design of your database before creating it.

Student Technology/Differentiation

Students use Access to create and format a database.

Closure Strategy

Exit Activity #10: Choose home row and easy. Turn off sound. http://www.typingweb.com/tutor/games/play/game/23 Exit Activity #11: Database Vocabulary Review: http://www.quia.com/mc/483616.html