I.

II.

 Prerequisite:

See Course (Catalog) Description below

III.

Course (Catalog) Description:

Course introduces programming using the Visual Basic programming language to solve business-related problems. Content includes program development and design, object-oriented programming, screen design, structured programming techniques, and event-driven programming using objects. Programming assignment concepts include arithmetic calculations, decision making, looping, reports to screen and paper, subroutines and functions, data validation, working with arrays, and introductory concepts of file creation and data retrieval. Recommended: CIS 101 or CIS 103 or comparable computer experience, CIS 105, ability to manage files using Windows, and one year high school algebra or equivalent.

IV.

Learning Objectives:

Upon completion of this course, the student will be able to demonstrate proficiency in programming using Visual Basic and Quick Basic by writing programs for a wide variety of business applications. Programming concepts will include:

1. Internal documentation
2. Storing data in variables
3. Decision making
4. Loops
5. Arrays (tables)
6. Built-in function
7. Mathematical concepts as applied to business
8. Reports with multiple pages (screens or forms) and totals
9. Data validity testing
10. Use of simple menus
11. Passing parameters to subroutines
12. Introduction to file handling

The student will display competency in program design and problem solving including:

1. Working with event-driven languages including screen design and selection of appropriate objects.
2. Working with procedure oriented languages
3. Program design through appropriate tools such as TOE charts, hierarchy charts, flowcharts, and pseudocode
4. Reading program listing for errors
5. Debugging
6. Preparation of adequate documentation

V.

Academic Integrity:

Students and employees at Oakton Community College are required to demonstrate academic integrity and follow Oakton's Code of Academic Conduct. This code prohibits:

There are serious consequences to violations of the academic integrity policy. Oakton's policies and procedures provide students a fair hearing if a complaint is made against you. If you are found to have violated the policy, the minimum penalty is failure on the assignment and, a disciplinary record will be established and kept on file in the office of the Vice President for Student Affairs for a period of 3 years.

Details of the Code of Conduct can be found in the Student Handbook.

VI.

Outline of Topics:

1. Programming concepts
   1. Program design and development
   2. Logic tools
       a. TOE charts
       b. Flowcharts
       c. Pseudocode
       d. Hierarchy charts
   3. Quick Basic as a procedure-oriented language
   4. Visual Basic as an Object-Oriented/Event-driven language
   5. Structured programming

2. Quick Basic
   1. Starting and Using Quick Basic
       a. The Quick Basic environment
       b. Getting help
       c. Creating and editing programs
       d. Program execution
       e. Displaying a program on screen and printer
       f. Reserved words
   2. Storing data in variables and constants
       a. String variables and constants
       b. Numeric variables and constants
       c. One-and two-dimensional arrays (tables)
   3. Operators and order of operations
       a. Arithmetic (=,-,*,/,^, and \)
       b. String concatenation 
       c. Logical (AND, OR, NOT, XOR)
       d. Relational (=,<>,<,<=,>,>=)
   4. Using the language
       a. Assignment statements (LET)
       b. Keyboard, display, printer I/O
       c. Sequence control and looping
       d. Introduction to built-in functions

3. Visual Basic
   1. The Visual Basic environment
       a. Screen components
           I.   Toolbar
           II.  Menu system
           III. Forms
           IV. Events
           V.  Properties
       b. The common Controls (Label, Text Box, Picture Box, Image Box,         Frame Control, Option Button, Check Box, List Box, Combo Box,         Scroll Bars, Timer Control, Command Button)
       c. Procedures
       d. Toolbox
       e. Printing forms and code
   2. Managing Projects
       a. Opening and Saving Projects
       b. Creating Executable Files
       c. Using the editor
       d. Working with the Project Window
   3. User Interfaces
       a. Access keys
       b. Dialog boxes (InputBox$ and MsgBox functions)
       c. Displaying output on screen and printer
           I. Screen design
           II. Text, fonts, and color
           III. Formatted output
           IV. Using the Printer object
       d. Data validity testing
   4. Using the Language
       a. Program flow and decision-making (If... then... Else, CASE, Do         Loops, For...Next Loops)
       b. Type of variables
       c. Scope of variables
       d. Constants
       e. Arithmetic, relational, and logical operators
       f. Debugging and Error Handling
       g. Responding to mouse and keyboard access files
       i. Multiple forms
       j. Creating simple menus
       k. Sub procedures
       l. Control and single-dimensional variable arrays

VII.

Methods of Instruction:

Reading, lecture, discussion, group work, demonstration of programs, hands-on exercises and projects, assignments, quizzes, and/or tests.

VIII.

Course Practices Required:

Reading:   Students will be expected to read textbook and research                appropriate manuals as needed.
Writing:    Interactive programming requires student to be able to write                screen and other instructions using clear and syntactically correct                English.
Computer: Students will use computers to create, test and debug a variety of                programs.

IX.

Instructional Materials:

TEXTBOOK: Murach's Visual Basic 2005 ; Author: Anne Boehm; Published by
                       Murach

Quick and Visual Basic Software

Appropriate texts and manuals

Handouts

X.

Methods of Evaluating Student Progress:

Students will be evaluated on quality of programs, other written assignments, quizzes, and tests as specified by the instructor.

XI.

Other Course Information:

If you have a documented learning, psychological, or physical disability you may be entitled to reasonable academic accommodations or services. To request accommodations or services, contact the ASSIST office in Instructional Support Services. All students are expected to fulfill essential course requirements. The College will not waive any essential skill or requirement of a course or degree program.

Course ID changed from DPR 212 to CIS 113, Fall, 1992