Rename the File using the following naming convention – Last Name First Name _Data Analysis Decision Making
- The assumption for this assignment is that you own a business and sell products (not a service).
- 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
- 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_
- 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.
- 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.