homepage

courses

previous -- view my teaching portfolio here

Instructions for downloading files

 

 

Buffalo State College

Databases and the Data Science Information Life Cycle, DSA 610

 

Course Description (from the College):  Introduction to a “big picture” understanding of data flow for strategic, data-driven decision making, including data storage, data organization, data gathering and preparation, exploratory data analysis, and meaningful visualizations and communication. Includes hands-on practice.. (3 credits)

 

Syllabus -- in Word format
     

Homework

Important Dates
Final Project -- Due Monday, May 10th

more detailed schedule in the syllabus

Email List

via Blackboard

 

Announcements:

Buffalo State
Office:
My BSC voicemail:
My BSC email: mccallb@buffalostate.edu
Office Hours: by appt

 

Answer Keys



Homeworks to be Turned in

Homework #1 -- Data
Homework #2 -- Data
Homework #3
Homework #4 -- Data
Homework #5 -- Data
Homework #6 -- Data
Homework #7 -- Data
Homework #8 -- Data
Homework #9 -- Data

 

Practice Labs & Class Notes

2/1 N E J E 2/8 N E J C T E
  2/22  J N E
   
   
   
   
   

 

Projects

Project #1 -- Data
Project #2 -- Data
Project #3 -- Data
Final Project -- Data set options posted in Blackboard

 

Handouts

 

 

 

 

Links:

Data Lifecycle
Data Lifecycle Management
The Lifecycle of Data
16-Step Lifecycle
Data Lifecycle, Best Practices
Data Lifecycle Management (DLM)
Data Analytics Lifecycle
Data Protection and Information Lifecycle Management
The Data Science Lifecycle

Excel Easy
Data Analysis in Excel
Excel 2016+
Microsoft Excel Video Training

SQL Tutorial
Learn SQL
SQL Basics for Beginners
SQLite Tutorial
Beginners' Guide to SQLite
SQL Query Cheet Sheet
SQL Tutorial
SQL Tutorial for Beginners
Interactive SQL Course

10+ Free Python Books
Python for Beginners
Learn Python
Which Library should I use for my Python Dashboard?
Best Python Data Visualization Libraries

Big Data: How is it generated?
Data Capture
Data Classification
Types of Data Classification
Data Classification
Ethics of Data Collection
The Murky Ethics of Data Gathering in a Post-Cambridge Analytica World
What is Data Validation?
Data Privacy
5 Things to Know about Data Privacy

Data Storage
Data Storage: Emerging Technologies
Data Lakes vs. Data Warehouses
Data Security
Most Common Passwords
Spreadsheets vs. Databases
Relational Databases
Definition and Overview of ODBMS
Object-Oriented Databases and Advantages

JSON Databases
JSON Interchange Standard
JSON vs. XML
What is JSON?
Importing XML into Pandas

Data Maintenance vs. Data Cleansing
Tips to Maintaining Your Data
Data Management
History of Data Management
Data Management: A Cheat Sheet

Stats NZ
Public Datasets (List of Sources)

Color Brewer (for maps)
Color Brewer for Python

PDF Graph Paper
I Will Derive song
How to draw Greek
GraphCalc
Free Online Math Courses
Mathnotes
Coding

 

 

 
(c) 2019, 2010, 2008, 2004 by Betsy McCall, all rights reserved
To contact the webmistress, email betsy@pewtergallery.com
Last updated: 2019 August 23rd