Thursday, March 31, 2016

Quick and dirty anti plagiarism tool

Hi all
For some time now, I was looking for a way to detect plagiarism in excel files.
Today I realized that in most cases, students that needs to submit an excel assignment (or for that matter, any other assignment) will be using a file already submitted by submitted by someone else in their group which they modify to some extent.
The students can only modify the file content, but they cannot modify are at least will not modify the file's creation date.
Thats the idea lying behind this "antiplagirism" tool.


1. grab the excel file from here
2. put it in the folder where the submitted files are located
3. run the macro by pressing CTRL+r
4. Sort the list of file that was created by the creation date (Column B)
5. Find the files with the same creation time

Do whatever it is you do.....

You can look at a demonstration here.