Tuesday, Nov 4th- 8th Grade- Database- Query Prework Project

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

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

“I Can…” Statement	Criteria for Success-Formative/Summative Assessments
I can recognize ascending and descending order. Test on Friday.	Students know the difference between ascending and descending order.

Literacy/Vocabulary Strategies (Word Wall)

Hashtags are used for Twitter accounts. It is also used as a “number” sign, for example #1. http://commons.wikimedia.org/wiki/File:Hashtag.JPG

Bell-Ringer/Connecting Strategy

On page 76, type lines 10 and 11. We are using our LEFT MIDDLE finger for the # HASHTAG/ NUMBER key We are using our RIGHT PINKY finger for the  SHIFT  key

Guided Lesson: @ Miss W will give instruction on the 6 prework query project Independent Exercise: @Students will complete the 6 query powerpoint If time: @  Students will start on the Sort worksheets. If you miss a question,      you will need to write out the question and the correct answer. 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

When would you want to use boolean connectors?

Student Technology/Differentiation

Students use PowerPoint to review for queries.

Closure Strategy

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.