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

 

LINK TO CLASS WEB SITE:

Download this page to keep in your H drive for quick access to the class web site

 

NOTE: We have switched in the labs to using Access 2007 and Excel 2007. The tip sheets below were prepared using the previous versions of Access and Excel and will be of use to you if you are using these older versions to work on the exercises at home. . Some of the key visual differences in Access 2007 are explained in this guide: Access2007_tips.pdf

 

ACCESS EXERCISES FOR USERS OF OFFICE 2003 or EARLIER VERSIONS:

 

AccessIntroduction:

  • Tip sheet: AccessFiltering.pdf
  • Data: Campaign contribution database used in introduction to Access

      Access 2002 version: Contribs.mdb

      Access 2000 version: Contribs_ACCESS2000.mdb

      Access 97 version: Contribs_ACCESS97.mdb

 

Access Exercise 1:

  • Data: Soft Money

      Access 2002 version: SOFT100K_96CYCLE.mdb

      Access 2000 version: SOFT100K_96CYCLE_ACCESS2000.mdb

      Access 97 version: SOFT100K_96CYCLE_ACCESS97.mdb

 

Access Exercise 2:

      Access 2002 version: hunting.mdb

      Access 2000 version: hunting_ACCESS2000.mdb

      Access 97 version: hunting_ACCESS97.mdb

 

Access Exercise 3:

 

Access Exercise 4:

      Access 2002 version: mdr.mdb

      Access 2000 version: mdr_ACCESS2000.mdb

      Access 97 version: mdr_ACCESS97.mdb

      Access 2002 version: Sofla.mdb [same content as Contribs.mdb]

      Access 2000 version: Sofla_ACCESS2000.mdb

      Access 97 version: Sofla_ACCESS97.mdb

 

Access Exercise 5 (review exercise):

 

Access Exercise 6 (review exercise):

  • Data: Service Difficulty Reports

      Access 2002 version: sdrs772.mdb

      Access 2000 version: sdrs772_ACCESS2000.mdb

      Access 97 version: sdrs772_ACCESS97.mdb

 

Access Enterprise Join Exercise (for optional class session):

 

Access Data import example:

 

 

 

EXCEL EXERCISES FOR USERS OF OFFICE 2003 or EARLIER VERSIONS:

These files can be read in these versions of Excel: 5.0, 95, 97, 2000, 2002 (XP), 2003.

Excel Exercise 1:

      Excel-Getting_Around.pdf

      Excel-Formulas.pdf

      Excel-Formatting.pdf

      Excel-Sorting.pdf

  • 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:

 

Excel Exercise 5:

  • Data:

      Review_SoftMoney.xls

      Review_Budget.xls

 

Tip sheet: Excel_Charting.pdf

 

 

 

DATA ANALYSIS PROJECT DATA: Link