Miss Witkowski's Computer Science Discoveries Class: Tuesday, Oct 28th- 8th Grade- Databases- Review for Test- Data types and Field properties

Monday, October 27, 2014

	Archdale-Trinity Middle School Lesson Plan
Date: 10-28-2014

Teacher:	Witkowski
Lesson/Unit Topic:	Databases- Test review & Steps to creating a database
Standards:	DB-2 Know Data Types associated with a database

“I Can…” Statement	Criteria for Success-Formative/Summative Assessments
I can tell the difference between a data type and a field property. Test on Wednesday.	Students know the difference between data types and field properties

Literacy/Vocabulary Strategies (Word Wall)

This genealogy database was designed so the date would be entered

as year-month-day. What type of field property was used?

http://en.wikipedia.org/wiki/Genealogy

Bell-Ringer/Connecting Strategy

On page 72, type lines 10 and 11.

We are using our left INDEX finger for the $ key. DOLLAR SIGN

We are using our right PINKY finger for the SHIFT key

Lesson-Instructional Strategies & Procedures for Teacher and Students

(Detailed Plans Including Best Practices, Researched Based Strategies)

Guided Lesson:

@ Students will review for Wednesday’s test

@ Open Database data types and field property test

@ Data Type and Field Properties PowerPoint

@ Review Steps in Creating a Database

@ Complete both sides of puzzle worksheet

Independent Exercise:

@ Students will use study guide to solve data type crossword puzzle http://worksheets.theteacherscorner.net/puzzle/cw-PXtIPiL/

If time:

until 3:33

@ Students will brainstorm different information needed for the database.

Higher Order Thinking Questions

Why would you want to follow certain steps to create a database?

Student Technology/Differentiation

Students use Access to tell the difference between a data type and a field property.

Closure Strategy

Miss Witkowski's Computer Science Discoveries Class