Computer Science Department
College of Arts and Sciences
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.
Created on: 1997.10.15 Updated on: 1997.10.15 Maintainer: Azer Bestavros best@cs.bu.edu