Final Problem #2

 

Input file record layout:

¨      SSN (numeric length 9)

¨      Last name (alphanumeric max length 12)

¨      First name (alphanumeric max length 10)

¨      Grades

o       Lab1-6 (each with numeric max length 3 with 1 decimal place)

o       Lab Exams 1-6 (each with numeric max length 3 with 1 decimal place)

o       Midterm Exam (max length 4 with 1 decimal place)

o       Final Exam (max length 4 with 1 decimal place)

 

All of the grades add up to a maximum of 1000 points.  Assign final letter grades in the following manner:

¨      The top 25% of the students get As

¨      The next 30% of the students get Bs

¨      The next 30% of the students get Cs

¨      The next 10% of the students get Ds

¨      The bottom 5% of the students get Es

 

The output file should contain the column headers then detailed SSN, name, total points and final letter grade for each student.  The output may be ordered by final letter grade OR social security number, but obviously not both at the same time!  This will be detailed on the final exam…

 

The SSN should have dashes in the format; for example 123-45-6789

The Name should be in the format: last, first