IT Milestone

Rubric element II.E.: Vertical bar chart (AKA column chart) or horizontal bar

chart can be used here

$­

$500

$1,000

$1,500

$2,000

$2,500

$3,000

$3,500

Monthly Spending 2018

Current Budget

Rent Childcare Food Car Utilities Total

Monthly Spending 2018 Rent $ 1,200 Childcare $ 600 Food $ 500 Car $ 300 Utilities $ 350 Total $ 2,950

Rubric element II.A.: This information will come

from your final project scenario. Determine best number format (type of

number, number of decimals, etc.)

Remember to name each worksheet in your workbook

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.

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

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

Rubric element II.F.: Vertical bar chart (AKA column chart) or

horizontal bar chart can be used here

$­

$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

Rubric element II.G.: Line graph used here

$­

$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

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