Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming,microsoft.public.excel.misc
|
|||
|
|||
User authentication/protection
I'm a professor and use Excel extensively in my classes. I need to be
able to assign Excel projects to my students and have some increased assurance that the students have submitted their own work. I've tried my hand at VBA programming and also simply used track changes. None of these solutions (even the track changes) worked reliably across both mac and pc platforms. I would like some advice about whether what I need from Excel is even possible. I Here's what I need and what I think would work: 1. I'd like to prevent a student from getting someone else's solution, opening it up and making some changes, and then submitting it as his or her own. Here's what might work: something to generate individual Excel file templates for them to do their work on that are encoded with a unique key for each student that can't be removed and that can be easily checked. This will make sure that the students don't simply email their work to each other, make changes on the file, and submit it as their own. I've programmed something like this in VBA, with a VBA checker, but after a lot of time programming, it didn't port to the mac environment. 2. I'd like to prevent a student from opening up his (presumably uniquely keyed) template next to someone else's and cutting and pasting the solution into his template. I don't know what would work for this. 3. I don't want it easily defeated. Honestly, if it is hard to defeat, then someone smart enough to defeat it will be plenty smart enough to do the work instead, and would find the work easier! 4. This needs to work on mac and PC versions, and be backward compatible with at least 2003. I understand I won't ever be able to prevent students from opening up another spreadsheet and manually copying the formulas. That's fine. Note: I suppose I could have not only unique identifiers but also unique assignments. That would make it pretty hard to create and grade, though, unless the assignments only varied trivially from student to student, so I'd rather not go with unique assignments. Has anyone seen anything like this, or has an idea that it may or may not be possible to do it? Thanks! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
User authentication/protection | Excel Discussion (Misc queries) | |||
User form- protection and password. | Excel Programming | |||
VBA Macro With User Protection Settings | Excel Programming | |||
Protection password iin VBA, how to avoid user seeing it? | Excel Discussion (Misc queries) | |||
http post from excel - user authentication from excel to web | Excel Programming |