> For the complete documentation index, see [llms.txt](https://colah.gitbook.io/illuminate-bi-tool-guide/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://colah.gitbook.io/illuminate-bi-tool-guide/report_templates/studentrubric.md).

# Student Rubric Template

[**Click here to download the Student Rubric Report template.**](https://www.dropbox.com/s/s0ouieit1jdioc0/Rubric%20Template%20%286%20points%2C%206%20categories%29%20for%20DNA.jrxml?dl=0)

## Preview

### Student Rubric Report

![](http://dl.getdropbox.com/u/10575883/TIBCO_Jaspersoft®_Studio%208-30%20PM.png)

## Info

This report is designed to make it easier for teachers to give students feedback on their work using your district's custom rubrics. Teachers enter rubric scores into a simple summary assessment. The report then generates a highlighted rubric, indicating what scores they earned in each category with a description of what each score signifies.

This template was designed with generic field names, specifically to make it easier to use as a report template. If you rubric has fewer than 6 categories or fewer than 6 "points" or levels, simply delete the rows/columns you don't need.

## How to Use the Student Rubric Report Template

### Step 1: Create a Summary Assessment

The Summary Assessment is where teachers will enter the essay rubric data.

* Click: **Assessments > Create a New Summary Assessment**
* Give the assessment a title (optional: Select subject-area, scope, and grade levels)
* Click: **Columns**

![](http://dl.getdropbox.com/u/10575883/Demo_for_BI_Tool_Workshop___Illuminate_Education%207-26%20PM.png)

* Click: **+ Add Column**  (You will need one column for each category on your rubric.)  *Please do not create more than 6 columns.*  The template has 6 rubric categories and can be very easily adjusted to have fewer categories. 
* Set the **Column Type** to “Number” for all columns.
* Name the columns according to your rubric categories.  Save.

![](http://dl.getdropbox.com/u/10575883/Demo_for_BI_Tool_Workshop___Illuminate_Education%207-30%20PM.png)

* Use the student scope selector to pull up 2 or 3 students.  Click: **Find Students**
* Click: **by Student**
* **Enter data** for 2 or 3 students.  Keep the values *less than or equal to 6*.  The template uses a 6 point rubric and can be very easily adjusted if your rubric has fewer than 6 points. (This is just for testing.  You can delete this data later.)

![](http://dl.getdropbox.com/u/10575883/Demo_for_BI_Tool_Workshop___Illuminate_Education%207-42%20PM.png)

### Step 2: Create Your Custom Report

* Click: **Overview**.  Then, **+ Custom Report**.  Then, **Create**.
* Click on the title of your custom report to open the custom report.
* In the custom report, click: **Manage Columns**
* **IMPORTANT**: 
  * *The names of the columns must be EXACT in order for the report to work properly.*
  * Rename the columns in your custom report.   Make sure the column with the student ID #'s is named "Local Student ID".  (If the column is labeled "Student ID", you'll need to change it to "**Local** Student ID".)  
  * Rename the columns representing your rubric categories to: **Category1, Category2, Category3,** etc.    Click: **Save changes and View Report**.

![](http://dl.getdropbox.com/u/10575883/Manage_Data_Columns___Illuminate_Education%207-51%20PM.png)

### Step 3: Create Your Data Adapter

* Download the custom report as a tab delimited txt file.

![](http://dl.getdropbox.com/u/10575883/View_Report___Illuminate_Education%207-56%20PM.png)

* Open JasperSoft Studio.  In the top left hand of the screen, click the icon to **create a new data adapter**.

![](http://dl.getdropbox.com/u/10575883/Menubar_and_TIBCO_Jaspersoft®_Studio_and_Desktop%208-03%20PM.png)

* Choose **CSV File**.  Click **Next**.
* Name your data adapter.  Click: **File** and select the **data.txt** file that was created when you downloaded the custom report from Illuminate.   Click: **Open**

![](http://dl.getdropbox.com/u/10575883/Screenshot_9_15_15__8_07_PM%208-08%20PM.png)

* Next, click: **Separators** and select **tab**.
* Click: **Columns > Get Column names from the first row of the file**.  
* Check the box next to **”Skip the first line”**.  Click **Finish**.

### Step 4: Download and Customize the Student Rubric Report Template

* Download the report template  

[**Click here to download the report template.**](https://www.dropbox.com/s/s0ouieit1jdioc0/Rubric%20Template%20%286%20points%2C%206%20categories%29%20for%20DNA.jrxml?dl=0)

* In JasperSoft Studio, click: **File > Open File** and select the report template you just downloaded — will be a **.jrxml** file.
* Click the “DataSet” icon in the top right hand area of JasperSoft Studio.

![](http://dl.getdropbox.com/u/10575883/TIBCO_Jaspersoft®_Studio%208-20%20PM.png)

* Next, **select the data adapter** you just created, and click: **Read Fields**.  Save.

![](http://dl.getdropbox.com/u/10575883/Dataset_and_Query_Dialog_and_TIBCO_Jaspersoft®_Studio_Professional%208-21%20AM.png)

* **IMPORTANT**: In the outline, **expand the fields** menu, **select all the “Category” fields**, and change the class from “java.lang.string” to “**java.lang.Double**”.  (This tells JasperSoft to read these fields as numbers, instead of text.)

![](http://dl.getdropbox.com/u/10575883/TIBCO_Jaspersoft®_Studio%208-37%20PM.png)

* IF your data contains fewer than 6 categories, **delete the extra categories from the rubric** before running the report.
* **Preview** the report.

![](http://dl.getdropbox.com/u/10575883/TIBCO_Jaspersoft®_Studio%208-30%20PM.png)

**TIP**: If you get an error, verify that the **”Ignore First Line”** option is selected in your data adapter. (The first line is your header row.) Double-click on your data adapter, and make sure the box is checked.

### Step 5: Customize the rubric in JasperSoft Studio

* If your report is generating successfully, now we are going to **add a calculation** and **customize the text** in the report to match your rubric.
* Click the **Design** tab.
* **Double-click the calculation** field right next to “Overall Score” at the bottom of the rubric.  
* Remove the existing text and **enter your calculation** for the overall score.
* Your calculation should look something like (adjusted for the number of categories in your rubric):  
  * ($F{Category1}+$F{Category2}+$F{Category3}+$F{Category4}+$F{Category5}+$F{Category6})/6
* Double click on any text field in the rubric to adjust the text.
* Don’t forget to save!

![](http://dl.getdropbox.com/u/10575883/TIBCO_Jaspersoft®_Studio%208-34%20PM.png)

### Step 6: Deploy the Report

* Login to Illuminate.  Click: **Reports > Create a New Jasper Report**
* Name your report.  **Select the .jrxml** file you have just created, and **select the custom report** you created in Step 2.
* Save, and you’re done!
* Finally, click: Reports > List Reports.  Search for you report and run it!

Now, as teachers enter data into the summary assessment, Illuminate will automatically generate a hi-lighted rubric for every student.