Overview

Excel is the spreadsheet component of Microsoft Office and it is an extremely versatile tool for manipulating numeric data, creating charts and sorting and filtering text data.

Coming May 20-May 27 2 sessions Tuesdays 9:00am-4:00pm UBC Robson Square

Course Description

With Excel you can:

• Work with your numeric data
• Display it as charts
• Manipulate non-numeric data as tables like you can in many database products

In this hands-on introductory workshop you will examine spreadsheet principles, entering data, creating formulas, designing worksheets, charting, data management and printing. Several applications for Excel are explored using examples and case studies.
Duration: 12 hours

Register for this course: Excel^® I Introduction to Workbooks, Charting, Data Managemen

 

Theoretical Objectives History and applications for worksheets Creating formulas Formatting to add meaning Functions (structure and use) Charts for communication Database terminology & applications

Practical Objectives Worksheets for manipulating numeric data Formatting Creating and modifying Charts Creating and modifying Data tables (edit, sort and filter) Budget Models Decision Support Tool

---

Lab Equipment and Devices

The sessions are conducted in a computer lab and you will have a lab computer for you to use.

You are welcome to bring your own computer to the lab sessions if you prefer to use that. Wireless access is available in the lab.

At times you will be doing a fair bit of typing and you will want to have a large enough screen and separate physical keyboard so that you can view content and type at the same time.

Lab exercises are based on using the lab computers.
If it appears that you are having challenges with your own device, we will ask you to use the lab computer.

Instructional Methods

• Hands-on labs
• Discussion
• Online collaboration
• Lecture

Course Materials

• Web site
• Course notes
• Printed copies of on-screen lecture notes available on request during lectures

No Recording or Pictures in the Lab

Please note: Taking pictures or video during the course sessions is not permitted. All the course materials and lecture notes are available in physical form and on the web.

Next session is Tuesday May 6th. Seats still available

If you are familiar with previous versions of Microsoft Outlook then sending and receiving email with Outlook 2013/2010 is very simple. For many people making the transition, that is where they stop exploring. In this course we uncover the mysteries of the new fluent user interface (the Ribbon) to help you to do what you have always done like emailing, scheduling and responding to appointments, categorizing your mail and calendar events. We also explore new ways to be productive with flags, rules, automatic formatting, quick art, smart parts and more.

Duration: 6 hours (Morning and afternoon session on the same day)

Register for this course: Outlook^® – Out of the Inbox

May 6 One session  9:00am-4:00pm UBC Robson Square

 

Theoretical Objectives Understand why the Inbox gets out of control and identify specific issues arising from the way you use Outlook now. Understand the key actions that can arise from an email and learn Outlook shortcuts to accomplish these quickly. Identify some best practices that are supported by Outlook, which can be applied to your individual situation. Choose specific features or Outlook that you can use immediately. Create a plan for you will start using those features.

Practical Objectives Use the Fluent User Interface Ribbon Backstage View Quick Access Toolbar Navigation Pane Folders Buttons To-Do Bar Date Navigator Appointments Task List Categories Tasks Folders Search Folders Quick Parts Key Tips (old name – keyboard shortcuts) Optional topics Archiving / Backup Journal

---

Lab Equipment and Devices

The sessions are conducted in a computer lab and you will have a lab computer for you to use.

You are welcome to bring your own computer to the lab sessions if you prefer to use that. Wireless access is available in the lab.

At times you will be doing a fair bit of typing and you will want to have a large enough screen and separate physical keyboard so that you can view content and type at the same time.

Lab exercises are based on using the lab computers.
If it appears that you are having challenges with your own device, we will ask you to use the lab computer.

Instructional Methods

• Hands-on labs
• Discussion
• Online collaboration
• Lecture

Course Materials

• Web site
• Course notes
• Printed copies of on-screen lecture notes available on request during lectures

No Recording or Pictures in the Lab

Please note: Taking pictures or video during the course sessions is not permitted. All the course materials and lecture notes are available in physical form and on the web.

The next session of this course starts next Wednesday night 6:30-9:30 pm at Robson Square (Lab C460). Seats still available: Register here: Programming Mechanics and Mindset

Overview

This course can be applied to the Award of Achievement HTML5 Academy

Introduction

With modern tools you can create a web page, or even an entire web site without knowing anything about programming – but – to get beyond simply adding content to pre-made templates you do need to know what is going on below the surface: You need to know about programming. Even if you don’t intend to write programs, an understanding of the fundamentals will demystify many of the technologies you will encounter in web development.

Course Description

We explore a big picture view of the Internet and identify centres of technology. It is in these centres of technology that various kinds of programming take place. We then look at high level programming concepts: variables, scope, control structures, sub procedures and functions and discuss scripting, compiled and hybrid languages and concepts related to object oriented programming.

Duration: 18 hours (6 evening sessions)

Register for this course: Programming Mechanics and Mindset

Theoretical Objectives You will learn concepts and terminology related to programming, and understand where these are used in web development. Some of the high level concepts covered in this course: Programming in General Scripting in Contrast High/Low level languages Abstraction Sequence Branching Iteration Variables Procedures/Functions Parameters Return Values State and Statelessness on the web Object Oriented Programming

Practical Objectives You will learn how to read programming/scripting code in several environments and recognize the application of the concepts shown in the Theoretical Objectives. (left panel on this page). You will learn the general layout of a integrated software development environment tool and create a simple website.

 

Lab Equipment and Devices

The sessions are conducted in a computer lab and you will have a lab computer for you to use.

You are welcome to bring your own computer to the lab sessions if you prefer to use that. Wireless access is available in the lab.

At times you will be doing a fair bit of typing and you will want to have a large enough screen and separate physical keyboard so that you can view content and type at the same time.

Lab exercises are based on using the lab computers.
If it appears that you are having challenges with your own device, we will ask you to use the lab computer.

Please plan to use your own cloud based storage (SkyDrive, DropBox, iCloud or similar) or a USB storage key.

 

Instructional Methods

• Hands-on labs
• Discussion
• Online collaboration
• Lecture
• Homework assignments submitted online

Course Materials

• Web site
• Course notes
• Printed copies of on-screen lecture notes available on request during lectures

No Recording or Pictures in the Lab

Please note: Taking pictures or video during the course sessions is not permitted. All the course materials and lecture notes are available in physical form and on the web.

 

Doing a one day session about Microsoft Word on Tuesday at Robson Square.

Details here: Word® 2013/2007 Quick Start

Overview:

If you are an experienced user of earlier versions of Microsoft Word, then making the initial transition to Word 2010/2007 is easy, until you try to do familiar things like formatting and extensive editing. In this course we uncover the mysteries of the new fluent user interface (the Ribbon) to help you to do what you have always done like create and edit text, format with styles and outlines, check grammar and spelling. We also explore new ways to be productive with shapes, smart art, quick parts, references and more. (We will look at Word 2013 too).

— more Word® 2013/2007 Quick Start