Module 2: Data Visualization

• Review
  • Discussion Board
  • DataCamp

• Watch this Video first!

• DataCamp: Introduction to Pivot Tables for Google Sheets

• Part 1
  • Video 2.1: Data Assembly
    • Compile a Colorado County Data Set
    • Download population data for all US counties
    • Download County GDP from the Bureau of Economic Analysis
    • Look up Congressional Districts for each Colorado County
  • Video 2.2: Pivot Tables
    • Complete Pivot Tables in Spreadsheets
    • Chapter 1 ONLY
    • Use a Pivot Table to aggregate GDP and Population by Congressional District
  • Video 2.3: Visualizing frequency distributions
    • Make a histogram
  • Video 2.4: Visualizing bivariate relationships
    • Make two scatterplots
• Part 2
  • Download US County Dataset
  • Create a Pivot Table
    • 49 rows and 4 columns
    • Each row corresponds to 48 States and Washington DC (Alaska and Hawaii are excluded)
    • Each column corresponds to four variables: Population, GDP, Median HH Income, Poverty %
    • Calculate the “Sum” for Population and GDP by State
    • Calculate the “Average” for Median HH Income and Poverty % by State
  • Create graphs (use Insert > Chart)
    • Use the resulting State aggregation (from the Pivot table)
    • Make four (4) histograms
      • (1) Population
      • (2) GDP
      • (3) Median HH Income
      • (4) Poverty %
    • Make four (4) scatter plots:
      • (1) Population (x) vs GDP (y)
      • (2) GDP (x) vs Poverty % (y)
      • (3) GDP (x) vs Median HH Income (y)
      • (4) Median HH Income (x) vs Poverty % (y)
    • All graphs must have axis labels
    • All scatter plots must include a “Trendline” along with labels for the “Equation” and “R^2 value” 

To submit your assignment in Bb, please “Share” your Google Sheets file and copy/paste the link.

Module 1: Intro to Data Analysis with Spreadsheets

In week 1 you will begin learning to analyze data in spreadsheets.

Assignment 1:

• Watch this video
• DataCamp
  • Click on this link to join my DataCamp classroom
  • Complete these two courses
    • Introduction to Spreadsheets
    • Data Analysis in Spreadsheets
• Troubleshooting
  • DataCamp is a bit temperamental. Here are a few tips.
  • Email account
    • The invitation link above (and here) is setup for the csupueblo.edu domain.
    • If you sign up using gmail or other personal email you won’t be connected to my classroom automatically.
    • The main benefit of having a classroom for you to connect to is free access to all premium content. Here are your options (unless you want to pay):
      • Use your pack.csupueblo.edu email when you create a new account. Use the email with your NAME not the one with your C123… number.
      • If you want to sign up with a different email, send me your preferred email address and I will create a separate invitation. 
  • Browser Refresh – duct tape for the internet
    • If you signed up successfully with your pack.csupueblo.edu email but you are still being prompted to pay for premium content try these steps.
      1. Kill your browser and restart.
      2. Use the invitation link to my classroom.
      3. Logout and log back in.
    • These steps typically resolve 90% of issues. If it doesn’t resolve your problem try the steps one more time and then email me.
    • During the courses DataCamp occasionally gets confused. Just refresh your browser and retry.
    • These issues can be annoying but when you’re thinking about complaining just remember that DataCamp makes all their premium content available to us at no cost. Also, I haven’t found anything better for teaching data analysis skills.

Introduction to Advanced Statistics Online

This course will consist of eight one-week modules, each module beginning Monday and ending the following Sunday. Each week you are responsible for contributing to Discussion forums in Bb and for completing an Assignment. I will provide descriptions and resources here each week and I will make an Announcement on Bb each time a new module post appears. Typically, I will also post one or more video lectures each week.

All assignments are due by 11:59pm on Sunday each week!

Here’s an introductory video.

Here’s a link to the course syllabus and below I’m providing some general guidelines for the asynchronous online format.

No Textbook! Don’t buy one. I use my own material.

Discussions:

• Each week you will earn up to 20 points by contributing to the discussion forums on Bb.
• Ask a question or share something you learned that saved you time or helped you understand the material. The idea is to be curious and promote understanding.
• Don’t regurgitate or summarize the material unless it’s part of a question or helpful insight.
• Submit comments or questions during the week, no later than Friday. If you wait until Sat or Sun your input won’t help you or anyone else. (That said, better late than never for scoring).
• Don’t login only once a week, make a few comments and logout 10 min later. I’ll notice if you’re doing the bare minimum.
• Don’t skip Discussion all together. If I see nothing, you’ll get 0/20.

Assignments:

• Follow instructions.
  • If I ask you to submit something via Bb or via Google Forms don’t email it instead. Grading is time consuming and handling special cases wastes my time.
  • Pay attention to format. If I ask you to submit an .xlsx file, don’t send a .pdf or other format.
• Make it easy for me to identify where you are answering a question. If I can’t find it you may not get credit.
• If you’re not sure what to do to complete an assignment, post a question on the discussion board! That’s the whole idea! Or you can send me an email if you prefer not to broadcast. Of course, this requires that you think about the assignment before 10p on Sunday.