Introduction to Electronic Data Processing

EDP 101 - Week 1

About the teacher

• swift as a coursing river
• with all the force of a great typhoon
• with all the strength of a raging fire
• mysterious as the dark side of the moon

Remember, remember

• Please keep your User ID for yourself.
• Don't hesitate to ask questions. Satisfy your curiosity.
• The teacher doesn't know everything. But I bet Google Search does.
• Everybody starts out as a beginner. Don't be afraid to try new things.

Remember, remember

• Tell the teacher if the pace is too slow or too fast.
• There will be assignments every now and then.
• Materials are posted in the classroom.
  • Repository for the decks can be found here.

What is Electronic Data Processing?

Electronic data processing (EDP) can refer to the use of automated methods
to process commercial data. Typically, this uses relatively simple, repetitive
activities to process large volumes of similar information.

- Wikipedia

Using different tools for different jobs.

To the man who only has a hammer, everything he encounters begins to look like
a nail.

- Abraham Maslow

Course Outline

1. Introduction to the different apps in the Google ecosystem
2. Capturing meaningful data using Google Forms
3. Cleaning the data in Google Sheets
4. Telling a story using Google Data Studio
5. Anything you want

The Google ecosystem

• Search
• Gmail
• YouTube
• Drive
• Docs
• Sheets
• Slides
• Forms
• Apps Scripts
• Data Studio
• ...and a whole lot more

For this course, we'll focus on these:

• Search
• Sheets
• Forms
• Data Studio

• ...but we will discuss the other ones, too
  • (for the rest, Just Google It™)

Google Search

• Beginner's guide to Google-fu
• Search Education
• Power Searching with Google

Gmail

• Huge storage space
• Easy to use UI
• One account to rule them all

YouTube

• 300 hours of video are uploaded to YouTube every minute
• almost 5 billion videos are watched on Youtube every single day
• great place to learn something new, for free

Google Drive

• single source of truth
• collaborating made easy
• auto-saves
• version control
• automation available

Google Docs

• writing more efficiently
  • voice typing
• docs.new

Google Sheets

• can be connected to different apps
  • e.g. Forms and Data Studio
• sheets.new

Google Slides

• easy to embed to different (Google) sites
• easy to add drawings, images, and video
• slides.new

Google Forms

• create surveys in minutes
• forms can be converted to a quiz
• can upload files directly to Google Drive
• forms.new

Google Apps Scripts

• make your own workflows!
• cloud-based scripting language
• able to access different Google Apps thru APIs
• see some examples

Google Data Studio

• turns your data into dashboards and reports that are:
  • informative,
  • easy to read,
  • easy to share,
  • and fully customizable
• view the gallery for examples

Remember the form you filled out a while ago?

This is the data now.

Feeling old yet?

Demo

Creating your own Data Studio Dashboard

Steps

1. Open Data Studio.
2. Create a Blank Report.
3. Add a new Data Source.
4. ???
5. Profit!

Data Source

• where the data for your reports will come from

Fields

• the different "columns" of the data you collected

Dimensions

• describes or categorizes your data
• adding dimensions to a chart groups the data by those dimensions

Metrics

• is the result of applying an aggregation to a set of values
• could come from the underlying data set, or be the result of implicitly or explicitly applying an aggregation function, such as COUNT(), SUM(), or AVG()

But there are more confusing terms!

Try checking this glossary.

Calculating Age

=INT(YEARFRAC($BIRTH_DATE_COLUMN2, TODAY()))

Working with checkboxes

=REGEXMATCH($MULTIPLE_CHOICE_COLUMN2, "some unique choice")

=REGEXMATCH($MULTIPLE_CHOICE_COLUMN2, "another unique choice")

Adding Data from another worksheet

=IFERROR(
  INDEX(IMPORTRANGE("GOOGLE_DOCUMENT_ID", "SHEET_NAME!$VALUE_COLUMN$1:$VALUE_COLUMN$100"),
    MATCH($KEY2, IMPORTRANGE("GOOGLE_DOCUMENT_ID", "SHEET_NAME!$KEY_COLUMN$1:$KEY_COLUMN$100"), 0)
  ),
  ""
)

Questions, concerns, clarifications, suggestions, violent reactions

Assignments

• Help our researchers help our farmers
• Try creating your own report in Data Studio
• Evaluation