VISUAL BASIC PROGRAMMING
CIS-32 / CIS-73 Course Outline - Fall 2008
INSTRUCTOR: Dan
McElroy
OFFICE: T-410 See http://unix.sjcc.edu/OfficeHours.htm
for office hours
PHONE: 298-2181 x 3235
E-MAIL: Dan.McElroy@sjcc.edu
TEXTBOOK:
Starting Out With Visual Basic 2005 3rd Edition
by Gaddis & Irvine- Addison Wesley ISBN 0-321-39399-6
COURSE OVERVIEW AND OBJECTIVES:
This course covers programming using
Microsoft Visual Basic. At the end of this course, the student will be able to:
- Use Visual Basic projects and programming tools to create
Windows applications
- Select and use constants and variables and identify their
lifetime and scope
- Create programs using arithmetic, logical and string
expressions
- Select alternate courses of actions using IF and CASE
statements and other VB controls
- Reduce program complexity using subroutine procedures and
user defined functions
- Implement iterative tasks using loops
- Create single-form and multi-form applications with menus
- Access databases using SQL queries
- Process lists of data using arrays
- Create programs using object classes
LAB ASSIGNMENTS:
Some of the lab assignments will take longer
than the time slot scheduled. It is expected that each student
will make use of the Open-Lab time to complete assignments as needed. Open-Lab
hours are made available to students registered in CIS courses and other
courses in the Business and Services Division at SJCC. Instructions will
be given during the first class meeting on how to use the open lab.
Programs turned in must include printouts of
both the program and the results of testing the program. Some labs may require
that a disk be turned in as part of the assignment. Programs will be graded on
whether they work, quality of output, program readability and appearance,
program construction and completeness of testing, and very importantly -
documentation.
LAB ASSIGNMENTS MUST INCLUDE:
1. Your name and UserID
2. Printouts of Visual Basic forms and code
3. The results of running the lab when available
4. A written description of the lab project in English.
ATTENDANCE:
You are expected to attend all class meetings.
If you are absent from either lecture or lab, it is your responsibility to
find out what you missed, and complete any assignments that were given. It
would be a good idea to make a friend or two with other people in the class
to share notes in the event that any of you are absent. Once
you have shown some commitment to the class by attending, participating in
quizzes, labs, or homework, I assume that you wish to be in the class. It
is your responsibility to drop the class if you do not wish to continue.
If you do not complete the course, and do not officially drop through the
Admissions office, you will receive a grade based on your completed work.
GRADING:
|
Homework
|
120 points
|
|
GRADING SCALE
|
|
Lab work
|
180 points
|
|
A = 90% - 100%
|
| Midterm
Exam |
100 points
|
|
B = 80% - 89%
|
|
Final Exam
|
100 points
|
|
C = 70% - 79%
|
| TOTAL |
500 points
|
|
D = 60% - 69%
|
| |
|
|
F = 0% - 59%
|
CIS 073 COURSE OUTLINE -- LECTURE
TOPICS
|
|
Date
|
Lecture and Lab Assignments |
|
9/2
|
Chapter
1—Intro to Programming and Visual Basic
—Homework—
1. Read the chapter. Make sure you understand key terms
2. Answer and turn in Short Answer questions
—Lab Assignments—
Run Tutorials 1-2 and 1-3
Enter
and run the
Paycheck Calculator program
Design and turn in the Carpet Size project (p37, #1)
|
|
9/9
|
Chapter
2—Creating
Applications with Visual Basic
—Homework—
1. Read
the chapter. Make sure you understand key terms
2. Answer and turn in True or False questions
—Lab Assignments—
Enter
and run the Highlander
Hotel (Tutorials 2-11, 2-12)
Enter and run the Kilo Converter
program (Tutorial
2-15)
Turn in the State Abbreviation program ( p.94, #4)
|
|
9/16
|
Chapter
3—Input
Variables, Exceptions, and Calculations
—Homework—
1.
Read the chapter. Make sure you understand key terms
2. Answer and turn in the Short Answer questions
—Lab Assignments—
Turn
in the
Theater Revenue program
(p.184, #4)
Turn
in the Hamburger
Store program
|
|
|
Date
|
Lecture and Lab Assignments |
|
9/23
|
Chapter
4—Making Decisions and Working with Strings
—Homework—
1.
Read the chapter. Make sure you understand key terms
2. Answer and turn in the Short Answer questions
—Lab Assignments—
Turn in
the Internet
Service Provider program
(p.269, #11)
|
|
9/30
|
Chapter
5—List, Loops, Validation and More
—Homework—
1. Read the chapter. Make sure
you understand key terms
2. Answer and turn in Short Answer questions
—Lab Assignments—
Turn in the Loan Calculator
program (p. 332, Tutorial 5-14)
Turn in the Rainfall Statistics
program (p.349, #5)
|
|
10/7
|
Chapter
6—Sub Procedures and Functions
—Homework—
1. Read the chapter. Make sure
you understand key terms
2. Answer and turn in Short Answer questions
—Lab Assignments—
Turn in the Joes
Automotive program (p404, #4)
|
|
10/14
|
MIDTERM
EXAM
|
|
|
|
Date
|
Lecture and Lab Assignments |
|
10/21
|
Chapter
7—Multiple Forms, Modules and Menus
—Homework—
1. Read the chapter. Make sure
you understand key terms
2. Answer and turn in Short Answer questions
—Lab Assignments—
Enter and turn in the Schedule
Builder program
(p.424 Tutorial 7-2)
|
|
10/28
|
Chapter
8—Arrays, Timers and More
—Homework—
1. Read the chapter. Make sure
you understand key terms
2. Answer and turn in Short Answer questions
—Lab
Assignments—
Choose two problems from Exercises 3, 4 or 5 on pages 549-551
|
|
11/4
|
Chapter
9—Files,
Printing and Structures
—Homework—
1.
Read the chapter. Make sure you understand key terms
2. Answer and turn in Short Answer questions
—Lab Assignments—
Turn
in the modified
Simple Text Editor program
(p.590-594) Tutorials 9-4 and
9-5)
|
|
11/11
|
Chapter
10—Working with Databases
—Homework—
1. Read the chapter. Make sure
you understand key terms
2. Answer and turn in Short Answer questions
—Lab Assignments—
Turn in BOTH Selecting Sales
Staff (p. 680, #1) and Sales Staff Salaries (p.680, #2) programs.
|
|
|
Date
|
Lecture and Lab Assignments |
|
11/18
|
Chapter
11—Developing
Web Applications
—Homework—
1.
Read the chapter. Make sure you understand key terms
2. Answer and turn in Short Answer questions
—Lab Assignments—
Turn
in the Kayak Tour program (p.707, Tutorial 11-3)
|
|
11/27
|
Chapter
12—Classes, Collections, and Scroll Controls
—Homework—
1. Read the chapter. Make sure
you understand key terms
2. Answer and turn in Short Answer questions
—Lab Assignments—
E-mail Address Book program (p. 796, Challenge
#1) All you need to complete is the ADD NEW NAME to the COLLECTION
of E-mail users.
|
|
12/2
|
Binary
and Random-Access Files
—Homework—
Assigned in class
—Lab Assignments—
Assigned
in class
|
|
12/9
|
More Topics—Graphics
and Animation
—Homework—
Assigned in class
—Lab Assignments—
Assigned
in class
|
|
12/16
|
FINAL EXAM
|
|
Visual Basic - List of Assignments
Fall 2008
|
Homework Assignment
|
Points
|
| Chapter 1 - Short Answer questions |
10
|
| Chapter 2 - True/False questions |
10
|
| Chapter 3 - Short Answer questions |
10
|
| Chapter 4 - Short Answer questions |
10
|
| Chapter 5 - Short Answer questions |
10
|
| Chapter 6 - Short Answer questions |
10
|
| Chapter 7 - Short Answer questions |
10
|
| Chapter 8 - Short Answer questions |
10
|
| Chapter 9 - Short Answer questions |
10
|
| Chapter 10 - Short Answer questions |
10
|
| Chapter 11 - Short Answer questions |
10
|
| Chapter 12 - Short Answer questions |
10
|
| TOTAL |
120
|
|
Exams
|
Points
|
| Midterm Exam |
100
|
| Final Exam |
100
|
| TOTAL |
200
|
|
|
| Lab Assignment |
Points
|
| Chapter 1 - Carpet Size |
10
|
| Chapter 2 - State Abbreviation |
10
|
| Chapter 3 - Theater Revenue |
10
|
| Chapter 3 - Hamburger Store |
10
|
| Chapter 4 - Internet Service Provider |
10
|
| Chapter 5 - Loan Calculator |
10
|
| Chapter 5 - Rainfall Statistics |
10
|
| Chapter 6 - Joe's Automotive |
10
|
| Chapter 7 - Schedule Builder |
10
|
| Chapter 8 - Two programs of your choice |
20
|
| Chapter 9 - Modified Simple Text Editor |
10
|
| Chapter 10 - Selecting Sales Staff |
10
|
| Chapter 10 - Sales Staff Salaries |
10
|
| Chapter 11 - Kayak Tour |
10
|
| Chapter 12 - Email Address Book |
10
|
| Extra Assignment - File Processing |
10
|
| Extra Assignment - Graphics |
10
|
| TOTAL |
180
|
|