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