Wednesday, May 3rd- 7th Grade- Sorting and Ranges

Archdale-Trinity Middle School Lesson Plan
Date: 05-03-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 Week	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 2. Go to Computer- Student Docs- Witkowski folder- Spreadsheet folder- open 1 Spreadsheet Vocabulary file.

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 02 through 10 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 16- Hide and Show Columns (Right click) Skill 21- hide gridlines (Page layout 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 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

Wednesday, May 3rd- 8th Grade- Review for Job Application Process Test

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

Teacher:	Witkowski
Lesson/Unit Topic:	Understand requirements for seeking, gaining, and maintaining employment
Standards:	6.01 Understand skills required for seeking employment

“I Can…” Statement
I can write a thank you note.  TEST  THURSDAY

Literacy/Vocabulary Strategies (Word Wall)

Thank you note  http://bbq-grill-recipes.com/wp-content/uploads/2016/05/thank-you-letter-for-job-interview-gt29qwla.png

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.02 Job Application Process 3. Students will complete exit Activity 3  ON YOUR OWN *** Students will write a thank you note for the character after the interview

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

Guided Lesson:  Miss W will review thank you note information Independent Exercise: *** Students will practice with Exit Activity 3 *** Students will review for THURSDAY's Test https://kahoot.it/#/ Personal Data Harry Potter             Capitalize first letter of first and last name 1265 Owl Street       Capitalize first letter of street name and word street London, NY 23487   Capitalize first letter of city and all of state abbreviation If absent on Tuesday- Complete Thank You Note

Exit Activity 3-  https://www.quia.com/rr/1099635.html   Exit Activity 4-  https://www.quia.com/rr/556835.html           refer to your character resume if needed  Exit Activity 5-  https://www.quia.com/rr/1058377.html?AP_rand=681164521

Tuesday, May 2nd Short Cut Links

Click here if you are a 8th Grade Student       http://wclassroom.blogspot.com/2017/05/tuesday-may-2nd-8th-grade-thank-you.html?_sm_au_=iVV6RRnw4st6045Q

Click here if you are a 7th  Grade Student     http://wclassroom.blogspot.com/2017/05/tuesday-may-2nd-7th-grade-formatting.html?_sm_au_=iVV6RRnw4st6045Q

Tuesday, May 2nd- 7th Grade- Formatting Tables

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

Teacher:	Witkowski
Lesson/Unit Topic:	Spreadsheets- Gathering Data
Standards:	SSB-1 Know the components of Spreadsheets

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

Literacy/Vocabulary Strategies (Word Wall)

Tab, Pie graph, Worksheets http://commons.wikimedia.org/wiki/File:Population_of_Provinces_and_Territories_of_Canada_Pie_Chart.png

Bell-Ringer/Connecting Strategy

1. Go to wclassroom 2. Open your 1 Spreadsheet Vocabulary PowerPoint

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

Guided Lesson: 6th period only @ What if you make a mistake choosing the chart? Open up 9 Chart Types and Styles     --click on the chart     --On the Design tab, click on the Change Chart button --Select a column chart    --On the Design tab, click on the Chart Styles arrow and find the orange/black choice. @Open the "car lot" file found in the Witkowski folder. 7th period only @ Navigating Excel 2010 http://www.gcflearnfree.org/excel2010        http://www.gcflearnfree.org/excel2010/1.2 Independent Activity: 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 Car lot exercise-   1*Open the "car lot" file found in the student docs, Witkowski folder, Spreadsheet folder and save to your lunch number 2*Students will gather data to create a spreadsheet of dream cars that they would have in their own car lot business. 3*Students will go to http://www.carmax.com and find cars and write the information (year, make(brand), model(name), miles, and price) on their worksheet. 4* Students will write information on their car lot worksheet.

Higher Order Thinking Questions

Which tab will be used for the different formatting activity and why?

Student Technology/Differentiation

Students will use http://www.carmax.com to research different car statistics.

Closure Strategy

Must complete in 40 seconds or less Exit Activity #9:  Ribbon Vocabulary words review words and definitions here http://quizlet.com/3089570/flashcards then play activity here http://quizlet.com/3089570/scatter Exit Activity: Uses of Spreadsheets http://www.quia.com/mc/2494317.html

Tuesday, May 2nd- 8th Grade- Thank You Notes and Review for Thursday's Test

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

Teacher:	Witkowski
Lesson/Unit Topic:	Understand requirements for seeking, gaining, and maintaining employment
Standards:	6.01 Understand skills required for seeking employment

“I Can…” Statement
I can write a thank you note.  TEST  ON THURSDAY

Literacy/Vocabulary Strategies (Word Wall)

Thank you note  http://bbq-grill-recipes.com/wp-content/uploads/2016/05/thank-you-letter-for-job-interview-gt29qwla.png

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.02 Job Application Process 3. Students will complete exit Activity 3

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

Guided Lesson:  Miss W will review thank you note information Independent Exercise: *** Students will practice with Exit Activity 3 *** Students will write a thank you note for the character after the interview or if there is not enough time students will complete their blue data sheets. *** Students will review for THURSDAY'S TEST https://kahoot.it/#/   If you didn't finish Monday's Work *** Go to Computer- Student Docs- Witkowski folder- Exploring Business folder then Employment folder- then open 6.02 Job Interview file Add 2 APPROPRIATE clip art pictures that MAKE SENSE for the definitions for each slide in the 6.02 Job Interview PowerPoint. If you were absent on Thursday: Review of Resume Assignment: @ Students will create a character resume for a fictional character from a book, movie,      tv show or video game. Do NOT use my Harry Potter example. https://www.quia.com/files/quia/users/egrahamj1/Character-Resume-  Personal Data Harry Potter             Capitalize first letter of first and last name 1265 Owl Street       Capitalize first letter of street name and word street London, NY 23487   Capitalize first letter of city and all of state abbreviation

Exit Activity 3-  https://www.quia.com/rr/1099635.html   Exit Activity 4-  https://www.quia.com/rr/556835.html           refer to your character resume if needed  Exit Activity 5-   https://www.quia.com/rr/1058377.html?AP_rand=681164521