Homework for Wednesday, Oct 12: Pivot Tables, LaRoche

Part 1: Pivot tables

Pivot tables are a powerful tool in Excel to analyze and tabulate complex spreadsheets.

Follow the instructions on this NICAR tipsheet called pivot tables.. You will be using a practice dataset called worldbank.

Assignment Due 11:59 pm Wednesday Oct. 12:

Create a pivot table using WorldBank.

#1 Following the NICAR handout instructions, create a list of the top countries on this disbarment list. Sum up the violations and then sort the list, highest to lowest.

Save these on separate tabs on a single spreadsheet and upload it to a blog post on WordPress.

Part 2: Research The Wall Street Journal and Michelle LaRoche.

Post two questions for her. They can range from career questions to how the WSJ operates. I will call on you Thursday to ask these questions. Thanks.

Meet Thursday in Lemke Newsroom, Kimpel 112

Summary LaRoche Resume:

Experience

Editor, Development
The Wall Street Journal
August 2013 – Present (3 years 2 months)Greater New York City Area

Managing Editor, Real-Time Desks
Dow Jones
February 2012 – Present (4 years 8 months)Greater New York City Area

Editor, Training and Recruiting
Dow Jones Newswires
April 2008 – February 2012 (3 years 11 months)

Assistant Managing Editor, Dow Jones News Service
Dow Jones & Co. Inc.
August 2004 – March 2008 (3 years 8 months)

Director, Corporate Information Services
Dow Jones Newswires
February 2002 – August 2004 (2 years 7 months)

Education
University of New Hampshire
Bachelor of Arts (B.A.), English/Journalism
1991 – 1995

FYI

Contest – Create a funny video about going back to school – win an Adobe Cloud subscription.

http://hacktoschoolcontest.com/