Throughout the semester, it is sometimes useful to survey your students’ knowledge or familiarity with a particular subject. For example, you could find out about their familiarity with Excel or see how frequently they have used the PsychInfo database at the library. You can do this by visiting your Gustavus Google account (if you have never used your account, you will first see a registration page before your Gustavus Google Calendar loads), selecting “Documents” from the menu bar at the top left, and then creating a new “Form”. Pictured below is an example survey I made inquiring about software.
As people take the survey, you can view quick data summaries for each question. As you can see in the screenshots below, most students are comfortable calculating averages in Excel, but not many students have ever used Excel pivot tables.
If you need to do fancier data summaries or actual statistics, you can export your survey data into an Excel file (or other spreadsheet equivalents).
Leave a Reply