Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old November 1st 04, 02:06 PM
spooker4u
 
Posts: n/a
Default Grading Function Question...


Am trying to create a function within my worksheet to give student's
their grade at any given point in time within the classes
term/semester. (i.e. if 7 week class, I can tell them what their grade
will be on week 4).

Currently I am using a point system (i.e. 9/10 = 90%) then averaging
each assignments averages together to determine the student's total
average grade, thereby assigning them their respective grade. What I
can't figure out is how to look at my workbook/worksheet and tell the
student what there grade IS today (since the values for future
assignments are 0 or null).

I suppose that I could change my average function on each of my
student's rows to reflect the average of only what is being requested,
but that is very time consuming, and not very practicle... I was hoping
to use "date()" function to have the cell determine based on the date
what their grade would be today if I/they were done with the class.

Any ideas?


--
spooker4u
------------------------------------------------------------------------
spooker4u's Profile: http://www.excelforum.com/member.php...o&userid=15935
View this thread: http://www.excelforum.com/showthread...hreadid=274155


  #2   Report Post  
Old November 1st 04, 02:49 PM
Bernie Deitrick
 
Posts: n/a
Default

Spooker,

The easiest way is to use the AVARAGE function, but leave all ungraded calls
blank (don't enter a zero unless that is the actuall score). Excel will
ignore the blanks, and give you the average for only the entered values.

HTH,
Bernie
MS Excel MVP

"spooker4u" wrote in message
...

Am trying to create a function within my worksheet to give student's
their grade at any given point in time within the classes
term/semester. (i.e. if 7 week class, I can tell them what their grade
will be on week 4).

Currently I am using a point system (i.e. 9/10 = 90%) then averaging
each assignments averages together to determine the student's total
average grade, thereby assigning them their respective grade. What I
can't figure out is how to look at my workbook/worksheet and tell the
student what there grade IS today (since the values for future
assignments are 0 or null).

I suppose that I could change my average function on each of my
student's rows to reflect the average of only what is being requested,
but that is very time consuming, and not very practicle... I was hoping
to use "date()" function to have the cell determine based on the date
what their grade would be today if I/they were done with the class.

Any ideas?


--
spooker4u
------------------------------------------------------------------------
spooker4u's Profile:

http://www.excelforum.com/member.php...o&userid=15935
View this thread: http://www.excelforum.com/showthread...hreadid=274155





Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Question on "Value" function Renny Bosch Excel Discussion (Misc queries) 6 December 31st 04 02:07 AM
I cant use englisch function names in a swedich version of excel PE Excel Discussion (Misc queries) 2 December 7th 04 01:00 AM
Statistical Excel Function Question within Excel 2000... Drew H Excel Worksheet Functions 3 October 31st 04 06:55 PM
need to save values from a function before it changes Ron Excel Worksheet Functions 1 October 29th 04 06:29 AM
SUMIF(AND) FUNCTION Saariko Excel Worksheet Functions 9 October 28th 04 11:52 AM


All times are GMT +1. The time now is 04:59 PM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017