Question: The output should contain: Average final grade earned for the class One row for each student showing the student name, the course average for the

The output should contain:

Average final grade earned for the class

One row for each student showing the student name, the course average for the student and the percentage earned on each grade. Include appropriate headers for the list.

Display class statistics:

o Average grade for each grade item (one row showing class average for each grade item)

The output should contain: Average final grade earned for the class

Problem 3 (25 points): In a new code block in the Assignment 01 Jupyter Notebook, write code that uses the file found on Bb in Assignments Assignment 01 Files used for Assignments\Assignment01/ Filename: Proj1Prob3.csv The first line of the file contains the number of points possible for each of the grade items listed below (Note: it DOES NOT contain a student name - just points). That line is followed by one line for each student in a class. The line for each student has the following fields, separated by commas: Student Name (in quotes) - Exam 1 - Exam 2 - Exam 3 - Exam 4 - Assignment 01 - Assignment 02 - Assignment 03 - Assignment 04 - Quiz 1 - Quiz 2 - Quiz 3 - Quiz 4 - Quiz 5 - Quiz 6

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!

The output should contain: Average final grade earned for the class One row for each student showing the student name, the course average for the student and the percentage earned on each grade....

Description "Write a program that reads from an input file a person's name followed by all their exam scores. Calculate and write the average score for all students on each exam to an output file....

Student Student ID Major Name Course No. Section No. Course Name Instructor No. Instructor Instructor Name Phone No. Grade 2NF Tables: The Whole Key Remove Partial Dependencies 86432 Jones Accounting...

please notice that it's c language Also please show and explain steps and I would be grateful for that Type and turn in a complete C program to solve the following problem: You must read students...

Please Help me!! This is C language, not C++. Project Overview: In this project, you will implement a set of functions that can be used to retrieve information from a CS100 grade book stored in a CSV...

ECE 2 3 0 0 - SOFTWARE DESIGN I - SPRING 2 0 2 4 Homework Assignment # 5 ( Counts double: 2 0 0 points ) - Design Problem Due date: Saturday May 4 t h by 1 1 : 5 9 PM via Gradescope Design Problem:...

Type and turn in a complete C program to solve the following problem: You must read students data from the file which name class_grades.txt this file has in each line student_id and three different...

Create a C++ program that inputs the students four test scores. The details of the test marks are also in the following table 1. Compute the percentage (out of 500 total marks) and output a grade...

Exp19_Excel_Ch03_ML2_Grades.xlsx - EXCEL 2019 Would be very appreciative of some assistance on these, if you can help, please do step by step, thank you in advance!!! Not sure why chegg decided to...

Amelia has wages of $45,000 and net income from a small unincorporated business of $70,000 for 2015. a. What is the amount of Amelias self-employment (SE) tax and deduction for AGI for her SE tax? b....

The balances of select accounts of Donovan, Inc. as of December 31, 2018 are given below. Credit Debit $120,000 Building Cash 9,000 Office Supplies 1,000 Furniture 4,000 Prepaid Insurance 600...

Large companies build up short - term debt over the period of 1 to 2 years, then sell long - term debt using a portion of the proceeds to repay the short - term borrowings. This procedure is called:...

A random sample of 43 biology students in a science program are selected for a study. Of those selected, only 27 passed the mid term exam. At the 5% significance level, is there sufficient evidence...

The Saudi has not yet learned that in the United States, relatives usually cannot substitute for each other. Perhaps in other cultures, it is acceptable to have ones siblings or even friends fill in...

A Saudi working in the United States wakes up ill. He sends his younger brother to work for him that day. The U.S. employer sends the brother home. What happened?

Observe how cultural groups different from yours are portrayed in the media, both in the news and in dramas, comedies, and so on. Are they portrayed accurately? Are they stereotyped?