Saturday, May 30, 2015

Monday, June 1st- Short Cut Links

If you are a 7th Grade Student, click here:   http://wclassroom.blogspot.com/2015/05/monday-june-1st-0-7th-grade-review.html


If you are a 8th Grade Student, click here:   http://wclassroom.blogspot.com/2015/05/monday-june-1st-8th-grade-database.html

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


Monday, June 1st-0 7th Grade- Review PowerPoint Presentation Facts


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



Teacher:
Witkowski

Lesson/Unit Topic:
Review of PowerPoint Presentation Facts

Standards:
PB-1 Characteristics of Content- Appropriate and Inappropriate
PB-2 Procedure for developing a presentation



“I Can…” Statement
Criteria for Success-Formative/Summative Assessments
I can create an interesting presentation.
TEST ON FRIDAY
Students create interesting presentations.


Literacy/Vocabulary Strategies (Word Wall)

Step1 is to determine the purpose of your presentation.
  1. Name one purpose.
  2. Name a different purpose.
  3. Name the last purpose.
4. After you determine your purpose, what is Step 2? It has to do with people.
5. What is Step 3? I has to do with thinking about the main points of your presentation.
6. With Step 4 you can use templates. What is Step 4?
we all have a story to tell
https://www.flickr.com/photos/bushepkjcphotos/5836620513/

Bell-Ringer/Connecting Strategy

On page 127, type lines 23 and 24.
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:
@ Miss W will show six 3 purposes presentations.

Independent Exercise
@ Students will complete any missing work.
@ Students will practice INDIVIDUALLY on review exercises.





Higher Order Thinking Questions

What are the hardest concepts for you to understand?

Student Technology/Differentiation

Students will use online software to review.

Closure Strategy


Play the following PowerPoint review games INDIVIDUALLY:
_______Play until you get all 10 steps correct. http://www.quia.com/rd/198881.html?AP_rand=183590182
______Until the picture shows completely http://www.quia.com/pp/280807.html?AP_rand=1363527069

 






Thursday, May 28, 2015

Friday, May 29th Short Cut Links

If you are a 7th Grade Student, click here:   http://wclassroom.blogspot.com/2015/05/friday-may-29th-7th-grade-spreadsheet.html?_sm_au_=iVVrSZQjTMHMF80N


If you are a 8th Grade Student, click here:   http://wclassroom.blogspot.com/2015/05/friday-may-29th-8th-grade-finding.html?_sm_au_=iVVrSZQjTMHMF80N

Friday, May 29th- 8th Grade- Finding Answers from a database

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



Teacher:
Witkowski

Lesson/Unit Topic:
Database Basics- Finding answers from a database

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 find answers in a database.
Students understand how to use a database to find answers.


Literacy/Vocabulary Strategies (Word Wall)



Bell-Ringer/Connecting Strategy

On page 103, type lines 26 and 27..
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:
@ Miss W will show students how to use a query to find answers in a database.

Independent Exercise
@ 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.

If time: students will use CrocBITE
the Worldwide Crocodilian Attack Database   http://www.crocodile-attack.info/data/filter-simple

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.


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