DATA 301 Online Notes and Course Materials
Dr. Ramon Lawrence

Lecture Notes

All Notes in 1 PDF file

The complete set of notes can be downloaded below or purchased from the book store.

All Course Notes (6 slides per page)

Schedule with Notes and Readings

Date	Topic and Notes	Exercises, Examples, and Resources
Thurs. January 4	Introduction Handouts, Color Slides	What Does a Data Analyst Make? Programming needed for top jobs Microsoft Data Science Class (ed-X)
Tues. January 9	Data Representation Handouts, Color Slides, Answers	Excel practice file: fileEncodings.xlsx Big Data Industry Facts Data Sizes Growing Global Mobile Data Text to ASCII Converter Create your own QR Code How Much Social Media Data?
Thurs. January 11 Tues. January 16	Excel Handouts, Color Slides, Answers	Sample Excel Document: sales.xlsx Download Office Free (UBC) LOOKUP Function Reference Advanced Filters Reference How to use Sparklines Excel Shortcut Keys
Thurs. January 18	Excel Scripting Handouts, Color Slides, Answers	Sample Excel VBA Document: vba.xlsm Five Ways to Use the Immediate Window
Tues. January 23 Thurs. January 25 Tues. January 30	Databases Handouts, Color Slides, Answers	Sample Access Database: WorksOn.accdb Codecademy SQL course SQLFiddle WorksOn DDL
Thurs. February 1	Command Line Handouts, Color Slides, Answers	Codecademy Learn Command Line Using Redirection Operators in Windows
Tues. February 6 Tues. February 20 Thurs. February 22	Python Handouts, Color Slides, Answers	Python Notebook (Anaconda) Python Fiddle - Online Python Editor ideone - Online Python Editor Codecademy Labs Codecademy Learn Python Python Practice Online Think Python (free online book) Learn Python Online Python Code Samples: Print questions (slide #13) Variable/expressions questions (slide #23) String questions (slide #34) Input/output questions (slide #39) Decision questions (slide #51) Loop questions (slide #63) List questions (slide #71) Dictionary question (slide #74) Function questions (slide #83)
Thurs. February 8	Midterm exam #1 in class.
Tues. February 13 Thurs. February 15	No class during midterm break.
Tues. February 27 Thurs. March 1	Python Data Analysis Handouts, Color Slides, Answers	BioPython - Python library for biological/bioinformatics computation BioSQL - a relational model for bioinformatics data MySQL Python Connector Psycopg - Postgres Python Connector NCBI Nucleotide Database NCBI Blast Service Comparison of Python Graph Libraries Convert Python Graphs to D3.js Format for Browsers Pygal - Python Chart Library NumPy Library scikit-learn (machine learning) Python Library pandas (data structures) Python Library Python Map, Reduce, Lambda Functions Tutorial Python Map/Reduce Tutorial Python Code Samples: Read from a file (slide #4) Write to a file (slide #5) Check if file is closed (slide #6) Process a CSV file using split (slide #7) Using CSV module to process a CSV file (slide #8) List files in a directory (slide #9) File questions (slide #11) Retrieve and print web page contents (slide #14) Google search example (slide #15) Send data using PUT to web page (slide #16) Web questions (slide #18) try-except example (slide #21) try-except question (slide #24) Biopython FASTA (slide #28) Biopython transcription (slide #29) Biopython Entrez database search (slide #30) Biopython BLAST (slide #31) Biopython BLAST parse results (slide #32) Biopython BLAST question (slide #33) matplotlib bar chart (slide #35) matplotlib histogram (slide #37) matplotlib probability histogram (slide #38) matplotlib bar chart question (slide #39) Linear Regression using SciPy (slide #41) k-means Clustering using SciPy (slide #42) SciPy regression question (slide #44) Query on MySQL (slide #47) Question on MySQL (slide #48) Map-Reduce example (slide #50) Map-Reduce question (slide #52)
Tues. March 6 Thurs. March 8 Thurs. March 15	Data Analysis with R Handouts, Color Slides, Answers	Download R Download RStudio Car Sample Data CSV File Province Population Data CSV File Athlete Sample Data CSV File Introduction to R (official documentation) Beginner's Guide to R Spurious Correlations (fun) 10 Great R Packages PrintEven Function Question (slide #34) List Question (slide #44) Data Frame Question (slide #50) Charts Question (slide #60) Hypothesis Testing Question (slide #85)
Tues. March 13	Midterm exam #2 in class.
Tues. March 20	GIS Handouts, Color Slides, Answers	Google My Maps Documentation Sample ESRI Maps (beautiful) UBC Invasive Species Animated Maps Google Maps Tutorial Using Google My Maps to Create a Travel Plan Google Maps API Google Maps API Tutorial (w3schools.com) Python Wrapper for Google Maps API Google Maps API Python Example
Thurs. March 22 Tues. March 27	Data Visualization Handouts, Color Slides, Answers	Sample Tableau Workbook Data is Beautiful (visualizations/analysis) Download Tableau (with course key in Connect) Download Tableau (14-day trial) Download Tableau Database Drivers Tableau Your Data! (ebook) Tableau Your Data (textbook web site)
Thurs. March 29	Open Data Handouts, Color Slides Course Summary and Final Exam Review Handouts, Color Slides	10 Rules for Data Storage Gapminder (How not to be ignorant about the world) Open Data Canadian Federal Government British Columbia Open Data City of Kelowna Open Data United States Government Open Data Washington State Open Data UK Open Data WorldBank Open Data United Nations Open Data OECD Quandl Kaggle Best Buy open data API NCBI databases ChEMBL SureChEMBL ChemSpider Machine Learning repository Game path finding benchmarks National Climatic Data Center Polar data catalog CERN (LHC) Canadian Astronomy Data Centre National Space Science Data Center Digital Archive Database Project (UBC) Google Analytics Academy (4 to 6 hours)
Tues. April 3 Thurs. April 5	Demonstration of graduate student data analytics projects
Thurs. April 12 at 6 p.m.	Final Exam at 6 p.m. in FIP 204

Sample datasets