session 02 easy and free data collection and processing tools
TRANSCRIPT
Easy and Free Data Collection and Processing Tools
Google Forms and Pivot Table
Google Forms
• Google Forms is part of Google’s collaborative productivity application or system, Google Drive.
• Google Drive includes cloud-based productivity applications for text processing, spreadsheet, presentations, drawing, image editing, file storage, and photo storage, among others.
• Useful for basic data collection needs, such as survey or login-free input form from multiple users
Creating a Google Form
• Log in to Google Drive using your Google account at https://drive.google.com
• Once you are logged in, click the red “New” button on the upper left side of the browser, select “More,” then select “Google Forms.”
DEMONSTRATION
Google Forms Support Articles
• Introductory Page to Google Forms https://www.google.com.ph/forms/about/
• View and manage form responses https://support.google.com/docs/answer/139706?hl=en
• Control navigation to sections of a form https://support.google.com/docs/answer/141062?hl=en&ref_topic=6063584
Pivot Table
• Pivot Table is a spreadsheet tool used to summarize large amounts of data in a table by using the column headers as basis for arranging the data.
• It is available in Microsoft Excel (called PivotTable), LibreOffice Sheets, and Google Sheets, among others.
Using Pivot Table in Excel 2010
• With an open Excel spreadsheet, click the Insert tab, then click PivotTable
DEMONSTRATION