School data tutorials

Educators today are expected to integrate the collection and analysis of student learning data into their ongoing instructional and organizational practice. Yet if you walked into almost any school in this country and asked how many teachers knew how to make a basic graph using spreadsheet software, you'd be lucky if a fourth of them raised their hands (and don't even bother asking the administrators!). So what can we do to help educators learn some basic technology skills that can help them track and monitor student learning progress over time?


CASTLE's School Data Tutorials web site was created to assist school districts and educational leadership preparation programs with the task of training K-12 educators to work with raw student and school data. The web site contains over 100 short Flash screencasts that walk educators through some Excel skills that are extremely helpful when working with classroom-, building-, or district-level data. Popular tutorials that are immediately useful to teachers and principals include

  • sorting
  • filtering
  • conditional formatting
  • pivot tables and charts
  • Most of the screencasts are only a minute or two long and can be watched a thousand times if necessary. This is extremely useful for educators who are not that tech-savvy and may not be able to keep up with the group during face-to-face training. The online availability also allows educators to return to the site later to review something if they forget what they learned previously.

    We have been getting tremendously positive feedback about this resource. Educators who previously saw no intersection of spreadsheets with their professional lives are contacting us, indignant that no one has ever showed them these skills previously. Comments like "I could have saved myself a lot of time" or "Now I have a way to do this easily" are extremely common. One of the reasons I think the tutorials are so well-received is because they're grounded in the important, real-life, data-driven decision-making needs of teachers and administrators (as opposed to the generic, context-less Excel training that occurs in many school systems).

    This summer we added a section to the site that walks educators through the steps of creating their own data collection templates. This section, which is not quite as polished as the rest of the site (e.g., I think you can hear my in-laws' computer's aquarium screensaver in the background!), contains examples for principals, teachers, and grade-level teams. In the coming months, we will upload additional examples of templates that are being used in schools across the country.

    The tutorials currently are being used in schools, districts, and university preparation programs across the nation. I encourage you to check out the site (maybe you'll learn something helpful!) and to spread the word about this resource. We created it to help build some capacity in school systems. Right now data analysis expertise resides primarily in central office research and assessment departments - we need more knowledge in our buildings and classrooms.

    More information is available at the web site if you'd like to know more about this resource or our critical partners. Any feedback or suggestions that you have are extremely welcome - simply comment on this post!

    Why the White House Correspondents’ Association dinner won’t feature a comedian in 2019

    It's the first time the association hasn't hired a comedian in 16 years.

    (Photo by Anna Webber/Getty Images for Vulture Festival)
    Culture & Religion
    • The 2018 WHCA ended in controversy after comedian Michelle Wolf made jokes some considered to be offensive.
    • The WHCA apologized for Wolf's jokes, though some journalists and many comedians backed the comedian and decried arguments in favor of limiting the types of speech permitted at the event.
    • Ron Chernow, who penned a bestselling biography of Alexander Hamilton, will speak at next year's dinner.
    Keep reading Show less

    How to split the USA into two countries: Red and Blue

    Progressive America would be half as big, but twice as populated as its conservative twin.

    Image: Dicken Schrader
    Strange Maps
    • America's two political tribes have consolidated into 'red' and 'blue' nations, with seemingly irreconcilable differences.
    • Perhaps the best way to stop the infighting is to go for a divorce and give the two nations a country each
    • Based on the UN's partition plan for Israel/Palestine, this proposal provides territorial contiguity and sea access to both 'red' and 'blue' America
    Keep reading Show less

    A new study says alcohol changes how the brain creates memories

    A study on flies may hold the key to future addiction treatments.

    Scott Barbour/Getty Images
    Mind & Brain
    • A new study suggests that drinking alcohol can affect how memories are stored away as good or bad.
    • This may have drastic implications for how addiction is caused and how people recall intoxication.
    • The findings may one day lead to a new form of treatment for those suffering from addiction.
    Keep reading Show less