How to approach this?
 

Hi,

As some of you may know I'm building myself an Excel based register and
markbook to record all my pupil data.

I have pretty much got the register section completed and am now moving
towards tackling the markbook.

In my workbook I have got a statistics sheet, where I am going to
collate the info to produce some meaningful info. So for example, with
my attendance data in the registers, I have got some simple formulas
working out percentages for on time, late, absent etc....

Now, I want to do something similar the basically allows me to enter in
marks and it will work out some stats for me.

However, the difficulty lies in that some work will be marked as a %,
some will be graded, some may just be given a mark out of something!

Does anyone have any ideas how I should undertake this challenge. Is
there a way of getting excel to look at a range, if there is a number
then use it to calculate an average %, if there is a letter i.e. a
grade, do something else?!

Can Excel find an average letter? So say a pupil had three grade in the
markbook and they were A, B C. It could work out that the average is B.


Any ideas would be welcome, get the old grey matter going!

Cheers,

Mark.


--
mevetts


------------------------------------------------------------------------
mevetts's Profile: http://www.excelforum.com/member.php...o&userid=29130
View this thread: http://www.excelforum.com/showthread...hreadid=499736

How to approach this?
 

Maybe you could attach a number value to each grade-
ie-
D=65
C=75
B=85
A=95
A+=100

Not sure if that helps....

"mevetts" wrote:


Hi,

As some of you may know I'm building myself an Excel based register and
markbook to record all my pupil data.

I have pretty much got the register section completed and am now moving
towards tackling the markbook.

In my workbook I have got a statistics sheet, where I am going to
collate the info to produce some meaningful info. So for example, with
my attendance data in the registers, I have got some simple formulas
working out percentages for on time, late, absent etc....

Now, I want to do something similar the basically allows me to enter in
marks and it will work out some stats for me.

However, the difficulty lies in that some work will be marked as a %,
some will be graded, some may just be given a mark out of something!

Does anyone have any ideas how I should undertake this challenge. Is
there a way of getting excel to look at a range, if there is a number
then use it to calculate an average %, if there is a letter i.e. a
grade, do something else?!

Can Excel find an average letter? So say a pupil had three grade in the
markbook and they were A, B C. It could work out that the average is B.


Any ideas would be welcome, get the old grey matter going!

Cheers,

Mark.


--
mevetts


------------------------------------------------------------------------
mevetts's Profile: http://www.excelforum.com/member.php...o&userid=29130
View this thread: http://www.excelforum.com/showthread...hreadid=499736