Files, handouts and readings for my UNL class

Class 10 -- 12/16/2010

• Stats_recap.ppt (Review of material covered this semester)
• Spycraft.ppt (Ideas for making sure the identities of confidential sources remain secret)
• NYTmovies.xls (spreadsheet of NYTimes top 1.000 movies, as we created in class)
• CARreport.doc (assignment instructions for written report due Jan. 13)

Class 9 -- 12/2/2010

• CrimesByCity2009tab.txt (tab-delimited data)
• CrimesByCity2009csv.txt (comma-delimited data)
• CrimesByCity2009.prn (fixed width data)
• Excelfunctions.xls (practice with functions)
• stats_lecture_07.ppt (Slides on Probability)
• PT_census.ppt (Slides about the Portuguese Census 2011)

Class 8 -- 11/25/2010

• PT_export_import_with_US.xls (Export/import data)
• stats06.ppt (Statistics lecture on economic data)

Class 7 -- 11/18/2010

• School_ranks_2010.xls (In-class school scores exercise)
• Stats_lecture_05.ppt (Statistics lecture on correlation dangers)

Class 6 -- 11/11/2010

• PT_president_vote_2001_2006_exercise.xls (In-class election exercise, and homework)
• PT_president_vote_2001_2006_exercise.txt (This is the same data as above, but in text format in case you have the same problem we had in class. Download this and open it in Excel. If Excel asks, tell it the delimiter between variables is the "tab" character.
• stats_lecture_04.ppt (Statistics lecture on correlation and regression)

Class 5 -- 4/11/2010

• Election_exercise_for_class.xls (In-class election exercise)
• Stats_lecture_3.ppt (Statistics lecture on bell-shaped data and graphics)

Class 4 -- 28/10/2010

• Deaths_by_city.xls (Deaths by city spreadsheet for exercise and homework)
• Excel_pivot_tables_PT_ExcelPC.doc (How to create Excel pivot tables using Excel 2007 on a PC)
• Excel_pivot_tables_PT.doc (How to create Excel pivot tables on older Excel)


• CrimesByCity2009.xls (Crimes by city spreadsheet for exercise)
• PT_president_vote_2001_2006.xls (Spreadsheet of Portugal presidential election returns from 2001 and 2006)
• Stats_lecture_2.ppt (Statistics lecture 2 slides)

Class 3 -- 14/10/2010

• Public_records_lecture.ppt (Public records lecture slides)
• Stats_lecture1.ppt (Statistics lecture 1 slides)

Class 2 -- 7/10/2010

• HomeworkCrimesByCity2009.xls (data for homework questions)
• ExcelHomeworkLesson2.doc (tip sheet for Excel homework)


• Excel for Journalists lecture (Ppt, 1.6Mb)
• Newsroom math lecture (Ppt., 740kb
• Newsroom Math Cheat Sheet (Word doc)
• Newsroom math online and printed resources (Word doc)

Class 1 -- 30/9/2010

• Computer assisted reporting lecture (Powerpoint, 4.2Mb)
• Assignment 1 handout (Word doc)
• Legal Leaks Toolkit (pdf)
• "Journalism Education at Universities and Journalism Schools in Portugal" (pdf)