6

Technology and Livelihood Education

ICT-ENTREPRENEURSHIP
Fourth Quarter – Week 5

• Creates Online Survey Form

(TELEIE6-Oe-9)

• Processes Online Survey Data

(TLEIE6-Of-11)

Name: ________________________ Grade: _____________

Teacher: _______________________ Date: ______________
 Lesson Creates an Online
1 Survey Form

Presentation
At the end of this lesson, you are expected to create an online survey form in
google drive and google sheet. (TLEIE-Oe-9)

Discussion

What is an online survey form?

An online survey is a structured questionnaire that your target audience
completes over the internet generally through filling out a form. Online surveys can
vary in length and format. The data is stored in a database and the survey tool
generally provides some level of analysis of the data in addition to review by a
trained expert.

What are the benefits of online surveys?

Unlike traditional surveys, online surveys offer a way to collect information
from a broad audience for very little cost. When conducting an online survey, you
have an opportunity to learn:
• Who your users are
• What your users want to accomplish
• What information your users are looking for

When to Conduct an Online Survey

• Before a site redesign you learn about current users and what they are
trying to accomplish
• After launching a new or revised site, you can learn if your new design
meets the needs of users and identify areas for improvement
• When you want to have content or features rated or ranked, you can
conduct ongoing surveys to gain ideas for future improvements
Best Practices for Developing Online Surveys

Before creating an online survey, you should identify:

• Your purpose
• Your respondents
• Software you will use
• Collection of data and its limitations
• Analyzation of data

Once you outline those basics you need to consider the following:
• Keep your surveys as brief as possible
• Provide the participant with an estimate of completion time up front, as
well as something that indicates their progress
• Include a mix of open-ended questions—in which users complete the
answer—and closed questions
• Ask if a respondent is willing to answer more in-depth questions in a
follow-up survey or interview

Creating Questions

Create your questions once you have determined the software and purpose. You
may want to consider collecting information about:
• If users are able to find the information they seek
• How satisfied users are with your site
• What experiences users have had with your site or similar sites
• What users like and dislike about your site
• What frustrations or issues users have with your site
• If users would recommend your site to others
• If users have any ideas or suggestions for improvements

How to create an online survey form?

You may create using the following applications:

Google Drive Google Sheets

A. Steps in Creating Online Survey Form in Google Drive

1. Go to drive.google.com
(Google Drive provides 15GB of free Google storage to save any type of file in one place)

2. Click the + button on the left

3. Click New on the top left, hover the cursor over More, then choose Google
Forms
4. A welcome message will appear, click Get Started

5. A new template opens and there you can add your survey questions
a. Start with the title of the survey. Click Untitled form in the upper left corner
then type the desired title.
 b. Check the box with the label Show progress bar at the bottom of form
pages, if you like to see the progress bar indicating how much of your form
they’ve completed.

c. Type the question in Question Title text box

d. Select the Question Type

e. Click Done

f. To add another question, click Add item button

You may also add a theme in your form by doing the following:
a. Click Change theme in the toolbar
b. Scroll through the templates in the panel on the right and click the theme
you prefer

All you need is to right- click the thumbnail of the form in your drive, hover
over Open with and click Google Forms, if you want to stop and continue doing
your survey later.

B. Steps in Creating Online Survey Form in Google Sheets

1. Click New on the top left, and choose Google Sheets, in your drive

2. Click Insert Menu and select Form. A message will display at the top of the page,
then a new form has been created.
3. Click Add question to begin editing your form
Tip: To get rid of this message, you can click Dismiss and continue editing your
spreadsheets.

Activity 1

Write the steps in creating an online survey form using:

A. Google Drive
1. _______________________________________________________________
2. _______________________________________________________________
3.________________________________________________________________
4.________________________________________________________________
5.________________________________________________________________

B. Google Sheet
1. _______________________________________________________________
2. _______________________________________________________________
3.________________________________________________________________

Activity 2
Create a survey form using Google Drive about the respondent’s basic profile.

Activity 3
Create a survey form using Google Sheet about the respondent’s basic
profile.
Rubrics in creating survey forms (Activities 2 and 3).

Criteria Excellent (5) Better (4) Good (3) Fair (2) Poor (1)
Ability to
create
survey form
Ability to
formulate
questions

Key Answer

Activity 1

Steps in Creating Online Survey Form in Google Drive

1. Go to drive.google.com
2. Click the + button on the left
3. Click New on the top left, hover the cursor over More, then
choose Google Forms
4. A welcome message will appear, click Get Started
5. A new template opens and there you can add your survey
Questions

Steps in Creating Online Survey Form in Google Sheets

1. Click New on the top left, and choose Google Sheets, in
your
drive
2. Click Insert Menu and select Form. A message will display
at the top of the page, then a new form has been created.
3. Click Add question to begin editing your form

Activities 2 and 3

Answers may vary. Use the rubrics in scoring.

*Note: Please submit a hard copy of your output to your teacher.

 Lesson Processes Online
2 Survey Data
Presentation
In the previous lesson, you have learned about creating online survey form.
This time, you will learn the next step which is the processing of the gathered data
from the online survey you have created.

Discussion
Survey data processing is the crucial step that follows the collection of
any survey data. The aim of data processing is to manipulate or transform
raw data into meaningful results which can be analyzed in any statistical software
tool, and ultimately presented in a way that answers the intended research question.

Quality assurance

A central component of processing customer feedback survey data is quality

assurance - ensuring that the data is of high quality and therefore presents valid
results. Data processing involves several stages, including logic checking and data
cleaning.
The data processor will check the logic to ensure that the data which has
been collected has been collected correctly and that there is no missing or erroneous
data. That is, checking that no individual has answered a question they were not
supposed to answer, and no one has missed a question that they should have
answered.
Data cleaning, on the other hand, deals with identifying outliers and removing
respondents who have given contradictory, invalid or dodgy responses, or are
potential duplicate records. Common forms of cleaning include identifying
speedsters, flatliners, and nonsensical or obscene open-text responses.
• Speedster - A respondent who completes the survey in a fraction of the time
they should have. Therefore, it is believed that they could not have possibly
read and answered all the questions properly in the time taken. As each
survey has a set expected length, you can measure this against the individual
duration of the entire survey, or specific sections (if recorded), to identify
speedsters.
• Flatliner - A respondent that gives the same response for each item in a
series of ratings (such as “On a scale of 1 to 5 where 1 means ‘Not very
satisfied’ and 5 means ‘Very satisfied’, how would you rate each of the
following supermarkets?”).
• Nonsensical - Someone may also write random letters or numbers instead of
giving a legitimate answer to an open-text response question. Similar
repeated behavior on key questions will often be used as a justification for
removing an individual's record from the data set.
Highlighted below is an example of a flatliner and respondent who has given
a nonsensical answer:

Data preparation and production

The final step in the data processing stage is to ensure that the data can be
used for analysis. This may require adjustments and transformations, including data
entry, editing, rebasing, filtering and reconstructing. If verbatim responses (open-
ended questions) have been collected, they may need to be coded down to a more
manageable number of themes and comments.
Data weighting may also be required to correct issues with sampling inconsistencies
or to ensure the data is representative of the target population. Once the data is
prepared, it can then be presented through statistics in tables, charts, or dashboards.

Steps in Processing Online Survey Data Using Google Form:

1. Create an Account using Google

Click Create Account and then select For Myself

On the next page, provide some information- first and last name, username,
and password- to create your account.
Verification code will be sent thru sms.

2. Create a Blank Form

Type the name and description of your form.

Type the questions

Click the drop-down menu next to the question field.

 Then, select the type of question.

Activity 1
Answer the survey form in Lesson 1, Activity 2.

Activity 2
Answer the survey form in Lesson 1, Activity 3.

Rubrics
Criteria Excellent (5) Better (4) Good (3) Fair (2) Poor (1)
Ability to
answer the
survey form

Assessment
Process the data gathered from Lesson 2, Activities 1 and 2.

Criteria Excellent (5) Better (4) Good (3) Fair (2) Poor (1)
Ability to
process the
data
gathered

Key Answers
Answers may vary. Please use the rubrics in scoring.

*Note: Please submit a hard copy of your output to your teacher.

References

Online Surveys | Usability.gov

What is Survey Data Processing? | Displayr

Home Economics and Livelihood Education 6 (New Edition), Erlinda M. Mendoza,

JFC Publishing House, Inc., pp.11-14

Self- Learning Module, SOCSARGEN

PREPARED BY:

JUVY C. INDOLOS
TEACHER 1
HAGUIKHICAN ELEMENTARY SCHOOL

EVALUATED BY:

GAYNOR P. ENCINA
MASTER TEACHER 1
BORAC ELEMENTARY SCHOOL

SOLOMON A. MEREZ JR.

PRINCIPAL 1
HAGUIKHICAN ELEMENTARY SCHOOL

NOTED:

ALMA M. ATIBULA,EdD
OIC-PSDS
NAVAL DISTRICT 2