Solved

How calculate test scores

Posted on 2014-12-12
8
127 Views
Last Modified: 2014-12-17
Using this screen shot as an example I'm trying to figure out how to calculate each group of option groups AND calculate the total score with weighting applied.

scoring example
So for example... Group #1 is actually made up of 4 option groups and the average of the 4 option groups is to equal 60% of the overall total score.

Group #2 is actually made up of 2 option groups and the average of the 4 option groups is to equal 30% of the overall total score.

Group #3 is actually made up of 5 option groups and the average of the 4 option groups is to equal 10% of the overall total score.

I know how to average each of the 3 group scores but I can't figure out how to apply the weighting to the overall score.

Make sense?
0
Comment
Question by:SteveL13
8 Comments
 
LVL 33

Expert Comment

by:Mike Eghtebas
Comment Utility
re: but I can't figure out how to apply the weighting to the overall score.

Question is not clear. give an example using numbers.
A 90-100
B 80- 89
etc.

perform some hand calculations.
0
 
LVL 24

Accepted Solution

by:
Phillip Burton earned 334 total points
Comment Utility
I would calculate it per question, i.e.

Questions 1-4 each contribute 15% to the final score.
Questions 5-6 ditto.
Questions 7-11 each contribute 2% to the final score.

Then you have a contribution per question, and you can sum them up.
0
 

Author Comment

by:SteveL13
Comment Utility
If for example group A has an average of 85 I want that average to represent 60% of the overall score.

If for example group B has an average of 92 I want that average to represent 30% of the overall score.

If for example group C has an average of 73 I want that average to represent 10% of the overall score.

What I can't figure out is...
a) what is the overall test score.  
b) How to calculate it.
0
 

Author Comment

by:SteveL13
Comment Utility
Phillip... you may be on to something.  I think I'll try your suggestion.  Back soon.
0
Get up to 2TB FREE CLOUD per backup license!

An exclusive Black Friday offer just for Expert Exchange audience! Buy any of our top-rated backup solutions & get up to 2TB free cloud per system! Perform local & cloud backup in the same step, and restore instantly—anytime, anywhere. Grab this deal now before it disappears!

 
LVL 24

Assisted Solution

by:Phillip Burton
Phillip Burton earned 334 total points
Comment Utility
85*.6+92*.3+73*.1 = 85.9
0
 
LVL 45

Assisted Solution

by:aikimark
aikimark earned 166 total points
Comment Utility
Weight the questions and grade values as follows:
		A	B	C	D	E
q1	1.5	5	4	3	2	1
q2	1.5	5	4	3	2	1
q3	1.5	5	4	3	2	1
q4	1.5	5	4	3	2	1
q5	1.5	5	4	3	2	1
q6	1.5	5	4	3	2	1
q7	0.25	5	4	3	2	1
q8	0.25	5	4	3	2	1
q9	0.25	5	4	3	2	1
q10	0.25	5	4	3	2	1

Open in new window

0
 
LVL 26

Expert Comment

by:Nick67
Comment Utility
The average of the first 4 is 60% of the total

((a+b+c+d)/4) * 0.60
is also 0.15a + 0.15b + 0.15c +0.15d

The average of the next two is 30% of the total
((e+f)/2) *0.30
is also 0.15e + 0.15f

The average of the final 5 questions is 10% of the total
((g+h+i+j+k)/5)*0.10 is also
0.02g + 0.02h + 0.02i + 0.02j + 0.02k

So the total overall weight score is 0.15 times the score of each of the first six questions and 0.02 times the score of each of the final 5

6 * 0.15 = .9
5 * 0.02 = .1
.9 + .1 = 1 = 100%

Just like Phillip said.
0
 

Author Closing Comment

by:SteveL13
Comment Utility
I'm not sure which way I'm going to go with this yet. but all good advice,
0

Featured Post

Find Ransomware Secrets With All-Source Analysis

Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

Join & Write a Comment

Most if not all databases provide tools to filter data; even simple mail-merge programs might offer basic filtering capabilities. This is so important that, although Access has many built-in features to help the user in this task, developers often n…
It took me quite some time to sort out all the different properties of combo and list boxes available from Visual Basic at run-time. Not that the documentation is lacking: the help pages are quite thorough and well written. The problem was rather wh…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now