Problem
|
A teacher has asked you to create a worksheet to handle
her class' grades. She has ten students in her class, and each student
has five test scores. In addition, this teacher would like to see the numerical
grades converted to letter grades based on the following:
|
90-100
|
A
|
|
80-89
|
B
|
|
70-79
|
C
|
|
0-69
|
F
|
This grade conversion will be accomplished using a user-defined
function. The worksheet should be able to (a) compute the test average
for each student, (b) display both the numerical and letter grade average
for each student, (c) compute the class average, and (d) display the numerical
and letter grade average for the class. |
Task
|
Develop an algorithm (method) for a function that will accept
as input a numerical grade and return a letter grade.
Represent this algorithm both using pseudocode and as a flowchart.
Implement your function as part of a workbook's code module.
Develop a set of equations for your worksheet.
Create a hand drawn layout for your worksheet.
Convert your equations into formulas, using your layout.
Enter values, formulas and labels into your worksheet and
print out the final result (a) normally, and (b) with formulas turned on
(see note below).
Submit copies of your ...
-
function (pseudocode or flowchart, and source code),
-
list of equations,
-
layout drawing, and
-
completed worksheet with and without formulas turned on.
|
Notes
|
-
Feel free to do more than what is asked above. You will neither
lose nor gain points for the extra work.
-
The actual values (numbers) you enter into your worksheet
are not really important, but you will need to test your worksheet using
actual values.
|