Integration/Forms Homework Assignment

Due Date:	Thursday July 9
Printouts:	One or more pages of your form Spreadsheet results showing answers people gave to your form, total money donated and summary table you created Summary page showing results from your form One or more charts made from your form
Other Requirements:	• Name your Form as explained in the section below.  • Make the Form be part of your CS110 collection.  • Edit your HW4 website so some of the work you have done in this assignment is on the website.
Evaluation:	15 points
Related Materials:	Example of a multi-page multi-path form

Preparation:

You will need to experiment with making a google Form within ScarletDocs. Forms are easy to make, but this assignment asks you to use some more sophisticated features.  If you try to learn some of the features on your real form, you will probably cause issues that are not easy to fix. That is is why is important to experiment on a practice form until you are comfortable using the features.

The Assignment:

The goal of this assignment is create a questionnaire about your product and to analyze how people fill this form out. You can ask any questions about your product as you want. What people think of it. Whether they own the product. What similar products they suggest. Whether they are willing to give you a donation to help you buy it.  And so on. The questions are up to you. Be creative.

To help you with this assignment, I have created a sample form to show you the flexibilty of Forms in scarletdocs. You can and should fill out the form as many times as you want to see all the paths thru the questionarre.  Different questions are shown, or not, depending on how people answer the questions.  As you will see below you have to add similar variety to your own questionarre. The sample form is available here: sample multi-page multi-path form.

There are five main parts to this assignment.

• First, you will create a multipage form which has at least ten questions in it.
• Second, you will get at least ten other people to fill out the form.
• Third, you will do a number of activites in the speadsheet
• Four, you will generate printouts and share your work appropriately.
• Five, add some of this work to your HW4 website.
  

On your form, make sure you ask whether the person is willing to donate money to help you purchase your item, and if so, how much they are willing to donate. (Only ask How Much? if they indicate they will donate.)

Make sure you use the command on the Response menu reading "Choose response destination" to make sure the responses will go into new spreadsheet.

Hints: Use Create Form in Scarlet Drive/Docs to start a new form. Use "Add Item: Page Break" to make new pages. Use "Add Item" to add various types of questions.  Most importantly, you can pick which page of questions follows a previous page by setting the "Continue/Go To" menu that will show up on the righthand side of the bar between pages. Or, you can control this more minutely, making different determinations using the exact answers by selecting the "Go to page based on answer" option listed by multiple-choice questions.

2. Fill out Form

Make sure your form can be filled out by people outside of Rutgers (those who don't have a Rutgers University login.) Send email to people - friends, classmates, TA, family - letting them know the location of the form and asking them to fill it out. You can click "View live form" to go to the form as others would see it. The URL that shows up in the address bar after doing that is that address that can be shared. Likewise, you can click the "Send Form" button and get the link there to share in your own way, or to share using the methods google supports (twitter, facebook, email etc.). Get at least ten people to fill it out. If you have trouble getting people to do this, you can fill out the form multiple times yourself.

3. Using Associated Spreadsheet

Go into the spreadsheet which shows the results from people filling out the form. (Use "View responses" command near top of sheet assuming you previously chose a response destination as requested earlier in this assignment.)

Off to the side (so you do not interfere with the answers coming in), or in a new tab have the spreadsheet calculate and display the total amount of money donated so far, and the phrase "Goal Reached" once the amount donated is over the amount you need. Obviously you will have to enter the amount you need into the spreadsheet (again on the side) and compare against that amount.

Next, in a separate section (off to the side), or in a new tab, of the sheet make a nicely formatted and sensible table showing at least five tally stats indicating how people answered some of the questions you asked.  You should use the COUNTIF function for many of these. When you give the range for the function, give an end cell many rows past the end of the current data.  (This way the tallies will recalculate as more answers come in later.) For example, if column B had the answers (Yes or No) to the question "Do you own a bicycle?", you can tally up how many people said "Yes" using the equation =COUNTIF(B2:B200,"=Yes") - opting to use B2 as the starting cell so the column header is not looked at, and B200 as the ending cell, so it can handle up to 199 people answering (even if only 10 have so far.)

Also, make several sensible charts or graphs (column?) of some type showing some aspect of the spreadsheet you want to highlight. (For example, you could show a two column chart showing how many people said "Yes" they own a bicycle in one column, and the number who answer "No" in the next column.

4. Naming, Sharing, Printing

Name your Form as follows: HW11 Lastname, Firstname - then make sure both the form itself and the spreadsheet of responses are placed in your CS110 folder so these files are shared with your TA.

Print and submit four printouts:

• Show at least one of the interesting pages from your form. You can print more than one if you want.
• After at least ten people have filled out the form, print the Spreadsheet displaying how the people answered the questions and also displaying the summary table you added. You can get to the spreadsheet by using the View Responses command (top of screen, assuming you previously set up a response destination) while working on the form.
• Bring up the google generated "Summary of responses" (thru the "Responses" menu) and print this also.
• Print one of the charts you made in the spreadsheet.

5. Integration

As you have already seen in previous assignments, Google makes it very easy to share info from one aspect of Google to another.  So we have been able to include maps in websites, place documents on websites and so on. Here, we saw how nicely Forms and Spreadsheets work together.  The concept of having different applications work nicely with one another, to share info, or features in some way, is know as integration.

To continue this theme, pick something from this assignment - the spreadsheet, the form, a chart - and display it a sensible place on your website.

Final Task

When you are done with this assignment, email your TA to let him/her know you shared the form in your folder and tell them what item you added to your webpage.  The TAs will check that they find these items.

Good luck,
-Jt