s
 |
Archdale-Trinity Middle School
Lesson Plan
|
Date: 04-01-2015
|
Teacher:
|
Witkowski
| |
Lesson/Unit Topic:
|
Databases- Using an input mask
| |
Standards:
|
DB-2 Know Data Types associated with a database
|
“I Can…” Statement
|
Criteria for Success-Formative/Summative Assessments
|
I can use an input mask.
|
Students use input masks.
|
Literacy/Vocabulary Strategies (Word Wall)
|
An input mask FORCES an user to put the data into the database in a certain way.
It helps to cut down mistakes.
https://www.flickr.com/photos/fstorr/6512990915/
|
Bell-Ringer/Connecting Strategy
|
On page 71, type lines 05 and 06.
We are using our left INDEX finger for the 4 key.
|
Lesson-Instructional Strategies & Procedures for Teacher and Students
(Detailed Plans Including Best Practices, Researched Based Strategies)
|
Guided Lesson:
@ Students will open their INN database.
@ Student will get out their Data Type or Field Properties? worksheets.
@ Data Type and Field Properties PowerPoint
Is it a data type or a field property? candy review
@ The Wonderful Wizards of Access - Part 2 - Using the Input Mask A http://www.youtube.com/watch?v=fBlT1KrQUsY
Start at 1 minute and end at 4 minutes .
@ Open the Field Property- Input Mask PowerPoint in the Database folder.
@ Go to your INN database.
@ Miss W will walk you through setting up a phone number input mask.
@ Miss W will show you a 2nd way to get to the Design View (right click on table name.)
Independent Exercise:
@ Students will create a zip code input mask.
@ Students will make the following notes:
Today’s Notes:
on the first page
Number- used for data that may be calculated or sorted
on the second page
at the top of the page write:
Record- a group of related fields of information
Memo- like text, but maximum of 64,000 characters
Lookup wizard- allows you to create a finite (limited) set of choices for that field’s entry values.
at the bottom of the page write:
Entry- data and formulas keyed in a field
@ Students will use study guide to solve data type crossword puzzle http://worksheets.theteacherscorner.net/puzzle/cw-PXtIPiL/
Monday’s Notes:
Yes/No is also a true/false field. will contain a check box yes/ no. Default is no.
Text includes words and/or numbers not used in calculations.
Currency monetary values
Input mask a format often applied to dates, time and zip codes.
at the bottom of the page write:
Field- one item of information in a record. represented by a column.
|
Higher Order Thinking Questions
|
Why would you want to use an input mask in your database?
|
Student Technology/Differentiation
|
Students use Access to add an input mask to their database.
|
Closure Strategy
|
Lesson Reflections
|
No comments:
Post a Comment