Learning Goal: I’m working on a programming project and need an explanation and answer to help me learn.
It’s easy to get smarter about your money when you have a head start.
In this assignment, you will use Excel to create a household budget to help maintain control over your finances and see how your money is being used.
Conduct a short internet job search for the type of position you will be applying for once you have completed your education. Consider your work experience in this search. For example, if you have no experience in field, please search for entry level positions or the type of position someone with your background could reasonably qualify for. Look for three positions that include wage/salary information. Once you have found 3 job ads that include salary information, determine the average starting salary and use this as the basis for your household budget.
Create an Excel spreadsheet of your own design to breakdown your household budget. List monthly expenses and monthly income. You will need to list your expenses for 12 months (so you should have columns for each month). Remember your expenses are not always the same every month (for instance your electric bill could fluctuate based on how hot it is). Be sure to format the expenses and income as currency using one of the formatting options in Excel. Do NOT use an online template. The designs must be easy and logical to read. You should start from a blank, clean, Excel document.
Requirements of the assignment
I have included two (2) example budgets for you to review, Budget Example 1, Budget Exampe 2. These are from students from another section of this course. These are meant to be guides and not exemplars. Please note, even though these are PDFs, you are expected to upload a XLS
Criteria | Excellent5 points | Good
2.5 points |
Poor
0 points |
Criterion Score |
---|---|---|---|---|
Format of Document |
There is a meaningful title, in bold, at least 16 point size, centered above (using merge and center) the spreadsheet content and is centered over more than 3 columns. The rest of the document is in 12 point font. All data that represents money is formatted as currency. |
Some of the requirements are missing |
Most of the requirements are missing |
Score of Format of Document,
/ 5 |
Title and Location |
Job title and where the student plans to live are clearly written |
Only job title or city/state are present or clear |
Neither is clear. |
Score of Title and Location,
/ 5 |
Realistic salary information |
Salary information is clear, accurate, and realistic. It is evident that the student researched. |
Only some of the information is clear, accurate, or realistic |
Information is not clear or realistic or information is not present. |
Score of Realistic salary information,
/ 5 |
Salary information |
3 job titles, locations, and starting salaries are present. |
2 job titles, locations, and starting salaries are present. |
less than 2 job titles, locations, and starting salaries are present. |
Score of Salary information,
/ 5 |
Salary Calculations |
The average starting salary is found using the AVERAGE function. Monthly income is labeled and found by dividing the annual income cell (reference the cell) by 12 |
Some of the requirements are missing |
most of the requirements are missing |
Score of Salary Calculations,
/ 5 |
12 months of expenses are listed |
12 months of expenses are listed |
6-11 months of expenses are listed |
5 or less months of expenses are listed |
Score of 12 months of expenses are listed,
/ 5 |
8 expense items are listed |
8 or more expense items are listed |
4-7 expense items are listed |
less than 4 expense items are listed |
Score of 8 expense items are listed,
/ 5 |
Negative numbers are included |
Negative numbers are included |
Negative numbers are not included |
Score of Negative numbers are included,
/ 5 |
|
Negative numbers are made red by using automatic formatting |
Negative numbers are made red by using automatic formatting |
Negative numbers are not red or Negative numbers are not made red by using automatic formatting |
Score of Negative numbers are made red by using automatic formatting,
/ 5 |
|
A function is used to calculate the average for each expense category |
A function is used to calculate the average for each expense category |
A function is not used to calculate the average for each expense category |
Score of A function is used to calculate the average for each expense category,
/ 5 |
|
A function is used to calculate the subtotal for each expense category |
A function is used to calculate the subtotal for each expense category |
A function is not used to calculate the subtotal for each expense category |
Score of A function is used to calculate the subtotal for each expense category,
/ 5 |
|
A function is used to calculate the subtotal for each month |
A function is used to calculate the subtotal for each month |
A function is not used to calculate the subtotal for each month |
Score of A function is used to calculate the subtotal for each month,
/ 5 |
|
A function is used to calculate the monthly income after expenses for each month |
A function is used to calculate the monthly income after expenses for each month |
A function is not used to calculate the monthly income after expenses for each month |
Score of A function is used to calculate the monthly income after expenses for each month,
/ 5 |
|
The pie chart is on a separate worksheet labeled “Chart” |
The pie chart is on a separate worksheet labeled “Chart” with the values referring to the budget worksheet page. |
Some of the requirements are missing |
The pie chart is not on a separate worksheet labeled “Chart” |
Score of The pie chart is on a separate worksheet labeled “Chart”,
/ 5 |
The pie chart includes the expense categories and monthly totals on the budget |
The pie chart includes the expense categories and monthly totals on the budget |
The pie chart does not include the expense categories and monthly totals on the budget |
Score of The pie chart includes the expense categories and monthly totals on the budget,
/ 5 |
|
The pie chart is correctly labeled |
The pie chart is correctly labeled |
The pie chart is not correctly labeled |
Score of The pie chart is correctly labeled,
/ 5 |
|
Entire spreadsheet is formatted so columns are the correct width for the data it is displaying |
Entire Spreadsheet is formatted so columns are the correct width for the data it is displaying |
Entire Spreadsheet is not formatted so columns are the correct width for the data it is displaying |
Score of Entire spreadsheet is formatted so columns are the correct width for the data it is displaying,
/ 5 |
|
The entire spreadsheet is clearly organized and well formatted |
The entire spreadsheet is clearly organized and well formatted |
The entire spreadsheet is not clearly organized nor well formatted |
Score of The entire spreadsheet is clearly organized and well formatted,
/ 5 |
|
There are no spelling errors |
There are no spelling errors |
There are 1-2 spelling errors |
There are more than 3 spelling errors |
Score of There are no spelling errors,
/ 5 |
A footer is included displaying the dynamic |
A footer is included displaying the dynamic filename |
A footer is included but does not display the dynamic filename |
A footer is not included. |
Score of A footer is included displaying the dynamic,
/ 5 |
TotalScore of Assignment 5: Excel Project- Household Budget Rubric,
/ 100
Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.
You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.
Read moreEach paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.
Read moreThanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.
Read moreYour email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.
Read moreBy sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.
Read more
Recent Comments