Friday, November 18, 2016

Agenda: Friday, 11/18/16

Spreadsheet practice: create a sheet that calculates your grades

  1. Review these websites for info on working with spreadsheets:
    1. Spreadsheet basics
    2. Using formulas (this one is really important)
    3. Cell borders and colors (The link takes you to the last page of the tutorial; don't worry about the previous pages)
  2. Use this information and your notes to complete this assignment:
    1. 1st and 2nd hour: see Google Classroom (½) for the assignment.
    2. 5th and 6th hour:  see Google Classroom (5/6) for the assignment.
    3. Instructions:
      1. Create a spreadsheet that helps you calculate your grades. You will need:
        1. A column for the assignment name
        2. A column for the assignment type (quiz, homework, project, etc.)
        3. A column for the number of points possible
        4. A column for the number of points you actually earned
        5. A column that uses a formula to actually calculate your grade on the assignment (format it as a percentage)
        6. A cell that averages your grades into one overall percentage.
      2. Fill in the data for 8 assignments and find out the grades. You may use real or made-up data; do not give yourself a 100% on everything!
      3. There are several variations listed for the assignment; these are optional for anyone who would like a challenge.