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.