Naming Convention

When submitting files to your instructors, please follow this naming convention:

YYYY-MM-DD_{filename/assignment}_{your name}

for example, for Lesson 41 from the Keyboarding text:

2009-08-14_Lesson_41_Keith.zip

Lesson Plan 2009-09-01

Microsoft Word – Excel Quick Reference

Covered toay:

 Review of Mail Merge and Intro to Excel.

Frank’s Furniture Warehouse. Tackle it tonight!

How to: Formatting Exercise

This document outlines steps that could be performed to efficiently complete the Formatting Exercise bonus assignment.

Successful completion of this assignment could result in a bonus to your Word mark of up to 10%.  (i.e. if you score 10/10, you will receive an extra 10% to your grade; if you score 7/10, you can score an extra 7%)

Your assignment must be submitted by 1 pm on Monday, August 28, 2009 to count for the bonus.  Good luck!

Completing the Formatting Exercise

Excel – Frank’s Furniture Warehouse

We will be covering this assignment as an entry to Excel.

Assignment 1 – Franks Furniture Warehouse

In this assignment, you will learn about…

* sorting

* formulas and calculations

* autosum

* autofill

* absolute references $a$1 ($ signs to lock in a cell reference)

* charting

* setting spreadsheets up for printing

How To – Success Factory Letter

1. Download the text from the blog.
2. Add the header.  Use right tab to align the phone #, fax # and website on the right-hand side of the header.
3. Format the text in the table.  Set a decimal tab for the “price” column.  Centre-Align the header row.  Left-align the Date, City and Title columns.
4. Create Smart Art for the Conceive- Believe – Achieve diagram.
5. Watch the line spacing to ensure there is not unnecessary line spacing above/below each paragraph.  In particular, watch the header, inside address and signature.

Funny Bunny memo – How To

Here is an overview of how to complete the Funny Bunny Memo.

Funny_Bunny_Howto

Related topics:

* using templates

* Clip Art, Graphics, SHIFT vs CTRL when selecting and resizing graphics

* Grouping

* Bring to Front/Back

Funny Bunny Veterinary Clinic

This is the original text: funny bunny memo – text only

This is your target document: Funny Bunny Memo

Skills to utilize:

* Template

* Clip Art

* manipulating graphics – layouts

* tables

How-to details:

1. Use the Professional Memo template accessible from Office Button > New > Memos.  You will need to adjust the first line and hanging indents, particularly because these indents will affect the behavior of the table you need to set up to position the rabbits.

2. To generate the effect at the bottom, you will need to create a picture with four small rabbits positioned over top of a circle/cross shape.  To insert the shape, use Insert > Illustrations > Shapes > Flowchart.  You will need to play with the layout/wrapping options to ensure that the rabbits can be positioned properly over the picture.  You can use Grouping to keep the shapes together.  Once the “grouped shape” is in place, you can then set a “tight” layout on it and then drag it into the middle of the text to create the wrap effect pictured.

Lesson Plan – Monday, August 24, 2009

1. Review for Midterm Exam – Word 2007

Review of the Assignments covered thus far – Diagnostic, ALIS, Dining Etiquette, How Tos, calendar templates, Quick Parts.  Midterm will be on blog content covered in-class up to Thursday Aug 20/09, including Headings, Table of Contents, Headers/Footers, Section Breaks, Find/Replace, Tabs, Tables

Midterm exam scheduled for Tuesday, Aug 25/09.

2. Review of References – Keyboarding Lesson 48 + extra assignment

Based on the submissions for the references assignment, we will need to review this concept in more detail.  Opportunity to correct and resubmit, plus new assignment with particular focus on web references.

3. Business Communication Text – Chapters 2-4 Writing Improvement

We will start going over the key concepts in improving your writing skills, including review of the Chapter 2-4 PowerPoints and Writing Improvement Exercises.  This will flow into grammar review and sentence structure concepts.

4. Computer Fun – file navigation / operating system navigation tips, file extensions

5. Skills in Demand report update/analysis

Lesson Plan Friday August 21, 2009

On Friday, we covered the following:

1. Review of Report – Skills in Demand – brainstorming

2. Word – Dining Etiquette challenge – how to isolate just the questions?

solution A. convert to table and then sort table (note: Insert > Table > Convert Text to Table — can set different delimiters (paragraph marks, tabs, commas, etc.)

solution B. use Find/Replace to insert extra tab (^t) in front of Answers, then convert to table in Word so Answers go into separate column.  Then, cut out the Answers and resort the Questions

3. Keyboarding – in-class review of Lesson 37 (Memo format)

Students provided with time to complete Lesson 37 key documents (memo keying)

Macro Exercise

We will be covering this in more detail after the midterm.

Here is the target document: Macro Exercise Completed

These articles are originally from the Prairie Horizons newsletter:

http://prairiehorizons.files.wordpress.com/2009/08/ph_v33-1_fall_1998.pdf

To extract the text, we copied and pasted from the pdf into Word.  However, the pasted text has too many paragraph marks!  How can we remove them efficiently?  (Hint: Use macros!  Use one to remove excess paragraph marks and another to remove excess spaces.)

 Macro Task 1

Macro Task 2

Macro Task 3