This repository contains SQL scripts that serve specific purposes related to text-base answer analysis. Below is a breakdown of each script, its purpose, and usage instructions.
File Name: SubmissionSimilarityChecker.sql
Purpose: This script identifies similar submissions based on text responses. It compares 'completed' submissions (newly received and needing checks) with 'passed' submissions (already approved). The script uses string matching for older submissions and similarity functions for recent ones.
Usage:
- Replace
{{Project ID}}with the specific project ID you're targeting. - Run the script in your SQL environment.
File Name: SubmissionComparison.sql
Purpose: This script compares responses from different submission statuses. It mainly distinguishes between 'completed' (newly received) and 'passed' (already approved) submissions. The comparison assesses the similarity of answers based on their text, user, and item IDs.
Usage:
- Replace
{{Project ID}}with the specific project ID you're targeting. - Run the script in your SQL environment.
Note: Ensure that you have the necessary permissions and that the database is properly backed up before running any script. It's also recommended to run these scripts in a test environment first.