Project $4$

Goals

Practice data processing using Lists, Dictionaries, and Sets

Notice:

For each project, you can submit at most $10$ times. In case of issues, you should approach TAs during office hours instead of wasting your submission chances.

The final score on Vocareum is tentative and subject to revision after being processed through plagiarism software.

Read each project description carefully. Just because your code works on your machine does not mean it is correct. Vocareum grades each submission based on the technical specifications in the project description. Not satisfying them gives low or zero points. We do not do manual reviews or regrading if your submission does not follow the technical specifications.

You can find files for testing your project in the $/$work folder on Vocareum.

Description

The university is developing a course management system that automatically calculates final grades based on the submission records of students. The course management system team hired you to implement the calculation process for any given course, which means you are required to write a Python program to read the submission records from students and calculate the final grades.

Files location and summary:

The example input files are located under startercode in Vocareum.

Each file contains data in the form of comma$-$separated values $($commas mark column$-$wise separation$).$ For each file, data is arranged as below:

StudentInfo.txt

$\backslash$table$[[$ID$,$Name,Age$],[($String$),($String$),($String$)]]$

$\backslash$table$[[$SubmissionRecord$.$txt$,],[$ID$,$Assignment's Name,Score,Date$],[($Strin$,($String: e$.$g$.,($Int$),($String$)],[$g$),$"Lab$\_1",$ "Midterm"$),,]]$

AssignmentInfo.txt

$\backslash$table$[[\backslash$table$[[$Assignment$\text{'}$s$],[$Name$]],$Weight,Deadline$],[($String$),($Float$),($String$)]]$

The following steps summarize the project tasks:

Task $0$ : program set up and adding brief description comments in the header area.

Task $1$: implement the following functions, that will read data from a file and return a list of dictionaries, where each dictionary will represent the data in one line of the input files:

readStudentInfo $($fileName$)$

readSubmissionRecord $($fileName$)$

readAssignmentInfo$($fileName$)$

Task $2$: Implement the getScore function that returns a list of dictionaries containing the student's information and their scores for each assignment.

Task $3$: Implement the computeFinal Grades function that returns a list of dictionaries that contains all the information from Task $2$ as well as their final grades.

Task $4$: Implement the computeAverage function that returns a dictionary that contains the average score for each assignment and final grade.

Task $5$: the main function.

Grading note:

Your code should be general and should not make any assumptions, e$.$g$,$ number of lines, content, etc. For example, we may pass a file with the same format but different content.

Task $0$: Setup and comments

Open a new, blank Python program window. Save the file as

project$04.$py$.$ At the top of the file, add the comments.

Task $1$: Implement readStudentInfo, readSubmissionRecord, readAssignmentInfo functions

In this task, you will write the functions that read data from files and append the data into dictionaries. This task is often called data preprocessing.

def readStudentInfo$($fileName$)$:

Parameters: filename $($String$)$

Return value: List of Dictionaries where each dictionary represents one line from the file.

Description: The function reads each student's data from a file and returns a list of dictionaries. All the data needs to be a String type.

Sample data from Studentinfo, txt

$01,$ Wilhelm, $19$

$02,$ Young, $18$

$...$

Sample output from function:

$$ studentInfo $=$ readStudentInfo$(\text{'}$StudentInfo$.$txt$\text{'})$

$>$ print $($studentInfo$)$

$[\{\text{'}$ID$\text{'}$: $\text{'}01\text{'},$ 'Name': 'Wilhelm', 'Age': $\text{'}19\text{'}\},\{\text{'}$ID$\text{'}$:

$\text{'}02\text{'},$ 'Name': 'Young', 'Age': $\text{'}18\text{'}\},...]$

def readSubmissionRecord$($fileName$)$:

Parameters: filename $($String$)$

Return value: List of Dictionaries where each dictionary represents one line from the file.

Description: The function reads the submission information from a file and returns a list of dictionaries. You need to convert the third entry of each row $($the score of the submission$)$ into an Int type, and the rest needs to be a string type.

Sample data from SubmissionRecord.txt

$01,$ Lab, $60,9/10/2023$

$01,$ Lab, $80,\frac{9}{11}\frac{?}{2023}$

Sample output from function:

$$ s submissionRecord $=$ readSubmissionRecord $(\text{'}$SubmissionRecord$.$txt$\text{'})$

Sample output:Task $2$: Implement the getScore functiondef getScore$($studentInfo$,$ submissionRecord, assignmentInfo$)$:Parameters: studentInfo $($List$),$ submissionRecord $($List$),$assignment Info$($List$)($All parameters are the return values of Task $1.)$Return value: List of Dictionaries where each dictionary contains the students' data and their respective scores for each assignment.Description: This function returns a list of dictionaries. Each dictionary contains students' information included in the parameter studentInfo and their scores for each assignment. You can get this information by going thro