Saturday, May 30, 2015

Monday, June 1st- 8th Grade- Database Review



Interlocking AT.jpg
Archdale-Trinity Middle School
Lesson Plan
 
Date: 06-01-2015



Teacher:
Witkowski

Lesson/Unit Topic:
Review Database Information

Standards:
DB-1  Know the Use and Purpose of a Database
DB-2  Know Data Types associated with a Database
DB-3  Demonstrate the Management of a Database



“I Can…” Statement
Criteria for Success-Formative/Summative Assessments
I can be creative on my review project and explain the items I missed. Test on Friday.
Students will be creative on their review projects and explain the items they missed.

Literacy/Vocabulary Strategies (Word Wall)
Junction table – a table used to join primary key field from multiple tables.
Which table is the Junction table? ( Users, UserPermissions, or Permissions)
http://commons.wikimedia.org/wiki/File:Junction_Table.svg
Bell-Ringer/Connecting Strategy
On page 127, type lines 23 and 24.

Guided Lesson:
@ Miss W will show 6 Design Review PowerPoints.
@ Miss W will review the 5 steps to create a database powerpoint.
`
Independent Exercise:
@ Students will read and figure out database design for
students will use CrocBITE
the Worldwide Crocodilian Attack Database   http://www.crocodile-attack.info/data/filter-simple
@ Students will have 10 minutes to work together to find the 5 fields needed for the CrockBite database.

@ Complete Review Activity INDIVIDUALLY  Database Definitions
Hints:
A feature that displays records that meet one or more specific
criteria is a filter/query.
Connector words OR and AND
Greater than or equal to

If time: review the Game powerpoint 
http://www.what2learn.com/ks3-ict-databases-game/

Higher Order Thinking Questions
How can you make your Publisher publication interesting to other students?
Student Technology/Differentiation
Students use various software programs to review.
Closure Strategy
Exit Activity #14: Database relationships

Exit Activity #15: Typing Symbols


No comments:

Post a Comment