Skip to main content

Table Management Through Correct Cell Reference

With new classes starting this week, I've discovered a few flaws in my game style class management system. Particularly when students drop or add the class.

Overall the reference formulas are pretty complex. Only because of my familiarity with them, am I able to locate all the unique data points and how they impact the visible results. By keeping redundant points identical and pulling data from a central location, I am able to keep the whole system manageable. 

Data inside the same workbook is found through HLOOKUP and VLOOKUP formulas. For those tables to function best, the data should be sorted alphabetically. At other times, I needed data from a separate workbook where the lookup formulas do not function. In those instances I referenced the specific column using IMPORTRANGE.

The problem occurred when changing, adding or dropping a name thus moving the data to a new column. The IMPORTRANGE function continued to work, but now referenced the wrong column data. Fortunately, I had used a consistent naming system across all sheets and tables. This kept all the data in the same sequence. It was easy to work through each individual student data sheet, in sequence and adjust the target column.

Another feature that paid off well was the use of an absolute cell reference for all IMPORTRANGE functions. This meant that changing a single cell (the reference point) changed all the resulting values across the sheet.

Popular posts from this blog

Classcraft Interactive Notebook Page

Finished crafting interactive notebook pages for Classcraft, an engaging classroom management tool.

This fall I plan to add interactive notebooks to my classroom procedures. The goal is to provide students with something tangible to take home at the end of the semester. So that means creating or borrowing resources to guide students in developing their notebook.

Classcraft is a classroom management tool, an elaborate punishments and reward system designed like an epic role play game. Students create avatars and can upgrade pets and outfits based on experience and gold points earned. They can also lose points and suffer minor penalties. Everything is done in a fun, game like environment.

The computer lab is already divided into five or six stations, which lends itself easily to guilds or teams of students who work together in the game. I want students to develop their own backstory and choose their characters for the good of the group. I also need students to keep their login info some…

Exploring Science and Math through Music and Messes

If you have ever seen a music video by the music group OK Go, you know that they enjoy experimentation and quirky effects. Now all that energy is available for teachers in the classroom, with maybe slightly less mess.

In cooperation with Google and Morton Salt, they have produced a set of three STEM related lesson plans complete with tie-ins to their most popular videos. You can get your hands dirty in this wonderful playground at the OK Go Sandbox.

Lego Mindstorm Maze Runner

Students were tasked with writing a program for their robot to successfully navigate a preset maze. This used only directional command blocks (no sensors). The goal was to recognize sequencing, patterns and to become comfortable with testing and making modifications based on test results.