kaplan IT133 Unit 6 Assignment

Assignment Grading Rubric

Course: IT133 Unit: 6 Points: 65

Unit 6 Assignment:

Outcomes addressed in this activity:

Unit Outcomes:

· Create formulas.

· Use functions.

· Design charts.

Course Outcomes:

IT133-3:Create spreadsheets using basic spreadsheet functions.

GEL-2.3:Solve real-world problems using mathematical skills.

Exploring Formulas, Functions, and Charts

Scenario

Note: You use the Spreadsheet you created in Unit 5 to complete this Assignment.

Now that you have all the appropriate budget data added to your workbook, you want to analyze it to determine how much your expenses are each month and year as well as how much you make per year to determine if you are spending too much and where you are spending it.

1. Create a formula or use the AutoSum function to have Excel calculate the total the expense for each month.
2. Create a formula or use the AutoSum function to have Excel compute the Total Annual Income.

1. Create a formula or use the AutoSum function to have Excel calculate the Total Annual Expenses.
2. Create a formula to determine the percentage of income used for each annual expense total.

1. Be sure to format it as a percentage. Place that formula in the column next to the total of each monthly expense. (GEL 2.3)

1. At the bottom of your budget add the following three functions to calculate the following based on the monthly expenses:

1. Min

1. Max
2. Average
1. In cell A1 add a function to show the current date

1. Rename your worksheet tab to Budget Detail.

Now that you have successfully set up your personal budget, formatted it to look professional, and added some formulas and functions analyze your overall income and expenditures, now you will add a pie chart to visually display your expenses.

Using only your monthly expense labels and your Annual expense totals, create a Pie Chart in a worksheet that will show how you are spending your money.

Copyright Kaplan University

Assignment Grading Rubric

Course: IT133 Unit: 6 Points: 65

8. Highlight the appropriate data and create the pie chart and add that chart to a new worksheet.

a. Highlight the Monthly Expenses (not the title, just the expenses; i.e... electric, water, phone…)

b. Highlight the Annual totals for each expense

9. Insert a 3D Pie Chart from the Insert Tab

a. Ensure you move the chart to a new worksheet.

10. Add Data labels to your Pie Chart

11. Format the data labels

a. Show Category name

b. Show Percentages

c. Show Leader Lines

12. Add a title to your Pie Chart

13. Rename the worksheet tab to Pie Chart.

Directions for Submitting Your Assignment

Complete your Spreadsheet in Microsoft Excel and save as Unit_6_Lastname.xslx and submit it to the Assignment Dropbox for Unit 6.

Review the grading rubric below before beginning this activity.

Assignment 6 grading rubric = 65 points

Assignment Requirements	Points Possible	Points Earned
1.	Create a formula or use the AutoSum	0–5
	function to have Excel calculate the total
	the expense for each month.
2.	Create a formula or use the AutoSum	0–5
	function to have Excel compute the Total
	Annual Income.
3.	Create a formula or use the AutoSum	0–5
	function to have Excel calculate the Total
	Annual Expenses.
4.	Create a formula to determine the	0–10
	percentage of income used for each annual
	expense total. Be sure to format it as a
	percentage. Place that formula in the
	column next to the total of each monthly
	expense.
5.	At the bottom of your budget add the	0–5
	following three functions to calculate the
	following based on the monthly expenses:
	(Min, Max, Average).

Copyright Kaplan University

Assignment Grading Rubric

		Course: IT133	Unit: 6 Points: 65
6.	In cell A1 add a function to show the	0–5
	current date.
7.	Rename your worksheet tab to Budget	0–5
	Detail.
8.	Highlight the appropriate data and create	0–5
	the pie chart and add that chart to a new
	worksheet.
9.	Insert a 3D Pie Chart from the Insert Tab.	0–5
	Ensure you move the chart to a new
	worksheet.
10.	Add Data labels to your Pie Chart and	0–5
	Format the data labels
	a. Show Category name
	b.	Show Percentages
	c.	Show Leader Lines
11.	Add a title to your Pie Chart	0–5
12. Rename the worksheet tab to Pie Chart.	0–5
Total (Sum of all points)	0–65
Less: Points deducted for spelling, grammar,
and APA errors. Plagiarism is totally
unacceptable
Assignment Total Points

Copyright Kaplan University