s
 |
Archdale-Trinity Middle School
Lesson Plan
|
Date: 03-30-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 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:
Miss W will explain instructions for Sub assignment
- Choose 6 careers from the Science, Technology, Engineering and Math page.
- Fill in your worksheet for the following categories:
You only need to write the first sentence in the job description blank.
- Choose one of the 6 careers and create a PowerPoint.
# The first slide should have your name and occupation and a picture with a citation.
# Look at the ENTIRE job description. Have one or more slide for each sentence.
You may copy and paste job description sentences.
# You need at least 5 slides not counting the title page.
# Find interesting pictures about that occupation and have one picture per slide with
the proper citations.
# Save to your lunch number.
@ 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.)
@ Students will create a zip code input mask.
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
| ||||||
Exit Activity #12:
Data type and Field Property Matching Review
Exit Activity #13:
Study Data Types vs Field Properties Definition Review http://quizlet.com/920789/cai-501-data-typesfield-props-flash-cards/
Then click scatter ( goal is 60 seconds or less)
| ||||||
No comments:
Post a Comment