CSCI 207  Programming in Visual Basic
Syllabus Sample Programs 
Week of: 
Tuesday 
Thursday 
1/29 
Chapter 1Introduction to Computers and Problem Solving
& Other Information about the course

Take Role & 1st day attendance

What is Programming?

What is a compiler?

Visual Studio Express Edition

Installing it

File management / Windows Explorer  Very Important!!!

Applied Technology minor

Getting started with our 1st VB Program

Importance of truly understanding the first few chapters

Terms

Don't underestimate the importance of knowing where you saved your program

Using the compiler

AWA  Alternate work assignments

When to meet in the Lab (Dundee in Ross Hall)

Designing a Program (Software Engineering)

What is an algorithm?

Flowcharts & Pseudocode

More notes

Link to download Visual Basic and some other tools.
Start our first walkthrough VB program.
Writing your first Visual Basic Project
1.
Set up workspace
2.
Start new project
3.
Set up Environment
4.
Plan
5.
Place Controls on Form
6.
Set Properties
7.
Write Code
8.
Run
9.
Save & reopen
10.
Modify
Do the Walkthroughs in chapter 2:
p. 23
·
Text Box
·
Button
·
Label
·
List Box 
9/05 
Chapter 2  Visual Basic Controls and Events

Controls and Events

Make sure you read this chapter carefully it covers fundamentals that are the building blocks of everything else.
I'll go over an example of a small program. 

9/12 
Chapter 3  Variables, Input, and Output
What is Critical Thinking?
Blooms Taxonomy
Start the HandsOn Programming Example 
 Very important chapter  Talk about strings  Bring in Questions!!
Continue with the HandsOn example
Inclass example :Compound Interest 
A = final amount

P = principal amount (initial investment)

r = annual nominal interest rate (as a decimal)

n = number of times the interest is compounded per year

t = number of years

9/19 
Chapter 4  Decisions 
If Statements

Case Statement

Boolean Math

Calling other event functions

Making one function handle more than one event

Let's try a problem requiring a decision in class: 
9/26 
Chapter 5  General Procedures

Sub Procedures

Function Procedures
Image Consulting Example
Review for Exam
Piece Work Calculator 
Exam 1 Will be on:

Chapters 1 thru 5

If Statement

Functions

Procedures

Boolean

Case Statement

10/3 
Go over the exam
Chapter 6  Repetition
 Loops  Do While  Do Until  For  Next Loops 
Let's start a project today
that will use loops for your take home project next week:
We'll write a program to run a linear
regression using leastsquares:
What is that? This is a way to
predict or model data where it is thought that one variable
effects the other. (Independent variable → dependent
variable)
This is done by taking known pairs of
data where is looks at though there is a correlation and
applying it to a clalculation.
Write a program where the users
enters in two pieces of data (paired) into a list box per
line separated by a comma. (You can change this if you want;
may be easier to have 2 list boxes) Grab that data and
run the leastsquares approximation formula.
Formula: (see below because this box
is too small)
Ok, so you all know that a straight
line uses the form y=mx+b where m is the slope and b
is the yintercept.
You are going to use the formula
below to get the m and b
Then provide some input for the
independent variable (m) and you tell the user y. Y
will be the predicted correlated value for m.
For example, If I gave you 30 pieces
of paired data that is height and weight, then I put in a a
height into an input box, click the button, your program
should predict this person's weight.

10/10 
No Class on the 11th:
Work on the Leastsquares project described above for your
out of class project
m= (n*(sum of x_{i} * y_{i})  (sum of x_{i})
* (sum of y_{i})) / (n * (sum of x_{i} * x_{i})
 (sum of x_{i})^{2} )
b = ((sum of y_{i})  m * (sum of x_{i}))/n
Make a functinons for:

sum of x_{i} * y_{i}

sum of x_{i}

sum
of y_{i}

sum of x_{i} * x_{i}

(sum of x_{i})^{2}

sum of y_{i}

10/17 
Chapter 7  Arrays
 More organized way to store a lot of related data  Some consider this the most complex topic of the course.  Not that hard, just another way to store a lot of related data.
Extra >Class example of the American to British Translations 
Array example in class. >
 Load states and their abbreviations into an array of records
 display
 find something
Save the states.txt file to the bin folder in the debug folder in the project folder.
Project>bin>debug>put text file here.

Let's compute the average of a list of numbers. Make sure you load the numbers into an array first. Then loop again and determine the average. We are using an array as practice.
List of Numbers
Maybe:
We can work on sorting Write a simple program that sorts a file, we can use the egg file from way back, Use either bubble or selection sort.
Eggs.txt
Example implementation of an array of Records.
Justices.txt 
10/24 
Chapter 8
 Text Files
Let's edit the Justice program, add some new
features. 
Let's do an old exam I dug up, I want you to give it an honest try first.
Sample Exam 2
If there's time let's assume they are not sorted, and we need to sort them first. 
10/31
Note: 11/4 is the last day to withdraw 
Let's do a practice exam today:
Load this file into an arrray of
strutures: Famous.txt
 Read the data in, put the name in one list box, the date
in another list box  Make a button that puts just the
people born in the 70's in the 2nd list box  Button that
displays their name and ages together in the 2nd list box;
sorted by birth date
 Exam 2

11/7 
Chapter 9 Additional Controls and Objects
Multiform Projects
Menu and Function Example  The extension of the piecework Calculator from last class.

Do an example in class of a project with a database connection 
11/14 
Chapter 10  Database 
Download:
Megacities
Gradebook 
11/21 
Chapter 12 
Web Applications  Making a web page with Visual Basic
Review for the Exam 
No Class,
Thanksgiving break 
11/28 
Continue working on the web application  no new material today
 Web Stuff:
Your web.config file uses
the
targetFramework="4.0"
attribute, which isn’t supported under IIS 6. In order
to upgrade to IIS 7, the server must be upgraded from
Windows 2003 to 2008.
remove the attribute from
the web.config file for the directory you specified
below, and it should work.

12/5 
Let's start the review. I'd like to go over more functions and procedures.
Show example that uses a function. 

Final Exam will be on 12/13 10:15 → 12:15 