CPSC 105 Assignment
Due Monday 4/3/2000
For this assignment you will be applying some basic programming skills
using Microsoft Excel (you may use another spreadsheet if it offers the
same functionality - but it's not recommended).
1. Create Truth Tables for the logical operators AND, OR, NOT, and XOR
in the manner demonstrated in class. Hint: XOR is the only hard one, since
the others already have built-in functions in excel. You need to think
of the meaning of XOR - i.e., A XOR B is TRUE IF they are different, and
FALSE if they are the same, or A XOR B is equivalent to (A AND NOT(B)) OR
(NOT(A) AND B).
2. This problem requires you to apply the "IF" function of excel.
It is a contruct that's also found in most programming languages. Create
a spreadsheet recording the grades of students in a semester in a manner
that's complimentary to the example shown in class. That is, it should
list as DATA the *letter* grade the student received in each class, and
you are to write a formula that assigns the grade point value to each letter
grade. Since Trinity's system is too involved, use the following assignments:
A=4, B=3, C=2, D=1, F=0
There are no pluses or minuses.
Calculate the GPA of a student. If the GPA is greater than 3.5 AND
there are no grades below C, you are to print "dean's list" underneath
the GPA value. Hint: for this you need to use the "MIN" function, which
returns the minimum value in a range of values. That is, "MIN" needs to
be a function call nested within IF.
Demonstrate your formulas for at least three fictional students.
Turn in this assignment on FLOPPY DISK, with your name labeled on the disk,
and indicated on the spreadsheet.