Click Here To Return To The Catalogue Home Page
Business Information Technology
Other Information

The following program majors are applicable for students who started the Business Information Technology program prior to September 2014. 

 The Business Information Technology (BIT) program is delivered over two years.

First year
In the first year, you complete 10 compulsory full courses that will introduce you to the basics of information technology and provide the foundation for your study in the second year.

Second year
In the second year, you complete an additional 10 courses. Four are required courses for all students. They are:

  • COMP-2025 OO Analysis & Design
  • ADEV-1002 Programming (.NET 1)
  • BUSA-1042 Intro to Business & Entrepreneurship
  • COMP-2023 Management Issues for Information Technology

The remaining courses in the second year are necessary to complete your chosen major. You can choose Application Development, Database Management, Network Management or Web Development.


Application Development builds proficiency in application development for business systems. Required courses for this major include:

  • WEBD-2001 XML Programming
  • WEBD-2000 Electronic Commerce
  • ADEV-2000 PowerBuilder
  • ADEV-2004 Mobile Computing
  • ADEV-2002 Programming (.NET 2)
  • ADEV-2001 n-Tier Processing
  • ADEV-2003 Application Integration

Database Management (Not offered at this time) will provide you with a highly developed skill set focused on daily operation of relational databases, system administration, backup and recovery, advanced SQL, and data warehousing. Required courses for this major include:

  • DBMS-3000 Advanced SQL
  • DBMS-2001 DBMS 1
  • DBMS-2000 DBMS Software
  • DBMS-2003 Data Warehousing
  • DBMS-3001 DBMS 2
  • DBMS-2002 DBMS Project

Network Management will give you the skills needed for network administration, security and disaster recovery, platform integration, and Windows and Unix servers. Required courses for this major include:

  • NTWK-2000 Applied Network Computing
  • NTWK-2001 Linux/Unix Administration
  • NTWK-2002 Advanced Network Administration
  • NTWK-3000 Switches and Wireless
  • NTWK-2004 Network Security & Business Continuity
  • NTWK-2003 Advanced Windows Server

Web Development will provide you with the specialized skills you need for developing content for the Web, including Web design, server-side technologies, introductory Internet security, platform integration, and mobile technologies. Required courses for this major include:

  • WEBD-2002 Web Design
  • WEBD-2001 XML Programming
  • WEBD-2000 Electronic Commerce
  • WEBD-2005 Server-Side Computing
  • WEBD-2003 Web Security
  • ADEV-2004  Mobile Computing


You also must complete either WRKE-2024 Co-op Work Experience in Term 4 or PROJ-2006 Industry Project in Term 5.

COURSE DESCRIPTIONS

ACCT-1971 Financial Accounting 1  

This first course in accounting covers the double-entry bookkeeping procedures, adjustments, and production of financial statements pertaining to sole proprietorships. Coverage is also given to special journals, subsidiary Ledgers, and control accounts. This results in a complete presentation of the accounting cycle for a service or merchandise business. Later in the course more in depth study of inventory costing methods, control procedures for cash including petty cash, and bank reconciliations is presented.
   
ADEV-1000 Programming (Java 1)
 
This course is a basic introduction to programming using the Java programming language. Students will develop, code, test, and debug programs for simple applications using proper programming principles and documentation. Topics include data types, variable declarations, control structures, methods, classes, inheritance, polymorphism, encapsulation, arrays, and other data structures.
   
ADEV-1001 Programming (Java 2)
 
This course will cover some of the more advanced areas of JAVA programming including Swing, Event Handling, Multi-Threading, Exception Handling, JDBC, File I/O, and Servlets. Students will use a Development tool to create Applet and Frame applications.
 
Prerequisites:
ADEV-1000 
   
ADEV-1002 Programming (.NET 1)

As an introduction, students learn the basics of developing Windows business applications using the Visual Basic .NET design process. Through progressive hands-on application development, students learn the features of the Visual Studio Interactive Development Environment (IDE), the .NET Framework along with Windows application standards and object oriented programming principles. Each assignment will further enhance the student’s knowledge and expertise using the Visual Studio IDE and the .NET Framework. The standard controls and methods along with object oriented code written by the student will be used to develop a Windows application utilizing sequential file I/O and a Microsoft Access database. Data Grid View controls and Crystal Reports will also be introduced.  As well, students will explore the Setup and Deploy options built into the .NET Framework.  The course will include a heavy unit testing component, whereby unit testing using Visual Studio Team Test will be used throughout the course.
 
Prerequisites:
ADEV-1000 
   
ADEV-2000 Powerbuilder
 
This course is designed to offer students an introduction to PowerBuilder as a client/server GUI development tool. Topics covered by this course include: defining an application, building windows, coding in PowerScript, developing menus and toolbars, debugging, inheritance, database administration, datawindows, functions, user objects, datastores, stored procedures and user events. Emphasis will be placed on object-oriented programming techniques. A database-backed application will be developed through a series of assignments.
 
Prerequisites:
ADEV-1002 AND ADEV-1001 
   
ADEV-2001 n-Tier Processing

This course is designed to offer students an introduction to a distributed computing environment using an enterprise application server. Topics covered include architecture and components of a distributed computing environment, including the client application and various server components. PowerBuilder will be used as the language of instruction and EAServer (Enterprise Application Server) will be used as the application server.  Each student will build his or her own distributed environment.
 
Prerequisites:
ADEV-2000 
   
ADEV-2002 Programming (.NET 2)

As a continuation of Programming (.NET 1), students learn to develop more advanced Windows business applications. Through progressive hands-on application development using object oriented programming principles, students learn to develop multi-tier business applications using a relational database. Students will incorporate Language Integrated Query (LINQ) to all aspects of the application.  Each assignment developed will further enhance knowledge and expertise using C#, the .NET Framework, and SQL Server as well as external components such as XML files and serial devices running on a separate thread.  Students will also develop a Web application as well as a Web Service to be utilized by both the Windows and Web applications created.
 
Prerequisites:
ADEV-1002 AND ADEV-1001 
   
ADEV-2003 Application Integration
 
This course is designed to expose students to integrating diverse applications as well as developing a platform for building messaging-based solutions using XML through an Enterprise Service Bus. Effectively exchanging messages across different software on different machines is an absolute requirement for integration. The middleware software used in this course allows connecting of diverse software, then graphically creates and modifies process logic that uses that software. This course prepares developers for the building blocks of an EAI solution using Schemas, Ports, Pipelines (Adapters or Connectors) and Orchestrations or Business Process Models.
 
Prerequisites:
ADEV-2000 AND ADEV-1002 

   
ADEV-2004 Mobile Computing
 
This course introduces mobile software development. It begins with an exploration of mobile computing devices such as smartphones and tablets. Students progress into application development for the Android platform. Programming topics include user-interface creation, event-driven programming, data persistence, web connectivity, and location-based services.
 
Prerequisites:
ADEV-1001 AND WEBD-1000 
   
BUSA-1042 Intro to Business & Entrepreneurship
 
This course is designed to introduce the learner to the Canadian business environment, create understanding of the trends facing managers and entrepreneurs, and identify critical business decisions needed to ensure sustainability in a competitive marketplace. This course will provide a practical application of the creation, evaluation and presentation of a business concept through the preparation of a business plan. Applying business planning concepts to the information technology sector will be examined throughout the course.

   
COMM-1107 Communication for Information Technology  
 
Students will learn the techniques involved in writing and speaking effectively for business. They will develop their writing skills using the three step writing process to produce business letter, memos and reports. Oral communication skills will be improved through oral presentations, teamwork and by conducting and participating in meetings. Students will learn how to research and properly document their research papers using the APA style. The process of job search will be thoroughly covered as students will learn techniques to search for employment opportunities. They will be able to write a professional resume and cover letter and learn the strategies and nuances of the job interview and participate in a simulated interview experience. Finally, they will simulate working in an Information Technology work environment by creating and testing a user-oriented instruction manual. Both individual and group work will be emphasized throughout the course.
   
COMP-1004 Operating Systems  

This course introduces students to computer hardware and general operating system concepts. Windows and GNU/Linux are used to illustrate and apply concepts. Students learn to install new systems; evaluate performance; use troubleshooting tools; perform command line operations; create, install, and execute batch files and shell scripts; manage widely used file systems; and implement appropriate host security.
   
COMP-1057 Intro to Object Oriented Concepts
 
This course introduces fundamental concepts of Object-Orientated Modelling and Analysis using the international standard language UML (Unified Modelling Language) along with a commercial-grade UML CASE tool. A professional problem solving approach is emphasized by examining case studies as working examples throughout the course. The Unified Software Development Process (or Unified Process) is introduced as an iterative and incremental software development framework to guide students through the various analysis stages.
   
COMP-2023 Management Issues for Information Technology
 
This course is designed to familiarize students with managerial, ethical, and professional issues in Computing and Information Technology. At the same time the course aims to educate students about key IT trends and contemporary issues in management theory and practice. Focus is also placed on understanding Project Management best practices and how they can be applied to modern IT projects using a systematic process as identified by the Project Management Institute. Issues of management or professional concern presented are complemented with examples and/or case studies that highlight practical applications of the theoretical concepts. Applications highlight the role of a knowledge worker in the information age.
 
Prerequisites:
COMM-1107 
   
COMP-2024 Project Management for Information Technology
 
The Project Management (PM) course introduces the fundamentals of working within a team on Information Technology (IT) projects. It covers teamwork principles and techniques, PM contexts, phases and processes, and the management of the integration of project scope, time, resources, costs, quality, communications, and risks. This course starts preparation for the Project Management Professional (PMP) certification exams. Microsoft Project is the software tool used to create sample project plans.
   
COMP-2025 OO Analysis & Design
 
This course is a continuation of Object Oriented Concepts with an emphasis on design-level UML modelling and CASE tool instruction. A variety of Software Development Processes are studied with a focus on iterative and incremental framework, using the Unified Process (UP). The combination of OO Concepts and this course will equip students with a good working knowledge of: (i) object-oriented concepts, (ii) visual modelling with UML, (iii) commercial-grade CASE tools, and (iv) industry standard software development processes.
 
Prerequisites:
COMP-1057 
 
DBMS-1000 Database Management Systems

This course explores Database Management Systems used to store information. After an introduction to key database concepts, the student will learn how to develop and read an an Entity Relationship Diagram (ERD), used to represent the database graphically.  The majority of the course covers Structured Query Language (SQL).   Data Definition Language (DDL - a subcomponent of SQL) is covered to create the physical database on disk.  Data Manipulation Language (DML - also a subcomponent of SQL) is introduced to allow for manipulation of the data stored in the database. Other key SQL concepts covered are stored procedures/functions including singleton and cursor processing as well as triggers. Finally, the Normalization process is discussed and applied to the ERD’s and database tables. 


DBMS-2000 DBMS Software
 
Database Management Systems (DBMS) Software covers the daily operation of a relational database. The course begins with an in-depth discussion of DBMS processing which explains what function(s) the database provides, and how these functions are implemented. Students will then study several DBMS systems of varying scale. The purpose of this is to highlight their similarities and differences as well as the advantages and disadvantages or each DBMS system. Topics will include installation and daily tasks necessary to implement and run these DBMS Systems.
 
Prerequisites:
DBMS-1000 
   
DBMS-2001 DBMS 1
 
DBMS 1 (Database Management Systems) provides in-depth coverage on one of the leading commercial relational database management systems (RDBMS) – the Oracle RDBMS. Topics include installation and basic database creation, creating users, permissions and advanced constraints. Also covered in depth are tablespaces and tables, specifying how the tablespaces and tables are handled, allocating storage space to tablespaces and tables, calculating storage space requirements and understanding how data is stored on the files. Also included is basic backup of the database and how to recover in case of simple database failures.
 
Prerequisites:
DBMS-1000 
   
DBMS-2002 Database Project

In the context of a business-like project, students will apply the skills of a database professional including business analysis, database design and normalization, database creation and maintenance, data loading, disaster recovery planning, generating reports, and altering the database structure in response to business demands. During the course of the project various database brands will be used. Professionalism will be expected from students at all times. They will be expected to demonstrate and apply corresponding skills including team work, business communications, ability and willingness to learn on their own, timeliness, and accuracy.
 
Prerequisites:
DBMS-2001 AND DBMS-3000 
   
DBMS-2003 Data Warehousing

This course covers the basic principles of data warehousing as well as the process of designing, populating, and interrogating a data mart. Students will design, create, build, and manage their own data mart (star schema). They will design, program, test, and run the processes that perform a complete initial data load into their Data Mart from an existing populated OLTP database. Students will develop in-depth knowledge as well as practical expertise on the lifecycle of a data mart.
 
Prerequisites:
DBMS-3000 

DBMS-3000 Advanced SQL
 
This course builds on the material covered in the Introduction to DBMS course. After basic Oracle SQL commands are reviewed, the course quickly progresses to cover advanced topics including views, database objects, user management, output formatting, sub-queries, and SQL programming. Students practice extensively the use of programming in PL/SQL, designing, testing, and debugging user stored procedures and cursors, as well as using exceptions effectively. They develop a solid knowledge of the Oracle system catalogue.
 
Prerequisites:
DBMS-1000 

DBMS-3001 DBMS 2
 
Applied DBMS II covers more advanced topics, based on the Oracle relational database management system (RDBMS). Topics include the database structure and how the database functions to ensure data remains consistent. Advanced backup and recovery procedures are studied to allow the database to be recovered regardless of the reason of failure with little or no data loss. A portion of the course also covers topics that can be useful in a variety of RDBMS. These topics include creating indexes to help improve the speed of database access, using optimization techniques to help tune SQL statements to perform faster, and understanding locking mechanisms used to protect data during changes and how locks can affect database performance.
 
Prerequisites:
DBMS-2001 

MATH-1028 Statistics for Information Technology  
 
A basic understanding of statistics is fundamental in the study of business. This course is designed to familiarize students with presenting and describing data, and calculating and using probabilities. Other concepts discussed are sampling methods and estimations, and regression analysis and correlation. Numbering system basics and conversion between the different numbering systems will be explored.
   
MATH-1029 Math for Information Technology
 
An understanding of financial mathematics is fundamental in the study of business. This course is designed to familiarize students with basic mathematics concepts such as exchange rates, indices, simple and compound interest, different types of annuities, mortgages, and business investment decisions.
   
NTWK-1000 Network Computing
 
This course conforms to the first of four courses leading to the Cisco Certified Network Associate (CCNA) designation. This course introduces the architecture, structure, functions, components, and models of the Internet and other computer networks. It uses the OSI and TCP layered models to examine the nature and roles of protocols and services at the application, network, data link, and physical layers. The principles and structure of IP addressing and the fundamentals of Ethernet concepts, media, and operations are introduced to provide a foundation for the curriculum. At the end of the course, students build simple LAN topologies by applying basic principles of cabling, performing basic configurations of network devices including routers and switches, and implementing IP addressing schemes.
   
NTWK-2000 Applied Network Computing
 
This course conforms to the second of four courses leading to the Cisco Certified Network Associate (CCNA) designation. The course expands on topics covered in Cisco Networking Level 1 and examines new topics. The course describes the architecture, components and operation of routers and switches in a small to medium business environment. Students will analyze, configure, verify and troubleshoot the following using both IPv4 / IPv6 protocols and services: RIP, RIPng, OSPFv2, OSPFv3, ACLs, DHCP, NAT, PAT, Static / Dynamic routing, Inter-VLAN routing, Routing tables, Dynamic Trunking (DTP) and VLANs. By the end of this course, students will be able to recognize and correct common routing / switching issues. Basic procedural labs are introduced in each chapter. Students then perform basic configuration, implementation, and troubleshooting on provided equipment. Packet Tracer activities reinforce new concepts and allow students to model and analyze routing.
 
Prerequisites:
COMP-1004 AND NTWK-1000 

NTWK-2001 Linux/Unix Administration

This course provides the skills and knowledge required to install, configure, and support network services on a Linux server.  After installing a Linux server, students will learn how to administer and manage their own Linux-based network.  Topics include administering users, securing the file system, configuring network connectivity, managing processes, configuring and managing printing, implementing remote connectivity, and implementing, configuring and managing a variety of network services such as DNS, DHCP, NFS, FTP, email and web services in a hands-on environment.
 
Prerequisites:
COMP-1004 AND NTWK-1000 

NTWK-2002 Advanced Network Administration
 
This course provides the skills and knowledge necessary to perform network management tasks on a Windows network. After installing a Windows server, students will learn how to administer and manage their own Windows-based network. Topics include designing networks, unattended installations, administering users, organizing and protecting the file system, installing and managing network clients, managing a printing environment, providing Internet services, and installing/configuring/maintaining network services such as DNS and DHCP in a hands-on environment.
 
Prerequisites:
COMP-1004 AND NTWK-1000 
 
NTWK-2003 Advanced Windows Server
 
The Advanced Windows Server course allows students to explore the more advanced features of the Windows Server 2008 R2 operating system.  Topics covered include server installation options, command-line utilities and Powershell scripting for Active Directory maintenance, DNS, DHCP, client management, system monitoring and domain merges.  Research, planning, troubleshooting and documentation are stressed through the implementation of group projects in which the students plan, design and implement a Windows network to support business needs. An emphasis is placed on the importance of professionalism and group work within the IT environment. The course is targeted towards participants who will be designing, installing and maintaining a Windows work environment.
 
Prerequisites:
NTWK-2002 AND NTWK-2000 

NTWK-2004 Network Security & Business Continuity

This course introduces students to a wide range of security topics such as understanding attackers and their attacks, cryptography, web security, operational security, and security management. Emphasis will also be placed on policies and procedures with a focus on business continuity plans. Students will complete several labs using security software and hardware to enable them to secure a network.
 
Prerequisites:
NTWK-2002 AND NTWK-2000 
 
NTWK-3000 Switches and Wireless  
 
This course conforms to the third of four courses (in Cisco’s current revision – Exploration series) leading to the Cisco Certified Network Associate (CCNA) designation. The course provides students with a thorough understanding of LAN switching and wireless technologies. An emphasis is placed on configuring and troubleshooting LAN switches and wireless within the LAN environment. Students develop an understanding of the operation of switches and wireless technologies and protocols and their role in the network. Basic procedural labs are introduced in each chapter. Students then perform basic configuration, implementation and troubleshooting labs. Packet Tracer activities reinforce new concepts, and allows students to model and analyze the processes.
 
Prerequisites:
NTWK-2002 and NTWK-2000 

PROJ-2006 Industry Project
 
Industry Project provides experience in performing an ICT (Information/Communication Technology) project requiring cross-functional teamwork while meeting customer requirements and deadlines. Each project team proposes, documents, tests, plans, models, develops, manages, and delivers its own project - either a new development or an enhanced or upgraded system. Teams must also provide for ongoing support of the delivered system. The course provides practice to further develop interpersonal, verbal, and written communication skills plus critical thinking, problem solving, and independent and life-long learning skills. After completion of Term 3 of the program students must complete Industry Project or Co-Operative Work Experience.
   
WEBD-1000 Web Development
 
This course is designed to offer students an introduction to the Internet and programming Web applications. Students will become familiar with browsing the Web, using Internet technologies, such as Telnet and FTP; create properly structured and valid Web pages using XHTML & CSS with embedded JavaScript for data validation and user interaction. A course-ending project will have students plan, create and upload their own websites to the Web.
 
Prerequisites:
COMP-1004 and ADEV-1000 
 
WEBD-2000 Electronic Commerce
 
This course provides an examination of the current trends in Business to Consumer (B2C) electronic commerce. Coverage is also given to the Ruby programming language and the Model-View-Controller (MVC) application design pattern. Learners will implement an e-commerce system using the Ruby on Rails MVC web-programming framework through a series of graduated assignments.
 
Prerequisites:
ADEV-1001 AND DBMS-1000 AND WEBD-1000 
 
WEBD-2001 XML Programming
 
This course explores XML and related web technologies. Building on web development fundamentals, the course provides an overview of XML document components and uses. It investigates the use of Cascading Style Sheets with XML and (X)HTML. An exploration of contemporary XML-related technologies follows, such as the Document Object Model (DOM), Extensible Style Sheet Language Transformations (XSLT), XML Path Language (XPath), XSL Formatting Objects (XSL-FO), XML Schemas (XSD), HTML5, and JQuery.
 
Prerequisites:
ADEV-1001 AND WEBD-1000 

WEBD-2002 Web Design
 
This course covers design principles that can be applied to the creation of well designed web pages and websites. It addresses usability issues such as navigation, site access using different devices and interactivity. You'll learn about project planning, layout, usability and different design styles. GIMP will be used to work with andmanipulate pictures (Jpegs), create graphics, icons, logos and basic animation. The HTML5 canvas will be used to add graphics, links, basic animation, event handling and dynamic graph creation (using XML files) to web pages. Students will use GIMP and the HTML5 canvas to work through a series of assignments and create a web site as a final project.

 
Prerequisites:
WEBD-1000 
 
WEBD-2003 Web Security
 
This course introduces students to a wide range of security topics such as understanding how attacks occur, who is attacking, cryptography, web security, policies and procedures, and understanding exploits. All topics will build on a foundation of ethics. Emphasis will be on real world examples of vulnerabilities and how they will be exploited.
 
Prerequisites:
WEBD-1000 AND DBMS-1000 
  
WEBD-2005 Server-Side Computing

This course explores concepts and technologies that are run on a Web Server to provide a rich and dynamic web site. Topics covered include creating dynamic web pages generated from data stored in a database, validating data submitted to the server from a web form and saving that data in a database, as well as maintaining session cookies to provide data persistence to clients accessing the website. These topics are viewed under a number of different server side technologies including PHP and MySQL.
 
Prerequisites:
WEBD-1000 AND ADEV-1001 
 
WRKE-2024 Co-Operative Work Experience

Co-operative education integrates related on-the-job experience with classroom theory by integrating a term of paid employment within the terms of academic study. Students are given the opportunity to practice and apply the skills gained at the college as productive full time employees on their work term. Placement of eligible students occurs in January and May each year to coincide with the start of the academic terms. Each work placement is a minimum of 16 weeks in length. Student performance will be monitored and evaluated by both the College and the employer. After completion of term 3 students are required to complete the co-operative work experience or the industry project.
 

Red River College endeavours to provide the most current version of all program and course information on this website. The College reserves the right to modify or cancel any course, program, process, or procedure without notice or prejudice. Fees may change without notice.