Friday, Oct 5 Spreadsheets- Charts

Bellringer- We are learning the number keypad.
http://www.typeonline.co.uk/number_pad_big_plus_lesson3.html
Choose exercise 1 and then click on the word “start.”
Time will not start until you put your cursor in the white rectangle and start typing. Record your typing speed and accuracyTo hear bellringer message

Open Car lot file and open your green file

What are we learning today?
What if statements. How to create and format charts .

Guided Lesson:
Pull out your study guide questions
Write the correct answers for all of the questions 

Open your to Green file.
What If analysis
What if you change the value in B7 to 10
What if you change the value in C7 to 100
The spreadsheet automatically recalculates new totals for you.
You do not have to retype formulas.

Open your Car lot file.
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.

Adding data bars
Click on the price data.
On the Home tab then go to the Conditional Formatting button then choose data bars then choose a color

Chart creation and formatting

• highlight your car lot data
• Insert a column chart
• click on the chart and the Chart Tools Tab will appear
• insert the chart title "My Car Lot". It will explain the chart's purpose.
• insert axis titles "miles" and "price"
• right click on the legend and choose "select data"
• highlight series 1 then click on edit and change to miles
• highlight series 2 then click on edit and change to price
• click on data labels and click on show
• change chart wall
• change chart floor
• make sure you have gridlines they will make the plot area easier to read.

Independent exercise:
Write down study guide questions 18 and 19 and write down a, b, c or d for the answers.
Start on the Excel Home Tab Ribbon Sheet Worksheet
you may write or type the answers but do NOT print until Miss W checks it.

Exit Activity- SmartBoard formative testing of vocabulary How much do you remember about Spreadsheets? By yourself or with a partner take turns and play http://www.quia.com/hm/174125.html?AP_rand=933500499&playHTML=1