It is common for final exams of a statistics course to include questions requiring the selection and application of statistical techniques to a given dataset. Due to COVID 19, this past semester final exams were held online. To reduce the likelihood of sharing of answers, it would be better if each student received a similar (same variables and structure) but unique (different values) dataset. Students received the exam questions and datasets (in XLSX format) simultaneously by email. Rather than create 61 (the class size) unique spreadsheets and send them to students individually, we create a single master spreadsheet which is sent to all and generates individualized data upon the entry of a unique identifying number, in this case a student ID number. All that is required are simple Excel functions. Following the successful application of this “master spreadsheet” last semester, we will use it for take home assignments in 2020-21.
View
PosterView
Video
