vcc.ca
COMP 0970: Computer Applications 12
Effective date
May 2025
Department
College & Career Access
School
Arts and Sciences
Description
Students will complete 2 of the following modules for ABE Provincial Level Computer Applications 12.
Word Processing: This course provides students with the basic knowledge and skills to use Microsoft Word, including advanced techniques in text editing, character and paragraph formatting, headers and footers, tables, styles and templates, mail merges, graphics and desktop publishing concepts.
Spreadsheet Management: This course provides students with the knowledge and skills needed to use advanced spreadsheet data entry and formatting techniques. Students apply statistical, financial and decision-making functions, cell protection and data validation. Students create macros to automate worksheet management.
Database Management: This course is designed to show students the concepts of database management using Microsoft Access. Students will learn how to create relational database tables, backup and repair the database, view data through queries, perform data editing with screen forms and generate formal output in a variety of report formats. On completion of this course students will be able to create a functional database system. Students will explore ethical and social issues of database use.
Digital Art and Graphics: This course introduces tools and procedures required for digital art and graphic design. Basic terminology of digital images and file formats will be introduced. Students will begin their study of digital art using photo editing software (GIMP, Photoshop). Photo editing will introduce students to design software and familiarize them with common functions of design software such as movement, selection, and colour manipulation.
Computer Programming: This course introduces students to the topic of Computer Programming. Students will learn the basic syntax of a popular programming language (Java, python, or C++). Students will learn how to approach and solve problems using basic procedural solutions (one-dimensional arrays, non-nested loops, minimal nested conditionals, no recursion) that demonstrate understanding of the fundamental concepts of programming.
Credits
4.0
Year of study
Grade 12 Equivalency
Prerequisites
Grade 10 English or equivalent.
Corequisites
None
Course Learning Outcomes
Upon successful completion of this course, students will be able to:
- Word Processing: Students will meet the learning outcomes for ABE Provincial Level Computer Studies (Publishing) as stated in the most recent ABE Articulation Handbook. Spreadsheet Management: Students will meet the learning outcomes for ABE Provincial Level Computer Studies (Spreadsheet Management) as stated in the most recent ABE Articulation Handbook. Database Management: Students will meet the learning outcomes for ABE Provincial Level Computer Studies (Database Management) as stated in the most current ABE Articulation Handbook. Digital Art and Graphics: Students will meet the learning outcomes for ABE Provincial Level Computer Studies (Digital Art and Graphics) as stated in the most recent ABE Articulation Handbook. Computer Programming: Students will meet the learning outcomes for ABE Provincial Level Computer Studies (Programming) as stated in the most recent ABE Articulation Handbook. https://www.bctransferguide.ca/wp-content/uploads/2023/07/abeguide2324.pdf
Prior Learning Assessment & Recognition (PLAR)
None
Hours
Clinical, Lab, Rehearsal, Shop, Kitchen, Simulation, Studio: 192
Practicum, Self-Paced, Individual Learning: 192
Total Hours: 192
Practicum, Self-Paced, Individual Learning: 192
Total Hours: 192
Instructional Strategies
Self paced - one-to-one individualized instruction
Grading System
Letter Grade (A-F)
Passing grade
D
Evaluation Plan
|
Type |
Percentage |
Assessment activity |
|
Project |
20 |
Word Processing & Spreadsheet Management: two projects @ 10% each |
|
Quizzes/Tests |
80 |
Word Processing & Spreadsheet Management: four tests @ 20% each |
|
Assignments |
20 |
Database Management: one assignment |
|
Project |
20 |
Database Management: one project |
|
Quizzes/Tests |
60 |
Database Management: two tests @ 30% each |
|
Quizzes/Tests |
10 |
Digital Art and Graphics: one test |
|
Project |
90 |
Digital Art and Graphics: four mini-projects @ 15% each and one culminating project @ 30% |
|
Quizzes/Tests |
20 |
Computer Programming: ten quizzes @ 1% each, two tests @ 5% each & one test @ 20% |
|
Project |
40 |
Computer Programming: four min-project @ 10% each |
Course topics
- Word Processing: Advanced character and paragraph formatting Footnotes, endnotes, indexes, bookmarks, cross references and tables of contents Tables and columns Mail merge of letters and labels Productivity tools: wizards, styles and templates Sections, headers and footers Charts, graphics and images
- Spreadsheet Management: Advanced data entry techniques Worksheet functions and formulas Advanced charts Reports Data analysis Macros Customized spreadsheets
- Database Management: Introduction to Database Concepts Building a Database Working with Data Developing Queries Developing Forms Developing Reports Social and Ethical Issues
- Digital Art and Graphics: Software options and basic terminology for graphic design Object transformations and selection options Common graphic design operations and tools Color and image formatting Various tools and operations relating to photo editing Extended software suites for graphic design
- Computer Programming: Basic Programming Concepts Data Types Arrays Loops Conditional Statements Basic Algorithms Procedures
Notes:
- Course contents and descriptions, offerings and schedules are subject to change without notice.
- Students are required to follow all College policies including ones that govern their educational experience at VCC. Policies are available on the VCC website at:
https://www.vcc.ca/about/governance--policies/policies/. - To find out if there are existing transfer agreements for this course, visit the BC Transfer Guide at https://www.bctransferguide.ca.