Others

How to Check Exam Logs and Enable Question Shuffling in Microsoft Forms

Chanuka Geekiyanage Oct 19, 2026 868 views

Question details

The user wants to investigate exam timestamps, find ways to shuffle or randomly branch questions, and prevent academic misconduct in Microsoft Forms.

How to Check Exam Logs and Enable Question Shuffling in Microsoft Forms

Product: Microsoft Forms
Device & OS: not provided
Scenario: Administering an online examination and investigating potential academic misconduct.
Observed behavior: Microsoft Forms lacks built-in advanced proctoring and random branching functionality, requiring users to rely on alternative security settings or third-party add-ons.

Before you start

Ensure you have the necessary administrative permissions to access and export form responses, and contact your IT administrator if you need to submit a support ticket for advanced audit logs.

Solution 1Recommended

Export Form Responses and Request Audit Logs

Export your exam responses to Excel to review timestamps, and work with your Microsoft 365 admin to get deeper audit information.

While Microsoft Forms does not display granular audit logs directly in its web interface, you can access basic timestamp data by exporting your results to Excel. For deeper investigations regarding academic misconduct, your IT administrator can request detailed backend logs from Microsoft Phone Support.

Open form responses

Export to Excel

Click the 'Open in Excel' button to download the response data. Open the downloaded file to review the start and completion times for each student.

Contact your IT administrator

If you need further audit details, ask your IT administrator to raise a support ticket through the Microsoft 365 admin center.

Export Form Responses and Request Audit Logs

Data availability: The Excel export only provides basic start and end times. Detailed tracking of student navigation requires advanced logs from Microsoft support.

Solution 2

Enable Question Shuffling and Security Settings

Use built-in Microsoft Forms settings to shuffle questions and restrict response behavior to minimize misconduct.

Solution 3

Integrate a Third-Party Proctoring Tool

Use compatible third-party applications like AutoProctor to add advanced proctoring capabilities to your Microsoft Forms exams.

Free Microsoft Office alternative

Analyze Your Exported Exam Logs Using WPS Office

Once you have exported your Microsoft Forms responses, you need a reliable spreadsheet tool to analyze the data and timestamps. WPS Office is a powerful, free alternative to Microsoft Office that handles Excel files effortlessly, offering seamless compatibility and a familiar interface.

1. Download WPS Office: Visit the official WPS website and download the free WPS Office suite for your device.
2. Open your exported logs: Launch WPS Spreadsheet and open the .xlsx file you downloaded from Microsoft Forms.
3. Analyze timestamps: Use built-in data sorting, filtering, and conditional formatting to easily identify unusual exam patterns.

Completely free and lightweight office suite100% compatible with Microsoft Excel (.xlsx) files exported from FormsFamiliar spreadsheet interface for easy data analysis without a learning curve

microsoft office alternative - wps office

Frequently Asked Questions

Can I show students one random question at a time in Microsoft Forms?

Currently, Microsoft Forms does not support branching to randomly selected questions. You can only shuffle the display order of all questions for each student by using the 'Shuffle questions' option in the settings menu.

How do I investigate unusual timestamps in Microsoft Forms?

Navigate to the 'Responses' tab of your form and click 'Open in Excel'. This spreadsheet provides exact start and completion times for each student's submission, helping you identify suspicious timing.

Does Microsoft Forms have built-in proctoring tools?

No, Microsoft Forms lacks built-in proctoring features. You must rely on native settings like question shuffling and time limits, or integrate third-party tools like AutoProctor for camera and screen monitoring.

Office Quick Solutions