Rename the File using the following naming convention – Last Name First Name _Data Analysis Decision Making

1. The assumption for this assignment is that you own a business and sell products (not a service).

1. Choose a type of business and identify the products to be sold (i.e., office products store selling items like pens, pencils, rulers, post-its, chairs, desks, and the like). Note: you must have a minimum of 10 items.

• Manipulate the data in the cells to reflect the following: Order Date

Region Representative Item

Units Unit Cost

Total (you do not have to change anything in this column as the formula is already inserted)

Remember: You can add or delete information as it is pertinent to your business and products sold.

• Using Pivot Tables provide at least 4 different tables (this means you will have 5 sheets within the workbook).

• For each table complete the following: A) summarize what the table shows, B) why you choose to highlight the table, and C) what business decision can you make using the table.

• Submit the Excel file with summary on Canvas under the Data Analysis Decision Making assignment.

*Be sure to click save often to avoid losing your work.
Grading
Data Sheet	20
Pivot Table 1 (with table explanation/decision)	20
Pivot Table 2 (with table explanation/decision)	20
Pivot Table 3 (with table explanation/decision)	20
Pivot Table 4 (with table explanation/decision)	20
TOTAL	100 points

*Remember: The Excel file needed to complete this project can be found by clicking on the “FILES” link on Canvas.

CSC 131 Computers in SocietyExcel Projects   Project 2 – Student Budget

1. Open the Excel file – My College Budget Template

CSC131_Fall 2016

Rename the File using the following naming convention – Last Name First Name _My College Budget_

1. Manipulate the data in the cells to reflect the following: Your Fixed Income

Your Variable Income Your Fixed Expenses Your Variable Expenses

Remember: You can add or delete information as it is pertinent to you.

1. Review your Budget Sheet to reflect on the financial picture you have painted.

• Provide a one paragraph that includes the following: A) summary of your finances, B) what you plan to change, and C) how you plan to implement that change.

• Submit the Excel file with summary on Canvas under the College Budget assignment.

*Be sure to click save often to avoid losing your work.
Grading
Monthly Income	20
Monthly Expenses	20
Semester Expenses	20
Summary Paragraph	8
File Naming Convention	2
Plot Chart	10
Income/Expenses Percentage and Totals	20
TOTAL	100 points

*Remember: The Excel file needed to complete this project can be found by clicking on the “FILES” link on Canvas.