https://www.complexbuilders.com/?buy=7008 School district superintendents and planners have tough decisions to make when school facilities are not being utilized efficiently. Having data and solid plans to back those decisions up is essential. If you could plan for change in your district using what-if scenarios, what might those look like?
If, for example, you needed to consider closing a school because your district’s enrollment has been dropping, you might first open a map of your district and school boundaries on your computer. (A note: not all districts have accurate school boundaries on a computerized map. So, just having this would be a huge first step.)
This map would show your school attendance boundaries and a dot on the residence of each student enrolled in the district. (This is called geocoding—a geographic marker that represents a student.)
Plus, you would have a numeric chart with counts of the number of students at each school broken down by grade and demographic category, such as ethnicity, program participation, primary language, and special education. Ideally, you would also have the school capacities, percent utilization, and seats available at each school to tell you which schools are under and which are over capacity, and by how much. Even better, these numbers would all change dynamically when you make a change to your boundaries.
In a what-if scenario, to simulate closing a school, you would simply delete the school icon from your online map and see that the area around the school and all the students who live in that area are no longer assigned to a school. You would click a button to select the unassigned planning areas and assign them to other schools. You would check your chart to see the impact on enrollments at the remaining schools. You would study the results and reassign some areas to different schools until enrollments are within school capacities and ethnicities and other demographic and special program variables ensure equity across schools.
That’s what we mean by what-if scenarios. Are you equipped with the technology to do this type of district planning with a few clicks of the mouse? If not, you can get there by employing a geographic information system, or GIS, planning system for your district.
School districts face numerous situations that require careful and thoughtful planning. By using what-if scenarios, you can simulate changes and get the data and maps you need to present multiple options to your board, families, and the public, particularly important when tough decisions must be made.
Here are a few other what-if scenarios a GIS planning system can help with:
What if you wanted to simulate opening a new school to accommodate increased student enrollments?
What if you wanted to look at changing grade configurations (e.g., K–8 to K–5 or 9–12 to 10–12, etc.) to continue to utilize all your sites, but even out student enrollments across buildings?
What if, after an emergency, such as a fire in a large neighborhood that crosses multiple elementary, middle, and high school attendance areas, you wanted to provide targeted support to families and schools? Could you easily and quickly create an emergency call and mailing list of all the families impacted? If the neighborhood school is no longer operational, could you also quickly assign those students to their next closest school with capacity?
What if the board asked about changing feeder patterns from elementary to middle to reduce the distance students travel to school? Could you give them viable options?
What if you could increase capacities at schools by bringing in portable classrooms delaying the need to build, while monitoring the effect on enrollments of new houses being built within district boundaries?
What if the district had uneven growth with some areas experiencing declining and other areas increasing enrollments? Could you easily review options to modify school attendance boundaries to not only even out enrollments across schools, but also ensure equity for all student populations and program participants?
A GIS planning tool gives you the power to create multiple what-if scenarios to address a variety of situations and decisions you might be facing or will face in the future. The planning should be the easy part so you can spend your energy and time working with the people who will be affected by your decisions.
“Geospatial information has been proven effective in supporting both the understanding of and response to disasters….However, the ability to effectively share, use, and re-use geospatial information and applications…is dependent upon having the required partnerships, policies, standards, architecture, and technologies already in-place when disaster strikes1.”
The COVID-19 pandemic shutdown of schools has been described widely as “unprecedented,” but district administrators routinely face challenges that are perhaps more aptly described as “everyday” disasters, or operational crises that need an immediate response.
The article highlights benefits of having a GIS application in place to meet operational challenges. The administrative team was able to use ONPASS® Pro, a specialized GIS application that contains detailed district, school site, and student location data, to overcome several types of operational challenges.
Prior to the COVID-19 shutdown of schools, a sewer line break at one of their school sites caused an immediate need to reassign 300 students to a different school with as little educational time lost as possible. In one afternoon, the team was able to reassign students to the closest school that had capacity and met students’ educational programming needs.
ONPASS Pro also proved useful in responding to the COVID-19 crisis. The district needed to be sure all children qualifying for free breakfasts and lunches were receiving food while schools were shut down. Many students ride the bus to school so just having food available at school sites that are miles away from their homes was not enough. Using existing bus stops and other neighborhood spots as drop-off locations, the school district used ONPASS Pro to determine where to take food to families, allowing them to be served within walking distance of their homes.
Reliable internet connections also became critical for student success during the COVID-19 shutdown and the transition to remote learning. Because the district already had geocoded student-level data in ONPASS Pro, the administrators could provide student location information to its T-Mobil telecommunications vendor. The carrier was able to increase cell tower capacity and speed to ensure that every student throughout the district had equitable access to technology.
For more details, read the full District Administration article, and watch this video to see how Eric Wells has been successful using ONPASS Pro to plan for other types of potential disasters.
Software that gives school district administrators the tools to combine student data with geographic information provides much more than a nicely drawn and colorful map of the district. School district administrators can face multiple challenges more confidently when they analyze their data in a platform based on a geographic information system (GIS). Two recent articles highlight how ONPASS® Pro, a GIS tool for school districts, helps solve multiple types of problems.
Administrators at Muskogee Public Schools faced difficult decisions related to declining birth rates and increasing numbers of families choosing nontraditional school options. In an article for eSchool News, Chief Information Officer Eric Wells describes how the district used ONPASS Pro to create multiple planning scenarios so they could reach a satisfactory solution.
District administrators worked with members of the community to devise a plan that turned an elementary school into a 6th grade center, closed a middle school, and moved those students to a larger elementary school. These changes required rezoning 2,700 students served by the remaining five elementary schools. Mapping the data helped show community members where students lived relative to school programs, demonstrated the need to move the location of one program, and even suggested unexpected efficiencies in the transportation department. Being able to show all stakeholders the data behind the decisions helped to calm an emotional situation.
Members of the Community Consolidated School District #15 (IL) have been very active in an ongoing redistricting process and have found data analysis to be a central part of their efforts. The district had not redrawn school attendance boundaries for at least 25 years, and newly elected School Board members wanted to align boundaries with where students currently live.
Superintendent Scott Thompson wrote in “Redrawing School Boundaries with Confidence” that “Any open, transparent, and inclusive process…has to begin with accurate data presented in a way that makes sense to the stakeholders.” The district used ONPASS Pro to map the school attendance boundaries and run many boundary scenarios so everyone involved could see how changes affected multiple schools in the district. Thompson pointed out that the scenarios provided “instant feedback” that allowed for immediate adjustments. The data analysis has provided confidence that the best possible boundary-change plans will be adopted.
Since the establishment of the one-room schoolhouse, school districts across the country have faced ever-changing shifts in student populations. As one room turned into two and two turned into three, schools have had to adapt, open, close, and sometimes reopen. That’s where ONPASS, our flagship software product, got its start—as a tool to help school districts anticipate and plan for changes based on student enrollments.
The Beginning
The story of ONPASS goes back a ways. In 1970, William (Bill) Gilmore, my father—a science teacher for the East Side Union High and Oak Grove School Districts in San Jose, California—left teaching after 15 years and began his work in school district planning and evaluation. He became the program director of Individualization at the Center for Planning and Evaluation (CPE) for the Santa Clara County Office of Education (SCCOE). It was “[a] center devoted to the improvement of educational practices through systematic planning and evaluation.” At that time, he also began to continue his own education at Stanford University in the fields of statistics and computer programming.
At the CPE, my dad worked in the area of individualized learning, continuing an initiative he led when he was teaching. At Andrew Hill, he ran Project 360,[1] an experimental program that included planning for the learning environment and individual learning needs of the student. This led to his interest in school district facilities planning. (As an aside, apparently, I went with my dad on field trips during this time. I’m the little girl standing at his feet in the picture on page two of the Project 360 newsletter dated February 1967.)[2]
Eventually these disciplines—measurement and evaluation, planning, and computer programming—would converge and become the basis for his future company.
Early Geographic Information Systems (GIS) and School Planning
The old way (maybe not the oldest way, but the pre-computer way) to manage change in a school district was to use a big map on the wall that had thick black lines around the district’s boundaries, flag pins at the location of each school site, and beaded pins to mark the location of each student living within the district.
I remember walking past one of these maps in the hallway of the Cupertino Union School District (CUSD) as a teenager circa 1972 when I spent several Saturdays helping my dad work with the district’s planners.
To digress a moment, I’ll provide a bit of context for the planning being done at the CUSD during that time.
In the 1960s, Cupertino, located in the heart of the San Francisco Bay Area (later known as Silicon Valley), had been growing rapidly. A primarily agricultural area had turned into suburban housing tracts that brought in thousands of families and school children. From the 1960s to the 1980s, the SF Bay Area saw the equivalent of a Gold Rush—more like a Silicon Rush—with computer hardware, software, and semiconductor companies moving in and starting up all over the Bay Area. Ten miles to the west of the district was Intel (in Santa Clara). Fifteen miles to the north was Hewlett-Packard (in Palo Alto). About 15 miles south was the IBM Research Laboratory (in San Jose), and just down the street from the CUSD was a small but growing company called Apple Computer (on Stevens Creek Blvd. in Cupertino). There was also DEC SRC, Amdahl, Rolm Corporation, Sun Microsystems, Xerox PARC, Oracle, Tandem Computers, Atari,AMD, National Semiconductor, Applied Materials, Fairchild Semiconductor, and Seagate Technology (to name just a few of the larger companies)—all with offices in the SF Bay Area.[3]
Needless to say, the population in the area was growing and changing daily. Schools could hardly be built fast enough.
Early in the 1960s, the [Cupertino Union School District] grew at a rate which would make it at one time the fastest growing elementary district in the nation and the largest in the state. During the peak growth years, the district was building five schools per year in an attempt to keep pace with an enrollment increasing by as much as 20 percent in a single year. By 1969–70, the district had built a total of 42 schools for its 23,300 students and the era of expansion had ended.[4]
In 1960, the district had approximately 12,800 students. By 1970, student enrollment peaked at approximately 23,300; but as the decade went on, the land was built out, families settled in, and their children grew up, found jobs, went to college, or moved away. Just like with any rush, things slowed down. By 1980, the enrollment was back down to just over 14,000. (The 2017–18 student enrollment was 18,017.)
Different versions of this same story have played out thousands of times over the decades at school districts across the nation. Most of us—whether as children attending school or as parents, grandparents, or community members—have experienced the opening or closing of a neighborhood school due to growth or decline of the student population.
Back to where ONPASS got its start…
My father worked with the CUSD as a consultant on assignment from the CPE during that period of high growth and then decline. He was charged with assisting the district with its facilities planning, which included using its big wall map to help manage the rapidly changing student population. On a daily basis, “student” pins were added, moved, and removed. When a new school was built, the map was redone: thousands of pins taken off, school attendance boundaries redrawn, and thousands of pins placed back onto the parcels of the revised map. The district greatly needed a better and more efficient way of managing its planning process.
In the early 1970s, a new computerized planning method was being used by some school districts in southern California. It was a software program that computerized the geographic elements of the district (e.g., the school buildings, streets, and boundaries) and stored the student information in an “online data base.” (Note that “online” in pre-Internet days simply meant computer based.) The early GIS computer program, originally developed by Urban Decision Systems[5] in Los Angeles, was called ONPASS, short for Online Pupil Assignment System.[6]
As the story goes, the original algorithm used in the ONPASS program was developed in the mid-1960s by Peter S. Loubal and a small group of research engineers at System Development Corporation (SDC) in Santa Monica, California. They were researching minimum paths and traffic efficiencies for the transportation industry. In an email exchange with my father in 2015, Loubal, explained:
In 1965 or 1966, while working for the (SF) Bay Area Transportation Study (BATS), in charge of traffic forecasting, I met Vlad Almendinger and Bob Totscheck of SDC, in connection with their effort to develop a comprehensive demographic, travel and traffic data management capability to support the multitude of planning efforts in our (and any other) study area. The technical director at BATS was Jay McBride, and we four spent many hours discussing the capabilities needed to manage and fully utilize the vast amounts of data that would support the various modeling efforts.[7]
In his paper, “A Procedure for Allocating Resources Over a Network,”[8] Loubal wrote: “[The procedure] is particularly suited for evaluating possible new locations for schools…and which existing locations should be expanded. A very fruitful area for applying the model is advance emergency planning and operational control in emergency situations. Such applications include the allocation of people to hospitals or to fallout shelters, and the development of contingency evacuation plans.” In his email with my father, Loubal recalled many applications that “deal[t] with transit rather than highway connections…fire spread in structures and terrain…military convoy movement… building a power-line system…evacuation applications (saving as many lives as possible, with limited transportation resources), locating fire-stations, etc., etc., every application was a new challenge.”
In 1970, several people from SDC left to start Urban Decision Systems of Los Angeles where they continued to work on these applications. They commercialized the method for education planning in a program called ISPP (Interactive School Planning Procedure) later called ONPASS, Online Pupil Assignment System. The program ONPASS was first used in the Santa Monica Unified School District in 1971. Kenneth E. Needham, then vice president of UDS, sold a consultant services agreement to the Cupertino Union School District[9] in 1974, where my father was first introduced to the system and computerization of the education planning process. By 1975, it was also being used by the Newport-Mesa Unified School District and the Grossmont Union High School District.
From 1975 through 1980, after decades of rapid growth, the CUSD began to experience declining enrollment. Working with several district planners, my dad used ONPASS to assist the CUSD in planning for and executing the closure of five schools in 1975, six schools in 1978 (including converting two of these schools to different purposes), two schools in 1979, and two schools in 1980—a net closure of 13 schools in five years.[10]
Starting His Business
Having left the CPE when its grant funding ran out and the unit subsequently closed, my father continued working with the CUSD and other school districts as an independent consultant in the areas of planning and evaluation. For computing, he installed a landline to Stanford University’s mainframe computer connected to his “DECwriter[11]” terminal in the den of our house. (For those unfamiliar, a DECwriter was a desk-like apparatus that had a keyboard, a dot-matrix printer, and fanfold paper coming out of the top. No CPU or monitor.) He had a computer timesharing account at Stanford (#W1.C69) and a mail cubby for output (bin 943) at the university’s computer center.
In 1974, my father started his sole proprietorship called Educational Measurement Service. He hired a bookkeeper and a computer programmer and opened a small office near our house.
In 1981, I was fresh out of college and needed a job, so my dad hired me; I was employee number four. By that time, we had several “dumb” terminals (with actual monitors) connected to the mainframe computer at Stanford. My unofficial title was “gopher” because one of my first jobs was to drive from the office in San Jose to Stanford University to pick up computer printouts—a 45-minute drive (one way) to pick up reports (and many times to deliver another check to pay for timesharing)! I did that run several times a week, sometimes multiple times in a day.
In 1982, to commercialize its use for his newly formed corporation, Educational Data Systems, Inc., my dad purchased the ONPASS software source code and obtained full and exclusive rights from Urban Decision Systems. By January 1987, he had developed ONPASS to run on our own microcomputer, an IBM model 360 mini-mainframe that actually sat in a “computer room” in our office. (No more driving to Stanford!)
My father programmed modern (at that time) GIS functions into ONPASS by using the Census Bureau’s GBF/DIME (Geographic Base File/Dual Independent Map Encoding) files, which used street segments and nodes to build a computerized network of streets across an area. To geocode the students, ONPASS used a database of streets, addresses, and nodes to match to the students’ addresses and then present them on a map on the computer. The database linked student addresses to their assigned schools, and a simulation could then be run by the user to model changes such as the closing or opening of a school and reassignments of students. Over time, the Census Bureau replaced the GBF/DIME files with the TIGER (Topologically Integrated Geographic Encoding and Referencing) database containing digitized maps and streets. He purchased these files and loaded them to ONPASS for the area surrounding each school district client.
By 1990, he had reprogrammed ONPASS to run on DOS-based PC computers; then, after Microsoft released its Windows platform, he and a small team of programmers converted ONPASS to run on Microsoft Windows, updating the code over time with each of the various Windows versions released. Suffice it to say, ONPASS has been under continual development from the 1960s to today!
For 40 years, from 1974 through 2013, my dad sold, installed, and supported the software in hundreds of school districts across the nation—from Beaverton School District in Oregon (his first ONPASS client) to Tucson, AZ to Fairfax, VA and the Bureau of Indian Affairs (to name a few).
In late 2018, we announced our most recent version of the ONPASS software, rewritten this time from the ground up to run on Esri’s latest GIS platform, ArcGIS Pro. It is now a 64-bit program that contains all the power of ArcGIS Pro, utilizing a geodatabase and varied base maps (aerial, streets, topographical, etc.) and easily integrating external data sources via shapefile formats such as County Assessor’s and Census Bureau geospatial data. Multiple layers of data can be presented at once and turned on and off to show boundaries, school buildings, and students as icons instead of pins on the map. The new program still has the foundational functions as the original ONPASS but uses today’s GIS technology to model changes in student populations and simulate the optimal assignment of students to schools. Thinking back on those days of programming each tool and report with hundreds of lines of code, it is amazing what the early GIS programs were capable of doing.
The End of the Story, But Not the End
In my earlier blog post announcing the upcoming release of our newly developed ONPASS program, I promised to tell the (long) story of our software, and so I have told it—as much as I know and can remember. I mentioned that, although we have now completely rewritten it, we have lovingly retained the name ONPASS. Why lovingly?
Lovingly because time brings value and, as you now know, ONPASS has been around in one form or another for more than 50 years!
Lovingly because ONPASS has served a real and important purpose in education, helping hundreds of planners, superintendents, and educators make better decisions on behalf of their students and families.
Lovingly because ONPASS was my dad’s life’s work. He rolled up his sleeves and not only designed the features and functions of the different versions, he programmed them himself. He kept apprised of the latest technology and made sure ONPASS was always at the forefront. He also marketed, sold, and demonstrated the software as well as traveled to meet his customers all over the country. He listened to their feedback and internalized their stories and needs. He developed personal relationships, even friendships, with many of them. He used ONPASS to help them in their jobs.
Lovingly because my dad warned me in 2015, the year after he retired (at the age of 83), that it would be a two- to three-year endeavor to rewrite ONPASS, and he was right (well, not really, it’s taken four years); lovingly because I am certain the new ONPASS would make him proud.
Lovingly because I now carry on doing what my dad loved to do: work with educators to solve problems, to make their jobs easier, and, ultimately, to help more students succeed.
My dad, Bill, passed away on July 6, 2017 at the age of 85. His entire career, even into retirement, was spent in education. So, also, lovingly because ONPASS has become a symbol of my dad’s career and of my own career as I worked for, and then alongside, and now in memory of, my dad.
I am very happy to share this story—one that my father loved to tell—and to be releasing ONPASS Pro, maintaining our company’s long tradition of planning for change and serving education.
As of April 2022, we sold the ONPASS Pro software to Angie Templeton of Templeton Analytics, a new company focused on selling the software and offering school district planning and GIS services. Angie has a long history of serving school districts in the areas of demographic and enrollment forecast planning. In the late 1990s and early 2000s, for her previous company, she worked with my father as a partner selling ONPASS to clients. She also was a former ONPASS trainer helping school districts learn the ins and outs of using the software to plan for district changes.
I am very pleased and am sure my father would have been happy that ONPASS Pro will live on with Angie’s new company. What’s most gratifying to me is that Angie understands and appreciates the value of the software as a powerful tool for school district planning and that she will continue to build upon my father’s legacy.
The images of the map you see are from the actual CUSD wall map that was used for planning before the district began using the ONPASS software program. My dad must have acquired this piece before it was put in the trash bin. This segment shows just two elementary school attendance areas. I placed red and blue pins into preexisting holes on a few parcels for effect.
FOOTNOTES: [1] William A. Gilmore, Report Project 360, 1966–1968, Andrew P. Hill High School, East Side Union High School District, pp. i–ii, 1–6 [2]Project 360 Report, Andrew Hill High School, Vol. 1, No. 1, (February 10, 1967) [3] See the Computer History Museum [4]Cupertino Union School District Long Range Facilities Master Plan, (April 22, 1980): I-1 [5]ONLINE, A Publication of Urban Decision Systems, Inc., Issue No. 5, (Fall 1977): 4–5 [6]Computer Assisted School Facility Planning with ONPASS, Urban Decision Systems, Inc., Los Angeles, CA, Oct. 10, 1975 [7] Peter S. Loubal, Email to Bill Gilmore, August 30, 2015 [8] Loubal, Peter S., “A Procedure for Allocating Resources Over a Network,” May 1969, System Development Corporation, 7 [9]ONLINE, a Quarterly Publication of Urban Decision Systems, Inc., Vol. 1, No. 3, (Spring/Summer 1975): 2,5 [10]Cupertino Union School District Long Range Facilities Master Plan, (April 22, 1980): III-7 [11] See DECwriter
By Susan M. McMillan, Ph.D., Senior Statistician and Researcher
Our family moved to Eden Prairie, MN during the middle of the 2011—12 school year. On an ice crystal-cold morning in January, I was pleasantly surprised to discover that a school bus would collect my boys at our corner. When we decided which house to purchase we had been under the impression that our family fell into the “walker” category because we lived only a few blocks from an elementary school.
The pleasant feeling faded as the other parents at the bus stop abandoned their “Minnesota nice” roots and described the acrimonious year-long redistricting process that had sent our neighborhood kids to a school about 1 and a half miles away. Read more