The Excel question type is available to all customers across all plan types and can be accessed through the Create Assessment Editor.
Overview of the Excel Autograded Question
The Excel question type is Autograded, meaning it automatically evaluates the candidate’s answer based on a correct answer sample or test case. This type is ideal for Excel tasks that require numerical calculations. Please note: it is not suitable for tasks involving graphs, Pivot tables, or any other features that cannot be graded via a cell.
Adding an Excel Question to an Assessment
To add an Excel Autograded question:
- Open the Create Assessment Editor.
- Choose the Excel question type.
- You’ll be prompted to either upload an Excel file (max 10MB) or create a new file.
Once you’ve added your Excel content, the correct answer option will appear. This feature requires at least one correct answer (like multiple-choice questions or test cases in code challenges). You must select the cell in Excel where candidates will input the correct answer and correlate it with your correct sample.
Configuring Correct Answers and Scoring
- You can add multiple correct answers for a question, with each correct answer earning up to 1/10 of a point (based on the total value of the question).
- Important Note: If there are more than 10 correct answers, the value of each correct answer will decrease accordingly.
The candidate’s answer must match the correct answer exactly. Ensure you provide instructions asking candidates not to change the formatting of the cell. Additionally, multiple correct answers can be set if there are different valid ways to format the response (e.g., 10 and 10.00).
Verifying Answers
To check if the answers entered match the correct ones:
- Input all correct answers into the Excel file.
- Click ‘Check’, and the system will compare the candidate’s input with the correct answer, ensuring the formatting and answer are correct.
Candidate Experience
The Excel question will open in a full-screen view for the candidate, providing them with a clear workspace to complete the task.
Correcting Scores
If you need to amend a score (e.g., if 10 and 10.00 should be considered the same), you can update the score manually after grading. Once the score is updated, the question and overall assessment scores will be recalculated.
Note: This score correction functionality is not available on the integration candidate card or shared candidate cards.
Need Help?
If you have any questions or need assistance with the Excel question type, feel free to contact us at support@vervoe.com.