Week 7 – Tues., Oct 17 and Thurs., Oct 19

In Class:
The Most Timeless Songs of All Time (From The Pudding)
Tips for Writing with Numbers
-Really quick review of Intro to pivot tables in Excel
-Pivot Table Practice Quiz on Movie Trips using moviebus1.xls download (.xls)
-Guest speaker, Elinor Comlay, founder/editor of Route 40

Assignments:
For Thursday, read articles by Elinor Comlay, guest speaker:

-For next week, Quiz #2 (take home/open Internet) is due Tuesday, Oct 24 at start of class. No late work accepted. If you are absent, you must email it to me. (Worth 35 points)

 

Advertisements
Posted in Weekly Overview | Leave a comment

Quiz #2 (Fall 2017) due Tues, Oct. 24

Quiz #2 is open Internet, take home. Worth 35 points. It is due Tuesday, Oct 24 at the start of class. No late work accepted. If you are absent, you must email quiz to me. 

30 points for questions (1 point each)

5 points for two spreadsheets. Save your Highest Grossing Films and Gun Deaths spreadsheets. Name them with your initials (ie FilmsMBG and GunDeathsMBG) and email them to me. I need your spreadsheets so that I can see how you got your answers. You must email me completed spreadsheets to get full credit.

You can do the spreadsheets in Excel or Google sheets. If you want to use Google sheets, import a file, log into your Google account, then click Documents > Create new > Spreadsheet. Then, click File > Import > Browse. Next, select the file and click Open > Open now.

Questions 1-10 cover newsroom math. Use calculator and/or spreadsheet to answer the questions. All of the information you need to answer the questions was covered in:

Questions 11-20 cover basic Excel functions and formulas. Download and use 100 Highest Grossing Films (.xls) All of the information you need to answer the questions was covered in:

Note: When you are done answering these questions, save your completed FilmsYourInitials spreadsheet so you can email it to me.

Questions 21-24 covers interviewing a dataset. Download and use Gun Deaths spreadsheet (.xls). All of the information you need to answer the questions was covered in:

Questions 25-30 require you to create pivot tables. Use your Gun Deaths spreadsheet (.xls) All of the information you need to answer the questions was covered in:

Note: When you are done answering these questions, save your completed GunDeathsYourInitials spreadsheet so you can email it to me.

Posted in Quiz | Leave a comment

Week 6 – Tues., Oct. 10 and Thurs., Oct 12

In Class:
Cool sports data stuff from ONA
-Quick review of Basic newsroom math and statistics
-Quick review of Excel Tips – Part 1 
Excel Tips – Part 2: Math formulas and functions
-Excel Practice Quiz review (compare to my key spreadsheet)
Intro to pivot tables in Excel

Assignments:
-Basic Excel Practice Quiz on Broward County arrests using Practice Quiz Data download (.xls) for Thursday, Oct. 12

-CHANGE: DON’T WORRY ABOUT THIS. WE WILL DO IN CLASS NEXT WEEK Pivot Table Practice Quiz on Movie Trips using moviebus1.xls download (.xls) for Tuesday, Oct. 17.

Posted in Weekly Overview | Leave a comment

ONA Sports Data Inspiration

…from ESPN

Posted in Awesome Data Stuff | Leave a comment

Week 5 – Tues., Oct. 3 

In Class:
-Review Quiz #1 return
-Review Math take home practice quiz
-Finish up Basic newsroom math and statistics
-Excel Tips – Part 1  (Use Fake NJ Crime Stats spreadsheet)
-NO CLASS on Thurs, Oct. 5

Assignments:
-Complete the take home practice quiz on Excel Tips – Part 1 

Note: You can also do this with Google Sheets if you don’t have access to Excel at home. To import a file, log into your Google account, then click Documents > Create new > Spreadsheet. Then, click File > Import > Browse. Next, select the file and click Open > Open now.

Posted in Weekly Overview | Leave a comment

Week 4 – Tues., Sept. 26 and Thurs., Sept. 28

In Class:
-Review from last week
-Intro to FOIA
Activity: Interviewing data
Basic newsroom math and statistics
Complete Part 1 of Quiz #1 (Take Home). Due at start of class on Thursday, Sept. 28. No late work accepted.
-Review Weeks 1, 2 and 3 for Quiz #1: Part 2 (it will be open Internet/book) on Thursday, Sept. 28

Assignments:
Complete the take-home math for journalists practice quiz using:
Basic newsroom math and statistics
-Statistics Every Writer Should Know
-Newsroom Math crib sheet (pdf)

Posted in Weekly Overview | Leave a comment

Activity: Interviewing Data

Continue reading

Posted in In-class Activity | Leave a comment