gradebook

  1. K

    Help with Formula for Gradebook

    Hi, I am a Kindergarten teacher and I am trying to create a formula that would allow me to enter my test grades in. It would automatically give it a four point value. I.E. if my test was ten points, and I entered 10 in column c than a 4 would appear in column d. If I entered a 0-3 than...
  2. M

    Teacher - Gradebook - Assign a value to a String

    I am trying to do something that I have no idea how to approach with Excel. I want to assign a value to a text string. Actually, i want to assign a formula to a text string, which will be used in another formula. If a student hands in a homework late, then I want to type an "L" as his grade...
  3. C

    Pass/Fail question

    "Hi, and thanks in advance for any help! I am trying to automate some the functions of my student's English progress, based on individual test scores. There are 5 data and 1 results columns. 2 of the tests have a fail/pass component that even if the cumulative score would be enough to pass...
  4. C

    my round formula rounds up too far

    Hello, welcome and nice board you have here. i have used it a bit but this is the first time i needed to ask a question. my question: I have this formula: =(IF(SUM(G22:AG22),ROUND(SUM(G22:AG22)/$G$19,2),"")) which was made from a gradebook template that i am using for my girlfriend but the...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top