Monday, December 1, 2014

Monday, Dec. 1st- 8th Grade- Databases- Sort and Filter Review

Interlocking AT.jpg
Archdale-Trinity Middle School
Lesson Plan
 
Date: 12-01-2014



Teacher:
Witkowski

Lesson/Unit Topic:
Database-  Review Sorting and Filtering

Standards:
DB-3 Demonstrate the management of a database



“I Can…” Statement
Criteria for Success-Formative/Summative Assessments
I can sort and filter.
Students remember how to sort and filter.
Literacy/Vocabulary Strategies (Word Wall)
The numeric keypad is to the right of the keyboard.
on a QWERTY keyboard.
http://en.wikipedia.org/wiki/Touch_typing
Bell-Ringer/Connecting Strategy
On page 92, type lines 21 and 22.
These lines are a review of all of the keys you have learned.

Guided Lesson:
@ We are NOT using the typing book for several days.
We are learning the numeric keypad.

Your thumb goes on the 0 at the bottom
Your  index finger on the 4
Your middle finger on the 5
Your ring finger on the 6
Your pinky will hit the plus sign +

The daily bellringers will now be practicing the number pad
Choose exercise 1 and then click on the word "start."
Time will not start until you put your cursor
in the white rectangle and start typing.
Record your typing speed and accuracy in your typing file.

**********************************************
Student will make flashcards for their missed test questions.
**********************************************
@ Student will open new Word document.
    Miss W will show students how to insert a screen print.

@ Students will open their Inn database.

@ Miss W will review sorting and filtering.
   Access 2010: Sorting and Filtering

@ Students will open 9 Independent Practice Filtering and Sorting a Database WORD document.
@ Students will screen print their answers into the 9 Independent Practice document.
@ Students will save the file to their lunch number.  

Independent Exercise:
@ Students may work in pairs
    to complete  9 Independent Practice Filtering and Sorting a Database.
@ Stop at number 8. We will do 8 and 9 together.
@ Make sure you save your work!

IMPORTANT NOTICE!
You must close the database first before you close the access file.
You must click on the inside “x” before you click on the outside “x”
If you don’t close following the above instructions, it will freeze the program.

If absent on Tuesday before Thanksgiving.
@ After the test, Click on https://portal.achieve3000.com/
  • Your user name is your lunch number.
  • Your password is your birthday.
  • Go to the email section and click on article titled "Picture This"
  • The article is about the Graphic Design career.
  • If you miss a question, hit the retry button

Higher Order Thinking Questions
What is the difference between sorting and filtering?
Student Technology/Differentiation
Students use Access to learn about databases.
Closure Strategy
Exit Activity #14:
Words that are new:
Report- display data in a custom format
Field selector- the box containing the field name  



No comments:

Post a Comment