|

Exporting Attendance or Lesson Monitor reports to Excel

The inbuilt Attendance and Lesson Monitor reports are designed to output to a web browser such as Internet Explorer. It is possible to export the data from the web browser to Microsoft Excel.

After running your report it will open a new window and you will see your information. If you right click on the report output you will see the following menu.

Export to Excel

Scomis Hosted Schools may notice that their SIMS freezes or locks up. This could be due to the Excel window opening in behind the SIMS screen. To access the window you may need to use the ALT + TAB key combination to bring the Excel window to the front. You should see the following screen.

New Web Query

By clicking the arrow in the very top left hand corner it will select all of the information. Alternatively you can tick individual arrows for the data that you want to bring in to the Excel spread sheet. After clicking import it will pop up another box asking you to choose the cell where the report will start.

Import Data

You can choose the cell you want by clicking on it, you can even use a different sheet of the workbook. If you only require that information on one sheet, it’s wise to leave the cell on it’s default which is A1. Clicking OK will then populate the spread sheet with the information which can be modified as you see fit.

Reviewed 29/7/20

How useful was this article?

Click on a star to rate it!

Average rating / 5. Vote count:

No votes so far! Be the first to rate this post.

Similar Posts

How to amend Work Email address to Home Email on Data Collection Sheet

ByHeidi Miller

The standard Data Collection Sheet only displays the Work Email address of a contact. This can be amended in several ways, the most stress-free approach is to update the field in the report so that the main email address takes the place of the work email address. This can be done as shown below. 1….

Report to show new students or leavers.

Bykaren.brain

You may need to know any joiners and leavers over a date range. There is a report built into SIMS which can show you this. Go to Reports>Run Reports>Click the + to expand Focus and select Student, Select and run either Migration Report for Arrivals or Leavers and enter the date range you need. This…

Report to generate classes and teachers

BySarah Hart

To generate this report, please go to: -Reports > Design Report > Create a new report -Select “Student” and then “on roll” -On the select data fields screen, select “Classes” (blue sub report), then select Class Name, Class Teacher, Students (blue sub report) First Name, surname.  Your previewed report will look like this:   Reviewed…

Attendance reports for Vulnerable children – Pupil Premium, SEN, FSM or EAL.

ByLiam Motevali

The following Attendance/Lesson monitor reports can be run/created in order to show vulnerable groups of children and their attendance figures. This can include Pupil Premium, Special Educational Needs, Free School Meals, Ever6, English Additional Language and others. In order to get a ‘Whole group figure’ for these groups, go to: Reports > Attendance/Lesson Monitor >…