Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Assume that there are many students in Computational Thinking with Data Science class. Below is just a sample of the academic records of some students

image text in transcribed
image text in transcribed
image text in transcribed
Assume that there are many students in Computational Thinking with Data Science class. Below is just a sample of the academic records of some students (grades in 100 scale): Name Midterm 1 (20%) Midterm 2 (20%) Midterm 3 (20%) Final Project (40%) Bob 90 85 95 90 Anna 95 95 95 95 Tom 80 90 100 100 Mary 100 100 90 95 H Laura 70 Ted 50 Mike 80 Letter grade conversion: 80 60 60 90 60 70 100 50 75 Guaranteed grade 2.90 A B 80 - 89 70 79 60 69 60 C D F All the questions below must be answered using Python script (Recommendation using basic Python, not necessary to use advanced packages like Numpy or Pandas) a) Decide a data structure to represent the class with students and grades information with assumption that the class list is long enough. Read the provided osv file containing these information and store into a variable having the defined data structure. (10 points) b) Calculate the final grade of cach student and print out the final grades of all students (5 points) c) Develop a function to convert numeric grade to letter grade. Utilize the developed function to convert numeric grades of students to letter grades and print out the final letter grades of all students. (10 points) d) Find the student with highest score, then print that student name and the highest score (5 points) Note: do not list them with what you see using your eyes. Please you Python script to find out the students and show them to the screen. e) List all students whose final letter grade is A. (5 points) Note: do not list them with what you see using your eyes. Please you Python script to find out the students and show them to the screen Liststudents whose final and points 80 - 89 B 70 - 79 60 - 69

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

Database Design Query Formulation And Administration Using Oracle And PostgreSQL

Authors: Michael Mannino

8th Edition

1948426951, 978-1948426954

More Books

Students also viewed these Databases questions

Question

Total size of memory required to store one frame of video is ?

Answered: 1 week ago

Question

2. Discuss various aspects of the training design process.

Answered: 1 week ago