home
techred home > dat-220

DAT-220: Visualization | Carlow University | Spring 2023

course wk no. date session links learning objectives completion targets
DTAN-203 1 Monday
9-JAN-2023

Categorize data into branches and associate branches with visualization techniques

Complete most if not all of the visualizations requested of our class music

DTAN-203 Wednesday
11-JAN-2023
  1. Assemble five songs of interest in our tracker spreadsheet
  2. Duplicate the sheet into your own google drive account
  3. Add an additional 3 variables (not of the same type) to the spreadsheet

Create basic charts in Google Sheets to respond to inquiry questions of interest to the class

DTAN-203 2 Monday
16-JAN-2023

{no class} Martin Luther King Jr. Day

DTAN-203 Wednesday
18-JAN-2023
  • Articulate the data visualization high-level process
  • Demonstrate spreadsheet essentials: add/move columns, create new sheets, write formulas, write cross-sheet formulas: manipulate the essentials of the chart tool in google sheets
  • Implement the data visualization process for an inquiry question related to our music data set

Create a visualization using google sheets (or your chosen visualization tool) that addresses 2-3 of the inquiry questions in our project.

Submit your work by simply having your visualuzations in your dedicated google drive folder for the music project.

DTAN-203 3 Monday
23-JAN-2023

Harnessing the power of pivot tables

Create a pivot table from raw data

Pursue an inquiry question using pivot table rows, columns, and filters

Investigate one or more substantial inquiry questions using a pivot table and create both a focused pivot table and one or more charts from that pivot table to address your question.

For Monday, 30-JAN, please have selected a few questions and attempted at least a pivot table to address one or all of your chosen questions.

DTAN-203 Wednesday
25-JAN-2023

Pivot tables to charts

Data formats and time series data and using data functions

Use date functions to generate component date values for time series plots

DTAN-203 4 Monday
30-JAN-2023

Worktime on 311 Pivot Tables

Create beautifl charts using pivot tables

Choose a topic for our change through time project and log it in our tracker.

DTAN-203 Wednesday
1-FEB-2023

Choose a variable or set of variables of interest to you concerning world-wide change and assemble a set of compelling inquiry questions related to those variables.

DTAN-203 5 Monday
6-FEB-2023

Develop compiled data sets about our change through time project.

DTAN-203 Wednesday
8-FEB-2023

DTAN-203 6 Monday
13-FEB-2023

DTAN-203 Wednesday
15-FEB-2023

DTAN-203 7 Monday
20-FEB-2023

DTAN-203 Wednesday
22-FEB-2023

DTAN-203 8 Monday
27-FEB-2023

DTAN-203 Wednesday
1-MAR-2023

DTAN-203 xxx Monday
9-JAN-2023
Wednesday
11-JAN-2023

SPRING BREAK: NO CLASSES

DTAN-203 9 Monday
13-MAR-2023

DTAN-203 Wednesday
15-MAR-2023

DTAN-203 10 Monday
20-MAR-2023

DTAN-203 Wednesday
22-MAR-2023

DTAN-203 11 Monday
27-MAR-2023

DTAN-203 Wednesday
29-MAR-2023

DTAN-203 12 Monday
3-APR-2023

DTAN-203 Wednesday
5-APR-2023

DTAN-203 13 Monday
10-APR-2023

DTAN-203 Wednesday
12-APR-2023

DTAN-203 14 Monday
17-APR-2023

DTAN-203 Wednesday
19-APR-2023

DTAN-203 15 Monday
24-APR-2023

DTAN-203 Wednesday
26-APR-2023

DTAN-203 16 FINAL
???
?-MAY-2023