Spreadsheet Management 12 (COMP 0984)

This course provides students with the knowledge and skills needed to use advanced spreadsheet data entry and formatting techniques. Students apply statistical, financial and decision-making functions, cell protection and data validation. Students create macros to automate worksheet management.

Completion of 2 of the following courses is required for completion of ABE Provincial Level Computer Studies: COMP 0982, COMP 0984, COMP 0985.

COMP 0982, 0984 and 0985 may be taken in any order.

Course code: COMP 0984

Credits: 4.0

Tuition: $0^*

Length: 96 hours

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

Campus: Broadway

Prerequisites

Grade 10 English or equivalent

Schedule†

COMP 0984 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
60767	Elliott, Brock	May 1, 2020 to October 31, 2020	Mon, Tue, Wed, Thu \| 3:30 p.m - 6:30 p.m	Elliott, Brock
60859	Elliott, Brock	June 1, 2020 to November 30, 2020	Mon, Tue, Wed, Thu \| 3:30 p.m - 6:30 p.m	Elliott, Brock
74039	Elliott, Brock	September 1, 2020 to December 23, 2020	Mon, Tue, Wed, Thu \| 3:30 p.m - 6:30 p.m	Elliott, Brock
74215	Elliott, Brock	October 1, 2020 to January 31, 2021	Mon, Tue, Wed, Thu \| 3:30 p.m - 6:30 p.m	Elliott, Brock
74302	Elliott, Brock	November 1, 2020 to February 28, 2021	Mon, Tue, Wed, Thu \| 3:30 p.m - 6:30 p.m	Elliott, Brock
74408	Elliott, Brock	December 1, 2020 to March 31, 2021	Mon, Tue, Wed, Thu \| 3:30 p.m - 6:30 p.m	Elliott, Brock
45248	Elliott, Brock	January 1, 2021 to April 30, 2021	Mon, Tue, Wed, Thu \| 3:30 p.m - 6:30 p.m	Elliott, Brock
45353	Elliott, Brock	February 1, 2021 to May 31, 2021	Mon, Tue, Wed, Thu \| 3:30 p.m - 6:30 p.m	Elliott, Brock
45432	Elliott, Brock	March 1, 2021 to June 30, 2021	Mon, Tue, Wed, Thu \| 3:30 p.m - 6:30 p.m	Elliott, Brock

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-07-01 15:30:00.0	Mon Tue Wed Thu	30-Jun-2020	2020-07-01 18:30:00.0	50000564	60767	20	202060	N	0	[empty string]	1530	ONLINE	2020-06-30 00:00:00.0	1829	[empty string]	S	2020-05-01 00:00:00.0	01-May-2020	Self Paced
2	2020-07-01 15:30:00.0	Mon Tue Wed Thu	30-Jun-2020	2020-07-01 18:30:00.0	50000564	60859	21	202060	N	0	[empty string]	1530	ONLINE	2020-06-30 00:00:00.0	1829	[empty string]	S	2020-06-01 00:00:00.0	01-Jun-2020	Self Paced
3	2020-07-01 15:30:00.0	Mon Tue Wed Thu	31-Oct-2020	2020-07-01 18:30:00.0	50000564	60767	20	202060	N	0	[empty string]	1530	ONLINE	2020-10-31 00:00:00.0	1829	[empty string]	S	2020-09-01 00:00:00.0	01-Sep-2020	Self Paced
4	2020-07-01 15:30:00.0	Mon Tue Wed Thu	30-Nov-2020	2020-07-01 18:30:00.0	50000564	60859	21	202060	N	0	[empty string]	1530	ONLINE	2020-11-30 00:00:00.0	1829	[empty string]	S	2020-09-01 00:00:00.0	01-Sep-2020	Self Paced
5	2020-07-01 15:30:00.0	Mon Tue Wed Thu	23-Dec-2020	2020-07-01 18:30:00.0	50000564	74039	20	202070	Y	0	[empty string]	1530	ONLINE	2020-12-23 00:00:00.0	1829	[empty string]	S	2020-09-01 00:00:00.0	01-Sep-2020	Self Paced
6	2020-07-01 15:30:00.0	Mon Tue Wed Thu	31-Jan-2021	2020-07-01 18:30:00.0	50000564	74215	22	202070	Y	0	[empty string]	1530	ONLINE	2021-01-31 00:00:00.0	1829	[empty string]	S	2020-10-01 00:00:00.0	01-Oct-2020	Self Paced
7	2020-07-01 15:30:00.0	Mon Tue Wed Thu	28-Feb-2021	2020-07-01 18:30:00.0	50000564	74302	22	202070	Y	0	[empty string]	1530	ONLINE	2021-02-28 00:00:00.0	1829	[empty string]	S	2020-11-01 00:00:00.0	01-Nov-2020	Self Paced
8	2020-07-01 15:30:00.0	Mon Tue Wed Thu	31-Mar-2021	2020-07-01 18:30:00.0	50000564	74408	22	202070	Y	0	[empty string]	1530	ONLINE	2021-03-31 00:00:00.0	1829	[empty string]	S	2020-12-01 00:00:00.0	01-Dec-2020	Self Paced
9	2020-07-01 15:30:00.0	Mon Tue Wed Thu	30-Apr-2021	2020-07-01 18:30:00.0	50000564	45248	22	202140	N	0	[empty string]	1530	DTN	2021-04-30 00:00:00.0	1829	[empty string]	S	2021-01-01 00:00:00.0	01-Jan-2021	Self Paced
10	2020-07-01 15:30:00.0	Mon Tue Wed Thu	31-May-2021	2020-07-01 18:30:00.0	50000564	45353	22	202140	N	0	[empty string]	1530	DTN	2021-05-31 00:00:00.0	1829	[empty string]	S	2021-02-01 00:00:00.0	01-Feb-2021	Self Paced
11	2020-07-01 15:30:00.0	Mon Tue Wed Thu	30-Jun-2021	2020-07-01 18:30:00.0	50000564	45432	22	202140	N	0	[empty string]	1530	DTN	2021-06-30 00:00:00.0	1829	[empty string]	S	2021-03-01 00:00:00.0	01-Mar-2021	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 = '0984' AND ssbsect.ssbsect_term_code >= 202060 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	60767
2	[empty string]

struct
1	60859
2	[empty string]

struct
1	60767
2	[empty string]

struct
1	60859
2	[empty string]

struct
1	74039
2	[empty string]

struct
1	74215
2	[empty string]

struct
1	74302
2	[empty string]

struct
1	74408
2	[empty string]

struct
1	45248
2	[empty string]

struct
1	45353
2	[empty string]

struct
1	45432
2	[empty string]

array

struct
1	HMFT LNCT HMFT LNCT
2	60767 60859 74039 74215 74302 74408 45248 45353 45432
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.

Spreadsheet Management 12 (COMP 0984)

Prerequisites

Schedule†

COMP 0984 schedule for programs:

Additional Information

Contact us