Materials of Music 5 (MUSC 3103)

Selected topics in theory and analysis. Selected topics change from time to time to accommodate perceived needs, popular topics or demand. The offerings are announced prior to the advising period for the following academic year in order for degree students to schedule their proposed plan of work. Prerequisite: Materials of Music 4 or permission.

Course code: MUSC 3103

Credits: 3.0

Tuition: $0^*

Length: 0.0 hours

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

Schedule†

MUSC 3103 schedule for programs:

MUSD

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
73600	Morrison, Ken	September 9, 2020 to December 18, 2020	Wed \| 9:00 a.m - 10:30 a.m	Morrison, Ken
73600 Online Delivery			Fri \| 11:00 a.m - 12:30 p.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-09-01 09:00:00.0	Wed	16-Dec-2020	2020-09-01 10:30:00.0	50005543	73600	8	202070	N	0	[empty string]	0900	ONLINE	2020-12-16 00:00:00.0	1029	[empty string]	L	2020-09-09 00:00:00.0	09-Sep-2020	Lecture
2	2020-09-01 11:00:00.0	Fri	18-Dec-2020	2020-09-01 12:30:00.0	50005543	73600	8	202070	N	0	[empty string]	1100	ONLINE	2020-12-18 00:00:00.0	1229	[empty string]	L	2020-09-11 00:00:00.0	11-Sep-2020	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 = 'MUSC' AND ssbsect.ssbsect_crse_numb = '3103' AND ssbsect.ssbsect_term_code >= 202070 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	73600
2	[empty string]

struct
1	73600
2	[empty string]

array

struct
1	MUSD MUSD
2	73600
3	[empty string]

Frequently asked questions

Ask a question

Meet with an advisor

Call +1.604.443.8600

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

Materials of Music 5 (MUSC 3103)

Schedule†

MUSC 3103 schedule for programs:

Additional Information

Ask a question