E1877 Sort instructor reports by name, ID, score, etc

This wiki page describes the changes made according to the specification of E1877 OSS final project for Fall 2018.

---

Peer Review Information

The following credentials are recommended for testing the changes:

• Instructor Login: username: super_administrator2 password: password
• Youtube link:
• Github Pull Request Link: https://github.com/expertiza/expertiza/pull/1287

Introduction

Background

Expertiza is a web portal which can be used to manage assignments related to a course. It provides a platform to view assignments, manage teams, select topics and work on improvement through anonymous peer reviews.

Problem Statement

Expertiza allows instructors to view kinds of reports of assignments in their courses such as submissions, scores, and review reports. To improve the report views, some table columns such as team name, score, average should be made sortable by using the same existing sort library.

What needs to be done?:

• For “view submissions” table, sort “Topic name”, “Team name”, “Team member(s)”, “Links” alphabetically.

• For “View scores” table, sort “Team” alphabetically, sort “Average” and “Range” (the first percentage) in both ascending or descending order.

• For “View review report” table, “Reviewer” and “Metric” are already sortable, so we need to make other columns sortable: sort “Review done” by the first number then the second number (e.g., 0/1, 0/2, 0/3, 1/1, 1/5, 2/2...), sort “Team reviewed” alphabetically and sort “Score awarded / Avg. score” (the first percentage) in both ascending or descending order.

• For “Author feedback report” table, change the header name “Review response rejoined” to “Review responded to” and “Last rejoined at” to “Last responded at”. Then, sort “Rejoinder” and “Review “Review responded to” as string (alphabetically), sort “# author feedbacks done” by the first number then the second number (same as “Review done” in the “View review report” table) and sort “Last responded at” as date.

• For “Teammate review report” table, sort the first 3 columns as string and sort the last column as date.

Our understanding from the problem statement

We will be using tablesorter jQuery to sort the table. For table columns which have constraints on them for sorting, we will be creating custom scripts which tablesorter library supports to sort those columns.

Files modified

The following files were modified

• app/views/assignments/list_submissions.html.erb

Files Added

The following files were added

Testing Plan

Functional Testing

For “view submissions” table, sort “Topic name”, “Team name”, “Team member(s)”, “Links” alphabetically.

1. Login as an super_admininstrator2.
2. Click Assignments tab next to Courses
3. Select the "View submissions" icon for the assignment for which you want to see the report of
4. Sort the table by clicking on headers