set analysis

[Anonymous]

Hello Community,

I am trying to get this set analysis correct. but i cant seem to figure it out.

i need to find the number of completed "modules". each module has 2 courses

The way this is figured out is that every course have 3 questions and only one has to be right to complete that course.

Example
Course1 - Questions1
               Questions2

               Questions3

Course2 - Questions4
               Questions5

               Questions6

Student	Pool/Question	Correct answers	Score
Mike	Question1	0	0%
Mike	Question2	1	100%
Mike	Question3	0	0%
Mike	Question4	0	0%
Mike	Question5	1	100%
Mike	Question6	0	0%

(This is for course 1)

count({$<[Question] = {'Questions1','Questions2','Questions3'}, [Correct answers] = {1}>}distinct Student)

I'm having trouble getting the second half of this, which is to tell me when they completed course 1 and course 2 they completed the module.

Any suggestions?

[sunny_talwar · Accepted solution]

May be like this:

Count(DISTINCT {<Student = {"=Sum({<[Question] = {'Questions1','Questions2','Questions3'}>} [Correct answers]) > 1 and Sum({<[Question] = {'Questions4','Questions5','Questions6'}>} [Correct answers]) > 1"}>} Student)

[Anonymous]

It worked very well!

Thank you Very much Sunny!!

[sunny_talwar]

I think I forgot to add > 1 for the second Sum() within the set analysis. Not sure if that would make any difference, but I have fixed that in my response above.

Best,

Sunny

[Anonymous]

noted and changed.

I have tested both ways and it seems not to affect the result, but I placed it in regardless to reduce any error that may occur.

-Mike

[Anonymous]

The Requirements have changed a little for this assignment.

The set analysis will have to be placed in a bar chart and correct amount of questions to complete a course has changed from 1 to 3.

Any suggestions?

[sunny_talwar]

Based on the data provided above, what would be the expected output?

[Anonymous]

expected output would be to see the count of students that have completed each module.

In the original example above neither course would be completed until all the questions that correspond to the course are correct.

Furthermore, the module wouldn't be complete till the both courses are complete.

[Anonymous]

i have been able to get it to show the correct count for Module 1, but unfortunately it gives me the same number across the rest of the modules as well.

Count(DISTINCT {$<Student = {"=Sum({<Question = {'Question1','Question2','Question3'}>} [Correct answers]) = 3 and Sum({<Question = {'Question4','Question5','Question6'}>} [Correct answers]) = 3 "}>} Student)