Custom Reporting v4.1.2 and earlier	Back - Viewing Submissions Up - Submission Mgmt Next - Scoring
Click here for a discussion of custom report definition using Test Pilot Enterprise v4.1.3 and later

view participant responses download a spreadsheet of responses for further analysis view question statistics including: frequency analysis of responses with a bar graph mean, maximum and minimum point awards survey question statistics and other statistical items of interest define and generate custom reports as: web pages spreadsheets server files for automated analysis

Custom Reporting

With Test Pilot's custom reporting features, you can select what participant response data you want shown and how you want it presented. From the owner options screen, you can click Custom Reports to begin the process of report definition.

When defining a custom report, note the Update button at the top and bottom of the web page. Any time you make a change to one of the settings, click the update button to save those changes.

Step #1 - Define a New Report Name

Before you can add fields to a report, you must first create a new report. Do that by entering a report name in the box provided at the bottom of the web page and click update:

Step #2 - Add Fields to the Report

A list of possible fields to be included on your report is shown at the top of the web page. Consider the following sample field listing:



Included are fields for the participant information and score for each submission as well as their scores for each question and partial scores for each group of questions.

Powerful Feature
Test Pilot calculates a partial score for every defined group of questions whether they are enabled or not. This permits you to define groups of questions which, while they may not be used for grouping questions on a test, they can be used to see how participants are doing in a particular subject area. It is through custom reporting that you can view this information.

You may click on the fields to select them. Hold down the command or control key to click on multiple items. Once you have made your selection, choose the report to which you wish the fields added from the pop-up menu shown below the field list. Note that you may define multiple reports. There is no limit on the number of reports that you may define.

Once you have chosen the fields and selected the report you wish, click update to have Test Pilot add the fields to the selected report.

Step #3 - Setting Report Options and Editing Reports

Once you have added the fields to the report (the fields are presented one the report in the order that they are listed in the report's fields box), you should see a screen similar to the following:



You can choose to have the report:

1. presented on a web page - when you choose to generate the report, it will be generated as a simple web page.
   
   
2. downloaded as a spreadsheet - when you choose to generate the report, a tab-delimited file containing the report data is generated and sent to your browser. If your browser is configured to open your spreadsheet program with documents with a MIME type of application/excel, the spreadsheet will automatically open.
   
   
3. saved to a local file - specify a filename in the space provided and when the report is generated, it will be saved as a tab delimited file in the assessment's server directory. You may not choose to have the report saved elsewhere on the server for security reasons.

Powerful Feature
Since Test Pilot can generate score data in a tab-delimited format to a server file of your choosing, Test Pilot assessments can be quickly integrated into any online course or grade-management solution.

If you wish to remove some listed fields from the report, select the field names by clicking and/or control/command-clicking upon them and check the remove selection from report checkbox. Click the update button and the fields will be removed from the list.

If you wish to delete the whole report, click the report's delete this report checkbox and click the update button.

Step #4 - Generate the Report(s)

Click Return to Owner Options to return to the administrative options page where you can then use the Generate Report button and its associated pop-up menu to generate your custom reports.