Big Data Solution Architecture
2021/22 | Conestoga College
Program Code: 1448
Applied Computer Science & Information Technology
Conestoga College Institute of Technology and Advanced Learning
This is a companion document to the current Conestoga College Student Guide
COVID-19 and 2021-22 Program Delivery
In response to the COVID-19 pandemic, Conestoga academic plans and decisions will continue to evolve to reflect the advice of public health authorities. Please consult the COVID-19 Information page for the most up-to-date information on college protocols.
Expectations regarding course delivery, participation, and assessments will be communicated by your faculty member at the start of the semester and included in the instructional plan.
Program technology requirements are posted on the program web page. Students in remote and hybrid delivery courses will require a device, webcam functionality, and reliable Internet access.
Program Handbook Guidelines
The purpose of this handbook is to provide students with program-specific details and other important information. The material in this handbook is accurate at the date of posting, and is applicable for the current academic year. Students will be informed of handbook changes that occur, if any, through college email. Program handbooks are updated yearly and students must check their program handbook for the current edition.
Conestoga offers a wide range of programs to empower your professional journey in a rapidly growing sector. Our diplomas, advanced diplomas, graduate certificates, and degrees will prepare you for your future by providing you with experiential and hands-on learning opportunities.
The School offers an unparalleled opportunity to advance your education. Our state-of-the-art facilities provide a cutting-edge educational experience in the heart of a uniquely advantageous location: Silicon Valley North (Waterloo Region). Our strong connections to local industry enable us to provide project-based learning and work-integrated learning, where you can solve real-world problems and engage in new technologies. Our faculty team maintains strong ties to Waterloo Region’s innovation sector, bringing fresh and relevant content to our programs.
What you do here…counts out there; and what you do in our School will prepare you for an exciting future in the dynamic world of ICT.
Program Staff Contact Information
Executive Dean – Applied Computer Science & Information Technology and Creative Industries
519 748 5220 ext. 5177
Student Success Advisor
In addition to the core complement of your full-time program faculty, other faculty will work with you for the duration of this program. These include faculty from other Schools for breadth and/or general education courses, as well as faculty with particular expertise in specific areas of program focus.
Contact information for this faculty will typically be provided on the first day of related courses.
Companies that embrace modern information technology must deal with very large amounts of data. This "Big Data" often shows patterns and trends on which to make good business decisions. To support Business Analysts, students in this program focus on the collection, processing and presentation of these large data sets. Developing skills in solution development, database design (both SQL and NoSQL), data processing, data warehousing and data visualization help build a solid foundation in this important support role. Through applied learning techniques such as problem-based learning, students will be able to apply their learning to real world problems.
Students can find their program design on the Student Portal by following the steps below:
- Log in to Student Portal
- Click on 'My Courses' tab
- Select 'View Progress Report' button
Courses are listed by level/semester. Students can also view courses for the most current program design for this academic year on the Conestoga website. To find these courses, students need to scroll down the page to the 'Program Courses'.
Program outcomes are developed with the expectations and requirements of external regulatory/accrediting bodies and consultation with Program Advisory Committees (PACs) and related industry experts. These outcomes are coordinated and articulated in a manner designed to result in the achievement by of sets of specified learning attributes.
Program Outcomes are located on the
Program Academic Achievement and Requirements
Academic Promotion Decisions
Students actively registered in cohort delivered programs who take longer than the designed program length of time to complete their studies are accountable for completing any new or additional courses that may result due to changes in the program of study.
Discontinued students cannot graduate from this program without first applying and being granted re-admission to the program. Readmission requires successful completion of all failed courses as a part time student.
Clearance of Academic Deficiency
As per program policy if a student has failed a course or dropped one or more courses in an academic level (also known as an academic deficiency), the student will be placed on academic probation and will - at a minimum, be required to pass the failed or dropped course before being cleared.
It is important that all students be aware of their academic standing and work with faculty members to find ways to quickly clear academic deficiencies.
The following establishes the standards associated with clearance of the academic deficiencies.
If available in a semester the student is enrolled, a previously failed or dropped course must be ahead of any other available courses available that semester. This includes giving missed or dropped courses priority in the case of timetable conflicts with other courses.
Where a student is assigned an "Incomplete" in a course, the requirements for clearing the incomplete will be communicated to the student by the faculty responsible for the course.
Courses may only be taken where the student has the necessary pre-requisites, as defined in the Program Design.
A student may be eligible for a supplemental opportunity if all the following criteria are met:
With respect to the failed course(s), the student:
- Must have a minimum 50% average, including assignments.
- Must have maintained regular attendance in the course(s) failed with a minimum of 75% attendance in all scheduled classes and labs.
- Must have passed at least
If successful, the failing grade can be upgraded only to the minimal passing grade of 55%.
Students shall be granted only ONE supplemental opportunity per term, subject to all criteria being met for the course.
A supplemental evaluation will not be granted for a course in which a student has received an academic offense. An academic incident resulting in a warning is not considered an academic offense for supplemental evaluation purposes.
For more information, visit the College Policies Procedures,Practices and Guidelines webpage then click on the Academic Administration side tab and search for the document entitled “Clearance of Academic Deficiency”.
Students that fail a course, or drop two or more courses in a given level are placed on academic probation. It is important that all students be aware of their academic standing and work with faculty members to find ways to quickly clear academic deficiencies.
You will be discontinued from the program if you have two failed courses in a level, or fail additional courses while on academic probation. You will also be discontinued if you fail the same course twice
You must also complete your program within 4 years of starting the program or you will be discontinued.
Once discontinued you may not take courses in the Big Data Solution Architecture (including through part-time studies) for one semester following the discontinuance.
Please check the Conestoga College website for
Students are eligible to graduate upon completion of all academic requirements in their program of study, including co-op work terms if applicable. Students are expected to respond to their invitation through their Student Portal.
Convocation ceremonies are held in the spring and fall of each academic year. Students who take longer than the advertised program length are responsible for completing any new or additional courses due to a program design change. Students who complete their program after the scheduled completion date are required to fill out an Application to Graduate form and submit it with payment to the Registrar's Office. Students who are discontinued or have withdrawn and then return to the college will be placed in the current program design and must meet all requirements to graduate.
Students considering withdrawing from a program should meet with their Student Success Advisor prior to withdrawing. In order to formally withdraw from a program, the student must complete the
Program Withdrawal Form and submit it to the Registrars Office. Deadlines for withdrawing from a program are posted on the website under
Academic assistance is available to students through a variety of avenues. The Program Coordinator and faculty can advise students on specific program and course information such as adding and dropping courses, special timetabling, etc. Access the Conestoga website for assistance provided through
Accessibility Services. Access the
Learning Commons website for detailed information on the academic services they provide including learning skills, peer services and math and writing assistance.
Program start and end dates, holidays and deadlines for course add/drop, withdrawal and refunds are located in your student portal.
Conestoga has more than 400 awards, bursaries, scholarships and academic grants available to Conestoga students. These funds are made available to our students through the partnerships we have established with local business and industry leaders. To be considered for an award, complete the General Application available through your student portal. Notifications and instructions to complete the application are sent to all full-time students' email accounts in the fall semester (deadline: first Friday in October), and winter semester (deadline: first Friday in February). Visit the
Financial Aid and Student Awards Office website for more details.
Program Advisory Committee
Each program at Conestoga has a Program Advisory Committee (PAC), which is made up of industry and academic representatives, as well as current students. They meet several times a year to discuss the direction in which that industry is heading and any improvements that can be made to keep the program current. This helps to ensure that students are learning material that is relevant to their industry.
At the beginning of each year, the coordinator of the program will ask for student volunteers. The student representatives are expected to attend the meetings. Students must prepare and submit a report based on guidelines provided by the Program Chair/Coordinator which will be presented at the meeting. Students are expected to be professional, dress in casual business attire and engage in discussions.
Communication - School Standard
Conestoga College and eConestoga student email accounts are used to communicate with students. Students are expected to regularly check their student email accounts. Please note that neither faculty nor administration faculty will not respond to emails from non-Conestoga email addresses.
Course Changes (Adding/Dropping)
Students can find their program design on the Student Portal by following the steps below:
- Log in to Student Portal.
- Click on 'My Courses' tab.
- Scroll over the icons to the right of individual course listings.
It is strongly recommended that students consult with the Program Coordinator prior to dropping a course.
- If a course withdrawal is processed prior to the deadline date, a dropped course will be recorded as a "W" (withdrawal) on the transcript.
- If a course withdrawal is processed after the deadline, an "F" (fail) will be recorded on the transcript.
Continuing Education and OntarioLearn courses are not included in student full-time fees. Students wishing to take these part-time courses are required to pay the full fee for the individual course(s). Students may add these or other courses under the 'Browse Continuing Education' tab in their Student Portal.
Applying to the Co-op Stream (starting with the 1801 cohort and subsequent cohorts unless otherwise noted):
- All applicants apply to the non co-op program. Students will be informed of the application deadline and process to apply for the Co-op Stream. Labour market conditions determine the number of co-op seats in optional co-op programs. Not every student who meets academic eligibility requirements will be not be admitted to the co-op stream.
- To be considered for the co-op stream, students are required to achieve a minimum overall 80% session weighted average in Level 1 with no failed or dropped courses.
To participate in a co-op work term, students must (starting with the 1801 cohort and subsequent cohorts unless otherwise noted):
- Successfully complete the Co-op and Career Preparation modules (CEPR8200 or CEPR1020 or CDEV1020). Students who fail Co-op and Career Preparation will not be permitted to search for co-op employment nor will they be able to participate in a co-op work term. Students who fail Co-op and Career Preparation more than twice will not be permitted to continue in their co-op program.
- Be enrolled full-time (full-time = 70% of the hours, or 66 2/3 % of the courses in the current session/level of the Program Design.) Exceptions will apply to those students who have been granted special timetabling based on formal identification of barriers or challenges for which accommodation is required. Academic eligibility requirements must still be met prior to being granted access to seek a co-op work term.
- Must have successfully completed all but two core courses, according to the program design, by the eligibility term prior to any given work term (regardless of the level the student was placed in advanced standing).
- Students (even those on special timetables) will not be permitted to complete a co-op work term until conditions above are met and all but two core course deficiencies, according to the program design, are cleared.
- Co-op work terms may need to be re-sequenced to allow academic deficiencies to be cleared or in the event a student changes cohorts (i.e. graduation is delayed by one year or more). Students may not repeat a passed work term.
- Should a student's academic performance decline considerably (including cumulative missed courses) during the term just prior to any work term, the college reserves the right to withdraw the student from the upcoming work term.
- Meet program specific co-op work term eligibility requirements.
- Academic eligibility for a co-op work term is based on the term that occurs two terms prior to any work term. If this term is also a co-op work term, then work term eligibility will be based on the student's achievement during the preceding academic term.
- Students may defer one work term regardless of the reason(s) (e.g. failed or missed work term).
- Students who do not successfully complete their deferred work term will be removed from the co-op stream.
- Since only one work term may be failed/deferred regardless of the reason(s), should a subsequent work term be missed/failed/unsecured (not successfully completed for any reason) the student will be immediately removed from the co-op stream.
- Students who are discontinued are not eligible for co-op work terms.
For additional information please refer to the Co-operative Education Regulations & Guidelines: Student Regulations, Procedures and Support found by:
- Login to MyCareer
- Select Co-op
- Select Co-op Resources
- Select Co-op Policies
- Select Co-operative Education Regulations, Procedures and Supports for Students
- Co-op programs add value to your education. Earn money while you apply what you've learned in a real workplace environment. Visit Co-operative Education for more details.
- The College cannot guarantee co-op employment. All co-op students are required to conduct an independent co-op job search in addition to the supports and services provided by the Department of Co-op Education.
- Students are responsible for their own transportation and associated costs in order to complete work term requirements. Work locations may not always be readily accessible by public transportation.
Conestoga recognizes you may have formal post-secondary education that may allow you to enter a program at an advanced level or provide for individual course exemptions.To ensure your credits are eligible for transfer, please contact our Credit Transfer Office. The Credit Transfer Policy and Procedure are available on the college website. For more information, visit the Credit Transfer & PLAR page.
Evaluations - deadlines, tests and examinations
In order to successfully complete this course the student is required to meet the following evaluation criteria (example only):
|||100% (% is subject to change)|
To encourage attendance, there may be in-class assignments some weeks.
Assignment Program Standard
Assignment requirements, weighting, deadlines etc. will be specified by the faculty in each course.
Missed Work or Classes
Refer to Attendance at Evaluations section in this handbook.
Test and Examination Program Standard
Test requirements, weighting, dates, etc. will be specified by the faculty in each course.
Prior Learning Assessment and Recognition (PLAR)
Conestoga recognizes prior learning of skills, knowledge or competencies that have been acquired through employment, formal and informal education, non-formal learning or other life experiences. Prior learning must be measureable at the required academic level and meet Conestoga standards of achievement for current courses.
Students must be at least 19 years of age or have an Ontario Secondary School Diploma (or equivalent) to be eligible to apply for PLAR.
Prior to transferring to another program, it is recommended that the student meet with the Student Success Advisor. Students who decide to change programs may do so by completing and submitting a program application form to the registrar's office. If considering transferring to a program outside the school in which they are currently enrolled, students may want to discuss options with a career advisor. When a student moves from one Conestoga program to another and where course numbers/codes are identical or equivalent, automatic credit is given if passing grades are met. Program transfers are not guaranteed, and are subject to program capacity, suitability and other criteria. Additional information for career or academic advising is available from faculty, program coordinators or career advisors in the Welcome Centre or on the Conestoga website.
Student feedback is an essential component of our continuous improvement process. Our opportunities for student feedback include:
Key Performance Indicators
All college programs in the province are evaluated using Key Performance Indicators (KPIs) through the Ministry of Colleges and Universities (MCU). This Student Experience Survey is conducted each academic year in select classes. Strategic goals to improve the programs are developed from these results. This data and other data specific to the campus and the program/school are collected so that Conestoga College can continually improve quality.
Student Appraisal of Teaching (SAT)
The Student Appraisal of Teaching (SAT) allows direct feedback from students on teaching for a particular course. Completion of the SAT forms give teachers and academic managers valuable information to use for the improvement of teaching at Conestoga.
The SAT process has two components: the Early Course Check-in and Full-SAT. The Early Course Check-in is 5 questions, occurs during week 5 of classes and provides early feedback to faculty about the student experience within their classroom. The Full-SAT is 44 questions and occurs late in the semester; a summary of the results goes to the faculty menber and their academic manager. Typically about one-quarter of the faculty is appraised per term. All full-time faculty have a SAT review at least once every two years. Part-time faculty may be reviewed more frequently. Continuing Education students may have an opportunity to complete a SAT form during their Continuing Education course.
After Hours Access
Conestoga hours of operation are 7:00 a.m. to 11:00 p.m. Conestoga recognizes that in some programs of study, students may require after-hours access to classrooms and labs. After-hours access is maintained in accordance with the academic needs of individual programs. The after-hours access is a privilege, not a right.
If after-hours access is required, faculty must contact security in advance, with the student(s) name, ID number, and program information, along with signed paperwork approving access. The student must follow these guidelines:
- Be in the designated room with another approved person
- Inform security immediately of any out-of-the normal situations
- Have student identification card available
- Notify security upon departure
- Not move furniture
Refer to the Student Guide for more information.
Academic Delivery Plan and College Hours
Academic Delivery Plan Fall 2021
In response to the COVID-19 pandemic, Conestoga has developed an academic delivery plan for the Fall 2021 semester. The safety and well-being of our college community remains our highest priority. Our academic plans and decisions continue to be based on the advice of public health authorities.
Some programs will be delivered in a hybrid format (a combination of remote and on-campus learning). Other programs will be delivered in a remote format only. Courses in which remote delivery is not possible will be offered entirely through on-campus delivery.
For the Fall, only students who have classes scheduled on campus will be pre-approved to be on-campus. Students need to complete a mandatory pre-approval process before they can attend their class. Students who do not have scheduled activity are not permitted on-campus. Support services for students will continue to be available remotely.
For the Fall 2021 semester, to support physical distancing on campus, full-time courses at Conestoga are delivered Monday to Sunday, 8 a.m. to 10 p.m.
Refer to your Student Guide for Conestoga's Safety and Security services and procedures.
Note: Students may be required to sign a Conestoga College ITAL (CCITAL) Acknowledgment of Safety Training and Responsibilities Form depending on program requirements.
Emergency Telephone Messages
It may be necessary for family members to contact a student in an emergency situation. Family members need to know the student number, program name, school, and campus the student is registered in, to aid Security in locating the student. This information will be required when the family member calls. Please have family members contact Security directly at 519-748-5220, ext. 3357 - only if it is an emergency.
College-wide Policies and Procedures
Student Protection Acknowledgement
A Student Protection Acknowledgement confirmation pop-up will appear when a student logs into the Student Portal on a yearly basis. This will direct students to policies and procedures relevant to their academic responsibilities. All Conestoga College wide academic policies and procedures are listed on the college website under "About Conestoga", "Policies and Procedures".Students are advised to review and comply with all policies and procedures, including the following:
- Academic Dispute and Resolution Policy & Procedure
- Academic Offences Policy & Procedure
- Clearance of Academic Deficiency Policy & Procedure
- Convocation Procedure
- Co-operative Education Policy
- Discontinuance Procedure
- Evaluation of Student Learning Policy & Procedure
- Grading Procedure
- Program and Course Withdrawal and Refund Procedure/International Student Withdrawal and Refund Procedure
- Readmission Procedure
- Religious Holiday Policy & Procedure
- Student Rights and Responsibilities Policy & Procedure
- Student Feedback Policy
- Student Fees Policy & Student Fee Invoicing and Payment Procedure
Students must follow all of the policies and procedures for Conestoga College and it is expected that faculty will accept, fulfil and enforce these standards.
The Student Engagement Department is here to help you transition to the Conestoga College experience, connect with your community, and build your skills.
Start your college experience by completing Conestoga 101 (CON0101) on eConestoga, a mandatory course for all new full-time students that will take you approximately one hour to complete. CON0101 provides an overview of the supports, services, and opportunities available to you throughout your time at Conestoga. Make sure you complete it early on in the term, as it contains valuable information that will help you transition to Conestoga.
General Education / Interdisciplinary Electives
School of Interdisciplinary Studies
The purpose of diploma General Education electives and Interdisciplinary electives is to provide graduates with the skills and knowledge to succeed not just in their chosen career fields, but in all life paths. Working collaboratively with your program, diploma General Education and degree Interdisciplinary elective courses cultivate critical and creative thinking skills, civic engagement and knowledge of the broader world of arts, culture and science that helps make you more reflective, creative, and effective in your own life.
All Ontario College Diploma, Ontario College Advanced Diploma, and Degree programs at Conestoga require students to complete general education electives / interdisciplinary breadth.
More information on these courses can be found at www.conestogac.on.ca/electives.
Program courses may use web-based services with data centres outside of Canada. Students may be expected to complete assessments where information is transmitted outside of Canada. Students who do not wish to submit their information to other countries have the right to opt-out. It is the responsibility of the student to notify the instructor if they, in the first week of term or at the time assignment details are provided, wish to submit an alternate assignment.
Course examinations may be administered through a remote proctoring service to assure academic integrity. Ensure that you meet the system requirements that will allow the recording of your computer screen, webcam, and microphone.
Attendance at Evaluations
Working Together to Plan Your Success
Your success matters! As an emerging professional, it is important that you demonstrate the same professional attitude to your program that you will be required to demonstrate to your future workplace. Regular, punctual attendance, and active participation in scheduled classes, field and clinical placements, labs and any on-campus and off-campus activities scheduled by your program will help you to understand and master the learning complexities of your program.
If extenuating, unplanned circumstances require you to miss a class, please note that it is your responsibility to follow up with individual faculty members and to acquire any missed information.
Attendance for Evaluations
Evaluations are critical components of each course and your overall success in your program. An evaluation is defined as a test, exam, presentation or any other formal assessment that contributes to your course mark that requires your presence, in class or on-line. Please note that in many programs across the College, every field placement, clinical day, and lab/shop day is considered crucial to your overall learning and success and the expectation is that you attend. If you are in a program that includes field or clinical placements, labs/shops, or any other on or off campus activities, it is essential that you discuss attendance requirements with your program faculty in order to understand expectations and consequences.
Your attendance for all evaluations is a requirement. If there is a concerning pattern of absence from evaluations across your program, you may be asked to meet with the Program Coordinator and/or Student Advisor to discuss strategies for success.
While circumstances such as religious holidays and academic accommodations may necessitate rescheduling of evaluations and will be accommodated, please note that there will be no special arrangements made for rescheduling evaluations due to personal conflicts such as work or vacation plans.
In order to facilitate a smooth implementation for all scheduled evaluations, both you and your program faculty have responsibilities which are listed below:
- To communicate all course obligations to you at the beginning of each semester through the Instructional Plan, including evaluation and presentation dates.
- To communicate, in writing, any unplanned extenuating circumstances involving the college, the program or the faculty members that may require changes to the course schedule.
- To provide alternative evaluation arrangements for missed evaluations/work due to recognized religious holidays as defined by the College Employer Council and documented accommodations through the Accessibility Office.
- To accept alternative evaluation requests in good faith and examine based on the unique circumstances and students' individual needs.
- To facilitate alternative evaluation arrangements as described below.
- To be informed about all course obligations and due dates.
- To inform your faculty member in writing of the need to reschedule evaluations due to a religious holiday as defined by the College Employer Council.
- If you have to be absent from any scheduled evaluation, report your absence on the Student Portal using the procedure below. You must do this prior to the start of the evaluation or risk receiving a mark of zero.
How to Report Absences on the Student Portal
- Log into the Student Portal and click on the 'Absence tab'.
- Indicate whether or not there is an assessment scheduled on that day by clicking 'Yes or No', as well as the reason for the absence (illness or other).
- Click 'Continue' to report the absence.
- Click 'I agree' to confirm the absence.
- You will receive a confirmation email that your absence has been recorded.
Important! Please note the following:
- The earliest you can record an absence for a particular day, is after 8:00 p.m. the day before. You must report each day you are absent.
- The Absence Recording System will show you as being absent for the day, starting from the time that you recorded the absence. For example, if you record your absence on a specific day at 11:00 a.m., the system will show you as being absent for all classes starting after 11:00 a.m. that day.
- If you are going to be present for any other classes on the day for which you recorded an absence, please let the faculty member know by attending or following up by eConestoga or college email.
- When you return to campus, make eConestoga or email contact immediately with the faculty member associated with the evaluation you missed in order to arrange appropriate follow up.
Valid Absence from Scheduled Evaluations Less than 20%
Conestoga recognizes that unexpected circumstances such as brief illness do arise during the semester and that a visit to a health practitioner may not be necessary. A valid absence from a scheduled evaluation worth less than 20% of the final grade which is not documented through the Accessibility Office or previously arranged due to religious holidays, will be accommodated once per course during the semester, subject to proper communication as described in the Student Responsibilities section above. If the evaluation cannot be rescheduled, (for example an experiential activity, lab or participation in a group presentation) reallocation of marks to another evaluation item will be determined by faculty and communicated to student via email to their eConestoga or college email address, or documented on an interview record and signed off by both faculty member and student.
Absence from additional scheduled evaluations worth less than 20% in the same course may require documentation for verification.
Valid Absence from Scheduled Evaluations 20% or More
Absence from scheduled evaluations worth 20% or more of the final grade that are not documented through the Accessibility Office or arranged due to religious holidays, will require appropriate documentation for verification, subject to proper communication as described in the Student Responsibilities section above.
Alternative Evaluation Arrangements
- Faculty members will determine alternative evaluation arrangements as appropriate.
- Students will complete any necessary forms.
- Students are required to complete the alternative evaluation as scheduled. If an evaluation cannot be rescheduled (for example an experiential activity or participation in a group presentation) reallocation of marks will be determined by faculty and communicated to student via eConestoga or college email or documented on an interview record and signed off by both faculty member and student.
Program Handbook Revision Log
Date: July 2021
Type of Revision: Annual updates
Date: August 2020
Type of Revision: Annual updates
Date: October 29, 2019
Type of Revision: Annual updates
Conestoga's Accessible Learning services provide support for students with permanent and temporary disabilities who feel they are encountering barriers to learning. They work with students to understand the impact of a disability in the college environment and will help develop a success plan that considers student goals and required academic accommodations. Accessible Learning will also communicate necessary accommodations to professors on behalf of the student.
To consult with an Accessibility Advisor about accommodations please make an appointment by emailing firstname.lastname@example.org or calling 519-748-5220 ext. 3232.
Exceptions for non-accessibility focused issues need to be consulted on with your professor. Final approval for exceptions unrelated to academic accommodations rests with the program chair.