
The Colorado Charter School Institute (CSI) is a statewide charter school authorizer in Colorado responsible for overseeing and supporting a portfolio of public charter schools. As an organization operating within the public education sector, CSI works with school leaders, administrators, governing bodies, and other stakeholders to support effective school operations, accountability, and organizational oversight.
Managing information across multiple independently operated schools requires accurate records, consistent communication, and reliable access to school-specific and portfolio-wide data.
From maintaining school leadership contacts and tracking administrative changes to organizing school characteristics and generating reports, CSI relies on dependable information management processes to support its responsibilities.
As school years transition, these requirements become increasingly complex. Staff must collect updated contact information, account for personnel changes, maintain historical records, and ensure that information remains accessible to the appropriate stakeholders.
Historically, many of these activities relied on spreadsheets, manual data compilation, and administrative coordination between CSI staff and individual schools.
Recognizing the opportunity to modernize these processes, CSI adopted Quickbase in June 2021 as part of a broader initiative to develop foundational organizational applications.
To advance this initiative, Colorado Charter School Institute partnered with Quandary Consulting Group to enhance its Quickbase Contact Management application, establish more consistent school master data, and improve reporting across its school portfolio.
The engagement focused on replacing spreadsheet-dependent processes with structured workflows that would support school contact updates, internal review and approval, annual school-year transitions, and more accessible reporting.
Through custom Quickbase development and workflow optimization, the initiative aimed to strengthen data accuracy, reduce administrative complexity, and create a more scalable foundation for education data management.
Overseeing a portfolio of charter schools requires consistent access to accurate information about school contacts, organizational characteristics, and administrative responsibilities.
As information changes throughout the school year, maintaining a reliable source of truth becomes essential. CSI identified several opportunities to improve how school data was collected, reviewed, maintained, and reported.
Historically, CSI distributed spreadsheets containing existing school contacts to school leaders each June. Schools were responsible for updating the information and returning their spreadsheets in July in preparation for the upcoming academic year.
CSI staff then manually compiled the returned files into a master contact spreadsheet. This process required significant administrative coordination and introduced opportunities for inconsistent information, duplicate effort, and delays.
Although CSI had already imported contact information into Quickbase, school users needed a more direct way to request changes. The existing process relied on select CSI staff to update records when schools reported personnel changes and without a structured self-service request process, contact maintenance required additional communication and administrative intervention.
School contact information needed to be reviewed before changes became available to the broader organization.
CSI required a workflow that allowed designated school users to submit updates while preserving internal review and approval authority. This was particularly important for maintaining reliable records and controlling which information became visible to different users.
CSI historically maintained school characteristics and attributes in spreadsheets organized by academic year.
As information evolved, the organization needed a more consistent way to maintain school records, preserve historical information, and support future application development.
At the beginning of each academic year, school attributes needed to be carried forward while historical information remained accessible.
Without a structured rollover process, annual transitions could require repetitive administrative work and create inconsistencies between current and historical records.
CSI historically prepared school-level and portfolio-wide reports manually; these reports summarized school characteristics and supported administrative oversight.
Maintaining separate reporting processes increased the effort required to compile information and made it more difficult to ensure that reports reflected current data.
Quandary Consulting Group was engaged to further develop CSI's existing Quickbase Contact Management application.
The scope focused on three interconnected areas:
Together, these improvements were designed to create a more structured and accessible environment for managing information across CSI's school portfolio.
The engagement included developing a process that allowed authorized school users to request updates to their associated contact records directly within Quickbase.
The workflow was designed to support both annual updates for the upcoming school year and mid-year personnel changes and by moving update requests into the application, CSI aimed to reduce its reliance on manually exchanged spreadsheets and establish a more consistent process for maintaining contact information.
Quandary's development scope included a review and approval process for contact changes submitted by school users. Designated CSI staff would review requested updates before changes became available in the approved contact records.
This structure was intended to maintain data quality while giving schools a more direct role in keeping their information current. Imm addition, the design also included exploring automated email notifications for submitted and approved requests.
The initiative also included finalizing a School Master Table within Quickbase. This table was designed to become the authoritative source for key school attributes and support synchronization with other CSI Quickbase applications.
The scope also included consolidating relevant fields from existing applications into the master data structure. By establishing a more consistent source of school information, CSI sought to reduce fragmented data management and improve consistency across its application environment.
Quandary's development scope included creating a process for rolling school attributes forward from one academic year to the next. Quandary's proposed functionality was designed to preserve historical school-year information while supporting updates for the upcoming year.
This approach reduced the need to manually recreate or reorganize school records during annual transitions; and, it would also provide a more structured foundation for reviewing school characteristics over time.
The engagement included defining user permissions for CSI staff and school users. These settings were designed to control which information users could access and which activities they were authorized to perform. Quandary also created school-facing dashboard designed to help users navigate the contact update process.
The proposed dashboard would make it easier for school representatives to distinguish between current-year changes and updates for the upcoming academic year.
Quandary's scope included developing reporting capabilities for two distinct audiences.
These reporting capabilities were intended to use current Quickbase information, reducing the need to manually compile separate spreadsheets.
The engagement established a development scope centered on improving how school information was collected, reviewed, maintained, and reported within Quickbase.
The Colorado Charter School Institute (CSI) engagement illustrates how low-code application development can help public education organizations modernize information management without replacing their existing technology investments.
By expanding Quickbase functionality, CSI sought to establish more consistent processes for managing school contacts, maintaining master data, preserving historical records, and producing administrative reports.
The initiative also demonstrates the importance of combining workflow automation with data governance. Rather than simply moving spreadsheets into a digital application, the proposed approach introduced structured permissions, approval processes, standardized school records, and reporting capabilities designed around the needs of different users.
For charter school authorizers, school networks, and public education agencies, this model provides a practical framework for reducing administrative burden, improving data accessibility, and supporting more consistent organizational oversight.
Through its Quickbase consulting, custom application development, and workflow automation capabilities, Quandary Consulting Group helps education and public sector organizations modernize administrative processes and establish more reliable foundations for operational data management.
Services
Industries




© 2026 Quandary Consulting Group 2026. All Rights Reserved.
Privacy Policy