Question: In python, create an auto grader which takes a csv file of the scores and processes it to produce another file with the grades and

In python, create an "auto grader" which takes a csv file of the scores and processes it to produce another file with the grades and an html page with custom feedback for each student. Import statements/global variables should not be used. Number of assignments, Number of students, and the weightage on the assignments can change. You should not assume a fixed set of values for these variables. you can not assume (a) the number of assignments (b) points for the assignments (c) number of students. These can vary. Your solution should be generic which can be used for any class. 2 sample CSV files are provided:
ID,Last Name,First Name,Email,Lab1,Lab2,Lab3,Lab4,Lab5,A1,A2,A3,A4,FP1,FP 2,FP 3,FP 4,FP 5,FP 6,FP 7,FP 8,Final Test
99999,LastName,FirstName,last@.first@metrostate.edu,10,10,10,10,10,25,25,25,25,25,25,25,25,25,25,25,25,50
992978,yoboytb,ycott,ycott.yoboytb@zy.zotroytbto.odu,10,10,10,10,10,8,1,9,14,13,3,15,9,0,23,14,15,39
1073250,Lor,Kong,kong.lor@zy.zotroytbto.odu,5,10,10,10,10,10,22,9,19,0,8,4,3,14,21,5,1,43
751411,bzonwu,Wiydoz,wiydoz.bzonwu@zy.zotroytbto.odu,10,10,10,10,10,2,2,12,5,7,1,17,4,23,8,3,24,42
307112,Robiychko,Bon,bon.robiychko@zy.zotroytbto.odu,6,10,0,8,10,9,8,2,17,4,2,7,22,13,3,4,6,46
890343,ykjordbl,Lucby,lucby.ykjordbl@zy.zotroytbto.odu,10,0,10,10,10,16,23,25,6,22,6,16,5,2,0,10,10,30
274323,Dbly,Jorozy,jorozy.dbly@zy.zotroytbto.odu,10,10,10,9,10,0,2,8,11,1,15,2,7,17,2,1,20,43
781409,Hbybn,bhzod,bhzod.hbybn@zy.zotroytbto.odu,10,0,0,10,10,9,3,17,13,7,13,14,4,17,20,21,25,44
554836,Robbck,Brbndon,brbndon.robbck@zy.zotroytbto.odu,10,10,10,0,10,25,17,9,5,21,16,16,12,20,14,19,8,50
1006098,Pioryon,Nbthbn,nbthbn.pioryon@zy.zotroytbto.odu,5,4,3,2,1,4,17,1,1,10,23,5,8,25,13,10,3,36
281045,Vorbvongyy,ybrbh,ybrbh.vorbvongyy@zy.zotroytbto.odu,10,10,10,10,10,22,24,0,18,22,19,14,24,11,11,12,2,33
629716,blbbtuyhi,zohbzod,zohbzod.blbbtuyhi@zy.zotroytbto.odu,10,10,10,10,10,21,4,15,18,6,0,16,3,10,7,16,7,44
ID,Last Name,First Name,Email,Lab1,Lab2,Lab3,Lab4,Lab5,A1,A2,A3,A4,Final Test
99999,LastName,FirstName,last@.first@metrostate.edu,10,10,10,10,10,25,25,25,25,100
992978,yoboytb,ycott,ycott.yoboytb@zy.zotroytbto.odu,10,10,10,10,10,8,1,9,14,80
1073250,Lor,Kong,kong.lor@zy.zotroytbto.odu,5,10,10,10,10,10,22,9,19,84
751411,bzonwu,Wiydoz,wiydoz.bzonwu@zy.zotroytbto.odu,10,10,10,10,10,2,2,12,5,84
307112,Robiychko,Bon,bon.robiychko@zy.zotroytbto.odu,6,10,0,8,10,9,8,2,17,92
890343,ykjordbl,Lucby,lucby.ykjordbl@zy.zotroytbto.odu,10,0,10,10,10,16,23,25,6,60
274323,Dbly,Jorozy,jorozy.dbly@zy.zotroytbto.odu,10,10,10,9,10,0,2,8,11,86
781409,Hbybn,bhzod,bhzod.hbybn@zy.zotroytbto.odu,10,0,0,10,10,9,3,17,13,88
554836,Robbck,Brbndon,brbndon.robbck@zy.zotroytbto.odu,10,10,10,0,10,25,17,9,5,100
1006098,Pioryon,Nbthbn,nbthbn.pioryon@zy.zotroytbto.odu,5,4,3,2,1,4,17,1,1,72
A correct implementation of this method will produce four output files
final_grades_1.txt, feedback_1.txt, final_grades_2.txt, feedback_2.txt
The OUTPUT_GRADES_FILE contains 3 additional columns: total_points, percentage, and grade.
The OUTPUT_FEEDBACK_FILE contains the feedback for each student. The feedback should reflect the scores the student got in each assignment, final total, percentage, and the grade.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!