Computer Applications 12

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.

Prerequisites

Grade 10 English or equivalent.

What you will learn

• 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

How to register

This course is offered as part of a VCC program only.

Contact us

If you have any question, please email at advising@vcc.ca.

† This information is intended as a guideline only. Program and course details are subject to change with the approval of VCC's Board of Governors.