QuickBooks Level 1 (CMPT 1362)

Learn how to perform daily accounting tasks including: working with Customers Centre, Employee Centre, and Vendor Centre; writing cheques, transferring money between accounts, and reconciling accounts; working with asset, liability, and equity accounts; processing sales orders and recording customer payments, accounts payable and accounts receivable; entering and paying bills; and basic payroll functions. Students should be familiar with the following accounting terms: asset, liability, equity, balance sheet, trial balance, income statement, debit & credit, ledger & journal, accounts payable & accounts receivable, and federal government remittance process for GST/HST. Required: Please purchase textbook from Downtown Campus Bookstore before the course start date. Please bring a USB flash drive to class.

Course code: CMPT 1362

Credits: 0.0

Tuition: $390^*

Length: 18 hours

Course outline: https://www.vcc.ca/cfm-files/course-outline.cfm?subject=CMPT&number=1362

Campus: Downtown

Prerequisites

Recommended: Ability to use computers comfortably, and basic bookkeeping knowledge.

Schedule†

CMPT 1362 schedule for programs:

CMPT

Course dates and times may vary throughout the term. Select the CRN number below to see a full schedule.

CRN #	Instructor	Dates	Day/Time	Instructor	Register
10631	Shaw, Todd	February 8, 2020 to February 29, 2020	Sat \| 9:00 a.m - 4:00 p.m	Shaw, Todd	In progress
20799	Shaw, Todd	April 4, 2020 to April 25, 2020	Sat \| 9:00 a.m - 4:00 p.m	Shaw, Todd	Register Register /applying/apply-now/registering-to-cs/
20804	Shaw, Todd	May 9, 2020 to May 30, 2020	Sat \| 9:00 a.m - 4:00 p.m	Shaw, Todd	Register Register /applying/apply-now/registering-to-cs/
20817	Shaw, Todd	July 4, 2020 to July 18, 2020	Sat \| 9:00 a.m - 4:00 p.m	Shaw, Todd	Register Register /applying/apply-now/registering-to-cs/

query

RESULTSET

query
	BEGIN_TIME_ROUND	DAY_OF_WEEK	END_DATE	END_TIME_ROUND	SIRASGN_PIDM	SSBSECT_CRN	SSBSECT_SEATS_AVAIL	SSBSECT_TERM_CODE	SSBSECT_VOICE_AVAIL	SSBSECT_WAIT_COUNT	SSRBLCK_BLCK_CODE	SSRMEET_BEGIN_TIME	SSRMEET_BLDG_CODE	SSRMEET_END_DATE	SSRMEET_END_TIME	SSRMEET_ROOM_CODE	SSRMEET_SCHD_CODE	SSRMEET_START_DATE	START_DATE	STVSCHD_DESC
1	2020-02-01 09:00:00.0	Sat	29-Feb-2020	2020-02-01 16:00:00.0	50165292	10631	3	202091	Y	0	[empty string]	0900	DTN	2020-02-29 00:00:00.0	1600	829	B	2020-02-08 00:00:00.0	08-Feb-2020	Lab
2	2020-02-01 09:00:00.0	Sat	25-Apr-2020	2020-02-01 16:00:00.0	50165292	20799	15	202092	Y	0	[empty string]	0900	DTN	2020-04-25 00:00:00.0	1600	829	B	2020-04-04 00:00:00.0	04-Apr-2020	Lab
3	2020-02-01 09:00:00.0	Sat	30-May-2020	2020-02-01 16:00:00.0	50165292	20804	15	202092	Y	0	[empty string]	0900	DTN	2020-05-30 00:00:00.0	1600	829	B	2020-05-09 00:00:00.0	09-May-2020	Lab
4	2020-02-01 09:00:00.0	Sat	18-Jul-2020	2020-02-01 16:00:00.0	50165292	20817	15	202092	Y	0	[empty string]	0900	DTN	2020-07-18 00:00:00.0	1600	829	B	2020-07-04 00:00:00.0	04-Jul-2020	Lab

CACHED

false

EXECUTIONTIME

SQL

SELECT ssbsect_crn, ssbsect_term_code, ssrblck_blck_code, ssrmeet_start_date, ssrmeet_end_date, TO_CHAR(ssrmeet_start_date, 'DD-Mon-YYYY') AS start_date, TO_CHAR(ssrmeet_end_date, 'DD-Mon-YYYY') AS end_date, ssrmeet_begin_time, ssrmeet_end_time, TRUNC( TO_DATE(CONCAT(ssrmeet_begin_time,'00'),'HH24:MI:SS')) + ( ROUND( (TO_DATE(CONCAT(ssrmeet_begin_time,'00'),'HH24:MI:SS') - TRUNC(TO_DATE(CONCAT(ssrmeet_begin_time,'00'),'HH24:MI:SS')) ) * 96 ) / 96) as begin_time_round, TRUNC( TO_DATE(CONCAT(ssrmeet_end_time,'00'),'HH24:MI:SS')) + ( ROUND( (TO_DATE(CONCAT(ssrmeet_end_time,'00'),'HH24:MI:SS') - TRUNC(TO_DATE(CONCAT(ssrmeet_end_time,'00'),'HH24:MI:SS')) ) * 96 ) / 96) as end_time_round, DECODE(ssrmeet_sun_day, 'U', 'Sun ', '') || DECODE(ssrmeet_mon_day, 'M', 'Mon ', '') || DECODE(ssrmeet_tue_day, 'T', 'Tue ', '') || DECODE(ssrmeet_wed_day, 'W', 'Wed ', '') || DECODE(ssrmeet_thu_day, 'R', 'Thu ', '') || DECODE(ssrmeet_fri_day, 'F', 'Fri ', '') || DECODE(ssrmeet_sat_day, 'S', 'Sat ','') AS day_of_week, ssrmeet_bldg_code, ssrmeet_room_code, sirasgn_pidm, ssbsect_seats_avail, ssbsect_wait_count, ssbsect_voice_avail, ssrmeet_schd_code, stvschd_desc FROM ssbsect INNER JOIN stvschd ON ssbsect_schd_code = stvschd_code AND ssbsect_schd_code NOT IN ('PLA', 'CL', 'CB', 'CI', 'T') LEFT OUTER JOIN ssrblck ON ssrblck_term_code = ssbsect_term_code AND ssrblck_crn = ssbsect_crn LEFT OUTER JOIN ssrmeet ON ssrmeet_term_code = ssbsect_term_code AND ssrmeet_crn = ssbsect_crn LEFT OUTER JOIN sirasgn ON sirasgn_crn = ssbsect_crn AND sirasgn_term_code = ssbsect_term_code WHERE ssbsect.ssbsect_subj_code = 'CMPT' AND ssbsect.ssbsect_crse_numb = '1362' AND ssbsect.ssbsect_term_code >= 202040 AND ssbsect.ssbsect_ssts_code = 'A' AND ssbsect.ssbsect_ptrm_end_date > sysdate-1 ORDER BY ssrmeet_start_date, ssrmeet_begin_time, ssbsect_crn

array

struct
1	10631
2	[empty string]

struct
1	20799
2	[empty string]

struct
1	20804
2	[empty string]

struct
1	20817
2	[empty string]

array

struct
1	CMPT
2	10631 20799 20804 20817
3	[empty string]

Frequently asked questions

cstudies@vcc.ca

Meet with an advisor

604.443.8484

International students

* Fees are approximate and subject to change. Students are required to pay any applicable fee increases. Fees listed are for domestic students. For international programs, visit VCC International.

† This information is intended as a guideline only. Program and course details are subject to change with the approval of VCC's Board of Governors.

QuickBooks Level 1 (CMPT 1362)

Prerequisites

Schedule†

CMPT 1362 schedule for programs:

Additional Information

Ask a question