 |
Archdale-Trinity Middle School
Lesson Plan
|
Date: 05-05-2015
|
Teacher:
|
Witkowski
| |
Lesson/Unit Topic:
|
Database- Advance filtering and Importing Text
| |
Standards:
|
DB-3 Demonstrate the management of a database
|
“I Can…” Statement
|
Criteria for Success-Formative/Summative Assessments
|
I can import text into a database.
|
Students will import text into a database.
|
Literacy/Vocabulary Strategies (Word Wall)
|
Importing means bringing an item in from an outside source.
This map shows countries that import oil.
 |
Bell-Ringer/Connecting Strategy
|
We are learning the numeric keypad.
Your thumb goes on the 0 at the bottom
Your index finger on the 4
Your middle finger on the 5
Your ring finger on the 6
Your pinky will hit the plus sign +
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:
@ Students will open 9 Independent Practice Filtering and Sorting a Database WORD document.
@ Miss W will show the class how to get the answers to 8 and 9.
IMPORTANT NOTICE!
You must close the database first before you close the access file.
You must click on the inside “x” before you click on the outside “x”
If you don’t close following the above instructions, it will freeze the program.
@ Open the Importing Text Files PowerPoint
@ Students will import text data into a database using an existing file.
@ Miss W will show students how to import data to a database
by saving as a plain text file. Name your Database Class.
@ Remember to save as a plain text file, NO spaces between the commas.
@ We will be using the External Data Tab (Ribbon).
@ In the Import and Link group, we will be clicking on the Text File button.
@ Students will need to Rename the fields, either by going to Design view
or using the menu option.
@ Open and Save the School Information file to your lunch number.
Independent Exercise:
@ Students will import text data into a database using their own data.
@ 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.
If time:
Guided Lesson:
@ Miss W will explain the difference between a one-to-one database
and a one-to-many database.
Pet relationship example https://docs.oracle.com/html/E38269_01/Content/Data%20model/Define_a_relationship.htm
Database Design 13 - One-to-Many Relationships
until minute 2
Database Design (Family example) https://www.youtube.com/watch?v=P_nhBKs25DQ
Independent Exercise:
students will create a visual definition of the following vocabulary words:
one-to-one database,
one-to-many database,
primary key,
foreign key,
and join line.
@ Save to the Database folder then the DB Relationship Project folder.
Rubric:
10 points Your Name
10 points definition of one-to-one database used correctly.
10 points definition of one-to-many database used correctly.
10 points definition of primary key used correctly.
10 points definition of foreign key used correctly.
10 points definition of join lines used correctly.
10 points spelling and grammar.
10 points for citation (may use one citation if you get all images from imdb)
10 points for using text boxes
10 points for creativity (having pictures of movie, stars, director and design elements- white space, balance, alignment, repetition, contrast and proximity/unity)
|
Higher Order Thinking Questions
|
Why do they call it importing data?
|
Student Technology/Differentiation
|
Students use Access to import data into a database.
|
Closure Strategy
|
Exit Activity #14:
Words that are new:
Report- display data in a custom format
Field selector- the box containing the field name
|
Lesson Reflections
|
No comments:
Post a Comment