[Home]....[All Videos]

Nesterenko Software Applications - All Videos

Pete Self     -       peteself@nesterenkosoftware.com

Logo

A variety of videos explain the various aspects of the Nesterenko Software Applications:

OnCall Assistant Application
     1. Click to Watch - OnCall Assistant Application - Overview of the app

Timetable Assistant Application
     2a. Click to Watch - Timetable Assistant Application - Brief Video - Quick overview of the app
     2b. Click to Watch - Setup and Getting Started
     2c. Click to Watch - Importing Master Schedule Data
     2d. Click to Watch - General Use
     2e. Click to Watch - Timetabling Functions
         2e (i). Click to Watch - While performing Simulations, Display Master Schedule as well as 'Class Load' values    - This video is also included within the longer, 'Timetabling Functions' video.
     2f. Click to Watch - School Board License Version

Course Request Tally and Sectioning Assistant Application
     3a. Click to Watch - Course Request Tally and Sectioning Assistant Application - Brief Video - Quick overview of the app
     3b. Click to Watch - General Use
         3b (i). Click to Watch - Allocate Sections    - This video is also included within the longer, 'General Use' video.
         3b (ii). Click to Watch - Create a Combined Class    - This video is also included within the longer, 'General Use' video.
         3b (iii). Click to Watch - Creating 'Placeholders'    - This video is also included within the longer, 'General Use' video.

Course Request Verification Application
     4. Click to Watch - General Use

Attendance Assistant Application
     5a. Click to Watch - Introduction and General Use - (Older video - will be updated soon)
     5b. Click to Watch - 'Connecting' the Absence Letter to the Data Source and Performing Mail Merge
     5c. Click to Watch - Explains how to generate 'Attendance Letters' to be mailed - (Older video - will be updated soon)
     5d. Click to Watch - Explains Other Settings, Configuration etc.- (Older video - will be updated soon)


1. OnCall Assistant Application - Manage Daily Absences/OnCalls - Overview of the app:

Click on video to pause and view reports etc.

0:00 - Intro - OnCall Assistant
0:28 - Daily Routine
3:05 -      Check For Issues
3:35 -      Class Notes
3:45 -      'Quick View' Form
3:55 -      Supply Teacher Form
4:15 -      Daily Reports - Daily Teacher Absence/OnCall Report, OnCall Slips etc.
5:05 -      Flip Periods 4-3, for instance
5:15 -      UpComing Absences/OnCalls Report
5:30 -      Initial School Setup
5:53 -      Intitial Calendar Setup:
6:30 -      Initial Absence Code Table Setup
6:39 -      Teacher Master Schedule - Same Import process as Timetable Assistant app - No Data Entry Required
7:03 -      Edit Teacher Assignments & OnCall Availability
7:03 -      Adjust Number of OnCalls Done - if starting app mid-year
7:30 -      Adjust Maximum Number of OnCalls
7:37 -      Add Teacher
7:43 -      YTD Reports - Detail and Summary
8:10 -      Teacher OnCalls Done/Remaining Linear Report
8:20 -      Wrapup - MS Access, No data Entry is Required, email: PeteSelf@NesterenkoSoftware.com

Back to Top of Page



2a. Timetable Assistant Application - Brief Video - Quick overview of the app:

Click on video to pause and view reports etc. More detailed videos (Setup, General Use, Timetabling Functions, etc.) follow.

Click here to view the Timetable (Master Schedule) Assistant application - mini brochure.
Back to Top of Page


2b. Timetable Assistant Application - 'Setup and Getting Started':


*The video has been replaced, for now, by an explanation and picture rather than a video. The video will return after it has been updated.

You will receive the necessary Timetable Assistant app files via an email attachment.
You will create a folder (20162017Timetable) on your computer (perhaps on your Desktop, perhaps within C: drive etc.)
You will save the 4 files from the email into that folder. *Note: If you are only able to download the files into a 'Downloads' folder or similar, copy or drag or move them from the Downloads folder into the 20162017Timetable folder.
You will 'Rename' the Timetable_v170013_ABCD file to Timetable_v170013_ABCD.mde (To do this, right-click on Timetable_v170013_ABCD, select 'Rename', then append '.mde' to the file and click Ok. The filename should then be Timetable_v170013_ABCD.mde) And the computer should then recognize the file as an MS Access file and display an icon to the left of the filename.

After getting files saved and renamed, you should have a folder that looks similar to:
FilesSetup

Back to Top of Page



2c. Timetable Assistant Application - 'Importing Master Schedule Data':

Generate MasterSchedule.csv data, Import into application, View Master Schedule report

Video topics include:

0:00 - Intro
0:05 - Timetable Assistant Application - Importing Master Schedule Data
0:38 -      Instructions to generate the Master Schedule Report
1:38 -      Extract data to the MasterSchedule.csv file
3:15 -      Import MasterSchedule.csv data
3:33 -      View Master Schedule Report
3:48 -      Invitation to watch the next video - 'General Use'
3:54 -      Summary of All Videos

Click here to view the Timetable Assistant application - mini brochure.

Back to Top of Page

2d. Timetable Assistant Application - 'General Use':

Explanation of the various functions and reports within the application.

Video topics include:

0:00 - Intro
0:05 - Timetable Assistant Application - General Use
0:35 -      Master Schedule Report
1:12 -      Teacher Linear Report
1:20 -      Room Linear Report
1:40 -      'Initialize Values' tab
1:52 -      Blocks, Column Headings etc.
2:10 -      Exclusions, Class Max tables etc.
2:35 -      'Other Routine Reports' tab
2:43 -      Several versions of the Master Schedule Report
3:27 -      Other Teacher Linear Reports
3:47 -      Special Reports which help resolve Teacer Workload issues
4:18 -      Variety of other Miscellaneous 'Listing' reports.
5:10 -      Invitation to watch the next video - 'Timetabling Functions'

Click here to view the Timetable Assistant application - mini brochure.
Back to Top of Page

2e. Timetable Assistant Application - 'Timetabling Functions':


Explanation of the functions which support the Timetabling process within the Nesterenko Software Timetable Assistant application..

Video topics include:

0:00 - Intro
0:05 - Timetable Assistant Application - Timetabling Functions
0:30 -      Master Schedule Report
0:35 -      'Timetabling 1' Tab
1:00 -      Master Schedule Report - Show Grade Totals
1:19 -      Available Seats Report
1:29 -      Selective Imports
2:36 -      'Timetabling 2' Tab - Master Schedule by Department Report etc.
2:52 -      'Section Count' Tab
3:10 -      Scenario 1 - Beginning of the Timetabling Process
4:40 -      Scenario 2 - Building the rest of the Course Sections
5:04 -      Scenario 3 - Checking Semester Balance
5:22 -      Scenario 4 - Simulated Loads
6:54 -      Scenario 5 - Assigning Teachers and Rooms
7:48 -      Scenario 6 - Load Students
8:00 -      Department Heads 'Swap' Teacher and/or Rooms
8:19 -      Teacher Linear by Department Report - nice to give to Heads for posting in Department offices
8:30 -      Guidance likes to use this application to generate the Master Schedule Report frequently, especially during September
8:40 -      Wrapup

Click here to view the Timetable Assistant application - mini brochure.
Back to Top of Page

2e. Timetable Assistant Application - 'Performing Simulations':


Explanation of the functions which support allow the 'Class Load' values to be displayed on the Master Schedule while performing Simulated Loads.


Click here to view the Timetable Assistant application - mini brochure.
Back to Top of Page

2f. Timetable Assistant Application - 'School Board License Version':

Explanation of the Board License Version of the Timetable Assistant application

Video topics include:

0:00 - Intro
0:05 - Timetable Assistant application - School Board License Version
3:54 -      Summary of All Videos

Click here to view the Timetable Assistant application - mini brochure.

Back to Top of Page

3a. Course Request Tally and Sectioning Assistant Application - Brief Video - Quick overview of the app:

Click on video to pause and view reports etc. More detailed videos (General Use, etc.) follow.

Click here to view the Course Request Tally and Sectioning Assistant - mini brochure.
Back to Top of Page


3b. Course Request Tally and Sectioning Assistant - 'General Use':

Explanation of various functions and reports. Works through the Sectioning process from beginning to end when final Sectioning decisions are made and would then be ready to build the Timetable.

Video topics include:

0:00 - Intro
0:05 - Course Request Tally and Sectioning Assistant
0:10 - Used by Staffing/Sectioning Group - typically during March-April
0:20 - Data comes from the Course Request Tally Report
0:40 - Begin a typical process
0:45 - Course Requesta and Sections Allocated Report
1:10 - Department Summary Report - one page snapshot
1:20 - Allocate Course Sections
1:40 - Special function to Allocate 'Estimated Sections'
2:15 - Explanation of Fields and Symbols
2:45 - Combining Courses
3:50 - Brief mention regarding Co-op Courses
3:55 - Adding Placeholders
5:00 - Initialize Values tab - Class Size Maximum Tables
5:15 - Other Reports tab - Two useful reports - One used at beginning of process, and 'Must Haves' report used at the end of the process. One page per Department. Used for communication and feedback with Department Heads.
5:50 - Misc. Analysis Reports tab - not usually used
5:56 - Submittimg tab - not usually used
6:05 - Help tab - Instruction to create the CourseRequestTally.csv file, Extension Code, Documentation
6:20 - Ready to begin Timetabling
6:30 - Brief mention of the Timetable Assistant Application

Click here to view the Course Request Tally and Sectioning Assistant - mini brochure.
Back to Top of Page

3b (i). Course Request Tally and Sectioning Assistant - 'Allocate Sections':

This video is also included within the longer, 'Course Request Tally and Sectioning Assistant - General Use' video above.
Quick, 1-minute video which explains how to Allocate Sections within the Course Request Tally and Sectioning Assistant Application.




Click here to view the Course Request Tally and Sectioning Assistant - mini brochure.
Back to Top of Page


3b (ii). Course Request Tally and Sectioning Assistant - 'Create a Combined Class':

This video is also included within the longer, 'Course Request Tally and Sectioning Assistant - General Use' video above.
Quick, 45-second video which explains how to identify a Combined Class within the Course Request Tally and Sectioning Assistant Application.




Click here to view the Course Request Tally and Sectioning Assistant - mini brochure.
Back to Top of Page


3b (iii). Course Request Tally and Sectioning Assistant - 'Creating Placeholders':

This video is also included within the longer, 'Course Request Tally and Sectioning Assistant - General Use' video above.
Quick, 1 minute video which explains how to create 'Placeholders' within the Course Request Tally and Sectioning Assistant Application.




Click here to view the Course Request Tally and Sectioning Assistant - mini brochure.
Back to Top of Page



4. Course Request Verification Assistant - 'General Use':

The main purpose of the application is to generate a Course Request Matrix Report. This report provides some much-needed information, especially towards the latter stages of Timetabling. Information helps to minimize conflicts.

Video topics include:

0:00 - Course Request Verification Assistant
0:12 - Provided No-charge to Timetable Assistant users
0:30 - Extract and then Import Course Request verification data
0:40 - Course Request Matrix Report
1:05 - Especially helpful when placing Single-Section courses
1:35 - Course Requests by Name
1:39 - Course Requests by Grade, Name
1:46 - Course Requests by Number of Requests - possibly find incomplete submissions
1:52 - If Alternates used - Alternates Report
1:46 - Course Requests by Number of Requests - possibly find incomplete submissions
1:58 - Select a course and see list of students who selected it.
2:20 - Recap of three applications: Course Request Tally and Sectioning Assistant; Timetable Assistant; Course Request Verification Assistant
2:40 - Pass on info to others.
2:45 - Fully-functional Trial version
2:52 - No other software installation required - MS Access
Sample Course Request Matrix Report
Back to Top of Page


5a. Attendance Assistant Application - Introduction and General Use


(Note: This is an 'older' video which will be updated soon.)
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

5b. Attendance Assistant Application - 'Connect Letter to Data Source and Mail Merge':

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

5c. Attendance Assistant Application - Generate 'Attendance Letters' :


(Note: This is an 'older' video which will be updated soon.)
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

5d. Attendance Assistant Application - Other Settings, Configuration etc.


(Note: This is an 'older' video which will be updated soon.)
Explains Other Settings, Configuration etc.:

Video topics include:


Click here to view the Attendance Assistant application - mini brochure.

Back to Top of Page