+ Reply to Thread
Results 1 to 3 of 3

Student grade inputting and grade percentage calculations

  1. #1
    Registered User
    Join Date
    10-21-2011
    Location
    Ishikawa, Japan
    MS-Off Ver
    Excel 2003
    Posts
    5

    Question Student grade inputting and grade percentage calculations

    Ok so my co- worker and I are excel illiterate and are trying to figure out a formula for entering students grades in a worksheet. Please help!

    Outline: Students complete homework assignments each term but the number of homework assignments changes from term to term. The homework is worth 15% of their total subject grade, however we want excel to calculate their percentage mark based on how many homework assignments they do and then what grade they receive for each one.

    Each homework assignment is out of 5. So we want a formula to say, for example, 'If a student completes only 1 homework assignment then their WHOLE homework grade (the whole 15%) comes from that homework mark for the term. So, if they do ONE homework assignment and their mark is 5/5, then they get the whole 15% for homework for the term. (ie. 100% of the possible homework score for the term). So then we want the formula to be able to calculate their mark if they get any score from 0>5 for their homework as well.

    On top of this, if they receive TWO, THREE or FOUR assignments for the term, we want the spreadsheet to be able to calculate their grade based on multiple assignments (with the 15% homework grade being spread between those assignments) and also be able to understand somehow that the amount of homework can change from term to term so that we don't have to keep making separate spreadsheets.

  2. #2
    Valued Forum Contributor quekbc's Avatar
    Join Date
    01-18-2010
    Location
    Sydney, Australia
    MS-Off Ver
    2010, 2013, 2016
    Posts
    1,149

    Re: Student grade inputting and grade percentage calculations

    Hi confusedteacher,

    Would this work? See attached.
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    10-21-2011
    Location
    Ishikawa, Japan
    MS-Off Ver
    Excel 2003
    Posts
    5

    Re: Student grade inputting and grade percentage calculations

    Yes thankyou that is brilliant! Thankyou for taking the time out to do the sample spreadsheet!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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