Monday, April 20th- 8th Grade- Database Filters and Test Review

	Archdale-Trinity Middle School Lesson Plan
Date: 04-20-2015

Teacher:	Witkowski
Lesson/Unit Topic:	Databases- Sorting and Filtering and Review for Test
Standards:	DB-3 Demonstrate the management of databases

“I Can…” Statement	Criteria for Success-Formative/Summative Assessments
I can sort and filter a database. Test on Tuesday!	Students sort and filter a database.

Literacy/Vocabulary Strategies (Word Wall)

The @ symbol means “AT” and is used in email addresses. The symbol is also used to express amounts in invoices (bills). For example, 2 items @ $1.99 each. http://commons.wikimedia.org/wiki/File:P_At_sign.png

Bell-Ringer/Connecting Strategy

On page 80, type line 12. We are using our LEFT RING finger for the @ AT  key. We are using our RIGHT PINKY for the Shift Key. This line is harder so we are only doing one line today. Make sure your spacing is correct!

.Guided Lesson: @ Miss W demonstrate sorting and filtering with the inn database. @ Students will review for Tuesday’s test. Study guides available. Independent Exercise: @ Students will follow the steps to sort and filter their inn database @ Students will review for Tuesday’s test. @ Exit Activity 15 If absent on Friday or if you did not finish (see board) @ Achieve 3000 Database Career article. 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. http://commons.wikimedia.org/wiki/File:Collared_mangabey,_mother_and_child.jpg

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

Exit Activity #11: EASY Database Vocabulary Review: http://www.quia.com/mc/619996.html Exit Activity #12: Database words-  http://www.quia.com/hm/671677.html?AP_rand=461255884&playHTML=1 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.