Click here if you are a 7th Grade Student http://wclassroom.blogspot.com/2017/04/monday-may-1st-7th-grade-what-if.html?_sm_au_=iVVD8jj08RtRFkM6
Friday, April 28, 2017
Monday, May 1st- Short Cut Links
Click here if you are a 8th Grade Student http://wclassroom.blogspot.com/2017/04/monday-may-1st-8th-grade-job-interview.html?_sm_au_=iVVD8jj08RtRFkM6
Monday, May 1st- 7th Grade- What If Activity and Charts
Archdale-Trinity Middle School
Lesson Plan
| |
Date: 05-01-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 create and change a chart.
|
Students use different features of Excel.
|
Literacy/Vocabulary Strategies (Word Wall)
|
Tab, Pie graph, Worksheets
 |
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:
@ Navigating Excel 2010 http://www.gcflearnfree.org/excel2010
“Spreadsheet Vocabulary PowerPoint Presentation”
describing uses of worksheets and tabs (slide 10)
Students will complete WHAT IF activity (slides 11-12)
Students will learn about bar, line and pie graphs (slides 13-17)
Open the 1 Spreadsheet Vocabulary file
Go through Slide 20 Parts of a Spreadsheet In the Witkowski folder then the Spreadsheet folder
@ Go to the SS flash card folder and open up 23 change color of tabs
This is an example of a workbook with 12 worksheets.
@ Open up 22 Pie Chart.
This is an example of the Insert tab and then the Design tab (chart layouts)
@ 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.
Independent Activity:
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.
If time:
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
|
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 45 seconds or less
Exit Activity #9: Ribbon Vocabulary words
review words and definitions here http://quizlet.com/3089570/flashcards
|
Monday, May 1st- 8th Grade- Job Interview Tips
Archdale-Trinity Middle School
Lesson Plan
| |
Date: 05-01-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 create a cover letter.
I can complete a job application.
TEST Tuesday or Wednesday
|
Literacy/Vocabulary Strategies (Word Wall)
|
Job Application
https://cdn.job-applications.com/images/application-mcdonalds.gif
|
Bell-Ringer/Connecting Strategy
|
1. Go to wclassroom.blogspot.com
2. Exit Activity 1 |
Lesson-Instructional Strategies and Procedures for Teacher and Students
(Detailed Plans Including Best Practices, Researched Based Strategies)
|
Guided Lesson:
Miss W will review interview information
*** Go to Computer- Student Docs- Witkowski folder- Exploring Business folder
then Employment folder- then open 6.02 Job Interview file SAVE to your lunch number Independent Exercise: *** Complete job interview visual powerpoint
Add 2 APPROPRIATE clip art pictures that MAKE SENSE for the definitions
for each slide in the 6.02 Job Interview PowerPoint.
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 1- Parts of a Resume https://www.quia.com/rd/277327.html?AP_rand=5466997
Exit Activity 2- Resume- hangman- https://www.quia.com/hm/453291.html
Exit Activity 3- https://www.quia.com/rr/
Exit Activity 4- https://www.quia.com/rr/
refer to your character resume if needed
Exit Activity 5- https://www.quia.com/rr/
|
Thursday, April 27, 2017
Friday, April 28th Short Cut Links
Click here if you are a 8th Grade Student http://wclassroom.blogspot.com/2017/04/friday-april-28th-8th-grade-update-blue.html
Click here if you are a 7th Grade Student http://wclassroom.blogspot.com/2017/04/friday-april-28th-7th-grade-update-blue.html
Friday, April 28th- 7th Grade- Update Blue Data Sheets and Spreadsheet Careers
Archdale-Trinity Middle School
Lesson Plan
| |
Date: 04-28-2017
|
Teacher:
|
Witkowski
| |
Lesson/Unit Topic:
|
Spreadsheet- What are Spreadsheets? Careers?
| |
Standards:
|
SSB-1 Know the components of Spreadsheets
|
“I Can…” Statement
|
Criteria for Success-Formative/Summative Assessments
|
I can explain what a Spreadsheet is.
I can list examples of Spreadsheets.
|
Students understand what a Spreadsheet is and can list different examples.
|
Literacy/Vocabulary Strategies (Word Wall)
|
Engineers use spreadsheet to build items."Isolated foundation are mostly used for columns and frame structure to transfer point load on a larger area depending on the soil bearing capacity. It also includes the ground water level effect on the foundation load and soil pressure."
 |
Bell-Ringer/Connecting Strategy
|
1. Open Spreadsheet PowerPoint
2. Get out Blue Data Sheets
|
Lesson-Instructional Strategies & Procedures for Teacher and Students
(Detailed Plans Including Practices, Researched Based Strategies)
|
Guided Lesson:
Miss W will explain Spreadsheet Career Charade Rules.
Independent Exercise:
Who uses spreadsheets? Uses of spreadsheets http://www.teach-ict.com/gcse_new/spreadsheets/spreadsheets/miniweb/pg9.htm
Charades- each group of three will have 3 minutes to come up with a
way to act out one of the people below using spreadsheets.
They can say anything but the name of the person.
For example: They can not say "Look at me, I'm an accountant."
Accountants, Teachers,
Engineers, Sales people,
Scientists, Supermarkets,
Market Researchers.
@ Navigating Excel 2010 http://www.gcflearnfree.org/excel2010
“Spreadsheet Vocabulary PowerPoint Presentation”
describing uses of worksheets and tabs (slide 10)
Complete Exit Activity 1 |
Higher Order Thinking Questions
|
What type of activities benefit from using a spreadsheet?
|
Closure Strategy
|
We have not covered some questions 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
|
Friday, April 28th- 8th Grade- Update Blue Data Sheets and Begin Job Applications
Archdale-Trinity Middle School
Lesson Plan
| |
Date: 04-28-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 create a cover letter.
I can complete a job application.
TEST NEXT Tuesday or Wednesday
|
Literacy/Vocabulary Strategies (Word Wall)
|
Job Application
https://cdn.job-applications.com/images/application-mcdonalds.gif
|
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. Get out Blue Data sheets
|
Lesson-Instructional Strategies and Procedures for Teacher and Students
(Detailed Plans Including Best Practices, Researched Based Strategies)
|
Guided Lesson:
Miss W will review job application information Miss W will review interview information Independent Exercise: *** Update Blue Data Sheets
*** Complete job application
If time:
*** 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.
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 1- Parts of a Resume https://www.quia.com/rd/277327.html?AP_rand=5466997
Exit Activity 2- Resume- hangman- https://www.quia.com/hm/453291.html
Exit Activity 3- https://www.quia.com/rr/
Exit Activity 4- https://www.quia.com/rr/
refer to your character resume if needed
Exit Activity 5- https://www.quia.com/rr/
|
Subscribe to:
Posts (Atom)