Go To: Computer Class Syllabus

Assignments on this page:  Magic Number ** Budget ** Minimum Wage Budget ** Future Budget

Procedure for Magic Number Worksheet:

1. Open an Excel Workbook.

2. Open this screenshot (or look at the violet sheet in the classroom file cabinet) to see what this assignment looks like when you're done.

3. Open this other screenshot.  It is a look at the formula view of the above-mentioned worksheet. Formulas are what you will be entering for this assignment!

4. Use the screenshots linked above to guide you to create this worksheet.  After you have constructed it, change the "Magic Number" and watch the others values change along with it, IF you do it right!

5. Save as MagicNumberABC.

Worth 2 Points

1. Open an Excel Workbook.

2. Open this screenshot of the Budget worksheet.
3. Create the budget in your workbook.
   1. Fill in the blank cells with YOUR estimate of what you pay or might pay FOR ALL ITEMS.
   2. If you don't think you have any expenses in one area, make an estimate of what it might be. Assume you are in an apartment or home.
4. Make a Pie chart using YOUR estimated data, not the US Average.
5. Make it look nice.  This is an example.  Use labels with percentages, no legend.  Color choice is yours.
6. Save as BudgetABC.

Worth 2 Points

Procedure for Minimum Wage Budget Worksheet:

1. Open your Exercise 08 workbook (which you have already completed, right???).

2. Have the sheet with "pie" on it open.  It is a budget, if you remember.

3. Change the Hourly Wage to the current minimum wage for non-restaurant workers who receive no tips.

4. Change some of the amounts in the table so that your total equals the monthly wage that appears in the table after you change to the current hourly minimum wage.

5. Save as MinWageABC.

Worth 2 Points

Procedure for Future Budget Worksheet:

1. Retrieve your Minimum Wage Budget worksheet, or open your Exercise 08 workbook .

2. Replace the Yearly salary cell data with the salary that you got from your COIN occupation search.

3. Refigure the formulas to reflect that your input is now starting with the yearly rather than the hourly value. (Change the formulas so that the monthly, weekly, daily and hourly amounts respond to the change in the yearly amount.)

4. Fill out your new budget, based on the new values now being a percentage of a much larger number: your potential future salary…

• NOW, you can afford a car, a nicer place to live, etc!

5. Make sure the percentages for the FICA and withholding are appropriate for your new income level.

• Go to http://www.irs.gov/formspubs/article/0,,id=109877,00.html

Or- if that page changes, as they often do, go to www.irs.gov and search the IRS site for the tax schedule or tax table for the current tax year.

6. Save as FutureBudgetABC.

Worth 2 Points

End of Excel Assignments...

Class Syllabus/Point Sheet

 Excel Index