Question: Write Python Code. Generate a ClassList of 100 students. Column 1 represents StudentID from 1 to 100. Column 2 to 6 represents marks in Mathematics,

Write Python Code. Generate a ClassList of 100 students. Column 1 represents StudentID from 1 to 100. Column 2 to 6 represents marks in Mathematics, Physics, Chemistry, Biology and English respectively. Create marks using random number generator by considering the following conditions. Mathematics Physics Chemistry Biology English Min. Marks 40 35 50 40 60 Max. Marks 100 100 100 90 85 Write a program to calculate the total and average for each student. Total must appear as the 7th column and average as the 8th column. Calculate the average of total marks of the class. Column 9 represents the "Overall grade". If average mark of a student is greater or equal to class average, Overall Grade is 1. If average mark of the student is less than class average, Overall Grade is 2. [25 marks)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

python code plz must upvote data.csv Each sub-question will guide you to complete the process. Use Python code to answer the questions 1-10. Answer the question 11 in English. Hint: You are suggested...

/*Please answer the Queries and display the code and output.*/ This assignment focuses on the use of the aggregate functions. These functions combine all the results to perform a statistical...

1 Assignment 1 consists of a theory component (1A, worth 80%) and a computer component (1B, worth 20%). The total marks allocated are summarized below. Assignment Grade weight Assignment 1A. Theory...

A. Write a SELECT statement that joins the Departments, Courses, StudentCourses, and Students tables. This statement should return these columns: DepartmentName, CourseDescription, LastName, and...

You are doing a fantastic job at Chada Tech in your new role as a junior developer, and you exceeded expectations in your last assignment for Airgead Banking. Since your team is impressed with your...

1. Please answer the follwing questions using Python 3. Also, please use the format below and share your code and show alll outputs. 2. If there are any questions please answer them. Please use the...

n Q1: Write Python code to do the following 1. Use the function random.randrange () to pick and print an even number from the range [-5,5] 2. Use the function random.randrange() to pick and print an...

If you can't write down the whole steps of the problem, some hint and main steps will be very helpful! Thanks! Problem 4. This question continues the previous one, but now we leave the world of the...

Competency In this project, you will demonstrate your mastery of the following competency: Utilize various programming languages to develop secure, efficient code Scenario You are doing a fantastic...

1. Please write the following code on Python 3. Also, please share you code and please answer entire solution not just part. Also, please show all outputs. Comment in you code. Problem 3(a). A first...

One kilomole of air (assumed to be 78% nitrogen, 21% oxygen, and 1% argon) at room temperature is heated to 4000 K, 200 kPa. Find the equilibrium composition at this state, assuming that only N2, O2,...

Petrochemical Parfum (PP) is concerned about a possible increase in the price of heavy fuel oil, which is one of its major inputs. Show how PP can use either options or futures contracts to protect...

What stage of the life cycle does reminder marcom prevail in ? a . maturity b . growth c . introductory d . decline

Delta MC 1 ( Q 1 . Q 2 ) Delta Q 2

Economist John Taylor has suggested that the Fed use the following rule for choosing its target for the federal funds interest rate (r): r = 2% + + 12 (y y*) / y* + 12 ( *), where is the average...

Suppose banks install automatic teller machines on every block and, by making cash readily available, reduce the amount of money people want to hold. a. Assume the Fed does not change the money...

Consider two policiesa tax cut that will last for only 1 year and a tax cut that is expected to be permanent. Which policy will stimulate greater spending by consumers? Which policy will have the...