 |
Archdale-Trinity Middle School
Lesson Plan
|
Date: 03-27-2015
|
Teacher:
|
Witkowski
| |
Lesson/Unit Topic:
|
Databases- Look up wizards
| |
Standards:
|
DB-2 Know Data Types associated with a database
|
“I Can…” Statement
|
Criteria for Success-Formative/Summative Assessments
|
I can use a look up wizard.
|
Students use a look up wizard
|
Literacy/Vocabulary Strategies (Word Wall)
|
What type of field should the telephone number be? WHY?
 |
Bell-Ringer/Connecting Strategy
|
On page 60, type lines 10 and 11.
Remember to use your thumb for the space bar.
We are using our left PINKY finger for the SHIFT key.
We are using our right PINKY finger for the _ Underscore key
|
Lesson-Instructional Strategies & Procedures for Teacher and Students
(Detailed Plans Including Best Practices, Researched Based Strategies)
|
Guided Lesson:
@ Typing assessment (class participation grade)
round up all numbers
if you were listed as a slow typist
20% improvement is a 100
10% improvement is a 90
0% improvement is a 80
slower than before improvement is a 70
if you were listed as a average typist
10% improvement is a 100
5% improvement is a 90
0% improvement is a 80
slower than before improvement is a 70
Independent Exercise:
@ Students will create look up wizards for bed size and window view.
@ Is it a data type or a field property?
@ 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
|
How do I create a look up wizard?
|
Student Technology/Differentiation
|
Students will use Access to create a look up wizard.
|
Closure Strategy
|
No comments:
Post a Comment