Friday, May 5th- 7th Grade- Using Functions

Archdale-Trinity Middle School Lesson Plan
Date: 05-05-2017

Teacher:	Witkowski
Lesson/Unit Topic:	Spreadsheets- Functions- built in calculation short cuts
Standards:	SSB-1 Know the components of spreadsheets SSB-3 Know spreadsheet operations

“I Can…” Statement	Criteria for Success-Formative/Summative Assessments
I can use a function.	Students use functions to get answers.

Literacy/Vocabulary Strategies (Word Wall)

What if we had 30 years of data and we wanted to find the highest or MAXIMUM number in the data? We could look at thousands of numbers or we could use the MAX function. http://en.wikipedia.org/wiki/Solar_maximum

Bell-Ringer/Connecting Strategy

Go to wclassroom.blogspot.com Go to My computer- student docs- Witkowski folder- Spreadsheet folder- Open up 1 Spreadsheet vocabulary

Lesson-Instructional Strategies & Procedures for Teacher and Students (Detailed Plans Including Best Practices, Researched Based Strategies)

Guided Lesson: We typed out a formula =F2+F3+F4+F5 and then we type out function to see how functions are shortcuts. =Sum(F2:F5) It is important to understand the parts of a function (equals sign, function name, parentheses, beginning of the range, colon, ending of the range and parentheses). Open the Understanding Functions Word document (if needed) Open up the "Functions goes with youtube" file. Excel 2010 Tutorial- Functions https://www.youtube.com/watch?v=b3q1ch-CGto 1 min to 3 min Functions 3 mins to 4:30 mins Range 4:30 mins to 8:30 mins Practice Stop at Count function at 8:30 mins Open the Spreadsheet Vocabulary file Slides 35 through 41 (functions) Open up the 4.0 Payroll file. Class practice 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 Independent Activity: @ Spreadsheet flashcard 32 calculates averages @ Additional function practice as needed. @ Complete Car Lot Exercise

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 #10: http://www.quia.com/rr/363962.html Work with partners. You may use the Spreadsheet Vocabulary PowerPoint. Play until you have won a million dollars Exit Activity#11: Working in pairs and using the PINK Study Guide answer the questions. These will be the next test questions.   http://www.quia.com/hm/174125.html?AP_rand=19139139&playHTML=1

Friday, May 5th- 8th Grade- Good Workplace Behavior

Archdale-Trinity Middle School Lesson Plan
Date: 05-05-2017

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)

Punctuality- arriving on time or before the stated time.    https://thumbs.dreamstime.com/x/punctuality-concept-businesswoman-businessman-looking-50330901.jpg

Bell-Ringer/Connecting Strategy

1.  Go to wclassroom.blogspot.com  2. Get out Blue Data Papers and Update with test score

Lesson-Instructional Strategies and Procedures for Teacher and Students (Detailed Plans Including Best Practices, Researched Based Strategies)

Guided Lesson:  Go to Computer- Student Docs- Witkowski folder- Exploring Business folder-     Employment folder- open 6.03 Being a Good Employee 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: @ Decide on project and start to plan 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 skit demonstrating the 12 behaviors (up to 3 person project)       Dialog must be written.      Must use all 12 behaviors.      Spelling must be correct  C. 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. D.  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. E. 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. F. Other Activity with Teacher Approval

You need to get at least a 60 or scroll to the bottom and hit the try again button  Exit Activity 6-  https://www.quia.com/quiz/3962470.html

Thursday, May 4th Short Cut Links

Click here if you are a 8th Grade Student        http://wclassroom.blogspot.com/2017/05/thursday-may-4th-8th-grade-job.html?_sm_au_=iVVfFTkPNQH64HJ6 

Click here if you are a 7th  Grade Student       

http://wclassroom.blogspot.com/2017/05/thursday-may-4th-7th-grade-functions.html?_sm_au_=iVVfFTkPNQH64HJ6

Thursday, May 4th- 7th Grade- Functions and Formatting

Archdale-Trinity Middle School Lesson Plan
Date: 05-04-2017

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 http://commons.wikimedia.org/wiki/File:Divers_ascending_at_shotline_labeled.png

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: Skill 1 ascending order (Home tab) Skill 16- Hide and Show Columns (Right click) Skill 21- hide gridlines (Page layout tab) Independent Exercise: Open your "car lot" file and complete up to car 10 Open the Spreadsheet Vocabulary file 1. Miss W will review functions 2. Open a new Excel spreadsheet In F2 type 20 In F3 type 30 In F4 type 40 In F5 type 50 In F6 type 60 We will type out a formula =F2+F3+F4+F5+F6 and then we type out function to see how functions are shortcuts. =Sum(F2:F6) It is important to understand the parts of a function (equals sign, function name, parentheses, beginning of the range, colon, ending of the range and parentheses). Open the Understanding Functions Word document Open up the "3 Function practice independent activity” . Excel 2010 Tutorial- Functions https://www.youtube.com/watch?v=b3q1ch-CGto 1 min to 3 min Functions 3 mins to 4:30 mins Range 4:30 mins to 8:30 mins Practice Stop at Count function at 8:30 mins Slides 34 (functions- built in calculations) through 40 Answer questions 20 through 23 If time: Skill 4- sparklines(insert),  Skill 20- icon sets (under conditional formatting) Skill 2- color scales (under conditional formatting)

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 Exit Activity #10: http://www.quia.com/rr/363962.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

Thursday, May 4th- 8th Grade- Job Application Process Test and Start Being a Good Employee Unit

Archdale-Trinity Middle School Lesson Plan
Date: 05-04-2017

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 TODAY

Literacy/Vocabulary Strategies (Word Wall)

Punctuality- arriving on time or before the stated time.    https://thumbs.dreamstime.com/x/punctuality-concept-businesswoman-businessman-looking-50330901.jpg

Bell-Ringer/Connecting Strategy

1.  Go to wclassroom.blogspot.com  2.  Exit Activity 5-  https://www.quia.com/rr/1058377.html?AP_rand=681164521 3. 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: @ Take Job Application Process Test 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 skit demonstrating the 12 behaviors (up to 3 person project)       Dialog must be written.      Must use all 12 behaviors.      Spelling must be correct  C. 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. D.  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. E. 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. F. Other Activity with Teacher Approval

Exit Activity 5-  https://www.quia.com/rr/1058377.html?AP_rand=681164521 You need to get at least a 60 or scroll to the bottom and hit the try again button  Exit Activity 6-  https://www.quia.com/quiz/3962470.html

Wednesday, May 3rd- Short Cut Links

Click here if you are a 8th Grade Student         http://wclassroom.blogspot.com/2017/05/wednesday-may-3rd-8th-grade-review-for.html?_sm_au_=iVVDR0f8RHfMNWjR

Click here if you are a 7th  Grade Student       http://wclassroom.blogspot.com/2017/05/wednesday-may-3rd-7th-grade-sorting-and.html?_sm_au_=iVVDR0f8RHfMNWjR