### Math 10e Assignments

#### Graphing

Mean, Median, Mode
-- Also known as the average. The mean is found by adding up all
of the given data and
78
-- The median is the middle number. First you arrange the numbers
in order from lowest
66 74 75 78 82 89\
- as you can see we have two numbers, there is no 75 + 78 = 153 153 / 2 = 76.5
Hence, the middle number is 76.5. -- this is the number that occurs most often.
78 56 68 92 84 76 74 56
68 66 78 72 66 The mode is 78. |

#### Trigonometry

You will need a Scientific Calculator for these equations. You will need to bring one to your exam. Calculators will not be provided for you. If you have an Ipod Touch or Iphone - search for TouchCalc in the App Store - it is free!News Flash - You can also access a scientific calculator without downloading anything on your Ipod or Ipone - just flip the screen sideways and it will change!You can also find this type of calculator online for free but of course this won't work during your exam. |

#### Final Exam Preparation

Here is a Sample Final Exam for you to try You can also view actual final exams from previous years by clicking here. Select your grade and your language and you can view exams from last year and years before. Here is the Math 10 E exam from 2008 / 2009 Here is the Answer Key Here is the Math 10 E exam from 2007 / 2008 Here is the Answer Key You can also try on-line practice tests by choosing the "E-Xam" link beside the answer keys. |

#### Excel Exercise 1

Hi Everyone, I have uploaded this exercise on how to create a Gradebook using Microsoft Excel. Please follow along with the instructions and input the information provided. Remember to save you work, we will be looking at your results on Wednesday. Click here for the Excel Exercise 1 |

#### Using Spreadsheets

Here is this great tutorial that breaks down exactly how to use the basics of Spreadsheets. This second audio tutorial was created by Microsoft. It is really useful but you will need headphones or speakers to hear the lessons. Assignment
1) The first step is to launch MS Excel or Open Office Calc and start a new worksheet. 2) Next, type descriptive labels for the worksheet and TITLE, and label the rows and columns. You may have to adjust the column widths in order to accommodate some of the longer and shorter headings. 3) You should now also try to change the format of the cells to allow them to show the dollar sign figures (currency). Try using the shortcut method (right click) when you have the desired cells selected. 4) Now the data: a) Tuition and fees were a one-time fee which you paid in September ($1450) b) Books were also a one-time fee, also paid in September. ($450) c) Rent is a constant $250 a month, however you had to pay a $125 dollar damage deposit in your first month. d) Utilities are getting more expensive as the cold sets in. (Sept. $50, Oct. $60, Nov. $75, Dec. $95) e) Food is a constant $160 a month. f) Transportation is also a constant $120 a month. g) Odds and ends have been $100 a month for the first three, however this increases in December by $300 for your Christmas shopping.
5) Once you have the data filled in, you need to calculate the totals for each month, as well as the totals for each row. 6) Once the formulas are entered, and totals are complete, you should format the worksheet to make it much more attractive. Change to suit your own tastes, however, keeping in mind that the worksheet will be read by others and should be readable. 7) You may send the worksheet to your instructor at this point, OR you may want to try the additional activity below.
Extra Activity : Creating Charts to accompany the worksheet. 1) Using the worksheet from the previous section, create a chart depicting the data entered in a graphical form,
Some Guidelines: a) Highlight the data from the worksheet from which you wish to chart. b) From insert, choose chart. c) Choose a column chart d) The column chart often looks best when the months lay on the horizontal axis (bottom). To do this choose "series: in rows" e) The chart should be placed on the same page as your worksheet. Make sure the two do not overlap. f) Save the resulting document and email to your instructor as an attachment. |

#### Rounding Numbers - review

When rounding whole numbers there are 2 rules to remember: I will use the term rounding digit - which means: When asked to round to the closest tens - your rounding digit is the second number to the left (ten's place) when working with whole numbers. When asked to round to the nearest hundred - the third place from the left is the rounding digit (hundreds place).
·
·
·
This rule
provides more accuracy and is sometimes referred to as the 'Banker's Rule'.
When the first digit dropped is 5 and there are no digits following or the
digits following are zeros, make the preceding digit even (i.e. round off to
the nearest even digit). E.g., 2.315 and 2.325 are both 2.32 when rounded off
to the nearest hundredth.
765.3682 becomes: 1000 when asked to round to the nearest thousand (1000) 800 when asked to round to the nearest hundred (100) 770 when asked to round to the nearest ten (10) 765 when asked to round to the nearest one (1) 765.4 when asked to round to the nearest tenth (10th) 765.37 when asked to round to the nearest hundredth (100th.) 765.368 when asked to round to the nearest thousandth (1000th) View these Rounding Numbers worksheets for more information When finished, compare your answers with these! How did you do? |

#### Week 2

This week we will be bringing together the data you collected last week and your new 'tax calculating' skills to complete your job outline, salary expectations, and monthly budget. We will be working on this during Monday and Tuesday's class. Here is an example of what your finished assignment should look like. |

#### Untitled Post

Yearly
Tax Bracket: 35.39% ß
Yearly
Monthly Expenses
Total: $2220
Monthly Net Income: $4028.13 ß yearly net income ÷ 12 months
- Monthly Expenses $2220
= $1808.13 leftover We will bring together the data we collected to create a finished job description, budget, and salary outline using the computer lab in A200.Here is an example of what your finished assignment should resemble.
Yearly
Tax Bracket: 35.39% ß
Yearly
Monthly Expenses
Total: $2220
Monthly Net Income: $4028.13 ß yearly net income ÷ 12 months
- Monthly Expenses $2220
= $1808.13 leftover |