Introduction to Spreadsheets (COMP 0832)

This course covers the basic skills needed to produce reports that involve numbers and calculations. Students learn how to enter and edit text and numeric data; enter calculating formulas and statistical functions; format numbers and text to produce clear, accurate and attractive printouts, and create simple charts to show relationships between numeric data.

Course code: COMP 0832

Credits: 0.0

Tuition: $0^*

Length: 96 hours

Campus: Broadway

Prerequisites

Introduction to Windows (COMP 0735) or equivalent
Grade 9 English or equivalent (English 041, CLB 6, or ESL Upper Advanced)

Schedule†

COMP 0832 schedule for programs:

HMFT
LNCT

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
44561	Elliott, Brock	01-Jan-2020 to 30-Apr-2020		Elliott, Brock
44533	Dilek, Rita	01-Jan-2020 to 30-Apr-2020		Dilek, Rita
44563	Dilek, Rita	01-Jan-2020 to 30-Apr-2020	Mon, Tue, Wed, Thu, Fri \| 12:00 a.m - 12:00 a.m	Dilek, Rita
44604	Elliott, Brock	01-Feb-2020 to 31-May-2020		Elliott, Brock
44577	Dilek, Rita	01-Feb-2020 to 31-May-2020	Mon, Tue, Wed, Thu, Fri \| 12:00 a.m - 12:00 a.m	Dilek, Rita
44608	Dilek, Rita	01-Feb-2020 to 31-May-2020		Dilek, Rita
44646	Elliott, Brock	01-Mar-2020 to 30-Jun-2020		Elliott, Brock
44619	Dilek, Rita	01-Mar-2020 to 30-Jun-2020	Mon, Tue, Wed, Thu, Fri \| 12:00 a.m - 12:00 a.m	Dilek, Rita
44650	Dilek, Rita	01-Mar-2020 to 30-Jun-2020		Dilek, Rita

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-01-01 15:30:00.0	[empty string]	30-Apr-2020	2020-01-01 18:30:00.0	50000564	44561	20	202040	N	0	[empty string]	1530	DTN	2020-04-30 00:00:00.0	1829	[empty string]	S	2020-01-01 00:00:00.0	01-Jan-2020	Self Paced
2	2020-01-01 00:00:00.0	[empty string]	30-Apr-2020	2020-01-01 00:00:00.0	50046015	44533	999	202040	N	0	[empty string]	[empty string]	ONLINE	2020-04-30 00:00:00.0	[empty string]	[empty string]	S	2020-01-01 00:00:00.0	01-Jan-2020	Self Paced
3	2020-01-01 00:00:00.0	Mon Tue Wed Thu Fri	30-Apr-2020	2020-01-01 00:00:00.0	50046015	44563	999	202040	N	0	[empty string]	[empty string]	BWY-A	2020-04-30 00:00:00.0	[empty string]	[empty string]	S	2020-01-01 00:00:00.0	01-Jan-2020	Self Paced
4	2020-01-01 15:30:00.0	[empty string]	31-May-2020	2020-01-01 18:30:00.0	50000564	44604	22	202040	N	0	[empty string]	1530	DTN	2020-05-31 00:00:00.0	1829	[empty string]	S	2020-02-01 00:00:00.0	01-Feb-2020	Self Paced
5	2020-01-01 00:00:00.0	Mon Tue Wed Thu Fri	31-May-2020	2020-01-01 00:00:00.0	50046015	44577	999	202040	N	0	[empty string]	[empty string]	BWY-A	2020-05-31 00:00:00.0	[empty string]	[empty string]	S	2020-02-01 00:00:00.0	01-Feb-2020	Self Paced
6	2020-01-01 00:00:00.0	[empty string]	31-May-2020	2020-01-01 00:00:00.0	50046015	44608	999	202040	N	0	[empty string]	[empty string]	ONLINE	2020-05-31 00:00:00.0	[empty string]	[empty string]	S	2020-02-01 00:00:00.0	01-Feb-2020	Self Paced
7	2020-01-01 15:30:00.0	[empty string]	30-Jun-2020	2020-01-01 18:30:00.0	50000564	44646	22	202040	N	0	[empty string]	1530	DTN	2020-06-30 00:00:00.0	1829	[empty string]	S	2020-03-01 00:00:00.0	01-Mar-2020	Self Paced
8	2020-01-01 00:00:00.0	Mon Tue Wed Thu Fri	30-Jun-2020	2020-01-01 00:00:00.0	50046015	44619	999	202040	N	0	[empty string]	[empty string]	BWY-A	2020-06-30 00:00:00.0	[empty string]	[empty string]	S	2020-03-01 00:00:00.0	01-Mar-2020	Self Paced
9	2020-01-01 00:00:00.0	[empty string]	30-Jun-2020	2020-01-01 00:00:00.0	50046015	44650	999	202040	N	0	[empty string]	[empty string]	ONLINE	2020-06-30 00:00:00.0	[empty string]	[empty string]	S	2020-03-01 00:00:00.0	01-Mar-2020	Self Paced

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 = 'COMP' AND ssbsect.ssbsect_crse_numb = '0832' 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	44561
2	[empty string]

struct
1	44533
2	[empty string]

struct
1	44563
2	[empty string]

struct
1	44604
2	[empty string]

struct
1	44577
2	[empty string]

struct
1	44608
2	[empty string]

struct
1	44646
2	[empty string]

struct
1	44619
2	[empty string]

struct
1	44650
2	[empty string]

array

struct
1	HMFT LNCT
2	44561 44533 44563 44604 44577 44608 44646 44619 44650
3	[empty string]

Contact us

Frequently asked questions

Ask a question

Book an appointment with an advisor

fill out an online form
Call 604.871.7000, option 2

INTERNATIONAL STUDENTS

Visit VCC International for contact information.

* 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.

Introduction to Spreadsheets (COMP 0832)

Prerequisites

Schedule†

COMP 0832 schedule for programs:

Additional Information

Contact us