Randomization of Number Research Assistant
Project scope
Categories
Accounting Financial modelingSkills
management accounting accounting researchWe have developed a large bank of management accounting questions, but all these questions are static questions (have only one version).
The project involves creating algorithmic questions (multiple versions of the same question) using Microsoft Excel.
These questions will be used for assignments and quizzes so that students will get different versions of the same questions. This reduces the chances for cheating.
- Create Excel spreadsheets for accounting related questions.
- Use random numbers and set the range or parameters for each variable in the question.
- Solve the question on Excel spreadsheet using formulas.
- Generate 20 -30 versions of the same question on Excel.
- Transfer the questions and solutions on a word document.
Will provide initial training on Excel functions to be used for the project.
Will supervise the students on an ongoing basis.
About the company
The School of Business at MacEwan University consists of four departments:
- Department of Organizational Behaviour, Human Resources Management and Management
- Department of Accounting and Finance
- Department of Decision Sciences
- Department of International Business, Marketing, Strategy and Law