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 project. Learn appropriate use of spreadsheet formulas and functions as required, such as specialized functions, databases, pivot tables/charts and what if analysis.
2.1 Introduce SAGE 300
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.
Lecture and practical applications, conducted exclusively in a computer lab.
| Excel | ||
| Assignment(s) or Test(s) - At least two in total. | 10 to 15% | |
| Excel examination | 20 to 25% | |
| Total Excel | 30 to 40% | |
|
SAGE |
||
|
At least three tests in total |
||
| General Ledger and Financial Reporter test | 10 to 15% | |
| Accounts Payable test | 10 to 15% | |
| Accounts Receivable test | 10 to 15% | |
| SAGE examination | 30 to 40% | |
| Total SAGE | 60 to 70% | |
| 100% |
Students must write all examinations in order to obtain credit for the course.
To pass this course, students must obtain a minimum of 50% on invigilated assessments, with the 50% calculated on a weighted average basis.
Invigilated assessments include, in-class quizzes, in-class tests, midterm exam(s) and the final exam.
At the end of the course, the successful student should be able to:
Grauer, Mulbery & Poarsy, Exploring Microsoft Excel Comprehensive, latest edition, Pearson Educational.
Christine A. Heaney, SAGE 300 ERP, latest edition, Pearson Educational.
Other resources as approved by department.
(ACCT 1110 with a grade of C+ or better OR ACCT 1210 with a grade of C or better OR ACCT 1235 with a grade of C or better) AND (CSIS 1190 with a grade of C or better or CSIS 2200 with a grade of C or better.)
Courses listed here must be completed either prior to or simultaneously with this course:
Courses listed here are equivalent to this course and cannot be taken for further credit:
| Institution | Transfer Details | Effective Dates |
|---|---|---|
| Kwantlen Polytechnic University (KPU) | KPU ABTY 1246 (3) | 2004/09/01 to - |
| Langara College (LANG) | LANG FMGT 2308 (3) | 2004/09/01 to - |
| Simon Fraser University (SFU) | No credit | 2004/09/01 to - |
| Thompson Rivers University (TRU) | TRU ACCT 2280 (3) | 2014/09/01 to - |
| University of British Columbia - Okanagan (UBCO) | No credit | 2006/09/01 to - |
| University of British Columbia - Okanagan (UBCO) | UBCO ARTS 2nd (3) | 2005/05/01 to 2006/08/31 |
| University of Northern BC (UNBC) | No credit | 2004/09/01 to - |
| University of the Fraser Valley (UFV) | UFV BUS 1XX (3) | 2004/09/01 to - |
| University of Victoria (UVIC) | No credit | 2004/09/01 to - |