Download the results of the worksheets as a simple Excel document. How? We'll show you!
Excel Export is a useful feature of Redmenta. It allows you to download the result data of a worksheet to your own device in an Excel document. This allows you to generate additional statistics in Excel using the usual operations in the most suitable application. Export the Excel file from the Evaluation menu of the worksheet, as shown in the picture:
The Excel spreadsheet also contains all the data found in the Table View on Redmenta, but here, they are put into an editable form where you can quickly and easily create additional operations and statistics. In the Excel file, the sheet called Overview displays the following fill-in data separately for each student:
- name of person completing the worksheet
- number of times the worksheet was completed
- group (to which group the respondent belongs)
- Evaluation (feedback/mark based on the evaluation settings)
- Percentage achieved
- Score achieved
- Max score of the worksheet
- Start time (when the completer started the completion)
- Fill duration (the time elapsed between starting and submission)
In addition to the Overview, there are other Excel sheets, but it is important to note that these are only available for download with a Redmenta subscription. A big advantage of the subscription is the detailed Excel Export. So, in the following, we will only talk about the sheets available with subscriptions:
Clicking on the Not filled Excel sheet, you will see the people with whom the worksheet is shared either personally or as a member of a group and have not yet completed it.
In the Summary by tasks sheet, the maximum and achieved score of the assignments is displayed. Each task is shown in a separate column, and below it you can see the maximum reachable score for that task and the actual score achieved. This makes it easy to compare the tasks that were solved with good results and those that were less successful.
In the detailed Excel export, you can also select which tasks you want to save to a separate spreadsheet. As shown in the image below:
