Click here if you are a 8th Grade Student http://wclassroom.blogspot.com/2016/11/thursday-december-1st-8th-grade-day-1.html?_sm_au_=iVVspVnDnfNTqN6Q
Click here if you are a 7th Grade Student http://wclassroom.blogspot.com/2016/11/archdale-trinity-middle-school-lesson.html?_sm_au_=iVVspVnDnfNTqN6Q
Wednesday, November 30, 2016
Thursday, December 1st- 7th Grade- What is a function?
 |
Archdale-Trinity Middle School
Lesson Plan
|
Date: 12-01-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.
|
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?
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
@ Spreadsheet flashcard 32 calculates averages
Independent Exercise:
Open up the Hurricane file.
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
@Depending on time several functions examples will be completed.
***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
|
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
|
Thursday, December 1st- 8th Grade- Day 1 of Workplace Behavior Presentations
Archdale-Trinity Middle School
Lesson Plan
| |
Date: 12-01-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)
|
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. 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 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 80 or scroll to the bottom and hit the try again button
Exit Activity 6- https://www.quia.com/quiz/3962470.html
|
Tuesday, November 29, 2016
Wednesday, November 30th- Short Cut Links
Click here if you are a 8th Grade Student http://wclassroom.blogspot.com/2016/11/wednesday-november-30th-8th-grade.html
Click here if you are a 7th Grade Student http://wclassroom.blogspot.com/2016/11/wednesday-november-30th-7th-grade.html
Click here if you are a 7th Grade Student http://wclassroom.blogspot.com/2016/11/wednesday-november-30th-7th-grade.html
Wednesday, November 30th- 7th Grade- Formatting Spreadsheet Data
 |
Archdale-Trinity Middle School
Lesson Plan
|
Date: 11-30-2016
|
Teacher:
|
Witkowski
| |
Lesson/Unit Topic:
|
Spreadsheets- Formatting Data
| |
Standards:
|
SSB-1 Know the components of Spreadsheets
SSB-3 Know spreadsheet operations
|
“I Can…” Statement
|
Criteria for Success-Formative/Summative Assessments
|
I can find and use different features of Excel.
TEST ON TUESDAY |
Students use different features of Excel.
|
Literacy/Vocabulary Strategies (Word Wall)
|
Format table- to give the data in a spreadsheet color and design
 |
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.
3. Go to wclassroom.blogspot.com
|
Lesson-Instructional Strategies & Procedures for Teacher and Students
(Detailed Plans Including Best Practices, Researched Based Strategies)
|
Guided Lesson:
Open car lot file and add the following items to your file:
On your car lot spreadsheet complete the following formatting:
1. choose a "format as table" style,
Skill 7- format table any color, (Home tab- format as table arrow)
Sorting
Make sure you have chosen a "Format as Table" style.
Click on the sort arrow by the price.
We are going to sort the most expensive car.
We are going to sort for the least expensive car.
Click on the sort arrow by the miles.
We are going to sort the car with the most miles.
We are going to sort the car with the least miles.
2. change the color of the 3 tabs,
Skill 23- change color of tabs,
(Right click on tab, click on change color, choose color)
3. create a "thick box" border (any color) around your favorite car,
Skill 31 formatting cells- (highlight car, choose border button)
4. fill in that cell with any color (choose paint bucket)
5. and change the data format in the price column to currency.
Skill 31 formatting cells- change price column to currency
(highlight prices, then click on number format arrow)
6. create data bars of any color in your price field
Skill 13- data bars on price column any color,
(Home tab- Conditional Formatting button)
7. hide the row of the car you like the least
Right click on number of car you do not like and choose hide.
Open the Spreadsheet Vocabulary file
Slides 22 through 34
Independent Activity:
Depending on Time: 1. Miss W will review functions. Open the 1Spreadsheet Vocabulary file
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
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
|
Higher Order Thinking Questions
|
What are the order of operation for a spreadsheet formula?
|
Student Technology/Differentiation
|
Students will use Excel to understand a formula’s order of operation.
|
Closure Strategy
|
|
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
|
Subscribe to:
Posts (Atom)