CSCI N207

CSCI N207 Distributed Education

DATA ANALYSIS USING SPREADSHEETS

Download All Files

Course materials (You MUST use Firefox to download 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		8-spreadsheetIntro.pptx OrderInformationSample.xlsx
9	Charts
	a. Charts overview		9a-charts.pptx distortion.xlsx
	b. Column chart		9b-columnCharts.pptx salaryThreeStatesColumnChart.xlsx
	c. Line chart		9c-lineCharts.pptx OrderInformationLineChart.xlsx
	d. Pie chart		9d-pieCharts.pptx OrderInformationPieChart.xlsx
	e. Scatter chart		9e-scatterCharts.pptx indianaScatterChart.xlsx multipleCharts.xlsx
10	Univariate Analysis
	a. Part One		10a-univariate-part1.pptx revenue.xlsx
	b. Part Two		10b-univariate-part2.pptx revenue.xlsx
11	Multivariate Analysis		11-multivariate.pptx multivariate.xlsx
12	Regression Analysis
	Part One		12a-regression-part1.pptx
	Part Two		12b-regression-part2.pptx regression.xlsx

Copyright 2010 @ Department of Computer and Information Science
Indiana Univeristy Purdue University at Indianapolis