Data Science with Excel/Sheets
- Intro to data
- Descriptive stats nearpod
- Geyser, baseball data, d.o. data
- measures of central tendency exercises
- visualizing data nearpod
- practice data sets and best graph choices
- go find a data set of interest, put in sheets, calculate relevant mean/median/mode/std dev and make two graphs.
- nearpod plotting and representing data reviews
- graphing quiz
- stats break - data visualization assignment. Pick one, explain why you like it and why it's good. (see instructions on resource page).
- correlation/regression - https://sites.google.com/site/statisticsforspreadsheets/ ??? maybe just demonstrate p values and logistic regression? (http://www.biostathandbook.com/simplelogistic.html)
- Chi-square? explanation and demonstration. Single example?
- t-tests - explain and demonstrate. Use http://www.biostathandbook.com/onesamplettest.html, http://www.biostathandbook.com/twosamplettest.html, http://www.biostathandbook.com/pairedttest.html and for calculations - https://www.graphpad.com/quickcalcs/ttest1.cfm
- t-test mini project
- data technique and its use in the real world. Small group presentations with screen sharing.
- Designing an experiment PPT and creation assignment.
- Actually carry out experiment and do project to end Unit 1.
Tableau Unit
Topic Sequence for Tableau Unit
Day by day schedule WIP- Start with section 1 (see above).
- Hands on with step-by-step guidelines to get a brief look at Tableau
- Music Sales
- Basic Skills (Tableau Student Guide 1-5)
- Calculations
- Basic Skills pt 2 (Tableau Student Guide 6-8)
- Mix of Three Components. Alternate between Lynda, Data Literacy, and Data Viz. Lynda for self-guided software practice, Data Literacy and Data Viz curriculums for theory lectures and mini practice activities:
- Lynda Curriculum - Tableau Essential Training (2020.1)
- Used for Step-by-Step activities. Contains videos, exercises and files to download. Covers:
- Data prep, joins
- Worksheets and workbooks
- Calculations
- Analysis
- Sorting/Filtering
- Groups and sets
- Crosstabs and pivots
- Creating, formatting, and annotating visualizations
- Maps
- Dashboards
- Used for Step-by-Step activities. Contains videos, exercises and files to download. Covers:
- Data Literacy Curriculum from Tableau Communities
- Used for reinforcement of ideas/concepts as well as theory. Covers:
- Asking the right questions
- Data and field types (review/extension)
- Aggregations and Granularity (review of sum, average, etc.)
- Distributions (extension topic)
- Statistical Thinking (review/extension/THEORY)
- Correlation and Regression (review/extension)
- Visualization Best Practices
- Used for reinforcement of ideas/concepts as well as theory. Covers:
- Data Visualization Curriculum from Tableau Communities
- Reinforcement and theories on best practices for visualizations. Covering:
- Visual perception
- Design approaches
- Infographic creation
- Interactivity
- Mapping
- Reinforcement and theories on best practices for visualizations. Covering:
- Lynda Curriculum - Tableau Essential Training (2020.1)
- Tableau Final Project (see below for topics)
- Determine Topic of Interest
- Collect, refine, clean data sources
- Perform analysis (EDA, also any data transformations required)
- Create EDA charts/graphs
- Interactives - dashboards, etc.
- Infographic - formatting, annotation of visualizations
Day by day schedule WIP- Start with section 1 (see above).
- Lynda Tableau Essential Training lessons 2 and 3 - coverage of loading data, basic joins, creating/editing workbooks, etc.
- How to clean data and what is meant by Tidy Data:
- Reading from "The Elements of Data Analytic Style" - ch 2 and 3. - provides context and background on data formatting and what you are seeking from your analysis
- Using the Tableau Data Source page:
- Run through OpenClassrooms "Create a Dashboard with Tableau" sections 4,5, and 6. (https://openclassrooms.com/en/courses/5873606-create-a-dashboard-with-tableau/6690746-load-a-dataset-into-tableau) for lesson 4. Data downloads on that site but also on resource page here
- MakeoverMonday projects should be happening to test student skills
- Lynda - finish units. Skip Crosstabs for now. Make sure students cover annotations and formatting
- Discover insights challenges:
- Netflix (data.world/chasewillden/netflix-shows) - add additional questions
- Airbnb (insideairbnb.com) - create questions and host on classroom
- Wildlife Strikes dataset. Use prompts such as:
- Make a map of ...
- Create a bar chart of ...
- Final projects (2):
- Report on an environmental issue using a dashboard and short accompanying writeup. Must contain:
- At least 3 variables of data (4 columns with id as first column). May need to merge datasets.
- Map(s), charts/graphs, annotations,
- Sliders, etc. allowing user to explore/filter data.
- Data Self-Portrait
- Create a dashboard.story of one or more aspects of your life through data. Examples in "Code as Creative Medium".
- No write-up necessary for this project.
- Can be broad and wide-ranging or narrowly focused.
- Report on an environmental issue using a dashboard and short accompanying writeup. Must contain:
Extra Credit Assignment (ignore for now)
Each student has an opportunity to earn extra credit by completing one additional assignment. The subject / topic and data set used must be approved by the instructor, and work on the extra credit assignment must be by individual only (no group extra credit assignments).
Students may select one of the two options below for their extra credit assignment. Please note that you must complete all requirements of the assignment to be eligible for full credit:
1) Participate in Andy Kriebel’s Makeover Monday Project (http://www.makeovermonday.co.uk/)
a. Andy Kriebel’s makeover Monday dataset is published every Sunday. Use any Sunday dataset and create a makeover of the chart using the provided data.
b. Publish your Makeover (ex. blog post about your redesign, post to Tableau Public and/or Twitter)
2) Create an Infographic
a. Identify a dataset (for example, information about schools performance in Ohio, economic reports, government or corporate report, etc.) that would make a good infographic
b. Redesign or create an infographic using the dataset you found
3) Pick a topic from Dear-Data.com or Dear-Data-Two.com and create your own post card. You are welcome to mail it to someone you know, but please take a high resolution picture of both sides of the card to submit for your extra credit assignment.
See Examples:
Each student has an opportunity to earn extra credit by completing one additional assignment. The subject / topic and data set used must be approved by the instructor, and work on the extra credit assignment must be by individual only (no group extra credit assignments).
Students may select one of the two options below for their extra credit assignment. Please note that you must complete all requirements of the assignment to be eligible for full credit:
1) Participate in Andy Kriebel’s Makeover Monday Project (http://www.makeovermonday.co.uk/)
a. Andy Kriebel’s makeover Monday dataset is published every Sunday. Use any Sunday dataset and create a makeover of the chart using the provided data.
b. Publish your Makeover (ex. blog post about your redesign, post to Tableau Public and/or Twitter)
2) Create an Infographic
a. Identify a dataset (for example, information about schools performance in Ohio, economic reports, government or corporate report, etc.) that would make a good infographic
b. Redesign or create an infographic using the dataset you found
3) Pick a topic from Dear-Data.com or Dear-Data-Two.com and create your own post card. You are welcome to mail it to someone you know, but please take a high resolution picture of both sides of the card to submit for your extra credit assignment.
See Examples:
- by Giorgia Lupi and Stefanie Posavec
- by Jeffrey Shaffer and Andy Kriebel
- Intro Tableau Workbooks
- Music Sales (1)
- thetableaustudentguide site (2):
- Fundraising - creating calculations (3)
ArcGIS Unit
- Power of Maps - motivation for the unit. Utility and joy of maps
- Map Book Gallery - find 3 maps and for each one detail:
- What is shows
- Why you like it
- What data is used
- Start here. The ArcGIS book from Esri.
- Units utilize web platform almost exclusively.
- Broad range of topics and applications.
- Includes intro readings for each unit.
- From there use lessons from:
- Visionmaker NYC (understanding NYC ecology using GIS)
- Current Events section (Covid)
- Featured Lessons
- Getting Started - broad array of topics including:
- Imagery and Remote Sensing
- Demographics
- Symbolizing Data and Cartography
- ArcGIS Dashboards
- Additional ideas:
- Calculate change in land usage in Brazilian rainforest (Amazon). Using NDIV satellite imagery?
- Examine water encroachment during Sandy
- Heat Island effects over time?