| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help with formula Grade book
I hope I phrase everything correctly. I have created a teacher grade
workbook. The rows A3 - A33 are students names. The columns C3 - C???? (??? = want to add additional grades (columns) when needed) are numeric test scores. B3 is my counter. I cant seem to get my formula in cell B3 to update when I add a column to include additional test score. B3 is my counter used when I average the sum of the test scores. (see below) If I insert a column K for example, the counter does not update. Is this the formula I should be using? What formula should I be using? =COUNT(C3:J3) When I average a cell (all numeric grades) I use the formula below which does not update either. This formula is always located in the column next to the last numeric test score. When I insert a column to add another test score I would like this formula to update. Example: J3 should read K3 when I insert a column. How can I get the formula to update? Is this the correct formula I should be using? =SUM(C3:J3)/$B$3 Here is the formula I use when I want to convert a numeric value (average of all test scores) to a letter grade for the averages. When I insert a column the reference K3 should read L3 (this is the column I have my averages of all the tests showing). How do I get the formula to update? Is there a better formula I should be using? =IF(K3=93.5,"A",IF(K3=86.5,"B",IF(K3=78.5,"C",I F(K3=69.5,"D","F")))) Thanks, -- David |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Help with formula Grade book
Don,
Thank you, I am off to add your formula to my grade book. -- David "Don Guillett" wrote: Easiest would be to have a dummy column at the end and insert BEFORE that column. or look for a number larger than in your data =COUNT(c3:OFFSET(c3,0,MATCH(99999,3:3))) -- Don Guillett SalesAid Software "David" wrote in message ... I hope I phrase everything correctly. I have created a teacher grade workbook. The rows A3 - A33 are students names. The columns C3 - C???? (??? = want to add additional grades (columns) when needed) are numeric test scores. B3 is my counter. I cant seem to get my formula in cell B3 to update when I add a column to include additional test score. B3 is my counter used when I average the sum of the test scores. (see below) If I insert a column K for example, the counter does not update. Is this the formula I should be using? What formula should I be using? =COUNT(C3:J3) When I average a cell (all numeric grades) I use the formula below which does not update either. This formula is always located in the column next to the last numeric test score. When I insert a column to add another test score I would like this formula to update. Example: J3 should read K3 when I insert a column. How can I get the formula to update? Is this the correct formula I should be using? =SUM(C3:J3)/$B$3 Here is the formula I use when I want to convert a numeric value (average of all test scores) to a letter grade for the averages. When I insert a column the reference K3 should read L3 (this is the column I have my averages of all the tests showing). How do I get the formula to update? Is there a better formula I should be using? =IF(K3=93.5,"A",IF(K3=86.5,"B",IF(K3=78.5,"C",I F(K3=69.5,"D","F")))) Thanks, -- David |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Help with formula Grade book
Assume grades are in C3 to J3:
in K3: =Average(C3:J3) If you add an additional column by highlighting column K and doing Insert=Column then i.e. average calculation moves to column L, then when you enter new grade in K3, L3 will show =AVERAGE(C3:K3) In the same way your grade formula [=IF(K3=93.5,"A",IF(K3=86.5,"B",IF(K3=78.5,"C",I F(K3=69.5,"D","F"))))] will change to reflect the new data. In my testing the latter formula was in cell C5 HTH "David" wrote: I hope I phrase everything correctly. I have created a teacher grade workbook. The rows A3 - A33 are students names. The columns C3 - C???? (??? = want to add additional grades (columns) when needed) are numeric test scores. B3 is my counter. I cant seem to get my formula in cell B3 to update when I add a column to include additional test score. B3 is my counter used when I average the sum of the test scores. (see below) If I insert a column K for example, the counter does not update. Is this the formula I should be using? What formula should I be using? =COUNT(C3:J3) When I average a cell (all numeric grades) I use the formula below which does not update either. This formula is always located in the column next to the last numeric test score. When I insert a column to add another test score I would like this formula to update. Example: J3 should read K3 when I insert a column. How can I get the formula to update? Is this the correct formula I should be using? =SUM(C3:J3)/$B$3 Here is the formula I use when I want to convert a numeric value (average of all test scores) to a letter grade for the averages. When I insert a column the reference K3 should read L3 (this is the column I have my averages of all the tests showing). How do I get the formula to update? Is there a better formula I should be using? =IF(K3=93.5,"A",IF(K3=86.5,"B",IF(K3=78.5,"C",I F(K3=69.5,"D","F")))) Thanks, -- David |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Help with formula Grade book
Topper,
Perfect, Thank you. I am laughing here. You solution is so logical. And very easy. You would not believe how long I worked at this problem before I asked for help. Works like a charm. Perfect... David "Toppers" wrote: Assume grades are in C3 to J3: in K3: =Average(C3:J3) If you add an additional column by highlighting column K and doing Insert=Column then i.e. average calculation moves to column L, then when you enter new grade in K3, L3 will show =AVERAGE(C3:K3) In the same way your grade formula [=IF(K3=93.5,"A",IF(K3=86.5,"B",IF(K3=78.5,"C",I F(K3=69.5,"D","F"))))] will change to reflect the new data. In my testing the latter formula was in cell C5 HTH "David" wrote: I hope I phrase everything correctly. I have created a teacher grade workbook. The rows A3 - A33 are students names. The columns C3 - C???? (??? = want to add additional grades (columns) when needed) are numeric test scores. B3 is my counter. I cant seem to get my formula in cell B3 to update when I add a column to include additional test score. B3 is my counter used when I average the sum of the test scores. (see below) If I insert a column K for example, the counter does not update. Is this the formula I should be using? What formula should I be using? =COUNT(C3:J3) When I average a cell (all numeric grades) I use the formula below which does not update either. This formula is always located in the column next to the last numeric test score. When I insert a column to add another test score I would like this formula to update. Example: J3 should read K3 when I insert a column. How can I get the formula to update? Is this the correct formula I should be using? =SUM(C3:J3)/$B$3 Here is the formula I use when I want to convert a numeric value (average of all test scores) to a letter grade for the averages. When I insert a column the reference K3 should read L3 (this is the column I have my averages of all the tests showing). How do I get the formula to update? Is there a better formula I should be using? =IF(K3=93.5,"A",IF(K3=86.5,"B",IF(K3=78.5,"C",I F(K3=69.5,"D","F")))) Thanks, -- David |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| when doing a grade book how do you drop the lowest grade | Excel Worksheet Functions | |||
| when doing a grade book how do you drop the lowest grade | Excel Worksheet Functions | |||
| Grade Percentage into letter grade | Excel Discussion (Misc queries) | |||
| Grade book average formula | Excel Worksheet Functions | |||
| Do any of the Grade book templates using Excel average grades? | Excel Discussion (Misc queries) | |||
Hybrid Mode
