B.C.'s Energy College


Apply Now
top menu Current Students Prospective Students Community Faculty & Staff
CPST 050 - Provincial Computer Studies: Applications
CPST 050

This course allows the student to develop problem solving/critical thinking skills utilizing computer application software as a tool. Project work will be emphasized.

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

This course is offered online:  No

Prerequisites: CPST 040 or permission of the instructor

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
Grading System:  Letters

Passing Grade:  D (50%)

Nature of Participation:  Individual lab work

Percentage of Individual Work:  100

Course Offered in Other Programs:  No

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