Key Insights:
Creating an exam marker that automates the grading process and sends instant feedback to users is a powerful application of Microsoft's Power Platform. This process leverages the simplicity and external accessibility of Microsoft Forms, enriched with a versatile quiz mode. Even though MS Forms is user-friendly, the journey to a fully automated marker involves diving deep into APIs with minimal guidance, necessitating a clever approach to extracting crucial data like questions and responses. The integration with Power Automate and the innovative use of Office Scripts for dynamic validation and scoring scripts highlight the flexibility and creative potential of Microsoft's tools. Building such a system not only showcases the technical prowess required to overcome the lack of direct support for specific features but also emphasizes the strategic setup of quiz form settings to maintain integrity and fairness. In summary, this blend of Microsoft technologies offers an insightful exploration into creating efficient, automated systems for evaluating quizzes or tests, paving the way for educators and developers to craft tailored, cost-effective solutions for their specific needs.
David Wyatt explores an innovative way to automate exam marking using MS Forms and Power Automate. Without a budget for ready-made solutions, he leverages his Power Platform skills to create a versatile testing and result distribution system. MS Forms was chosen for its ease of use, external accessibility, quiz features, and integration potential with Power Automate, despite initial functionality gaps.
The project involved several key steps: mapping the Forms API, developing a validation script, compiling everything into a flow, and adjusting form settings. MS Forms supports various question types, though Wyatt focused on text inputs and multiple-choice questions, excluding types without clear right or wrong answers.
To capture question and answer details, Wyatt navigated the lack of direct Power Automate connectors and incomplete API documentation through browser network inspection. This led to identifying essential APIs for fetching questions and responses, setting the groundwork for processing exam submissions.
The validation script, crucial for assessing responses, was executed through Office Scripts. It involved iterating over questions to check answer types, compare submitted answers with correct ones, and tally scores. This script facilitates dynamic exam marking, overcoming Power Automate's limitations in directly handling such tasks.
Integrating this script within a Power Automate flow, Wyatt managed to automate the response handling. Utilizing SharePoint HTTP requests allowed for a non-premium solution. The flow includes steps for evaluating exam results, generating certificates via Microsoft Word, and disseminating results and certificates through email.
Form settings were meticulously adjusted to enhance security and integrity. Features like disabling practice mode and hiding answers post-submission were pivotal in maintaining exam fairness. Despite these measures, Wyatt acknowledges the solution isn't cheat-proof but serves its purpose effectively.
A demo version of this exam automation system is available, offering a hands-on experience for Power Automate and Power Apps enthusiasts. It showcases Wyatt's achievement in elevating the utility of MS Forms and Power Automate for educational assessment purposes.
Power Automate, as showcased by David Wyatt's project, offers vast potential in customizing and automating educational processes. By integrating it with other Microsoft services like MS Forms and Office Scripts, educators and developers can create tailored assessment tools without the need for expensive off-the-shelf software. This approach not only saves costs but also allows for personalized exam settings, automatic marking, and immediate feedback provision.
To facilitate an integration between Microsoft Forms and Power Automate, it is necessary to create an automated workflow specifically for Microsoft Forms.
Indeed, Microsoft Forms supports Auto-Grading, which becomes functional for questions of multiple-choice, text, or ranking nature, provided the correct answers to such questions have been previously identified or inputted.
Upon commencing this process, you will encounter a variety of options. The appropriate choice in this context would be the "choice" option.
To mark answers, particularly employing the Choice question format as an illustration, you should introduce your question along with the responses. The option to add more response alternatives is made available via the "+ Add option". For designating the accurate answer or answers, clicking the Correct Answer check mark adjacent to the desired answer is imperative. It is noteworthy that options such as "All of the above" or "None of the above" can also be elected.
Power Automate Exam Marker, Microsoft Forms Exam Creator, Automate Exam Grading, MS Forms Assessment Automation, Create Exam Power Automate, Design Exam with MS Forms, Automated Exam Scoring, Exam Marker Using Power Automate, Microsoft Forms Exam Automation, Power Automate Assessment Tool