Exam number generator
Greetings! We are exploring how to automatically generate and assign
exam numbers electronically, both in an effort to have them in advance
of finals and to make life easier for our records officer.
Have any of you done this, and if so, would you be willing to share?
Thanks in advance!
Dave Genzen
Cleveland-Marshall College of Law
_______________________________________________
You are currently subscribed to teknoids as: elmer@teknoids.net.
To unsubscribe send a blank email to teknoids-leave@ruckus.law.cornell.edu
--
See the web interface at http://ruckus.law.cornell.edu/mailman/listinfo/teknoids to get your list password, unsubscribe, and view your list settings.
RE: Exam number generator
What we have been doing is using a VB script I found online a number of years ago that runs in Excel. The VB Script is attached. On lines 2, 3 and 4 you change the values for your beginning number, ending number and the number of results you want. After that, you run the macro, and it gives you a list of random, unique numbers (it is important to note, the numbers are not in numerical order at this point). We then paste an alphabetical list of students (along with their email address) we want to assign numbers to. Then, if you want, sort by the anonymous number and, voila, you have random, unique number assignments.
We then, use MS Word, and an email mail merge to send the number to the students in a personalized email.
This works, is fairly easy, and doesn't take much time, so we go with it.
Jeff Whitcomb
Technology Services Manager
Cumberland School of Law - Samford University
205-726-4662
jmwhitco samford edu
P Think before you print
Why are computers so difficult? Because of errors like this:
Service X depends on service Y, which failed to start because of the following error: The operation completed successfully.
-----Original Message-----
From: teknoids-bounces@ruckus.law.cornell.edu [mailto:teknoids-bounces@ruckus.law.cornell.edu] On Behalf Of David Genzen
Sent: Tuesday, March 08, 2011 10:24 AM
To: teknoids@ruckus.law.cornell.edu
Subject: [teknoids] Exam number generator
Greetings! We are exploring how to automatically generate and assign exam numbers electronically, both in an effort to have them in advance of finals and to make life easier for our records officer.
Have any of you done this, and if so, would you be willing to share?
Thanks in advance!
Dave Genzen
Cleveland-Marshall College of Law
_______________________________________________
You are currently subscribed to teknoids as: jmwhitco@samford.edu.
To unsubscribe send a blank email to teknoids-leave@ruckus.law.cornell.edu
--
See the web interface at http://ruckus.law.cornell.edu/mailman/listinfo/teknoids to get your list password, unsubscribe, and view your list settings.
Exam number generator
seems like jeff and i had the same thought. Excel has a built in random
number generator, its pretty easy to use.
the command is :randbetween(min, max)
if you wanted a 5 digit random number you'd just put
=RANDBETWEEN(10000,99999)
that would be it. only thing you might want to look out for is duplicates.
Darrell
On Wed, Mar 9, 2011 at 8:22 AM, Whitcomb, Jeff <jmwhitco@samford.edu> wrote:
> What we have been doing is using a VB script I found online a number of
> years ago that runs in Excel. The VB Script is attached. On lines 2, 3 and
> 4 you change the values for your beginning number, ending number and the
> number of results you want. After that, you run the macro, and it gives you
> a list of random, unique numbers (it is important to note, the numbers are
> not in numerical order at this point). We then paste an alphabetical list
> of students (along with their email address) we want to assign numbers to.
> Then, if you want, sort by the anonymous number and, voila, you have
> random, unique number assignments.
>
> We then, use MS Word, and an email mail merge to send the number to the
> students in a personalized email.
>
> This works, is fairly easy, and doesn't take much time, so we go with it.
>
> Jeff Whitcomb
> Technology Services Manager
> Cumberland School of Law - Samford University
> 205-726-4662
> jmwhitco samford edu
>
> P Think before you print
>
> Why are computers so difficult? Because of errors like this:
>
> Service X depends on service Y, which failed to start because of the
> following error: The operation completed successfully.
>
>
> -----Original Message-----
> From: teknoids-bounces@ruckus.law.cornell.edu [mailto:
> teknoids-bounces@ruckus.law.cornell.edu] On Behalf Of David Genzen
> Sent: Tuesday, March 08, 2011 10:24 AM
> To: teknoids@ruckus.law.cornell.edu
> Subject: [teknoids] Exam number generator
>
> Greetings! We are exploring how to automatically generate and assign exam
> numbers electronically, both in an effort to have them in advance of finals
> and to make life easier for our records officer.
>
> Have any of you done this, and if so, would you be willing to share?
>
> Thanks in advance!
>
> Dave Genzen
> Cleveland-Marshall College of Law
> _______________________________________________
> You are currently subscribed to teknoids as: jmwhitco@samford.edu.
> To unsubscribe send a blank email to teknoids-leave@ruckus.law.cornell.edu
> --
> See the web interface at
> http://ruckus.law.cornell.edu/mailman/listinfo/teknoids to get your list
> password, unsubscribe, and view your list settings.
>
> _______________________________________________
> You are currently subscribed to teknoids as: darrell.miller@law.lsu.edu.
> To unsubscribe send a blank email to teknoids-leave@ruckus.law.cornell.edu
> --
> See the web interface at
> http://ruckus.law.cornell.edu/mailman/listinfo/teknoids to get your list
> password, unsubscribe, and view your list settings.
>
Exam number generator
On Wed, Mar 9, 2011 at 7:06 AM, Darrell Miller
<darrellrhodesmiller@gmail.com> wrote:
> that would be it. only thing you might want to look out for is duplicates.
Very easy to eliminate duplicate lines using a Linux command line:
sort filename.txt | uniq
The sort is necessary before passing the data to uniq because uniq
compares only adjacent lines.
Best regards,
Paul
_______________________________________________
You are currently subscribed to teknoids as: elmer@teknoids.net.
To unsubscribe send a blank email to teknoids-leave@ruckus.law.cornell.edu
--
See the web interface at http://ruckus.law.cornell.edu/mailman/listinfo/teknoids to get your list password, unsubscribe, and view your list settings.
Exam number generator
If you find something let me know!!!!!!!! We do it the old fashioned way.
Syd Beckman
Vice-President, Dean and Professor of Law
Lincoln Memorial University - Duncan School of Law
On Tue, Mar 8, 2011 at 11:24 AM, David Genzen
<david.genzen@law.csuohio.edu>wrote:
> Greetings! We are exploring how to automatically generate and assign exam
> numbers electronically, both in an effort to have them in advance of finals
> and to make life easier for our records officer.
>
> Have any of you done this, and if so, would you be willing to share?
>
> Thanks in advance!
>
> Dave Genzen
> Cleveland-Marshall College of Law
> _______________________________________________
> You are currently subscribed to teknoids as: sydbeckman@gmail.com.
> To unsubscribe send a blank email to teknoids-leave@ruckus.law.cornell.edu
> --
> See the web interface at
> http://ruckus.law.cornell.edu/mailman/listinfo/teknoids to get your list
> password, unsubscribe, and view your list settings.
>
Exam number generator
a simple solution would be to import your student email list into excel or a
spread sheet. Every spread sheet will have a way to generate random numbers
using a formula. so each email address will have a random number associated
with it. then use a mail merge to send those exam numbers to the students.
Darrell Miller
On Tue, Mar 8, 2011 at 5:46 PM, Sydney Beckman <sydbeckman@gmail.com> wrote:
> If you find something let me know!!!!!!!! We do it the old fashioned way.
>
> Syd Beckman
> Vice-President, Dean and Professor of Law
> Lincoln Memorial University - Duncan School of Law
>
> On Tue, Mar 8, 2011 at 11:24 AM, David Genzen <
> david.genzen@law.csuohio.edu> wrote:
>
>> Greetings! We are exploring how to automatically generate and assign exam
>> numbers electronically, both in an effort to have them in advance of finals
>> and to make life easier for our records officer.
>>
>> Have any of you done this, and if so, would you be willing to share?
>>
>> Thanks in advance!
>>
>> Dave Genzen
>> Cleveland-Marshall College of Law
>> _______________________________________________
>> You are currently subscribed to teknoids as: sydbeckman@gmail.com.
>>
>> To unsubscribe send a blank email to
>> teknoids-leave@ruckus.law.cornell.edu
>> --
>> See the web interface at
>> http://ruckus.law.cornell.edu/mailman/listinfo/teknoids to get your list
>> password, unsubscribe, and view your list settings.
>>
>
>
> _______________________________________________
> You are currently subscribed to teknoids as: darrell.miller@law.lsu.edu.
> To unsubscribe send a blank email to teknoids-leave@ruckus.law.cornell.edu
> --
> See the web interface at
> http://ruckus.law.cornell.edu/mailman/listinfo/teknoids to get your list
> password, unsubscribe, and view your list settings.
>
Exam number generator
Here's a random number generator..
http://www.random.org/integer-sets/
Take a look at random.org for other options - Tons of them. Claim to
be TRUELY random based on atmospheric noise.
Regards,
John
On Tue, Mar 8, 2011 at 5:46 PM, Sydney Beckman <sydbeckman@gmail.com> wrote:
> If you find something let me know!!!!!!!! We do it the old fashioned way.
>
> Syd Beckman
> Vice-President, Dean and Professor of Law
> Lincoln Memorial University - Duncan School of Law
>
> On Tue, Mar 8, 2011 at 11:24 AM, David Genzen <david.genzen@law.csuohio.edu>
> wrote:
>>
>> Greetings! We are exploring how to automatically generate and assign exam
>> numbers electronically, both in an effort to have them in advance of finals
>> and to make life easier for our records officer.
>>
>> Have any of you done this, and if so, would you be willing to share?
>>
>> Thanks in advance!
>>
>> Dave Genzen
>> Cleveland-Marshall College of Law
>> _______________________________________________
>> You are currently subscribed to teknoids as: sydbeckman@gmail.com.
>> To unsubscribe send a blank email to teknoids-leave@ruckus.law.cornell.edu
>> --
>> See the web interface at
>> http://ruckus.law.cornell.edu/mailman/listinfo/teknoids to get your list
>> password, unsubscribe, and view your list settings.
>
>
> _______________________________________________
> You are currently subscribed to teknoids as: jmayer@cali.org.
> To unsubscribe send a blank email to teknoids-leave@ruckus.law.cornell.edu
> --
> See the web interface at
> http://ruckus.law.cornell.edu/mailman/listinfo/teknoids to get your list
> password, unsubscribe, and view your list settings.
>
Exam number generator
Over the past two years we have written and extended an online exam
number assignment, exam scheduling, and exam rescheduling request
application. It is extremely specific to our environment, but could
potentially be adapted by others, if anyone is interested.
The system harvests class enrollment from our campus student information
system database (Banner), and loads it into a local database.
Within the local database, exam numbers are randomly assigned to each
student, specific to each class. (This was a faculty demand to continue
our prior practice. So instead of a student being #377 for all exams,
she might be #4 for Con Law, #38 for Civ Pro, and #2 for Torts. Each
class is thus numbered sequentially 1 to X (skipping 13)).
The registrar then defines the exam period for the semester, identifies
which courses actually have exams, and enters a tentative exam schedule.
He may then "view conflicts" in his tentative schedule, which identifies
how many students are enrolled in courses that are tentatively scheduled
for simultaneous exams, as well as how many students are tentatively
scheduled for exams that permit them, under our rules, to reschedule if
they wish.
The registrar may tweak the schedule until he feels he's minimized
conflicts as best as possible, and then he "finalizes" the schedule.
All of the above happens in the administrative web interface.
Once the schedule is finalized, students may log in to the student
interface and see their individualized exam schedule, and, if the rules
permit them to reschedule, request rescheduling.
Reschedule requests are written to the database and the registrar is
e-mailed the request and prompted to log in to the administrative
interface to approve (or deny) the request. Since the system enforces
the rules, he approves pretty much everything.
If the student has an exceptional request that would violate the rules
(e.g. wants to reschedule an exam for *before* the regularly scheduled
exam administration, or whatever), he or she may see the registrar, and
the registrar may grant an exception and administratively reschedule the
exam in the system for any date and time he wishes.
Meanwhile, the Dean of Students also uses the system to reschedule the
exams of students who qualify for accommodations under the ADA.
In the administrative interface, the registrar can see complete
schedules of both regularly scheduled and rescheduled exams for every
day in the exam period, can print class rosters, and can print "exam
number" sheets, which is what we use to actually give students their
exam numbers when they pick up their exams. When the exam is being
administered, the proctor gets students to line up in alpha order, and
each student picks up his or her exam number assignment sheet, the exam
itself, and exam envelope. The student then has to write the exam
number on the exam, the envelope, and (of course) enter it into Exam4.
We experimented with trying to provide the assigned number on the
first page of the actual exam, but that proved unworkable.
We thus have a database record of student exam number assignments and an
administrative interface to retrieve them, which means we don't have to
worry about losing (or inadvertently re-sorting!) individual spreadsheet
files.
The web interface logic is all written in classic ASP/VBScript (Yeah, I
know, I know).
The code is internally documented with comments (at least somewhat), but
is certainly, as I already mentioned, very specific to our environment:
it interfaces with our student information system (with, I think, custom
views), our LDAP directory and its unique structure, and, obviously
implements our particular rescheduling rules. With all those caveats,
if anyone is interested in learning more, just contact me off list.
- Nathan
Nathan D.M. Robertson
Director of Information Policy and Management
University of Maryland School of Law
501 West Fayette Street
Baltimore MD 21201-1768
vox: 410.706.1213
fax: 410.706.2372
nrobertson@law.umaryland.edu
_______________________________________________
You are currently subscribed to teknoids as: elmer@teknoids.net.
To unsubscribe send a blank email to teknoids-leave@ruckus.law.cornell.edu
--
See the web interface at http://ruckus.law.cornell.edu/mailman/listinfo/teknoids to get your list password, unsubscribe, and view your list settings.