Attendance Assistant ApplicationPete Self     -       peteself@nesterenkosoftware.com |
![]() |
Attendance Assistant Application - Used by Gudance, VPs, Student Success teams
(This page order - click or scroll down) 1. Introduction 2. Sample Reports 3. Pricing 4. Videos 5. Frequently Asked Questions 6. Help (Link to another page to view various Help topics) |
Attendance Assistant Application - various reports and explanations:
![]() |
1. Introduction - Attendance Assistant
This is a Microsoft© Access application file which requires no installation, other than to have Microsoft© Access installed on your computer.
Data is imported from Trillium© the 'Consecutive Days Absent Report', the 'Student Directory Report' and the 'Parent Mailing Labels Report'.
The Attendance Assistant application has two main components:
- The first component allows the user to analyze and summarize student absences. This is the most-used component.
- The second component allows the user to quickly generate individualized 'Attendance' Letters which can then be sent home.
     This component is used by schools who routinely send home 'Attendance' Letters to parents.
     If it is a routine school practice to send home letters, then this app will save countless hours and generate
     very nice custom letters.
     If this component is used, I will send an MS-Word Mail-Merge Letter document template which can be customized.
2. Sample Reports - Attendance Assistant        
The app contains many reports.
All Absences sorted by Name, Grade, Number of Absences. Same but grouped by VP if more than 1 VP.
User can also select a minimum number of absences and display the same reports as above but limited to studenst with only a selected number of absences in any course.
Click on any of the following to get a sense of the reporting available:
All Students
All Students - Sorted by Name
All Students - Grouped by Grade
All Students - Sorted by Total Classes Absent Great report to find students with biggest Attendance issues.
(The next 3 are same as previous 3 reports, but if more than 1 VP)
All Students - Grouped by VP, Sorted by Name, if more than 1 VP.
All Students - Grouped by VP, Grade, if more than 1 VP.
All Students - Grouped by VP, Sorted by Total Classes Absent, if more than 1 VP. Great report to find students with biggest Attendance issues.
Selective Reports - Can identify a minimum # of Classes Absent - Examples here use '6 Absences'
Selective - At Least 6 Absences - Sorted by Name
Selective - At Least 6 Absences - Grouped by Age
Selective - At Least 6 Absences - Grouped by Grade This is most-used report. Used by Student Success teams to focus on a limited number of students.
Selective - At Least 6 Absences - Sorted by Total Classes Absent
(The next 4 are the same as previous 4 reports, but if more than 1 VP)
Selective - At Least 6 Absences - Grouped By VP, Sorted by Name
Selective - At Least 6 Absences - Grouped By VP, Age
Selective - At Least 6 Absences - Grouped By VP, Grade This is most-used report, if more than 1 VP. Used by Student Success teams to focus on a limited number of students.
Selective - At Least 6 Absences - Grouped By VP, Sorted by Total Classes Absent
'Attendance Letters' - Letters can be generated to be sent home
The functions to generate 'Attendance' Letters include a few steps and ultimately generate letters such as the following:
Attendance Letters
Labels for Attendance Letters
Summary Report By Grade showing information which will appear on 'Attendance Letters'
Summary Report By Name showing information which will appear on 'Attendance Letters'
3. Pricing - Attendance Assistant
Email to request a free evaluation version of the software. The evaluation version is fully-functional. Included also is an over-the-phone
discussion/demonstration/tutorial which will teach you how to use the software.
No setup or initial data-entry would be required by the user.
The software purchase is a yearly licence.
Price of the software is $150.00 for a one-year school licence.
Contact to discuss a Board-wide license.
4. Instructional Videos - Attendance Assistant
Scroll down to view Instructional Videos...
a. Attendance Assistant - Introduces the Application and explains the use of a variety of reports
that can be used to analyze and summarize student absences.
b. Attendance Assistant - Explains how to generate individualized 'Attendance' letters that can be printed and sent home.
The process uses a mail-merge letter which works in conjunction with the application.
c. Attendance Assistant - Explains other specific functions: Files Overview; Special cases; Additional 'Letter1' functions;
'Letter2' tab; 'Help' tab, etc.
Introduces the Application and explains the use of a variety of reports that can be used to analyze and summarize student absences.
Video topics include: Click here to view the Attendance Assistant application - mini brochure. Back to Top of Page |
How to connect the AbsenceLetter1.doc to the Attendance Assistant application and perform a Mail Merge
Video topics include: 0:00 - Attendance Assistant Application - Connect Letter and Mail Merge 0:10 -      Students Already Selected 0:28 -      Launch AbsenceLetter1.doc 0:43 -      Connect to Data Source 1:04 -      *If screen appears, select OLE DB Database files 1:18 -      Letter1 - AbsenceLetter1MailMergeQuery 1:28 -      New 2014 - Multiple VPs 1:45 -      Use 'Preview Results' Toggle Button - And Advance through students 1:55 -      Click Save to remember the 'connection' 2:04 -      Perform Mail Merge 2:10 -      New document with one page for each student 2:45 -      Re-Launch letter to demonstrate 'connection' is remembered 2:58 -      Connection process also used to connect different letters and at start of new year 3:20 -      Good Day Click here to view the Attendance Assistant application - mini brochure. Back to Top of Page |
Explains how to generate 'Attendance Letters' to be mailed
Video topics include: Click here to view the Attendance Assistant application - mini brochure. Back to Top of Page |
Explains Other Settings, Configuration etc.:
Video topics include: Click here to view the Attendance Assistant application - mini brochure. Back to Top of Page |
5. Frequently Asked Questions - Attendance Assistant        
6. Help - Attendance Assistant        
Click here to view various Attendance Assistant Help Topics