Print Page
Active as of Summer Session 2012
I. General Information
1. Course Title:
Accounting Information Systems
2. Course Prefix & Number:
ACCT 2140
3. Course Credits and Contact Hours:
Credits: 3
Lecture Hours: 3
Lab Hours: 0
4. Course Description:
Students will learn how to use spreadsheet and database management software to design and build accounting systems that deliver timely, accurate information. The spreadsheet component will cover worksheet creation, layout, calculation and reporting capabilities as a stand alone or in connection with the object linking features of current accounting software. The database component will concentrate on the creation of relational database systems and the manipulation of data to complement current accounting software. Emphasis is placed on using software systems for business decision making.
5. Placement Tests Required:
6. Prerequisite Courses:
ACCT 2140 - Accounting Information Systems
There are no prerequisites for this course.
9. Co-requisite Courses:
ACCT 2140 - Accounting Information Systems
There are no corequisites for this course.
II. Transfer and Articulation
1. Course Equivalency - similar course from other regional institutions:
St. Cloud State University, ACCT 383 Accounting Information Systems, 3 credits
Bemidji State University, ACCT 3110 Accounting Systems, 3 credits
North Dakota State University, ACCT 420 Accounting Information Systems, 3 credits
III. Course Purpose
Program-Applicable Courses – This course is required for the following program(s):
Accountant, Diploma
Accounting, AAS Degree
IV. Learning Outcomes
1. College-Wide Outcomes
| College-Wide Outcomes/Competencies |
Students will be able to: |
| Analyze and follow a sequence of operations |
Design an accounting information system to provide information needed to make key decisions. |
| Utilize appropriate technology |
Demonstrate an understanding of spreadsheet and database software. |
2. Course Specific Outcomes - Students will be able to achieve the following measurable goals upon completion of
the course:
- Explain what an accounting information system is and describe its basic functions and usefulness.
- Describe basic business activities and related information processing operations in the revenue and expenditure cycles.
- Demonstrate an understanding of spreadsheet and database software.
- Develop skills to master worksheet creation, layout, calculation and reporting capabilities, as a stand alone or in connect with the object linking features, of current spreadsheet software.
- Design an accounting information system to provide information needed to make key decisions.
- Understand fundamental concepts of database terminology, and data modeling and their effect on an Accounting Information System.
- Prepare and use flowcharts to understand, evaluate, and document information systems.
- Create GAAP based financial statements that are professional looking using a spreadsheet application.
- Analyze financial and business data by creating charts and graphs that display relevant information using a spreadsheet application.
V. Topical Outline
Listed below are major areas of content typically covered in this course.
1. Lecture Sessions
- Excel Tour
- Excel 2010 capabilities and new features
- How to start, navigate, and work with Excel files
- How to use Excel help
- How Excel is used in accounting
- Excel Basics
- How to enter information into a worksheet
- How to use formulas more extensively
- How to manipulate date and structure worksheets
- How to print a worksheet
- Financial Statement Analysis
- How to perform a vertical financial analysis
- How to create a pie chart of expenses
- How to perform a horizontal financial analysis
- How to create a column chart of expenses
- How to calculate financial ratios
- Depreciation
- How to calculate straight-line depreciation using Excel’s built-in functions
- How to use what-if analysis with the depreciation function
- How to create a depreciation summary for many assets
- How to calculate depreciation using double declining blance and sum-of-the-year digits methods using Excel’s built-in functions
- How to create charts to illustrate depreciation expense
- Loan and Bond Amortization
- How to use the payment function to calculate payments to retire a loan
- How to create a loan amortization schedule
- How to use a what-if analysis with the payment function
- How to use names in a worksheet
- How to use the present value function to calculate the proceeds of a bond
- How to create a bond amortization schedule
- How to use Excel’s what-if analysis and goal-seeking capabilities with the present value function
- How to use Excel’s Scenario Manager
- How to integrate monthly periods into loan or bond amortization analyses
- Cash Budgeting
- How to prepare a budget for operating activities that includes a
- Sales budget
- Operating cash receipts budget
- Purchases budget
- Sales and administrative expenses budget
- Operating cash payments budget
- How to prepare a budget for investing and financing activities
- How to finalize and format the cash budget with grouping
- How to utilize what-if analysis and goal seeking with a cash budget
- Other topics: Present/Future Values, Predicting costs, and Allowance for Uncollectible accounts
- How to use Excel to prepare a present/future value analysis
- How to use Excel to predict costs
- How to use Excel to calculate an allowance for uncollectible accounts
- DataFlow Diagrams
- Document Flowcharts
- Designing Flowcharts
- Access Tour
- Access’s capabilities and new features
- How to start, navigate, and work with Access files
- How to Access Help
- How Access is used in accounting
- Access Basics
- How to create and print tables
- How to create and print queries
- How to create and print forms
- How to create and print reports
- Tables
- How to Add, change, and delete records
- How to add a picture with an OLE field
- How to change the structure of a database
- How to change field data types, row heights, and column widths
- How to create field validation rules
- How to create field default values
- How to create field formats
- How to specify referential integrity
- How to document a database
- Queries
- How to use a query to display selected records
- How to use character data in criteria in a query
- How to use wildcards in criteria
- How to edit a query
- How to use comparison operators and sorting
- How to use compound criteria and limit output
- How to perform calculations
- How to use computed fields
- How to compute statistics
- How to use an action query to update or delete records
- How to use a parameter query
- How to print a query
- Forms
- How to modify a form’s labels and Text Box controls
- How to use list box and combo box controls
- How to place a calculated control on a form
- How to place a check box control on a form
- How to use special combo box controls
- How to place an option button control on a form
- How to create a form with a sub-form
- How to print a form
- How to document a form.
- Reports
- How to use a query to create a report
- How to use grouping and summarizing in a report
- How to modify an existing report design
- How to export a report to MS Word and/or Excel
- How to import an Excel table into Access
- How to create a mail merge letter using MS Word, Excel and Access.
I. General Information
1. Course Title:
Accounting Information Systems
2. Course Prefix & Number:
ACCT 2140
3. Course Credits and Contact Hours:
Credits: 3
Lecture Hours: 3
Lab Hours: 0
4. Course Description:
Students will learn how to use spreadsheet and database management software to design and build accounting systems that deliver timely, accurate information. The spreadsheet component will cover worksheet creation, layout, calculation and reporting capabilities as a stand alone or in connection with the object linking features of current accounting software. The database component will concentrate on the creation of relational database systems and the manipulation of data to complement current accounting software. Emphasis is placed on using software systems for business decision making.
5. Placement Tests Required:
6. Prerequisite Courses:
ACCT 2140 - Accounting Information Systems
There are no prerequisites for this course.
9. Co-requisite Courses:
ACCT 2140 - Accounting Information Systems
There are no corequisites for this course.
II. Transfer and Articulation
1. Course Equivalency - similar course from other regional institutions:
St. Cloud State University, ACCT 383 Accounting Information Systems, 3 credits
Bemidji State University, ACCT 3110 Accounting Systems, 3 credits
North Dakota State University, ACCT 420 Accounting Information Systems, 3 credits
III. Course Purpose
1. Program-Applicable Courses – This course is required for the following program(s):
Accountant, Diploma
Accounting, AAS Degree
IV. Learning Outcomes
1. College-Wide Outcomes
| College-Wide Outcomes/Competencies |
Students will be able to: |
| Analyze and follow a sequence of operations |
Design an accounting information system to provide information needed to make key decisions. |
| Utilize appropriate technology |
Demonstrate an understanding of spreadsheet and database software. |
2. Course Specific Outcomes - Students will be able to achieve the following measurable goals upon completion of
the course:
- Explain what an accounting information system is and describe its basic functions and usefulness.
- Describe basic business activities and related information processing operations in the revenue and expenditure cycles.
- Demonstrate an understanding of spreadsheet and database software.
- Develop skills to master worksheet creation, layout, calculation and reporting capabilities, as a stand alone or in connect with the object linking features, of current spreadsheet software.
- Design an accounting information system to provide information needed to make key decisions.
- Understand fundamental concepts of database terminology, and data modeling and their effect on an Accounting Information System.
- Prepare and use flowcharts to understand, evaluate, and document information systems.
- Create GAAP based financial statements that are professional looking using a spreadsheet application.
- Analyze financial and business data by creating charts and graphs that display relevant information using a spreadsheet application.
V. Topical Outline
Listed below are major areas of content typically covered in this course.
1. Lecture Sessions
- Excel Tour
- Excel 2010 capabilities and new features
- How to start, navigate, and work with Excel files
- How to use Excel help
- How Excel is used in accounting
- Excel Basics
- How to enter information into a worksheet
- How to use formulas more extensively
- How to manipulate date and structure worksheets
- How to print a worksheet
- Financial Statement Analysis
- How to perform a vertical financial analysis
- How to create a pie chart of expenses
- How to perform a horizontal financial analysis
- How to create a column chart of expenses
- How to calculate financial ratios
- Depreciation
- How to calculate straight-line depreciation using Excel’s built-in functions
- How to use what-if analysis with the depreciation function
- How to create a depreciation summary for many assets
- How to calculate depreciation using double declining blance and sum-of-the-year digits methods using Excel’s built-in functions
- How to create charts to illustrate depreciation expense
- Loan and Bond Amortization
- How to use the payment function to calculate payments to retire a loan
- How to create a loan amortization schedule
- How to use a what-if analysis with the payment function
- How to use names in a worksheet
- How to use the present value function to calculate the proceeds of a bond
- How to create a bond amortization schedule
- How to use Excel’s what-if analysis and goal-seeking capabilities with the present value function
- How to use Excel’s Scenario Manager
- How to integrate monthly periods into loan or bond amortization analyses
- Cash Budgeting
- How to prepare a budget for operating activities that includes a
- Sales budget
- Operating cash receipts budget
- Purchases budget
- Sales and administrative expenses budget
- Operating cash payments budget
- How to prepare a budget for investing and financing activities
- How to finalize and format the cash budget with grouping
- How to utilize what-if analysis and goal seeking with a cash budget
- Other topics: Present/Future Values, Predicting costs, and Allowance for Uncollectible accounts
- How to use Excel to prepare a present/future value analysis
- How to use Excel to predict costs
- How to use Excel to calculate an allowance for uncollectible accounts
- DataFlow Diagrams
- Document Flowcharts
- Designing Flowcharts
- Access Tour
- Access’s capabilities and new features
- How to start, navigate, and work with Access files
- How to Access Help
- How Access is used in accounting
- Access Basics
- How to create and print tables
- How to create and print queries
- How to create and print forms
- How to create and print reports
- Tables
- How to Add, change, and delete records
- How to add a picture with an OLE field
- How to change the structure of a database
- How to change field data types, row heights, and column widths
- How to create field validation rules
- How to create field default values
- How to create field formats
- How to specify referential integrity
- How to document a database
- Queries
- How to use a query to display selected records
- How to use character data in criteria in a query
- How to use wildcards in criteria
- How to edit a query
- How to use comparison operators and sorting
- How to use compound criteria and limit output
- How to perform calculations
- How to use computed fields
- How to compute statistics
- How to use an action query to update or delete records
- How to use a parameter query
- How to print a query
- Forms
- How to modify a form’s labels and Text Box controls
- How to use list box and combo box controls
- How to place a calculated control on a form
- How to place a check box control on a form
- How to use special combo box controls
- How to place an option button control on a form
- How to create a form with a sub-form
- How to print a form
- How to document a form.
- Reports
- How to use a query to create a report
- How to use grouping and summarizing in a report
- How to modify an existing report design
- How to export a report to MS Word and/or Excel
- How to import an Excel table into Access
- How to create a mail merge letter using MS Word, Excel and Access.