A computer-illiterate friend of yours has just graduated from BU and wants you to help him/her apply to graduate schools. As a part of the application process, your friend is expected to submit a report of his/her performance over the 4 years he/she spent at BU. The report should include a list of all the classes taken in each semester. For each class, the following is needed: the name and course number of the class, the numeric grade (on a 4.0 point scale) received in that class, and the total credit units for that class. From this information, it is required to compute the grade points for each class. This can be done easily by multipying the grade by the total credit units.

For example, suppose that your final grade in cs-101(b1), which is a 4-credit class, is 3.6 (out of a maximum of 4.0), then in the transcript, cs-101(b1) should appear as follows.

       ------------------------------------------------------------------------
       Course Name      Course #            Grade       Credits    Grade Points
       ------------------------------------------------------------------------
       Intro to Comp    CS-101(b1)           3.6          4.0           14.4
       Intro to Ling    LS-111               3.2          2.0            6.4
       Calculus         MA-123               3.7          4.0           14.8
       ...              ...                  ...          ...            ...
       ------------------------------------------------------------------------

Also, for each semester, it is required that the semester GPA of your friend be computed. The semester GPA can be computed by adding up the grade points for all the classes taken in that semester and then dividing the total by the total number of credit units for that semester. Similarily, it is required that the year GPA be computed. The year GPA can be computed by adding up the grade points for all semesters and then dividing that by the total number of credit units for all semesters. Finally, an overall GPA must be also given. Using Microsoft Excel, generate and submit the following:
1. A printout of the spreadsheet that your friend should submit to the graduate school.
2. A printout of the spreadsheet showing all formulas used.
3. A properly labeled chart plotting the semester GPA for all semesters.

Note

Created on: 1997.10.15
Updated on: 1997.10.15
Maintainer: Azer Bestavros
            best@cs.bu.edu