Question: Please use Java. The code is miss and needs fixing or completed. Dr. Wilson ask a Computer Science student to write a program that do








Please use Java. The code is miss and needs fixing or completed.
Dr. Wilson ask a Computer Science student to write a program that do the following 1)-Read his excel Grade-Book file with N number of student and M number of quizzes and exams. 2)- The quizzes and exams have same grade percentage, the average sum(grade/M) 3)- Compute the grade average for each student and Letter grade for each student. 4) Create an excel sheet name it GradeBookOut and put student name, average, and grade as follovw The GradeBook is source file and the output is GradeBookOut file. Download the source file GradeBook to test and create your project. GradeBook NameQiz Quiz2 Quiz3 Quiz4 Quiz5 Midterm Final Lex.De H Valli.Pata Jose Man Shelli.Bai Jason.Ma 100 74 73 72 71 100 79 78 100 100 89 90 91 92 100 100 91 92 93 94 100 100 100 100 100 72 67 62 87 76 GradeBookout Student Name Lex.De Haan Valli.Pataballa Average Grade 100 A 87 B This is your final project for this term Here specification that I computed Dr. Wilson ask a Computer Science student to write a program that do the following 1)-Read his excel Grade-Book file with N number of student and M number of quizzes and exams. 2)- The quizzes and exams have same grade percentage, the average sum(grade/M) 3)- Compute the grade average for each student and Letter grade for each student. 4) Create an excel sheet name it GradeBookOut and put student name, average, and grade as follovw The GradeBook is source file and the output is GradeBookOut file. Download the source file GradeBook to test and create your project. GradeBook NameQiz Quiz2 Quiz3 Quiz4 Quiz5 Midterm Final Lex.De H Valli.Pata Jose Man Shelli.Bai Jason.Ma 100 74 73 72 71 100 79 78 100 100 89 90 91 92 100 100 91 92 93 94 100 100 100 100 100 72 67 62 87 76 GradeBookout Student Name Lex.De Haan Valli.Pataballa Average Grade 100 A 87 B This is your final project for this term Here specification that I computed
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
