E1912 Export Tags

Introduction

About Expertiza

Expertiza is an Open Source Web Application Software managed by National Science Foundation. Expertiza is used by many courses including CSC 517 for assignment management. It has functionalities such as peer reviews, teammate reviews and tagging reviews in which students can provide feedback on other's work which helps peer in better developing the project.

Motivation

The Expertiza team currently had to manually fire queries in the database in order to get the tag submissions made by an individual user(student) on each review for a particular assignment. In this way, the team got the data from the entire class, which was then used to feed the Machine Learning algorithms. But many times it used to happen that students made random tags and the ML algorithm was not able to make good predictions out of it, hence in order to solve this issue a new idea was proposed as to select on the students which did not create outliers in the predictions and hence, therefore, it is a good proposal.

Tasks Identified

In order to perform this task following files were identified where the code hasbeen added.

• In _answer_tagging_report.html.erb view, a button is added for exporting the student's tagged values
• A checkbox for each row has been added in order to select students whose tags are to be exported(By default all will be selected).
• A method is written in export_file_controller.rb controller named export_tags that exports the CSV file.

Implementation

We have added a default select all checkbox under Report tags done by each user which enables student selection for exporting tags in the CSV file. We have added a column for the checkbox and a button named Export which on click generates the CSV file.

Below is the snippet of same view _answer_tagging_report.html.erb .

Definition, Demo code and snapshots

We have written a method inside the export_file_controller.rb. Once this method is called it queries on the name array passed from the view and exports the CSV file with the required data.

The output file has user_id, tag_prompt_deployment_id, comments and value. We can see that some comments are repeated it is because every review that is received has at least 1 tag for it. Hence we see the repetition. The value column has -1, 0 and 1 as No, not answered and Yes meaning respectively.

Teammates

Mentor - Harsh Agrawal

• Aishwarya Subramanian (asubram7)
• Dyuti De (dde)
• Ankit Mody (amody)

Future work

The task accomplished is of added a checkbox in the view so that students can be selected as required. The following are a few which were identified as part of this project.

• Adding a javascript function in view so that it stores the username of every student which is selected in an array.
• Defining a query which will extract the data based on the usernames of students from USERS, ANSWERS and ANSWER_TAGS.
• Writing a method in report_formart_helper.rb that exports the csv file.