Lecture and practical applications, conducted exclusively in a computer lab.
1.1 Review basic spreadsheet concepts
1.2 Review and apply basic accounting concepts
1.3 Prepare spreadsheets and charts for financial statements, financial analyses, and supporting schedules, including a complete accounting worksheet and financial statement projectLearn appropriate use of spreadsheet formulas and functions as required, such as IF and VLOOKUP
2.1 Introduce ACCPAC for WINDOWS
2.2 Set up databases and activate the General Ledger
2.3 Set up the General Ledger and Chart of Accounts; process day-to-day and adjusting entries
2.4 Print transaction batches and the Trial Balance
2.5 Generate and modify financial statements using the Financial Reporter feature
2.6 Export and import the Chart of Accounts to and from Excel; export the Trial Balance to Excel
2.7 Perform year-end procedures and print the post-closing Trial Balance
2.8 Activate and set up tax and bank services
3.1 Activate and set up the Accounts Receivable module
3.2 Process day-to-day transactions, including invoices, cash receipts and adjustments
3.3 Perform period-end processing, including interest and write-off batches
3.4 Generate reports, including the Aged Trial Balance
4.1 Activate and set up the Accounts Payable module
4.2 Process day-to-day transactions, including invoices and adjustments
4.3 Process payments, both manual and computer generated cheques
4.4 Generate reports, including the Aged Payables Report.
At the end of the course, the successful student should be able to:
- Create accounting-related spreadsheets and charts by applying previously acquired accounting skills and expanding on previously acquired computer skills
- Set up and use the ACCPAC for WINDOWS General Ledger module and Financial Reporter
- Set up and use the ACCPAC for WINDOWS Accounts Receivable module
- Set up and use the ACCPAC for WINDOWS Accounts Payable module.
| Excel | ||
| Assignment(s) and Quiz(zes) - minimum one of each | 10% | |
| Excel examination | 20% | |
| Total Excel | 30% | |
| ACCPAC for Windows | ||
| Assignment(s) and Quiz(zes)-minimum of one in each modue | 20% | |
| General Ledger and Financial Reporter examination | 20% | |
| Accounts Receivable examiniation | 15% | |
| Account Payable examination | 15% | |
| Total ACCPAC | 70% | |
| 100% |
Students must write all four examinations in order to obtain credit for the course.
Textbooks and Materials to be Purchased by Students
Grauer, Robert T. and Maryann Barber. Exploring Microsoft Excel 2000, latest edition, Pearson Educational.
Zwicker, Brian. ACCPAC for Windows: SB Series Software, latest edition, Nelson Thomson Learning.
ACCT 1110 or ACCT 1235 text or equivalent.