UofC Navigation

ICT 427 Microsoft Macros and VBA Level 1

 Email this information to yourself or a friend
 Remind me of this course at a later date



Course Description

Take full advantage of Microsoft Office suite by automating routine tasks. No matter which application you're using, there are some tasks you perform dozens of times, such as typing a section of text, running a series of menu commands, or formatting a document in a particular way.

This course shows you how to accomplish the same tasks by incorporating them into a macro that you can run with just a few mouse clicks or keystrokes.


Course Details

Coming Soon


Prerequisites

  • There are no prerequisites for this course, however, students must have significant experience with Microsoft Excel and Access in order to successfully complete this course.
  • Students must also meet the recommendations and requirements in the Notes section along with any proficiencies identified below.

Instructional Delivery

  • Face-to-face in a lab

Registration

  • Registrations within 24 hours of course start time must be made by phone (403-220-2988).

Top of Page


Course Content

Course Level Learning Outcomes

  • Coming Soon

Topics of Instruction

Getting started with the Visual Basic Editor

  • Visual Basic for Applications
  • Properties and modules
  • The Code window

Programming basics

  • Working with variables and functions
  • Scope of variables
  • Scope of procedures

Word objects

  • Programming with objects

Understanding Objects in Excel

  • Objects
  • Application object

Control Structures

  • Using decision structures
  • Using loop structures

Top of Page


Notes

Required Tools

  • Online and in class students need acess to Microsoft Office 2016 outside lab/class time to work on assignments, projects, or other course work. This software may be downloaded from Microsoft.

Textbooks

Attendance

It is strongly recommended that students attend every class. It is the responsibility of the student to communicate potential absenteeism to the instructor.

Top of Page


Prerequisites

  • There are no prerequisites for this course, however, students must have significant experience with Microsoft Excel and Access in order to successfully complete this course.
  • Students must also meet the recommendations and requirements in the Notes section along with any proficiencies identified below.

Top of Page


Proficiencies

You should be a relatively experienced Excel user able to comfortably perform the following tasks:

  • create workbooks, insert sheets, save files
  • navigate through a workbook
  • use the Excel Ribbon user interface
  • enter formulas
  • use Excel's worksheet functions
  • name cells and ranges
  • use basic Windows features
  • understand file management techniques

Top of Page



Applies Towards the Following Certificate(s)




Sections

  ICT 427 - 029 Microsoft Macros and VBA Level 1  
  Fall 2016   Status:  Available
 
Class:   Tue 8:30AM - 4:30PM
18 Oct 2016 to 25 Oct 2016
Number of Sessions: 2 Sessions
Hours: 14.00
Course Fees:   Flat Fee non-credit    $625.00
 
Campus: Main Campus
Delivery Options:  Class
Instructor(s): Somasundari Sankaragomathi
  Section Notes:  

COURSE SCHEDULE AND DELIVERY

This course has 2 classes scheduled once per week for 2 weeks. This course is delivered in an in class format. Classes are held in a classroom lab.

PREREQUISITES

There are no prerequisites for this course, however, students must have significant experience with Microsoft Excel and Access in order to successfully complete this course.

TRANSFER AND WITHDRAWAL FEES

A $25 fee applies for course withdrawals and transfers. For our standard Refund, Withdrawal and Transfer Policy visit conted.ucalgary.ca/refund

  
 
  ICT 427 - 030 Microsoft Macros and VBA Level 1  
  Winter 2017   Status:  Available
 
Class:   Wed 8:30AM - 4:30PM
22 Feb 2017 to 01 Mar 2017
Number of Sessions: 2 Sessions
Hours: 14.00
Course Fees:   Flat Fee non-credit    $625.00
 
Campus: Main Campus
Delivery Options:  Class
Instructor(s): Somasundari Sankaragomathi
  Section Notes:  

COURSE SCHEDULE AND DELIVERY

This course has 2 classes scheduled once per week for 2 weeks. This course is delivered in an in class format. Classes are held in a classroom lab.

PREREQUISITES

There are no prerequisites for this course, however, students must have significant experience with Microsoft Excel and Access in order to successfully complete this course.

TRANSFER AND WITHDRAWAL FEES

A $25 fee applies for course withdrawals and transfers. For our standard Refund, Withdrawal and Transfer Policy visit conted.ucalgary.ca/refund

  
 


Search ContEd