Tutorial 5: Summary of Performance

We will create prebuilt report using Jaspersoft Studio summarizing student performance on an assessment. We will create a summary at the end of list by student gender. Using variables we will count the number of students in each performance band. Using a stacked bar chart you will graph the number of students at each grade level by school. Last, we will create a summary at the end of each school to show the distribution by grade level. We will use a CSV connection (Custom Report) Data Adapter as the data source for this report.

Here is a sample of what your final report should look like:

1. Create a custom report that contains Student ID, performance band results from two state or national tests (NWEA, assessments, CELDT, etc.). For this example, use filters to only include students that have results on both tests.

2. Create a new Jasper Report, adding the parameter ILLUMINATE and change the query language to illuminate_custom.

3. Add the following additional parameters: site, gender, is_sed, is_special_ed, and race_slash_ethnicity. They are all of type 'String' and can be used to display in your report.

4. Create variables counting the total number of students with results on each assessments.

5. Create variables counting the number of students in each Performance Band.

6. Create a variable computing the percent of students in each band. Note: Check that the total number is not zero, as you cannot divide by zero.

7. Collapse all bands except Title and Summary.

8. Add a title to your report using the Text Field element. Include the "site" parameter in the title.

9. Create a bar chart to display the results of one of your assessments selected.

10. Configure your chart to have a color of your choice for the bars. Make the maximum RANGE value 100. Select "TRUE" to display data labels.

11. Create a Stacked bar chart to display two categories, which will be each assessment. Each bar contain the percent of students in each performance band on an assessment.

12. Add Text Fields to annotate your report with findings. In this example, sentences with the number of students Exceeding / Meeting Standard are included.

13. Publish your report in Illuminate.

14. Test Running the report.

Sample JRXML Here: https://cdn1.illuminateed.com/bi/nweaprojectedproficiencysample.jrxml

Did you know Illuminate can build your BI Tool for you? Click here to learn about Illuminate's Report Building Service.