INTRODUCTION TO VISUAL BASIC PROGRAMMING

INTRODUCTION TO VISUAL BASIC PROGRAMMING

ITP 150

Spring 2000, Tuesday, 2:00 pm, OHE 122

Course Description:

Expose the functionality of the Visual Basic Programming Environment; provide an overview of programming fundamentals including variables, controls, data types, selection structures, ActiveX components, introduce the client/server computing model; create various Visual Basic applications from the lab component of the class

Instructor: Anthony Borquez

Messages: 213.740.4129; Fax: 213.740.1051; email: anthonyb@usc.edu

Appointments –Wed. 12:00p – 1pm, Thu. 2 to 4:00 pm

Required Textbooks:

An Introduction to Programming Using Visual Basic 6.0, 4^th edition by Schneider

Recommended book(s): Mastering Visual Basic Development , Microsoft Corporation

Supplemental Reading Material: provided by the instructor for topics concerning programming fundamentals or industry trends/standards

Overview:

This course will focus on the basic programming concepts associated with Visual Basic development. Students will create Visual Basic applications that incorporate fundamental concepts, as well as design programs based upon late breaking technologies from the industry. Tools that will be used in the course include: Microsoft Visual Basic 6.0, Microsoft Access, and ActiveX controls. Fundamentals of this course will include the Visual Basic Development environment, variables, the scope of variables, selection structures, data controls, application components and references, Internet Programming with VB Script, OLE, ActiveX controls, and connectivity with relational databases. Upon completion of this course, students will be able to create Visual Basic applications that incorporate basic principles, as well as intermediate components of client/server development.

Class Schedule:

Week	Topic	Reading Assignment	Lab Assignment
Week 1 *Jan 11*	Programming Overview, Programming Windows, Introduction to Visual Basic	Schneider Chapters 1.1 - 1.5, Chapters 2.1 - 2.2	No lab assignment this week
Week 2 *Jan 18*	Visual Basic Objects, Events, Numbers, Strings, I & O, Compiling	Schneider Chap. 3.1 – 3.4	Do exercises from chapters 3.1 to 3.6.
Week 3 *Jan 25*	Variables and Data Types, Constants, naming conventions, Project Explorer	Schneider Chap. 3.5 – 3.6	*Project 1 due Jan 28* Check Instructor website to find out project assignments/details
Week 4 *Feb 1*	General Procedures: Sub Procedures vs. Function, Variables	Schneider: Chapter 4.1 – 4.4	*Exercises from Chapter 4*
Week 5 *Feb 8*	Variables continued, the scope of variables, sub procedures & functions	Finish Schneider: Chapter 4.1 – 4.4	*Project 2 (Variables & Procedures) due Feb 11*
Week 6 *Feb 15*	Selection Structures/Conditional Statements, Excel Objects	Schneider: Chapter 5.1 – 5.4	*Project 3 (If.Then Statements, Select Case) due Feb 18*
Week 7 *Feb 22*	Repetition Structure (For..Next, Do While, Do Until Loops)	Schneider: Chapter 6.1 – 6.4	*Project 4 (Looping Structures) Feb 25*
Week 8 *Feb 29*	Overview of Y2K, Midterm Review	Y2K Handouts and references (check website)	*Project 5 (For..Next) due Mar 3*
Week 9 *Mar 7*	MIDTERM 1	Review for Midterm 1, review notes, lab exercises, code examples	No lab assignment this week
*Mar 14*	Spring Break	Spring Break	Spring Break
Week 10 *Mar 21*	Creating and accessing Arrays, Control Arrays, Sorting and Searching	Schneider: Chapter 7.1 to 7.6	Exercises focusing on Arrays
Week 11 *Mar 28*	Database Management, Data Control, Relational Databases & SQL	Schneider: Chapter 12.1 to 12.3	*Project 6 (Using the Data Control) due Apr 7*
Week 12 *Apr 4*	Client/Server Overview, Data Access Techniques, Using Recordsets	In-class handout for client/server fundamentals part A	*Project 7 (data access and recordsets) due Apr 14*
Week 13 *Apr 11*	Communicating with Other Applications	In-class handout for client/server fundamentals part B	*Project 8 (Controlling IE from Visual Basic) due Apr 18*
Week 14 *Apr 18*	Programming with VB Script, Writing Internet Applications with VB	Data Access Objects (DAO 3.5) handout, Client/Server Literature	*Project 9 (Using VBScript to write an Internet Application) due Apr 25*
Week 15 *Apr 25*	Packaging VB Projects, Future trends in Visual Basic, ActiveX, Course Summary	Review readings, lecture notes, and handouts	*ActiveX handout/ work on Final Project*

Examinations:

Exams cover material from the reading assignments, lectures, and lab projects.

Grading:

Midterm 1      25%

Final Exam     25%

Final Project   25%

Lab Projects   25%

                        100%