 |
Archdale-Trinity Middle School
Lesson Plan
|
Date: 05-07-2015
|
Teacher:
|
Witkowski
| |
Lesson/Unit Topic:
|
Database- Importing data
| |
Standards:
|
DB-3 Demonstrate the management of a database
|
“I Can…” Statement
|
Criteria for Success-Formative/Summative Assessments
|
I can tell the difference between a primary key and a foreign key.
|
Students can tell the difference between a primary key and a foreign key.
|
Literacy/Vocabulary Strategies (Word Wall)
|
Is the movie, August Rush, a primary or foreign key?
There are links to the stars’ database. Is the actress, Keri Russell, a primary or foreign key?
Is the movie, John Q, a primary or foreign key?
There are links to the stars’ database. Is the actor, Denzel Washington, a primary or foreign key?
https://www.flickr.com/photos/wfryer/2661745103/
|
Bell-Ringer/Connecting Strategy
|
We are learning the numeric keypad.
Your index finger on the 1
Your middle finger on the 2
Your ring finger on the 3
Your ring finger on the . period key.
The daily bellringers will now be practicing the number pad
Choose exercise 2 and then click on the word "start."
Time will not start until you put your cursor
in the white rectangle and start typing.
Record your typing speed and accuracy in your typing file.
|
Guided Lesson:
@ You will be able to listen to music on Friday, Monday and Tuesday IF you work and behave!
@ There will be a test next Wednesday.
@ There will be questions on Typing, Publisher, and Databases
@ The test will NOT include the new words this week- foreign key or database relationships, etc.
@ Each day you will study a different topic and get a class participation grade for completing the worksheets and activities.
@ The questions will be previous questions. You may use your flashcards to study.
@ After the test, you will analyze your weakest topic and will do a project on it.
@ If you make a 88 through a 100 on the test, you will not need to do the project or retake the test.
@ For students, who retake the test, you will get the better of the 2 scores.
@ We will discuss the project more next week.
Independent Exercise:
Access Database Basics-Referential Integrity
@ Students will open the 9 Independent Practice Filtering and Sorting a Database PowerPoint
@ Miss W will go over problems 8 and 9.
@ Students will use Study Guide and partners to complete Exit Activity 14.
|
Higher Order Thinking Questions
|
What is the difference between a primary and foreign key?
|
Student Technology/Differentiation
|
Students use Access to import data into a database.
|
Closure Strategy
|
Exit Activity #14: Database relationships
|
No comments:
Post a Comment