Data Science Spring 2020 - Section 5

Jan 14

Jan 16

Introduction

Data is Everywhere

ICE 1.1 – Data is Everywhere

Session 1 Readings 

Jan 21

Jan 23

A Brief Introduction to Data

Identifying Sources of Data

Excel Basics – review on your own

ICE 2.1: Building a Data Dictionary  

ICE 2.2: Excel Intro

Jan 21: Quiz 1

Jan 21: ICE 2.1

Jan 28

Jan 30

Learning to (Mis)trust Data

Introduction to Tableau – in class demonstration

ICE 3.1: Assessing Trustworthiness of Data Sources

ICE 3.2: Getting Familiar with Tableau  

Jan 28: Quiz 2

Jan 28: ICE 3.1

Jan 30: ICE 3.2

Feb 4

Feb 6

Viewing Data

ICE 4.1: The Day the Music Died

ICE 4.2: Gotta Catch Em All

Feb 4: Quiz 3

Feb 4: ICE 4.1

Feb 6: ICE 4.2

Feb 11

Feb 13

Communicating Using Data

Storytelling with Infographics

ICE 5.1: Telling a Story through Visualization  

 ICE 5.2: Creating Infographics with Piktochart  

Feb 11: Quiz 4

Feb 11: Assignment 1

Feb 13: ICE 5.2

Feb 18

Feb 20

Exam 1 – Study Guide Announcement

Exam 1 – Review

Data used in Exam Review

Exam 1 (Feb 20)

Feb 25

Feb 27

Dirty Data

Data Cleansing

ICE 7.1: Locating “Bad Data” Using Excel

Feb 25: Quiz 5

Feb 27: ICE 7.1

Feb 27: Students pick their groups for Assignment 3

Mar 10

Mar 12

Choosing Relevant Data

Evaluating Key Performance Indicators

 ICE 8.1: Identifying Key Performance Indicators

ICE 8.2: Visualizing Key Performance Indicators

Mar 10: Quiz 6

Mar 12: ICE 8.2

Mar 12: Assignment 2

Mar 17

Mar 19

Connecting Diverse Data

Creating Interactive Dashboards

ICE 9.1: Connecting Data Sets

ICE 9.2: Creating Interactive Dashboards

Mar 17: Quiz 7

Mar 17: ICE 9.1

Mar 19: ICE 9.2

Mar 24

Mar 26

Exam 2 – Study Guide Announcement

Exam 2 – Review

Exam 2 (Mar 26)

Mar 31

Apr 2

Storing and Retrieving Data

Using Tableau to Aggregate Data

 ICE 11.1: Creating a Simple Database

 ICE 11.2: Working with “Pivot Tables” in Tableau

Mar 31: Assignment 3 proposal submission (100-word limit)

Mar 31: Quiz 8

Apr 2: ICE 11.2

Apr 7

Apr 9

Beyond Numbers

Twitter Sentiment Analysis using Excel

ICE 12.1: Manually Determining the Sentiment of Textual Data (if time permits)

ICE 12.2: Sentiment Analysis Using Excel

Apr 7: Quiz 9

Apr 7: ICE 12.2

Apr 14

Apr 16

Predicting the Future

Predictive Analytics Using Tableau

Exam 3 – Study Guide Announcement

Exam 3 – Review (Apr 16)

ICE 13.1: Simple Predictive Analytics Using Tableau

Apr 14: Quiz 10

Apr 14: ICE 13.1

Apr 21

Apr 23

Group Presentations (Apr 21)

EXAM 3 (Apr 23 – Class time )

Apr 21: Assignment 3

Apr 3o: All missed items (quizzes, ICEs, assignments) due without extra penalty