Wednesday, April 8th- 8th Grade- Designing and Formatting a Database

s

	Archdale-Trinity Middle School Lesson Plan
Date: 04-08-2015

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

“I Can…” Statement	Criteria for Success-Formative/Summative Assessments
I can design a database. Test on Friday on Data Types and Field Properties.	Students correctly design a database.

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)

Guided Lesson: @ Students will sign in to Edmodo or get an Edmodo sign in. Student username = lunch numberPassword = Computer log-on (Birthdate = leading zeroes/forward slash/ four-digit year 6th period Edmodo code   3fxmg4 7th  period Edmodo code sc2yzq @  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: @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. @ Complete the "Design" database assignment on the last slide of the   Worksheet Steps to Create a Database PowerPoint

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