What is a Spreadsheet Test module? A Spreadsheet Test module allows you to assess participants' skills in analyzing and organizing spreadsheets. This module is particularly useful for roles that involve finance, accounting, and administration tasks.

Step by step on how to create a spreadsheet module #

You can opt to create a “Spreadsheet,” which will lead you to the following page:

This spreadsheet module has already been automatically generated but not completed yet! Every component here is crucial, so please review each element meticulously.

1. Module name _^IMPORTANT
   Initially, we will populate it with the title “Untitled Module” by default.
2. Module detail bar
   You can configure specific details for this particular module.
   • Module duration _^IMPORTANT
     You can select the maximum duration within which participants are allowed to work on this assessment. The range varies from 5 minutes to a maximum of 1 hour.
   • Module language
     You have the option to choose English, Bahasa Indonesia, or both languages. Simply click on the desired language(s) until they turn blue.
   • Description
     Provide a description to inform other users about the content and purpose of this module.
   • Instruction
     Change the instructions to guide participants on what to expect and any specific preparations they need to make before starting the test. Rest assured, we have already provided default content by default. Therefore, there’s no need to worry about making changes.
   • Difficulty level
     You can choose from options such as ‘No Difficulty,’ ‘Easy,’ ‘Medium,’ and ‘Complex’ to indicate the level of difficulty for this module.”
   • Category _^IMPORTANT
     Tagging under the appropriate category that best suits this test.
   • Suitable Position _^IMPORTANT
     Tagging under the appropriate job category that best suits this test.

1. Question description _^IMPORTANT
   Enter the question description in this space. You are welcome to include images or files to enhance the content.
2. Test File _{^{IMPORTANT AND MANDATORY}}
   Upload your working sheet here. This working sheet will be available for download and will serve as the foundation upon which participants will complete their tasks. It provides the initial structure and context for participants to work on.
   
   Grading File
   After uploading your working sheet, you’ll find an ‘Add Grading File’ button. This feature allows you to include a grading file, which ensures that participant answers are not hardcoded with specific values. You’ll need to provide a separate set of data with the same structure but different values.
   
   Once you’ve uploaded your grading file, you’ll need to highlight the data that distinguishes the Grading file from the Working file. Then, click the ‘Add Dataset’ button. This step informs our grader system about the specific data to reference in your grading file for accurate calculation.

3. Test Case _{^{IMPORTANT AND MANDATORY}}

Moving forward, you can proceed to add your test cases. Fill in the mandatory fields based on your working file and the expected results as outlined in your grading file’s spreadsheet.

If you designate a test case as non-grading (Use Grading > No), it will be referring to the working sheet data. This type of test case will make the values available for participants to view.

On the other hand, if you designate a test case as a grading test case (Use Grading > Yes), it will be evaluated against the grading file data set. This kind of test cases will remain hidden from participants. Participants will only be informed whether their response is correct or incorrect without viewing the detailed test case results.

To complete the process, click ‘Save’ to submit your final changes. If you’d like to see a preview of the module, click on ‘Preview’.

FAQ On Spreadsheet Module #

Can I add multiple questions to this module type? #

No, Algobash 2.0 does not support multiple questions within this module type. Each module is designed to focus on a single question.

What occurs if I activate multiple languages? #

If you activate more than one language, participants will be able to view and interact with the assessment in their preferred language. However, it’s important to note that you’ll need to input translations for question descriptions and options in each of the activated languages to ensure a seamless experience for participants.

Can I preview the module before finalizing it? #

Yes, you can preview the module by clicking the “Preview” button. This enables you to review how the module will appear to participants before saving the changes.

What if I want to make changes after creating the module? #

You can always edit and modify the module by accessing it from your module list:

Click the ‘Details’ button and click the “Edit” button.

Can I reuse the same module for different assessments? #

Yes, you can reuse the same module for different assessments within your organization. This feature streamlines the creation process and ensures consistency.

What kind of tasks can I include in a Spreadsheet Test module? #

You can include tasks that require participants to manipulate data, create formulas, format cells, and perform calculations using spreadsheet software.

Can I tailor the test to specific roles or industries? #

Absolutely, you can customize the Spreadsheet Test to align with the specific skills and tasks relevant to roles within your organization.

Alternatively, we can create a custom module tailored to your specific requirements.