 |
Archdale-Trinity Middle School
Lesson Plan
|
Date: 09-25-2014
|
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.
 |
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 Lesson:
@ Students will open in the DATABASE folder
the 1 Database Fundamentals PowerPoint
@ What is your favorite movie?
as we watch the following video.
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
@ Continue 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.
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.
|
.PNG){kind=link}
No comments:
Post a Comment