B.C.'s Energy College

Apply Now
CPST 050 - Provincial Computer Studies: Applications
This course allows the student to develop problem solving/critical thinking skills utilizing computer application software as a tool. Project work will be emphasized.

  • Total Hours: 120
  • Lecture Hours: 40
  • Laboratory Hours: 80
Total Weeks:  20

Prerequisites: CPST 040 or permission of the instructor

Course Content:
This computer studies course will cover a minimum of two of the following:

1. Information Technology

2. Networking

3. Database Management

4. Publishing/Presentation Software

5. Advanced Spreadsheets

As far as possible, this course will be a hands-on, practical application course with a useable product at the end of the project. Project may be done for non-profit groups (newsletters, presentations, web pages, etc.), to help instructors prepare course materials, or (as a last resort) as part of a simulation. The students will use a phased systems development approach in the project.

Learning Outcomes:
This computer studies course will cover a minimum of two of the following:

Information Technology -The learner will be able to:
      • Identify/explain/demonstrate how communications hardware and software function
      • Send, receive and organize electronic mail
      • Demonstrate proficient use of the Internet including:
        • Explain how the Internet was developed and how it functions
        • Use of a WWW browser
        • Search techniques using one or more search engines
        • Downloading files
        • Participation in one or more newsgroups
        • Basic web page design
        • Demonstrate an awareness of ethical and security issues
        • Access information from a CD-ROM drive
        • Send and receive a document through use of a fax modem (recommended option)

Networking -The learner will be able to:

  • State advantages and disadvantages of using networks
  • Describe different network configurations (printer network, LAN, WAN, etc.)
  • Describe and diagram different network topologies (point-to-point, star, bus, etc.)

  • Describe the advantages and disadvantages of different network data transmission media (twisted pair, coaxial cable, optical fibre, and wireless)
  • List and describe common network operating systems and network protocols
  • Describe various server models, including file servers and client/server systems
  • List Internet/intranet similarities and differencesDescribe management issues, including traffic analysis and security
3. Database Management -The learner will be able to:
      • Design and create flat file and relational databases
      • Maintain and modify the structure of existing databases
      • Correctly formulate queries
      • Create and edit forms
      • Create and edit reports
      • Be aware of various social and ethical issues involving databases
4. Publishing/Presentation Software -Learning outcomes shall be applied to one or more of the following:
      • Advanced Word Processing
      • Desktop Publishing
      • Multimedia Presentations
The learner will be able to:
  • Organize and present a variety of text, graphic and other data (e.g. animation and sound), following appropriate design and layout procedure
  • Demonstrate the use of templates, wizards and other productivity tools
  • Merge documents and integrate tables, charts and graphics
  • Describe the various file formats used for text, graphics, sound, animation and publication files
  • Demonstrate the ability to change file formats where possible
  • Create, modify and manipulate digital graphic images (e.g. scan, draw, paint)
  • Retrieve a graphic/animation/sound file through using either CD-ROM or the Internet
  • Apply, where appropriate, correct typographic principles involving font selection, point size, justification, kerning, bullets, headers and footers
  • Generate links, cross references, footnotes, indexes and tables of contents where appropriate
5. Advanced Spreadsheets -The learner will be able to:
  • Enter, format, and edit data
  • Use and write formulas
  • Create and modify charts
  • Create reports
  • Manage and analyze data
  • Create macros or use a programming language to customize a spreadsheet
  • Design a spreadsheet to analyze, interpret, and project outcomes in an applied situation
Passing Grade:  D (50%)

Supplies:  Memory Stick

Textbooks: Textbooks are subject to change. Please contact the bookstore at your local campus for current book lists.

Home   |   About NLC   |   Admissions   |   Programs   |   Services   |   Student Life   |   News & Events   |   Contact Us
Northern Lights Facebook Fan Page Northern Lights Twitter Page Northern Lights YouTube Page