Course Overview

Hui Hu Ph.D.

Department of Epidemiology

College of Public Health and Health Professions & College of Medicine

January 7, 2019



Virtual machine setup

Linux terminal and Git


Key Points on Syllabus

  • Instructor Information and Office Hours
  • Course Content
  • Attendance and Participation
  • Homework
  • Course Project
    -  Proposal
    -  Final report

Instructor Information and Office Hours

  • Hui Hu, PhD
  • Office: CTRB 4224
  • Email:
  • Phone: 352-294-5944
  • Office hours: By appointment

Tell us

  • your name
  • what degree program you are in
  • what programming languages you are familiar with
  • what data engineering skills you want to learn from this course

Course Content

  • Course Overview
    - VM setup, R crash course
  • SQL
    - Basic SQL
    - Data models and relational SQL
    - Many-to-many relationships in SQL
  • Access web data
    - Query APIs
  • Spatial data
    - PostGIS
  • NoSQL databases
    - MongoDB
  • Big Data
    - Spark


  • Attendance is mandatory
  • UF policy for excused absences applies (must notify instructor in writing before class when possible)
  • Each unexcused absence results in a 1.5% deduction from the final grade
  • >3 unexcused absences results in failure


  • 6 homework assignments
    -  10% each
    -  the highest 5 grades will count towards the final grade
  • Often simple programming exercises
  • Requirements:
    -  turn in assignment no later than 11:59 pm on the day it is due
    -  late assignment will NOT be accepted
    -  no handwritten assignment
    -  DO NOT copy others' work

Course Project

Option A

Option B

Pick one article from a list of publications (which will be made available mid-February), and write codes to reproduce its data engineering and descriptive analyses

Come up your own ideas for the course project. It is required to include at least ONE non-traditional data source (e.g. spatial data, web data, etc.) other than the traditional survey data

Course Project (continued)

  • You can work individually or work as a team
  • If choose to work as a team:
    -  each team can have up to 2 members
    -  clearly delineate roles and responsibilities of each team member
  • Project Due:
    -  Feb 18, 2019: form a project team
    -  March 11, 2019: project proposal
    -  Apr 15, 2019: final presentation
    -  Apr 22, 2019: final project report


  • Project proposal:

    -  Cover Page: Include title and list of team members.

    -  Project description: Up to one (1) page.

    -  Literature cited (no page limit); please follow the Vancouver style.
    Proposals must use single column and single spacing; Arial or Times New Roman font; font size no smaller than 11 point; tables and figure labels can be in 10 point; 0.5 inch margins.

o Specific Aims/Objectives: for those choosing option A, please cite the article you’d like to reproduce and briefly summarize the specific aims/objectives of the article. For those choosing option B, please state your aims/objectives.

o Data Source: please provide details about the data and how it can be accessed

o Preliminary Data Pipelines: please briefly describe the data engineering steps involved in this project

o Timeline


  • For those choosing option A, the project report should be structured as an R Markdown Notebook, with all the codes and explanations to the codes.
  • For those choosing option B, please structure the report to include:
    -  Title (14 point typeface) and names of each team member
    -  Abstract: no more than 250 words summarizing the project.
    -  Introduction: a short background and objective(s) of the study.
    -  Methods: design, setting, dataset, approaches, and main outcome measurements.
    -  Results: key findings
    -  Discussion: key conclusions with direct reference to the implications of the methods and/or results.
    -  References: please follow the Vancouver style.


  • Attendance and participation: 5%
  • Homework: 50%
  • Project proposal: 5%
  • Final project presentation: 10%
  • Final project report: 30%

Virtual Machine Setup

Linux Terminal and Git


By Hui Hu


Slides for Lecture 1, Spring 2019, PHC7065 Critical Skills in Data Manipulation for Population Science

  • 422
Loading comments...

More from Hui Hu