Monday, May 8, 2017

Tuesday, May 9th- 7th Grade- Formatting Spreadsheets

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


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 THURSDAY
Students use different features of Excel.

Literacy/Vocabulary Strategies (Word Wall)
Format table- to give the data in a spreadsheet  color and design
Excel spreadsheets
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 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:
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


@ 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
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
Exit Activity #10:
Work with partners.
You may use the Spreadsheet Vocabulary PowerPoint.
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

No comments:

Post a Comment