Section outline

  • Computer Lab: Excel: Good, Bad, and Ugly

    Early warning: This lab is due by midnight next Thursday August 9, 2018.  Lab 2 is due the following Thursday, and Lab 3 is not due for 3 weeks, but Lab 3 may take more time than Labs 1 and 2.  Even if you are able to do Labs 1 and 2 on your own, Lab 3 may require help from a TA or someone else who has completed it successfully.  The best way to get this help is to attend the in-person lab sessions and start early to see if you have trouble.

    Limitations of using Excel for research data entry and for sorting and querying data.  Data table structure -- Wide ("short-fat") vs. Long ("tall-skinny").

    Faculty:  Michael Kohn, Josh Senyak, et al.
     
    Location:      Mission Hall 1400

    • Optional Reading:

    • Assignment:

      Complete Lab 1 on Excel pivot tables.

    • Lab 1 Instructions File
    • MyResearch - Mac Instructions File
    • MyResearch Windows 10 Installation URL

    • Assignment Due Date: Complete Lab 1 Quiz and upload your Lab 1 Excel xlsx file, LASTNAME_Epi218ExcelLab1.xlsx, below by 8/09/2018 at midnight.

    • Lab 1 Quiz
    • Lab 1 Upload Assignment

      Upload LastName_Epi218Lab1Data.xlsx by clicking on the "Lab 1" link above.  The link won't work unless you are logged into the CLE syllabus site.

    • Datasets:

    • Epi218ExcelLab1Data.xlsx File