Sunday, April 27, 2014

Elementary Student Placement Calculated with Google Sheets



Right around now, elementary schools everywhere are beginning to discuss student placement for next year. It can be a time consuming process, with lots of meetings loaded with multi-colored index cards and post it notes. In an effort to make the process easier last year, I created a Google Sheet to help teachers visualize balanced classrooms. This year I improved the system based on lessons learned.


The sheet is shared with teachers after student demographic information is added to the "data" tab.  Teachers complete the sheet with academic and anecdotal information. Then, teachers organize an initial placement of their class. Because of Google’s Sheet collaborative capabilities, this is all done before the first meeting.


When the grade level teachers do meet, they already have a starting place because of the initial placement. The “Dashboard” sheet provides a quantitative look at how the classes are balanced by automatically calculating all of the information, including gender, academics and behavior. Students are moved from one class to another on the "Data" sheet to rebalance the numbers.


The "Class Roster" sheet allows the placement team to see the classes by name.  It’s possible to customize the data shown in each column by using the drop down menus on the right side of the roster.


I’ve included directions for the administrators who are setting up the sheet and for the teachers who are placing their students. Last year we were able to reclaim one whole day from the process. I hope others find this useful as well. Please let me know if you use it and if you have any ideas to make it better.

*All data used in the example is fictional for demo purposes.

Wednesday, April 23, 2014

Building an Elementary Maker Space

My colleague Peter McKenna started a Maker Space in his elementary school though our district’s unique and wonderful Innovation Grant process. His successes inspired a local movement to build spaces in each of our elementary schools. I set out to build a Space in my elementary school about three months ago and it’s been an interesting ride. The best part has been watching the excitement and curiosity of students in and around the space. I’m far from being an expert (did I mention that it’s been three months?) but I’ll share what I’ve done with the hopes that it could be helpful. This post is going to focus on the physical space.


The Physical Space

Very few actually have a choice about their space. Basically, you work with what you have. You actually don’t even need a space. +Gary Stager has talked about using large storage bins to organize tools so that the maker space could go to the classroom instead of the classroom coming to the space.  For me, I was able to adapt a computer lab that is also a music room two days out of every six. I moved the computers to the perimeter of half the room and was able to find two large wooden tables to be workbenches in the center.

I was lucky to get discarded classroom furniture from Mr. Mike the custodian, including a number of shelving units.The room also has decent cabinets and a sink (big bonus.)  

I’ve scrounged around for as much storage as possible but I’m already running out of places to put things.  Work space is also tight. The tables in the center are great, but some unused countertop would be nice. My big takeaways: get as much storage and counter space as you can.

The Maker Library

I’ve got a growing library to inspire teachers and students alike.  Some books, like the Make Component Encyclopedia and Make: Electronics are used during sessions. This is placed near the soldering station to identify components. Others are meant as idea references. I was able to get my hands on an old Make magazine collection and have subscribed for future issues. So far I’ve picked up the following books:


The Tools

As you can tell by the library, I decided to lean towards an electronics/robotics space. I invested in several Make:it - Soldering Starter Kits and a bunch of breadboards and multimeters. Radio Shack had a killer deal on Panavise Circuit Board vises so I was able to get two of those. I have a variety of standard tools, hammers, screwdrivers, pliers, power drill and bits. I also have a number of clamps, measuring tapes, combination squares, and a vise. The most intense piece of equipment in my shop is a MakerBot Replicator 5th Generation 3D Printer. It’s new and I don’t have a lot of experience with it, but I’m excited to start printing robot chassis!

What is Going On Right Now

My maker club has several projects in the works.  Students are designing a laptop cart to house the refurbished Linux MacBooks. They are un-making a broken laser printer and working on their soldering skills by desoldering components from it’s salvaged circuit boards. In between projects, students are creating some Paper Craft. It's been a whirlwind three months made possible by supportive parents and amazing kids. I’m looking forward to blogging more about these projects in the future. 

If you're interested in elementary school Maker Spaces, come and join our School Maker Space community!