Similar Posts
LinkedIn Post – Survey Data Entry and Analysis Using Excel
Previous posts showed how to use Splitter to analyze survey data in Excel downloaded from Google Forms or exported from Survey Monkey. Splitter can also handle survey data entered in Excel from survey using pen paper, ie row for respondents and column for question answers. For multiple answer separate each answer with a comma sign-within…
Google Forms Tutorial Part 2 : Create Online Quiz/Test – Indonesia
Tutorial mengenai cara membuat kuis online dengan menggunakan Google Forms dari awal dengan contohnya: dari bagaimana membuat Google Forms menjadi kuis, membuat kunci jawaban dan nilai untuk pertanyaan tertutup dan terbuka (essay), mengirimkan kuis, mengirimkan skor hasil ke peserta kuis, membuka data peserta kuis di spreadsheet. Download pdf di sini.
Comparison Survey Data Format in Excel : Survey Monkey to Google Forms
Here we have example of raw survey data (individual responses) from Survey Monkey and the same data in Google Forms format. Survey monkey data download here, in Google Forms format download here. If you have survey data from Survey Monkey or other online survey platform and wants to do in-depth analysis using spreadsheet, you’d want…
LinkedIn Post – Google Forms + Splitter
Question with multiple answers is the main reason why Pivot Table can not be used to analyze survey data in Excel. Common data format in Excel is to separate the multiple answers into multiple columns, requiring complicated formula for calculation, if Excel is used for analysis at all. Google Forms data format is unique and…
Tingkat Ketertarikan untuk Membeli Smartphone Baru
Kuesioner ini bertujuan untuk mengetahui tingkat ketertarikan konsumen terhadap produk smartphone baru. Format kuesioner ini dapat digunakan sebagai template untuk produk lain atau evaluasi konsep produk. Untuk melihat kuesioner klik di sini, untuk meng-copy ke Google Drive Anda klik di sini
PRODUCT TEST – LOOSE TEA
This questionnaire is about product test for loose tea. Developed in Google Forms, free to copy to your Gdrive. 3 Products, Blind Test, Sequential Monadic with Rotation. Here we use branching to section facility in Google Forms to apply the rotation. To view click here, to copy click here.