Introduction

The purpose of the “Seminary Attendance Submission Status” report is to check whether attendance has been submitted correctly by Teachers within a specified date range. If Teachers have not submitted their attendance correctly for one or more classes, their attendance status will be highlighted as “Incomplete”. Classes that have been marked correctly will be tagged as “Complete”.

Running the Report

1. In the Attendance Reports section of the S&I Support page, click on the link labeled: Seminary Attendance Submission Status.­

2. On the Run sqlReport page, enter the desired Start Date and End Date for the report using the fields provided. For example, if you would like to run a report for June, then select “June 1” in the Start Date field and select “June 30” in the End Date field. Click the Submit button to run the report.

NOTE: If you would like to run a report for a SINGLE day only, then simply enter the SAME date in both fields. For example, to run a report just for June 15, select “June 15” for both the Start Date and the End Date fields. Also note that non-school days such as weekends and public holidays will be automatically ignored in the report even if they are included in the selected date range.

Understanding and Using the Report

1. Once you have run the report, you will see multiple “groups” of data each separated by a grey header. In this example, the first “group” of data is labeled: "Moli, Seini Kaunanga – 2019 06 04". Inside this “group” it is showing that Seini was scheduled to teach 6 classes on Tuesday, June 04, 2019. It is also showing that Seini completed attendance correctly for her first 5 classes. Her last class for the day however was not submitted correctly and is highlighted on the report as “Incomplete”. Seini should be contacted by the School Office or Seminary HOD and asked to submit attendance for her 7th period class on June 04, 2019.

The second “group” of data is labeled: Moli, Seini Kaunanga – 2019 06 05. The second “group” of data, is showing that Seini taught 3 classes on 5 June 2019, and submitted attendance correctly for all 3 of her classes. All classes taught within the selected date range will be grouped like this by Teacher and Date, and then listed by class.

2. Each of these “groups” of data can be expanded or collapsed by clicking on the grey header. Click once to collapse. Click again to expand. All groups of data are expanded by default when you run the report.

3. If you would like to search for a specific teacher or date, you can use the Filters provided at the top of the report to select specific dates or teachers. In this example, I have selected to view the attendance information for “Amelia” and “Seini” on “Thursday, June 20, 2019”. Open a “filter drop-down” and select an option to activate a filter. You can open a “filter drop-down” multiple times and select multiple options to further refine your filter. You can use multiple filters, and multiple options at the same time.

4. You can “cancel” any of the filters by clicking on the link(s) displayed underneath the filter box. When you click on one of these links, the filter will be cancelled for that option.

NOTE: Sometimes the filter drop-downs will be “greyed out” or deactivated. This occurs when there is only one option available in that drop-down box, and therefore nothing to filter for that column.

5. You can also use the Search Box to refine your query. This works in a similar way to the filters, but allows the user to search quickly for a specific name, date, word or month etc. The Search Box will allow the user to search for a specific word or phrase anywhere on the report. For example, if you would like to see all of the entries for Seini, then you could simply type “Seini” in the search box.

NOTE: The Search Box will not work properly for the Status column.

6. Use your initiative to make the report work for you. For example, to quickly view all classes that were not submitted correctly for Tuesday 4th June, select “Tuesday, June 04, 2019” from the Cal Date filter, and type “Incomplete” in the Search Box. The user could then send this list to the school office and ask them to follow up the highlighted teachers and classes for this data.

7. Also take note that there are various Buttons available at the top of the report that allow the user to perform different functions. For example, use the Copy button to quickly copy the data in the report. The data can then be pasted into a spreadsheet, email, or word document if needed for other purposes.

Quick Recap

1. Click the Seminary Attendance Submission Status link on the S&I Support page.

2. Enter a Start Date and End Date on the Run sqlReport page, then click Submit to runt the report.

3. Expand and collapse “groups” of data by clicking on the grey “group” header.

4. Use the Filter Drop-Downs or Search Box to further refine your query.