+ Reply to Thread
Results 1 to 9 of 9

Dropping Lowest Grade

Hybrid View

  1. #1
    Registered User
    Join Date
    11-09-2010
    Location
    Durham, North Carolina, US
    MS-Off Ver
    Excel 2010
    Posts
    4

    Re: Excel 2010 - Dropping Lowest Grade

    Hi Guys!
    Thanks for the quick response! I'll attach the workbook so you can get an idea of what I'm talking about!

    So you can see the problem column is the "RATs" column on the far left. Some are worth 20, one is worth 19, and some are worth 10. I basically need to drop the three lowest "percentages", and then the remaining need to go into the 12% of the total grade. But when calculating how much of that 12% the student gets from RATs, I need the earned points/total points because the 10 point assignments contribute half as much to the grade as the 20 point assignments (if that makes sense). Hopefully with the spreadsheet it will make more sense... I find it's easier to explain in person and more difficult to explain with typing

    @Beaunydal

    Thanks for the formula and help, but I don't think it works exactly! If you remove the three lowest scores manually, you can see the difference. With the -SMALL function, it will remove the lowest number, and not necessarily the lowest percentage. So it removed the 4/10 instead of 5/20, and 4/10 is actually a higher percentage.
    Attached Files Attached Files
    Last edited by PuneetRaman; 11-10-2010 at 08:39 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1