 |
Archdale-Trinity Middle School
Lesson Plan
|
Date: 12-04-2014
|
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. Text on Wednesday.
|
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:
@ There will be a test next Tuesday.
@ There will be questions on Typing, Publisher, and Databases
@ The test will not include the new words this week- foreign key or database relationships
@ 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.
@ We will discuss the project more next week.
@ Miss W will review the importing data process.
Independent Exercise:
@ Students will import text data into a database.
@ Name your database and table SCHOOLS
@ Name, Ownership, Type, Enrollment, InState, OutofState
are your field names.
@ Every field is text except InState, and OutofState they are currency.
@ If you do it correctly you will not need to type dollar signs.
@ If you make a mistake on the field names or type, go to the Design view to correct it.
Access Database Basics-Referential Integrity https://www.youtube.com/watch?v=oJh5pNhoOLE If time:
@ Students will open their 9 Independent Practice Filtering and Sorting a Database WORD document.
@ Students will open the 9 Independent Practice Filtering and Sorting a Database PowerPoint
@ Students will screen print their answers into the 9 Independent Practice document.
@ Students will save the file to their lunch number.
@ Miss W will go over problems 8 and 9 from the
@ You NEED to make sure your screen prints are numbered and CLEAR and EASY to read.
@ Crop the images until just the answers show.
|
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