IT EXCEL SPREADSHEET

Monthly Spending 2018

Rent 1,200$

Childcare 600$

Food 500$

Car 300$

Utilities 350$

Total 2,950$

$­

$500

$1,000

$1,500

$2,000

$2,500

$3,000

$3,500

Monthly Spending 2018

Current Budget

Rent Childcare Food Car Utilities Total

Rubric element II.A.:

This information will come

from your final project

scenario. Determine best

number format (type of

number, number of decimals,

etc.)

Make sure your charts

have all necessary

elements (title, legend,

labeled axes, etc.) and

that coloring of each

category is consistent

throughout the three

graphs

This example uses data on a fictional monthly household budget which expects a 5%

increase in spending for each budget item each year. Use this as a guide to help you

create your own spreadsheet using the data from the final project scenario. Please

post any question you have to your class General Questions forum.

Remember to name each

worksheet in your workbook

Rubric element II.E.:

Vertical bar chart (AKA column chart) or horizontal bar

chart can be used here

Monthly Spending 2018 Monthly Spending 2019 Monthly Spending 2020 Monthly Spending 2021 Monthly Spending 2022 Monthly Spending 2023

Rent 1,200.00$ 1,260.00$ 1,323.00$ 1,389.15$ 1,458.61$ 1,531.54$

Childcare 600.00$ 630.00$ 661.50$ 694.58$ 729.30$ 765.77$

Food 500.00$ 525.00$ 551.25$ 578.81$ 607.75$ 638.14$

Car 300.00$ 315.00$ 330.75$ 347.29$ 364.65$ 382.88$

Utilities 350.00$ 367.50$ 385.88$ 405.17$ 425.43$ 446.70$

Total 2,950.00$ 3,097.50$ 3,252.38$ 3,414.99$ 3,585.74$ 3,765.03$

$­

$500

$1,000

$1,500

$2,000

$2,500

$3,000

$3,500

$4,000

Monthly

Spending 2018

Monthly

Spending 2019

Monthly

Spending 2020

Monthly

Spending 2021

Monthly

Spending 2022

Monthly

Spending 2023

Projected Monthly Budget

Rent Childcare Food Car Utilities Total

$­

$500

$1,000

$1,500

$2,000

$2,500

$3,000

$3,500

$4,000

Monthly Spending

2018

Monthly Spending

2019

Monthly Spending

2020

Monthly Spending

2021

Monthly Spending

2022

Monthly Spending

2023

Budget Growth

Rent Childcare Food Car Utilities Total

Rubric element II.D.:

Use formulas to calculate projections for each new year (growth rate for each year provided in the final project scenario) and for totals, using best

number format for the data presented

Rubric element II.F.:

Vertical bar chart (AKA column chart) or

horizontal bar chart can be used here

Make sure your charts have all necessary elements (title, legend, labeled axes, etc.) and that coloring of each

category is consistent throughout the three graphs

Rubric element II.G.:

Line graph used here