+ Reply to Thread
Results 1 to 3 of 3

How to Create Grading Formula

  1. #1
    Registered User
    Join Date
    07-17-2011
    Location
    Thailand
    MS-Off Ver
    Excel 2007
    Posts
    1

    Smile How to Create Grading Formula

    Dear all,

    Could anyone please help me to create a simple formula that will output a score between 0 and 15 for a series of YES/NO answers to a series of 15 questions.

    For example, I have 15 questions, each requiring a YES/NO answer.
    The answers are then inputby students into a single row of an excel spreadsheet.
    I have the correct answers to the YES/NO questions.

    E.g.,

    STUDENT ANSWER: YES YES YES NO YES NO YES NO NO NO YES NO YES NO YES

    MY ANSWERS: NO YES NO YES NO NO YES YES NO YES NO NO YES YES NO

    STUDENT'S SCORE =

    What formula can I use to output a score between 0 and 15 for the student?

    Many thanks for your help and assistance.

    Best wishes.
    Max

  2. #2
    Registered User
    Join Date
    06-07-2011
    Location
    Bačka Palanka, Serbia
    MS-Off Ver
    Excel 2010
    Posts
    12

    Re: How to Create Grading Formula

    If answers is in cells B1, B2, ..., B15 in cell B16 formula is =countif(B1:B15;"YES") for answer YES.
    If you wish answer as procent that formula is =countif(B1:B15;"YES")/15 and format cell B16 as procent.

  3. #3
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Northumberland, UK
    MS-Off Ver
    O365
    Posts
    21,531

    Re: How to Create Grading Formula

    If you assume correct results are in B1:P1 and Student answers are in B2:P2 with score to be placed in Q2

    Please Login or Register  to view this content.
    the above would return 6 for your example.

+ 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