Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Mar 2001
    Posts
    114
    Thanks
    0
    Thanked 0 Times in 0 Posts

    catching a cheater (Office 2003)

    I set up an Excel spreadsheet as a test template for a high school computer class. Each student opened the original template and took the test, then saved their finished test in a common folder using their first name as a file name. Normally, I am able to trust this system, but today I am 99.99% certain that one student opened up the finished test of another person, then resaved it as their own.

    Is there some type of embeded information in the file structure that I could somehow open up and read to see if there would be definitive proof that one was copied from the other? (since I created the original file myself, looking at the file properties|file summary | advanced shows the same info for both.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: catching a cheater (Office 2003)

    Has the "Remove personal information from file properties on save" check box been ticked in the Security tab of Tools | Options...?
    If so, you can't see who edited the workbook.
    Otherwise, opening the workbook and saving it under another name will cause the username to appear in the Last Saved By property in the Statistics tab of File | Properties.
    You can also open the workbook in Word with the "Recover Text from Any File" option. You should see a list of users who edited the workbook near the end of the file.
    Warning: don't save the workbook from Word!
    But if the student simply copied the workbook of another student and renamed the copy, the Last Saved By property will still be that of the other student.
    Perhaps the network administrator can check the log files for the folder to see who manipulated the document.

  3. #3
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    2,826
    Thanks
    136
    Thanked 482 Times in 459 Posts

    Re: catching a cheater (Office 2003)

    So what you are saying is,
    copy and rename the workbook, then
    open the workbook and then save it.
    ..so that the Last Saved By is updated 'correctly'

    Then perhaps you'll need to use a utility like 'TouchPro' to backdate the file date/timestamp properties to cover yourself and..

    ..whoa. I was getting carried away there.

    Maybe it would be easier just to do the test.

    zeddy


    zeddy

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •