Journalism 772 and 472: Computer-Assisted Reporting

Philip Merrill College of Journalism

University of Maryland

 

ACCESS EXERCISES FOR USERS OF OFFICE 2007

 

ACCESS 2007 EXERCISES:

 

Access Introduction:

Dams Dams98.mdb

Campaign contributions -- Contribs.mdb

 

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 2007 EXERCISES:

These files can be read in these versions of Excel: 5.0, 95, 97, 2000, 2002, 2003 and 2007.

Excel Exercise 1:

  • Tip sheets:

  Excel2007-Basics.pdf

Includes: Spreadsheet navigation, formulas, formats, and sorting

  • Data:

  Budget.xls

  SOFT100K_95-96.xls

  fatals.xls

  INS98_CROSSTABS-MD_DC_VA.XLS

 

Excel Exercise 2

  MDCENSUS.xls

  noinsure.xls

 

Excel Exercise 3

  Noinsure_clean.xls

  fatals.xls

 

Excel Exercise 4:

 

Excel -- in-class pivot-table exercise:

 

Excel Exercise 4A:

  • Data:

  coverage.xls

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

 

Excel Exercise 5:

  • Data:

  Review_SoftMoney.xls

  Review_Budget.xls

 

Excel Charts: