 |
Archdale-Trinity Middle School
Lesson Plan
|
Date: 10-23-2014
|
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.
Test on Wednesday. |
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
@ Students will open the Data Type and Field Properties PowerPoint
@ Miss W will review different data types with students.
@ Students will finish the BB Inns database.
@ It is very important to enter the data correctly or you will get the problems wrong!
@ Students are use to seeing a database in DATASHEET View.
Datasheet View displays data in a row-and-column format.
@ Students will look at the DESIGN View to see if they used the correct database types.
Design View lets you tell Access exactly how you want the object to look.
@ If time: Students will learn about the LOOK UP Wizard database type.
A WIZARD asks you questions and formats the form according to your preference.
Do NOT name the field first wait until you are asked for it.
Students will work through an example with the teacher
using a Lookup Wizard with the
BBinns file to create a Discount field.
The Discount field should be the Lookup & Relationship data type.
When you get to number of columns type in the following choices:
Senior
Military
AAA
Other
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
|
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