Assigning a Letter Grade to a number

[pbaldy]

Geez, how slow am I?

[MichaelA]

Sorry about the change in terminology. I did mean course.

What lookups do I have and how can I get rid of them without causing problems?

[MichaelA]

It is an academic year.

[MichaelA]

So far, so good but no letter grade for Phoebe Spanish?

StudentID	Course	AverageGrade	LetterGrade
Phoebe	History/American	98.25	A+
Phoebe	Spanish 1	89.75
Abigail	Algebra 1	91.75	A-
Abigail	Science/Physical	89	B+

[MichaelA]

So far so good but no letter grade for Phoebe Spanish?

StudentID	Course	AverageGrade	LetterGrade
Phoebe	History/American	98.25	A+
Phoebe	Spanish 1	89.75
Abigail	Algebra 1	91.75	A-
Abigail	Science/Physical	89	B+

[MichaelA]

I figured this one out. I had to add decimals to the number grades.

[pbaldy]

I mentioned that. Fractional grades that fall between gaps will do this. Perhaps changing the upper limit to 90 in this case and changing the join to just be < for the upper limit should fix it.

[pbaldy]

Again I'm too slow! I think it's the onslaught of cold weather we're having.

[MichaelA]

Wow, this is great! Thank you all, so much.

Now, I'm trying to think of a way to track student progress in terms of a percentage of assignments completed. This would be subject specific and a report showing what percentage is complete of each subject all in one report.

Thank you, again, for your help,
Michael