Forums/SCORM Engine/LMS

Wrongly scaled score in SCORM Engine 2008.1 Rollup Integration method (versions to 2008.1.0.7067)

Kevin Glynn
posted this on February 10, 2009 04:17 pm

SCORM Engine 2008.1 introduces a supported API through the ScormEngineManager class.  One of the methods, GetRegistrationSummary, allows you to retrieve summary data about a given registration (completions status, score, time spent etc.). The primary usage of this method is in the templated RollupRegistration integration method that we deliver to clients.

 

There are two paths used behind the scenes to collect this data from the SCORM Engine tables.  SQL or, on databases that support them, Stored Procedures. Stored Procedures are used by default for SQLServer and Oracle databases.

 

If you are using stored procedures then, in versions of the SCORM Engine up to and including 2008.1.0.7067, the score field returned by  GetRegistrationSummary is incorrectly scaled (it will be -1.0 to +1.0 instead of -100.0 to +100.0 as documented).

 

Attached to this announcement are DDL scripts for Oracle and SQLServer to recreate the correct stored procedure. 

 

We recommend that you apply this script and, if necessary, make the corresponding change to your LMS code so that you don't hit this problem when you next update your SCORM Engine version. 

 

After applying this script then the NoddyLms will show scores 100x bigger than expected (since it was erroneously working around this problem).

If you have any questions about this fix please mail info@scorm.com.