SQL Test Scoring in Alooba
Alooba's SQL test offers a powerful way to assess participants' proficiency in SQL querying, allowing you to efficiently evaluate participants' SQL skill levels. This article provides a comprehensive overview of how SQL tests are scored in Alooba.
Purpose of the SQL Test
The SQL test is a valuable component of Alooba assessments, designed to gauge participants' ability to craft and execute complex SQL queries. In this test, participants are presented with scenarios, database tables, and corresponding data. They're then required to formulate SQL queries that extract information/perform specific actions with the provided database.
How Alooba's SQL Scoring Works
The Alooba SQL scoring process comprises three distinct phases, providing you with a spectrum of options for assessing SQL queries. This range extends from complete automation to manual grading, and from basic validation to a more intricate method that allows for partial scoring. You are empowered with a variety of choices tailored to your requirements and capabilities.
- As soon as a SQL Test is submitted, Alooba will execute the queries and check if the outcome matches what is expected. Full marks will only be granted if the query does exactly what was expected.
- For select queries, Alooba will compare the generated output with the expected output.
- For questions where the query is expected to modify the data, their query will be run then the resulting data in the table will be compared with the expected post-run data.
Subsequently, if the partial scoring feature is enabled and the participant did not achieve a full score in the first step, the system will engage in query analysis to determine if any partial marks should be awarded. This analysis entails comparing the participant's query with a large set of known successful queries to determine how close they were to a correct answer. Partial marks will be assigned based on the degree of resemblance to an effective query.
* If partial scoring is not enabled, and they didn't get full marks they will get a score of 0 for the question.
- Lastly, you retain the ability to manually provide your own custom evaluation, overriding the automated score assigned by the system.
Accessing SQL Scores
On the participant's page, if they have completed a SQL test, there should be a SQL tab available. On the SQL tab of the participant's page you will be able to see their total score for the SQL test, and can select individual questions to see how they answered each.
Their awarded marks will be shown for the currently selected question, and you can see a side-by-side view of an example of a correct query with their query. As well as the expected output compared to their output.
If you believe that they deserve more or less credit for their effort you can easily modify the awarded marks and their test score, along with their overall score will automatically be immediately updated.
How to Enable Partial Scoring
To utilize the automated SQL scoring feature, ensure the "Grant Partial Mark" option is enabled when adding the SQL test to the assessment/exercise. This empowers the system to automatically analyze and assign partial scores based on query similarities.
Conclusion
SQL scoring in Alooba is designed to automate and streamline the evaluation process of participants' SQL proficiency. This scoring system can be configured to offer a basic evaluation of queries as either correct or incorrect, or it can be customized for a sophisticated approach that provides greater depth in assessing SQL queries and assigning partial marks accordingly.
By understanding how the scoring works and its options, you can efficiently evaluate assessments and exercises, save time, and provide fair and accurate scores to participants.
For any further assistance or inquiries, don't hesitate to reach out to Alooba Support.