Home‎ > ‎Math Essentials 10‎ > ‎Math 10e Assignments‎ > ‎

Using Spreadsheets

posted Apr 26, 2010, 8:36 AM by Jon Hamlin   [ updated Apr 26, 2010, 8:46 AM ]
We will begin by looking at these slide show presentations of various spreadsheets concepts.

Math 10 Essentials Ch 3


•  Section 3.1: The Basics Of Spreadsheets
•  Section 3.2: The Style File
•  Section 3.3: Smart Spreadsheets
•  Section 3.4: Starting From Scratch




Spreadsheets


•  Section 3.5: What If...?
•  Section 3.6: Saving Precious Time
•  Section 3.7: Handy Uses & Applications
•  Chapter 3 Review


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

Software:  Microsoft Excel

Goal:  To Create a computerized version of a worksheet showing projected expenses for a University students' fall term.  The design of the worksheet is based on this hand-drawn planning version.



 

 

 

 

 

 

 

 

 

 

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.


Comments