reducing student grades

Scenario

30% of students can receive A+/A.  

In a class of 20, 8 student get A's but only the top 6 scores can qualify.  

The other 2 exceed the 30% rule.  How do I reduce the lowest A scores down to a B+ without affecting the other A scores or the other 12 students?

Lets use Column A and B, and Rows 2-21

Comments
There are 16 comments. Login or register to view them.

Darren Freeman .....

Steve Holloway |
Steve Holloway's picture

I am not sure if I understand

Cantona1 |

Obvious mistake

Flash Gordon |
Flash Gordon's picture

grading students

nhush |

An exam room usually has physical rows and columns ...

dstickl |

@nhush

Democratus |
Democratus's picture

I received a sensible answer

nhush |

Stop whining!

George Attazder |
George Attazder's picture

 

nhush |

 

nhush |

Use

Cantona1 |

Hi Cantona1,

nhush |

Min excluding 0's

edhy |

That's clever...

George Attazder |
George Attazder's picture

Thanks

nhush |

 

nhush |