Lesson 23: Pivot Tables in Spreadsheets

April 6, 2020

Trying something new today. Zoom has better video recording capability.

Join Zoom Meeting

https://csupueblo.zoom.us/j/157402034

Meeting ID: 157 402 034

Review:

• Covid-19 Data Analysis and Forecasting
• Stock Market Simulation Project
• Grades
• Cool Question Contest
• Schedule = DataCamp trilogy + final

DataCamp Options:

• Spreadsheet Track (Default)
  • Pivot Tables in Spreadsheets (Today’s focus)
  • Data Visualization in Spreadsheets
  • Financial Analytics in Spreadsheets

• Python Track (Alternative)
  • Data Manipulation with Pandas
  • Time Series Analysis in Python
  • Visualizing Time Series in Python

• Data Science Track (Optional – Extra Credit)
  • Data Science for Business
  • Machine Learning for Business
  • Data Visualization for Everyone
  • Choose your extra credit option:
    • 3 Quiz score upgrades (replace low scores, 1 per course)
    • Or, regain up to 50% points lost on Sim Project
    • Or, regain up to 50% points lost on previous DataCamp

Presentation:

• Track Covid-19 Cases in Colorado by County

Assignment:

• Work on DataCamp Assignments
• Email me if you plan to work on Python (instead of Sheets)
• Email me if you plan to do extra credit (optional Data Science Track)