Tuesday, March 3, 2015

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

Interlocking AT.jpg
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.
noble gases. [97]
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

@ 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.

    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:

Exit Activity #9:


Exit Activity #10:
Choose home row and easy. Turn off sound.


Exit Activity #11: Database terms

Exit Activity #12: Database terms
 




No comments:

Post a Comment