Monday, Nov. 10th- 8th Grade- Databases- Sorting and Filtering

s

	Archdale-Trinity Middle School Lesson Plan
Date: 11-10-2014

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

“I Can…” Statement	Criteria for Success-Formative/Summative Assessments
I can sort and filter a database.	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 lines 10 and 11. We are using our LEFT RING finger for the @ AT  key. We are using our RIGHT PINKY for the Shift Key.

.Guided Lesson: @ Students will write out the test questions and answers they missed. @ Miss W demonstrate sorting and filtering with the income database. Independent Exercise: @ Students will follow the steps to sort and filter their income database. @ Students will follow the steps to sort and filter their inn database If you did not finish on Friday:   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.