Support Forums
ATutor Support
SCORM grades
You must be signed-in to post.
| Author | Subject | |
|---|---|---|
| Page: 1 | ||
| theanti9 | Subject: SCORM grades |  |
| 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 | Subject: Re: SCORM grades | |
| 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 grades | |
| 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.