Packing Slip 
item |
Random Student Selector Using Excel |
contact |
Bill Holmes (Chandler-Gilbert Community College) bill.holmes@cgcmail.maricopa.edu |
credits |
Bill Holmes Instructor at ASU (sorry, can't remember name -- years ago) |
college(s) |
Chandler-Gilbert Community College |
discipline(s) |
Faculty, all academic areas |
summary |
This simple Excel spreadsheet will let you randomly select students to call on in class. |
details |
Using the random function in Excel, this simple spreadsheet is adapted from one I saw used in a class I took at ASU. It was a class in collaborative teaching techniques, and it is a high tech version of the spinner that some teachers use on an overhead projector. This spreadsheet is one I use in my class. I have 4 students grouped with their desks pushed together facing one another. By typing a number in one cell, I can set it for any number of groups, and another cell lets you set how many students are around each table. By pushing the F9 key, new random numbers are selected and you call on the person indicated on the spreadsheet (after assigning seat numbers around each table at the beginning of class). Students never know when they will be called on and so are more likely to be prepared, and you can't be accused of "picking on me!" If you don't have a PC projector in your classroom, you could have a student verify the numbers from a computer monitor or even a laptop. Note! As a professional courtesy to the owner of this package, if you use some aspect of this package or have some thoughts about it, please share your feedback via the comments form below. |
supplements |
Excel Randomizer (spreadsheet) Note! As a professional courtesy to the owner of this package, if you use some aspect of this package or have some thoughts about it, please share your feedback below. |
shareback |
A "Shareback" cites the places on the web that mention, reference, or use this MLX package, and "shares" that information back here (more about shareback...) Sharebacks can be generated automatically by weblog tools. |
extra |
Last modified: Feb-21-2003 Date created: Feb-21-2003 Visitor count: 3984 Dublin Core Metadata record  This package is included in the Chandler-Gilbert Instructional Technology Packages special collection. |
Maricopa Learning eXchange
http://www.mcli.dist.maricopa.edu/mlx/slip.php?item=571
