Practicum - Employment (CNSK 1489)

The practicum provides an opportunity for students to master, integrate and display the knowledge and skills which have been taught during the classroom component of the Addiction or Community Counselling Skills Certificate. The worksite practicum recognizes the knowledge and skills of students who are currently working in a social service, substance misuse or corrections agency and allows them to meet practicum course goals by integrating their knowledge and skills in a combination of graded classroom presentations and an evaluated skill based assignment. Prerequisite: Successful completion of all required courses in the Addiction or the Community Counselling Skills Certificate Program.

Course code: CNSK 1489

Credits: 4.0

Tuition: $570^*

Length: 150 hours

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

Schedule†

CNSK 1489 schedule for programs:

CNSK

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
10725	Stirling, Sarah	January 8, 2020 to April 29, 2020	Wed \| 6:30 p.m - 9:30 p.m	Stirling, Sarah	In progress

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 18:30:00.0	Wed	08-Jan-2020	2020-03-01 21:30:00.0	50106731	10725	48	202091	N	0	[empty string]	1830	DTN	2020-01-08 00:00:00.0	2130	423	P	2020-01-08 00:00:00.0	08-Jan-2020	Practicum
2	2020-03-01 18:30:00.0	Wed	22-Jan-2020	2020-03-01 21:30:00.0	50106731	10725	48	202091	N	0	[empty string]	1830	DTN	2020-01-22 00:00:00.0	2130	423	P	2020-01-22 00:00:00.0	22-Jan-2020	Practicum
3	2020-03-01 18:30:00.0	Wed	05-Feb-2020	2020-03-01 21:30:00.0	50106731	10725	48	202091	N	0	[empty string]	1830	DTN	2020-02-05 00:00:00.0	2130	423	P	2020-02-05 00:00:00.0	05-Feb-2020	Practicum
4	2020-03-01 18:30:00.0	Wed	19-Feb-2020	2020-03-01 21:30:00.0	50106731	10725	48	202091	N	0	[empty string]	1830	DTN	2020-02-19 00:00:00.0	2130	423	P	2020-02-19 00:00:00.0	19-Feb-2020	Practicum
5	2020-03-01 18:30:00.0	Wed	04-Mar-2020	2020-03-01 21:30:00.0	50106731	10725	48	202091	N	0	[empty string]	1830	DTN	2020-03-04 00:00:00.0	2130	423	P	2020-03-04 00:00:00.0	04-Mar-2020	Practicum
6	2020-03-01 18:30:00.0	Wed	18-Mar-2020	2020-03-01 21:30:00.0	50106731	10725	48	202091	N	0	[empty string]	1830	DTN	2020-03-18 00:00:00.0	2130	423	P	2020-03-18 00:00:00.0	18-Mar-2020	Practicum
7	2020-03-01 18:30:00.0	Wed	01-Apr-2020	2020-03-01 21:30:00.0	50106731	10725	48	202091	N	0	[empty string]	1830	DTN	2020-04-01 00:00:00.0	2130	423	P	2020-04-01 00:00:00.0	01-Apr-2020	Practicum
8	2020-03-01 18:30:00.0	Wed	15-Apr-2020	2020-03-01 21:30:00.0	50106731	10725	48	202091	N	0	[empty string]	1830	DTN	2020-04-15 00:00:00.0	2130	423	P	2020-04-15 00:00:00.0	15-Apr-2020	Practicum
9	2020-03-01 18:30:00.0	Wed	29-Apr-2020	2020-03-01 21:30:00.0	50106731	10725	48	202091	N	0	[empty string]	1830	DTN	2020-04-29 00:00:00.0	2130	423	P	2020-04-29 00:00:00.0	29-Apr-2020	Practicum

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 = 'CNSK' AND ssbsect.ssbsect_crse_numb = '1489' 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	10725
2	[empty string]

struct
1	10725
2	[empty string]

struct
1	10725
2	[empty string]

struct
1	10725
2	[empty string]

struct
1	10725
2	[empty string]

struct
1	10725
2	[empty string]

struct
1	10725
2	[empty string]

struct
1	10725
2	[empty string]

struct
1	10725
2	[empty string]

array

struct
1	CNSK CNSK CNSK CNSK CNSK CNSK CNSK CNSK CNSK
2	10725
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.

Practicum - Employment (CNSK 1489)

Schedule†

CNSK 1489 schedule for programs:

Additional Information

Ask a question