+ Reply to Thread
Results 1 to 4 of 4

Weighted scores for student tasks

  1. #1
    Registered User
    Join Date
    05-10-2016
    Location
    Geelong, Australia
    MS-Off Ver
    2016
    Posts
    13

    Question Weighted scores for student tasks

    I have a workbook that I am using for student results.

    I have had some great help from the forum and am asking for more.

    In each section, I have 10 columns for teacher to write the title of the task.
    I have 4 sections in total

    I would like each of the last 2 columns in each section to be weighted more than the previous 8. I would like the 2nd to last to be weighted 25% and the last column to be 40%
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    07-20-2011
    Location
    Mysore, India.
    MS-Off Ver
    Excel 2019
    Posts
    7,081

    Re: Weighted scores for student tasks

    Pl explain with example how you decide total%.
    Pl note
    Array formula should be confirmed with Ctrl+Shift+Enter keys together.
    If answere is satisfactory press * to add reputation.

  3. #3
    Forum Expert Crooza's Avatar
    Join Date
    10-19-2013
    Location
    Hunter Valley, Australia
    MS-Off Ver
    Excel 2003 /7/10
    Posts
    2,000

    Re: Weighted scores for student tasks

    I've hardcoded the weighting into the array below. I assumed the remaining 8 scores were equally weighted at 4.375% each.

    Check this gives the answer you were expecting though. a quick check my end seems to work OK

    Please Login or Register  to view this content.
    Happy with my advice? Click on the * reputation button below

  4. #4
    Registered User
    Join Date
    05-10-2016
    Location
    Geelong, Australia
    MS-Off Ver
    2016
    Posts
    13

    Re: Weighted scores for student tasks

    Thank you so much Crooza.

    Sorry for the delayed response. I had forgotten I had asked.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 1
    Last Post: 02-28-2018, 02:38 AM
  2. Weighted Scores
    By Ericen in forum Excel General
    Replies: 2
    Last Post: 01-02-2015, 12:18 PM
  3. Creating a chart of student test scores
    By mmcgee in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 07-16-2014, 02:10 PM
  4. Replies: 6
    Last Post: 04-05-2013, 07:31 PM
  5. Replies: 0
    Last Post: 03-01-2011, 10:18 PM
  6. formula to come up with overall scores for student's 4 exam's
    By Colsey in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-04-2008, 09:37 PM
  7. turning student scores into a level???
    By teacherphil in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-15-2006, 05:30 PM

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