This module may be completed in the time allowed with a 1:1 or 2:1 ratio of students to computers. The guidelines in this module are developed so that the teacher and the school may have the flexibility to choose the software General Ledger or Spreadsheet, and hardware that best suits their needs.
Basic objectives related to learning Accounts Receivable, Accounts Payable and Payroll components are included in this module. Although Module 5 is not listed as a prerequisite, it may be difficult for students to understand the payroll component of the software package without an understanding of payroll.
If time does not permit instruction on all three components, it is strongly recommended that a minimum of
8 - 10 hours of the module be spent on a project where the student designs an accounting system using a practice set and the learned components of the accounting software. An exercise employing independent learning and critical and creative thinking skills would be of higher priority than completing all of the software components.
Foundational Objectives
·
To recognize technology as a tool to aid
in the accounting process.
·
To become accustomed to and adept at the
use of accounting software and understand its strengths and limitations.
Common Essential Learnings Foundational Objectives
·
To provide opportunities for students'
active involvement in decision making and problem-solving related to technological
developments in accounting. (TL)
·
To develop students' abilities to access
knowledge. (IL)
·
To promote both intuitive, imaginative
thought and the ability to evaluate ideas and processes in accounting. (CCT)
Suggested time: 5-8 hours
Level: Intermediate
Prerequisites: Modules 2, and 11
| Learning Objectives |
Notes |
| 12.1 To review the accounting cycle of a merchandising firm. |
Students should review the additional accounts of a merchandising firm (sales, purchases, contra accounts, inventory, etc.) The extent
of this exercise will depend on the time elapsed since Module 2 was covered. |
| 12.2 To demonstrate the proper handling of software and hardware and the ability to load and operate General Ledger accounting software.
|
Students should be made aware of the fact that the general Ledger component cannot handle a large number of Accounts Receivables and Accounts Payable. |
| 12.3 To determine the advantage of integrating an Accounts Receivable module and an Accounts Payable module to the General Ledger accounting software. (CCT) |
The accounts receivable and accounts payable modules are essentially subsidiary ledgers. Why do we need subsidiary ledgers in a manual system? Reasons may include that the general ledger and all financial statements would become too lengthy or that it would be impossible to determine individual amounts from one balance in a control account. What
advantages are there to having subsidiary ledgers in General Ledger Accounting
Software? Some advantages of subsidiary
ledgers and the accounts receivable and accounts payable computerized
modules may include being able to keep track of individual balances owing,
dates and amounts of individual invoices, and payment due dates. |
| 12.4 To become familiar with the step by step procedure necessary to process accounts receivable and accounts payable data using integrated accounting software modules. (IL) |
Again this may be accomplished in several ways. The students may work through a directed example with the help of the teacher, may follow a prepared example from a manual, or may work through a tutorial. The focus should be on becoming familiar with the software and not acquiring new accounting knowledge. The procedure may include being able to: ·
enter new dates
|
Suggested time: 3-5 hours
Level: Intermediate
Prerequisites: Modules 2, 11 and 12A
| Learning Objectives |
Notes |
| 12.5 To determine the advantage of integrating a payroll component to accounting software. |
What is the purpose of payroll software? Some items that may be listed are accumulating data for individual employees, to produce employee pay cheques, to summarize employee deductions, and to generate reports for management. Students
should understand how the payroll component communicates with the general
ledger component of accounting software.
At what point is it cost beneficial to buy or use the payroll component?
Students should realize it is not always cost effective to purchase
or use a payroll module for a small number of employees.
Businesses can have payroll sent out to an outside agency such
as a bank that provides the service. |
| 12.6 To become familiar with the step by step procedure necessary to process payroll data using integrated accounting software modules. (IL) |
The procedure may include being able to: ·
enter payroll software information/defaults necessary
to process data
|
Suggested time: 8-10 hours
Level: Intermediate
Prerequisites: Modules 2, 11 and 12B
| Learning Objectives |
Notes |
| 12.7 To design an accounting system for a merchandising firm using General Ledger, Accounts Receivable, Accounts Payable, and Payroll software. (CCT) |
This objective may be accomplished by using a textbook project, a practice set, or a teacher created simulation. Current source documents should be used. If the practice set/project used as a student activity is prepared by a publisher, an audit test may be available. Students will design the system complying with software requirements, analyze transactions, prepare all statements and reports, and follow control procedures. This exercise should be a higher priority than covering all three additional software components.
|