CIS 73 Green Sheet

VISUAL BASIC PROGRAMMING
CIS-73 Course Outline - Spring 2010

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: Visual Basic 2008 How to Program by Deitel & Deitel, Pearson/Prentice-Hall 2009 ISBN: 0-13-605305-X

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 scheduled class time. 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. 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. However, you may be dropped by the instructor if it appears that you are not participating in the class by submitting regular course work. If you do not complete the course, and do not officially drop through the Admissions office and are not dropped by the instructor, you will receive a grade based on your completed work.

In other words, if you want to stay in the class, you need to submit work on a regular basis or your may be dropped. If you want to drop the class, you should drop the class by one of the drop dates to make sure it happens for the best result on your transcript..

GRADING:

Homework

60 points

GRADING SCALE

Lab work

270 points

A = 90% - 100%

Final Exam

80 points

B = 80% - 89%

TOTAL
410 points

C = 70% - 79%

D = 60% - 69%

F = 0% - 59%

CIS 073 COURSE OUTLINE -- LECTURE TOPICS, LAB AND HOMEWORK ASSIGNMENTS

Week
Date

Lecture Topic
Chapter numbers refer to
Visual Basic 2008 How to Program

Lab Assignment
Page numbers refer to
Visual Basic 2008 How to Program

Homework
Page numbers refer to
Visual Basic 2008 How to Program

Points this week

Week 1
Feb 2
Class Orientation
Chapter 1 Intro to Computers
Operating Systems, Visual Basic

Paycheck Program Copy the code and a screen-shot of your visual design into a Word document and e-mail them to the instructor. (10 points)

Read Chapter 1 and do the Self-Review Exercises. Do not turn in the Self-Review Exercises for any of the chapters.

Answer questions from Exercises 1.4 through 1-13 pages 32-33. E-mail these answers to the instructor. (10 points)
20

Week 2
Feb 9
Chapter 2 Visual Basic IDE
Help, Variables
GUI Design Exercises 2.8, 2.9, 2.10 and, 2.12 pages 69-72. Copy a screen-shot of each exercise into a Word document and e-mail to the instructor. (10 points)
Read Chapter 2 and do the Self-Review Exercises.

Answer questions from Exercises 2.3 through 2.7 page 68. E-mail these answers to the instructor. (10 points)
20

Week 3
Feb 16
Chapter 3 C# Applications
Text formatting, Equality and Rational Operators Smallest-Largest-Average Exercise 3.15 page 120
Pos-Neg Count Exercise 3.17 page 120.
Copy the code for each program in to a Word document and e-mail to the instructor. (10 points each)
Read Chapter 3 and do the Self-Review Exercises.

Answer questions from Exercises 3.7 through 3.13 pages 120-121. E-mail your answers to the instructor. (10 points)
30

Week 4
Feb 23
Chapter 4 Intro to Classes and Objects
Methods, Parameters Invoice Program Exercise 4.11 page 160. Copy the class code, the test application and a screen-shot showing the results of your program execution into a Word document and e-mail to the instructor. (10 points)
Read Chapter 4 and do the Self-Review Exercises.

Answer questions from Exercises 4.5 through 4.8 page 159. E-mail your answers to the instructor. (10 points)
20

Week 5
Mar 2
Chapter 5 Control Statements-1
Control Structures, if.else, while, loops, ++/-- Mileage Program Exercise 5.9 pages 219-220. Copy the class code, the test application, and a screen-shot showing your program has correctly processed three sets of data into a Word document and e-mail to the instructor. (20 points)
Read Chapter 5 and do the Self-Review Exercises.
20

Week 6
Mar 9
Chapter 6 Control Statements-2
for do..while, switch, break, continue, Logical Operators Price Code Program Exercise 6.4 page 264. Copy the class code, the test application, and a screen-shot showing your program execution into a Word document and e-mail to the instructor. (20 points)
Read Chapter 6 and do the Self-Review Exercises.
20

Week 7
Mar 16
Chapter 7 Methods
Packaging, static methods & Variables, Class Math, Parameters, Random Numbers, Recursion Parking Program Exercise 7.10 page 331. Copy the class code, the test application, and a screen-shot showing your program execution into a Word document and e-mail to the instructor. (20 points)
Read Chapter 7 and do the Self-Review Exercises.
20

Week 8
Mar 23
Chapter 8 Arrays
for each passing arrays, multidimensional arrays, command-line args Airline Reservation Program Exercise 8.9 page 395. Copy the class code, the test application, and a screen-shot showing your program execution into a Word document and e-mail to the instructor. (20 points)
Read Chapter 8 and do the Self-Review Exercises.

Answer questions from Exercise 8.5 page 393. E-mail your answers to the instructor. (10 points)
30

Break
Mar 30
Spring Break / Cesar Chavez Day
No classes held 3/29 - 4/4 Break ! Break !

Week 9
Apr 6
Chapter 9 LINQ
Collections Invoice LINQ Query Program Exercise 9.3 page 415. Copy the class code, the test application, and a screen-shot showing your program execution into a Word document and e-mail to the instructor. (20 points)
Read Chapter 9 and do the Self-Review Exercises.
20

Week 10
Apr 13
Chapter 10 Classes and Objects
this reference, indexers, garbage collection, delegates Microwave Oven Program Exercise 10.11 page 482. Copy the class code, the test application, and a screen-shot showing your program execution into a Word document and e-mail to the instructor. (30 points)
Read Chapter 10 and do the Self-Review Exercises.
30

Week 11
Apr 20
Chapter 11 Inheritance
base and derived classes, constructors w/ inheritance Package Shipping Program Exercise 11.9 page 527. Copy the class code, the test application, and a screen-shot showing your program execution into a Word document and e-mail to the instructor. (20 points)
Read Chapter 11 and do the Self-Review Exercises.

20

Week 12
Apr 27
Chapter 12 Polymorphism and Operator Overloading
abstract classes Catch up on any labs that you are behind on.
Read Chapter 12 and do the Self-Review Exercises.

Answer questions from Exercises 12.3 through 12.7 page 577. E-mail your answers to the instructor. (10 points)
10

Week 13
May 4
Chapter 13 Exception Handling
Chapter 14 GUI with Windows
Labels, TextBoxes, Buttons, CheckButtons and RadioButtons Restaurant Menu Program Exercise 14.15 page 723-724. Copy the code and a screen-shot showing your program execution into a Word document and e-mail to the instructor. (30 points)
Read Chapters 13 and 14. Do the Self-Review Exercises.
30

Week 14
May 11
Chapter 17 Strings
Characters and Regular Expressions Random Sentences Program Exercise 17.6 pages 886-887. Copy the class code, the test application, and a screen-shot showing your program execution into a Word document and e-mail to the instructor. (20 points)
Read Chapter 17 and do the Self-Review Exercises.
20

Week 15
May 18
Chapter 18 Files and Streams
sequential access files, random access files Telephone-Number Word Generator Program Exercise 18.6 page 934. Copy the code and a screen-shot showing your program execution into a Word document and e-mail to the instructor. Do not copy the output file into the Word document. (20 points)
Read Chapter 18 and do the Self-Review Exercises.
20

Week 16
May 25
Chapter 20 Databases and LINQ to SQL
FINAL EXAM FINAL EXAM
(80 points)
Read Chapter 20 and do the Self-Review Exercises.
80

TOTAL POINTS (350 points) (60 points) 410

Homework	60 points	GRADING SCALE
Lab work	270 points	A = 90% - 100%
Final Exam	80 points	B = 80% - 89%
TOTAL	410 points	C = 70% - 79%
		D = 60% - 69%
		F = 0% - 59%

Week Date	Lecture Topic Chapter numbers refer to Visual Basic 2008 How to Program	Lab Assignment Page numbers refer to Visual Basic 2008 How to Program	Homework Page numbers refer to Visual Basic 2008 How to Program	Points this week
Week 1 Feb 2	Class Orientation Chapter 1 Intro to Computers Operating Systems, Visual Basic	Paycheck Program Copy the code and a screen-shot of your visual design into a Word document and e-mail them to the instructor. (10 points)	Read Chapter 1 and do the Self-Review Exercises. Do not turn in the Self-Review Exercises for any of the chapters. Answer questions from Exercises 1.4 through 1-13 pages 32-33. E-mail these answers to the instructor. (10 points)	20
Week 2 Feb 9	Chapter 2 Visual Basic IDE Help, Variables	GUI Design Exercises 2.8, 2.9, 2.10 and, 2.12 pages 69-72. Copy a screen-shot of each exercise into a Word document and e-mail to the instructor. (10 points)	Read Chapter 2 and do the Self-Review Exercises. Answer questions from Exercises 2.3 through 2.7 page 68. E-mail these answers to the instructor. (10 points)	20
Week 3 Feb 16	Chapter 3 C# Applications Text formatting, Equality and Rational Operators	Smallest-Largest-Average Exercise 3.15 page 120 Pos-Neg Count Exercise 3.17 page 120. Copy the code for each program in to a Word document and e-mail to the instructor. (10 points each)	Read Chapter 3 and do the Self-Review Exercises. Answer questions from Exercises 3.7 through 3.13 pages 120-121. E-mail your answers to the instructor. (10 points)	30
Week 4 Feb 23	Chapter 4 Intro to Classes and Objects Methods, Parameters	Invoice Program Exercise 4.11 page 160. Copy the class code, the test application and a screen-shot showing the results of your program execution into a Word document and e-mail to the instructor. (10 points)	Read Chapter 4 and do the Self-Review Exercises. Answer questions from Exercises 4.5 through 4.8 page 159. E-mail your answers to the instructor. (10 points)	20
Week 5 Mar 2	Chapter 5 Control Statements-1 Control Structures, if.else, while, loops, ++/--	Mileage Program Exercise 5.9 pages 219-220. Copy the class code, the test application, and a screen-shot showing your program has correctly processed three sets of data into a Word document and e-mail to the instructor. (20 points)	Read Chapter 5 and do the Self-Review Exercises.	20
Week 6 Mar 9	Chapter 6 Control Statements-2 for do..while, switch, break, continue, Logical Operators	Price Code Program Exercise 6.4 page 264. Copy the class code, the test application, and a screen-shot showing your program execution into a Word document and e-mail to the instructor. (20 points)	Read Chapter 6 and do the Self-Review Exercises.	20
Week 7 Mar 16	Chapter 7 Methods Packaging, static methods & Variables, Class Math, Parameters, Random Numbers, Recursion	Parking Program Exercise 7.10 page 331. Copy the class code, the test application, and a screen-shot showing your program execution into a Word document and e-mail to the instructor. (20 points)	Read Chapter 7 and do the Self-Review Exercises.	20
Week 8 Mar 23	Chapter 8 Arrays for each passing arrays, multidimensional arrays, command-line args	Airline Reservation Program Exercise 8.9 page 395. Copy the class code, the test application, and a screen-shot showing your program execution into a Word document and e-mail to the instructor. (20 points)	Read Chapter 8 and do the Self-Review Exercises. Answer questions from Exercise 8.5 page 393. E-mail your answers to the instructor. (10 points)	30
Break Mar 30	Spring Break / Cesar Chavez Day No classes held 3/29 - 4/4	Break !	Break !
Week 9 Apr 6	Chapter 9 LINQ Collections	Invoice LINQ Query Program Exercise 9.3 page 415. Copy the class code, the test application, and a screen-shot showing your program execution into a Word document and e-mail to the instructor. (20 points)	Read Chapter 9 and do the Self-Review Exercises.	20
Week 10 Apr 13	Chapter 10 Classes and Objects this reference, indexers, garbage collection, delegates	Microwave Oven Program Exercise 10.11 page 482. Copy the class code, the test application, and a screen-shot showing your program execution into a Word document and e-mail to the instructor. (30 points)	Read Chapter 10 and do the Self-Review Exercises.	30
Week 11 Apr 20	Chapter 11 Inheritance base and derived classes, constructors w/ inheritance	Package Shipping Program Exercise 11.9 page 527. Copy the class code, the test application, and a screen-shot showing your program execution into a Word document and e-mail to the instructor. (20 points)	Read Chapter 11 and do the Self-Review Exercises.	20
Week 12 Apr 27	Chapter 12 Polymorphism and Operator Overloading abstract classes	Catch up on any labs that you are behind on.	Read Chapter 12 and do the Self-Review Exercises. Answer questions from Exercises 12.3 through 12.7 page 577. E-mail your answers to the instructor. (10 points)	10
Week 13 May 4	Chapter 13 Exception Handling Chapter 14 GUI with Windows Labels, TextBoxes, Buttons, CheckButtons and RadioButtons	Restaurant Menu Program Exercise 14.15 page 723-724. Copy the code and a screen-shot showing your program execution into a Word document and e-mail to the instructor. (30 points)	Read Chapters 13 and 14. Do the Self-Review Exercises.	30
Week 14 May 11	Chapter 17 Strings Characters and Regular Expressions	Random Sentences Program Exercise 17.6 pages 886-887. Copy the class code, the test application, and a screen-shot showing your program execution into a Word document and e-mail to the instructor. (20 points)	Read Chapter 17 and do the Self-Review Exercises.	20
Week 15 May 18	Chapter 18 Files and Streams sequential access files, random access files	Telephone-Number Word Generator Program Exercise 18.6 page 934. Copy the code and a screen-shot showing your program execution into a Word document and e-mail to the instructor. Do not copy the output file into the Word document. (20 points)	Read Chapter 18 and do the Self-Review Exercises.	20
Week 16 May 25	Chapter 20 Databases and LINQ to SQL FINAL EXAM	FINAL EXAM (80 points)	Read Chapter 20 and do the Self-Review Exercises.	80
	TOTAL POINTS	(350 points)	(60 points)	410

Week Date

Week 1 Feb 2

Week 2 Feb 9

Week 3 Feb 16

Week 4 Feb 23

Week 5 Mar 2

Week 6 Mar 9

Week 7 Mar 16

Week 8 Mar 23

Break Mar 30

Week 9 Apr 6

Week 10 Apr 13

Week 11 Apr 20

Week 12 Apr 27

Week 13 May 4

Week 14 May 11

Week 15 May 18

Week 16 May 25

Week
Date

Week 1
Feb 2

Week 2
Feb 9

Week 3
Feb 16

Week 4
Feb 23

Week 5
Mar 2

Week 6
Mar 9

Week 7
Mar 16

Week 8
Mar 23

Break
Mar 30

Week 9
Apr 6

Week 10
Apr 13

Week 11
Apr 20

Week 12
Apr 27

Week 13
May 4

Week 14
May 11

Week 15
May 18

Week 16
May 25