BSYS 2061 Business Data Management with MS Access 2019 for Windows
| School | School of Business + Media |
|---|---|
| Program | Part Time Studies |
| Course Credits | 3 |
| Minimum Passing Grade | 50% |
| Start Date | January 07, 2021 |
| End Date | March 25, 2021 |
| Total Hours | 36 |
| Total Weeks | 12 |
| Hours/Weeks | 3 |
| Delivery Type | Lecture/Lab |
| Pre-requisites | BSYS 1000 or BSYS 1001 or BSYS 1005 |
| CRN | 77742 |
Acknowledgement of Territories
The British Columbia Institute of Technology acknowledges that our campuses are located on the unceded traditional territories of the Coast Salish Nations of Sḵwx̱wú7mesh (Squamish), səl̓ilwətaɁɬ (Tsleil-Waututh), and xwməθkwəy̓əm (Musqueam).
Instructor Details
| Name | Masoud Jalili |
|---|---|
| Instructor to provide | |
| Location | SE6-326 |
| Office Hours | Instructor to provide |
Course Description
In an information-based society, understanding data management is vital. The backbone of the Internet, Cloud Computing, and Business Intelligence are relational database management systems. The use and manipulation of data is the key to utilize business information to create a competitive advantage. This course introduces relational database management systems, data modeling, and artificial intelligence. Students will use Microsoft Access, a relational database management system, to create data models and build data applications. An introduction to Artificial Intelligence, Machine Learning, and Deep Learning tools and models will also be included in the course.
Course Learning Outcomes/Competencies
Upon successful completion of this course, the student will be able to:
- Explain when and why a database should be created.
- Understand and Use database terminology.
- Construct a database using a relational database management system.
- Design and modify tables.
- Explain and illustrate the data modeling process using normalization.
- Build table relationships to meet business requirements.
- Create single table and multiple-table based forms.
- Search, modify, and analyze data using queries.
- Create and customize reports to summarize and gain insights into data.
- Export/Import data in various formats such as csv and xlsx.
- Describe Machine Learning (ML) concepts and algorithms.
- Conduct ML experiments using MS Azure cloud platform.
- Describe the benefits of Artificial Intelligence (AI) and Machine Learning (ML).
- Compare various prediction models such as regression and classification.
- Carry out ML experiments using dataset preparation, training, and testing modules.
Learning Resources
Required:
Shellman/Vodnik - New Perspectives Microsoft Office 365 & Access 2019 Comprehensive
ISBN 9780357025758,Price - $149.95 list
Shellman/Vodnik - eBook: New Perspectives Microsoft® Office 365 & Access 2019 Comprehensive
ISBN 0357392728,Price - $74.95 list
BCIT Bookstore link: https://www.campusebookstore.com/integration/AccessCodes/default.aspx?bookseller_id=238&Course=BSYS+2061&frame=YES&t=permalink
Course Goals
- Understand and Use database terminology
- Design and modify tables
- Build table relationships to meet business requirements
- Create single table and multiple tables based forms
- Search, modify, and analyze the database using queries and charts
- Create and customize reports to summarize and gain insights into your data
- Export/Import data in various formats such as csv and xlsx
- Decribe the Machine Learning(ML) concepts and algorithms
Evaluation Criteria
Assignments and Attendances | 10 | % |
Mid Term Exam | 45 | % |
Final Exam | 45 | % |
TOTAL | 100 | % |
Comments:
1. Students must achieve a minimum average 50% on their exams before any account of assignment marks is made. If you do not achieve a minimum average of 50% on your combined exams, you will have failed this course – in this event, your assignments mark will not be considered as a part of your final mark.
2. Compliance with the “Course Notes (Policies and Procedures)” sections (see page 3).
Course Schedule and Assignments
Weekly assignments due before the starting of the following lab | |||||
Week- | Material Covered | Reference | |||
1-Jan 7 | Creating a Database | Module 1 |
| ||
2-Jan 14 | Building a Database and Defining Table Relationships | Module 2 | Tutorial Hands-on (AC2-9 to AC2-51) | ||
3-Jan 21 | Normalization Rules | Appendix | Appendix (AC A1) at the end of the textbook | ||
4-Jan 28 | Maintaining and Querying a Database | Module 3 | Tutorial Hands-on (AC3-5 to AC3-55) Case Problem 1(AC3-57) | ||
5-Feb 4 | Creating Form and Reports | Module 4 | Tutorial Hands-on (AC4-4 to AC4-42) Case Problem 1(AC4-45 to AC4-46) | ||
6-Feb 11 | Mid Term | ||||
7-Feb 18 | Creating Advanced Queries and Enhancing Table Design | Module 5 | Tutorial Hands-on (AC5-4 to AC5-57) Case Problem 1(AC5-59 to AC5-61) | ||
8-Feb 25 | Using Form Tools and Creating Custom Forms | Module 6 | Tutorial Hands-on (AC6-5 to AC6-68) Case Problem 1(AC6-72 to AC6-73) | ||
9-Mar 4 | Creating Custom Reports | Module 7 | Tutorial Hands-on (AC7-5 to AC7-53) Case Problem 1(AC7-56 to AC7-57) | ||
10-Mar11 | Using Action Queries and Advanced Table Relationships | Module 9 | Tutorial Hands-on (AC9-6 to AC9-41) Case Problem 1(AC9-43) | ||
11-Mar 18 | Intro to Artificial Intelligence | Handout | |||
12-Mar 25 | Final Exam | ||||
BCIT Policy
Any student who needs special assistance in the event of a medical emergency or building evacuation (either because of a disability or for any other reason) should promptly inform their course instructor(s) and Accessibility Services of their personal circumstances.
Human Rights, Harassment and Discrimination:
The BCIT community is made up of individuals from every ability, background, experience and identity, each contributing uniquely to the richness and diversity of the BCIT community as a whole. In recognition of this, and the intrinsic value of our diversity, BCIT seeks to foster a climate of collaboration, understanding and mutual respect between all members of the community and ensure an inclusive accessible working and learning environment where everyone can succeed.
Respect, Diversity, and Inclusion is a supportive resource for both students and employees of BCIT, to foster a respectful learning and working environment. Any student who feels that they are experiencing discrimination or harassment (personal or human rights-related) can confidentially access this resource for advice and support. Please see Policy 7507 – Harassment and Discrimination and accompanying procedure.
Students should make themselves aware of additional Education, Administration, Safety and other BCIT policies listed at https://www.bcit.ca/about/administration/policies.shtml
Guidelines for School of Business + Media
Attempts:
Students must successfully complete a course within a maximum of three (3) attempts at the course. Students with two attempts in a single course will be allowed to repeat the course only upon special written permission from the Associate Dean. Students who have not successfully completed a course within three attempts may not be eligible to graduate from their respective program.
Attendance:
Regular attendance in lectures and labs is seen as integral to student success, therefore, attendance in class is monitored. Unexcused absences in excess of 10% of the time prescribed for this course may result in the assignment of a failing grade. Attendance may be taken at any time during class. A student not present for attendance will be marked absent. A student who leaves class for a period of time deemed excessive by the instructor may be considered absent regardless of whether they are present when attendance is taken.
In case of illness or other unavoidable absence, students must communicate with the instructor, or the appropriate Program Head, as soon as possible (preferably in advance) indicating the reason for the absence. Students who are seeking accommodation for a medical absence must have a BCIT-approved medical certificate ). For other absences, students must be prepared to provide appropriate supporting documentation.
A student who has unexcused absences in excess of 10% of the time prescribed for the course by the Withdrawal Deadline is considered to have ‘Vanished’ and will be assigned a grade of ‘V’. In these cases, no further work will be graded.
These requirements are set out in accordance with BCIT Policy 5101 Student Regulations. More information regarding withdrawals from PTS courses is available at https://www.bcit.ca/pts/pts_withdrawals.shtml.
Approved
I verify that the content of this course outline is current.
Masoud Jalili, Instructor
December 11, 2020
I verify that this course outline has been reviewed.
Juan Azmitia, Program Head
December 11, 2020
I verify that this course outline has been reviewed.
Ron Wlock, Program Head
December 11, 2020
I verify that this course outline has been reviewed and complies with BCIT policy.
Phil Ramer, Associate Dean
December 11, 2020
Note: Should changes be required to the content of this course outline, students will be given reasonable notice.