I'm sure it has been asked in the past, but I can't seem to find it or possible replies, but is there an easy way to find duplicate questions in a question bank?
I can think of easy in a couple of different ways and unfortunately, what you're asking to do doesn't satisfy the definition of easy in any of them.
The low-tech way is to open a question bank and read through the questions and responses and make sure there are no duplicates. This might work okay for small question banks but not for large ones.
Question banks cannot be exported directly, but you can create a quiz out of a question bank and then export the quiz. You can then open up the quiz, unzip it, and look through the contents. You may be able to manipulate them with some kind of technology to see which ones match up as duplicates. It's not as easy as it sounds though as you also need to make sure both the question and the responses are different or they're not truly duplicates. If you want more information about exporting a question bank, Stefanie Sanders wrote an explanation of exporting a question bank back in December 2015, Export individual question banks. Ken Black confirmed that you can't export them directly and provided additional information in April 2017, Download Question Banks into a Readable File Format.
A third possibility may be to leverage Canvas Data. It has information about the quiz questions and quiz question answers. You would need to compare the text of the question and all of the responses to make sure they are the same. Those tables have references to assessment questions, but that's not a table in there. Also, I'm not positive that all of the questions show up there or whether it's just those that are included in a quiz, so that may not work either.
The third one could work if you pulled the trick from the second one and put all of the questions from a bank into a quiz, but otherwise it's probably not reliable. You would have to wait a few days for it to show up in Canvas Data, so it's not an immediate solution. It also requires you to have access to Canvas Data, which most people do not.
The second solution requires programming skills that vast majority of people do not have. If you're one of those lucky few, you could look into it.
The first way is the only way widely available to anyone. It's easy in the sense that it's not technical, but I wouldn't consider it an efficient use of time.
If I was tasked with accomplishing this, I would choose them in reverse order, depending on how much time I had available. If it came down to the last one, I would probably tell the person to check their own banks.
There is one other possibility I can think of right now. If you have a fake user account (not the "Test Student"), you could create a quiz with all of the questions as Stefanie described in the second method. Then go in and take the quiz, being sure to answer all the questions. Go into the Quiz Statistics and generate the student analysis report. This will download it into Excel. Then you can transpose the data. After stripping the number from the front of every question, you can sort by the question text and look through for duplicates. Some of the things I mentioned there require some familiarity and expertise in Excel, but more people have that than who have the programming capability to work it out the second way.
Thank you James, you are right, not necessarily easy but possibly doable. Wish there were an easier way, because a couple of my banks have lots of questions.
Retrieving data ...