Information Communication/Entrepreneurship6-W5-6.pptx

ICT lesson

1. Day 1 Online Survey Tool

2. Title Lorem Ipsum

3. Online Survey is an innovative , easier and faster way to deliver surveys, collect results and analyze results using online system. This tool is used to define questions and the possible answers using the internet. The link to this survey questions are sent to whoever will answer the survey online.

4. Steps on how to create a survey using google form: Log in to your google account. Click on the google apps icon.

5. Steps on how to create a survey using google form: 2. Click the “Forms” icon once

6. Steps on how to create a survey using google form: 3. Accomplish survey set up. Write a title for your survey

7. Steps on how to create a survey using google form: 4 . Add and edit questions. 6 Types of Questions in Google Forms Text – obtaining short answers Paragraph text – getting easy responses Multiple choice –present several answers to choose from Choose from a list – useful questions about categories Scale – when ranking answers Grid – when providing 1 to 5 responses.

8. 5 . Edit the survey completion form. 6. Distribute the survey (Show the pupils how to create Google Forms)

9. Generalization: Creating online survey is an innovative, easier and faster way to deliver surveys, collect and analyze results.

10. Fill in the blanks with the correct answer. Select from the words in the box. The ______ are utilized to determine the feedback and customers satisfaction. Online survey is an __________ easier and faster way to deliver surveys, collect results and analyze results using online system. Log in to your ________ before creating Google forms. Online survey is ______________. There is no need for printing the questionnaires. ___________ may be encountered. Unstable internet connections is just one of technical issues during online surveys. Technical problems Cheaper Google account Innovative Online survey tools

11. Advantages of Using Online Tools to Gather Data The potential to control respondents that can access the internet. Internet can facilitate discussions with difficult –to-reach, busy or working people. Internet can provide access to various locations. Participants may be more willing to discuss sensitive issues than face-to-face interviews. The financial and time-related cost of gathering data can be reduced.

12. Disa dvantages of Using Online Tools to Gather Data Respondents who participate may be more interested about the topic which may result in biased result. A high incidence of non-response if invitations for online survey sent via email end up in spam folder. Potential respondents may have multiple email addresses that may result in duplication of response.

13. 4. There is no way to verify the identity of the respondents. 5. Internet access may not be available to target participants. 6. Participants may lack the computer skills to be able to respond effectively. 7. Clarifying instructions may be difficult to conduct online or the response may be delayed.

14. Click reponses

15. Click Excel Icon

16. Sample responses

17. Put a check (/) if the statement is correct and X if not. ___1. Surveys enable you to gather data on specific topic. ___2. Online surveys are done through the internet using online survey tools. ___3. Participants may lack the computer skills to respond effectively. ___4. Internet access may not be available to target participants that can cause delay. ___5. O nline survey can reduce financial and time-related cost on gathering data.

18. Day 3

19. Sample of electronic spreadsheet

20. Microsoft Excel – one of the most widely used electronic spreadsheet application by individual and businesses. It contains and columns which enables you to sort, arrange and calculate numerical data easily. Functions – calculations that return a result. To create and enter functions. always start with an equal sign (=). Without it, excel will not calculate a result.The input in functions are called arguments Arguments – this can be a form of numbers, cell references or texts. It refers to both individual cells and cell ranges and must be enclosed within a parenthesis. It contains the information you want to calculate.

21. Excel has the most common functions you may use: SUM – adds all the values in the selected cell range AVERAGE – calculates the sum of the cells and divides by the number of cells in the argument COUNTA – count items in a cell range MAX – determines the highest cell value in the argument

22. Formulas – are combinations of functions and operations Excel uses symbols for mathematical operations for formula, such as: + plus sign for addition ˗ minus sign for subtraction * Asterisk for multiplication / forward slash for division

23. Formula bar equal sign function name argument

24. Click enter

25. Answer the following questions: What is an electronic spreadsheet? What is the importance of using electronic spreadsheet? Why do we need to use electronic spreadsheet? How do we use electronic spreadsheet in a proper way?

26. Arrange the jumbled letters to form a word. Use the clue indicated in each number. ___1. TFUIONSCN – calculations that return a result ___2. SMULAFOR – combinations of functions and operations ___3. DAEPRSHSTEES – are designed with functions and formulas that will make calculating numerical data easier and convenient for you. ___4. GUARNTSME – can be in form of numbers , cell references or texts ___5. CEXEL – commonly used by individuals and business to create and produce much needed calculations and operations.

27. Day 4

28. Sample calculations

29. Formula bar equal sign function name argument

30. Click enter

31. Find the function and create a formula that will calculate the total number of fruits. Write the formula in cell B7. A B 1 Item Number of Fruits 2 Banana 27 3 Mango 32 4 Watermelon 54 5 Pineapples 14 6 Guava 22 7 TOTAL

32. Fill in the blanks with the correct answer. Choose your answer from the words below. The ____________ software is use to create and produce calculated data needed by individuals and business An ______________ is designed with functions and formulas that will make calculating numerical data easier. ______________are use like when you are calculating. ______________ can be in a form of numbers, cell references or texts. ______________ are calculations that return a result. Functions formulas arguments Microsoft Excel electronic spreadsheet