Page Comparison

This article is for faculty, staff, and students who want to create a form, quiz, or survey on the web.

...

1. Visit s.uconn.edu/onedrive and sign in with your email address and NetID password.

2. Click on My Files in the left-hand menu and find the folder that you would like the spreadsheet to reside in.

3. Click on Add new in the top-left corner to add a Forms for Excel.

4. Continue down this page to the “Question types” section.

...

1. Visit s.uconn.edu/onedrive and sign in with your email address and NetID password.

2. Click on My files in the left-hand menu, then locate and open the spreadsheet.

3. In the top ribbon, click on Insert and choose Forms then New Form.

   

...

1. Go to forms.office.com and sign in with your email address and NetID password.

2. Click New Form to begin.

   

3. Click Untitled Form and enter a name for the form. If desired, a description can be added as well.

Question types

Click Add New and choose a question type.
At the end of each question title is an icon that allows you to add a picture to the question.
By clicking on the ellipsis (…) of each question you will find more options.

• Choice: is a typical multiple-choice question. If multiple answers should be allowed, enable Multiple answers.
  Click on ellipsis to shuffle the answers for each user. Choose Drop-down to change the radio buttons to a drop-down menu.

  

• Text: is an open ended type question that gives the user a text entry field. The limit for this field is 4,000 characters.
  If you choose Long answer the text field will adjust its size to fit the text entered by the user.

• Rating: allows the user to give a star rating to text of the question. You can have 2 to 10 stars appear in the question. The icon can be changed from a star to a few other icons.
  Using the ellipsis menu, you can enter a description for the minimum and maximum rating level.

• Date: allows the user to enter a date using a calendar tool.

• Ranking: allows users to click-and-drag a list of items to place them in an order of their choosing.

• Likert: allows you to group multiple Rating questions into a single question. This question type will look familiar if you have filled out a satisfaction survey after receiving a service from a company.

  

• File upload: Allows the user to upload (attach) a file to the form. ⚠️ Note that this option is available only when the form is limited to UConn users; this option is not available for public forms due to security concerns.
  In the ellipsis menu you can restrict which file types are allowed for upload.
  The file upload question cannot be anonymous.

• Net promoter score: is another way for users to describe their attitude toward the question. This question type will look familiar if you have filled out a satisfaction survey after receiving a service from a company.

  

Questions can be made required by selecting the Required icon.

Creating Sections

Sections break the form up into multiple pages. Instead of seeing all questions on one page, users will only see one section at a time. To navigate to the next section, all required questions must be answered and the user must click the Next button.

1. Click Add New.

2. Select Section.

3. Enter a section name, and if desired, a description.

   

Adding Branching (conditional formatting)

With branching, a user's response to a question can dictate what happens next in the survey. You can make questions either appear or disappear depending on a user’s choice on a previous question. On any question, branching can be added by:

1. Select the ellipsis icon in the bottom right corner of the question.

   

2. Click Add Branching

3. Next to an option or at the end of a question, choose the question or section the survey should go to next.

...