CodeLesson
Instructor-Led Courses

Crunching Public Data

An instructor-led online course led by Jeffrey McManus.
Instructor
Jeffrey McManus has been a Web developer in Silicon Valley for fifteen years. He teaches Web Design and Management for the University of Victoria and is the CEO of Platform Associates. He's written six books on software development and frequently speaks at developer conferences. He likes popsicles.

Course Description

Go beyond the spreadsheet! Crunching Public Data is an introductory programming course intended specifically for public- and private-sector knowledge workers who want to make sense of data stored in tabular format, then analyze and visualize it in meaningful ways. In the course we make use of actual data from the US government site data.gov to give students real-world experience with data analysis, particularly with data sets in the megabyte to gigabyte range that are larger than spreadsheets can typically handle.

Course Outline

The programming language of instruction for this course is Python. Previous experience coding in Python is helpful, but not necessary.

  • Sourcing data: Strategies for tracking down source data
  • Reading tabular data files in code
  • Performing basic input and output
  • Aggregating tabular data
  • Creating, populating and querying SQLite databases
  • Data visualization strategies

Prerequisites

Format

Taught online. Instructor-led. 4 units. What's a unit?

A unit measures the time it takes to complete one of our instructor-led courses. Each unit normally requires about 4-6 hours of effort. We expect you'll do at most one unit per week. You may take more or less time to complete the course. Most of our courses are four units. We offer extended time if you need more time to complete the course.

CodeLesson courses are available to students 24 hours a day while the course is in session. That means you can participate in the course even if you have a busy daytime schedule or if you're located in a different time zone.

Courses are comprised of online and offline readings, weekly quizzes, online discussion topics, and hands-on coding exercises that are evaluated by the instructor. You can post questions about the coursework at any time and the instructor will provide guidance. You're never stuck on your own.

Copyright © 2010-2013, LessonPlex Inc. Support/Feedback. FAQ.