Tuesday, April 14, 2015

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

Interlocking AT.jpg
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.
File:Asterisk TimesNewRoman.
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
EASY Database Vocabulary Review: http://www.quia.com/mc/619996.html

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.





No comments:

Post a Comment