Community Forums

ATutor Support

SCORM grades


You must be signed-in to post.

AuthorSubject
 
Page: 1
theanti9
Subject: SCORM gradesQuote this post in your reply
If you are asking for help, provide lots of detail so problems can be reproduced.

Things to describe:
Operating system ATutor is installed on - Ubuntu 9.10
ATutor version - 1.6.4
PHP version - 5.3.0
MySQL version - 5.1.37
Webserver & version - Apache 2.2.12

I'm looking to find out where in the database the grades are stored for scorm packages. I can't find them. I'm trying to make a report page for an outside party to come in and view the progress of their students in their group. I need to see what courses the students have passed and what they haven't done yet. If someone could point me in the direction of this information, or maybe another way to get the right information, that would be great.

Thanks,
Ryan
Posted: 2010-01-13 18:28:05
greg

Avatar for greg
Subject: Re: SCORM gradesQuote this post in your reply
SCORM grades are not saved.

Create your tests with ATutor if you need data. Or create them with an IMS QTI compliant test authoring tool, and import the QTI tests into ATutor.
Posted: 2010-01-14 10:19:06
matthai
Subject: Re: SCORM gradesQuote this post in your reply
Hello,

the scorm-1.2 rte stores all CMI data in the cmi table.

Regards,
Matthai


mysql> select * from AT_cmi;
+--------+---------+-----------+----------------------------+-------------------------------------------------------------------------------------+
| cmi_id | item_id | member_id | lvalue | rvalue |
+--------+---------+-----------+----------------------------+-------------------------------------------------------------------------------------+
| 1 | 2 | 1 | cmi.core.total_time | 0000:00:00.00 |
| 2 | 2 | 1 | cmi.core.lesson_status | not attempted |
| 3 | 2 | 1 | cmi.core.entry | |
| 4 | 4 | 1 | cmi.core.total_time | 0000:00:00.00 |
| 5 | 4 | 1 | cmi.core.lesson_status | not attempted |
| 6 | 4 | 1 | cmi.core.entry | |
| 7 | 4 | 1 | cmi.objectives._count | 3 |
| 8 | 4 | 1 | cmi.suspend_data | !fmxclp|MC_QTI_Optimaal_01#0#|QUE_1004#0#|QUE_1003#0#Essay_QTI_Optimaal_01_RS#dfd~# |
| 9 | 4 | 1 | cmi.objectives.0.score.raw | 0 |
| 10 | 4 | 1 | cmi.objectives.2.id | QUE_1004 |
| 11 | 4 | 1 | cmi.objectives.1.id | MC_QTI_Optimaal_01 |
| 12 | 4 | 1 | cmi.objectives.0.id | QUE_1003 |
| 13 | 4 | 1 | cmi.objectives.2.score.raw | 0 |
| 14 | 4 | 1 | cmi.objectives.1.score.raw | 0 |
| 15 | 4 | 1 | cmi.core.score.raw | 0 |
| 16 | 2 | 1 | cmi.core.score.raw | 0 |
| 17 | 2 | 1 | cmi.suspend_data | !fmxclp|QTI_MC_101b##|QTI_MC_101##MC_101_Q01#D~# |
| 18 | 2 | 1 | cmi.objectives.0.score.raw | 0 |
| 19 | 2 | 1 | cmi.objectives.1.score.raw | 0 |
| 20 | 2 | 1 | cmi.objectives._count | 2 |
| 21 | 2 | 1 | cmi.objectives.1.id | QTI_MC_101b |
| 22 | 2 | 1 | cmi.objectives.0.id | QTI_MC_101 |
+--------+---------+-----------+----------------------------+-------------------------------------------------------------------------------------+
22 rows in set (0.00 sec)
Posted: 2010-01-23 04:50:48
 
Page: 1

You must be signed-in to post.

Related Articles