Sunday, December 4, 2016

Monday, December 5th- 7th Grade- Review for Spreadsheet Formatting Test

Interlocking AT.jpg
Archdale-Trinity Middle School
Lesson Plan
 
Date: 12-05-2016


Teacher:
Witkowski

Lesson/Unit Topic:
Spreadsheets- What is a function

Standards:
SSB-1 Know the components of Spreadsheets


“I Can…” Statement
Criteria for Success-Formative/Summative Assessments
I can use a function.

Test on Tuesday
Students use functions to get answers.


Literacy/Vocabulary Strategies (Word Wall)
What if we wanted to find the AVERAGE of a group of numbers?
What would the function look like?
GUIMark: 4.45 fps average
https://www.flickr.com/photos/schoschie/2959139599/
Bell-Ringer/Connecting Strategy
Go to wclassroom.blogspot.com
Lesson-Instructional Strategies & Procedures for Teacher and Students
(Detailed Plans Including Best Practices, Researched Based Strategies)
Guided Lesson:
Review for Tuesday's test
*Open test 1 PowerPoint
*Give out study guides

https://kahoot.it/#/
 

Independent Exercise:

@ Jeopardy Game if time

@ Open up your car lot file.
Look at the board and add the words (labels) sum, max, min and average.
Insert the functions sum, max, min and average.
Remember you will need to use the correct range.



Higher Order Thinking Questions
When and how should you use a function?
Student Technology/Differentiation
Students will use Excel to understand functions.
Closure Strategy
Exit Activity 1: Uses of Spreadsheets http://www.quia.com/mc/2494317.html


Remember:
Built in calculations are called functions.
Horizontal is like laying down flat on the ground.
Vertical is up and down
You may use the Spreadsheet Vocabulary PowerPoint.
Play until you have won a million dollars

Monday, December 5th- 8th Grade- Review for Tuesday's Test

Archdale-Trinity Middle School
Lesson Plan

Date: 12-05-2016


Teacher:
Witkowski

Lesson/Unit Topic:
Understand requirements for seeking, gaining, and maintaining employment

Standards:
6.03 Understand behaviors required to maintain employment


“I Can…” Statement

I can explain appropriate workplace behaviors. 
Test on Tuesday


Literacy/Vocabulary Strategies (Word Wall)
Bell-Ringer/Connecting Strategy
      
1.  Go to wclassroom.blogspot.com 

2. Go to Computer- Student Docs- Witkowski folder- Exploring Business folder-
    Employment folder- open 6.03 Being a Good Employee
Lesson-Instructional Strategies and Procedures for Teacher and Students
(Detailed Plans Including Best Practices, Researched Based Strategies)
Guided Lesson: 
Miss W will review how to be a good employee by understanding appropriate workplace behavior and having a work ethic by reviewing PowerPoint.

Independent Exercise:
Students will present their Workplace Behavior Projects
Students will finish Appropriate Work Behavior Projects

 If time Jeopardy game

PROJECT Activity Rubrics

For each of the projects listed below you will need to choose:
3 appropriate workplace behaviors
3 ethical behaviors
3 unethical behaviors
3 benefits of good workplace behavior



A. Create a crossword puzzle and a word maze about 12 of the behaviors.
     Must use all 12 behaviors.
     Spelling must be correct for crossword and word maze
     Crossword definitions need to be  complete sentences
     Maze needs to include shorter definitions along with the words
     Maze needs word and definition list

B. Create a Kahoot game about 12 of the behaviors.
     Must use all 12 behaviors.
     Spelling must be correct
     Questions begin with a capital letter and end with a question mark?
     Must have 4 answer choices for each question. 

C. Create a skit demonstrating the 12 behaviors (up to 3 person project) 
     Dialog must be written.
     Must use all 12 behaviors.
     Spelling must be correct 

D. Create a student survey about the vocabulary words, have students take survey and graph results
     Must use all 12 behaviors.
     Spelling must be correct
     Spreadsheet must have 12 worksheets, labels and a chart for each of the behaviors.

E.  Create a comic strip with at least 24 panels telling a story about 12 of the behaviors.
     Must use all 12 behaviors.
     Spelling must be correct
     Must have appropriate drawings.
     Must make sense.

F. Create a PowerPoint showing famous people displaying 12 of the behaviors.
     No copy and paste, it must be in your own words why the picture displays the behavior.  Do NOT type just definitions.
     Must use all 12 behaviors.
     Spelling must be correct
     Must have at least one animation and transition per slide
     Include a title slide with your name and the title "Work Place Behaviors"
     If Internet pictures are used you need to have web site citations.

You need to get at least a 100 or scroll to the bottom and hit the try again button

Thursday, December 1, 2016

Friday, December 2nd Short Cut Links

Click here if you are a 8th Grade Student   http://wclassroom.blogspot.com/2016/12/friday-december-2nd-8th-grade-finish.html?_sm_au_=iVVtJ5Fj4G740SZj

Click here if you are a 7th Grade Student      http://wclassroom.blogspot.com/2016/12/friday-december-2nd-7th-grade-using.html?_sm_au_=iVVtJ5Fj4G740SZj

Friday, December 2nd- 7th Grade- Using Functions

Interlocking AT.jpg
Archdale-Trinity Middle School
Lesson Plan
 
Date: 12-02-2016


Teacher:
Witkowski

Lesson/Unit Topic:
Spreadsheets- What is a function

Standards:
SSB-1 Know the components of Spreadsheets


“I Can…” Statement
Criteria for Success-Formative/Summative Assessments
I can use a function.

Test on Tuesday
Students use functions to get answers.

Literacy/Vocabulary Strategies (Word Wall)
What if we wanted to find the AVERAGE of a group of numbers?
What would the function look like?
GUIMark: 4.45 fps average
https://www.flickr.com/photos/schoschie/2959139599/
Bell-Ringer/Connecting Strategy
Go to wclassroom.blogspot.com
Lesson-Instructional Strategies & Procedures for Teacher and Students
(Detailed Plans Including Best Practices, Researched Based Strategies)
Guided Lesson:

@ Function as a shortcut example
@ What are functions? http://www.gcflearnfree.org/excel2010/10.2  until 2:54
@ Autosum button http://www.gcflearnfree.org/excel2010/10.4 examples of functions
@ Spreadsheet flashcard 32 calculates averages

Independent Exercise:
Open up the Hurricane file. We are finishing it today.
Class practice of Hurricane sheet using  functions
We are going to practice inserting the following FUNCTIONS or shortcuts:
Sum- adds all of the numbers in a range
Max- finds the largest number in a range
Min- finds the lowest number in a range
Average- calculates the average of a range of numbers
Count- counts the numbers of entries in a range


@Finish payroll functions.
 ***Students will open the payroll file and by using functions
        find the following information:
        the maximum hourly rate
        the minimum hourly rate
        the sum of the hourly rates
        the average of the hourly rates

@ Open up your car lot file.
Look at the board and add the words (labels) sum, max, min and average.
Insert the functions sum, max, min and average.
Remember you will need to use the correct range.



Higher Order Thinking Questions
When and how should you use a function?
Student Technology/Differentiation
Students will use Excel to understand functions.
Closure Strategy
Exit Activity 1: Uses of Spreadsheets http://www.quia.com/mc/2494317.html


Remember:
Built in calculations are called functions.
Horizontal is like laying down flat on the ground.
Vertical is up and down
You may use the Spreadsheet Vocabulary PowerPoint.
Play until you have won a million dollars

Friday, December 2nd- 8th Grade- Finish Appropriate Job Behavior Presentations

Archdale-Trinity Middle School
Lesson Plan

Date: 12-02-2016


Teacher:
Witkowski

Lesson/Unit Topic:
Understand requirements for seeking, gaining, and maintaining employment

Standards:
6.03 Understand behaviors required to maintain employment


“I Can…” Statement

I can explain appropriate workplace behaviors. 
Test on next Tuesday


Literacy/Vocabulary Strategies (Word Wall)
Bell-Ringer/Connecting Strategy
      
1.  Go to wclassroom.blogspot.com 

2. Go to Computer- Student Docs- Witkowski folder- Exploring Business folder-
    Employment folder- open 6.03 Being a Good Employee
Lesson-Instructional Strategies and Procedures for Teacher and Students
(Detailed Plans Including Best Practices, Researched Based Strategies)
Guided Lesson: 
Miss W will review how to be a good employee by understanding appropriate workplace behavior and having a work ethic.

Independent Exercise:
Students will present their Workplace Behavior Projects
Students will finish Appropriate Work Behavior Projects

 PROJECT Activity Rubrics

For each of the projects listed below you will need to choose:
3 appropriate workplace behaviors
3 ethical behaviors
3 unethical behaviors
3 benefits of good workplace behavior



A. Create a crossword puzzle and a word maze about 12 of the behaviors.
     Must use all 12 behaviors.
     Spelling must be correct for crossword and word maze
     Crossword definitions need to be  complete sentences
     Maze needs to include shorter definitions along with the words
     Maze needs word and definition list

B. Create a Kahoot game about 12 of the behaviors.
     Must use all 12 behaviors.
     Spelling must be correct
     Questions begin with a capital letter and end with a question mark?
     Must have 4 answer choices for each question. 

C. Create a skit demonstrating the 12 behaviors (up to 3 person project) 
     Dialog must be written.
     Must use all 12 behaviors.
     Spelling must be correct 

D. Create a student survey about the vocabulary words, have students take survey and graph results
     Must use all 12 behaviors.
     Spelling must be correct
     Spreadsheet must have 12 worksheets, labels and a chart for each of the behaviors.

E.  Create a comic strip with at least 24 panels telling a story about 12 of the behaviors.
     Must use all 12 behaviors.
     Spelling must be correct
     Must have appropriate drawings.
     Must make sense.

F. Create a PowerPoint showing famous people displaying 12 of the behaviors.
     No copy and paste, it must be in your own words why the picture displays the behavior.  Do NOT type just definitions.
     Must use all 12 behaviors.
     Spelling must be correct
     Must have at least one animation and transition per slide
     Include a title slide with your name and the title "Work Place Behaviors"
     If Internet pictures are used you need to have web site citations.

You need to get at least a 90 or scroll to the bottom and hit the try again button