Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please solve parts a and b both in Python. received incorrect code last time. Task A Download the text file. The text file contains grade

Please solve parts a and b both in Python. received incorrect code last time.

image text in transcribed

image text in transcribed

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 D, 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 Task B 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? 9 File Edit Format View Help ID Quiz HW AVG Project Midterm Final 1 80.9 57.4 97.3 68.5 46.0 2 93.8 97.5 94.3 90.5 97.0 3 81.9 87.1 76.6 56.0 59.5 4 73.2 89.9 91.5 55.0 54.3 5 55.9 52.5 88.6 66.0 0.0 6 65.8 48.3 83.3 71.0 67.0 7 76.0 79.8 89.9 60.3 55.0 8 84.2 95.2 75.0 78.5 89.5 87.3 93.1 88.6 74.0 88.5 10 95.3 95.0 87.8 88.0 87.0 11 79.9 86.4 83.0 60.5 53.0 12 87.8 94.7 88.4 76.0 83.5 13 92.9 97.6 95.9 89.0 88.5 90.0 96.5 94.9 76.0 97.0 15 70.4 89.3 92.1 78.0 61.0 16 90.7 79.9 88.1 80.0 75.5 17 90.9 96.5 87.0 93.0 89.0 18 88.2 96.1 91.4 84.3 91.0 19 87.5 90.5 88.6 64.0 85.5 20 96.8 99.5 97.3 92.0 96.0 21 89.0 85.1 91.6 63.5 52.0 22 78.9 83.5 73.3 90.5 95.0 23 97.6 89.6 90.5 89.5 98.0 24 95.8 76.1 92.6 73.5 87.5 25 89.7 96.5 96.9 75.0 63.5 1 1

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_2

Step: 3

blur-text-image_3

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

Database Systems A Practical Approach To Design Implementation And Management

Authors: THOMAS CONNOLLY

6th Edition

9353438918, 978-9353438913

More Books

Students also viewed these Databases questions