One Advantage to Using Google Sheets Conditional Formatting…

I’m a visual learner and like using conditional formatting to add color to Google Forms Spreadsheets. The Google Form Spreadsheet collects the data obtained from a Google Form. Thanks to the colorization capability of spreadsheets I can start accessing the data before creating charts and using equations.

SPREADSHEET EXAMPLE OF USING CONDITIONAL FORMATTING TO COLLECT DATA
Conditional Formating Data

  1. The color options for each column was created by using conditional formatting
    1. Allows one to set colors based upon the answers
    2. Spreadsheet automatically colors cell depending on response
  2. Data information can be seen before charting or using equations
    1. Example from the above graphic
      1. More females answered the question
        1. Female represented by pink
        2. Milk chocolate was the most popular answer ~ light brown cells
        3. White Chocolate was the least favorite ~ Black cells
        4. Grade column is difficult to assess visually ~ no color added

HOW TO SET COLOR USING CONDITIONAL FORMATTING 

  • Create a Google Form with multiple choice, checkboxes or list questions
    • This is the easiest questions to use for conditional formatting
  • Open the response spreadsheet associated with the form
  • WATCH this Video to setup a conditional format for each spreadsheet column

https://youtu.be/Zq7-X3WCd5M

Yes! You Can Have One Sheet per Student in a Google Form Spreadsheet

I’m discovering not many teachers know multiple student sheets can be added to one spreadsheet. Due to the time it takes for setting this up I don’t recommend doing this for all Google Forms. However due to the nature of a reading log it is well worth taking the time to set up a sheet per student. The trick is you will need to create one Google Form per student, and then add a sheet into an existing Spreadsheet.

This is how to add multiple sheets to one spreadsheet

Reading Log multiple students

STEPS for ADDING MULTIPLE SHEET to a SPREADSHEET

  • Open Google Form
  • Click Response

step 1

  • Click Change Response Destination

Step 2-2

  • Click New Sheet in Exisiting Spreadsheet

Step 4

  • Select the Spreadsheet

Step 5

IF ALL GOES WELL YOU SHOULD HAVE MULTIPLE SHEETS IN ONE SPREADSHEET

Screen Shot 2015-08-24 at 10.35.34 AM