Author Archives: admin
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
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.)
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.)
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.)
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
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)
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
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
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
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