Category

Education

Education, Municipal, News

Munetrix Again Named to the GovTech 100 List

Munetrix Named to GovTech List for Fifth Year Running

Munetrix is proud to be once again featured on Government Technology’s GovTech 100 list, a compendium of 100 companies focused on, making a difference in, and selling to state and local government agencies across the United States.

Munetrix has earned this prestigious honor every year since 2016, each year the list has been researched and published.

The announcement reads, in part, “In 2020, as detailed in this feature-length article in Government Technology magazine, the gov tech market brought bigger deals, more investment, new companies and many fresh new innovations that moved the needle in the public sector.”

“We are thrilled to once again named to the GovTech 100 list,” said Bob Kittle, Munetrix President and CEO. “This annual recognition is a reflection of our team’s commitment to innovation, product development and, perhaps most of all, personalized customer service. We continue to try make data analytics easy, intuitive and centralized for our users in the municipal government and education sectors.”

Government Technology wrote in support of the 2020 announcement:

“Five years ago, Government Technology saw something happening: Civic tech was changing. Fueled by new technologies, modern methodologies and a sudden interest from investors, startups were beginning to work more with government. In a space long dominated by incumbents, notorious for complex procurement and implementation cycles, agencies were hungering for something new. We took note, and launched a list of 100 companies that represented that ecosystem.”

school assessment data
Education, K-12, Opinion

Addressing Inequities and Assessment Challenges Facing Educators, Students and Families Amid Imperfect Educational Environments

How Adopting Emerging Technologies Facilitates Learning, Simplifies Progress Monitoring, and Improves Student Outcomes

A version of this article originally appeared in District Administration Magazine.

As we approach the midpoint of this school year, students are learning via a variety of instructional modalities, including face-to-face, virtual and hybrid instruction.  As COVID-19 cases, hospitalizations and deaths are rising again, schools are shifting between instructional models to flex with changing health safety guidelines and local community dynamics. Educational pedagogy such as “synchronous” and “asynchronous learning” are becoming household terms. And, educators at all levels are making Herculean efforts to keep up with these challenges and to provide the best possible instruction for students.

In this oscillating climate, educators must pivot quickly to adapt—guided by data—to have the greatest impact on student learning. The ability to rapidly access, analyze and evaluate data—across multiple assessments and platforms (along with other types of data)—is critical to making decisions about instruction, programming and interventions.

The Continuing Impact COVID-19 Will Have on Students this Fall

A recent study conducted in partnership between NWEA, Brown University and University of Virginia (EdWorkingPaper 20-226) projects that “Students are likely to return in fall 2020 with approximately 63-68% of the learning gains in reading relative to a typical school year, and with 37-50% of the learning gains in math.” The study goes on further to state, “We estimate that losing ground during the COVID-19 school closures would not be universal, with the top third of students potentially making gains in reading.” 

In short, not every student will be impacted in the same way, nor to the same degree. Equity plays a large role in the learning gaps between individual students resulting from a variety of elements including prior achievement, socioeconomic factors, access to technology and internet, teacher training on virtual instruction, support within the home, and more. 

Dynamic reporting tools can help educators to look at trends, past and present, and disaggregate trends easily by filtering at various levels.

Why is Data-Driven Instruction More Important Than Ever?

While assessments can be powerful tools to identify student needs or monitor student progress/growth, assessments are only powerful when the data is analyzed and applied to drive instruction, programming and interventions. Educators must use data to take action for data to have any utility. Otherwise, it’s just more test data.

In Paul Bambrick Santayo’s book, Driven by Data, he writes that schools need to change their focus from, “what is taught” to “what is learned.”  The impact of the pandemic on student learning and the ongoing transitioning of learning environments escalates the necessity of this shift in focus.

Bambrick-Santayo goes on to identify that there are four fundamental building blocks to data driven instruction: assessment, analysis, action and culture.

  • Assessments must be standards-aligned, with varying levels of questions for depth of knowledge and understanding and provide data that not only informs instruction but helps to compare students with their peers. 
  • Analysis is the key to using the data to identify areas of student need so that action can be taken. 
  • Educators must understand how to apply the conclusions from their data analysis to take appropriate actions that have the greatest impact.
  • Finally, educational leaders must create a culture in which data-driven instruction will thrive.  This includes providing and following an assessment calendar, providing time for deep data analysis and discussion, and encouraging/supporting educators in using the data to guide actions taken.
Dynamic reporting tools in data analytics systems allow educators to quickly analyze trends over multiple assessment periods, and aggregate/disaggregate data using filters.

The greatest barrier to moving from assessment to action is the deep and meaningful analysis of assessment data. Analysis requires the “systematic examination of assessment data to thoroughly determine students’ strengths and weaknesses, then taking the necessary steps to address their needs,” states Bambrick-Santayo.

How to Optimally Get from Assessment to Action

According to Bambrick-Santayo, the first core driver of analysis includes “user-friendly reports.” Time is the new premium. There isn’t the time, nor resources, available to build complex spreadsheets to facilitate comparing data across multiple assessment platforms. The skill level at which educators can analyze data varies as greatly as the instructional levels among students, and many educators may not have the technical skills to create and manage the elaborate spreadsheets needed for meaningful data analysis. Time to teach these new skills is severely limited or not available.  Furthermore, safety protocols, preparation for virtual learning classes, and the new logistics/daily routines of instruction have removed any “extra” time that was once nominally available.

Educators need tools that help analyze data across multiple platforms—quickly, easily and seamlessly. They want tools that provide easy-to-read reports, where computerized systems “crunch the numbers for them.” These tools should rapidly disaggregate or aggregate student assessment data at the student, class, grade, building or district level—by subject, standard or objective—all within a few clicks…not hours or days.

Dynamic reporting tools can help educators easily group students by proficiency and skill/goal area for targeted instruction/intervention.

Dynamic platforms empower educators to change views rapidly in order to identify trends, gaps and areas of need. They help educators filter different types of student data, including achievement, attendance, behavior, demographic and perception data, so that schools and districts are able to analyze the needs of the whole child. In a perfect world, this should be available in one online platform (not multiple systems with different logins that require manual massaging of data between platforms). Data must be accessible anytime, anywhere, to adapt to changing school environments.

Dynamic reporting tools can help educators easily identify significant gaps among different groups of students, help drive data-based decisions on interventions, programming and resource allocation.

A “New Normal” Guided by Data

Perhaps COVID-19 will accelerate the implementation of data-driven instruction to permeate more substantially in everyday educational practice. The easier data analysis is, the more it frees educators to spend their time taking meaningful action with students. For Data Driven practices to take root, educational leaders must also purposefully set aside time to infuse deep and meaningful data analysis, planning and action into the school culture. 

It’s not that educators don’t have enough access to data. It’s that educators need to easily convert that data into intelligence…and intelligence into action. Only then, can educators focus their time, energy, expertise and passion on what they do best—educating and developing today’s learners!

Linda Kraft is Director of Customer Experience with Munetrix, a Michigan-based data analytics and management firm serving school districts and municipalities across the country. She can be reached at linda@munetrix.com. Learn more at munetrix.com.

References 

Bambrick-Santayo, Paul.  Driven by Data 2.0: A Practical Guide to Improve Instruction.  Jossey-Bass, 2019.

Dorn, Emma, Bryan Hancock, Jimmy Sarakatsannis, and Ellen Virelug. (2020)., COVID-19 and student learning in the United States: The hurt could last a lifetime.  Retrieved from Fresno State University: https://fresnostate.edu/kremen/about/centers-projects/weltycenter/documents/COVID-19-and-student-learning-in-the-United-States-FINAL.pdf

Kuhfeld, Megan, James Soland, Beth Tarasawa, Angela Johnson, Erik Ruzek, and Jing Liu. (2020). Projecting the potential impacts of COVID-19 school closures on academic achievement. (EdWorkingPaper: 20-226). Retrieved from Annenberg Institute at Brown University: https://doi.org/10.26300/cdrv-yw05

Education, Municipal, News, Opinion

Munetrix Offers New COVID-19 Dashboard to Michigan Municipalities and School Districts at No Cost

Company Partners with Bloomfield Hills Schools and the Metro Bureau to Develop and Distribute Dashboard Statewide

Munetrix, in partnership with Bloomfield Hills Schools, has developed and launched a new COVID-19 dashboard and is making the dynamic dashboard available to any municipality, county or school district that wishes to embed it on its own website, at no cost to that government entity. In addition, Munetrix has partnered with the Metro Bureau to distribute dashboard embed codes to its member organizations across the state of Michigan.

First deployed on the Bloomfield Hills Schools homepage, the COVID-19 dashboard was developed initially to address the desire of Bloomfield Hills Schools administrators to provide clear communication regarding the school district’s readiness to return to face-to-face learning to parents in a way that would be as easy to understand and as readily updated as possible. In doing so, district officials approached Munetrix to develop technology that would source data from state of Michigan’s coronavirus case data and display relevant metrics to provide clear indicators as to the most current moving averages of new cases per 100,000 population, sortable by county, as well as to display each county’s rolling percent-positive data.

The dynamic dashboard draws state data that is both updated (with new cases) and refreshed (updating prior case data) daily, giving district parents the most accurate, timely and geographically relevant data available.

The two data visualizations provided on the dashboard are intended to give parents and community members an instantly intuitive snapshot regarding a given district’s readiness to return to face-to-face learning or its risk level of regressing to all-virtual learning environments using a color-coded graphic representation of moments in time, dating back to March 1, 2020. The system utilizes the Harvard Global Health Institute Model developed by Dr. Ashish Jha and others to create standards for risk factors and thresholds by which a school district can establish triggers for moving from one phase of risk tolerance to another. For example, the Bloomfield Hills Schools parameters dictate that the county remain at least 21 consecutive days in a given risk level before the district is eligible to enact predetermined protocols for moving to a next phase of learning modality.

Leveraging the standards established by the Harvard Global Health Institute Model, Munetrix displays risk ranges in the conventional red-orange-yellow-green convention, making the data intuitively accessible and visually clear, educating parents, children, district personnel and the community at large as to a district’s current state of return readiness at any given time.

Making Difficult Decisions Easy to Understand

Not only does this accessible dashboard allow for quicker, data-based decision making, it is a tool that serves to provide transparency and information to parents during a time when uncertainty and anxiety are heightened, making such information accessible on-demand, 24/7.

“We’ve heard of parents who watch the numbers on our dashboard like you might watch the stock market—three times a day!” said Patrick Watson, Superintendent of Bloomfield Hills Schools. “It also gives parents the information when and how they want it, no longer relying on answered phone calls and returned emails that may take some time to address,” he added. “The number of phone calls and emails into the office, with people looking for updates and information, has dramatically reduced, allowing our staff to focus their energy and resources on optimizing our learning environments, both virtual and in-person.”

“As a data visualization company, we continue to consider it our duty to do whatever our technology allows to deliver easy-to-understand, actionable intelligence to those who need it, and to make it simple for anyone to display, use and understand,” said Buzz Brown, Vice President of Customer Engagement and Chief Data Officer with Munetrix. “There has never been a more urgent time for accurate and timely information than during this pandemic, especially given how it’s affected our schools, educators, administrators, families and learners.”

Melissa Baker, Executive Director of the Metro Bureau, immediately recognized the value that this new dashboard provides to school districts and their constituents, offering to facilitate the distribution of free embed codes provided by Munetrix to its membership. “This is such an incredible value-add to our district members,” she said. “People are craving accurate, timely and understandable data these days, and our members are committed to providing it. Anything that makes this easier on everyone is something we as an organization are committed to broadly distributing.” 

Munetrix and the Metro Bureau receive requests for embed codes daily, with dashboards now being displayed on several district home pages across the state…east and west, north and south. 

Munetrix will provide a copy-and-paste embed code at no cost to any school district or government entity that would like to display the dashboard on its own website. Simply contact Munetrix to submit a request, or Metro Bureau members can complete this form to request a code. 

To see how this dashboard is being deployed by local school districts to make informed decisions about learning environments and communicate transparently with parents and the community in real time, watch the story that Local 4 Newscasters shared with their viewers. 

About Munetrix

Auburn Hills, Mich.-based Munetrix, among the nation’s largest aggregators of municipal and school district data, promotes municipal wellness and sustainability through its cloud-based data management tools and proprietary performance management applications. In partnering with Munetrix, municipalities and school districts are able to manage their data and access cost-effective products and advisory services to make meaningful and reliable budgets, financial projections, academic achievement metrics, trend reports and better-informed forward-looking decisions. Learn more at www.munetrix.com.

Education, Municipal, Opinion

Etiquette and Other Best Practices for the New Normal

Perfecting the Two-Dimensional Meeting in the Age of Virtual Conferences

It’s been an unusual few months, getting used to Zoom and similar technologies. Users have had fun with virtual backgrounds, emojis and other gimmicks. Guess what? Summer is almost over, and the remote collaboration environment is here to stay for many. We are hearing a significant percent of the workforce will not return to the office in any foreseeable future. The two-dimensional meeting is here to stay, and it’s important to learn how to use it.

Create a Profile

Make sure you get a presence in each app you find yourself using. Whether it’s Zoom, Teams, or GoTo meeting, get an account (even if it’s free) and create your profile. Make sure you have a proper picture to display when your video is off. Consider including your organization’s name and job title. For example, stop to consider if your meeting environment deems it acceptable to have the Millennium Falcon as your background.

Plan Your Workspace

It was fun for a while hearing your colleagues’ dogs bark, the occasional cat on the keyboard, grandkids Zoom bombing, or critiquing home decor. As I said, summer is almost over. It’s back to work or school time. Plan to have a proper location, depending on the nature of your audience. Be careful of what’s in the background. I’m sure you may be passionate about your politics, religion or other endeavors. Be mindful of your audience. They may have conflicting views and get distracted from your input as they are focused on reading book titles on your shelf.

Test the location and quality of your camera. Make sure it appears as though you are looking into the camera, otherwise you appear aloof. If you are using multiple monitors, you may need a camera that is not attached to your laptop or screen. The camera should be located behind the monitor you will be using on the call. Make sure the camera is located slightly above your face, and not below your face.

Avoid Joining with Links

Now that you have taken the time to create a profile in the app, do not lose it by joining meetings through links. Sometimes the link brings you in the meeting as a generic user. Launch your app first, log in as you, and then join the meeting with the meeting ID.

Live Etiquette

When you are live in the meeting, make sure your tile includes your name and not some generic title like “Mom’s iPad.” How many times have you been in a meeting and wondered who someone was? This is your chance to always have your name and affiliation posted for all to read. Reading body language in a meeting is important but sometimes difficult sitting around a table. The two-dimensional tiles can make it easier, as long as the cameras are on. Similarly, if you are not going to pay attention to the presenter, turn your camera off. It’s obvious when you are doing something else.

Consider having your mic muted at all times until you are ready to speak. Background noise can be distracting to others in attendance, and even disruptive to the meeting in general.

Guest Speakers

There’s been a paradigm shift in two converging directions from which you can benefit. Attendees are much more willing to attend a virtual event now with a guest speaker, and guest speakers are much more willing to stay home. Nationally known speakers that would have cost in the five-digit neighborhood with travel expenses are now willing to spend an hour on your call for $1,000 or less. Use this as an advantage to engage your audience and significantly enhance the quality of your material.

Camaraderie

Here you will need to be creative, but this part can be the most rewarding. Some of your attendees may have limited contact with other humans. New hires don’t have the option of chatting over the water cooler with colleagues in an office building. You need to create that human contact and build that team virtually.

Members of the Munetrix team were presenters at a recent association board meeting, and the Board Chair always included a team event at her meetings. She wanted to continue that tradition virtually. We used a game show app with topical trivia questions to engage all attendees. Amazon gift cards were awarded for most points.

“MASFPS board members were able to enjoy a round of Kahoot with our friends from Munetrix during our summer leadership and learning academy,” says Sara Shriver, Executive Director with MASFPS. “This was a great way to engage all members during a virtual learning event! It was fun, competitive, and a unique way to build camaraderie as an organizational team!”

ADA Compliance

Lastly, remember and consider the hearing and visually impaired community when conducting meetings, to make sure you are staying compliant with ADA guidelines and requirements. The Center for Hearing and Communication has issued guidance on this matter, and Zoom itself offers its own disability compliance tools and disclosures. Check out Zoom’s library of resources and documentation here, but be sure to frequently check and update your policies and procedures, as both technology and regulations change frequently.

No one can state with certainty how “normal” this “new” reality will last. But we can all take measures now to make the best out of an imperfect working, learning and collaborating environment, until such a time that we all get back to the old normal.

Buzz Brown, Co-Founder, serves as Vice President of Customer Engagement and Chief Data Officer with Munetrix. He can be reached via email at buzz@munetrix.com or by phone at 248.499.8355.

Education, Fiscal Health, K-12, Opinion

Schools Should Take a Three-Phased Approach as They Plan to Return to “Normal”

How to Adapt Today, Become Adept Tomorrow, and What to Adopt Permanently

[A version of this post originally appeared on District Administration, a national trade journal serving school district administrators and educators.]

When announcements came that states were closing schools for the remainder of this school year, in a way they brought the first semblance of clarity to the myriad spate of unknowns. Soon, we began to look ahead to the fall school year, which brings its own set of variables and unknowns. While we expect timelines and announcements to vary from district to district and state to state, one thing is becoming increasingly clear: it is unlikely that things will soon be getting “back to normal” in large measure.

With each day comes increased clarity, if only at the margins, but that clarity is often difficult to recognize in moments of urgency and quickly shifting priorities. But each day, discoveries are being made: we weren’t prepared for this or that, we hadn’t accounted for every contingency, or perhaps, maybe we’ve stumbled upon a better way to manage this particular task.

Which is why, though it may seem difficult at first, school districts and personnel at every level of education should be taking this time to reassess their systems, processes and vulnerabilities to optimize what will eventually be a return to some degree of normalcy. But it likely won’t happen overnight. In fact, we suggest that educators and administrators take a three-phased approach: take immediate remedial actions where you can in the short term, plan for an eventual transition back to a more recognizable learning environment, and document what new workflows should be permanently adopted as best practice long-term.

Phase One: Triage for Today

Literally overnight, educators and administrators were thrust into an entirely unfamiliar work and teaching environment. Technology needed to be learned and adopted without warning, nor training. Employees dispersed to millions of disconnected remote home offices in an instant. Nearly everything we took for granted, in terms of collaboration, communication and cooperation, was suddenly taken from us. And many instantly discovered the limitations and vulnerabilities that few had accounted for.

Access to systems and documents proved challenging for those who are used to keeping software and hardware under literal and figurative lock-and-key. If “it’s at my desktop at school,” it’s practically unreachable at the moment.

But work needs to get done. Meetings need to happen. Projects need to press forward, and budgets will soon be due. We cannot permanently pause. As many have discovered, time waits for no one. 

All of this underscores the need to quickly establish and document new workflows, new teams, new processes for planning, and new systems and technology that live in the cloud or are accessible to anyone who needs it, 24/7. 

Amid all of our other urgent priorities, administrators and educators should be documenting proper workflows that account for each of the following:

  • Tasks: Capture explicit documentation of all required tasks to complete a given project.
  • Teams: Make sure all tasks are assignable to ensure completion and inject accountability.
  • Timelines: Create project milestones that are clearly defined and realistically attainable.
  • Metrics: Measure progress and success against pre-established desired outcomes.
  • Prompts and Reminders: In times of uncertainty, teams will need (and respond to) built-in alerts and prompts when deadlines approach or new priorities arise.
  • Collaboration: Multiple teams may need to collaborate on overlapping projects. Create safeguards against tasks being missed due to workflow handoffs or unclear accountability.

Once decided upon and documented, leverage available technology to create one centralized knowledge base and project management tool, accessible remotely. Harnessing workflows into one centralized location will make sure nothing gets missed or skipped and can account for new workflows that might come along as priorities shift or change.

Phase Two: Transition to Tomorrow

Workflows, processes, systems and task forces will eventually need to return to a more conventional reality. The problem is, we don’t currently know when that will be. Perhaps it will be announced as suddenly as we transitioned away from our regularly scheduled programming. There will be a sense of relief, to be sure…but there will also be demanding deadlines and daunting decisions equal to those we are grappling with today. 

If uncertainty can be mitigated, now is the time to do it, when it is most relevant and obvious. School districts should be encouraging administrators, educators and clerical support to document where the vulnerabilities and shortcomings emerged, so they can be addressed, not only in the long term, but to avoid a painful transition-back in the nearer term.

In the past several weeks, decisions had to be made with little warning, and new processes had to be up and running overnight. But now we do have some luxury of foresight, knowing that a return to regular education is coming, even if we don’t know when. Perhaps now is the time to plan for those workflows and processes to be updated, especially considering that each individual workflow and task force might have several sub-workflows, and perhaps even disparate teams collaborating at different points and times.

A few transitions we can anticipate now, for which workflows and centralized knowledge bases can be established:

How will we track and process the return of devices that have been assigned out, and who is assigned to each subtask?

What is the new process for building preparation and maintenance, following the sudden dispersal of maintenance personnel, including timelines and accountabilities for reopening facilities?

What updates to registration workflows might need to be made if registration for the new school year is in a compressed time frame or needs to occur remotely/digitally?

How do our teacher and student evaluations need to be addressed, given how the final weeks of this school year’s curricula were delivered?

What changes need to be made to accommodate school lunch provision, both over the summer and should another similar crisis arise—remote delivery or centralized pickup?

Many districts were preparing to roll out a new math series in the fall: Will workflows need to accommodate new realities and timelines?

How will summer school be administered?

Are there necessary changes to scheduling and processing of material assets, such as bus maintenance?

As budget deadlines approach, how can we build in scenarios, given the many unknowns?

Technology is better equipped to manage these tasks, workflows and scenarios at scale than humans, pen-and-paper, or even static spreadsheet software (like Excel or Google Sheets). In most cases, the data to make informed decisions and create optimized workflows already exists and is readily available to school districts. There’s never been a better nor more urgent time to plug in to the tools at our disposal.

Phase Three: Adopt to Adapt, and Stay Adept

What many discover during times of crisis is that processes and procedures adapted out of urgency or necessity can actually be adopted as best practices going forward. In fact, the quicker, most efficient way to accomplish priorities can be discovered then defined to make our teams more effective while reducing costs and eliminating unnecessary exposures to human error.

The first step is moving away from paper and into digital environments. Next, make sure that data and technology is universally available and accessible—from anywhere, at any time, by anyone who should rightly have access. Lastly, allow (or force) technology to do the heavy lifting of planning, coordinating and measuring successful projects and collaborating teams.

Your new workflows and systems should allow you to:

  • plan and prepare for the unknown
  • proactively put processes in place and document workflows
  • account for contingencies
  • consider various and, perhaps even unforeseen, scenarios
  • trigger alternate paths, as appropriate
  • maintain a centralized knowledge repository that can be shared, not only among existing team members, but in perpetuity, even as personnel turnover continues at pace for the foreseeable future

School district professionals may find it challenging to manage the complexity of workflows even under “normal” circumstances. Maybe “normalcy” will return soon, but in the meantime, increased urgency and shifting priorities can create or elevate margin for human error. If we can use this challenge as an opportunity to modernize and optimize workflows, we will all be better for it…both in standard operating procedures and, heaven forbid, when the next crisis presents itself.

This discipline and attention to detail in the short term will build better habits for the long run. Once we emerge from crisis mode, we should take comfort in the lessons learned and the uncertainty conquered.

Linda Kraft is Director of Customer Engagement with Munetrix, a Michigan-based data analytics and management firm serving school districts and municipalities across the country. She can be reached at linda@munetrix.com.

Education, Fiscal Health, Municipal

Budget Planning at the Height of Uncertainty

Scenarios are Critical When You Can’t Predict the Future

[This article also appears in American City & County Magazine.]

For many working in the public sector, budgeting for an upcoming fiscal year is well underway. Has there ever been a more challenging time to account for future unknowns than the current crisis we find ourselves working to overcome?

Budget planning during a “normal” fiscal year is difficult enough, as unknowns and what-ifs are a part of the budgeting process. Past experiences and fairly settled patterns on which we can generally rely help us predict many of our budget assumptions. But forecasting and projecting an annual plan at a time when “facts on the ground” are changing so fast makes the plans we craft today seem like a fool’s errand.

School administrators and municipal managers should be forgiven for feeling ill-at-ease during their fiscal year-end planning and next-year budget planning sessions: Even the “experts” are getting projections wrong. Their models were off. New data emerged. We failed to account for this or that.

But the numbers will soon be due, and telling. There’s no sense in denying reality. The good news is that there are measures we can take today that won’t necessarily eliminate unpredictability in the future; but can at least account for it…and maybe even prepare for it.

Dynamic Events Demand Dynamic Scenario Building

A school superintendent friend of mine made a profound statement the other day, suggesting that, “Every district better have three budgets in their pocket when they start the 2021 school year!” Great advice!  But how?

One of the best ways to hedge against uncertainty is to create various and disparate scenarios, then calculate the outcomes to provide a range of projections for what the future might look like. The problem many budget builders are having right now is that inputs are seemingly infinite: What if income tax receipts drop 10%? Or 15%? What will our parking revenue be? Not knowing when our retail businesses will be back up to full stride, how much sales tax will they generate? How many children will  show back up for school when it reopens? How will we bus them? How will cafeterias function? With so many jobless claims, how “off” will our income tax revenue be? What if our expenses rise tenfold? With so many unforeseen investments suddenly necessary and urgent, such as PPE being sold at prices four to ten times higher than normal, new cleaning supplies and systems, increased investment in remote technology, ambulances that are wearing down quicker, with longer wait times for replacements, etc.? What if? What if, What if? 

We can’t reliably predict the relevant time horizons to inject any sort of end-date confidence into these projections. Yet, we don’t have the luxury of time to wait for a return to any semblance of “normal,” when projections and forecasts can be more reliably made. So now what?

NOW is the time to act – even if the budget isn’t due for a couple months or more. If we wait too long, too much will have changed, so much new information will have to be accounted for, and we’ll find ourselves scrambling to make best guesses and insert relatively random estimates in the interest of urgency. That’s a recipe for error, and even greater uncertainty. A perfect budget isn’t a reasonable expectation. Budgets are a plan, and plans are subject to change. 

Our advice is to look at the big picture…many of them, in fact. Whereas financial professionals have the natural gift, inclination and patience to make calculations in a very granular manner, the current moment demands that we take a step back and look at broader trends, larger impacts, and to be inclusive of line items we’ve never accounted for in the past. If we don’t, our granular and exacting attention to detail will be swept away with the tide of this rushing wave of new information.

In short, these are dynamic times, to be sure. Events, facts and data change hourly. Your budgeting needs to be equally dynamic and nimble to adapt right along with them.

Start with Three; Adjust as Needed.

With so few knowns and so many questions, we recommend that budgeters start by bracketing uncertainty to limit the range of unpredictability. From there, we can hone in. Start with three budget scenarios, after you’ve made your best-case analysis (likely an educated guess) where you are in the current budget cycle (be conservative) and use a top-down approach (i.e., you can’t spend more than you have), and start with revenues.

  • Best-Case Scenario: What is the most optimistic—but realistic—vision for future revenues and expenditures? Don’t be overly bullish…rather, very cautiously optimistic. This exercise will inject greater calm and confidence, and help you prepare for the future absent negativity, emotion or panic. Just as the coronavirus models themselves improved as behaviors changed, it is possible to emerge from this challenge better off than we’d originally feared. Be sure to have a plan for that eventuality.

  • Worst-Case Scenario: The counter exercise will allow your mind, your team and your planning process to put a bracket around your worst fears. Documenting those not only allows you to start planning now for the worst possible outcomes, it can have the effect of actually easing anxiety, as your budgeting should demonstrate your entity’s ability to withstand the coming storm, if you start accounting for the tough road ahead sooner.

  • Realistic Middle Ground: Only after going through the prior two exercises will your brain and your budget be able to wrap itself around the most likely scenario, factoring in both the negative and positive possible versions of the future. Clarity should emerge. You will get to a point where your focus is on some version of a reasonable forecast, from which you can tinker and tweak to account for deviations in inputs as actual data becomes available.

From there, you’ll want the ability to quickly and repeatedly adjust variables, including revenue and expenditure parameters, once unknowns become likelihoods, and eventually, knowns. It is absolutely critical, though, to build that framework now, so you can continue to make adjustments along the way, rather than build something new from scratch 20 times between now and the budget’s due date.

Of course, standard, off-the-shelf spreadsheet software will make this onerous and rigid. If there was ever a time to make an investment in a nimble, predictive and agile technology to create, envision and modify budget plans, it’s now. The minute you have a scenario settled, the facts will change. And even accounting for numerous and varied scenarios, you can be assured that once you find yourself presenting that budget to a room full of decision makers, someone at the table will inevitably ask, “Have you ever considered what this will look like if X happens, and not Y?”…presenting yet another scenario to consider! 

You’ll want to have that answer in minutes…not weeks or months. For all its utility, Excel will not be up to that challenge. Being able to adjust assumptions on the fly is critical.

Three scenarios may not even be enough. You’ll want a tool that can overlay five or more, and demonstrate side-by-side comparisons, so that informed decisions can be made easily, confidently, collaboratively and quickly.

In the Meantime, Cash is King!

Now is not the time to rest on our laurels and wait for the dust to settle. Apart from working hard on budgeting for an unknown future, we can and must take actions in the more certain present to mitigate future hardship, if at all possible. 

Consider pausing collision insurance on fleet assets, like school busses or dormant DPS vehicles. Before you do, fill the entire fleet up with historically inexpensive fuel, and even try to buy future fuel contracts. Adjust your HVAC controls. Turn off ISPs and cable TV access for buildings not in use. Renegotiate payment terms with vendors, including discounts for early payment terms. Nothing should be off the table. It’s time to re-evaluate everything!

In our experience, chaos breeds opportunities, and there is no time like the present to start addressing an uncertain and ever-changing future.

Need help or ideas? Contact us! Always happy to have conversations and explore scenarios! I can be reached personally using bob@munetrix.com, or leave a message at (248) 499-8355.

Education, Fiscal Health, Municipal, News, Press Releases

Munetrix Provides Live, Interactive Map of Coronavirus Cases to Any Government Agency at No Cost

Free Embed Code Allows Governments to Provide Visualized Map for Any Website

Munetrix, a data analytics solutions provider serving municipalities and public school districts, has developed and launched a visualized map that renders live coronavirus cases data by county, and is making the map available to any municipality, county or government agency that wishes to embed it on its own website.

The Michigan Association of Counties was the first such organization to embed the map on its home page, and since then, more than ten others have embedded the map, including regional councils of government, counties, cities and more, representing more than 5,000 cumulative user views of the map in total as of April 13th.

The interactive map visualizes various data in a live, interactive and scalable manner, with various ways to render the most recently reported government data, including the number of cases, the number of deaths, as well as cases and deaths per 100,000 population, which is sortable by county, council of government and other geographic criteria, as set by the user.

“Access to updated, actionable information is critical right now, both for governments and the constituents they serve,” said Bob Kittle, President and Chief Executive Officer of Munetrix. “It’s vital that the data be visualized, easily understood and widely accessible, as leaders, administrators, health departments and the general public alike make critical and, oftentimes, life-or-death decisions during this COVID-19 pandemic.

“We felt, as a data visualization company, it was our duty to do whatever our technology would allow to deliver that intelligence to those who need it, and to make it easy for anyone to display, use and understand,” he added.

Munetrix will provide a copy-and-paste embed code at no cost to any agency or government entity that would like to display the map on its own website. Simply contact Munetrix or the Michigan Association of Counties to submit a request.

About Munetrix

Auburn Hills, Mich.-based Munetrix, among the nation’s largest aggregators of municipal and school district data, promotes municipal wellness and sustainability through its cloud-based data management tools and proprietary performance management applications. In partnering with Munetrix, municipalities and school districts are able to manage their data and access cost-effective products and advisory services to make meaningful and reliable budgets, financial projections, trend reports and better-informed forward-looking decisions.


Education, K-12, Municipal, Opinion

The Problem with Buzzwords

Is the use of jargon actually standing in the way of progress?

“Transparency.”

“Smart cities.”

“Big data.”

Our world is littered with them. Call them “buzzwords,” call it “jargon,” call it “government speak.” Whatever you call them, it’s clear that people are using words and expressions they don’t fully understand, can’t reliably define, and, what’s worse, won’t even recognize when they actually see them executed properly.

Heck, even the word “data” has become something of an overused, catch-all moniker being applied to virtually anything containing a fact or figure. Is a printout of a spreadsheet, tucked away in the desk drawer of a retired clerk, “data?” Is a crumpled-up, out-of-date map “data?” Is an artifact dug from an archeological site considered to be “data?”

And what makes data “big,” for that matter?

Or consider the concept of “smart cities.” What makes a city “smart?” Sure, there are definitions out there…but can you recite one? Most people can’t—even those clamoring for them (or even part of the conversation, in many instances).

Which brings us to “transparency.” Transparency is a word I’ve been hearing since the 1980s , first in the automotive world, later in the political arena , and now virtually everywhere you turn—including routine business matters with municipalities and school districts. But ask 100 people to define transparency and you’ll get 100 different answers. (I know…I’ve done it!) 

Even our old friend Noah Webster has a difficult time defining transparency: “the quality or state of being transparent.” (Not joking…look it up.) The definition of transparent per Webster is no joy either, the best of eight options being “readily understood.”  So the answer is: “the quality or state of being readily understood?” See the problem?

If we can’t even agree on definitions, how can we come to consensus as to whether we’ve achieved the outcomes we all profess to desire, such as government transparency, smart cities and the public’s understanding of available community data?

The Problem with Jargon

It’s not that they aren’t admirable and worthwhile pursuits, these commitments to transparency, the continued progress toward smarter cities, and providing universal community access to public data. They are. The problem arises when people use buzzwords as a shield from scrutiny or evaluation.

If nobody truly understands the meaning of a noble-sounding aspiration, it becomes easy to pay lip service to abstractions and hide behind actual results. Claims of transparency and “smart-ness” become easier to tout, as an unwitting public is becoming increasingly immune to their effects: We hear the words, we vaguely understand the actions people are making toward the objectives these buzzwords describe, and we assume progress is being made. It’s comforting, in a way.

But what if it’s not?

What if we end up with  the illusion of transparency, but, in reality, too few are actually achieving the intended goals of informing our public, community employees and elected officials?

Consider a hypothetical: An entity commissions a study and produces a 500-page report, then posts a PDF of that report somewhere buried deep within its website. Is this transparency? Is the PDF even data? At 500 pages, it certainly is big…but big data, it is not.

The ultimate danger that the proliferation of over-used and misapplied terminology poses to our communities is that we hear the lip service, we see activity and proposals, we witness claims of accomplishments, and we fall complacent to actually achieving measurable results and meaningful progress toward the vital ends our communities need to achieve—fiscally, scholastically, and politically.

Less Talk, More Walk

As an industry—and as a community—we can do better. As someone who works in the “data” business, I see the opportunities firsthand. We need to better educate our citizens about important initiatives we pursue on their behalf…and clearly report on the progress (or lack thereof) being made. 

Free of jargon. Free of buzzwords. Overflowing with clarity.

Let’s understand what types of information our community is truly interested in seeing, and let’s package those facts and figures in a way that is accessible and relevant to their interests. Let’s hold “Citizen 101” town halls to better educate our friends and neighbors about what they can know about, what they can care about…and what they should stay educated about…and let them tell us what “transparency” truly means to them.

It’s not that the technology isn’t there. We have all the data we need…big and small! And we look at ours daily. The types of information that people most readily click on and download just might surprise those who might be too close to the data to fully appreciate. People, school districts, and government entities may assume they’re offering data that complies with government-issued transparency mandates, and they may assume that that’s enough. But are they truly giving the people what they really care about in their everyday lives? Often not, I suspect.

There’s a standard for this already, to which I reference (and adhere to) often: the Government Accounting Standards Board’s (GASB) litmus test for the quality of data being shared. The six qualitative characteristics, as set forth in GASB’s Concepts Statement No. 1, Objectives of Financial Reporting are:

  • Relevant
  • Reliable
  • Understandable
  • Timely
  • Consistent
  • Comparable

Most of all, let’s make it simple. Let’s resolve—as an industry, as municipalities, as school districts, and as councils of government—to make it easy for elected officials and citizens alike to understand the terminology we use and the solutions we are trying to provide to achieve things like transparency and smart cities. 

An informed public is a powerful public. Let’s leave the buzzwords behind…and move our communities forward.

[To learn the one acceptable buzzword here at Munetrix, please click here.]

Education, Fiscal Health, Municipal

The Transparency Illusion

By Bob Kittle

The demand for government transparency is more fervent than ever. While, in the past, inquiring about the use of tax dollars required time, filling out forms or even a trip to City Hall, today the public expects almost instant gratification to their questions — or not even have to ask questions because they want to find it on their own with internet searches, even from their mobile device. More often than not, they are disappointed with the results they find.

The problem isn’t that local governments aren’t posting budgets and financial information online. It’s that they are doing so in a manner that pretty much renders them useless to anyone who doesn’t have a background in municipal finance, public administration or data science. When it comes to transparency, more isn’t always better, and dozens of 100-page PDF documents are not synonymous with the intent of Transparency.

People want to know what projects and programs their tax dollars are funding; answers to questions like where the money for those new signs came from, why potholes on their street aren’t fixed, or any other information that’s relevant to their home value, safety and/or quality of life in the neighborhood.

Citizens want timely, helpful data that they can understand. When local governments post loads of data ad nauseam, the public is left with the task of sorting through it and trying to understand what it all means and how it relates to their query. For many, the process isn’t just exasperating, it results in having less trust in their government. A telling bumper sticker I once saw said, “I love my country, but I don’t trust all its governments.” Touché.

This type of transparency is like wearing someone else’s prescription glasses; you might be able to see some blurred images but not the details that really matter.

Publishing reams of data isn’t transparency, It’s the illusion of transparency.

Understanding what information to share, when to share it and the level of transparency people expect:

  • helps local governments provide insightful and relevant information;
  • reduces the risk of publishing private information;
  • improves community public relations; and
  • encourages trust in the electorate and area stakeholders.

This consistency also provides stakeholders the ability to know exactly where information is, when it was put there and how to retrieve it. It should also stay in the same location for consistency purposes.

While someone should be tasked with managing and monitoring transparency within the organization, it doesn’t require a new hire or expansive workload. The use of performance management software (like the Munetrix dashboard), makes the process easy, efficient and relatively timeless and provides municipalities and school districts with the ability to share, monitor and understand the data they publish with little more than a click of a mouse.

We recommend being fully transparent, so you’ll never be accused of the “Illusion of Transparency” when it comes to accessing your open data and documents. 

Education, Municipal, News, Opinion

Cheers to a successful millage passage!

By: Bob Kittle

It was announced at the Detroit Regional Chamber’s Mackinac Policy Conference in May 2019 that a coalition of education advocates is aiming for a Wayne County millage to support after-school programs. If supported, the county-wide proposal would be on the Wayne County ballot in 2020. While this effort may be worthwhile, it is certain to be a challenge, first because it’s a county-wide vote, but also because gaining support for any millage proposal can be difficult – as almost any city or school district can attest. Having accurate and timely data can help build a strong case for millage requests and lessen the handwringing for anxious policymakers at the same time.

Munetrix understands the importance of data in community decision making. Increased demands for transparency make it clear that constituents want confidence that every penny is spent wisely. When current dollars aren’t enough to support operations or a new community initiative, a strong case can be made for additional funding by comparing how similar communities pay for equivalent services. You can also respond to naysayers with data reflecting that proposed millage rates aren’t unprecedented or out of line using relevant comparable analysis.

Citizens expect data to be accessible and will use it to better understand their community’s use of taxpayer funds. While preparing for your next city or school (or, in the case of Wayne County, after-school) millage, use data in your favor.  

Munetrix makes government data easy. If you need assistance with your next millage proposal, don’t hesitate to contact us.

1 2 3 4 5 6