Programs

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.