Please Solve in Python and read the Question thoroughly especially the txt file. Lastly I would highly appreciate it if the code is short and easy / simple to understand.

Task A

Download the text file. The text file contains grade data for multiple students. The first row has headers (labels) for each column. The first column, ID, is simply a unique ID for each student.

Develop a Python script, that will read the data from the text file and use the data to compute a final course average and a letter grade for each student. The script should write the student ID, final course average (rounded to the nearest integer), and letter grade to a new text file called example.txt. Each column should include a header (label).

Course average is determined as follows: Quizzes 15% HW 20% Project 25% Midterm 20% Final Exam 20%

Use the round command in your Python script to round the course average to the nearest integer. To determine letter grade, assume the following minimum scores: 90% for an A, 80% for a B, 70% for a C, 60% for a D _________________________________________

Add code to your script from Task A to determine and output (to the Python IDLE Shell), the answer to the following questions.

1)What percentage of students earned an A or B in the course. 2)What was the lowest final exam score for a student that received an A in the course and what was the students ID number? 3)What is the overall homework average for all students that received a D or F in the course? 4)What is the standard deviation of the homework averages for all students that received a D or F in the course?

Task A Download the text file. The text file contains grade data for multiple students. The first row has headers (labels) for each column. The first column, ID, is simply a unique ID for each student. Develop a Python script, that will read the data from the text file and use the data to compute a final course average and a letter grade for each student. The script should write the student ID, final course average (rounded to the nearest integer), and letter grade to a new text file called example.txt. Each column should include a header (label). Course average is determined as follows: Quizzes 15% HW 20% Project 25% Midterm 20% Final Exam 20% Use the round command in your Python script to round the course average to the nearest integer. To determine letter grade, assume the following minimum scores: 90% for an A, 80% for a B. 70% for a C, 60% for a D Add code to your script from Task A to determine and output (to the Python IDLE Shell), the answer to the following questions. 1)What percentage of students earned an A or B in the course. 2) What was the lowest final exam score for a student that received an A in the course and what was the student's ID number? 3) What is the overall homework average for all students that received a D or F in the course? 4) What is the standard deviation of the homework averages for all students that received a Dor F in the course? File Edit ID 1 2 3 4. 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24. 25 Format Quiz 80.9 93.8 81.9 73.2 55.9 65.8 76.0 84.2 87.3 95.3 79.9 87.8 92.9 90.0 70.4 90.7 90.9 88.2 87.5 96.8 89.0 78.9 97.6 95.8 89.7 View Help HW AVG Project Midterm Final 57.4 97.3 68.5 46.0 97.5 94.3 90.5 97.0 87.1 76.6 56.0 59.5 89.9 91.5 55.0 54.3 52.5 88.6 66.0 0.0 48.3 83.3 71.0 67.0 79.8 89.9 60.3 55.0 95.2 75.0 78.5 89.5 93.1 88.6 74.0 88.5 95.0 87.8 88.0 87.0 86.4 83.0 60.5 53.0 94.7 88.4 76.0 83.5 97.6 95.9 89.0 88.5 96.5 94.9 76.0 97.0 89.3 92.1 78.0 61.0 79.9 88.1 80.0 75.5 96.5 87.0 93.0 89.0 96.1 91.4 84.3 91.0 90.5 88.6 64.0 85.5 99.5 97.3 92.0 96.0 85.1 91.6 63.5 52.0 83.5 73.3 90.5 95.0 89.6 90.5 89.5 98.0 76.1 92.6 73.5 87.5 96.5 96.9 75.0 63.5 1