Bookkeeping Specialty

This course is designed to develop students’ keyboarding skills. Accuracy and keyboarding speed are emphasized, during the course. In each lesson, students are shown correct touch typing techniques and review the alpha-numeric keyboard. This course also introduces timings of various durations. The speed objective is 30 wpm in three minute timings with three or fewer errors.

Business Communications 1 covers language skills necessary for written business communications. Topics include spelling, grammar, punctuation, capitalization, and number usage.

Administrative Procedures 1 incorporates practical and professional approaches to learning office skills. Students solve on-the-job situations to encourage critical thinking. Ethics cases presented to students promote thoughtful discussions. Students also research new ideas and learn to work independently.

OFAD 157 Business Math and Calculators covers the basic skill of using the 10-key touch keypad for numeric calculations. Students apply the use of memory functions to cross check totals and use the multiplication function to calculate percents, discounts, and taxable amounts. Frequent skill assessments promote accuracy and speed in the use of the desktop calculators. Students will learn basic business math skills including estimating, problem solving, and the metric system.

Students learn terminology of Microsoft Windows, Microsoft Outlook, and Internet Explorer. Managing electronic files, scheduling, and privacy are also covered.

Word Processing 1 introduces students to word processing in a Windows environment. Students learn the main software features of MS Word and improve their keying speed and accuracy. Document formatting is presented during the course and students produce basic business documents using business formatting skills. Business standards in all documents are promoted throughout the course. The speed objective is 35 gross words a minute (gwam) in five-minute timings with five or fewer errors.

Word Processing 2 is a progression beyond Word Processing 1. Students continue to learn the main software features of MS Word and improve their keying speed and accuracy. Students produce basic business documents using business formatting skills. Business standards in all documents are promoted throughout the course. The speed objective is 45 gwam in a five-minute timing with five or fewer errors.

Bookkeeping 1 covers basic bookkeeping skills learning the nine steps of the manual accounting cycle including recognizing source documents, recording journal entries, posting to the general ledger, preparing a trial balance and worksheet, preparing financial statements to a professional level, recording adjusting and closing entries, and preparing a post-closing trial balance. The basics of special journals are covered as well as banking procedures and control of cash.

This course gives students the skills defined in the Office Administration and Applied Business Technology Provincial Curricula. These skills are considered to be essential requirements for today’s workforce. Employees need to be adaptable and capable of meeting the challenges of change in today’s economy, advances in technology, and changes in the way work is organized. This course uses an office simulation activity for students to practice job-ready skills in the use of technology and to hone their organizational and time management skills. The course also covers basic employment skills such as developing an effective resume and cover letter, and emphasizes professionalism, decision making, ethics, and communication skills.

Introduction to Spreadsheets: MS Excel 1 is designed to introduce students to the concepts of spreadsheets, formulas, graphs, and database features within spreadsheets.

OFAD 172 Bookkeeping 2 is an introduction to processing a company’s payroll. It covers calculating employees’ earnings and deductions, calculating employer payroll expenses, journalizing and posting the payroll, and disbursing payroll liabilities.

OFAD 275 Bookkeeping 3 is a continuation of both Bookkeeping 1 and Bookkeeping 2. It covers bookkeeping activities for a merchandising business, how to analyze and record purchases and sales, handle cash receipts and cash payments, maintain and reconcile subsidiary ledgers, and record taxes in special journals.

OFAD 178 provides training opportunities using Sage 50 for Windows. The course includes study of the General Ledger, Accounts Payable, Accounts Receivable, and Payroll and Inventory. Company setup and account linking are included.

The Microsoft Access OFAD 182 course covers introductory database functions to create and process data in a Windows environment. The student creates and modifies useful databases using tables and forms. The student creates and modifies professional quality reports and queries for the databases.

This course covers advanced applications in using financial functions, data tables, amortization schedules, and hyperlinks; creating, sorting and querying a worksheet database; and creating templates and working with multiple worksheets and workbooks.

This course covers advanced applications for working with large amounts of data through analyzing, validating, formula auditing, complex problem solving, automating and collaborating. PivotTables and PivotCharts are covered, as are trendlines, Solver, Scenario Manager, Visual Basic for Applications code, macros, controls, and the Compare and Merge Workbooks feature.