Tag: data

Peeking Behind the Curtain

Pay no attention to that man behind the curtain!  Most of us have seen the movie “The Wizard of Oz.”  The mighty Oz is a fearful sight until Toto pulls back the curtain to reveal an ordinary man pulling levers and talking into a microphone. The lesson is that sometimes the awesome and magical turn out to be an

Read More

Size Matters

In the course of my career I have occasionally heard some unsavory “us versus them” talk. Teachers versus non teachers Certificated versus classified Management versus non-management School versus district Parents versus school administration Some discussions of the Local Control Funding Formula (LCFF) resort to this rhetoric, most notably the “school versus district” polarity.  I have previously mentioned the

Read More

Speed versus Quality

Bob came to see me.  “When the examiners come just say Plan, Do, Check, Act.”  “Um, What?”  “Oh and Alignment and Implementation.  That’s key.”  I rolled my eyes only after he left my office.  The Baldridge examiners were coming and I had a script to follow, apparently. Thanks Cavegirl for the book recommendation Why Business

Read More

Excel Solver for Expense Transfers

Thank you Pronger for your post about the Excel solver function.  Follow this link to view his explanation and instructions. The solver function is especially useful if you deal with a multitude of funding sources such as state and local grants, federal awards and bond funds.  Each restricted funding source has very particular spending rules and most have

Read More

Schrödinger’s Excel

Or, how to be deadly and awesome at the same time Is Excel good or bad?  It is both.  Are you good at Excel or bad at it?  Probably both. Excel is extraordinary.  In the wrong hands it also can be a disaster,  Excel is just a tool, like a chisel.  It is inspiring in the hands of a skilled carpenter and murderous in

Read More

Zombie PowerPoint

or, Why PowerPoint Cannot Die The YouTube video Death by PowerPoint is really, well, to the point.  Yet, despite obvious abuses, PowerPoint is here to stay. Powerpoint is the perfect vehicle for bulleted and numbered lists. We are addicted to lists.  What do you think most people will click on: Study shows correlation between polyphenols and health, or

Read More

Budget Advisory Committees are Hard

When the Budget Advisory Committee was approaching my boss and I would look at each other and groan in unison “Ugh BAC!”  Why? It was not that we didn’t want to talk budget with the community.  Hey, we’ll talk your ear off with all sorts of budget geekiness if you let us.  It is because a BAC

Read More

When School Districts Borrow

This an outstanding guide to school district debt financing by Orrick, Herrington & Sutcliffe, LLP.  While the guide references California law, it is useful in understanding public school finance in general. School district administrators in California function in a complex financial universe that increasingly requires familiarity with and use of sophisticated tax-exempt public finance techniques to finance

Read More

We Don’t Need No %@# Standards?*

Imagine comparing two school districts’ test scores, where each district uses different tests.  That would be meaningless, right? Yet, this situation exists on the business side of things. Legislation will require a calculation, but the implementation is unclear.  Subsequent guidelines and regulations (if any) sometimes just cite the statute verbatim. For example, prior to the new funding formula, conversion

Read More

Eleven Important Rules for Reporting

When you are asked to report results internally or externally, there are several rules of thumb that, if followed, will usually make life a lot easier for you.  Otherwise, you may overshare, share wrong data, or actually not answer the real question being asked.  This is especially important when dealing with reporters and public information requests.

Read More