If you are a 7th Grade Student, click here: http://wclassroom.blogspot.com/2015/05/thursday-may-28th-7th-grade-spreadsheet.html?_sm_au_=iVV3S3P0H7MDns46
If you are a 8th Grade Student, click here: http://wclassroom.blogspot.com/2015/05/wednesday-may-27th-8th-grade-finding.html?_sm_au_=iVV3S3P0H7MDns46
Wednesday, May 27, 2015
Thursday, May 28th- 8th Grade- Importing Data into a Database
 |
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
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
| |
Thursday, May 28th- 7th Grade- Spreadsheet Formatting
 |
Archdale-Trinity Middle School
Lesson Plan
|
Date: 05-28-2015
|
Teacher:
|
Witkowski
| |
Lesson/Unit Topic:
|
Spreadsheet- Formatting
| |
Standards:
|
SSB-1 Know the components of Spreadsheets
SSB-2 Know Spreadsheet operations
|
“I Can…” Statement
|
Criteria for Success-Formative/Summative Assessments
|
I can format spreadsheets
|
Students can format spreadsheets
|
Literacy/Vocabulary Strategies (Word Wall)
| |
You can merge and center titles in Excel.
When you merge cells you take several small cells and make one large cell.
 | |
Bell-Ringer/Connecting Strategy
| |
On page 103, type lines 25 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:
@ Signed interim reports due
@ Miss W will review how to format a spreadsheet.
| |
Independent Exercise:
@ Students will practice formatting skills on the Independent Practice.
If absent on Wednesday:
@ Compare your time to your beginning of the year time! :)
@ Students will complete formula sheet individually
@ Students will complete any missing work:
*** The 3 Purpose PowerPoint
*** The Review Test
*** The Review Test Correction Sentences
*** The Review Test Analysis (which type of question did you miss the most?)
Questions 1 through 8 are Typing Questions
Questions 9 through 15 are PowerPoint Questions
Questions 16 through 25 are Spreadsheet Questions.
| |
Important Dates- Last Grades if you want to improve your final grade.
3 Purpose PowerPoint due today, Tuesday, May 19
Review Test, Thursday, May 21
Test Corrections or Correction Voki due today, Friday, May 22
Final typing improvement test is Tuesday, May 26th
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 does formatting a spreadsheet make it easier to use?
| |
Student Technology/Differentiation
| |
Students will format a spreadsheet
| |
Closure Strategy
| |
Exit Activity 11: Spreadsheet Review
2 items you may have forgotten:
Absolute value- is when you need cells to remain the same when copied
# means the column is too narrow and you need to make it wider to see the data
| |
Tuesday, May 26, 2015
Wednesday, May 27th Short Cut Links
If you are a 7th Grade Student, click here: http://wclassroom.blogspot.com/2015/05/wednesday-may-27th-7th-grade-typing.html?_sm_au_=iVVS1qB56hjHQMN5
If you are a 8th Grade Student, click here: http://wclassroom.blogspot.com/2015/05/wednesday-may-27th-8th-grade-finding.html?_sm_au_=iVVS1qB56hjHQMN5
If you are a 8th Grade Student, click here: http://wclassroom.blogspot.com/2015/05/wednesday-may-27th-8th-grade-finding.html?_sm_au_=iVVS1qB56hjHQMN5
Wednesday, May 27th- 8th Grade- Finding Answers from a Database
 |
Archdale-Trinity Middle School
Lesson Plan
|
Date: 05-27-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 99, type lines 54 and 55..
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
| |
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
| |
Subscribe to:
Posts (Atom)