Similar Posts
LinkedIn Post – Survey Monkey and Google Forms Excel Data Format
In Survey Monkey website, there is an example of Survey Monkey survey raw data exported to Excel, a copy can be downloaded here. As mentioned in previous post, question with multiple answer is the main reason you can not use Pivot Table, notice that question with multiple answers are separated into multiple column, the common…
Survey Data di Excel (2)
Untuk mengetahui lebih banyak mengenai bagaimana data survey terlihat di Excel dari survey menggunakan Google Forms, berikut contoh lain file excel tentang study kebiasaan snacking. Untuk survey menggunakan Microsoft Forms data di spreadsheet sedikit berbeda untuk pertanyaan multiple answer (dibahas di post lain).
Kuis Motion
Objective : Ini adalah kuis tentang Motion/Gerak untuk kelas Fisika. Berisi pertanyaan multiple choice dan pertanyaan terbuka. Skor akan dikirim ke email murid setelah reviewer menilai pertanyaan terbuka. Untuk melihat klik di sini, untuk meng-copy klik di sini.
Quiz Photosynthesis
It is a quiz on photosynthesis. Teacher sends out a link for their students to open quiz after class. 10 multiple choice questions with key answers provided. No essay question. It is set so score can be viewed immediately after form submission. To view click here, to copy click here.
Paragraph Question in Google Forms for Asking List of Answers
Other than for open end question, Paragraph question in Google Forms can be used for asking list of answers. In the survey data which is available in Excel spreadsheet that would mean multiple value in a cell in which case Pivot Table would not be suitable. Splitter Excel Add-In splits that multiple values into its…
LinkedIn Post – Splitter Handles Survey Monkey Data
In previous post, Survey Monkey survey data in Excel is rearranged to follow Google Forms format to allow Splitter to do deep dive. One of Splitter key function is to handle question with multiple answers. It splits multiple values/contents in a cell by splitting it into its individual value/content. Google Forms uses comma sign to…