Task: Grades Spreadsheet

Your task is to assign end-of-quarter letter grades based on student homework, labs, and exams. Based on the data in grades.txt of your git repo, perform the task below using a spreadsheet tool (e.g. Microsoft Excel, Apple Numbers, Google Sheets, etc.).

  1. For each student, compute a final cumulative average according to the following weights:

  2. For each student, assign one of the following letter grades (each has a corresponding number of Grade Point Average points):

        ======================
        | Grade | GPA Points |
        ======================
        |  A+   |    4.0     |
        |  A    |    4.0     |
        |  A-   |    3.7     |
        |-------|------------|
        |  B+   |    3.3     |
        |  B    |    3.0     |
        |  B-   |    2.7     |
        |-------|------------|
        |  C+   |    2.3     |
        |  C    |    2.0     |
        |  C-   |    1.7     |
        |-------|------------|
        |  D    |    1.0     |
        |-------|------------|
        |  F    |    0.0     |
        ======================

    The main task is to determine cutoff values for each of the grades. When choosing cutoffs, aim to be:

    1. Fair: No two cumulative averages that are "too close together" get mapped to different grades.

    2. Balanced: The distribution of grades should be reasonable (up to your interpretation). When accounting for this criterion, you will need some statistics, such as the number (and percentage) of students who receive each grade, the number (and percentage) of students who receive each kind of letter (A, B, C, D, F), and the average number of GPA points that a student receives.

  3. Finally, set up your spreadsheet in a way that makes it easy to view the grades:

    1. sorted by last name
    2. sorted by cumulative average

When you're done, fill out and submit this template once for each tool you used, along with the artifacts, code, etc. you build, to your course git repo.