Exporting assignment grade

Topics: Developer Forum, Project Management Forum, User Forum
Jan 28, 2012 at 7:00 PM

We have set up SLK on sharepoint and it's working quite well, but we also have requirement to export grades from slk to external system. What we basically need is the user name, assignemnt name, learner score and maximum score for that particular assignment. Maybe some of you already did such a thing and could share your thoughts or point me in the right direction? Maybe there is some bulit-in solution for that?

Thanks in advance.

Coordinator
Feb 7, 2012 at 8:06 PM

You'll need to look at the AssignmentItem, LearnerAssignmentItem and UserItem tables in the database.

Richard

SLK Coordinator

http://blog.salamandersoft.co.uk

Jun 8, 2012 at 2:30 AM
Edited Jun 8, 2012 at 2:30 AM

Here's a quick suggestion that works.

To export the data

Right click the SQL database.

the Source is your SQL native and destination is "flatfile" (a file like something.txt).

Export your view to this flat file.

 

 

Import data into Excel

Then Open excel and use the import data feature to import your .txt file.

Jun 12, 2012 at 12:48 PM
Edited Jun 12, 2012 at 12:58 PM

Here you go, I included Description, Final Score (which the Instructor gives) and the Instructor Comments.

 

SELECT DISTINCT 
                      dbo.AssignmentItem.Title AS [Assignment Name], dbo.AssignmentItem.Description, dbo.UserItem.Name AS Student, dbo.AttemptItem.TotalPoints AS [Graded Score], 
                      dbo.LearnerAssignmentItem.FinalPoints AS [Final Score], dbo.AssignmentItem.PointsPossible AS [Max Score], 
                      dbo.LearnerAssignmentItem.InstructorComments AS [Instructor Comment], dbo.LearnerAssignmentItem.IsFinal
FROM         dbo.AttemptItem RIGHT OUTER JOIN
                      dbo.AssignmentItem INNER JOIN
                      dbo.LearnerAssignmentItem ON dbo.AssignmentItem.Id = dbo.LearnerAssignmentItem.AssignmentId INNER JOIN
                      dbo.UserItem ON dbo.LearnerAssignmentItem.LearnerId = dbo.UserItem.Id ON dbo.AttemptItem.LearnerAssignmentId = dbo.LearnerAssignmentItem.Id
WHERE     (dbo.LearnerAssignmentItem.IsFinal = 1)

 

Cheers
/Simon