Programming Project 1: Design a spreadsheet to calculate the class’s grades

Project 1

Q & A

Q1. How can I convert from the numeric grade to the letter grade?

There are several ways to do this. The easiest one is to use an “IF” statement. It would be a very long statement, but it works.

Another option, a more elegant one, is to use a LOOKUP (or VLOOKUP) table. This solution is an advance use of Excel.

Q2. How can I calculate the numeric grade?

You need to “design” a formula. Notice that the quizzes (13) add up to 130 points, but this 130 points only account for 10% of the final grade. If you divide a student grade by the addition of all the potential points (270) your final grade would be wrong.

Q3. How can I make my solution “flexible”?

Well if you design the formula using the value of the test, for example, later on if I need to change the value of the test, I would need to change the formula for all the students. However, if you use the cell address that has de value of the test, then I only need to change the value in that cell to update the grade of all the students.

Q4. How many students should I include in my solution?

Just use 5 or 6 students.

Q5. How do I know that my formula works properly?

I recommend you to test your solution by giving grades to two or three studetns.

Q5. Can I submit late Project 1.

You cannot submit project 1 late because I will publish the solution to the project just after the deadline.