s
 |
Archdale-Trinity Middle School
Lesson Plan
|
Date: 10-24-2014
|
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 62, type lines 06 and 07.
Remember to use your thumb for the space bar.
|
Lesson-Instructional Strategies & Procedures for Teacher and Students
(Detailed Plans Including Best Practices, Researched Based Strategies)
|
Guided Lesson:
@ Students will open the Data Type and Field Properties PowerPoint
@ Students will open their INN database.
@ Students will create look up wizards for bed size and window view.
@ Is it a data type or a field property? candy review
@ Review Steps in Creating a Database
@ 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.
@ Open 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 complete the Is it a data type or field property? worksheet.
@ Students will make the following 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
|
No comments:
Post a Comment