Thursday, Oct 30th- 8th Grade- Database- Design Templates

s

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

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

“I Can…” Statement	Criteria for Success-Formative/Summative Assessments
I can use a template.	Students use templates.

Literacy/Vocabulary Strategies (Word Wall)

The Ampersand sign “&” means “and.” An example: I like cats & dogs. http://commons.wikimedia.org/wiki/File:Glossy_3d_blue_ampersand.png

Bell-Ringer/Connecting Strategy

On page 72, type lines 17 and 18. We are using our right INDEX finger for the &  key. AMPERSAND SIGN We are using our left PINKY finger for the  SHIFT  key

Guided Lesson: @ Students will create flashcards for the questions they missed on the test.      Students will create online flashcards at http://quizlet.com/ @ Select a Access Database Template http://www.gcflearnfree.org/access2010/15.2 Independent Exercise: Music Database @Students will brain storm as a group the different fields needed @ Students will add an alternate row color of their choice. @ Students will change the color of the gridlines. @ Students will choose a raised cell design. Reviewing Templates Open a Word document. Miss W will show you how to create a table. Type the following table of template names:                                 then list 2 NEW fields besides each name that you have not seen before. For example:                                        Template Name New Field 1 New Field 2 Education Student ID Class Finance Inventory Issues and Tasks Sales and Marketing Time and Billing Small Business 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. Independent Lesson: @ Complete the "Design" database assignment on the last slide of the   Worksheet Steps to Create a Database PowerPoint

Higher Order Thinking Questions

What is a template? Why would you want to use one?

Student Technology/Differentiation

Students use Access to find templates for their databases.

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