Monday, Nov 3rd- 8th Grade- Database- Templates

s

	Archdale-Trinity Middle School Lesson Plan
Date: 11-03-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)

A template is a pre-designed form. You can have templates for any type of software or form, such as databases, business cards, letterhead, etc. http://123freevectors.deviantart.com/art/Greeting-Card-Template-Vector-272642738

Bell-Ringer/Connecting Strategy

On page 75, type lines 6 and 7. We are using our left MIDDLE finger for the 3  key.

Guided Lesson: @ Select a Access Database Template http://www.gcflearnfree.org/access2010/15.2 Independent Exercise: Reviewing Templates Open the Template Word document        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 @ If time start on the Queries Prework 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 #11: EASY Database Vocabulary Review: http://www.quia.com/mc/619996.html Exit Activity #12: Database words-  http://www.quia.com/hm/671677.html?AP_rand=461255884&playHTML=1 Need to get at least 8 out of 11 correct. Exit Activity #13: Reach a million dollars. http://www.quia.com/rr/592937.html Exit Activity #14: Database Vocabulary includes math signs: http://www.quia.com/jg/619998.html   Words we have not covered yet: Freeze Column- To make the first field stay in place type a * at the beginning and end of the word-  When searching fields that contain a specific word type the word with not stars- When searching fields that equal a specific word remove the filter (Click the Funnel)- To get back to all records from a filter you must Exit Activity #15: Database filter words (more than, less than, etc.):  http://www.quia.com/jg/778814.html Exit Activity #16: Understanding Database concepts: http://www.quia.com/pop/83136.html?AP_rand=359993708 Must get at least 7 correct out of 10.