GAFE Resources‎ > ‎Google Sheets‎ > ‎

Analyze Your Staff Tech Survey

Note: Prior to this activity, you will need to complete the "Create a Tech Survey" activity located under the Google Forms tab, and have already received responses from a majority of colleagues. If you have not completed that activity, please do so first. Click here to locate this activity. If you have not yet received responses, select another activity and return to this one at a later time.

Work individually, with a partner or with your school team as a group

Plan for 45 minutes


As a Technology Leader, you will see the greatest success with colleagues when you provide differentiated support and challenges to meet each person’s current level of comfort. The responses to the tech survey you created in the previous activity will provide you with valuable data as you plan for the coming months.  In this activity, you will use the capabilities of Google Sheets to analyze that data.


  1. Open your Google Drive by clicking Apps Launcher and then Google Drive

  1. Scroll through the contents of your Drive and locate the title of the tech survey you created previously. Then, locate the Google Sheet with the same title, followed by (Responses). The title will have the Sheets icon to the left.

  2. Open the Google Sheet. Take several minutes to review the responses if you have not yet done so. Note in your digital or paper journal any immediate observations or questions that come to mind.

  3. Use the Sort function in the Data menu to analyze the responses further. Click here for how-to steps from Google Help. Select a column to sort and review the clusters of data generated as a result. Note any observations. For example, you may have created a question regarding teachers’ comfort with the Chromebooks. Originally, the data will be listed in order of response completion. Sorting by that column, you will see clustered together those who selected the lowest number, progressing to those who rated themselves with the highest. You may note the percentage of colleagues at each level and keep this information in mind as you plan for their support.

  4. Follow the above steps for at least 3 different sorts based upon the questions you posed. Be sure to note all significant patterns within your journal for future reference.

  5. Next, you will select several sets of data to reformat as charts or graphs. You may choose the same questions that you sorted, different questions, or a subset of data within a question. Click here to gain an understanding of the Chart function in the Insert menu. Click here to view a list of Chart types, and link to information about each type.  

  6. Create a bar chart for a set of data. Click here for information about this chart type in Google Sheets. Click here for directions on customizing your bar chart. Practice manipulating the layout of the chart to impact the visual presentation of the data.

  7. Create a pie chart for a set of data. Click here for information about this chart type in Google Sheets and for directions on customizing your pie chart. Practice manipulating the layout of the chart to impact the visual presentation of the data.

  8. If you would like, select one or more additional types of charts to create from the menu of options.

  9. Note in your journal any observations from your data analysis that may impact your planning.

Danielson Connections: 4d, 4e