 |
Archdale-Trinity Middle School
Lesson Plan
|
Date: 09-29-2014
|
Teacher:
|
Witkowski
| |
Lesson/Unit Topic:
|
Databases- Gathering Data for a Database
| |
Standards:
|
DB-2 Know the data types associated with a database
|
“I Can…” Statement
|
Criteria for Success-Formative/Summative Assessments
|
I can gather data for a database.
TEST ON FRIDAY
|
Students can collect information for a database.
|
Literacy/Vocabulary Strategies (Word Wall)
| ||||||||||||||||||||
Here is an example of another student database.
There are 3 records (Shanaka, Shanika, and Billy)
There are 3 fields you can see (Title, Address, Age) and 1 field that is cut off
The field type is text for Title and Address.
If they are going to do math (find averages) with the Age field they should use the number field type.
If they are not going to math with the Age field they should use the text field type.
http://www.flickr.com/photos/indi/27936551/
| ||||||||||||||||||||
Bell-Ringer/Connecting Strategy
| ||||||||||||||||||||
On page 24, type lines 5 and 6.
Remember to use your thumb for the space bar.
We are using our left RING finger for the W key.
Make sure you use the shift keys to capitalize the words!
| ||||||||||||||||||||
Lesson-Instructional Strategies & Procedures for Teacher and Students
(Detailed Plans Including Best Practices, Researched Based Strategies)
| ||||||||||||||||||||
Guided Practice:
7th Period Only
@ Students will open in the DATABASE folder
the 1 Database Fundamentals PowerPoint
@ Finish the Review of Database Tables worksheet.
Independent Lesson:
@ Students will start on airline database worksheet.
@ Miss W will review how to gather data for the first example.
GSO- Greensboro
RDU- Raleigh
CLT- Charlotte
Independent Activity:
@Students will complete all 8 vacation spots on the airline database worksheet.
@ Students will complete the 1-10 Data Type sheet.
You may look at slide 18 or work in pairs.
@ Students, who finish collecting data will participate in typing contest.
Homework- Extra Credit for 3rd test:
Ask your parents if they have a business card or
have one in their wallets from a business or
have a friend with a business card or the next
time you go into a business or they go into a
business see if they have a business card or
at home go to Google and then images and type
"business card" then print a business card.
If you give Miss W a business card sometime
this week you will get 5 points extra credit on
the second test. MUST be appropriate for school-
no alcohol, guns or bad words on cards.
MUST BE IN BY MONDAY
| ||||||||||||||||||||
Higher Order Thinking Questions
| ||||||||||||||||||||
How do I know which type of data goes into which field?
| ||||||||||||||||||||
Student Technology/Differentiation
| ||||||||||||||||||||
Students will use expedia.com to gather information for a database.
| ||||||||||||||||||||
Closure Strategy
| ||||||||||||||||||||
Exit Activity #8:
Frog Game Home Row Keys http://www.freetypinggame.net/play3.asp
Exit Activity #9:
Typing Adventure http://www.learninggamesforkids.com/keyboarding_games/keyboarding_games_typing_adventure1.html
Exit Activity #10:
Choose home row and easy. Turn off sound.
Exit Activity #11: Database Test Questions
The first database test will be on these questions.
There are some questions we have not covered yet.
To put data in a particular order is to sort.
Ascending is small to large, A-Z order.
Descending is large to small, Z-A order.
Two examples of connector words are OR and AND.
A feature that displays records that meet one or more specific
criteria is a filter/query.
Exit Activity #12: Database terms
Exit Activity #13: Database terms
| ||||||||||||||||||||
No comments:
Post a Comment