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.

 

Hours: 120 (Lecture Hours: 2;  Laboratory Hours: 4)

 

Total Weeks:  20

 

Prerequisites:
CPST 040
OR permission of the instructor

 

Non-Course Prerequisites:
None

 

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:
1. Information Technology 
- 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)

2. Networking
- 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 differences
- Describe management issues, including traffic analysis and security
3. Database Management
- Design and create flat file and relational databases
- Maintain and modify the structure of existing databases
- Correctly formulate queries
- Create and edit forms
- 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 Presentation
- 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 footer
- Generate links, cross references, footnotes, indexes and tables of contents where appropriate
5. Advanced Spreadsheets
- 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%)

 

Percentage of Individual Work: 100

 

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