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

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. You'll be presented with a list of those reports defined for the current assessment:

Defining a New Report

To create a report, enter a report name in the space provided at the bottom of the list and click the create button. Note that you may define multiple reports. There is no limit on the number of reports that you may define.

Deleting a Report

To delete a report, click the associated delete button to the left of the report's title, check the deletion enable checkbox and finally click the Delete Selected Report button.

Editing Reports

To edit a report, simply click on its name in the list of reports.

You may choose to have the report:

• presented on a web page - when you choose to generate the report, it will be generated as a simple web page.
  
  
• 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.
  
  
• 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.
  
  
• emailed - specify an email address in the space provided and the report's contents will be e-mailed as a tab-delimited spreadsheet attachment. This is especially handy if you need to regularly report scores to administrators or managers.
  
  v4.3.2+ - Multiple comma-separated e-mail addresses may be specified in the space provided.

Listed 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 checkboxes to have the associates fields included in the report. The order of the items shown when the report is generated is controlled by the order field. If you wish to move items around, simply change their order number and click update.

The fastest way to order items on your report is to click their checkbox in the order in which you wish them to appear. Then click update to save your changes.

If you wish to remove some listed fields from the report, simply uncheck the associated checkbox and click the update button.

Sort Options

You may choose to have the report records sorted. You may specify up to three keys which will be used to sort the data in alphabetical ascending order. The date/time key is sorted in proper order.

To delete a sort key, simply set it to the same value as another key and click update.

Conditional Inclusion of Submission Records

By default, all participant submissions are included in the report. You may, however, choose to narrow the scope of the report. The first step in this process is to decide you you wish to narrow the scope. Specifically, you need to choose the fields upon which you wish decisions to be made. Check each appropriate field's condition check box and click update report definition.

Once you have picked fields for decisions, you'll be presented with a list to define those decisions as shown below:

You may impose as many conditions as you wish. To add a new condition, simply make your selections and enter a value in the new condition area and click update report definitions. Records must satisfy all listed conditions in order to be presented on the report.

Each condition supports two types of actions:

include when - if the condition evaluates to true, the record will be included on the report.
exclude when - if the condition evaluates to true, the record will be NOT included on the report.

The fields available for decisions are those that you have checked in the field list above. To add more, simple check the appropriate boxes above and click update. Note that the decision fields need NOT appear on the actual report.

We support both number and alphabetic comparisons. The tests supported are as follows:

Numeric Comparisons	Alphabetic Comparisons
equality inequality greater than greater than or equal less than less than or equal	equality (case sensitive) inequality lexically greater lexically greate than or equal lexically less than lexically less than or equal contained within starts with ends with

Dates are considered numbers for comparison purposes.

Generate the Report(s)

Click 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.

Scheduled Generation of Reports - v4.3.2 and above

You may select to have a report generated automatically at selected times. In such a case, the report must be configured to be generated as a file or e-mail. A list of such scheduled generations is shown when editing a report.



In the example above, there are four scheduled generations of this report. Reports may be generated once at a particular time and date or on a repeating basis; either daily at a particular time, weekly on a particular day at a particular time or monthly on a particular day at a particular time.

Simply make selections from the controls shown to choose when you wish the report generated. Check the Add checkbox and click update report definition to schedule a new report.

To delete a scheduled generation, check the Delete checkbox associated with the entry in the list and click update report definition.