Create a script that will do the process of grades computation with the the following consideration: 1 Major exam : 40% 3 Quizzes : 20% 1 Project : 30% 2 Assignments : 10% Compute for the average of the grades after user provided the data. Also, kindly consider the table specification commensurate to the grades computed: Grades        Remarks 98-100        1.0 95-97          1.25 92-94          1.5 89-91          1.75 86-88        2.0 83-85        2.25 79-82        2.5 76-78        2.75 75             3.0 <75           5.0 >100        N/A   Sample Output: Please enter Student Name: Ryan Please Enter grade for Major Exam: 90 Please Enter grade for Quiz 1: 90 Please Enter grade for Quiz 2: 90 Please Enter grade for Quiz 3: 90 Please Enter grade for Project: 90 Please Enter grade for Assignment 1:90 Please Enter grade for Assignment 2: 90 1 Major Exam's average is 90 and the 40% equivalent is 36 3 Quizzes' average is 90 and the 20% equivalent is 18 1 Project’s average is 90 and the 30% equivalent is 27 1 Assignment's average is 90 and the 10% equivalent is 9 Ryan's total grade is 90 and its equivalent is 1.75 Please show code in order for me to give you a like

Np Ms Office 365/Excel 2016 I Ntermed
1st Edition
ISBN:9781337508841
Author:Carey
Publisher:Carey
Chapter6: Managing Multiple Worksheets And Workbooks
Section: Chapter Questions
Problem 6RA
icon
Related questions
Question
100%

Create a script that will do the process of grades computation with the the following consideration:
1 Major exam : 40%
3 Quizzes : 20%
1 Project : 30%
2 Assignments : 10%

Compute for the average of the grades after user provided the data.

Also, kindly consider the table specification commensurate to the grades computed:

Grades        Remarks
98-100        1.0
95-97          1.25
92-94          1.5
89-91          1.75
86-88        2.0
83-85        2.25
79-82        2.5
76-78        2.75
75             3.0
<75           5.0
>100        N/A

 

Sample Output:

Please enter Student Name: Ryan
Please Enter grade for Major Exam: 90
Please Enter grade for Quiz 1: 90
Please Enter grade for Quiz 2: 90
Please Enter grade for Quiz 3: 90
Please Enter grade for Project: 90
Please Enter grade for Assignment 1:90
Please Enter grade for Assignment 2: 90

1 Major Exam's average is 90 and the 40% equivalent is 36

3 Quizzes' average is 90 and the 20% equivalent is 18

1 Project’s average is 90 and the 30% equivalent is 27

1 Assignment's average is 90 and the 10% equivalent is 9

Ryan's total grade is 90 and its equivalent is 1.75


Please show code in order for me to give you a like

Expert Solution
steps

Step by step

Solved in 3 steps with 3 images

Blurred answer
Knowledge Booster
Development strategies
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Np Ms Office 365/Excel 2016 I Ntermed
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:
9781337508841
Author:
Carey
Publisher:
Cengage