click here for details... Sakai Executive Director Position Search now open
Issue Details (XML | Word | Printable)

Key: SAK-4399
Type: Task Task
Status: Closed Closed
Resolution: Fixed
Priority: Major Major
Assignee: Huong Nguyen
Reporter: Marc Brierley
Votes: 0
Watchers: 1
Operations

If you were logged in you would be able to see more operations.
Sakai

Allow students' responses to be exported to Excel.

Created: 20-Apr-2006 03:33   Updated: 24-Oct-2008 06:21
Component/s: Tests & Quizzes (Samigo)
Affects Version/s: trunk [DO NOT USE]
Fix Version/s: 2.5.0

Time Tracking:
Not Specified

Issue Links:
Duplicate
 

2.6.x Status: None
2.5.x Status: None
2.4.x Status: None


 Description  « Hide
Allow students responses for all question types, (except file upload and audio recording) to be exported to Excel. Adding Export page and "Export" links on all grading pages in Samigo. See p. 21 on mockup:

http://issues.sakaiproject.org/confluence/download/attachments/46190/grading.pdf

 All   Comments   Work Log   Change History   Subversion Commits   git Commits      Sort Order: Ascending order - Click to sort in descending order
Marc Brierley added a comment - 20-Apr-2006 03:36
Lydia - You might want to contact Steve Githens (s-githens@northwestern.edu) about how to check-in his code.

Lydia Li added a comment - 01-May-2006 18:54
waiting for Steven to finish his code.

Peter A. Knoop added a comment - 19-Apr-2007 04:42
Is this still an active issue as of Sakai 2.4?

Karen Tsao added a comment - 30-Aug-2007 13:27
This work is based on contributed code from Charles Hedrick (Rutgers Univ.). Thanks to Charles for contributing his code for this feature.

add -N C:\sakai\sam\samigo-app\src\webapp\jsf\evaluation\exportResponses.jsp
    A C:/sakai/sam/samigo-app/src/webapp/jsf/evaluation/exportResponses.jsp
add -N C:\sakai\sam\samigo-app\src\java\org\sakaiproject\tool\assessment\ui\listener\evaluation\ExportResponsesListener.java
    A C:/sakai/sam/samigo-app/src/java/org/sakaiproject/tool/assessment/ui/listener/evaluation/ExportResponsesListener.java
add -N C:\sakai\sam\samigo-app\src\java\org\sakaiproject\tool\assessment\ui\bean\evaluation\ExportResponsesBean.java
    A C:/sakai/sam/samigo-app/src/java/org/sakaiproject/tool/assessment/ui/bean/evaluation/ExportResponsesBean.java
commit -m "SAK-4399" C:/sakai/sam/samigo-app/pom.xml C:/sakai/sam/samigo-app/src/java/org/sakaiproject/tool/assessment/bundle/EvaluationMessages.properties C:/sakai/sam/samigo-app/src/java/org/sakaiproject/tool/assessment/ui/bean/evaluation/ExportResponsesBean.java C:/sakai/sam/samigo-app/src/java/org/sakaiproject/tool/assessment/ui/listener/evaluation/ExportResponsesListener.java C:/sakai/sam/samigo-app/src/webapp/jsf/evaluation/exportResponses.jsp C:/sakai/sam/samigo-app/src/webapp/jsf/evaluation/histogramScores.jsp C:/sakai/sam/samigo-app/src/webapp/jsf/evaluation/questionScore.jsp C:/sakai/sam/samigo-app/src/webapp/jsf/evaluation/submissionStatus.jsp C:/sakai/sam/samigo-app/src/webapp/jsf/evaluation/totalScores.jsp C:/sakai/sam/samigo-app/src/webapp/WEB-INF/faces-config.xml C:/sakai/sam/samigo-services/src/java/org/sakaiproject/tool/assessment/facade/AssessmentGradingFacadeQueries.java C:/sakai/sam/samigo-services/src/java/org/sakaiproject/tool/assessment/facade/AssessmentGradingFacadeQueriesAPI.java C:/sakai/sam/samigo-services/src/java/org/sakaiproject/tool/assessment/facade/PublishedAssessmentFacadeQueries.java C:/sakai/sam/samigo-services/src/java/org/sakaiproject/tool/assessment/facade/PublishedAssessmentFacadeQueriesAPI.java C:/sakai/sam/samigo-services/src/java/org/sakaiproject/tool/assessment/services/assessment/PublishedAssessmentService.java C:/sakai/sam/samigo-services/src/java/org/sakaiproject/tool/assessment/services/GradingService.java
    Sending sakai/sam/samigo-app/pom.xml
    Sending sakai/sam/samigo-app/src/java/org/sakaiproject/tool/assessment/bundle/EvaluationMessages.properties
    Adding sakai/sam/samigo-app/src/java/org/sakaiproject/tool/assessment/ui/bean/evaluation/ExportResponsesBean.java
    Adding sakai/sam/samigo-app/src/java/org/sakaiproject/tool/assessment/ui/listener/evaluation/ExportResponsesListener.java
    Sending sakai/sam/samigo-app/src/webapp/WEB-INF/faces-config.xml
    Adding sakai/sam/samigo-app/src/webapp/jsf/evaluation/exportResponses.jsp
    Sending sakai/sam/samigo-app/src/webapp/jsf/evaluation/histogramScores.jsp
    Sending sakai/sam/samigo-app/src/webapp/jsf/evaluation/questionScore.jsp
    Sending sakai/sam/samigo-app/src/webapp/jsf/evaluation/submissionStatus.jsp
    Sending sakai/sam/samigo-app/src/webapp/jsf/evaluation/totalScores.jsp
    Sending sakai/sam/samigo-services/src/java/org/sakaiproject/tool/assessment/facade/AssessmentGradingFacadeQueries.java
    Sending sakai/sam/samigo-services/src/java/org/sakaiproject/tool/assessment/facade/AssessmentGradingFacadeQueriesAPI.java
    Sending sakai/sam/samigo-services/src/java/org/sakaiproject/tool/assessment/facade/PublishedAssessmentFacadeQueries.java
    Sending sakai/sam/samigo-services/src/java/org/sakaiproject/tool/assessment/facade/PublishedAssessmentFacadeQueriesAPI.java
    Sending sakai/sam/samigo-services/src/java/org/sakaiproject/tool/assessment/services/GradingService.java
    Sending sakai/sam/samigo-services/src/java/org/sakaiproject/tool/assessment/services/assessment/PublishedAssessmentService.java
    Transmitting file data ...
    Committed revision 34609.

Karen Tsao added a comment - 31-Aug-2007 13:52
commit -m "SAK-4399" C:/sakai/sam/samigo-app/src/java/org/sakaiproject/tool/assessment/bundle/EvaluationMessages.properties C:/sakai/sam/samigo-services/src/java/org/sakaiproject/tool/assessment/facade/AssessmentGradingFacadeQueries.java C:/sakai/sam/samigo-services/src/java/org/sakaiproject/tool/assessment/facade/AssessmentGradingFacadeQueriesAPI.java C:/sakai/sam/samigo-services/src/java/org/sakaiproject/tool/assessment/services/GradingService.java
    Sending sakai/sam/samigo-app/src/java/org/sakaiproject/tool/assessment/bundle/EvaluationMessages.properties
    Sending sakai/sam/samigo-services/src/java/org/sakaiproject/tool/assessment/facade/AssessmentGradingFacadeQueries.java
    Sending sakai/sam/samigo-services/src/java/org/sakaiproject/tool/assessment/facade/AssessmentGradingFacadeQueriesAPI.java
    Sending sakai/sam/samigo-services/src/java/org/sakaiproject/tool/assessment/services/GradingService.java
    Transmitting file data ...
    Committed revision 34636.

Karen Tsao added a comment - 31-Aug-2007 13:58
Forgot this one:
commit -m "SAK-4399" C:/sakai/sam/samigo-app/src/java/org/sakaiproject/tool/assessment/ui/bean/evaluation/ExportResponsesBean.java
    Sending sakai/sam/samigo-app/src/java/org/sakaiproject/tool/assessment/ui/bean/evaluation/ExportResponsesBean.java
    Transmitting file data ...
    Committed revision 34637.

Huong Nguyen added a comment - 27-Sep-2007 11:09
verified on qa1-nl and it was corrected exported as in the spec.
1. Anonymous grading
2. Nonanoymous grading
3. Name of excel file