write a program

Whitewater High School has contracted you to write a program that will read a file of student names and test scores in the formation FIRST NAME LAST NAME: SCORE1 SCORE2 SCORE3, where each of the scores is an integer. Then your program is to print a report, sorted by last name with each of the last names fully capitalized (that is, if you read in Wilkinson you print WILKINSON) followed by a comma, then the first name, then a colon, then the scores, then the average for the student, and lastly a letter grade (based upon 90 percent or greater being an "A," 80 percent or greater being a "B," and so forth). At the end of the report the averages for each test are to be printed also. Needless to say, the report must be written to a file and must be "pretty" (in proper columns and such). (HINT: Read in the whole line as a string, switch the first and last name, sort the names, then compute the math. Use stringstream for input and output to read the separate items from each string once they are sorted and to format the output line before printing. Also, since you do not know what the total amount of data may be (the file below is only a SAMPLE to make sure your program runs, use vectors to store your data)

There is a test data file in the Files section of Canvas.

Sample date that is in the file:

Mary Jones: 89 90 100 Tom Brown: 100 99 100 John Smith:66 80 98 Englebert Humberdink: 85 87 88 Tom Jones: 76 78 89 Paul McCartney: 88 88 99 Olivia Newton: 77 66 98 Susan Barlow: 87 98 89 Robert Payne: 88 44 76 George Franklin: 77 88 99 Margaret Ibach: 87 89 90 Maggie Chang: 99 99 100 Blaire Bates: 89 87 78 John Lennon: 88 77 99 Silvia Stalone: 66 55 88 Pepper Johnson: 90 80 99 Alfred Newman: 80 80 90 Hugh Walker: 56 90 70 Maureen Ferguson: 100 90 70 Cho Zhang: 99 99 99 Lisa Graham: 80 87 78 Paul Revere: 89 78 90 Franklin Smythe: 88 88 100 Mark Anderson: 100 90 80 Toni Interbitzen: 90 90 90

Extra Credit:

(50 points) Below the main body of the report output who had the highest score for each test, and then the highest average overall.

(25 points) If there are two or more people with the last name, have them alphabetized correctly.