2019 Course Information

Quick 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. Please note that all 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.
  • Sub Detect and Route Substitution
  • Part Description
    Session 5 Andy Leibenguth will present Sub Detect and Route Substitution. Learn how these products interact and explore how they will aid operations moving forward.
  • 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.