36410 Topic: Capstone Project Excel Number of Pages: 1 (Double Spaced) – (CHECK AND ADVICE) Number..
36410 Topic: Capstone Project Excel
Number of Pages: 1 (Double Spaced) – (CHECK AND ADVICE)
Number of sources: 1
Writing Style: Other
Type of document: Coursework
Academic Level:High School
Category: Art
Language Style: English (U.S.)
Order Instructions:
Follow as file uploaded for entire assignment
College of DuPage CIS 1150
Spreadsheet Project using Microsoft Excel
Part 1
Create a spreadsheet that tracks your expenses for a week.
use a column for each day of the week include at least 7 expense items in rows (make up expenses if necessary) using functions, compute the total expense for each day of the week using functions, compute the weekly total expense for each item using functions, compute the weekly average expense for each item name the worksheet Expense
Be sure to label the rows and columns, and include a title.
Part 2
On a s per item. Be sure there is an appropriate main title, axis titles, and labels for the chart.
Part 3
On a separate sheet titled Pie, create a chart based on the total expenses per day using a 3-D pie chart and pull out the day with the most expenses. Be sure there is appropriate title and labels for the chart.
Content and style will be assessed. Name the file using your name. For example, John Doe would name the file SS-prj- Doe-John.xlsx.
Part 4
On a separate sheet using landscape orientation show me the entire ss using formulas. Call it the Formula Sheet
Rubric
All four sheets should be completed and turned in on BB before class starts on the due date for full points, minus the errors.
Below are listed some of the more frequent mistakes that you can lose points for. This list is not all inclusive.
All sheets should be in one workbook. (-5) Workbook not appropriately named. (-4) Worksheet not appropriately named. (-3) Missing sheet. (-5)
Lack of visual appeal or minimal formatting. (-7) Inconsistent formatting. (-5)
Currency formatting not applied to currency values. (-4) Inconsistent decimal formatting. (-3)
Extraneous formatting. (-3) Missing formula in cell. (-7) Incorrect formulas in cell. (-5)
Function not used instead of formula. (-3) Inconsistent value column widths. (-2)
Missing chart. (-20)
Chart not based on correct content. (-5)
Unnecessary replication of data in chart worksheet. (-5) Chart main title missing. (-7)
Chart legend superfluous. (-2) Chart legend redundant. (-2)
Chart legend is indeterminate. (-5)
Chart text hard to read on background. (-3) Column chart axis titles missing. (-5)
Column chart axis labels are indeterminate. (-5) Pie chart did not display percentages. (-3) Spelling error. (-2 to -5)
Example
There are many acceptable formats that can be used for this project. On the following pages is just one example that meets the requirements of this project. Weekly Expenses
Sunday Monday Tuesday Wednesday Thursday Friday Saturday Total Average
Mortgage
Car Payment Food Clothing
Gas
Phone
Entertainment
$0.00 $350.00 $0.00 $0.00 $0.00 $0.00 $0.00
$0.00 $140.00 $0.00 $0.00 $0.00 $0.00 $0.00
$250.00 $0.00 $0.00 $125.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $75.00
$0.00 $0.00 $20.00 $0.00 $35.00 $0.00 $0.00
$0.00 $5.00 $0.00 $5.00 $0.00 $10.00 $10.00
$35.00 $0.00 $0.00 $0.00 $0.00 $200.00 $100.00
$350.00 $50.00
$140.00 $20.00
$375.00 $53.57
$75.00 $10.71
$55.00 $7.86
$30.00 $4.29
$335.00 $47.86
Total $285.00 $495.00 $20.00 $130.00 $35.00 $210.00 $185.00 $1,360.00 $194.29
Total Weekly Expense by Item
$400
$350
$300
$250
$200
$150
$100
$50
$0
Mortgage Car Payment Food Clothing Gas Phone Entertainment
Items
Total Daily Expenses
Friday
15%
Saturday
14%
Thursday
3%
Wednesday
10%
Sunday
21%
Tuesday
1%
Monday
36%