Advanced Data Analysis (LERN 1520)

After taking this Advanced course in Data Analysis, you will be able to perform inquiries that will be useful to your business or organization, and have the skill necessary to communicate these results through graphs and text that your fellow employees will understand. Take the guesswork out of important company decisions and make decisions based on statistically significant information. Whether your business is home based or a large company, this class will take you to the next level where important decision-making is concerned.
This course is offered in partnership with Learning Education Resource Network - UGotClass. For more information see: http://yougotclass.org/index.cfm/VCC

Course code: LERN 1520

Credits: 0.0

Tuition: $279^*

Length: 16 hours

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

Campus: Online

Prerequisites

Intermediate Data Analysis -LERN 1510

Schedule†

LERN 1520 schedule for programs:

LERN

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
30905		November 2, 2020 to November 27, 2020			Register Register /applying/apply-now/registering-to-cs/

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-08-01 00:00:00.0	[empty string]	27-Nov-2020	2020-08-01 00:00:00.0	[empty string]	30905	1000	202093	Y	0	[empty string]	[empty string]	ONLINE	2020-11-27 00:00:00.0	[empty string]	[empty string]	A	2020-11-02 00:00:00.0	02-Nov-2020	Lecture/Practical

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 = 'LERN' AND ssbsect.ssbsect_crse_numb = '1520' 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	30905
2	[empty string]

array

struct
1	LERN
2	30905
3	[empty string]

Additional Information

What you will learn

Developing a Survey
Comparing Means
Finding Differences between Groups
Individual Research Inquiries

How do I apply for this course?

This course is offered as part of a VCC program only.

How does the course work?

It is easy to participate in your online course. After you register, you will be given a web address to go to get into your online classroom. You will have a password and use your email address and password to gain access.
Once inside the online classroom, here’s what you can expect.
Participate when you want
You can participate any time of day or evening. The online classroom is open 24 hours a day, 7 days a week.
There are no live real-time requirements or meetings. You decide when you participate.
For the best learning, participants should log into the course on 2-3 different days of the week.

For each Unit, you will:
Read the print readings (about 20 pages a week)
Have the option of accessing the online readings
Listen to the audio presentation for the Unit and view the slides
Have the option of taking a self-quiz to see how much you have learned
Engage in written online discussion with your instructor and other participants
For best learning, you should make one or more comments at 2-3 different times each week.
The content (readings, audio lectures, slides) and self quizzes are accessible for the entire course, so you can work ahead, or go back and review again, at your convenience.

What are the completion requirements?

As non-credit, in which case you can participate as little or as much as you like;

For completion and recognition, the requirements are as follow:

a) Make at least one comment every week in the discussion.
- The comment should show thought and be more substantive than just “Yes, I agree.” There is no length required for comments.
- Replies to other comments, responses to other participants, count as comments (in most cases your instructor value replies and responses as comments).
- Questions and online discussion facilitative comments also count as well as long as there is some thought to them.

b) Take every Unit self-quiz.
- Take every Unit self-quiz for the course and get at least 80% score.
- You may retake any self-quiz as often as you need to get to the 80% level.

-The requirements should be done by the last day of the course.

-Individual instructors may extend the deadline upon request.

-If, for any reason, you are not able to complete the requirements during the course, we are pleased to provide you with our Course Transfer Option. You may retake any or all of the same UGotClass online course at a future offering within the next 12 months, and you can do so at no extra cost.

How is competition recognition awarded?
-For individual courses, a pdf transcript is issued showing completion.
-For certificates and certification, a pdf certificate is issued showing completion.

What is the LERN refund policy?

If, for any reason, you are not able to complete the requirements during the course, we are pleased to provide you with our Course Transfer Option.You may retake any or all of the same UGotClass online course at a future offering within the next 12 months, and you can do so at no extra cost.

Want to know more?

Email lern@vcc.ca

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.

Advanced Data Analysis (LERN 1520)

Prerequisites

Schedule†

LERN 1520 schedule for programs:

Additional Information

Ask a question