Wednesday, Mar 4th- 8th Grade- Databases- Gathering Vacation Data

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

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

“I Can…” Statement	Criteria for Success-Formative/Summative Assessments
I can gather data for a database.	Students can collect information for a database.

Literacy/Vocabulary Strategies (Word Wall)

Field types: Date/Time, Yes/No, Text, Currency, The Number field type is used when you are going to do math with the numbers. http://en.wikipedia.org/wiki/Sun

Bell-Ringer/Connecting Strategy

On page 21, type lines 9 and 10. Remember to use your thumb for the space bar. We are using our RIGHT PINKY finger for the RIGHT SHIFT  key.

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

Guided Practice: @ Access 2010: Introduction to Databases http://www.youtube.com/watch?v=eXiCza050ug @ Students will open in the DATABASE folder     the 1 Database Fundamentals PowerPoint @ Class will practice identifying tables and records, fields, and entries. @ Class will discuss the difference between text and number data field types. @ Finish the Review of Database Tables worksheet. Independent Lesson: @ Students will start on airline database worksheet. @ Miss W will walk through how to gather data for the first example. @  Expedia TV ad http://www.youtube.com/watch?v=-B5hcH8Kr4U @ Go to http://www.expedia.com/     GSO- Greensboro     RDU- Raleigh     CLT- Charlotte       Flight # Airline Departure City Arrival City Departure Time Arrival Time Length of Flight Date Leaving # of Stopovers Cost of Trip Independent Activity: Students will complete vacation spots on the airline database worksheet. 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

How do I know which data goes into which field?

Student Technology/Differentiation

Students will use expedia.com to gather information for a database.

Closure Strategy

Exit Activity #5: Practice on the beginner level (#1 home row keys) at http://www.freetypinggame.net/play11.asp Choose beginner if you are in the beginner category Choose intermediate if you are in the average category Click to turn off the sound. 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: Choose home row and easy. Turn off sound. http://www.typingweb.com/tutor/games/play/game/23 Exit Activity #11: Database terms http://www.quia.com/jg/1412062.html Exit Activity #12: Database terms http://quizlet.com/18461807/database-terms-flash-cards/