 |
Archdale-Trinity Middle School
Lesson Plan
|
Date: 03-06-2015
|
Teacher:
|
Witkowski
| |
Lesson/Unit Topic:
|
Databases- Creating a Database
| |
Standards:
|
DB-2 Know the data types associated with a database
|
“I Can…” Statement
|
Criteria for Success-Formative/Summative Assessments
|
I can create a database.
TEST ON TUESDAY
|
Students create a database.
|
Literacy/Vocabulary Strategies (Word Wall)
|
Which Field types should you use for each of the FIELD NAMES below?
Fields are categories of information.
Text, Date/Time, Yes/No, Text, Currency
The RECORDS would be each Farmer Code. Records are a complete set of field entries.
|
Bell-Ringer/Connecting Strategy
|
On page 24, type lines 5 and 6.
Remember to use your thumb for the space bar.
We are using our left RING finger for the W key.
Make sure you use the shift keys to capitalize the words!
|
Lesson-Instructional Strategies & Procedures for Teacher and Students
(Detailed Plans Including Best Practices, Researched Based Strategies)
|
Guided Practice:
@ Why do businesses use databases? http://www.youtube.com/watch?v=yeVHLTkIXB8
to minute 3:45
@ Miss W will walk through how to create a vacation database
by right clicking on the database name to the left and using the Design view.
Students will check to make sure they have the correct field types.
Students will add a new field from Design view.
@ Miss W will review sorting definitions- ascending and descending
@ Students will participate in the connector AND and OR activity
@ Students will practice sorting with their flight database
Independent Exercise:
@ Students will enter their vacation information into their vacation database.
@ If it does not let you type in the data, it means you have the field type wrong.
@ If time: Sorting activity
Sorting- arranging items in a different order.
Ascending- A to Z order (alphabetical order), 1 to 100 order
Descending- Z to A order, large numbers to small numbers order
@ Review PowerPoint for test questions
@ Practice test questions with exit activity 11.
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 you create a database?
|
Student Technology/Differentiation
|
Students will use Access to create a database.
|
Closure Strategy
|
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.
Exit Activity #11: Database Test Questions
The first database test will be on these questions.
There are some questions we have not covered yet.
To put data in a particular order is to sort.
Ascending is small to large, A-Z order.
Descending is large to small, Z-A order.
Two examples of connector words are OR and AND.
A feature that displays records that meet one or more specific
criteria is a filter/query.
Exit Activity #12: Database terms
Exit Activity #13: Database terms
|
L
|
No comments:
Post a Comment