Data Analysis

Module	Title	Lessons
1	Introduction, STAIR	Lesson 1
2	Computer Hardware	Lesson 1 Lesson 2 Lesson 3
3	Binary, Hexidecimal, and ASCII	Lesson 1 Lesson 2 Lesson 3
4	Computer Software	Lesson 1
5	Computer Security	Lesson 1
6	Webpages, Websites, and E-Commerce	Lesson 1 Lesson 2
7	Databases	Lesson 1
8	Introduction to Spreadsheets	Lesson 1
9	Charts	Lesson 1 Lesson 2 Lesson 3 Lesson 4 Lesson 5
10	Univariate Data Analysis	Lesson 1 Lesson 2
11	Multivariate Data Analysis	Lesson 1 Lesson 2
12	Regression	Lesson 1 Lesson 2

Programming Concepts and Data

This course contains video lectures as well as power point lectures which will cover the basic fundamentals of computing with history of programming languages and basic concepts of programming. This course also covers the basic web programming concept like HTML, JavaScript , in addition to that database concepts of normalization, joining and relational structure of database is also a part of this course, which will help the students to cover the basic concepts of programming and data.

Lecture	Video Segment	PPT Link To Source Code
Introduction
--	General Orientation	Orientation.ppt
--	Course Introduction	N201 Orientation.ppt
Problem Solving
1a	STAIR Problem Solving	STAIR.ppt Polya Summary Definition of Psuedocode
Background, History, and Fundamentals of Computing
2a	Fundamentals of Computing	Essence of Computing.ppt
2b	Lights, Legos, and Numbers	Binary Light Demo Brick Counting Demo
2c	Binary to Base 10	Conversion Reading
2d	Base 10 to Binary
2e	Basic Logic Gates	Tinker Toy Logic
Working With HTML
3a	Basic HTML	BasicHTML.ppt HTMLtemplate.html mozilla.org
3b	Links and Images	BasicHTML.ppt linkImage.html face.gif
3c	Formatting with Styles	BasicHTML.ppt formatting.html
History of Programming Languages
4a	History of Programming Languages	Language History.ppt
Machine Language
5a	Storing Data in ABNIAC	ABNIAC
5b	ASCII Representation in ABNIAC
5c	Addition and Looping in ABNIAC
Miracle
6a	Using Miracle	Miracle Miracle Summary miracleHello.ppt
6b	Building a Hello World	Miracle Miracle Summary miracleHello.ppt helloStair.doc
6c	Using Variables	variablesIO.ppt hiYouStair.doc Miracle Miracle Summary
6d	String Concatenation	variablesIO.ppt
Conditions
7a	Conditions and IF Statements	conditions.ppt
7b	Using the Else Clause
Using Loops
8a	Standard For Loops	forLoops.ppt
8b	Modifying For Loops
8c	Code Tracing	forLoops.ppt Code Tracing.doc
Loops Cont.
9a	While Loops	whileLoops.ppt
9b	Proper Loop Design
9c	Making a Flexible Loop
Javascript
10a	Introduction to Javascript	jsTemplate.html Javascript Chart Javascript Reference wallyAlgorithm.html wallyJavascript.html
10b	Form Based Input and Output	copy.html
Functions
11a	Basic Functions	This Old Man Demo
11b	Adding Parameters	Parametric Old Man
11c	Variable Scope	Scope Demo
Working with Arrays
12a	Basic Array	arrayDemo.html
12b	Array Man	arrayMan.html
12c	Two-Dimensional Arrays	distance.html
Introduction to Databases
13a	Introduction to Databases	databases.ppt
13b	Building a Database	demo.db buildDemo.sql databases.ppt Get eSQL
13c	Getting Specific Results	demo.db databases.ppt
13d	Intro to Relational Data Structures
13e	Creating an Inner Join
13f	Modeling Many to Many Joins
13g	Data Normalization

Principles of Computing

Course Description: Main objective of this course is to overcome fear of computers, show Wide range of applications and Strong programming skills to clear basic concepts and get solid background and solve problems of computing.

Unit	Video	PPT and HTML Links
1a	Introduction to Computing
1b	Basic problem-solving with STAIR	STAIR powerpoint
2a	The universal information manipulator	Essence of Computing powerpoint
2b	Lights, Legos, and Numbers	The binary light demo The brick counting demo
2c	Converting from binary to base 10
2d	Converting from base 10 to binary
3a	Basic logic gates
3b	Storing data in ABNIAC	ABNIAC
3c	ASCII representation in ABNIAC	ABNIAC
3d	Addition and looping in ABNIAC	ABNIAC