Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

More Books

Students also viewed these Databases questions