hermanntrude Posted April 3, 2009 Share Posted April 3, 2009 I have made a small excel spreadsheet which randomly generates a number between 1 and 15 (the number of students in one of my classes), then it looks up the name next to that number in the class list and displays it in large (200pt) text so the whole class can see it. I wrote a small macro and attached it to a button so that when I press the button it randomises a few times so names flicker in the display area and then stops on a particular name. The reason for this is like this: As an instructor, a useful method of divining exactly what students know is to ask questions in class. The reccomended method is to ask the question, wait, and then single someone out... that way everyone thinks about how to answer the question in case it's them who gets chosen. The trouble with that is that there is a certain amount of negative feeling involved in the selection process... particularly if the class thinks you picked someone "unfairly". Now, with the randomizer, I can't be blamed for the choices, and when someone gets a question they find hard, I'm the one who helps them out... in other words, my influences are positive more than negative. i'm very proud [/boast] Link to comment Share on other sites More sharing options...
CaptainPanic Posted April 7, 2009 Share Posted April 7, 2009 Sounds like a good idea! How did the students react when they saw it the first time, and what did other teachers say about it? But indeed, you will almost certainly avoid the reaction that "the teacher always picks me for the difficult questions"... And if a student says that you made an unfair randomizer (a cheating randomizer), you can happily invite the student to make a better one If I were a teacher, I'd probably ask you for a copy of it Link to comment Share on other sites More sharing options...
hermanntrude Posted April 7, 2009 Author Share Posted April 7, 2009 The students find it slightly amusing that i'm that much of a nerd. I'm not sure if they noticed the subtle psychological change in the room. It seems to me it works nicely. It's a good job i'm even more of a nerd than that, though: Just because I wanted to find out if I could, i decided to make my randomiser report every result to a frequency chart and then set it to run for a while to test the randomosity of it. It turned out that the first and last student in any list was being chosen half as many times due to the rounding function. I changed it to "INT" instead, which always rounds down, and it's better. I've also developed a function on another sheet in the same workbook, where thereare checkboxes next to each student's name so I can tell the randomiser who is and who isn't there so it won't choose absent people (that was a bit of a bodge... basically i told it to calculate a new name if it came up as "absent", and repeated the function twenty times, but it works). Now that I have the checkboxes, i'm thinking i could add a button which would report that day's attendance into another sheet which would record attendance. This is turning out to be difficult. Link to comment Share on other sites More sharing options...
Kaeroll Posted April 7, 2009 Share Posted April 7, 2009 You really are a nerd. I approve! Link to comment Share on other sites More sharing options...
YT2095 Posted April 7, 2009 Share Posted April 7, 2009 another good Aid to education is to get yourself a Personal 3-band Cell Phone blocker/Jammer. they`re quite affordable, and renders useless any mobile phone within a 15m radius, even a call in progress will be stopped within a couple of seconds the battery lasts a good 3.5 hours and it`ll run indefinitely on the mains Charger (plenty long enough for your average lesson). my Lab is a Cellphone Free Zone 1 Link to comment Share on other sites More sharing options...
insane_alien Posted April 7, 2009 Share Posted April 7, 2009 or you can make a giant tinfoil hat for the building Link to comment Share on other sites More sharing options...
CaptainPanic Posted April 7, 2009 Share Posted April 7, 2009 Good that you fixed your randomizer. You must always assume that one of the kids in the class is as big a nerd as you... and that this kid will therefore somehow statistically prove that your randomizer is cheating - better avoid that Link to comment Share on other sites More sharing options...
YT2095 Posted April 7, 2009 Share Posted April 7, 2009 a nice way around that is to use the numerical contents of the register that stores the Time as a seed value for the RND function. Link to comment Share on other sites More sharing options...
Lan(r)12 Posted April 7, 2009 Share Posted April 7, 2009 I HATE it when I get called on to answer chem questions...I get all nervous and I KNOW I'll mess up...you are an evil person, you teacher. But that is a cool idea. But then again...I think silly string is cool...so... Link to comment Share on other sites More sharing options...
hermanntrude Posted April 7, 2009 Author Share Posted April 7, 2009 i'm very nice about it. If you can't get it i'll help you out. I've managed to write a macro now which takes the attendance data and stores it in a table. It works beautifully. Link to comment Share on other sites More sharing options...
CharonY Posted April 8, 2009 Share Posted April 8, 2009 Hm. Interesting concept. I usually keep a DB in which I keep track who I have asked how often, but randomize it openly may be a nice trick. It may appear a bit like a quiz show then, but that might not be a bad thing. Link to comment Share on other sites More sharing options...
insane_alien Posted April 8, 2009 Share Posted April 8, 2009 Hm. Interesting concept. I usually keep a DB in which I keep track who I have asked how often, but randomize it openly may be a nice trick. It may appear a bit like a quiz show then, but that might not be a bad thing. you can have those mini mars bars as a prize too. amazing how far a bar of chocolate will encourage a kid to learn. even if that kid is a 21 year old university student (me). Link to comment Share on other sites More sharing options...
Kaeroll Posted April 8, 2009 Share Posted April 8, 2009 you can have those mini mars bars as a prize too. amazing how far a bar of chocolate will encourage a kid to learn. even if that kid is a 21 year old university student (me). I was taught the basics of radioactivity by having Dairy Milk thrown at my head. It worked! Link to comment Share on other sites More sharing options...
hermanntrude Posted April 8, 2009 Author Share Posted April 8, 2009 Hm. Interesting concept. I usually keep a DB in which I keep track who I have asked how often, but randomize it openly may be a nice trick. It may appear a bit like a quiz show then, but that might not be a bad thing. my early results really do seem to be promising. I am concerned, though that it might not work as a device that's there from the start. My students have been taught chemistry by me for the last year... they're used to my ways and tolerant of my nerd-dom. Perhaps if i start using it next year as soon as i meet the new students they might (a) take it for granted (b) not find it so amusing as my current students Link to comment Share on other sites More sharing options...
Lan(r)12 Posted April 8, 2009 Share Posted April 8, 2009 Trust me Mr. Hermanntrude...the chocolate bar thing WORKS. I'm 20, yet I would get up and do integration on the board for the promise of a 3 Musketeers bar...or a Reesee's...mmmmmm... We learn via chocolate...remember that! Link to comment Share on other sites More sharing options...
CharonY Posted April 8, 2009 Share Posted April 8, 2009 We have got the clicker system here, where you actually can poll the answers anonymously. I always wanted to try that out but apparently there are sometimes technical issues with that. Link to comment Share on other sites More sharing options...
A Childs Mind Posted April 8, 2009 Share Posted April 8, 2009 BRAVO i would love to be in wutever class you teach Link to comment Share on other sites More sharing options...
YT2095 Posted April 8, 2009 Share Posted April 8, 2009 I was taught the basics of radioactivity by having Dairy Milk thrown at my head. It worked! meh, it was blackboard erasers when I was a kid! Link to comment Share on other sites More sharing options...
A Childs Mind Posted April 8, 2009 Share Posted April 8, 2009 meh, it was blackboard erasers when I was a kid! lol Link to comment Share on other sites More sharing options...
iNow Posted April 8, 2009 Share Posted April 8, 2009 We have got the clicker system here, where you actually can poll the answers anonymously. I always wanted to try that out but apparently there are sometimes technical issues with that. We use those in our corporate training events all of the time, and without issue. They're great once you learn how to use 'em properly, and allow for real feedback anonymously, and also to see which content areas are being missed by the students (and without them feeling "put on the spot"). It's called an Audience Response System, btw. Link to comment Share on other sites More sharing options...
wade.daniel.w Posted April 8, 2009 Share Posted April 8, 2009 good idea! I think it would benefit the class better if you could set it up on an alternating systematic process rather than random (this will in fact ensure each child is eventually selected in an even distribution) Link to comment Share on other sites More sharing options...
hermanntrude Posted April 8, 2009 Author Share Posted April 8, 2009 systematic would be predictable. The whole point is to make sure the students dont know who's next so they attempts to think about the answer in case they're selected. and random DOES ensure they're selected evenly. the program has a built-in plotter and after 30 or 40 questions a class of 15 gets selected fairly evenly Merged post follows: Consecutive posts mergedone of our instructors is piloting clickers now. Ive already told them i want them Link to comment Share on other sites More sharing options...
CharonY Posted April 9, 2009 Share Posted April 9, 2009 It's called an Audience Response System, btw. Bah, I call it bloody expensive useless system that makes student complain half the lecture that their device did not register properly . Though to be honest last time I heard that the system is supposed to work properly now. Thinking about hurling stuff. I was wondering how well it would work to throw chocolate bars at students. The signals might be ambiguous, but they pack a better punch than chalk. Link to comment Share on other sites More sharing options...
iNow Posted April 9, 2009 Share Posted April 9, 2009 I knew I was doing something wrong. I've been hurling staplers this whole time. Granted, my student base likely tends to be older than yours. We don't use our ARS for grading purposes, just for status/retention checks. If a large number of folks are getting specific questions wrong, we know our crew failed to properly address that topic and we go back until everyone is up to speed and ready to move forward into the next module. Link to comment Share on other sites More sharing options...
MM6 Posted April 16, 2009 Share Posted April 16, 2009 There are a bunch of randomizers online, like random.org. Just enter the names of the students and it randomizes them. I use it from time to time when forming lab/activity groups. But I call on who I want when I want. I'm in charge and they will bow to me! lol Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now