Spreadsheets

The objective of this assignment is to use spreadsheets to manage and analyze data. Specifically, it will introduce you to Google Spreadsheets which is a spreadsheet program comparable to Microsoft's Excel.

The lecture for this assignment is performed in Excel and the tutorial in part 1 below is done in Google spreadsheets. Google Spreadsheets and Excel have many of the same features and concepts. You must watch the Excel lecture and use the concepts learned to complete the assignment using Google Spreadsheets. Again, some of the Google Spreadsheets menus and ways of doing things may be different than what you see demonstrated in Excel, but they are very similar so you can find the equivalent way of doing things in Google Spreadsheets.

Part 1: Google Spreadsheets Tutorial

• Follow the steps in the Google Spreadsheet Tutorial. Many of the skills learned in this tutorial will be applied to part 2 of this assignment.


• The tutorial will teach you how to create three seperate spreadsheets that you will submit for grading:
  1. Checks
  2. Company
  3. Expenses


• These files must be shared with your instructor.
  
  

Part 2: MyGrades Spreadsheet

• Create a new Google Spreadsheet workbook for this course called "MyGrades", as shown in this example.
  
  
  • Use the same data for the fictitious students provided in the example. Put your name as the fourth student and fill in the *??* with your own information. If you have not yet received any grades in the course, make up grades for yourself - this is an excellent chance for "What If" analysis. By creating and using this spreadsheet you will be able to determine the grades you will need to get on future assignments, quizzes, etc. to achieve your desired final grade in the course.
  
  
  • Your Spreadsheet should look similar to the one shown in the example. Note all of the different tabs at the bottom of the spreadsheet, which must be included in your workbook.
  
  
  • You must include all formatting parts, such as bold, underline, italics, decimal places, and centering as seen in the example.
  
  
  • Formulas must be used to calculate the grades for all students including yourself. The Excel lecture demonstrates how to compose the necessary formulas to compute the grades. Formulas must be used where applicable on all sheets. Formulas must be used to calculate the following:
    • Average i.e. =(B1+C1+D1)/3 will not be accepted for full credit
    • Sum
    • Standard Deviation
  
  
  • Use the weights from the syllabus to compute a Weighted Average for each grading category, as seen in the example.
    • The formula to calculate the weighted average is total points earned / total possible points * percent of item.
    • For example, if quizzes were worth 25% and you got 80 of the possible 110 points during the semester, your equation would be 80 / 110 * 25. You need to determine how to use the functions in Google Spreadsheets (i.e. Sum) to calculate this value.
  
  
  • Note that the Excel lecture assumes a final project done by partners. Depending on your class, you may or may not be working with a partner. If you are working with a partner, you should factor in the percentage efforts. If you are working individually you may omit the percentage effort and just calculate the grade based on the web page and video components (as shown in the example).
  
  
  • 3D Pie Chart:The pie chart will show the weights from the syllabus for each category. In order to create the pie chart, you will need to do the following:
    
    • Create a new sheet. In one column type the categories (i.e. Quizzes) and in the next column type the weight for the item found in the syllabus (i.e. 25%).
    • Create a Pie Chart from the data you typed above. Note:Your own spreadsheet should include all the features you see in the example. (i.e., a legend, a title that must be your name, and data labels showing percent and label).