Important Messages


 

 
IST 500

Fundamentals of Systems Development with Visual Basic (3-0-3)


Instructor:

Victor Matos.
Phone:

Office: (216) 687-3911
Fax:
(216) 687-5448
Department: (216) 687-4760

Office:

Room: BU 342
Hours: 8:30-9:50 AM, 2:45-3:50, 5:20-5:50 Click here for detailed schedule

E-mail: matos@cis.csuohio.edu
Web Page: http://cis.csuohio.edu/~matos
Important Dates CSU Official Calendar

Objectives:

Introduction to computer programming for Business and Information Science students. No previous experience and knowledge of programming is required. Visual basic is used to teach solid programming concepts and practices. Topics include variables and their types, control structures, flow control, controls for graphical-user-interfaces, event-driven programming, file and database processing, and the application development cycle.

Pre-requisite
: IST 203 Software Tools for Personal Productivity (or equivalent course)


Text:
"Visual Basic 6 - How to Program"
Deitel & Deitel, Nieto. ISBN 0-13-456955-5. Ed. Prentice Hall, NJ 1999.

Course Resourses:
  • Links to pages in the Internet referencing Visual Basic software libraries, chat rooms, technical newsgroups, editorial houses, magazines, journals, etc. Click here to enter.

  • Software: Microsoft software is available (for a small fee) through the University License Agreement.

Calendar:
Detailed action plan for the semester on calendar format. Click here to see it.

 

 

 

 

 

 


Tentative Syllabus

Week

Topics

 Chapter

1

Computing Concepts
Objectives: To understand fundamental computer concepts. To understand the notions of personal computing, distributed computing and client/server computing. To become familiar with different types of programming languages. To become familiar with the history of the Visual Basic programming language. To understand the role Visual Basic and VBScript play in developing applications for the Internet and the World Wide Web. To understand the kinds of multimedia applications you can create with Visual Basic, including graphics, images, animation, audio and video. To understand the role ActiveX components play in developing Visual Basic Applications.

Chapter 1

2

Integrated Development Environment
Objectives: Become familiar with the integrated development environment. To be able to create a standard executable. To be able to identify the controls in the toolbox. To be able to use the label, textbox, line, command button controls to make simple GUI. To be able to customize controls using properties. To be able to save a project. To be able to execute a simple program. To understand the difference between design mode and run mode. To be able to use the label, textbox, line, command button controls to make simple GUI.

Chapter 2

(a) Making the GUI for a 1999 W2-Tax form.

(b) Making a "Baby" engineering - Business calculator.

3

Introduction to Visual Basic Programming
Objectives To write simple programs in Visual Basic. To become familiar with fundamental data types. To understand computer memory concepts. To be able to use arithmetic operators. To understand the precedence of arithmetic operators. To be able to write simple decision-making statements.

Chapter 3

(b) Designing a simple Pizza Request Form.

4

Control Structures Part I. Goals: To understand basic problem-solving techniques. To be able to develop algorithms through the process of top-down, stepwise refinement. To be able to use the If/Then and If/Then/Else selection structures to choose between alternative actions. To be able to use the While/Wend, Do While/Loop and Do Until/Loop repetition structures. To understand counter-controlled repetition and sentinel-controlled repetition. To understand the concept of nested control structures.

Chapter 4


Homework 2
(The Game of Twos)

5

Control Structures: Part II. To be able to use the For/Next, Do/Loop While and Do/Loop Until repetition structures. To understand multiple selection using the Select Case multiple selection structure. To be able to use the Exit Do and Exit For statements. To be able to use the Boolean data type. To be able to create and use constant variables. To be able to use the logical operators to combine conditions. To understand how control structures can be combined in a structured program. To become familiar with the data types available in Visual Basic.

Chapter 5
(Tokenizer)

6

Sub Procedures And Function Procedures Goals: To understand how to construct programs modularly from procedures and functions. To be able to create new procedures and functions. To understand the mechanisms used to pass information between procedures and functions. To understand the Exit Sub and Exit Function statements. To understand how the visibility of indentifiers is limited to specific regions of programs. To introduce simulation using random numbers. To understand and be able to use Optional arguments and named arguments. To be able to use Visual Basic math functions. To be able to create and use code modules.

Chapter 6

7

Arrays To introduce the array data structure. To understand the use of arrays to store, sort, and search lists and tables of values. To understand how to declare an array, initialize an array, and refer to individual elements of an array. To be able to pass arrays to procedures. To understand basic sorting techniques. To be able to create and manipulate multidimensional arrays. To be able to create and use control arrays. To understand how to create, use, and redimension dynamic arrays. To be able to use ParamArray and Array.

Chapter 7

8

Strings, Dates and Times Objectives: To use the string concatenation operators. To be able to compare strings and search strings for substrings. To be able to manipulate the characters in a string using a variety of functions. To be able to convert values to and from strings and other data types. To be able to use the date and time functions. To be able to format strings, dates and times.

Chapter 8

9

Graphics Objectives To understand coordinate systems. To be able to incorporate images into a program. To understand and be able to use the Printer object.

Chapter 9

10

Basic Graphical Objectives: To be able to use the ComboBox control and ListBox control to allow the user to select from a list of options. To be able to use the scrollbar controls and Slider control to select from ranges of values. To be able to create menus and pop-up menus to enhance an application’s GUI. To be able to use the MsgBox function to display information to the user.

Chapter 10

11

Mouse and Keyboard Objectives To recognize mouse events such as Click, DblClick, MouseDown, MouseUp and MouseMove. To determine which of the mouse buttons was pressed. To determine whether or not the Shift, Ctrl and Alt keys were held down when a mouse button was pressed. To be able to drag-and-drop an object using the mouse. To be able to change the mouse pointer icon into shapes appropriate for various contexts. To recognize key events such as KeyPress, KeyDown and KeyUp, and to write code to respond to these events. To be able to use the KeyPreview property to intercept keyboard events.

Chapter 12

12

Error Handling and Debugging Objectives To understand errors and how to handle them. To be able to use the On Error Statement. To understand the use of labels in error handling. To be able to use the Resume statement. To be able to use the Err object to determine what error occurred. To understand error handling and the call stack. To understand the debugger elements.

Chapter 13

13

Sequential File Processing Objectives To understand the data hierarchy arrangement of bits, bytes, characters, fields, records, files and databases. To be able to use the FileListBox, DirListBox and DriveListBox controls. To be able to create and use file system objects FileSystemObject, File, Folder and Drive. To be able to open, read, write and close sequential files, and to detect the end-of-file condition.

Chapter 14

14
15

Database Management Objectives To understand the relational database model. To use the ADO Data Control to access a database. To use the DataGrid, Hierarchical FlexGrid, DataCombo and DataList controls with the ADO Data Control to view and manipulate data in a database. To understand basic database queries using Structured Query Language (SQL). To use Data Environment Designer to quickly create data-driven applications.

Chapter 18


TENTATIVE GRADING

70% - Approx. 6 exams.
30% - Approx. 14 Lab Experiences/Homeworks/Programming projects 

Quality Points and Letter Grades: We will use the Letter+- scale published by the University.


Grade distribution is subject to changes. Modifications (if any!) will be announced in class.


GRADING POLICY

  • Make-up exams and late assignments will be accepted only under extraordinary circumstances.
  • All homework is due at the start of class on the date specified in the assignment. At the discretion of the instructor, 10% per day late will be deducted from late homework assignments; weekends will count as one day. At the discretion of the instructor unannounced exams could be administer during the semester. No assignment will be accepted more than one week after its scheduled due date, or after it has been discussed in class, whichever occurs first. Any student who fails to turn in two or more homework assignments will receive a grade of "F" for the course, regardless of scores on other homework or exams. Part of your grade on all homework assignments depends on the professional quality of your work. It must be understood that individual homework assignments should represent the effort of the student turning in the assignment. Should two or more students turn in the same solution to an individual assignment (or what I judge to be the same solution) I will consider this to be cheating and will grade the papers accordingly. Both students involved will be penalized! Any student who turns in a group effort for an individual homework assignment will automatically receive a grade of F for the course!

 

COURSE ORGANIZATION

Activities during class time will focus primarily on strengthening your understanding of the course material rather than on my lecturing about these topics. The lectures will be designed to supplement the assigned text readings, and to present examples that demonstrate how the techniques presented in the text can be used.

 

Other Supporting Material / Samples

  • Listing of homework assignments

  • VB examples taken from the textbook

  • Supporting VB material. (Author's webpage).

  • Listing of previous exams


  • ADA COMPLIANCE

    If you need course adaptations or accommodations because of a disability, if you have emergency medical information to share with me, or if you need special arrangements in case the building must be evacuated, please make an appointment with me as soon as possible. My office location and hours are listed on top of this syllabus. If you need further information, please contact the ACCESS office, phone number (216) 687-5106.