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