I'm trying to figure out if it's possible to have text ouput for gradebook if-statement or are they strictly for numerical values.
For example in a course there are five labs of which student has to do four random ones. So if max grade for each lab is 1 I know that 4 points is enough to pass the lab section of the course.
It would cool if I could do something like
=If(LAB1+LAB2+LAB3+LAB4+LAB5>=4,"Labs passed", "Labs missing")
But I have not been able to get this operating. Can someone please clarify if this is even a possibility or am I just doing something wrong.
Hi,
The gradebook calculations won't accept a string like that. However, you can accomplish the same thing in a different way. If you change the lab category grade type from "Value" to "Scale", you can make a custom scale that consists of "Labs missing", "Labs passed". The two text values of the scale correspond to numeric values 0 and 1, so you can replace your above formula with:
=If(LAB1+LAB2+LAB3+LAB4+LAB5>=4, 1, 0)
The gradebook calculations won't accept a string like that. However, you can accomplish the same thing in a different way. If you change the lab category grade type from "Value" to "Scale", you can make a custom scale that consists of "Labs missing", "Labs passed". The two text values of the scale correspond to numeric values 0 and 1, so you can replace your above formula with:
=If(LAB1+LAB2+LAB3+LAB4+LAB5>=4, 1, 0)