Tutorial 6: CELDT Longitudinal Summary

We will create prebuilt report using Jaspersoft Studio summarizing student performance on an CELDT over the last five years. 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. We will use a CSV connection (Custom Report) Data Adapter as the data source for this report.

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

1. For the data source, create a custom report with the columns shown below. If you are part of a large district, you may want to filter your results to work with a smaller set as you develop your report.

   

   (Student ID, Last Name, First Name, Gender, Current Grade Level, 2011-2015 Proficiency Level Overall, 2011-2015 CELDT Prof Level Text)

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 CELDT each year.

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

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

10. Click on the chart and configure the chart colors in Plot > Series Colors

11. Click on the chart, click Plot > Item Labels > TRUE

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/celdtlongitudinalsummary.jrxml

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