Question

Python 3.7

Students Grade

This project will have you using error handling and file handling to display mid semester report with percentage of student work and their grade. The ‘Students.csv’ file contains students name, exam1 score, exam 2 score, assignment 1 and assignment 2 scores as well. All tasks are out of 100 each. The ‘Students’ are .csv, you may find using the csv module easier to use. However, you can always read in a line and use. split.

Requirements

●Ask the user for the name of the file to open. It should continually ask until the user  

responds with a file that can be opened. The user may enter quit and the program will  

exit

●You will need to read each row in the following order (Name, Exam 1, Exam 2, Assignment 1, and Assignment2).

●You will need to calculate student percentage in each section as follow:

○Exam 1 worth 10% of total grade.

○Exam 2 worth 10% of total grade.

○Assignment 1 worth 5% of total grade.

○Assignment 2 worth 5% of total grade.

○Total percentage ( out of 30%) is  

Exam1%+Exam2%+Assignemt1%+Assignment2%

●You will need to calculate an estimate for student grade as follow

○Student percent score (out of 100%) = (Total percentage/30)*100

●You will need also to display student grade depending on the following:

○‘A’ is 91% and above

○‘B’ is 81% - 90%

○‘B-’ is 71% - 80%

○‘C’ is 61% - 70%

○‘F’ is <=60

●You will read data from Students.csv and output all the above requirements to Students_grade.csv (Name,Exam1 score, Exam2 score,Assignment1 score, Assignment2 Score, Exam1%,Exam2%,Assignment1%,Assignment2%,Total% out of 30%, Total% out of 100%, Grade).

Development notes.

●All import statements should be at the top of the program.

●Don’t try to write it all at once, take

your time and work on one skill at a time.

Example

Enter the name of the file (quit to exit) ==> exam.csv

Could not open the file, please enter another.

Enter the name of the file (quit to exit) ==> student.txt

Could not open the file, please enter another.

Enter the name of the file (quit to exit) ==> students.csv

Reading data and outputting to Students_grade...

Enter the name of the file (quit to exit) ==> Quit

Student.csv

Homer Smith 89 97 99 90

Jack Stanely 90 100 87 94

Daniel Hackson 80 85 75 89

Sara Thomson 97 98 83 90

Thomas Elu 100 97 94 97

Sam Carol 69 40 70 60

Tina Jefferson 79 90 80 95

Sample of Students_grade.csv:

Name Ex1     Ex2 Asi1 Asi2 Ex1/10 Ex2/10 Asi1/20 Asi2/20 Total Total*100/30 Letter Grade

Homer Smith 89 97 99 90 8.9 9.7 4.95 5 28.55 95.16667 A

Jack Stanely 90 100 87 94 9 10 4.5 4.7 28.05 93.5 A

Daniel Hackson 80 85 75 89 8 8.5 3.75 4.45 24.7 82.33333 B

Sara Thomson 97 98 83 90 9.7 9.8 4.15 4.5 28.15 93.83333 A

Thomas Elu 100 97 94 97 10 9.7 4.7 4.85 29.25 97.5 A

Sam Carol 69 40 70 60 6.9 4 3.5 3 17.4 58 F

Tina Jefferson 79 90 80 95 7.9 9 4 4.75 25.65 85.5 B

Thankyou! Have a great day

Answer 1

'''
Python version : 3.7
Python program to read student details from a file and calculate and output mid semester report
to output file
'''

# function to continually ask for input filename until the user
# responds with a file that can be opened.
# The user may enter quit and the program will exit
# returns the open file object or None depending on whether user wants to exit or not
def get_filename():
   # loop that continues till user exits or provides with a valid filename
   while True:
       try:  
           filename = input('Enter the name of the file (quit to exit) ==> ')
           if filename.lower() == 'quit':
               return None
           file = open(filename)
           return file
       except IOError:
           print('Could not open the file, please enter another.')

# main function to read the input file and output the result to output file          
def main():
  
   inFile = get_filename() # get the file object or None if user wants to exit
   # check if user wants to exit
   if inFile != None:
       # if user provided a valid input file
       # create the output file
       outFile = open("Students_grade.csv","w")
       # output the header information
       outFile.write("Name,Ex1,Ex2,Asi1,Asi2,Ex1/10,Ex2/10,Asi1/20,Asi2/20,Total,Total*100/30,Letter Grade")
      
       contents = inFile.readlines() # read the contents of the file into the list with each line being an element of the list
       inFile.close() # close the input file
       # loop over each record of input file
       for line in contents:
           line = line.strip().split(',') # split the list data using comma(,) as delimiter to get the individual fields
           # calculate the weighted marks
           weighted_marks = []
           weighted_marks.append(float(line[1])*.1)
           weighted_marks.append(float(line[2])*.1)
           weighted_marks.append(float(line[3])*.05)
           weighted_marks.append(float(line[4])*.05)
           # calculate weighted total
           total = 0
           for marks in weighted_marks:
               total += marks
           # convert the weighted total to student percent score  
           total_100 = (total*100)/30
           # determine the grade
           if total_100 >= 91:
               grade = 'A'
           elif total_100 >= 81:
               grade = 'B'
           elif total_100 >=71:
               grade = 'B-'
           elif total_100 >= 61:
               grade = 'C'
           else:
               grade = 'F'
           # output the details to file
           outFile.write('\n')  
           for val in line:
               outFile.write(str(val)+',')
          
           for val in weighted_marks:
               outFile.write(str(val)+',')
              
           outFile.write(str(total)+','+str(total_100)+','+grade)
       # close the output file  
       outFile.close()
  
   print('Thankyou! Have a great day')

#call the main function  
main()  
#end of program          
          
Code Screenshot:

Output:

Input file:

Output file: