Spreadsheet

Spreadsheet questions are useful for assessing students' ability to understand and use spreadsheets to analyze and report tabular data. Question authors create spreadsheet templates to be completed by students. Student responses are automatically scored and immediate feedback is optionally provided to the student.

How it looks

Imagine a scenario where an accounting teacher wants to test her student's ability to create an income statement. She creates a template with a list of bank transactions and a template for an income statement and prompts the students to complete the income statement.

The author of the question chooses an option to score the cells by formula (vs by value). Students are expected to use forumlas to fill out the line items in the income statement and to compute the revenue and expense totals and net income.

How it works

The Artcompiler spreadsheet question type is purpose built for assessment. In addition to providing common spreadsheet user experience, it is designed to be tightly integrated with assessment platforms.

Key features of the spreadsheet question type include:

• Scoring individual cells by formula or value equivalence
• Using common formula syntax and function names
• Marking cells to be completed by the student to hide the expected response
• Protecting cells and regions to make read-only parts of the question template
• Styling and formatting cells and regions using standard spreadsheet features