Wednesday, May 27, 2015

Thursday, May 28th- 8th Grade- Importing Data into a Database

Interlocking AT.jpg
Archdale-Trinity Middle School
Lesson Plan
 
Date: 05-28-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.
Students understand how to import data.


Literacy/Vocabulary Strategies (Word Wall)



Bell-Ringer/Connecting Strategy

On page 103, type lines 24 and 25..
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:
@ Open the Importing Data PowerPoint

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 absent on Tuesday:
*** Students will take the Database Relationship test
***@ Students will take a typing test at http://www.typingtest.com to get their  words per minute.

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

Lesson Reflections




No comments:

Post a Comment