Microsoft Excel - Creating Pie Charts

You will be analyzing your spending habits and those of your classmates using a spending log to keep track of what you spend your money on.  As you complete the assignment think of it as a comparative exercise.  You will be using a basic paper and pencil form to document and total your expenses.  Then you will use Microsoft Excel to manipulate the same data.  Think of the difficulty you may have if you were to try to create the chart you ultimately create without spreadsheet technology.  You will use Microsoft Excel to record the data in a worksheet.  To further illustrate this data you will use charting features available in Microsoft Excel to visually summarize the data related to your group.

1. Form a group of 4 people.
2. Each person in the group should print and complete a spending log for one week.  At the end of the week total all of your expenses for each category.  The Weekly Spending Log is available below.
3. The group should meet after the week of logging expenditures to determine the role each will take to consolidate the information for comparison.
4. As a group, decide who will serve in each of the following 4 roles (while this topic is creating charts, review resources are also provided)
   Role 1) Weekly Log Analyst - Your role is to collect the Weekly Spending Log from each individual group member.  After collecting the data transfer the individual totals for each category and calculate a grand total for each category using the Weekly Log Analyst Form available below.
   Role 2) Excel Data Clerk 1 - Your role is to create an appropriately named Excel workbook and enter the data for each group member on a separate worksheet using their name as the sheet tab name.  You should use an Excel function to calculate the totals for each person.  You will also use the result of your function to validate the total submitted by each person in the group.  You should note if calculation mistakes are made. 
   Role 3) Excel Data Clerk 2 - Your role is to use the information compiled by the Weekly Log Analyst to enter summary data for each group member and an Excel formula to calculate the grand total for each category on a worksheet named appropriately to represent the data it contains.
   Role 4) Excel Chart Generator - Your role is to use the worksheet containing data that was entered by the Excel Data Clerk 2 to create an Excel Chart as a representation of this summary data and move the chart to a new worksheet named appropriately to represent the worksheet contents.  
5. As a group analyze the chart created by the Excel Chart Generator.  Identify the category in which the largest amount of money was spent.  Identify the category in which the smallest amount of money was spent.
6. Individually reflect upon the findings of your project.  Why do you think the category with the most money spent turned out to be what it was?  Similarly, why did your group spend the least amount of money on the category that was identified? 
7.  Assemble a report which includes all of the data used to complete your analysis, all individual reflections and Excel worksheets in the workbook your group created. All project related files should be submitted to the assignment drop box.  If an assignment drop box is not available, save all assignment related files on a USB flash drive and submit this to your instructor.