Thursday, April 2nd- 8th Grade- Steps to Designing a Database and Test Review

s

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

Teacher:	Witkowski
Lesson/Unit Topic:	Databases- Steps to creating a database
Standards:	DB-2 Know Data Types associated with a database

“I Can…” Statement	Criteria for Success-Formative/Summative Assessments
I can tell the difference between a data type and a field property.	Students know the difference between data types and field properties

Literacy/Vocabulary Strategies (Word Wall)

This genealogy database was designed so the date would be entered as year-month-day. What type of field property was used? http://en.wikipedia.org/wiki/Genealogy

Bell-Ringer/Connecting Strategy

On page 72, type lines 10 and 11. We are using our left INDEX finger for the $  key. DOLLAR SIGN We are using our right PINKY finger for the  SHIFT  key

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

Guided Lesson:     @ Open Database data types and field property test @ Data Type and Field Properties PowerPoint    @ Review Steps in Creating a Database     @ Complete both sides of puzzle worksheet Independent Exercise: @ Students will use study guide to solve data type crossword puzzle http://worksheets.theteacherscorner.net/puzzle/cw-PXtIPiL/ If time: @  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 @ 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 follow certain steps to create a database?

Student Technology/Differentiation

Students use Access to tell the difference between a data type and a field property.

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