Douglas College wordmark
Facebook logo Twitter logo Instagram logo Snapchat logo YouTube logo Wordpress logo

Registration for the Fall 2019 semester begins June 25.  Watch your email for more details.

back to search

Advanced Object Oriented Programming for Business Applications

Course Code: CSIS 4050
Faculty: Commerce & Business Administration
Credits: 3.0
Semester: 15 Weeks
Learning Format: Lecture, Lab, Seminar
Typically Offered: TBD. Contact Department Chair for more info.
course overview

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

Methods of Instruction

  • Lecture
  • Seminar
  • Tutorial
  • Hands-on exercises in the lab

Means of Assessment

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

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

course prerequisites

Courses listed here must be completed prior to this course:

  • A grade of C or better in CSIS 2175 and CSIS 2300

Corequisites

Courses listed here must be completed either prior to or simultaneously with this course:

  • No corequisite courses

Equivalencies

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

  • No equivalency courses

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

course schedule and availability
course transferability

Below shows how this course and its credits transfer within the BC transfer system. 

A course is considered university-transferable (UT) if it transfers to at least one of the five research universities in British Columbia: University of British Columbia; University of British Columbia-Okanagan; Simon Fraser University; University of Victoria; and the University of Northern British Columbia.

For more information on transfer visit the BC Transfer Guide and BCCAT websites.

assessments

If your course prerequisites indicate that you need an assessment, please see our Assessment page for more information.