Excel Level 1 (CMPT 1129)

Learn to work with worksheets and workbooks to analyze data using a variety of features to create, modify, and format common business reports such as budgets, reports, and charts. Designed for students who need to create basic formulas, edit formulas, format, chart, and print. Required: Please purchase textbook from the Downtown Campus Bookstore before the course start date.

Course code: CMPT 1129

Credits: 0.0

Tuition: $244^*

Length: 7 hours

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

Campus: Downtown

Prerequisites

Recommended: Basic knowledge of Windows, or CMPT 1302 (Introduction to Computers and File Management) course.

Schedule†

CMPT 1129 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
20813	Loewenthal, Colin	April 4, 2020 to April 4, 2020	Sat \| 9:00 a.m - 5:00 p.m	Loewenthal, Colin	Register Register /applying/apply-now/registering-to-cs/
20819	Loewenthal, Colin	May 2, 2020 to May 2, 2020	Sat \| 9:00 a.m - 5:00 p.m	Loewenthal, Colin	Register Register /applying/apply-now/registering-to-cs/
20999	Loewenthal, Colin	June 6, 2020 to June 6, 2020	Sat \| 9:00 a.m - 5:00 p.m	Loewenthal, Colin	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-03-01 09:00:00.0	Sat	04-Apr-2020	2020-03-01 17:00:00.0	30145882	20813	9	202092	Y	0	[empty string]	0900	DTN	2020-04-04 00:00:00.0	1700	416	B	2020-04-04 00:00:00.0	04-Apr-2020	Lab
2	2020-03-01 09:00:00.0	Sat	02-May-2020	2020-03-01 17:00:00.0	30145882	20819	15	202092	Y	0	[empty string]	0900	DTN	2020-05-02 00:00:00.0	1700	416	B	2020-05-02 00:00:00.0	02-May-2020	Lab
3	2020-03-01 09:00:00.0	Sat	06-Jun-2020	2020-03-01 17:00:00.0	30145882	20999	15	202092	Y	0	[empty string]	0900	DTN	2020-06-06 00:00:00.0	1700	619	B	2020-06-06 00:00:00.0	06-Jun-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 = '1129' 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	20813
2	[empty string]

struct
1	20819
2	[empty string]

struct
1	20999
2	[empty string]

array

struct
1	CMPT
2	20813 20819 20999
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.

Excel Level 1 (CMPT 1129)

Prerequisites

Schedule†

CMPT 1129 schedule for programs:

Additional Information

Ask a question