Section outline

  • Computer Lab: Filtering by form, queries, reports, and importing data

    Filtering by form. Writing select queries and reports for monitoring study progress. Importing data and appending and updating records.

    Faculty:  Michael Kohn, Josh Senyak, et al.

    Location:      Mission Hall 1400

    • Required Reading:

    • Optional Reading:

    • Assignment: Optional narrative description

    • Lab 3 Instructions File

    • Assignment Due Date: Make sure that you upload the completed Lab 3 Worksheet* and both of the rtf files, “LastnameCountsByRace1.rtf” made prior to importing the new 2007 records and “LastnameCountsByRace2.rtf” made after importing the new records by 8/18/2016 at midnight.

    • Lab 3 Assignment

      Upload Lab 3 files by clicking on the "Lab 3" link above.

      The link won't work unless you are logged in.

      The files should include should include the following:

      “LastnameCountsByRace1.rtf” made prior to importing the new 2012-13 records

      “LastnameCountsByRace2.rtf” made after importing and the new records

      Your completed Lab 3 worksheet.

    • Datasets:

    • InfantJaundiceStudyLab3.zip File

      This is a compressed (zip) file to improve download speeds.  You should extract it prior to using it.

    • Baby2012-2013 File