IUPUI

CSCI N207 | Data Analysis With Spreadsheets

All-Inclusive Lecture File Pack
Lecture Number Lecture Title Runtime Files Link
00 Class Orientation 00:11:04 lecture00.zip
Watch the Lecture
01 STAIR 00:26:03 lecture01.zip
Watch the Lecture
02 A What & Why Database? 00:21:17 lecture02_a.zip
Watch the Lecture
02 B Create an Access Database 00:23:26 lecture02_b.zip


Watch the Lecture
02 B Demo 01 Opening an Existing Access Database 00:12:02 Watch the Lecture
02 B Demo 02 Create a New Access Database 00:24:01 Watch the Lecture
03 Relational Model 00:32:42 lecture03.zip

Watch the Lecture
03 Demo Relational Model 00:15:24 Watch the Lecture
04 A SQL - SELECT Statement 00:21:08 lecture04_a.zip

Watch the Lecture
04 A Demo SQL - SELECT Statement 00:23:37 Watch the Lecture
04 B SQL - WHERE Clause 00:16:14 lecture04_b.zip

Watch the Lecture
04 B Demo SQL - WHERE Clause 00:17:27 Watch the Lecture
04 C SQL - Built-in Functions 00:22:40 lecture04_c.zip

Watch the Lecture
04 C Demo SQL - Built-in Functions 00:20:02 Watch the Lecture
04 D SQL - JOIN Operations 00:25:17 lecture04_d.zip

Watch the Lecture
04 D Demo SQL - JOIN Operations 00:14:53 Watch the Lecture
05 Database Design 00:27:35 lecture05.zip

Watch the Lecture
05 Demo Database Reports 00:17:01 Watch the Lecture
06 Database Reports 00:16:33 lecture06.zip
Watch the Lecture
07 Data Import Export 00:05:45 lecture07.zip

Watch the Lecture
07 Demo Data Import Export 00:09:11 Watch the Lecture
08 Spreadsheet Introduction 00:59:59 lecture08.zip
Watch the Lecture
09 A Charts 00:17:46 lecture09_a.zip
Watch the Lecture
09 B Column/Bar Charts 00:15:58 lecture09_b.zip
Watch the Lecture
09 C Line Charts 00:13:03 lecture09_c.zip
Watch the Lecture
09 D Pie Charts 00:08:49 lecture09_d.zip
Watch the Lecture
09 E Scatter Charts 00:10:53 lecture09_e.zip
Watch the Lecture
10 A Univariate Analysis Part 1 00:18:19 lecture10_a.zip
Watch the Lecture
10 B Univariate Analysis Part 2 00:27:06 lecture10_b.zip
Watch the Lecture
11 Multivariate Analysis 00:20:24 lecture11.zip
Watch the Lecture
12 A Regression Analysis Part 1 00:21:17 lecture12_a.zip
Watch the Lecture
12 B Regression Analysis Part 2 00:19:06 lecture12_b.zip
Watch the Lecture