Course home page Syllabus Resources

 

Journalism 772 and 472: Computer-Assisted Reporting

Philip Merrill College of Journalism

University of Maryland

 

Links for files to download for class exercises and projects

 

NOTES: The labs in Knight Hall have been upgraded to the Office 2010 versions of Access and Excel. If you are using an older version, here is a link to tip sheets and exercises for the Office 2007 versions of Access and Excel and a link to tip sheets and exercises for the Office 2003 versions of Access and Excel. You will need to become familiar with the 2010 versions since these will be used for work in class, including exams and projects.

 

ACCESS 2010 EXERCISES:

 

Access Introduction:

Dams Dams98.accdb

Campaign contributions -- Contribs.accdb

 

Access Exercise 1:

 

Access Exercise 2:

 

Additional features for exploring Access tables:

 

Access Exercise 3:

 

Access Exercise 4:

 

Access Exercise 5 (review exercise):

 

Access Exercise 6 (review exercise):

 

Access Enterprise Join Exercise (for optional class session):

 

Access Data import example:

 

 

EXCEL 2010 EXERCISES:

 

Excel Exercise 1:

  • Tip sheets:

  Excel2010-Basics.pdf

Includes: Spreadsheet navigation, formulas, formats, and sorting

  • Data:

  Budget.xlsx

  SOFT100K_95-96.xlsx

  fatals.xlsx

  INS98_CROSSTABS-MD_DC_VA.XLSX

 

Excel Exercise 2

  MDCENSUS.xlsx

  noinsure.xlsx

 

Excel Exercise 3

  Noinsure_clean.xlsx

  fatals.xlsx

 

Excel Exercise 4:

 

Excel -- in-class pivot-table exercise:

 

Excel Exercise 4A:

  • Data:

  coverage.xlsx

  SOFT100K_95-96.xlsx (same file as used in Exercise 1)

 

Excel Exercise 5:

  • Data:

  Review_SoftMoney.xlsx

  Review_Budget.xlsx

 

Excel Charts:

 

DATA ANALYSIS

        PROJECT DATA: [Link to be added later]

        ADDITIONAL TOOLS WE MAY EXPLORE AS NEEDED:

o   Access 2007:

         The Switch function

         The Partition function

         Pivot Tables

         Pivot Charts

         Make-Table Queries

         Subqueries, or queries of queries

         Fixing city names (Making new lookup tables)

o   Moving between Access and Excel:

         Transferring query results: Access-Excel_2010_transfer.pdf

o   Excel 2007:

         Charts

         Printing

o   Mapping:

         With Batchgeocode.com

  Site: www.batchgeocode.com