Monday, Oct 14- 7th Grade: Spreadsheet Skills Continued

Bellringer:
1.  The daily bellringers will now be practicing the number pad
http://www.typeonline.co.uk/number_pad_lesson2.html
Choose exercise 5 and then click on the word "start."
Record you typing speed and accuracy on the form.
You must have 98% or higher accuracy.

What are we learning?
4.00 Spreadsheet Basics & Formulas
4.1 Know the components of Spreadsheets
4.2 Creation and Formatting of Spreadsheets
4.3 Know spreadsheet operations

Guided Lesson: 
@ Daily spreadsheet skill exercises
Open Exercise
Skill 1 ascending order (Home tab)
Skill 21- hide gridlines (Page layout tab)
Skill 22- pie chart (chart tools then design tab), 
Skill 4- sparklines(insert),
Skill 20- icon sets (under conditional formatting)
Skill 2- color scales (under conditional formatting)

On your car lot spreadsheet complete the following formatting:
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.

Chart creation and formatting

• hide the "miles" column 
• highlight your car lot data- model and price
• Insert a column chart
• click on the chart and the Chart Tools Tab will appear
• We are going to look at the Design Tab.
• Choose a chart style color.
• We are going to  look at the Layout tab.
• insert the chart title "My Car Lot". It will explain the chart's purpose.
• insert horizontal axis title "model"
• insert vertical axis title "price"
• click on data labels and click on show
• click on data table and click on show
• change chart wall, go to more options and pick a fill color
• change chart floor, go to more options and pick a different color 
• make sure you have gridlines they will make the plot area easier to read.

Exit Activity: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.