Computer
MicroComputer Certificate
The Microsoft Computer Certificate consists of five courses: four required and one elective. This program develops the level of computer literacy you need to compete in today’s job market.
See Business Fundamentals Certificate Program and Administrative Assistant Certificate for Course Schedule.
| Business Fundamentals Courses and Schedule 2018/2019 | ||||||
|---|---|---|---|---|---|---|
| Intro to Computers (ABTS 1200) (30) | YMCR 5030 | Lillooet | ||||
| Word Processing 1 (ABTS 1100) (45) | YMCR 5350 | Lillooet | ||||
| Spreadsheets 1 (ABTS 1210) (27) | YMCR 5140 | Lillooet | ||||
| Keyboarding 1 (ABTS 1130) (45) | XPCS 0710 | Lillooet | ||||
| Databases (ABTS 1230) (30) | YMCR 5160 | Lillooet | ||||
| Human Relations (ABTS 1500) (36) | XYMS 0400 | Lillooet | ||||
| Accounting 1 (ABTS 1430) (45) | XBKP 0600 | Lillooet | ||||
| Accounting 2 (ABTS 1440) (50) | XBKP 0610 | Lillooet | ||||
| Computerized Accounting (Sage 50) (ABTS 1410) (50) | YMCR 5150 | Lillooet | ||||
| Outlook | ABTS 1270 | Online/Williams Lake/Kamloops | ||||
Introduction to Computers • YMCR 5030/ABTS 1200
A solid understanding of a computer’s operating system is essential to using a microcomputer effectively. Students are introduced to operating systems at a fundamental level required for using an IBM or compatible microcomputer. Students learn the concepts of the DOS/WIndows operating system (OS) in preparation for further learning, and to manage a computer system
Prerequisites: Basic typing skills; YMCR 5030 is a prerequisite for all other courses in this program.
Word Processing 1 • YMCR 5350/ABTS 1100
Students are instructed in Microsoft Word for Windows. Students learn to create, edit and search documents, as well as use many additional extended features available in Word. Students should be prepared to devote additional non-class hours to exercises and project work.
Prerequisites: YMCR 5030 or computer file-management knowledge; knowledge of the standard keyboard.
Spreadsheets 1 • YMCR 5140/ABTS 1210
Students create and format spreadsheets to analyze and share information and to make informed decisions. This course offers an introduction to basic spreadsheet concepts (basics, file management, ranges, sorting, columns and rows), using Excel. These concepts include Excel's built-in functions (moving and copying data; formatting a worksheet; printing worksheets; functions and formulas (AutoSum, Inserting functions, Aver, Min and Max functions); referencing and absolutes (consolidating data with 3D references, now and today functions, absolute referencing); charts (creating a chart, selecting, moving, sizing and deleting chart items, preview and printing charts); and advanced built-in functions in Excel (financial function, using range names, split screens and freeze pane, working with clip art).
Prerequisites: YMCR 5030 or computer file-management knowledge.
Keyboarding 1 • XPCS 0710/ABTS 1130
Students are provided with the necessary techniques to keyboard accurately at a minimum of 25 net words per minute (nwpm).
Databases • YMCR 5160/ABTS 1230
This course is designed for students wishing to gain a basic understanding of a relational database software program. Students learn the basic concepts of database structure and design by creating a working model. The course concentrates on the concepts of a database while using the Microsoft Access database for Windows. You should be prepared to devote additional hours of non-class time to exercises and project work.
Prerequisites: YMCR 5030 or computer file-management knowledge and basic bookkeeping skills.
Human Relations • XYMS 0400/ABTS 1500
Students concentrate on developing the personal and professional development skills required in today’s workplace. These skills include self-examination and assessment, development of effective communication skills, interpersonal skills, client relations, teamwork, problem solving and an understanding of business ethics.
Accounting 1 • XBKP 0600/ABTS 1430
Students are introduced to manual accounting, with an emphasis on fundamental accounting principles and their application in day-to-day business situations. This course is based on a service business organized as a sole proprietorship. Students practice basic bookkeeping and accounting skills including double-entry general journal entries, posting to the general ledger, preparing a trial balance, recording adjustments in a ten-column worksheet, producing period-end financial statements, closing the temporary accounts, maintaining petty cash and preparing bank reconciliations.
Accounting 2 • XBKP 0610/ABTS 1440
Students are exposed to common accounting systems including sales, purchases, federal and provincial taxes, merchandise inventory, payroll and annual reporting of remittances. They also introduced to subsidiary ledgers, specialized journals, combined journals, year-end procedures and worksheets. Financial statements are prepared in detail, including a classified balance sheet and an income statement for a merchandising business.
Prerequisites: ABTS 1430
Computerized Accounting • YMCR 5150/ABTS 1410
This course is intended to teach the fundamental features and concepts of the Simply Accounting software program. Students are able to design, establish and manage an accounting system for a small business. This is a very intense, production-oriented course; students must be prepared to devote extra time outside the regularly scheduled lesson and laboratory work to get the most out of the course and to complete all course requirements to acceptable standards. This course is not intended to teach accounting principles.
Prerequisites: YMCR 5030 or computer file management knowledge; basic bookkeeping skills.
Outlook • ABTS 1270
Students are introduced to Microsoft Outlook and receive hands-on training in the use of email for online communications, calendar for managing important dates and appointments and contacts for the creation and maintenance of an address database.
