Course

Advanced Object Oriented Programming for Business Applications

Faculty
Commerce & Business Administration
Department
Computing Studies & Information Systems
Course code
CSIS 4050
Credits
3.00
Semester length
15 Weeks
Max class size
35
Method(s) of instruction
Lecture
Seminar
Typically offered
To be determined

Overview

Course description
This course will provide the student with practical knowledge of developing and implementing business related applications using the latest Microsoft coding innovations. Topics will include DDL, DML, host-based processing, designing complex queries, triggers, and extensive coverage of ADO.NET. Along with the coverage of database access using Relational and Non-relational database(s), these topics will be covered: XML and XML integration with ADO.NET. The course will use Visual Studio .NET to build Advanced Windows Applications.

Note: For CSIS programs, students can receive credit for one of: CISY 3540/CSIS 3540 or CSIS 4050.
Course content
1. Design Pattern
  • MVC, MVVM, and/or a more current pattern used in the industry
2. Object-oriented programming using Visual C#
  • Using Visual Studio
  • Basic syntax and control flow
  • Classes, Polymorphism and Inheritance
  • Arrays and Lists
  • Tuples
  • lambda
  • LINQ
  • Building GUI with
    • Windows Form, Windows Platform Foundation, or any currently used UI approached
  • Event Handling
  • Database Programming and ADO.NET
  • Performing CRUD to different data sources such as
    • RDBMS
    • NoSQL
  • Entity Framework
3. ASP.net
Learning activities
  • Lecture
  • Seminar
  • Hands-on exercises in the lab
Means of assessment

Evaluation will be carried out in accordance with the Douglas College Evaluation Policy.

Means of Assessment

Labs/Assignments                  10% - 15%

Project                                  15% - 25%

Midterm Examination*             30% - 35%

Final Examination*                  30% - 40%

 

Total                                        100%

 

*In order to pass the course, students must, in addition to receiving an overall course grade of 50%, also achieve a grade of at least 50% on the combined weighted examination components (including quizzes, tests, exams).

Students may conduct research as part of their coursework in this class. Instructors for the course are responsible for ensuring that student research projects comply with College policies on ethical conduct for research involving humans, which can require obtaining Informed Consent from participants and getting the approval of the Douglas College Research Ethics Board prior to conducting the research.

Learning outcomes

The successful student will be able to:

  1. Construct complex queries, set operators, and user-defined stored procedures
  2. Demonstrate the use of a Visual Studio .NET and a design pattern to build applications
  3. Demonstrate the use of ADO.NET within the application
  4. Describe ADO data providers, datasets, data adapters, connections
  5. Explain the basic concepts of reading/writing XML/XAML
  6. Explain how XML is incorporated in the .NET environment
  7. Demonstrate the use of Relational database and NoSQL incorporated with Visual Studio .NET
Textbook materials

Instructor will prepare course reference material

or

other textbook(s) as approved by the department

Requisites

Prerequisites

Courses listed here must be completed prior to this course:

Corequisites

No corequisite courses.

Equivalencies

Courses listed here are equivalent to this course and cannot be taken for further credit:

Course Guidelines

Course Guidelines for previous years are viewable by selecting the version desired. If you took this course and do not see a listing for the starting semester / year of the course, consider the previous version as the applicable version.

(Current)

Course Transfers

These are for current course guidelines only. For a full list of archived courses please see https://www.bctransferguide.ca

Institution Transfer details for CSIS 4050
Alexander College (ALEX) ALEX CPSC 2XX (3)
Athabasca University (AU) AU COMP 3XX (3)
College of New Caledonia (CNC) CNC CSC 2XX (3)
Kwantlen Polytechnic University (KPU) No credit
Thompson Rivers University (TRU) TRU COMP 3XXX (3)
University Canada West (UCW) UCW CPSC 3XX (3)
University of Northern BC (UNBC) UNBC CPSC 3XX (3)
University of the Fraser Valley (UFV) UFV COMP 3XX (3)

Course Offerings

Winter 2025