Cognitive & Mental Challenges (HRCA 1291)

This course builds on content from other courses to assist students to explore concepts and care-giving approaches that will allow them to work effectively with individuals experiencing cognitive or mental challenges. The emphasis in this course is on supporting clients with dementia, recognizing responsive behaviours and identifying person-centred intervention strategies. This course is part of the full-time Health Care Assistant Program

Course code: HRCA 1291

Credits: 3.0

Tuition: $0^*

Length: 60 hours

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

Schedule†

HRCA 1291 schedule for programs:

HCAT

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
43963	Casajoras, Akie	May 4, 2020 to May 15, 2020	Mon, Tue, Wed, Thu, Fri \| 7:45 a.m - 3:15 p.m	Casajoras, Akie
61314		August 31, 2020 to September 11, 2020	Mon, Tue, Wed, Thu, Fri \| 8:00 a.m - 3:00 p.m
44627		January 11, 2021 to February 26, 2021	Mon, Tue, Fri \| 8:00 a.m - 11:00 a.m

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-04-01 07:45:00.0	Mon Tue Wed Thu Fri	15-May-2020	2020-04-01 15:15:00.0	50300801	43963	3	202040	N	0	HCAT1214	0745	BWY-B	2020-05-15 00:00:00.0	1514	2209	L	2020-05-04 00:00:00.0	04-May-2020	Lecture
2	2020-04-01 08:00:00.0	Mon Tue Wed Thu Fri	11-Sep-2020	2020-04-01 15:00:00.0	[empty string]	61314	12	202060	N	0	HCAT121	0800	BWY-B	2020-09-11 00:00:00.0	1500	2228	L	2020-08-31 00:00:00.0	31-Aug-2020	Lecture
3	2020-04-01 08:00:00.0	Mon Tue Fri	26-Feb-2021	2020-04-01 11:00:00.0	[empty string]	44627	37	202140	N	0	HCAT121	0800	BWY-B	2021-02-26 00:00:00.0	1059	2209	L	2021-01-11 00:00:00.0	11-Jan-2021	Lecture

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 = 'HRCA' AND ssbsect.ssbsect_crse_numb = '1291' 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	43963
2	HCAT1214

struct
1	61314
2	HCAT121

struct
1	44627
2	HCAT121

array

struct
1	HCAT
2	43963 61314 44627
3	HCAT1214

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.

Cognitive & Mental Challenges (HRCA 1291)

Schedule†

HRCA 1291 schedule for programs:

Additional Information

Contact us