Wednesday, April 15th- 8th Grade- Sorting and Filtering

	Archdale-Trinity Middle School Lesson Plan
Date: 4-15-2015

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 Asterisk sign looks like a star. http://commons.wikimedia.org/wiki/File:Asterisk_TimesNewRoman.png

Bell-Ringer/Connecting Strategy

On page 76, type lines 18 and 19. We are using our right MIDDLE finger for the * asterisk key. We are using our left PINKY finger for the  SHIFT  key

Guided Lesson: @ Students will review vocabulary playing a team game http://www.what2learn.com/ks3-ict-databases-game/ @ Students will correct sorting and math operator mistakes @ Students will create an income database. @ Open the Guided Practice PowerPoint If time: Students will complete the income questions   @ Students will review for Friday’s test. @ Open the Independent  Practice PowerPoint Independent Exercise: @ Students will complete the Inn Filtering and Sorting a Database Questions. Term Definition Filter A tool used to search for specific information within a database.       Filter by selection Filters related to an active cell. Filters for the field or entry that has been sdelected       Filter/Advanced Filter Sort Used to define specific search criteria (what you are looking for) Sort Arranging information in some form of logical order; alphabetical, chronological (by time), numerical. Ascending- A to Z   Descending Z to A Criteria A condition that must be met or not met in a search. Anyone wearing blue.

Higher Order Thinking Questions

How do you decide if you need to sort or if you need to filter?

Student Technology/Differentiation

Students use Access 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 9 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 9 correct out of 10.