Category Archives: Uncategorized

Week 14 – April 21

Please log into Canvas shell for Data Journalism and fill out the course evaluation “Student Rating of Instruction” located at the top under University Policies and Important Information. The Final Project is worth a total of 100 points of your total grade for … Continue reading

Posted in Uncategorized | Comments Off on Week 14 – April 21

Week 13 – April 14

The Final Project is worth a total of 100 points of your total grade for the semester. Here are five parts to this assignment. (See detailed requirements for each here.)

Posted in Uncategorized | Comments Off on Week 13 – April 14

Week 12 – April 7

Assignment 3: Data Visualizations due Sunday, April 7 Monday, April 8 at 11:59pm (Worth 75 points)  The Final Project is worth a total of 100 points of your total grade for the semester. Here are five parts to this assignment. (See detailed requirements for each here.)

Posted in Uncategorized | Comments Off on Week 12 – April 7

Week 11 – March 31

Assignment 3: Data Visualizations due Sunday, April 7 at 11:59pm (Worth 75 points)  The Final Project is worth a total of 100 points of your total grade for the semester. Here are five parts to this assignment. (See detailed requirements for each here.)

Posted in Uncategorized | Comments Off on Week 11 – March 31

Final Project Overview – Spring 2024

Goal: To produce a publishable feature story using data and visualizations. The Final Project is worth a total of 100 points of your total grade for the semester. Here are five parts to this assignment. (See detailed requirements for each below.) *Late … Continue reading

Posted in Uncategorized | Comments Off on Final Project Overview – Spring 2024

Week 10 – March 24

Guest speaker Stephen Stirling, who is currently a data editor for Philadelphia Inquirer. Check out some of his work on his website and come with questions. Working on Graded Assignment 3: Data Visualizations due Sunday, April 7 at 11:59pm (Worth 75 points) 

Posted in Uncategorized | Comments Off on Week 10 – March 24

Week 9 – March 17

-Assignment 2 Grades are posted in Canvas  – Let me know if you have questions –Inverted Pyramid of Data Journalism (revisited) –Lecture: Intro to Infographics and Visualizations –Making Infographics Using Google Tools and Google Sheets –Data Visualization 101 (Visage + Hubspot) –What’s … Continue reading

Posted in Uncategorized | Comments Off on Week 9 – March 17

Assignment 3: Data Visualizations

Worth 75 points -Late work subject to 25% reduction Due Sunday, April 7 at 11:59pm in Canvas The goal of these assignments is create a series of infographics and visualizations that demonstrate what you have learned this semester and that … Continue reading

Posted in Uncategorized | Comments Off on Assignment 3: Data Visualizations

Week 8 – March 3

–COUNT, COUNTA and COUNTUNIQUE in Google Sheets –Intro to Cleaning Data–Basic Formulas for Cleaning with Google Sheets-In-Class Exercise: Data Cleaning Assignment 2: Data Analysis (Worth 50 points) is due Friday, March 8 at 11:59pm or before you leave for break.  Follow the instructions … Continue reading

Posted in Uncategorized | Comments Off on Week 8 – March 3

COUNT, COUNTA and COUNTUNIQUE in Google Sheets

Google Sheets has function for counting data that we often use in pivot tables. The three useful ones for our purposes are: COUNT – Tally range of values with numerals COUNTA – Tally range of values cells with text and/or … Continue reading

Posted in Uncategorized | Comments Off on COUNT, COUNTA and COUNTUNIQUE in Google Sheets