Getting your assessment data out of VSware and into SchoolWise involves a couple of steps. This article will walk you through each of them.

1. Export your data from VSware

Go to the Assessment screen in VSware and then click into the Results Crosstab screen. Here you can choose the class, exam and other options. Simply place a check next to all the classes you want to include in the export and then choose the exam from the next drop-down.

Make sure the following options are selected;

  • Include Study Level is set to Yes and the 
  • Include Points is set to New Leaving Cert. Also make sure that the 
  • Include SEN flag, Include Average and Include Extra Fields are all set to No. 

Once you are done selecting your options click the Go button to generate the report and finally click the Export to Excel button. You can then save the file onto your computer or device.

Note: You can select all Junior Cycle classes as one export. You will need to select all Senior Cycle classes as an additional export. This will create two files that you will need to import into SchoolWise.

2. Prepare the file

Once you have exported the file, you will then need to delete the header rows and save it as a CSV or Comma Separated Values. To do this simply open the exported file with Microsoft Excel or Google Sheets.

Excel

  • Highlight the first two rows and delete them so that the Name, Class, etc. is the first row in the file
  • Click on File and Save As
  • Select CSV (Comma Delimited) in the Save as type
  • Choose the location to save the file

G Suite

  • Highlight the first two rows and delete them so that the Name, Class, etc. is the first row in the file
  • Click on the File menu
  • Select the Download option and then click Comma-separated values
  • This will download the file to your device

3. Import the file into SchoolWise

Navigate to StaffCentral and then click on the VSware tile to open the screen. 

Note: You will need full administration privileges to import the file into SchoolWise


Then click on the Import tile to display the import screen

All you now need to do is locate the file you prepared in the previous step by clicking on the uploader. Once you click on the file the import process will start.

Note: this can take a few seconds to a couple of minutes depending on the number of learners in the file

When the import has uploaded the data, the last step is to simply enter the Assessment Task/Activity name that should appear in the Gradebook along with the Date the exam took place. 

Once you have completed these details, you simply need verify the import. All the learners will have been matched automatically. Any learner that did not match (usually no longer in the school) or an individual result (learner has changed class/subject) needs to be manually matched and will be highlighted in red. 

If the learner is no longer in your school you can simply ignore it. Otherwise you need to match them up. To do this simply click on the learners name, search for the learner in your school and once you locate them just click on their name to select them. Finally, click the Assign button.

If a class does not match you can click on the result to display the search box. Search for the class and then click the Assign button.

Learner not matched

Class not matching

Once everything is matched you are ready to complete the import. Scroll down to the end of the screen and you will notice the Summative Task/Activity toggle is on to indicate that this is a summative task (Which can be filtered later). The Ignore Error toggle is off indicating that all records must be matched before you can import. If you want to ignore those records where learners or results did not match simply toggle this to on. 

When you have finished choosing your options click the Import button to complete the process. Teachers can now see the imported data in their Gradebook and reports.


Did this answer your question?