University of Michigan - Answering Interesting Questions with Data
- Offered byCoursera
- Public/Government Institute
Answering Interesting Questions with Data at Coursera Overview
Duration | 29 hours |
Mode of learning | Online |
Difficulty level | Intermediate |
Official Website | Go to Website  |
Credential | Certificate |
- Overview
- Highlights
- Course Details
- Curriculum
Answering Interesting Questions with Data at Coursera Highlights
- Earn a certificate from Coursera
- Add to your LinkedIn profile
Answering Interesting Questions with Data at Coursera Course details
- There is a huge amount of raw data available on the internet with endless potential
- This four-week course from the University of Michigan will help you learn how to read data in different formats and write programs to scrape data from the internet
- Once you complete this course, you'll be empowered with the ability to use data to answer high-level and interesting questions
- An essential component of data collection and analysis is the ability to store and manage the data effectively once you've retrieved it
- You'll learn how to use SQL to manage data in relational databases in order to create linked datasets and gain insight into the relationships and meaning that can be derived from your data
- Data is a powerful tool, but its potential can only be unleashed once it is converted and represented as logical information
- This process is referred to as data visualization, and it is key to understanding and analyzing data.
- You'll be taught to use charts, scatter plots, graphs, and other mediums in order to transform your data into valuable information that can be used to answer interesting questions
- This course is designed for learners who are interested in extending their Python knowledge, learning a textual programming language, or who would like to be able to communicate with programmers in a professional setting
Answering Interesting Questions with Data at Coursera Curriculum
Week 1: HTML and Beautiful Soup
Meet Dr. Barb Ericson
Welcome to the Course
How is This Course Different?
What is Python?
Why Work in Groups?
POGIL Roles
How to Write Code in the eBook
Reloading Your Code History
Welcome to the Week 1
Introduction to HTML
Fix HTML
The Document Object Model (DOM)
Attributes
CSS Classes
Introduction to Beautiful Soup
How to read sections on Beautiful Soup
find vs find_all
View page source and inspect HTML page elements
Why use class_ with find or find_all?
Create a Soup object from a URL
Syllabus
Community Engagement Article
Course Pre-Survey
Week 1 Overview
Exercise: Group Work
HTML Basics
Exercise: Group Work
More Group Work on HTML
Exercise: Ebook Work
Beautiful Soup
Assignment Brief
Scraping Web Pages with Beautiful Soup
Assignment Instructions
Scraping Web Pages with Beautiful Soup
eBook Login
Peer Instruction
HTML
Exercise: HTML Practice
Peer Instruction
Beautiful Soup
Exercise: Group Work
Beautiful Soup
Assignment Submission
Scraping Web Pages with Beautiful Soup
Week 1 Quiz
How to Work in Groups
Introduce Yourself
Where in the World Are You?
Peer Instruction Discussion
HTML
Peer Instruction Discussion
Beautiful Soup
Assignment Reflection
Scraping Web Pages with Beautiful Soup
End of Week 1 Discussion
Working with HTML and Beautiful Soup
Week 2: XML, JSON, and APIs
Welcome to Week 2
What is XML?
XML terms
Parsing XML
Fixing XML
What is JSON?
XML vs JSON
Processing JSON
What is an API?
Free APIs
API Authorization
Get JSON data from an API
Using Params to Specify API Parameters
Week 2 Overview
Exercise: Ebook Work
XML Reading
Exercise: Ebook Work
Parsing XML
Exercise: Ebook Work
Looping Through Nodes
Exercise: Ebook Work
JSON Reading
Exercise: Ebook Work
Parsing JSON
Exercise: Ebook Work
Application Programming Interfaces
Assignment Brief
Working with JSON and APIs
Assignment Instructions
Working with JSON and APIs
Peer Instruction
XML
Exercise: XML Practice
Peer Instruction
JSON
Exercise: JSON Practice
Assignment Submission
Working with JSON and APIs
Week 2 Quiz
Peer Instruction Discussion
XML
Peer Instruction Discussion
JSON
Assignment Reflection
Working with JSON and APIs
End of Week 2 Discussion
XML and JSON
Week 3: Databases and SQL
Welcome to Week 3
Why use a Database?
Intro to SQLite
How to Download DB Browser
Exploring a database with DB Browser
Introduction to SQL in DB Browser
Basic SQL Statements
Using Python to Execute SQL
More SELECT Keywords
Using Python to Select Data
Using Python for SQL Statements
Using fetchone and fetchall
Week 3 Overview
Exercise: Ebook Work
What is a Database?
Exercise: Ebook Work
Database Concepts
Exercise: Ebook Work
Intro to DB Browser
Exercise: Ebook Work
Creating a Database Table
Exercise: Ebook Work
SQL Summary
Exercise: Ebook Work
More SELECT Keywords
Assignment Brief
Storing API data in a Database
Assignment Instructions
Storing API data in a Database
Peer Instruction
Database
Exercise: Database Practice
Peer Instruction
More SQL
Exercise: More SQL Practice
Exercise: Database Practice
Assignment Submission
Storing API data in a Database
Week 3 Quiz
Peer Instruction Discussion
Database
Peer Instruction Discussion
More SQL
Assignment Reflection
Storing API data in a Database
End of Week 3 Discussion
Relational Databases and SQL
Week 4: More Databases and Visualizing Data
Welcome to Week 4
Intro to Spidering Twitter
Code for spidering twitter
Code for multiple tables
Code with JOIN
Goals for Database Design
Intro to OMDB
Tables for OMDB
Types of keys and best practices
What is Matplotlib?
Why plot data?
Key Terms
Example Plots
Enhancements
Example Pie Chart
Plotting Michigan and Georgia data
Paired bars
Week 4 Overview
Exercise: Ebook Work
Spidering Twitter using a database
Exercise: Ebook Work
Basic Data Modeling
Exercise: Ebook Work
Multiple Tables
Exercise: Ebook Work
Three kinds of keys
Exercise: Ebook Work
Using JOIN
Assignment Brief
Selecting Data and Creating Figures
Assignment Instructions
Selecting Data and Creating Figures
Course Post-Survey
Peer Instruction
Database Join
Exercise: Ebook Work
Practice with SQL JOIN
Peer Instruction
Matplotlib
Exercise: Ebook Work
Matplotlib practice
Assignment Submission
Selecting Data and Creating Figures
Week 4 Quiz
Peer Instruction Discussion
Database Join
Peer Instruction Discussion
Matplotlib
Assignment Reflection
Selecting Data and Creating Figures
End of Week 4 Discussion
Visualizing Data
End of Course Recap
Other courses offered by Coursera
Student Forum
Anything you would want to ask experts?
Useful Links
Know more about Coursera
Know more about Programs
- Teaching & Education
- Middle School
- Physical Education
- Pre Primary & Primary School
- Secondary & Sr. Secondary School
- Nursery & Primary Teacher Training (NPTT)
- Special Education
- Nursery Teacher Training (NTT)
- Early Childhood Care & Education (ECCE)
- Vocational Education
- Pre Primary Teacher Training (PPTT)
- Primary Teacher Training (PTT)