Tuesday, Oct 15- 7th Grade Spreadsheets- formatting charts

Bellringer:
1.  The daily bellringers will now be practicing the number pad
http://www.typeonline.co.uk/number_pad_big_plus_lesson3.html
Choose exercise 6 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: 

On your car lot spreadsheet complete the following formatting:

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.

@Daily spreadsheet skill exercises
Open Spreadsheet Flashcard Exercise:
 9 Chart types and styles

On Design tab click Change Chart Type @ If there is time students will add     functions to their car file.

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.