Others

How to Use Microsoft Forms for Award Nominations and Judging

Maira Mehtab Sep 21, 2026 869 views

Question details

The user needs to transition an annual award program from SurveyMonkey and Excel to Microsoft Forms to manage nominee submissions and structured judging with scoring criteria.

Product: Microsoft Forms
Device & OS: not provided
Scenario: Setting up nominee submissions and a judging form with scoring criteria for an annual award program spanning multiple regions.
Observed behavior: The goal is to successfully configure Microsoft Forms to handle data collection, scoring, and permissions for nominees and judges.

Before you start

Before creating your forms, outline your exact scoring criteria and confirm who will need access to view or evaluate the submitted data.

Solution 1Recommended

Plan Form Structure and Judging Criteria

Properly mapping out your nominee form and scoring method is essential before building it in Microsoft Forms.

Since the program covers multiple regions and relies on standardized criteria, structuring the data collection process beforehand ensures that the exported results are easy for judges to review and score.

Define the Nominee Form

List all required fields for nominee submissions, such as name, category, region, and supporting text descriptions.

Establish Scoring Criteria

Determine how judges will score the nominees, such as using a Likert scale or rating questions out of 10, and map these to specific Form questions.

Determine Response Storage

Decide where the submitted data will live. You can set the form to automatically sync responses to an Excel workbook hosted on SharePoint or OneDrive for collaborative judging.

Solution 2

Review Microsoft 365 Licensing and Account Types

Check your account type to ensure you have the necessary permissions to collect respondent data automatically and securely.

Build Forms with WPS Office

Create Award Nomination Forms and Judging Sheets with WPS Office

WPS Office offers a built-in Form tool that seamlessly integrates with WPS Spreadsheets. You can easily collect nominee submissions online and have the data automatically populate into a spreadsheet for judges to score, replacing the need for external survey tools.

1. Access WPS Forms: Open WPS Office, navigate to the 'Tools' tab, and select 'Form' or 'Smart Form' to start a new project.
2. Add Form Questions: Add your nomination or judging questions, utilizing rating scales, multiple-choice, or text fields as needed.
3. Share the Link: Click 'Share' or 'Send' to generate a link and distribute it to your nominees or evaluators to collect their inputs.
4. Analyze Data in Spreadsheets: Click 'View Responses' to automatically open a WPS Spreadsheet containing all submitted data, where you can use formulas to tally the final scores.

Easily create customizable online forms for nominations and judging.Responses automatically sync to a WPS Spreadsheet for real-time scoring and calculation.Fully compatible with Microsoft Excel (.xlsx) formats for easy sharing with judges.Lightweight, free, and accessible across multiple platforms and devices.

microsoft office alternative - wps office

Frequently Asked Questions

Can I collect file uploads, like portfolios, in my Microsoft Forms nomination form?

Yes, Microsoft Forms allows you to add a 'File Upload' question type, provided that the form is restricted to 'Only people in my organization can respond' and you are using a compatible enterprise or business account.

How do I share the judging form securely with specific evaluators?

You can share the form by clicking 'Collect responses' and choosing 'Specific people in my organization can respond', then entering the email addresses of your designated judges.

Can I calculate the total scores automatically within Microsoft Forms?

Microsoft Forms itself does not calculate a total score across multiple rating questions. You will need to export the form responses to Microsoft Excel to sum up the individual scores and determine the final winner.

Office Quick Solutions