School assessment sheet

**dubbi3** · 08-24-2009, 02:50 PM

Members,

I need a little help with a complicated problem.

I would like to have a excel sheet to fill in my student assessment results.

Our rule is that if you have 80% of the questions, filled in correct you have a 6.

I don't know how to fix this in excel.

I can fill in the name, the total points (good answers) and after that i hope someone can help me to get the mark/score out of it.

The enclosure contains my filled in excel sheet.

Btw:

an example:

I filled in 16 correct answers out of a total from 20 answers and that means that my mark will be a 6.

**protonLeah** · 08-25-2009, 12:30 AM

Please Login or Register  to view this content.

**Excel Matic** · 08-25-2009, 03:32 AM

Your query isn't clear in terms of what is the scale on which students are assessed. Let me ask this in this way:

So, if a student answers 80% questions correct, the score (after calculations) is 6. If this is so, then it means the scale is of 7.5 points (7.5 * 80% = 6)

If the above is not true, what would be the 'Marks' if students give correct answers more or less than 80%?

Please explain.