Fix Microsoft Forms Incorrectly Scoring Capital Letters
Question details
Users need to resolve a discrepancy where Microsoft Forms incorrectly marks valid answers as wrong on the Publish results page simply because they contain capital letters.
- Product
- Microsoft Forms
- Device & OS
- not provided
- Scenario
- Teachers or form creators are reviewing and publishing quiz scores for students.
- Observed behavior
- Individual results and exported Excel files show correct grades, but the Post Scores/Publish results page displays incorrect scores for answers containing capitalized letters.
Before attempting to resolve this display issue, export your current form results to an Excel spreadsheet to ensure the correct underlying scores are safely preserved.
Report the Issue via Microsoft Forms Feedback
Because this is a known backend glitch affecting the Post Scores display, submitting a direct report to the Microsoft Forms engineering team is the fastest way to flag the issue.
Microsoft uses direct user feedback to identify backend scoring behavior changes. Reporting the exact form and capitalization discrepancy helps them target the bug.
Navigate to Microsoft Forms and open the specific quiz that is experiencing the capitalization grading error.
Click on the 'More form settings' icon (the three dots) located in the upper right corner of the screen.
Select 'Feedback' from the dropdown menu. Describe the issue clearly, mentioning that the Post Scores page shows incorrect results for capital letters while the Excel export remains correct, and submit the report.
Open a Support Ticket via Your Microsoft 365 Admin
If the issue persists, routing a formal support ticket through your organization's IT administrator will prompt Microsoft to investigate the backend using diagnostic tools.
Easily Analyze Form Results with WPS Office
While waiting for Microsoft to fix the Forms backend scoring glitch, you can seamlessly review your exported quiz results using WPS Office. It is a free, highly compatible alternative to Microsoft Office that easily handles exported Excel data.
- 1. Export Form Data: In Microsoft Forms, go to the Responses tab and click 'Open in Excel' to download your accurate scoring data.
- 2. Open with WPS Spreadsheet: Launch WPS Office, select Spreadsheet, and open your downloaded file to view the correct grades without capitalization errors.
Frequently Asked Questions
Are the final grades lost due to this capitalization error?
No, the final grades are not lost. The issue only affects the visual output on the Publish results page. If you view individual results or export the data to an Excel file, the correct scores are preserved.
Why does the Post Scores page show a different score than the Excel export?
This is a backend glitch in Microsoft Forms where the Publish results view fails to ignore capitalization in text answers, even though the underlying data correctly records and awards points for the answer.
Can I manually fix the scores in the Post Scores view?
You cannot easily change the automated grading display bug for capitalization directly in the Post Scores overview. However, you can manually review and adjust scores in the individual responses tab or rely entirely on the exported Excel spreadsheet for final grading.
