Course Information

Registration Options

For a quick and easy course registration, you have the option to choose a single complete training track: eSQL Basic GenED, Intermediate Routing and Planning, or STLC (Student Transportation Leadership Conference). Please note that all of these options are designed to be done as a full track and therefore you must take the full track or none of the classes within the track.

If you are…

New to Edulog eSQL, only use a few aspects of the software (students, stops, run, routes…) or need a refresher, consider enrolling in the eSQL Basic classes. Attendance is required for all four days.

Routing and Planning: eSQL Basic
  • Part Description
    Day 1 You will understand the basis of how Edulog views transportation and how it is the crux of how the software functions. With this understanding as our basis, we will dive into using the map along with its tools. Student eligibility, address matching, and specializing student profiles will be the skills you will gain on day one of eSQL Basic.
    Day 2 On this short day you will have the chance to work with more of the linking pieces that are essential to getting our students to schools. These are stops and runs.
    Day 3 The third day of class takes you into the realm of time, where the real world meets the digital world. We will continue to build on your knowledge through increasingly difficult tasks. Routes and vehicles will be added to the mix.
    Day 4 This day will bring you satisfaction in scenario-based learning where all the pieces fit together. You will work with your “officemates” to solve a variety of transportation scenarios that you may encounter. Once you have conquered this you will be able to think within the software to apply what you know to whatever may arise at your home office.
  • If you have…

    Mastered the basics of routing in eSQL and are looking for helpful solutions to improve your planning, then the Intermediate Routing and Planning course is for you. Attendance is required for all four days.

    Intermediate Routing and Planning
  • Part Description
    Day 1 Reflecting every student accurately in the software is required for safe, efficient, and on-time student transportation. You will learn how to quickly identify students whose locations are not properly recorded in Edulog. We will then fix these locations using a variety of tools and methods.
    Day 2 On this short day we will explore how to effectively make long-term run direction changes using adjacencies, segment speed changes, and proper placement of stops at corners on hazard streets. We will also work with adjusting stop times on our runs.
    Day 3 On this day, you will learn how to examine and improve transportation efficiency at the run and route level.
    Day 4 During this final short day, we will explore the tools in eSQL which enable you to quickly audit your transportation picture allowing for safe, efficient, and timely delivery of students.
  • If you are…

    A solid user of Edulog software but want to brush up on a given subject, consider signing-up for a deeper dive into the following subjects:

    Mapping
  • Offered in sessions 5-6 and 11-12. Mapping Forum in session 8.
    Learn how to add to and adjust the EDULOG Map based upon Internet map research or developer maps.
    Learn how to adjust or add your school boundaries using the MARIS Boundary editting tools.
    Forum style discussion to allow time for participants to present mapping problems and have the class discuss strategies on solving those issues.
  • Reports 1-3
  • Offered in sessions 7-9. Reports Forum in session 10.
    An introduction to running standard, specialty, and geographic reports along with the output types that allow for functionality options.
    Working with user-defined reports and groupings. Learn how to create new reports, editing and formatting options, data grouping, and page breaks.
    Learn the basics of how to copy, rename, delete, and run a report; and then take it to the next level by making more advanced adjustments to fields, filters, and sort orders. Understand data field adjustment, properties, expressions, and “print when” statements. We will look at fun formatting items like inserting images, lines, and rectangles to enhance reports.
    A forum style class on reports where questions are encouraged and solutions will be shared within the group.
  • Boundary Planning 1-2
  • Offered in sessions 5-6 and 11-12.
    Learn about creating datasets, loading data, and applying themes. Learn about student tallies and exporting, how to use selection tools, and an analysis window.
    A deeper look into boundary creation, modification techniques, saving and posting of boundaries. Learn how to plot information and print.
  • SPED 1-2
  • Offered in session 1-2.
    Learn the basic techniques and functions of routing special needs, understanding the transportation needs, home stops, flags and more.
    Continued work with special needs routing focusing on runs building, route considerations, vehicle equipment for needs, and report options.
  • 12.5 AVL and Insight
  • Part Description
    Session 9 A look at the added feature for loading GPS data directly into edulog version 12.5 and a Peek at the upcoming new Edulog GPS software Insight.
  • JIRA Ticketing System
  • Part Description
    Session 10 A look at the Edulog Customer Support Center, Entering tickets into the system as a client and working with Edulog agents through to resolution of your issue.
  • Route Substitution and Substitution Detection
  • Part Description
    Session 5 Documenting route substitutions is critical to reporting Key Performance Indicators (KPIs) and gaining efficiencies through comparative analysis using GPS data. Andy Leibenguth will explain how to do Route Substitution and show Edulog’s “artificial-intelligence-based” analysis process to detect undocumented substitutions. Learn how to use the results of this analysis and explore how it improves operational efficiency.
  • Driver Portal and Parent Portal
  • Part Description
    Session 6 Understand the newest tablet and mobile device products. Join Shawna Knudson and Tim Baigent to see how Driver Portal, Parent Portal, or Parent Portal Lite can improve your transportation service.
  • If you are…

    A brand new user of Edutracker or someone in need of a refresher, this GPS class is for you.

    Edutracker GPS
  • Offered in sessions 1-4. GPS Forum in session 7.
    Learn the basics of starting Edutracker, creating views, loading vehicles into the program and organizing groups for vehicles or schools. Learn how to get around the map, using informational tools, and working with tracking views to show what your fleet is doing today. Expand your knowledge by learning how to pull in routing data with todays GPS events in planning views, Look at what your vehicles did in the past with historical views and use our special tools like Vehicle Finder to help answer questions about your fleet. Learn how to use Edutracker reporting tools to provide you with information on what your fleet did and when. Also, learn how to make Vehicle and Route substitutions using the unit manager interface as well as adding or adjusting GPS device installations.
    Forum style discussion to allow time for participants to present how they use GPS in their operations, and discuss issues they encounter.
  • If you are…

    A user of Edulog Advanced and want to learn to back-up data, change bell times, work with clusters, edit the map, manage shuttles vs. transfers and make custom reports, sign up for the forums that interest you.

    Troubleshooting
  • Part Description
    Session 1 Learn the golden questions to follow when the software doesn’t start and stay to discuss tips for communicating problems to tech support.
  • Worklists
  • Part Description
    Session 2 Discussion of how to use worklists, choose the best filters, and the opportunity to build them in Advanced and eSQL (advanced searches).
  • Advanced SPED Issues
  • Part Description
    Session 3 A forum style class on Advanced SPED Issues where questions are encouraged and solutions will be shared within the group.
  • Bell-Times and Frequency
  • Part Description
    Session 4 Frequency: A high level problem based workshop that will look at the complexities of frequencies.
  • Rollovers
  • Part Description
    Session 5 Learn how to find and edit Rollover instructions, what should be included in a request if someone will be running it for you, and discuss special cases when a Rollover can save time.
  • Making and Storing Backups
  • Part Description
    Session 6 Practice making, labeling, and restoring backups for Edulog version 12.
  • Student Downloads
  • Part Description
    Session 7 Learn how and when to use the prestu process, what is required for a successful upstu, and how to see any problem records once it has run.
  • Student Downloads Forum
  • Part Description
    Session 8 Discuss issues and solutions with other districts regarding imports of student records. Explore options for breaking out apartment numbers and combining fields.
  • How Boundaries Affect Data
  • Part Description
    Session 9 Discuss and explore applying boundaries to specific grades and programs as well as other uses for boundaries and how to make them available where you want to use them.
  • Transfers and Shuttles
  • Part Description
    Session 10 Understand the differences between Edulog’s transfer stops and shuttle runs, and why you might need to use transfers.
  • If you are…

    A transportation director, supervisor, chief operating officer, or other leader in the pupil transportation industry, these topics critical to managing school transportation operations are for you. Participants and instructors will explore technology implementation, best practices utilizing Edulog products and a variety of pressing issues facing today’s transportation leaders.

    Day 1 – Student Transportation Management Best Practices
  • Part Description
    Opening – Joint Session with Edulog International User Conference Hear the latest as company leaders welcome you to the conference and share the latest on what’s coming from Edulog.
    Introductory Session A key to the STLC is learning from each other. During this session each participant does a self-introduction including projects and scenarios being faced by their transportation operations, to enable STLC leaders to shape the sessions for the week.
    Best Practices Roundtable – Policy The foundation for every transportation department is strong direction and guidance through well-documented policies, procedures, and guidelines. Some policies are established by state and federal government while others can be unique to the needs and desires of local district administrators and school boards. These policies are necessary to clearly establish the level of transportation service that will be provided within the district.
    Best Practices in Communication While this could be a week-long conference topic in itself, we will focus on transportation-related communication with the general public and parents. The group will critique sample transportation web pages, district web sites and other means of communicating with parents such as email and web-based apps. We will follow a similar strategy with media communications and the skills needed to navigate those tricky waters.
    Best Practices in Planning It seems like it never stops. We’ll discuss the various aspects of school transportation planning that take should take place throughout the year, even throughout the week!
    Best Practices in Student Data Management A truly effective transportation department establishes procedures for using data from the district’s Student Information System. The session focuses on the sharing of that data on a regular basis, the specific data elements needed for student security and parent communication, and the growing use of crowd-sourced, app-based parent communication.
    Specialized Transportation Data Management In addition to the traditional transportation of children with special needs, most districts have additional specialized transportation needs, including McKinney-Vento, magnet/choice schools and more. We’ll explore that data needs of a variety of such programs.
    Budget Planning and Data-Driven Decision Making Best practices call for managing the transportation department’s budget based on data. Since the “lion’s share” of this budget relates directly to routing this session will focus on key performance indicators (KPIs) dealing with routing. We will also explore analysis and strategies for improving those KPIs to help the budget.
  • Day 2 – Scenario-Based Solutions
  • Part Description
    Day 2 Attendees will learn to address a variety of issues that face transportation departments across the country through tabletop exercises. Groups will combine Edulog staff with experienced transportation leaders as well as those relatively new to their positions. Participants will have the opportunity to offer scenarios from their district and receive assistance in the development of an implementation plan. Each plan – including preparation, implementation, and communication – will be shared with the larger group. In the afternoon, attendees are invited to attend Edulog’s International User Group meeting.
  • Day 3 – Student Transportation Leadership Topics
  • Part Description
    Illegal Passing 2018, more than any year in recent memory, saw numerous incidents involving student injury and fatality as a result of motorists passing stopped school buses. We will focus on the education, engineering, and enforcement triangle necessary to combat this issue.
    Legal Issues Facing Leaders Today Edulog’s general counsel addresses some of the hot topics facing today’s transportation leaders.
    Edulog System Topics – What the Transportation Director Needs to Know This session, intended for all transportation leaders (not just directors), focuses on the key components of Edulog’s transportation solutions that need to be top-of-mind for the transportation director, regardless of whether he or she is hands-on with the software. We’ll address topics such as map calibration, optimization, student data management, and managing user training.
    Project Planning Continuing from the scenario-based session on Day 2, this session applies to the overall aspects of planning and carrying out a transportation plan, including stakeholder involvement, communication plans, and execution.
    Implementation of Technology Technology is moving forward at a rapid pace and offers the transportation department options previously never considered. Implementation on-board mobile data terminals (tablets), student ridership, and parent portal solutions require specific project planning. This session includes district perspectives on the best way to roll out new technology, focusing on the considerations for various stakeholder groups.
    Field Trips Student transportation leaders share their approaches to managing field trips, critical success factors and lessons learned.
    Department Organization Transportation directors and Edulog consultants share a variety of transportation department organizational approaches and lessons learned.
    Sleep Studies, Tiers, and Bell-Times Whether to improve student outcomes or to improve efficiency, transportation departments are asked to report data or produce solutions that involve adding or reducing bell schedule tiers, altering the length of school day or moving high schools to a later start time. We’ll discuss the relevant considerations and review case studies to prompt group discussion.
    Routing and Scheduling Back to the basics, we’ll discuss well-established, but often overlooked, best practices in route management system implementation. Topics include walk zones, hazard zones, hazard streets, and boundaries. We’ll also discuss student ridership management to ensure stops are well maintained and placed appropriately.
    State of the Industry on Lap/Shoulder Belts We’ll explore the latest trends and lessons learned in implementing lap/shoulder belts on school buses. Sure, there are improved safety benefits, but unintended consequences include improved driver retention and reduced driver distraction resulting in additional safety for students.
  • Day 4 – Hands-On Edulog
  • Part Description
    Hands-On Participants will have the opportunity to use the Edulog system in a computer lab setting, guided through some basic tasks including management reports and queries and to see how various system analyses can improve their daily operations.