SISRA Analytics

Updating SISRA Analytics with your Arbor information has never been easier with our custom report writer. First, you'll need to export your pastoral information into SISRA, before you can export your assessment data.

Step 1 - Export pastoral information

Download this report and save the file on your computer until it's needed in the next steps. 

Go to School > Custom Report Writer and click on the Create New Report button, then click Import a report. A small window will then open.

Click on browse and locate the excel file you previously saved on your computer, then click Upload.

SISRA_Analytics_pastoral_export.gif

 

To reduce loading time, this report will default to being empty, so before downloading your report for each year group, you need to click Edit and scroll down to the 'Filters' section.

Add the relevant year group.

Screen_Shot_2020-01-16_at_10.13.36.png

Download the file in Excel format by clicking on the download button and choosing the format.

Run the file through the SISRA Excel Add-in before saving as a .csv (MS DOS) file.

 

Step 2 - Export your assessment marks for one year group

Go to School > Custom Report Writer and click on Create New Report in the top-right of the page. Then click Create New Report.

Choose your report title and under Who or what will this report be about? select Students, then click Next.

report_title.png

 

In Step 2, change the date range drop-down from Current Academic Year to Today.

current_year_to_today.png

 

In Step 3, type in ‘Arbor’ into the search box then drag the Arbor Student ID box over to the Added Columns section. A slide over will appear, where you can set the column label to Student ID, then click Save. Do not tick Unique MIS ID.

student_ID.png

 

Next, search for summative marks in the search box and drag this field over to the added columns section.

Screen_Shot_2020-01-16_at_15.46.07.png

 

Set the column label as the assessment subject.

Screen_Shot_2020-01-16_at_15.53.54.png

 

Next, set the start and end dates the mark falls into. If you want to use the latest mark for the student, set the dates to the start and end of your Academic Year.

Screen_Shot_2020-01-16_at_15.54.59.png

 

Next, select the Grade Point Scale that the assessment uses in the Stage/Scale drop-down menu, select the assessment, and if necessary change the Display Grade Set.

Screen_Shot_2020-01-16_at_15.56.42.png

 

Finally, leave Marked only ticked if you want Arbor to include the latest recorded mark for students - if unticked, Arbor will display a blank mark when a student has not been marked in the most recent assessment period. Then click Save.

Screen_Shot_2020-01-16_at_15.58.42.png

 

Repeat this for every assessment you need to add, then click Skip Setup Wizard.

skip_setup.png

 

On the next page, scroll down to the Filter section and type 'year group' into the Select filter box.  Select Year Group from the drop-down menu and click Add Filter. In the slide over, select the required year group, then click Save

year_group_filter.png

 

Click Save & View Report, then click the Download button to select to download it as an Excel file.

Once you’ve downloaded your report, open it in Excel and run the SISRA Excel Add-In to convert the file to the format required for import into SISRA.

download_to_excel.png


Top Tip: Quickly recreate the report for another year group  

If you need to quickly recreate the report for a separate Year Group, using the same assessments, just follow these steps:

  1. Click the Duplicate button, then in the duplicated report, click the Edit button.
  2. Edit the Report Title as required.
  3. Scroll down to the Filters section and click on the pencil icon next to the Year Group filter.
  4. In the slide over, change the Year Group, then save your changes and view the report.
I'm still stuck!
0 out of 0 found this helpful