Part 1:
The workbook provided shows household income and expenses. You will create charts to help analyze your budget.
1. Open the workbook Lab 8-3 Budget Analysis provided and save as
CS155Week8LastnameFirstname. Ensure that you use your lastname and firstname.
2. In the budget analysis file change; wages, food, phone, and
clothing data for each month. (Leaving these items the same will result in a
deduction)
3. Create a chart using the expenses from the budget.
4. Create a second chart using the cash flow data from the budget.
5. The following areas will be part of grading criteria:
· Changes to data asked for in Part 1
· Ensure the charts created display months and appropriate items from column A
· Create a chart from expenses data
· Move expense data chart to own sheet
· Rename new sheet with expense chart to descriptive title
· Create chart title for expense data chart
· Create a chart from cash flow data
· Move cash flow chart to own sheet
· Rename new sheet with cash flow chart to descriptive titles
· Create chart title for cash flow chart
· Save the file as CS155Week8LastnameFirstname. Ensure that you use your lastname and firstname
· Add a footer in left section of sheet named Budget with your name and GIDnumber
NOTE: Charts not required to be pivot charts
Part 2:
In Part 1 you made choices about which type(s) of chart(s) to use to present budget data. What was the rationale behind those selections? How did the data in the Household Expenses pose a special challenge? How might you address that challenge?
· Answer Part 2 questions in comments or submission text area when submitting
Save file after completing and submit work by attaching file to week 8 assignment submission area.
|
Grading Criteria Assignment
|
Maximum Points
|
|
Change data in sheet for wages, food, phone and clothing
|
15
|
|
Create a chart
· Expenses data
· Cash flow data
|
25
|
|
Move chart to own sheet (expense and cash flow)
|
10
|
|
Rename new sheet to descriptive titles (expense and cash flow)
|
10
|
|
Create chart title (expense and cash flow)
|
10
|
|
Add footer -in left section put your name and GID number
|
10
|
|
Part 2 Questions answered
|
10
|
|
Save the file as CS155Week8LastnameFirstname
|
10
|
|
Override for incorrect file type, template used or incorrect content or file used
|
|
|
|
100
|
What Students Are Saying About Us
.......... Customer ID: 12*** | Rating: ⭐⭐⭐⭐⭐"Honestly, I was afraid to send my paper to you, but you proved you are a trustworthy service. My essay was done in less than a day, and I received a brilliant piece. I didn’t even believe it was my essay at first 🙂 Great job, thank you!"
.......... Customer ID: 11***| Rating: ⭐⭐⭐⭐⭐
"This company is the best there is. They saved me so many times, I cannot even keep count. Now I recommend it to all my friends, and none of them have complained about it. The writers here are excellent."
"Order a custom Paper on Similar Assignment at essayfount.com! No Plagiarism! Enjoy 20% Discount!"
