Excel Quiz
How to Create an Interactive Quiz in Excel
http://college.cengage.com/accounting/resources/instructors/air/fall_2006...
Creating Interactive Quizzes in Excel
J.A. (Jim) Connell University of Montevallo Michael E. Stephens College of Business Station 6551 Montevallo, AL 35115 Elizabeth Mulig USF St. Petersburg 140 Seventh Avenue South St. Petersburg Florida 33701-5016 727-553-4154 mulig@stpt.usf.edu
Introduction Have you ever received a spreadsheet file that asked you questions and then magically told you whether your answers were correct? They can be more than e-mail pastimes. Once you understand how those spreadsheet files list questions and check your answers, you can create spreadsheet files that ask your students accounting questions. All it takes is an understanding of a few simple functions within the spreadsheet, and we’re about to reveal those secrets. They’re a lot easier to create than most people think and it only takes one simple formula to produce a scoring system that makes your quiz interactive. This means that your answers will be included in the spreadsheet, but it’s easy to hide the answers and password protect the spreadsheet so your students have to work to find the correct answer. To illustrate how it works, we’ve created an interactive quiz based for a principles-level accounting class. Once you understand the function, you can adapt this to your own needs by changing the headings and questions. We used Microsoft Excel 2000 here, but the concepts work with earlier versions of Excel and other spreadsheets. Background & Objectives This document explains the creation of a self-scoring, interactive quiz using Excel. The reader should be able to create an interactive quiz after reading and reviewing this document. Practice with sample questions is an effective way for students to study for upcoming exams. Interactive quizzes, as described here, are one way to provide a set of sample questions to students before the actual test. Quizzes
http://college.cengage.com/accounting/resources/instructors/air/fall_2006...
Creating Interactive Quizzes in Excel
J.A. (Jim) Connell University of Montevallo Michael E. Stephens College of Business Station 6551 Montevallo, AL 35115 Elizabeth Mulig USF St. Petersburg 140 Seventh Avenue South St. Petersburg Florida 33701-5016 727-553-4154 mulig@stpt.usf.edu
Introduction Have you ever received a spreadsheet file that asked you questions and then magically told you whether your answers were correct? They can be more than e-mail pastimes. Once you understand how those spreadsheet files list questions and check your answers, you can create spreadsheet files that ask your students accounting questions. All it takes is an understanding of a few simple functions within the spreadsheet, and we’re about to reveal those secrets. They’re a lot easier to create than most people think and it only takes one simple formula to produce a scoring system that makes your quiz interactive. This means that your answers will be included in the spreadsheet, but it’s easy to hide the answers and password protect the spreadsheet so your students have to work to find the correct answer. To illustrate how it works, we’ve created an interactive quiz based for a principles-level accounting class. Once you understand the function, you can adapt this to your own needs by changing the headings and questions. We used Microsoft Excel 2000 here, but the concepts work with earlier versions of Excel and other spreadsheets. Background & Objectives This document explains the creation of a self-scoring, interactive quiz using Excel. The reader should be able to create an interactive quiz after reading and reviewing this document. Practice with sample questions is an effective way for students to study for upcoming exams. Interactive quizzes, as described here, are one way to provide a set of sample questions to students before the actual test. Quizzes