Today we learned learned how to use the IF function in Excel. This allows us to set if/then rules within Excel. I already had an idea on how to use this function but wanted explore it some more and I am glad I did. A few things popped up during my use. #1 you should always go back and check to see if your formulas are working correctly. My guess is that Dr. Pierce set this project up because he knew where the mistakes were going to happen because many of the grades fell right on the cut off line. One time I forgot to put an = sign in and then one time I set a value 1 point too high. Going back and checking, I saw that 2 students had a grade of 82 but 1 had a B and the other had a C. How could this be?? After thinking about it for a minute, I remembered that Dr Pierce said to only show whole grades so Excel automatically rounded the grades for us. The student with the C actually had a 81.8 average. This, IMO, exposes a problem using a computer to do our grades. In real life, unless their was an unusual circumstance, I would have awarded this student a B or at least altered my formula for similar scenarios
Class Grade Book
I decided since I already knew a little about the IF function to conditionally format the grade book so that anyone that had better than a B average would be highlighted in green.
This most closely uses ISTE standard 3- transferring current knowledge to new technologies. I would also say that we could use this to communicate information to students and parents
No comments:
Post a Comment