All Of Your Data, In One Place
What sorts of data do you have about your students? How do you get it? Do you have a tool that helps?
Probably for more than 100 years, teachers have been taking attendance by hand as the students walk in the door. They keep a handwritten homework log. They keep a grade book on paper, in excel, or with an online service. Is there one place you can go to find out all of the information you have on a student? Can you look at the student’s grades, homework completion, attendance, class participation, and behavior in one place? If such a tool exists, I’d love to be in possession of it. For most teachers all of this data exists in 20 different places, and sometimes in places where they don’t even have access to it!
Tons of people are trying to keep track of student data:
There are a plethora of different software companies that sell enterprise solutions for looking at students’ standardized test scores from year to year, looking at individual skills and a student’s strengths/weaknesses. This data is of critical importance (though I wish it wasn’t so reliant on standardized tests).
There are school-wide management programs that keep attendance, keep track of grades and parent contact information. They print out report cards to mail to parents and incident reports for bad behavior.
There are digital grade books for your classroom where you input the grades and all of the calculations are done for you. Teachers no longer have to take out their calculator at the end of the quarter to work out each kid’s grades. Students can often access their grades as well so then keep up with how well they are doing.
Why aren’t all of these things in the same place? Why can’t I find out all of the information on a particular student? I’m ready for the data to be integrated, available, and easy to work with.
I’m not an experienced programmer, but I’ve just started development on a solution. Next year, there’ll be bar code scanner at the door; students will scan in when they enter and leave class and when they go to the bathroom. Attendance will be automatic. I’ll have the time in the beginning of the period to set up for class. Bathroom frequency will be recorded, and students will be denied if they go every day…automatically. I’ll keep a homework log using the same digital system. Students who are missing assignments will receive automated text messages reminding them to get it done. And I will be able to sit down at my desk at the end of the day, and look at patterns and trends….
A lot of kids from Physics A were absent today…
John Smith just missed 3 homework assignments….
Dave has been going to the bathroom every day for a week….
The program will report on these issues, and automatically respond in pre-designated ways. And I’ll get a complete view of all of the data I take on each student.
I’m excited to remove the secretarial work from my job, and focus on teaching and learning. Sound interesting? What features might you include? Let me know in the comments.
May 4, 2010 No Comments
Tools to Differentiate Instruction: Differentiated Study Sessions
This is part II of my little mini-series on differentiating instruction in mixed ability classrooms. For this post, I want to discuss another little trick I’ve developed for using review time effectively in classrooms with many different kinds of kids. Some kids are probably in need of no review. They’ve sat through lectures, completed activities and homework assignments, and it all soaked in. Other students, might need some re-teaching or reinforcement of a few key topics. Other students may require intensive and comprehensive review work so they can solidify most of the content to be tested. How can we satisfy all of these different learners in one room all at the same time?
This was a problem that I’ve been meaning to conquer for some time, and I think I’ve pretty much done it. My school has a rolling laptop cart with a dozen computers in it. I break the students into pairs, hopefully in couples of similar ability / needs. Each pair gets a computer and I have them plug in their headphones (I have a few pairs to loan, but most kids have ipods in their bags).
Each pair of students is given practice problems / conceptual questions and the answers / explanations are all available to them on mrkadin.com. Students can work on the type of problem they struggle with the most. If they can’t seem to figure out the projectile motion problems, they can try samples and watch videos explaining the trigonometry and kinematics.
If they are struggling to understand the way acceleration and velocity chance when an object is thrown up in the air…
I’ve never seen the students more engaged. I’ve blurred their faces to protect the students’ privacy. They are all working, either watching the screens or completing math problems.
Making the videos was really easy. First, you make power point slides that serve as the visuals for the video. Then you add an audio narration. See this post for tips on doing that. Then, I uploaded the slides to authorstream.com, a really great tool that converts narrated power point slides into embeddable flash videos. This makes the videos watchable by anyone with a web browser; no power point needed. Word up.
January 27, 2010 No Comments
Tools to Differentiate Instruction: Differentiated Project Design
The importance of differentiation in a mixed ability classroom cannot be understated. Here’s some good readings on the topic. Not to provide advanced material for the quicker students to devour as well the time, energy, and practice for the slower students is to bias your teaching towards one group or the other. If you want to reach each kid, and keep both sides of the performance spectrum engaged, you have to have material that is engaging for each group.
I’ve added a few new tools to my differentiation tool-belt lately. I’ve been a big fan of adding tiers to the grading rubric for my projects. Tier one is the easiest to complete. To pass students need only show competency with the most basic skills. To earn a 95 (tier 2), students need to show they are making higher level connections, and conveying that understanding. And to earn higher than a 95%, if they reallllly want that extra “+” on that A, then they have to take on a very challenging extra piece. For example, my students recently completed a roller coaster design project. To earn a 65 (the lowest passing score at my school), the students had to design the roller coaster itself, and answer some basic questions along the way. To earn up to a 95, the students had to complete a proposal, where they explain how they designed it and provide evidence as to how it is the best design. And then, to get a 100, they had to do an entirely different design, of a “Turkish Twist” style ride, where the cylindrical ride spins, you get pinned to the wall, and the floor drops out. Completing this extra design involved calculus or good graphing calculator skills; it wasn’t for the feint of heart.
Making passing the project about showing the basic skills helped students who struggle with organizing large multi-faceted assignments from being too afraid to actually do it. Making an A worth more than the basic skills helped the middle of the road students to do some advanced thinking and to demonstrate it. Making the 100 a very difficult problem helped keep the super-fast students working for a long time, while I was able to provide assistance to the struggling students who needed it most.
Here’s a link to the project, for which I use mail merging to make the project’s numbers individualized for each student.
January 24, 2010 1 Comment
Teaching 2.0: Using Technology to Boost Student Engagement and Achievement
I recently was invited to speak at my school’s “Collaborative Inquiry Showcase” where teams of teachers show off some of their data-supported best practices / methods.
The talk was very successful. Several teachers have spoken to me since, having been inspired by some of the tech resources/tools I discussed. You can find the slides from the talk here. You’ll find that the videos won’t work (they don’t get passed with the power point file) and that some names/pictures have been removed to protect my co-workers’ and students’ privacy. If a security message comes up about macros in the power point, just allow them, I give you my personal assurance that the slides are malware free.
The most interesting results that came from my work are related to targeted data-driven teaching. A few days before a major unit test, using the clickers, I was able to identify a set of 21 students who were struggling and in need of major assistance before the exam. During the course of few days preceding the test, I found time to pull aside 10 of the 21 students outside of class and to tell them I’m worried about their pre-test scores and to suggest to them some places where they could receive extra support (my after school help sessions, mrkadin.com, etc). Because of time restrictions and so I could have a control group, 11 students did not get this “intervention.” Students who were pulled aside scored 31% higher on the final test on average than their pre-test scores vs. the class average of 15%. The average increase for students who didn’t receive an “intervention” was 23%. This goes to show the power of dedicating my time to the students who I have identified as needing it most.
Across the business world and in other spheres, using data to drive decision making is the obvious strategy. Seeing the current state of things, and responding to that state, makes clear sense. It’s outrageous how many teachers are teaching the same lessons from 20 years ago, to an entirely different brand of students, with an entirely different set of needs. Using the data about how my students were doing allowed to me to respond to the current state of my class; I was able speak to the students who needed it most. And that simple human interaction and expression of worry helped those students to improve their scores by higher than any other group. Also, when selecting the students who I had time to speak to, I tried to speak to more students of color and more male students in order to address the clear achievement gap. Below you can see how the gap shrank from pre to post assessment.
We need this type of data in every classroom, and at the school and district level. Student performance on pre-tests and post-test, achievement gaps, attendance and behavior data, and we need time set aside for teachers to analyze it. While state tests provide some insight (though culturally biased) into how our students are doing, there is an opportunity to track our students’ performance at a much more fine-grained timescale. I consider the development of these data-driven systems and practices more important than most other educational reform efforts. And there’s a lot of money to be made in doing it right…
January 22, 2010 No Comments
Mail Merge your Grading
I’ve written here about how you can use Microsoft Word’s mail merge feature to create individualized assignments for your students. So when my students work on projects, they each get their own version of the problems, each with its own semi-randomly generated numbers. This helps to avoid cheating and helps to promote true collaboration between the students.
Today I turned that Idea around and streamlined the grading/commenting process on a recent student assignment. Instead of writing tons of notes on each student’s packet which they won’t be able to read because the margins are to small, and instead of spending 10 minutes per student with my calculator out doing the arithmetic for a complicated rubric, I created a giant grid in excel.

All of the students’ scores on each problem in the project packet were entered and then merged into the final rubric with a section for notes that I typed out at the end.

For me, this was great for 3 reasons. 1) Students can better understand my feedback because it is clear and typed. 2) It saved me a lot of time since I didn’t have to make 70 individual documents for the rubric. And 3) I got all of the grading data in one place. I noticed that a lot of students struggled with one aspect with the third problem in this assignment, and I never would have had any chance of noticing without having all of the data in excel!
November 22, 2009 No Comments
Doing More than Polling with Student Cell Phones
I’ve written about what can be done with the kids’ cell phones here. I was turned on to this site by my school’s technology integration specialist.
www.wiffiti.com (a terrible name that combines wifi and graffiti…i think) is a website that allows anyone to send a text message with some text to their number and have it displayed on the screen. Our class is studying projectile motion, so I had students text in examples from their experience outside of the class (outside hobbies, sports etc). Their examples were visualized in real time as the students text’ed them in. Here’s the results:
I intend to incorporate the students’ interests as they’ve texted them in into examples I use in class. This will help the students buy into the new topic.
November 15, 2009 No Comments
How to Continue Learning, Even When You’re Out
I’m out sick today, but I could somehow sense the illness coming on yesterday.
Most days that the little angels are being looked after by a sub are a complete waste. Every teacher knows it. The sub can’t teach your content, and having the kids work independently under someone else’s watch rarely yields good results.
I, however, have had a large amount of success bringing myself to the classroom even when I’m not physically there through the sound of my voice and some other tools.
The first tool that I use is my LiveScribe Pulse Smartpen which I’ve blogged about before. Essentially this pen creates videos of me doing practice problems for my physics and math classes. I usually use it for showing example problems to study from before tests on www.mrkadin.com.
I also recorded narration to a power point presentation. This processes is explained here. It is fairly simple. You just need the time to sit down and record it on the fly. I sent links to the subtitutes and copies of the power points and they simply showed them in class.
You can take a quick listen to the presentation by downloading it here. Note that the filesize is pretty large (>30MB) with all of the recorded sounds.
In my experience, the students watch diligently when I use these techniques. It’s not interactive; the kids can’t ask me questions. But, it doesn’t keep them a lot more engaged than 10 dittos to finish by the end of the period.
Reports from the substitutes are just now coming in by email. The classes apparently “went pretty well” and “everyone was enraptured by the video.” Ever had your kids enraptured with a substitute?
October 27, 2009 1 Comment
Using DropBox to Keep Your Docs All Sync’d Up
I like the idea of keeping all of my documents up in the internet could and getting at them from wherever I am. Dropbox is the only solution I’ve seen that makes that possible. Google docs is almost there, but doesn’t include all of the features I want to see yet. Essentially what dropbox does is it keeps your documents in sync across multiple computers. Whenever I save a word document at home, it is instantly uploaded (without clicking a thing) to the dropbox servers, and then pushed to my computer at work. All of my documents at home, therefore, are the same as my documents at school (with about a 2 second lag time).

Ever have to drive home quickly because you forgot to email yourself something? Not me, all the documents on all of my computers are the same. Ever forget to print something out but not have it on the computer in the classroom? Even if you only have one computer, all of your documents are stored on the dropbox website and you can download them on any computer.
This would be good for any business, but there are a few features that make it totally great. First of all, all the files are transferred over SSL (nerd speak for a secure connection) which means that if you want to get a movie file or an .exe through your school’s restricting BS network (deep breaths Kadin…deep breaths), you are all good. Even nicer, inside your dropbox folder, there is a separate sub-folder called “Public.” You can get a url (a link) to any file you place in this directory.
You can use this link when you send documents to students. Rather than sending attachments in emails, the students can simply click the link. This is really helpful for class blogs that don’t have a space for uploading files. The link that you get points towards the actual file on your computer as well, not a temporary copy of the file. Thus, if you post a power point on your class blog (like I do, blog.mrkadin.com) and then later make a change to one of the slides on your computer, the students will get the most up to date version of the presentation when they click the link later on. Booyah.
Seriously, this is an amazingly powerful tool and it works for PC/Mac and….Linux! The cost: Free.99
October 19, 2009 1 Comment
Using SMS for Collecting Data
A website I recently encountered, text the mob, allows you to set up instant polls (much like the clickers I’ve blogged about here, and here). Students text their answers to a number given to you by the website, and you can watch a graph of student responses populate in real time. Pretty neat, and much less expensive than a set of clickers for your class. It is certainly not as feature-rich though.
Most schools don’t let the students use their cell phones in school. But I feel like within your own classroom (as many teachers do with ipods) you can have your students take out their phones, turn them on, send the text, and then turn them off. The whole thing would be quick, and would a minor disruption to the rules.
October 17, 2009 2 Comments
Using Microsoft Word’s Mail Merge For Assignments
The ‘Mail Merge’ feature in Microsoft Word is designed to help people who are sending out massive mailings to individualize each letter. For example, if you are sending out a letter to 250 customers, instead of saying “dear valued customer” as the opening, you can have 250 documents generated with “dear mr. smith” and “dear mr. jackson” and “dear ms. arnold” etc. It is an incredibly powerful tool for administrative tasks, but more importantly, it can be used successfully in your classroom. Here’s a short video explaining how to do it in excel 2007.
How is that useful in the classroom? You can create multiple versions of the same assignment/project and use the mail merge to create individual assignments for each student. For example, I recently completed a CSI project with my students where they were asked to use the physics topics we’ve been studying to solve a car accident mystery.
Each student received a packet with the crime scene information. I used excel to randomly generate 80 different versions of the problem (check out this resource for using random numbers in excel). The kids, of course, were amazed, and accused me (though I don’t think this is really an accusation) of being one of the biggest nerds alive. We nerds are taking ownership of that term. What’s nice is that with Excel, I kept the random numbers and calculated all of the individual answers using excel formulas. Each student was assigned a specific packet number (see image above) and I could use this number to look up their answers in Excel to check them when they were done.
Anyway, why the hell would anybody go through all of this trouble!? Well, I’ve found there are a few reasons why this works for me. First of all, showing students that you care about each one of them individually (even though I just used random numbers) always gets them to care more about the project. Secondly, since each student has their own problem with their own answers, it forces them to ask me questions in a more general way, and to think things out more. For example, a student can’t ask “what’s the convertible’s final velocity?” because I don’t know the answer. Instead they have to say, “I’m having trouble finding out what the convertible’s final velocity is. How could I start?” Which is a much more productive help request for the students to learn to solve problems on their own. The most important advantage of doing this mail merge individualization is that it prevents cheating. When I assign a big project like this, if all of the students have the same numbers, than anyone could just copy off of anyone else. Thus, it would be difficult to allow the students to work together. In this case, the students were encouraged to collaborate because help has to actually be help and not just copying.
I’d note that this isn’t specific to science and math, since excel can work with text instead of numbers. In fact, in this most recent CSI project there was a line about whether or not it was raining the night of the accident which was different for different students.
Try it out, you might find it helpful and the students will appreciate it. Here’s some additional resources on mail merges, and the actual CSI project that I assign with names changed because they are teachers from my school.
CRIME SCENE INVESTIGATION WORD DOC You can see what the project looks like with the mail merge fields in it. The packet is accompanied by a separate packet which scaffolds the students through a solution process.
Formatting Numbers – Word can sometimes act kind of funky when merging numbers and it can give you like pi*10^7 decimals when you want 1. This will help you to format the numbers after merging.
October 17, 2009 2 Comments



