Standard |
ACC 157 – Advanced Integrated Management Systems
Emphasizes advanced use of database management and electronic spreadsheet software packages for accounting/financial applications. Topics include; advanced multiple file operations, custom input/output forms, advanced accounting applications, spreadsheet database management, advanced macro applications, and graph creation
|
Competency Areas |
Hours
|
|
|
Advanced Multiple File Operations |
Class |
2 |
|
Custom Input/Output Forms |
D. Lab |
8 |
|
Advanced Accounting Applications |
P. Lab/O.B.I. |
0 |
|
Spreadsheet Database Management |
Credit |
6 |
|
Advanced Macro Applications |
|
|
|
Graph Creation |
|
|
|
Prerequisite: |
ACC 105, ACC 106 |
|
Corequisite: |
Course Guide |
|
Competency |
After completing this
section, the student will: |
Hours |
||
|
Class |
D.Lab |
P.Lab/ O.B.I. |
||
|
ADVANCED MULTIPLE FILE
OPERATIONS |
4 |
16 |
0 |
|
|
Multiple file operations. |
Perform advanced multiple file operations. |
|
|
|
|
Operating parameters |
Change operating parameters. |
|
|
|
|
File manipulation |
Copy all or a portion of a data file to another file. |
|
|
|
|
|
Copy to a file suitable for use in a spreadsheet or word processing program. |
|
|
|
|
Memory variables |
Create, use, display, store, retrieve, and remove memory variables. |
|
|
|
|
Command files |
Create, modify, and execute a command file that uses conditional logic. |
|
|
|
|
|
Use commands that move to specific points within a data file. |
|
|
|
|
|
Accept data into the program. |
|
|
|
|
|
Print data out of the program. |
|
|
|
|
|
Add to the data file. |
|
|
|
CUSTOM INPUT/OUTPUT OPERATIONS |
2 |
8 |
0 |
|
|
Input/Output |
|
|
|
|
|
|
|
|
|
|
ADVANCED ACCOUNTING APPLICATION |
3 |
12 |
0 |
|
|
Accounting applications |
Create and manipulate multiple files for a specific accounting or management application. |
|
|
|
|
|
Create spreadsheets for advanced accounting and financial applications. |
|
|
|
|
SPREADSHEET DATBASE MANAGEMENT |
5 |
20 |
0 |
|
|
Data commands |
Use spreadsheet data commands for statistical purposes. |
|
|
|
|
|
Use spreadsheet data commands for building tables. |
|
|
|
|
|
Manipulate data by using other data commands. |
|
|
|
|
Computational functions |
Use advanced computational functions available in the spreadsheet. |
|
|
|
ADVANCED MACRO APPLICATIONS |
5 |
20 |
0 |
|
|
Macros |
Create macros for various applications using the spreadsheet command language. |
|
|
|
|
|
Design and create spreadsheets with macros for specific accounting or management applications. |
|
|
|
|
Printing |
Use advanced print options. |
|
|
|
|
Combining files |
Combine various spreadsheet files and text files. |
|
|
|
GRAPH CREATION |
1 |
4 |
0 |
|
|
Create and print graphs using the options available |
|
|
|
|
Suggested Resources |
Liskin, M. (1988). DBASE III Plus Made Easy. New York: McGraw-Hill.
Que Development Group. (1991). Using 1-2-3 for Dos 3.1+, special edition. Carmel, IN: Prentice Hall Computer.
Wray, R.A. (1991). Dbase III Plus Programming (2nd ed.). Boston: Boyd & Fraser.