Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

There are 10 students in an elementary school class. Each has 4 grades as follows: Name Math Art English Science Eris 92 96 85 83

There are 10 students in an elementary school class.

Each has 4 grades as follows:

Name Math Art English Science

Eris 92 96 85 83

Matthew 77 83 68 75

Alexios 75 88 79 72

Cato the Elder 91 71 99 82

Qin Shi Huang 88 96 85 97

Illya 96 97 92 91

Saladin 89 95 95 79

Edward 84 89 85 76

Ashoka 95 92 96 89

Jamal 88 86 95 93

a) Store this data in a searchable format. (hint: there is a mix of numerical and string data. It may be easier to work with if they are stored in separate but corresponding variables, using row/column number to find the label after the fact) (5)

b) Using menu and switch/case, make a program that gives the grades of any given student in this list. (10)

c) Using find, tell me which students have a grade below 80 and in what subject they do so that I may email their parents. (15)

d) Create a function that takes in a scalar grade and returns a letter grade with the following scale: A is 90-100. B is 80-89. C is 70 to 79. D is 60 to 69. F is below 60. (hint: for ranges of scalars, if/elseif/else is likely the easiest to implement, but I will accept any function that works.) (10)

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

DB2 11 The Ultimate Database For Cloud Analytics And Mobile

Authors: John Campbell, Chris Crone, Gareth Jones, Surekha Parekh, Jay Yothers

1st Edition

ISBN: 1583474013, 978-1583474013

More Books

Students also viewed these Databases questions