Excel Chapter 3
Main Targets:
 Introduce basic formulas
 Formatting Cells, Rows, Columns and Titles
 Applying basic Formulas and using the copy function
 Creating complex formulas using MIN, MAX, and AVERAGE
 Using various methods to create formulas
Assignments for Excel Unit C
SIDE NOTEIf you do not do the formulas you can only receive HALF Credit!!!
Assignment #  Assignment Name  Page Number  Link 
1.  Unit C Chapter Work Part 1  Pages EX168 to EX203  No Link Save 
2.  Unit C Chapter Work Part 2  Pages EX204 to EX217  No Link 
3.  Unit C In the Lab 1Salioto Auto Parts (Summative)  Pages EX234 to EX235  No Link 
4.  Unit C In the Lab 2Britney's Music  Pages EX238 to EX240  Click Here 
5.  Unit C In the Lab 3RockieView (Summative)  Pages EX241 to EX242  No Link 
The Math & Business Collaboration presented by Ms. G
Assignment #  Assignment Name  Link 
1. 
Gas and Taxes Spreadsheet
 Open the Gas and Tax Spreadsheet
 We are going to figure out mathematical equations to find: We are going to find values for the formulas based on spending $25 dollars for gas. We will find out how much of the money is spent on taxes and what the cost per gallon is without tax.
 You will learn the formula for figure out how much is spent on taxes for gas
 You will research gas tax for 20 different states (Oregon is the example)
 You will fill out the spreadsheet with the information obtained by you
 This is only a 2 day assignment (200 points).
 You will get 10 points for each state done by Tuesday 11:59 and 59 seconds. Anything turned in later will be only assessed at 70%.
 If you are late with this you can only get 70% no more
 Heads up, to do Part 2 you need to complete part 1.
 Click Here 
2. 
Create Your own spreadsheet
You will make a spreadsheet.
 Open the next spreadsheet
 Enter the following headings: State Name, # of Gallons, $ spent on Tax, $ Spent on Gas.
 Enter the Information you obtain from your research
 Enter the Formulas at the bottom across all the columns
 Center the Title and Use Heading 1
 Center the sub headings and use Heading 2
 Change the $ spent on Tax and $ Spent on Gas to Currency
 Add Themes, Fonts, Colors, and effects to make it original
 Due by Thursday at 3 pm, no later
 For those who cannot remember and lack self discipline....text yourself. You need to turn this in by 3 pm on Thursday

Click Here 
3.  Part 3Charts, Create Your own charts
You will open to spreadsheet from part 2
 Create a Pie Chart based on the Average row for $ for Taxes & $ for gas Columns
 Create a Bar Chart Based on the States Column & Gallons of Gas
 Create a Bar Chart Based on The Median Info
 Create Bar Chart Based on Standard Deviation
 CreateColumn Chart Based on States & $ Amount of Taxes
 Create Column Chart Based on States & $ Amount of Gas
 Create a Histogram Chart Based on the States and the # of Gallons
 Create a Histogram Chart Based on the $ of Tax
 Add a Sheet (Click The Plus sign at the Bottom), and Create Line Charts Based on the Highest Row
 Create a Line Chart Based on Lowest Row
 Create a Sunburst Chart Based on States and $ of Gas
 Add a Totals row above the Average Row and Create a Line Chart based on the totals of the 3 Columns and Add it to the sheet you created
 You must Add some legends to 3 of the charts
 You must recolor 6 of the charts
 You must use different designs other that the originial on all charts
 You must have titles on 5 of the charts
 You will add 2 more Formula Rows; One for Average Deviation, and Geometric Mean
 Create the Formulas for Average Deviatiion and GeoMetric Mean
 In Column F add in YOUR OWN WORDS what Mode, Median, Standard Deviatiion, Average Deviatiion, and GeoMetric Mean. A definition that a 7th grade student would understand.
 This is Due Monday Night 11:59 pm.
 Highest grade after that is 70% after that time that was stated above. So read above and text yourself.
 No Link 
