Tuesday, May 19, 2015

Wednesday, May 20th- 8th Grade- Database- Importing Raw Data- Add Commas- No Spaces

Interlocking AT.jpg
Archdale-Trinity Middle School
Lesson Plan
 
Date: 05-20-2015



Teacher:
Witkowski

Lesson/Unit Topic:
Database Basics- Importing Raw Data by adding Commas and no spaces

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 import data. Test on Database Relationships on Tuesday.
Students understand how to import data.


Literacy/Vocabulary Strategies (Word Wall)



Bell-Ringer/Connecting Strategy

On page 95, type lines 3 and 4..
Today’s typing is a general review using all of the alphabetic keystrokes we have learned this semester

Lesson-Instructional Strategies & Procedures for Teacher and Students
(Detailed Plans Including Best Practices, Researched Based Strategies)

Guided Lesson:
@ All students will review the Importing Data PowerPoint
@ Review students will create Publisher and Database vokis

Independent Exercise
@ Students will import RAW data from mystery people file
    Remember: must be formatted AND SAVED as TEXT,
   must be separated at field breaks by ADDING A COMMA (DELIMITATED)
                         NO SPACES
IF TIME:
@ Students will solve Robbery 1 (with teacher) and Robbery 2 (without teacher)
@ Students will create a clue worksheet and trade with a partner.
@ Students will create a query to solve Robbery 3.

Important Dates- Last Grades if you want to improve your final grade.
Design Principles PowerPoint due today, Tuesday, May 19  
Test Corrections or Correction Voki due today, Tuesday, May 19
Database Relationship Words PowerPoint due Thursday, May 21
Final typing improvement test is Tuesday, May 26th
Database Relationships test is Tuesday, May 26th
Mystery Database import/filter is Friday, May 29th
Daily Review Grades from Monday, June 1st  through Thursday, June 4th
Daily typing grade on Thursday, June 4th
Official End of Semester test for this class is Friday, June 5th




Higher Order Thinking Questions

How is a many to many database relationship like a one to many database relationship? How is it different?

Student Technology/Differentiation

Students will Access to understand queries.

Closure Strategy

Exit Activity #14: Database relationships






No comments:

Post a Comment