CSCI N207 Distributed Education
DATA ANALYSIS USING SPREADSHEETS
Download Slides and Databases
Course materials:
| NUMBER | TOPICS | VIDEOS | MATERIALS |
Orientations |
|||
| 0a |
General Orientation |
 |
orientation.ppt |
| 0b | Class Orientation | |
ClassOrientation.pptx |
Unit 1 - Problem Solving |
|||
| 1 | STAIR | |
|
Unit 2 - Introduction to Databases |
|||
| 2 | a. What and Why Databases | |
2a-What&Why.pptx studentAdviser.accdb |
| b. Set up an Access Database | |
2b-DatabaseSetup.pptx WMCRM.accdb |
|
| 3 | Relational Model | |
3-relationalModel.pptx studentAdviser2.accdb WMCRM.accdb |
| 4 | a. SQL - Select | |
4a-SQL-Select.pptx WPC.accdb |
| b. SQL - Where | |
4b-SQL-Where.pptx |
|
| c. SQL - Built-in Functions | |
4c-SQL-Built-In.pptx SalariesByState.accdb |
|
| d. SQL - Join | |
4d-SQL-Join.pptx WPC2.accdb |
|
| 5 | Database Design | |
5-databaseDesign.pptx |
| 6 | Database Reports | |
6-databaseReports.pptx coffee.accdb Customers.pdf RevenueReport.pdf |
| 7 | Datab Import Export | |
7-dataImportExport.pptx OrderInformation.xlsx |
Unit 3 - Analysis with Spreadsheets |
|||
| 8 | Introduction to Spreadsheets | |
|
| 9 | Charts | ||
| a. Charts overview | |
||
| b. Bar chart | |
||
| c. Pie chart | |
||
| d. Line chart | |
||
| e. Scatter chart | |
||
| 10 | Univariate Analysis | ||
| a. Lecture | |
||
| b. Demonstration in Spreadsheets | |
||
| 11 | Multivariate Analysis | ||
| a. Lecture | |
||
| b. Demonstration in Spreadsheets | |
||
| 12 | Regression | ||
| a. Lecture | |
||
| b. Demonstration in Spreadsheets | |
||
Copy right 2009 @ Department of Computer and Information Science
Indiana Univeristy Purdue University at Indianapolis