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!

    LinkedIn meets Tinder in this mindful networking app

    Swipe right to make the connections that could change your career.

    Getty Images
    Sponsored
    Swipe right. Match. Meet over coffee or set up a call.

    No, we aren't talking about Tinder. Introducing Shapr, a free app that helps people with synergistic professional goals and skill sets easily meet and collaborate.

    Keep reading Show less

    4 reasons Martin Luther King, Jr. fought for universal basic income

    In his final years, Martin Luther King, Jr. become increasingly focused on the problem of poverty in America.

    (Photo by J. Wilds/Keystone/Getty Images)
    Politics & Current Affairs
    • Despite being widely known for his leadership role in the American civil rights movement, Martin Luther King, Jr. also played a central role in organizing the Poor People's Campaign of 1968.
    • The campaign was one of the first to demand a guaranteed income for all poor families in America.
    • Today, the idea of a universal basic income is increasingly popular, and King's arguments in support of the policy still make a good case some 50 years later.
    Keep reading Show less

    Why avoiding logical fallacies is an everyday superpower

    10 of the most sandbagging, red-herring, and effective logical fallacies.

    Photo credit: Miguel Henriques on Unsplash
    Personal Growth
    • Many an otherwise-worthwhile argument has been derailed by logical fallacies.
    • Sometimes these fallacies are deliberate tricks, and sometimes just bad reasoning.
    • Avoiding these traps makes disgreeing so much better.
    Keep reading Show less

    Why I wear my life on my skin

    For Damien Echols, tattoos are part of his existential armor.

    Videos
    • In prison Damien Echols was known by his number SK931, not his name, and had his hair sheared off. Stripped of his identity, the only thing he had left was his skin.
    • This is why he began tattooing things that are meaningful to him — to carry a "suit of armor" made up the images of the people and objects that have significance to him, from his friends to talismans.
    • Echols believes that all places are imbued with divinity: "If you interact with New York City as if there's an intelligence behind... then it will behave towards you the same way."
    Keep reading Show less