grades

Hi All I am trying to set up the conditional formatting for a spreadsheet that contains grades achieved against a target value - some students have a target grade over the boundary of 2 grades - for example A/B - so either is "good". Any ideas on how can I format grade cells so that if it...

Right firstly, apologies if this has been asked before but I have no idea how to shape the search to see if it has or hasn't been posted on before. I have a spreadsheet with quarter on quarter results for a set of penetration tests. I am trying to create a formula which will compare the...

I am trying to count the number of grades a student has acheived that are above a grade C. I have a named range called gcsegrades which have each grade and their relevant point value on another sheet. d=34 c=40 b=46 a=52 Rather than doing a a vlookup against each and every-cell is there a...

I was using an If statement, thought it was set up correctly but as I've been entering data it hasn't represented data like i wanted it to. It represents a grade scale for my classes where D7 is my final percentage...

This is what I have so far: column E is for Quizzes and column I is for Labs. Quizzes (col E) counts for 10%. Labs (col I) counts for 20%. I want to drop the lowest 4 grades out of all the labs and quizzes for each student. For example, if the lowest 4 are all quizzes then no labs get dropped...

Hello, I was wondering if you could could help me out with this question: </PRE> I have the formula =0.10/counta(E6:E15 ). This gives me 0.10/10 if E6 through E15 are filled. How do I make this formula: =0.10/counta( E6:E15 but exclude the cells from this range that equal any of the...

Have created a grade sheet for my son (the teacher) 5th grade Class. Column A: Enter Number of Correct responses Column B: =A4/$A$3 Displays Percent score Column C: =IF(B4>0.94,4,IF(B4>0.7999,3,IF(B4>0.59,2,IF(B4<0.6,1)))) Displays Numberic Grade (1 thru 4) Minimum Grade for...

Hi - In a gradebook workbook, there is a sheet for each period of a school day. I want to now output a student's data into a single report, either in report sheet, MS Word doc, txt file, etc. A student may be entered on 1 or more of the sheets. If you are good in reporting, here is the...

I am in charge of reviewing multiple tests from around the country and evaluating each question, each testing site, etc. I need to find an easy way with excel if possible to input the "answer key" in collum A then each of the tests that I receive from the testing locations in collums B, C...

Freshman-year calculus 29 years ago was the last serious mathematical thinking I engaged in, so please bear with me. My school has a new grading formula which requires not only a given grade median, but also a set grade distribution. If I have a column of grades which range from 4.0 to 8.5...