|
Standard |
Posted: 09/20/07
|
R
State Standard £ Institutionally Developed College: n/a |
CIS2711 – Midrange
Programming II
Course
Description
Provides an
advanced study of the midrange programming languages RPG and COBOL and how they
are utilized to solve business applications. Topics include: data validation, interactive programming,
screen design aid, subfiles, multidimensional array processing, and database
processing.
|
Competency Areas |
Hours |
|
|
Data
Validation |
Class |
4 |
|
Interactive
Programming |
D. Lab |
6 |
|
Screen
Design Aid |
P.
Lab/O.B.I. |
0 |
|
Subfiles |
Credit |
7 |
|
Multidimensional
Array Processing |
|
|
|
Database
Processing |
|
|
|
Prerequisite: |
CIS2710 |
|
Corequisite: |
|
Course Guide |
|
Competency |
After completing this section,
the student will be able to: |
Hours |
||
|
Class |
D.Lab
|
P.Lab/ O.B.I. |
||
|
|
|
|
|
|
|
DATA VALIDATION |
6 |
8
|
||
|
|
Explain
the purpose of data validation |
|
|
|
|
|
Describe
and use validation procedures |
|
|
|
|
8 |
16
|
|
||
|
|
Explain
interactive programming concepts |
|
|
|
|
|
Describe
screen design techniques |
|
|
|
|
|
Describe
database update procedures |
|
|
|
|
|
Describe screen
I/O’s |
|
|
|
|
|
Validate
user input and display appropriate messages |
|
|
|
|
|
Update
files via interactive programs |
|
|
|
|
SCREEN DESIGN AID (SDA) |
8 |
10
|
|
|
|
|
Describe the
purpose of SDA |
|
|
|
|
Describe how
to create screens using SDA |
|
|
|
|
|
SUBFILES |
6 |
10
|
|
|
|
Describe
the purpose of Subfiles |
|
|
|
|
|
Describe
how to create Subfile screens |
|
|
|
|
|
MULTIDIMENSIONAL ARRAY PROCESSING |
4 |
6
|
|
|
|
Explain multidimensional array (table) concepts |
|
|
|
|
|
Describe
how to construct multi-dimensional arrays |
|
|
|
|
|
Describe
how to populate multi-dimensional arrays |
|
|
|
|
|
Describe
multi-dimensional table processing |
|
|
|
|
|
DATABASE PROCESSING |
8 |
10
|
|
|
|
Describe database
concepts and terminology |
|
|
|
|
|
Explain
random file processing concepts |
|
|
|
|
|
Describe
random file processing |
|
|
|
|
|
Describe
random file updating |
|
|
|
|
|
|
|
|
|
|
|
Suggested Resources |
Cooper & Stern (2003). Programming in COBOL/400. Wiley.
ISBN: 0-471-41846-3
Horn & Gleason ( 2005). Comprehensive
Structured COBOL. Course
Technology. ISBN: 0-87709-621-x
Murach (2000). Murach’s Structured COBOL. Murach.
ISBN: 1-890774-05-7
Cozzi, R. (1999). The Modern RPG IV
Language. Midrange Computing ISBN: 1-58347-002-6
Meyers & Yeager (2002). Programming in RPG IV. 29th St Press ISBN: 1-58304-094-3