Section Allocation App - MS Access Version - Nesterenko Software
Section Allocation Assistant App - MS Access® Version
Organizational tool - provides the user with all the necessary functions
related to the Course Request and Sectioning process which, typically, takes place during March and April.
This page explains the 'MS Access® Version' of the Section Allocation Assistant App.
To switch to the 'Web Version' page, Click HereNote: Also known as the 'Course Request Tally and Sectioning Assistant' App
The Section Allocation app draws in CourseRequestTally CSV data easily extracted from Aspen® or PowerSchool®, so no data-entry is required to get started.
Section Allocation Assistant App - MS Access® Version - various reports and explanations:
1. Introduction - Section Allocation Assistant App - MS Access® Version
The application is a great organizational tool which provides the user with all the necessary functions
related to the Course Request and Sectioning process which, typically, takes place during February-March-April.
It will save you a great deal of time, keep you completely organized and provide you with tremendous detail and sunmary reports.
This is a Microsoft® Access application file which requires no installation,
other than to have Microsoft® Access installed on your computer.
Data is easily extracted from Aspen® and PowerSchool® and Imported into the app..
Application Use - Section Allocation Assistant App - MS Access® Version
The main functions of the application allow the user to import the current Course Request Tally data as
often as necessary - typically daily because things change so frequently during this period of time - and it
is so important to be working with the most recent Tally data; the user can enter the number of sections to
be offered for each course; identify 'combined/stacked' classes if any; and generate a variety of detail and
summary reports suitable for analysis and for submission.
Reports include analyses that provide the user with anticipated Average Class Sizes, display
collective agreement Maximum Class Sizes, and flag potentially large or small courses.
As well, Combined/Stacked Classes are grouped together, showing Total Tally and average size etc.
Summary or detail Reports can be generated for analysis or for communication and feedback
with Department Heads.
Reports display total number of course sections by Department and Overall total number of course sections.
Typically, the process takes place over a period of several weeks, as the user likely starts with an optimistic
'wish-list' of course sections to offer and then whittles down the number of course sections to match the
overall total classroom sections as have been allocated by School Board Senior Administration.
To TopTo Bottom
2. Sample Reports - Section Allocation Assistant App - MS Access® Version
3b. Section Allocation Assistant App - MS Access® Version - '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 - Section Allocation Assistant App 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 Requests 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
