Week 6 – Mon., Feb. 19 and Wed., Feb. 21

In Class:
-Data J Picks of the Week:

Excel Practice Quiz #1 review
Excel Tips – Part 2: Math formulas and functions
–Intro to Pivot Tables

Assignment:
-Complete Excel Tips – Part 2 and questions (if you don’t in class)
-Keep practicing Excel on your own until you are confident.
Excel Practice Quiz #2 due Monday, Feb. 26

Advertisements
Posted in Weekly Overview | Leave a comment

Excel Practice Quiz #1 – Spring 2018

Answer the following questions using demodataSp18 and Excel Basics Crib Sheet

Continue reading

Posted in Quiz | Leave a comment

Week 5 – Mon., Feb. 12 and Wed., Feb. 14

In Class:
-Data J Picks of the Week (Math Where You Might Not Expect It):

-Basic newsroom math and statistics

-Quiz 1 and 2 review
Inverted pyramid of data journalism
Interviewing data
-Interviewing Data with basic spreadsheet functions -(download demodataSp18 spreadsheet) and use Excel Basics Crib Sheet
-How to Import Excel Spreadsheet into Google Sheets

Assignments:

Read and Review:
-Basic newsroom math and statistics
-Statistics Every Writer Should Know
-Newsroom Math crib sheet (pdf)

Do the Excel Practice Quiz (due Monday, Feb 19) using demodataSp18 spreadsheet) and
Excel Basics Crib Sheet
-Excel Tips – Part 1: Format, sort, filter, total
Excel Tips – Part 2: Math formulas and functions

If you don’t have access to Excel over weekend, you can Import Excel Spreadsheet into Google Sheets

Posted in Weekly Overview | Leave a comment

Quiz #2 answers

Continue reading

Posted in Quiz | Leave a comment

How to Import Excel Spreadsheet into Google Sheets

Log in to Gmail

Creat a new Google Sheet

Drive
>New
>Google Sheet

In Google Sheet…

File
>Import
>Upload
>Select file
>Open
>Create a new spreadsheet
>Open New

Posted in How To, Resource | Leave a comment

Week 4 – Mon., Feb. 5 and Wed., Feb 7

In Class:
-Quiz #2 (covering Weeks 1, 2 and 3)
Inverted pyramid of data journalism
Interviewing data
Lecture: Intro to Cleaning Data
Four Common Ways to Clean Data in Excel
Example: Interviewing and cleaning data

Assignments:
-Complete Quiz #1 (Take Home)Due at start of class on Wed, Feb. 7. No late work accepted.
Quiz #2 on Weeks 12 and 3 (it will be open Internet/book) on Wed., Feb. 7

-Read DJH Become Data Literate in 3 Simple Steps
-Read DJH Basic Steps in Working with Data

Posted in Quiz, Weekly Overview | Leave a comment

Week 3 – Mon., Jan. 29 and Wed., Jan. 31

In Class:
-Data J Pick of the Week –The Most Timeless Songs of All Time (From The Pudding)
NJ Scavenger Hunt review
Intro to FOIA
Inverted pyramid of data journalism
Common Data File Types
Intro to scraping

Assignments:
-Read DJH – Your Right to Data
-Complete Quiz #1 (Take Home)Due at start of class on Wed, Feb. 7. No late work accepted.
-Review Weeks 1, 2 and 3 for Quiz #2 (it will be open Internet/book) on Wed., Feb. 7

Posted in Weekly Overview | Leave a comment