Tuesday, November 29, 2016

Wednesday, November 30th- 8th Grade- Finish Appropriate Work Behavior Projects

Archdale-Trinity Middle School
Lesson Plan

Date: 11-30-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 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 will only have today (Wednesday) to complete the project.
If your partner is absent, you will need to complete the project.
On Thursday and Friday, the projects will be presented to the class.  
On Thursday, students going on Friday's field trip will present first.
You need to get at least a 70 or scroll to the bottom and hit the try again button

Monday, November 28, 2016

Tuesday, November 29th Short Cut Links

Click here if you are a 8th Grade Student  http://wclassroom.blogspot.com/2016/11/tuesday-november-29th-8th-grade-begin.html?_sm_au_=iVVD6rqPFQ01JS26

Click here if you are a 7th Grade Student  http://wclassroom.blogspot.com/2016/11/tuesday-november-29th-7th-grade-sorting.html?_sm_au_=iVVD6rqPFQ01JS26

Tuesday, November 29th- 7th Grade- Sorting, Ascending and Descending Order

Interlocking AT.jpg
Archdale-Trinity Middle School
Lesson Plan
 
Date: 11-29-2016


Teacher:
Witkowski

Lesson/Unit Topic:
Spreadsheets- Cell References and Sorting

Standards:
SSB-1 Know the components of Spreadsheets


“I Can…” Statement
Criteria for Success-Formative/Summative Assessments
I can find and use different features of Excel. TEST NEXT TUESDAY
Students use different features of Excel.


Literacy/Vocabulary Strategies (Word Wall)
Range, Cell Reference, Sorting, Ascending- to go up, Descending
File:Divers ascending at
Bell-Ringer/Connecting Strategy
1. Go to Computer- then your LUNCH number- then open Copy of Car Lot

3. Go to Computer- Student Docs- Witkowski folder- Spreadsheet folder-
open 1 Spreadsheet Vocabulary file.
4. Go to wclassroom.blogspot.com
Lesson-Instructional Strategies & Procedures for Teacher and Students
(Detailed Plans Including Best Practices, Researched Based Strategies)
Guided Lesson:

Open the Spreadsheet Vocabulary file
Slides 19 through 24   (Range, Cell Reference, Sorting)  

@Practice ascending and descending order



Independent Exercise:
Open your "car lot" file and type in cars 11 through 16

Open the Spreadsheet Vocabulary file
Slides 25 through 30   (PEMDAS)  
Do the PEMDAS activity- Slide 26 (order of operations in a spreadsheet formula)

Skill 1 ascending order (Home tab)
Skill 21- hide gridlines (Page layout tab)
Skill 22- pie chart (chart tools then design tab),  
Skill 4- sparklines(insert), 
Skill 20- icon sets (under conditional formatting)
Skill 2- color scales (under conditional formatting)


Cell Reference and Range Activity
Follow instructions to make a picture.

Make cell C5 to C8 yellow

Make D5 to D8 yellow

Make cell F5 to F8 yellow

Make cell G5 to G8 yellow

Now click on C6 make it black

Then click on F6 and make it black

Cell E11 green

Cell B12 to B13 red

Cell I11 to  I12 red

Cell C14 red

Cell D15 red

Cell E16 red

Cell F15 red

Cell G14 red

Cell H13 red

Higher Order Thinking Questions
How do cell references help navigate a spreadsheet?
Student Technology/Differentiation
Students will use Excel to understand cell references.
Closure Strategy

Exit Activity: Uses of Spreadsheets http://www.quia.com/mc/2494317.html


We have not covered one question yet.
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

Tuesday, November 29th- 8th Grade- Begin Appropriate Behavior in the Work Place Project

Archdale-Trinity Middle School
Lesson Plan

Date: 11-29-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.


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


3. Students need a pen or pencil
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 read in pairs:
Students will complete the Appropriate Work Place Behavior Worksheet
Definitions are on the back of the worksheet or you can look at PowerPoint 6.03  


 Decide which PROJECT Activity you want to complete.

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
     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.
     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 will only have 2 days (Today and Wednesday) to complete the project.
If your partner is absent, you will need to complete the project.
On Thursday and Friday, the projects will be presented to the class.  

Sunday, November 27, 2016

Monday, November 28th Short Cut Links

Click here if you are a 8th Grade Student  http://wclassroom.blogspot.com/2016/11/monday-november-28th-8th-grade.html

Click here if you are a 7th Grade Student  http://wclassroom.blogspot.com/2016/11/monday-november-28th-7th-grade.html

Monday, November 28th- 7th Grade- Formatting a Chart

Archdale-Trinity Middle School
Lesson Plan
 
Date: 11-28-2016


Teacher:
Witkowski

Lesson/Unit Topic:
Spreadsheets- Values versus Labels and Cell References

Standards:
SSB-1 Know the components of Spreadsheets


“I Can…” Statement
Criteria for Success-Formative/Summative Assessments
I can format a spreadsheet chart
Students use different features of Excel.

Literacy/Vocabulary Strategies (Word Wall)
Range, Cell Reference, Sorting, Ascending, Descending
File:Divers ascending at
Bell-Ringer/Connecting Strategy
Go to Computer- Student Docs- Witkowski folder- Spreadsheet folder
then go to the SS flashcards folder- then open 7 format table
Lesson-Instructional Strategies & Procedures for Teacher and Students
(Detailed Plans Including Best Practices, Researched Based Strategies)
Guided Lesson:
 
Miss W will review slides 1 - 17 and explain the new slides.
 
1. Open the SS flashcard folder

SS Flash cards file
Open 7 Format Table    (format as table button)
SS Flash cards file  (conditional formatting button)
Open 13 Data Bars

SS Flash cards file   (border button and percent button)
Open 31 Formatting Cells

@ Open 19 Hide Worksheet
    - right click on tab and choose hide
    - right click on tabs before and after the hidden tab and choose unhide.

@ Open 16 Hide and Show Rows
    -right click on row number and choose unhide.
- highlight row before and row after the hidden row
    and then right click and choose unhide.

If absent on Friday: Go to Carmax.com and finish finding 15 cars.
Open your Car Lot file and key in the first 7 cars.

If time: Cell Reference and Range Activity
Follow instructions to make a picture.

Make cell C5 to C8 yellow

Make D5 to D8 yellow

Make cell F5 to F8 yellow

Make cell G5 to G8 yellow

Now click on C6 make it black

Then F6 and make it black

Cell E11 green

Cell B12 B13 red

Cell I11 I12 red

Cell C14 red

Cell D15 red

Cell E16 red

Cell F15 red

Cell G14 red

Cell H13 red
 
Higher Order Thinking Questions
How do cell references help navigate a spreadsheet?
Student Technology/Differentiation
Students will Excel to understand cell references.
Closure Strategy
Exit Activity: Uses of Spreadsheets http://www.quia.com/mc/2494317.html