CIS 230

Class #20 Lecture

Review selected Ch. 10 Review Questions on p. 438

Review selected Ch. 10 Feedback exercises (pp. 385, 393, 412)

Continue Ch. 10 Lecture

Hands on Programming Exercise:

  1. (user-defined types) Do Feedback 8.3 #1 & 2 (p. 299) on your computer.  Place the Type/End Type statement in the general declarations section of the form module but declare it as Private. Create five text boxes allowing the user to enter the 5 pieces of information for a student. Then, create another text box that invites the user to enter an integer between 1 and 100. Finally, create a command button that will insert the 5 data elements from 5 text boxes into the desired position of the array (subscripted from 1 to 100) of 100 students.

  2. (two-dimensional tables) Do Feedback 8.4 (p. 310) on your computer. Use loops efficiently to answer exercises #2 - 4.

  3. (sequential access files) Write a program that simply stores the user's name on the first line of a sequential access file. Use an InputBox to obtain the user's name. (See pp. 435 & 436 to learn how to use the InputBox Function.)

  4. (sequential access files) Write a comma-delimited text file with three records (integers) on each of 5 lines. Create a command button that uses a double nested loop and an Input # statement to input all 15 elements into a 5 x 3 two-dimensional array. As a second exercise, place the same data into an MS Excel comma-delimited (.csv) file and do the same thing.

Homework Assignment:

    CIS 230 Home Page | Mr. Minich's Education Home Page | Web Design