Standard

 

ACC 160 Advanced Accounting Spreadsheet Applications

Course Description

 Provides students with laboratory based theoretical and technical advanced spreadsheet applications.  Emphasis is placed on developing an understanding of scope and application of advanced spreadsheet software.  Topics include: advanced computational functions, advanced data management functions, advanced file management, advanced data manipulation, advanced spreadsheet printing options, advanced spreadsheet macros, advanced spreadsheet command language, advanced graph generation, and advanced accounting and financial applications.

 

Competency Areas

Hours

 

 Advanced Computational Functions

Class

 1

 Advanced Data Management Functions

D. Lab

 7

 Advanced File Management

P. Lab/O.B.I.

 0

 Advanced Data Manipulation

Credit

 4

 Advanced Spreadsheet Macros

 

 

 Advanced Spreadsheet Command Language

 

 

 Advanced Graph Generation

 

 

 Advanced Accounting and Financial Applications

 

 

Prerequisite:

ACC 106

Corequisite:

 

 

Course Guide

 

Competency

After completing this section, the student will:

Hours

Class

D.Lab

P.Lab/

O.B.I.
ADVANCED COMPUTATIONAL FUNCTIONS

2

16

0

 Mathematical functions

Operate accounting spreadsheet software using advanced mathematical functions.

 

 

 

 Logical functions

Operate accounting spreadsheet software using advanced logical functions.

 

 

 

 Special functions

Operate accounting spreadsheet software using advanced special functions

 

 

 

 Date and time functions

Operate accounting spreadsheet software using advanced date and time functions.

 

 

 

 ADVANCED DATA MANAGEMENT FUNCTIONS 

1 

10

0

 Data management functions

Operate accounting spreadsheet software using advanced data management functions.

 

 

 

 ADVANCED FILE MANAGEMENT 

1

3

0

Passwords

Use spreadsheet passwords.

 

 

 

Extract/combine

Use advanced extract/combine spreadsheet commands.

 

 

 

Transfer/import/translate

Work with spreadsheet file transfer/import/translation features.

 

 

 
ADVANCED DATA MANIPULATION

1

2

0

Data manipulation commands

Use advanced data manipulation commands within spreadsheets.

 

 

 
ADVANCED SPREADSHEET PRINTING OPTIONS

1

3

0

Print options

Use advanced print options within spreadsheet.

 

 

 

Printer status

Identify printer status for spreadsheet printing purposes.

 

 

 

Global defaults

Use global defaults for spreadsheet printing purposes.

 

 

 

Hiding ranges

Hide segments of worksheet for printing purposes.

 

 

 
ADVANCED SPREADSHEET MACROS

1

3

0

Macro setup

Plan, create, name, and execute spreadsheet macros.

 

 

 

Automatic macros

Create automatic macros.

 

 

 
ADVANCED SPREADSHEET COMMAND LANGUAGE

2

10

0

Command language

Use advanced command language for spreadsheet macros.

 

 

 

Data input and manipulation

Input and manipulate data when using spreadsheet macros.

 

 

 

Program control, enhancements, and decision making

Use macro command language for program control, decision making, and program enhancement.

 

 

 
ADVANCED GRAPH GENERATION

1

5

0

Graph creations

Use advanced graph commands within spreadsheet.

 

 

 
ADVANCED ACCOUNTING AND FINANCIAL APPLICATIONS

0

18

0

Problem applications

Apply advanced spreadsheet applications to accounting/financial problems.

 

 

 

 

Suggested Resources

 

Books

 

Holt, J. A., & Kottas, J.F. (1992).  Cases and applications in Lotus 1-2-3.  Boston: Irwin.

Que Development Group. (1992).  Using 1-2-3 release 2.4, special edition.  Carmel, IN: Prentice Hall Computer.