Tuesday, March 3rd- 8th Grade- Database Field Types

	Archdale-Trinity Middle School Lesson Plan
Date: 03-03-2015

Teacher:	Witkowski
Lesson/Unit Topic:	Databases- Tables
Standards:	DB-1 Know the use and purpose of a database

“I Can…” Statement	Criteria for Success-Formative/Summative Assessments
I can understand why databases can have more than one table.	Students understand the use of tables in a database.

Literacy/Vocabulary Strategies (Word Wall)

Database Tables- building blocks of databases. All databases have at least one table. This example is showing a 2 table database. http://commons.wikimedia.org/wiki/File:Emp_Add_Tables_(Database).PNG

Bell-Ringer/Connecting Strategy

On page 20, type lines 5 and 6. Remember to use your thumb for the space bar. We are using our left INDEX finger for the V key.

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

Guided Lesson: @ Students will open in the DATABASE folder the 1 Database Fundamentals PowerPoint @ What is your favorite movie? We are going to look at the Internet Movie Database http://www.imdb.com/title/tt0240772/ as we watch the following video. @ What is a database? http://www.youtube.com/watch?v=Y-bvjtYgRVU    start at 1:10 explains relationships to 5:30 @ Class will practice identifying tables and records, fields, and entries. @ Class will discuss the difference between text and number data field types. Independent Lesson: @ Complete the IMDB worksheet @ Students will open in the DATABASE folder the 2 Data types and field properties PowerPoint @ Start the Review of Database Tables worksheet. Use slide 18 to help with the field type definitions. Please remember you only use the Numbers field if you want to calculate something. @ Complete the "What is a database?" question by copying the ENTIRE definition from slide 1 at the beginning of the PowerPoint. If time, Go to http://www.expedia.com/ Students will start on airline database worksheet. Miss W will walk through how to gather data for the first example. Homework- Extra Credit for 3rd test: Ask your parents if they have a business card or have one in their wallets from a business or have a friend with a business card or the next time you go into a business or they go into a business see if they have a business card or at home go to Google and then images and type "business card" then print a business card. If you give Miss W a business card sometime this week you will get 5 points extra credit on the second test. MUST be appropriate for school- no alcohol, guns or bad words on cards. MUST BE IN BY MONDAY

Higher Order Thinking Questions

Explain how a multi-table online database works?

Student Technology/Differentiation

Students will study a multi-table online database

Closure Strategy

Exit Activity #8: Frog Game Home Row Keys http://www.freetypinggame.net/play3.asp Exit Activity #9: Typing Adventure http://www.learninggamesforkids.com/keyboarding_games/keyboarding_games_typing_adventure1.html Exit Activity #10: October Game- Choose home row and easy. Turn off sound. http://www.typingweb.com/tutor/games/play/game/23