Monday, March 24th- 7th Grade- Spreadsheets- Formatting

Bellringer:
1. Open your Typing file and on page 49 type lines 5 and 6.            
    Use your left LITTLE finger for the Z  key .
2. If you do not have the Career worksheet or PowerPoint finished
   Click on http://www.careeroutlook.us/table.php?state=NC&cluster=sci&interest=all
3. Students will go to http://www.carmax.com to finish their worksheet and spreadsheet. 
4. TEST ON FRIDAY-  on Spreadsheet vocabulary (play exit game to practice) 

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

Guided Lesson: 

@ Open up the Spreadsheet Vocabulary PowerPoint file.
     Slides 24-25 (identifying parts of spreadsheet formula)

@ Slides 26 (order of operations in a spreadsheet formula)

@ Students will recreate the formula.

@ Students will start to format their car spreadsheet.

Car lot formatting exercise- students will format their data table, change the color of the tabs, create a border around their favorite car, fill in that cell and change data format to currency. 

Independent Activity:
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)

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.

---STOP  HERE----
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.

http://edu.glogster.com/ 
Do NOT create a new id if you can not log in! We have a list with ids on it.