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.
Download this report and save the file on your computer until it's needed in the next steps. Do not open the template.
You can then import it into your site by following these instructions: Importing a report
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, and click to edit the column.
Change this to be one particular year group.
Save and view the report, then 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.
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.
In Step 2, change the date range drop-down from Current Academic Year to Today.
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.
Next, search for summative marks in the search box and drag this field over to the added columns section.
Set the column label as the assessment subject.
The year will automatically populate. Select the assessment and assessment period, and if necessary change the Display Grade Set.
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.
Repeat this for every assessment you need to add, then click Skip Setup Wizard.
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.
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.
If you need to quickly recreate the report for a separate Year Group, using the same assessments, just follow these steps:
- Click the Duplicate button, then in the duplicated report, click the Edit button.
- Edit the Report Title as required.
- Scroll down to the Filters section and click on the pencil icon next to the Year Group filter.
- In the slide over, change the Year Group, then save your changes and view the report.