Wednesday, April 15, 2015

Thursday, April 16th- 8th Grade- Sort versus Filter

s
Interlocking AT.jpg
Archdale-Trinity Middle School
Lesson Plan
 
Date: 4-16-2015



Teacher:
Witkowski

Lesson/Unit Topic:
Databases- Database Careers

Standards:
DB-3 Demonstrate the management of databases



“I Can…” Statement
Criteria for Success-Formative/Summative Assessments
I can read carefully and find the correct information.  
Test on Tuesday.
Students make good grades on Achieve reading material.


Literacy/Vocabulary Strategies (Word Wall)
Sorting- Ascending order is A to Z or 1 to 100 order.
File:Insertion-sort-example-
http://commons.wikimedia.org/wiki/File:Insertion-sort-example-300px.gif
Bell-Ringer/Connecting Strategy
On page 79, type lines 6 and 7.
We are using our LEFT RING finger for the 2  key.

.Guided Lesson:
@ Students will correct sorting and math operator mistakes
@ Open the Guided Practice PowerPoint
@ Students will complete the income questions  
@ Open the Independent  Practice PowerPoint

If time:
On the first attempt:
100 to 75 is an “A”  100
 74 to 65 is a “B”      88
                      64 to 55 is a “C”       78
                      54 to 45 is a “D”       70
                       
We have talked about how database administrator make on
average $77,000 per year. We have talked about that it is a
high demand job. Today, I want you to realize that many different
interesting careers use databases.
You may not associate databases with saving animals but the
story you are about to read shows how critical databases are
to endangered animals.
Hopefully the story will motivate you to pay attention when
we talk about sorting and filtering.
Go to achieve 3000. Go to your mailbox.
Click to view the article A Critter Count. Students will read carefully.
The activity questions will be a daily grade. .

DIFFERENT THOUGHT QUESTION: How does the International
Species Information System, ISIS, database help save animals?
Write 2 to 3 sentences.

File:Collared mangabey, mother and child.jpg

Candy Challenge/Extra Credit for Friday’s Test Questions:
1. When the animal database "offers you choices" to click on such as
bats, bears, butterflies what type of data type is it? (Not text)
2. When you click and find the definition of the animal, what data type
is the definition? (Not text)
Independent Exercise:
@ Students will read and answer activity questions and the new thought question.
@ Students will follow the steps to sort and filter their income database.
@ Students will follow the steps to sort and filter their inn database
Higher Order Thinking Questions
How do I decide which criteria to use for my filters?
Student Technology/Differentiation
Students use Access to learn how to sort and filter.
Closure Strategy
EASY Database Vocabulary Review: http://www.quia.com/mc/619996.html

Need to get at least 8 out of 11 correct.

Exit Activity #13:
Reach a million dollars. http://www.quia.com/rr/592937.html

Exit Activity #14:
Database Vocabulary includes math signs: http://www.quia.com/jg/619998.html  
Words we have not covered yet:
Freeze Column- To make the first field stay in place
type a * at the beginning and end of the word-  When searching fields that contain a specific word
type the word with not stars- When searching fields that equal a specific word
remove the filter (Click the Funnel)- To get back to all records from a filter you must

Exit Activity #15:
Database filter words (more than, less than, etc.):  http://www.quia.com/jg/778814.html

Exit Activity #16:
Understanding Database concepts: http://www.quia.com/pop/83136.html?AP_rand=359993708
Must get at least 7 correct out of 10.


Lesson Reflections


No comments:

Post a Comment