Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

A professor wants a report of final grades for a class to be prepared in a tabular form. Each student is represented by a line

A professor wants a report of final grades for a class to be prepared in a tabular form. Each student is represented by a line containing full name followed by six floating point numbers representing the results in four assignments and two examinations. The first two assignments are worth 5%(each) of the total, the next two are worth 10% each, and the exams worth the rest (midterm exam being 30% and the final exam being 40%). All these data are given in a file named student_data.dat. This is a prototype of the file. Jamie Zawinski,78.8,65.0,87.3,90.0,89.0,79.0 Adam Douglas,86.2,59.0,77.8,81.0,87.5,88.0 Wallace Steven,66.2,68.0,91.3,78.6,80.3,86.4 Paul Wolfowitz,98.8,95.0,89.3,93.0,88.0,90.4 Henry Williamson,88.8,91.0,87.8,92.4,79.8,89.5 Write a powershell script that first asks for the Course Name then open and reads the file student_data.dat line by line and then calculates and prints the students names and final grade and letter grades as shown below. The letter grades to be awarded are: F (59.4% and below), D (59.5% to 69.4%) C (69.5% to 79.4%) B (79.5% to 89.4%) and A (89.5% and above). All printed numbers must have 2 decimal places. Your output should look like the following, Enter Course Name: - Grades Report Full Name Assignment-1 Assignment-2 Assignment-3 Assignment-4 Mid Term Exam Final Exam Grade Letter Grade ---------- -------------- ------------- ------------- -------------- ---------------- ----------- ------ ------------ Jamie Zawinski 78.80 65.00 87.30 90.00 89.00 79.00 83.22 B Adam Douglas 86.20 59.00 77.80 81.00 87.50 88.00 84.59 B --------------------------------------------------------------------------------------------------------------------- --------------------------------------------------------------------------------------------------------------------- Important: You must get a final output screen dump and put in a word file.

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

Databases And Information Systems 1 International Baltic Conference Dbandis 2020 Tallinn Estonia June 19 2020 Proceedings

Authors: Tarmo Robal ,Hele-Mai Haav ,Jaan Penjam ,Raimundas Matulevicius

1st Edition

303057671X, 978-3030576714

More Books

Students also viewed these Databases questions

Question

9. Mohawk Industries Inc.

Answered: 1 week ago

Question

8. Satyam Computer Services Limited

Answered: 1 week ago