All Office Tna

Microsoft Training Needs Analysis Forms http://www.mousetraining.co.uk

Click the tabs at the bottom for information on the courses offered. Alternatively, use the hyperlinks to view the questions for each application. These forms are designed to help select the appropriate length and level of training required. Then just email back your responses and we will do the rest.

Candidate Info Employees Name Department Telephone Manager

Tick Relevant Course Category's) 1

Excel (Spreadsheet)

2

Word (Word Processing)

3

Outlook (Email)

4

Visio (Drawing)

5

Access (Database)

6

PowerPoint (Presentation)

7

FrontPage (Web Design)

8

Project (Project Management Publisher (Brochure & Page Design)

9

http://www.mousetraining.co.uk

Result

✘

✘

✘

✘

http://www.mousetraining.co.uk

access

Intro Intermediate Advanced No training Required Intro Intermediate Advanced No training Required Intro Intermediate Advanced No training Required Intro Intermediate Advanced No training Required

for each ail back

Intermediate No training Required

Intermediate No training Required

Intermediate No training Required

Intermediate No training Required

Training Needs Analysis Microsoft Excel

www.mousetraining.com

At MTCTS we endeavour to treat all delegates in an individual way and therefore ask you to fill in this form so that we are able to put together a course that is most suited to you. For each question you are given the choice of 4 responses labelled A-D. Please choose one response that most accurately describes your knowledge level for each topic. Please note that this is not a test. A B C D

I have never used it before or do not fully understand the NO KNOWLEDGE topic. BASIC KNOWLEDGE I have the basic understanding of the topic. GOOD KNOWLEDGE I understand most of it - there may be gaps COMPLETE KNOWLEDGE I understand it fully - use it often.

User Name: Dept/Section:

Topic

A

B

C

D

NO BASIC GOOD CO MPLE TE KNOWLEDG KNOWLE DG KNOWLEDG KNOWLEDG E E E E

Starting New Workbooks Saving a File The difference between Save and Save As Closing Files Opening Files Entering Text, Numbers, Dates Editing and Deleting cells Selecting Range of Cells Moving and Copying data Formatting Numbers Changing Font Type and Size Text Alignment and Orientation Wrapping Text Applying Borders and Shading Using Autoformat Conditional Formatting Format Painter Clearing Formats Formatting Columns and Rows Printing and Previewing spreadsheets Changing Page Orientation Adding Headers and Footers Printing a Selection Adjusting Page Breaks Setting a Print Area Inserting New Columns and Rows Creating a Formula with + & Creating a Formula with * & / Creating a Formula with brackets Copying a Formula Relative and Absolute ($) Reference Using Autosum Functions: Sum, Average Functions: Min, Max, Count Function Argument Tool Tips Using the Now,Day,Month,Year functions Using If Statement Using Nested If Vlookup and Hlookup functions Creating Charts Using the Chart Wizard Editing and Formatting charts Creating Combination charts Saving Custom Charts Using Error Bars and Trendlines on a chart Creating Multiple Spreadsheets File Inserting and Deleting Sheets Renaming and reordering sheet tabs Linking Sheets in the same file Hiding Sheets Linking different Excel Files Using Data Consolidation Viewing Different Files at once Saving a Workspace Naming individual and ranges of cells Deleting and amending named ranges Using named cells/ranges in formulae Named ranges as a navigation aid Applying names retrospectively Sorting Data Adding Subtotals on a list Using Autofilter Using Advanced Filter Database Functions: Dsum, Dmin, Dmax Outlining Spreadheets Using the Pivot Table Wizard Changing the Pivot Table Layout Pivot Chart Setting up Scenarios Uing Goal Seek and Solver Creating and using Custom Views Sharing a File Tracking changes Protecting Cells, Sheets, Files Password Protecting a cell range Auditing Spreadsheets Customizing Toolbars Customizing Menus Importing / Exporting Text files Recording Macros Absolute and Relative record Personal Macro Workbook Running Macros Using the Visual Basic Editor Navigating in a Module Inserting and Removing Modules Reassigning Keyboard Shortcuts Running Subroutines together Using Step Mode Using Object Browser Use of Arguments in functions Using Variables Using Constants Compiling Code using IF structure Using Select Case Using the Immediate Window Using the Toggle Breakpoint Using the Watch Pane Generating Combobox, Checkbox, Msgbox Creating Userforms Creating Custom Menus Creating Custom Toolbars Using Event Procedures Using Looping structure 0 intro Thank you for completing the form, please write below any comments you may have.

Page 5 of 68

0 intro 100 Intermediate 150 Advanced 180 VBA

Page 6 of 68

Training Needs Analysis Microsoft Access

www.mousetraining.com

At MTCTS, we endeavour to treat all delegates in an individual way and therefore ask you to fill in this form so that we are able to put together a course that is most suited to you. For each question you are given the choice of 4 responses labelled A-D. Please choose one response that most accurately describes your knowledge level for each topic. Please note that this is not a test. I have never used it before or do not fully understand the topic. I have the basic understanding of the topic.

A

NO KNOWLEDGE

B C D

BASIC KNOWLEDGE GOOD KNOWLEDGE I understand most of it - there may be gaps COMPLETE KNOWLEDGE I understand it fully - use it often.

User Name: Dept/Section:

Topic

A

B

C

D

NO BASIC GOOD CO MPLETE KNOWLEDG KNOWLEDG KNOWLEDG KNOWLEDG E E E E

Starting a New Database

A

B

C

D

Opening an Existing Database

A

B

C

D

Closing a Database

A

B

C

D

Creating a Table in Design View

A

B

C

D

Defining Field Names and Types

A

B

C

D

Setting a Primary Key

A

B

C

D

Composite Primary Keys

A

B

C

D

Entering Field Properties

A

B

C

D

Adding Input Masks

A

B

C

D

Applying Validation Rules and Text

A

B

C

D

Inserting Additional Fields

A

B

C

D

Deleting Fields

A

B

C

D

Moving Fields

A

B

C

D

Renaming Fields

A

B

C

D

Creating a Table using Table Wizard

A

B

C

D

Switching between Design and Table Views

A

B

C

D

Entering Data into a table

A

B

C

D

Modifying Data in a table

A

B

C

D

Formatting Tables

A

B

C

D

Sorting Data

A

B

C

D

Finding & Replacing Data

A

B

C

D

Page 7 of 68

●

Hiding and Unhiding Fields

A

B

C

D

Freezing Columns

A

B

C

D

Renaming and Copying Tables

A

B

C

D

Importing data from Excel

A

B

C

D

Linking to a different Database Table

A

B

C

D

Creating a Filter by selection

A

B

C

D

Creating a Filter by form

A

B

C

D

Saving a filter by form as a select query

A

B

C

D

Running a Select Query

A

B

C

D

Creating a Query from the Query Window

A

B

C

D

Adding Fields to a query

A

B

C

D

Suppress the display of a field in a query

A

B

C

D

Removing Fields from a query

A

B

C

D

Text, numeric, date, and logic criteria

A

B

C

D

Using Wild Card Characters in a query

A

B

C

D

Working with multiple criterion

A

B

C

D

Using BETWEEN, AND, OR, NOT, NULL, IN

A

B

C

D

Creating Calculated fields in queries

A

B

C

D

Using Simple Query Wizard

A

B

C

D

Creating relationships between tables

A

B

C

D

Applying different types of relationships

A

B

C

D

Applying Referential Integrity

A

B

C

D

Cascading Updates and Deletions

A

B

C

D

Running Multiple Table Queries

A

B

C

D

Joining Tables for a query

A

B

C

D

Using Find Unmatched Query Wizard

A

B

C

D

Using Find Duplicates Query Wizard

A

B

C

D

Generating Advanced Calculated fields

A

B

C

D

Using Parameter Queries

A

B

C

D

Calculating Totals in Queries

A

B

C

D

Using Crosstabs Queries Wizard

A

B

C

D

Using Action Queries

A

B

C

D

Creating Forms using Auto Form

A

B

C

D

Creating Forms Using the Form Wizard

A

B

C

D

Data Entry in Forms

A

B

C

D

Resizing and Moving Controls

A

B

C

D

Formatting Controls

A

B

C

D

Using Format Painter and AutoFormat

A

B

C

D

Changing Text Attributes

A

B

C

D

Inserting Moving Sizing and Deleting Fields

A

B

C

D

Resizing Forms

A

B

C

D

Displaying Properties of an item

A

B

C

D

Creating Sub Forms

A

B

C

D

Page 8 of 68

Setting Form Properties

A

B

C

D

Calculations within Forms

A

B

C

D

Combing Text Values

A

B

C

D

Changing the Data Source of the form

A

B

C

D

Changing the Tab Key Order on the forms

A

B

C

D

Using the Forms Toolbox

A

B

C

D

Generating Standard Reports using Wizard

A

B

C

D

Inserting and Deleting Controls on Reports

A

B

C

D

Customising Reports

A

B

C

D

Using Expressions on Reports

A

B

C

D

Adding Sub Reports

A

B

C

D

Creating Parameter Reports

A

B

C

D

Generating Mailing Labels

A

B

C

D

Creating a Chart

A

B

C

D

Formatting a Chart

A

B

C

D

Changing the type of chart

A

B

C

D

Creating, Editing and Deleting a Macro

A

B

C

D

Running a Macro

A

B

C

D

Macro Action(s)

A

B

C

D

Autokeys

A

B

C

D

Named Column

A

B

C

D

Conditional Macro

A

B

C

D

Generating a Message Box

A

B

C

D

Designing a Switchboard

A

B

C

D

Formatting Switchboard Forms

A

B

C

D

Creating a Splash Screen

A

B

C

D

Using Autoexec

A

B

C

D

Creating a Custom Toolbar

A

B

C

D

Creating a Custom Menu

A

B

C

D

Start-up Menu

A

B

C

D

Sample Subroutine

A

B

C

D

Sample Function

A

B

C

D

Thank you for completing the form, please write below any comments you may have.

Page 9 of 68

Page 10 of 68

Page 11 of 68

Page 12 of 68

Page 13 of 68

Page 14 of 68

Page 15 of 68

Page 16 of 68

Page 17 of 68

Page 18 of 68

Training Needs Analysis Microsoft Project

www.mousetraining.com

At Mouse, we endeavour to treat all delegates in an individual way and therefore ask you to fill in this form so that we are able to put together a course that is most suited to you. For each question you are given the choice of 4 responses labelled A-D. Please choose one response that most accurately describes your knowledge level for each topic. Please note that this is not a test. A B C D

I have never used it before or do not fully understand the topic. BASIC KNOWLEDGE I have the basic understanding of the topic. GOOD KNOWLEDGE I understand most of it - there may be gaps COMPLETE KNOWLEDGE I understand it fully - use it often. NO KNOWLEDGE

User Name: Dept/Section:

Topic

A

B

C

D

NO BASIC GOOD CO MPLETE KNOWLEDG KNOWLEDG KNOWLEDG KNOWLEDG E E E E

Starting a New Project

A

B

C

D

Saving a Project

A

B

C

D

The difference between Save and Save As

A

B

C

D

Opening and Closing Projects

A

B

C

D

Opening Documents

A

B

C

D

Selecting/highlighting text

A

B

C

D

Moving and Copying text

A

B

C

D

Viewing Gantt Chart

A

B

C

D

Navigating a Project Plan

A

B

C

D

Pert Charts/Network Diagrams

A

B

C

D

Resource Graph

A

B

C

D

Viewing Calendar

A

B

C

D

Entering Tasks

A

B

C

D

Entering Milestones

A

B

C

D

Linking Tasks, Finish to Start

A

B

C

D

Linking Tasks, Start to Finish

A

B

C

D

Linking Tasks, Finish to Finish

A

B

C

D

Linking Tasks, Start to Start

A

B

C

D

Unlinking Tasks

A

B

C

D

Applying Hard and Soft Task Constraints

A

B

C

D

Scheduling Project from Start Date

A

B

C

D

Scheduling Project from Finish Date

A

B

C

D

Splitting Large Tasks into Sub Tasks

A

B

C

D

Using Summary Bars

A

B

C

D

Using Lag, Lead and Delay in tasks

A

B

C

D

Applying a Critical Path

A

B

C

D

Entering Slack

A

B

C

D

Creating new Calendars

A

B

C

D

Changing default working Hours & Week

A

B

C

D

Page 19 of 68

Setting Additional Non-Working Days

A

B

C

D

Entering Resources, People, Equipment, etc.

A

B

C

D

Assigning Resources to Tasks

A

B

C

D

Viewing Resource Calendar

A

B

C

D

Resource Levelling

A

B

C

D

Calculating Resource Costs

A

B

C

D

Viewing Cost Rate Table

A

B

C

D

Showing the Project Statistics

A

B

C

D

Setting a Baseline

A

B

C

D

Clearing a Baseline

A

B

C

D

Using the Tracking Gantt

A

B

C

D

Recording Work Done

A

B

C

D

Using the Tracking Toolbar

A

B

C

D

Completing the Project

A

B

C

D

Formatting Timescale, Gridlines

A

B

C

D

Using Text and Bar Styles

A

B

C

D

Applying Templates

A

B

C

D

Inserting Objects, Clipart, Word, etc.

A

B

C

D

Using the Drawing Toolbar

A

B

C

D

Creating Internal Hyperlinks

A

B

C

D

Creating Links to Word Bookmarks

A

B

C

D

Creating Links to Excel Range Names

A

B

C

D

Viewing Hyperlink Table

A

B

C

D

Sorting Data by Priority and Date

A

B

C

D

Using the Autofilter

A

B

C

D

Filtering Tasks

A

B

C

D

Creating Custom Filters

A

B

C

D

Creating Custom Views

A

B

C

D

Adding Columns to Tables

A

B

C

D

Creating Custom Tables

A

B

C

D

Generating Task Usage Report

A

B

C

D

Generating Current Avtivities Report

A

B

C

D

Generating Costs Report

A

B

C

D

Printing Gantt Chart

A

B

C

D

Printing Network Diagram

A

B

C

D

Changing Page Setup

A

B

C

D

Sharing Resources with other projects

A

B

C

D

Inserting Sub-projects

A

B

C

D

Using External Predecessors and Successors

A

B

C

D

Customising Toolbars and Menu bar

A

B

C

D

Creating and Running a Global Macro

A

B

C

D

Creating File Spesific Macros

A

B

C

D

Thank you for completing the form, please write below any comments you may have.

Page 20 of 68

Page 21 of 68

0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Page 22 of 68

0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

Page 23 of 68

Page 24 of 68

Training Needs Analysis Microsoft PowerPoint

www.mousetraining.com

At MTCTS, we endeavour to treat all delegates in an individual way and therefore ask you to fill in this form so that we are able to put together a course that is most suited to you. For each question you are given the choice of 4 responses labelled A-D. Please choose one response that most accurately describes your knowledge level for each topic. Please note that this is not a test. I have never used it before or do not fully understand the topic. I have the basic understanding of the topic.

A

NO KNOWLEDGE

B C D

BASIC KNOWLEDGE GOOD KNOWLEDGE I understand most of it - there may be gaps COMPLETE KNOWLEDGE I understand it fully - use it often.

User Name: Dept/Section:

Topic

A

B

C

D

NO BASIC GOOD CO MPLETE KNOWLEDG KNOWLEDG KNOWLEDG KNOWLEDG E E E E

Starting a New Presentation

A

B

C

D

Saving a Presentation

A

B

C

D

The difference between Save and Save As

A

B

C

D

Closing a Presentation

A

B

C

D

Opening a Presentation

A

B

C

D

Adding New Slides

A

B

C

D

Creating a Title Slide

A

B

C

D

Changing the Slide Layout

A

B

C

D

Entering & Editing Text on slides

A

B

C

D

Selecting Text and Selecting Placeholders

A

B

C

D

Moving and Copying data

A

B

C

D

Changing Text Font Type and Size

A

B

C

D

Formatting Backgrounds

A

B

C

D

Applying Borders and Shading

A

B

C

D

Creating a Bulleted List

A

B

C

D

Formatting Numbered and Bulleted Lists

A

B

C

D

Format Painter

A

B

C

D

Drawing basic Shapes Freehand

A

B

C

D

Creating Auto Shapes

A

B

C

D

Formatting Shapes; Shadows, Fill Effects

A

B

C

D

Copying and Moving objects

A

B

C

D

Page 25 of 68

Working with Guides

A

B

C

D

Working with the Visible Grid

A

B

C

D

Aligning & Distributing Objects

A

B

C

D

Flipping and Rotating

A

B

C

D

Ordering Objects

A

B

C

D

Grouping Objects

A

B

C

D

Inserting & Formatting text within a shape

A

B

C

D

Inserting WordArt

A

B

C

D

Using Connectors to create flow charts

A

B

C

D

Inserting Clip Art

A

B

C

D

Recolouring Clip Art

A

B

C

D

Grouping and Ungrouping Clip Art

A

B

C

D

Inserting an Image from file

A

B

C

D

Rotating Images

A

B

C

D

Inserting a Movie F]ile

A

B

C

D

Creating a Chart

A

B

C

D

Editing the Chart Type

A

B

C

D

Editing the Chart Options

A

B

C

D

Creating a Table

A

B

C

D

Adding Text on a Table

A

B

C

D

Inserting Columns and Rows within tables

A

B

C

D

Enhancing a Table with formatting

A

B

C

D

Creating an Organisational Chart

A

B

C

D

Editing an Organisational Chart

A

B

C

D

Linking Data from Word and Excel

A

B

C

D

Switching between Views

A

B

C

D

View in Black and White

A

B

C

D

Viewing Slide Miniature

A

B

C

D

Creating a Summary Slide

A

B

C

D

Using Slide Sorter View

A

B

C

D

Using Notes Pages View

A

B

C

D

Using Outline View to enter text

A

B

C

D

Deleting Slides

A

B

C

D

Moving and Copying Slides

A

B

C

D

Slide Show View

A

B

C

D

Transition Effects

A

B

C

D

Building Bullet Points

A

B

C

D

Animating a Chart

A

B

C

D

Previewing Animations

A

B

C

D

Genetaring Custom Animations

A

B

C

D

Animating Multiple Objects simultaneously

A

B

C

D

Rehearsing the timing of a Presentation

A

B

C

D

Adding Controls to use during slide shows

A

B

C

D

Page 26 of 68

Hiding Slides

A

B

C

D

Adding Hyperlinks to a presentation

A

B

C

D

Creating Action Buttons

A

B

C

D

Creating a custom Show

A

B

C

D

Spell Check

A

B

C

D

Print Preview

A

B

C

D

Printing Notes

A

B

C

D

Printing Handouts

A

B

C

D

Printing Outline View

A

B

C

D

Sending Slides to Word to Create Handouts

A

B

C

D

Publishing to the Web

A

B

C

D

Pack and Go

A

B

C

D

Viewing the Slide Master

A

B

C

D

Adding a company logo to every slide

A

B

C

D

Formatting the Background

A

B

C

D

Creating Colour Schemes

A

B

C

D

Formatting Title Area and Object Area

A

B

C

D

Adding Headers & Footers

A

B

C

D

Viewing and Editing the Title Master

A

B

C

D

Applying Design Templates

A

B

C

D

Creating your own design Template

A

B

C

D

Applying your own design Template

A

B

C

D

Change the settings of the default design

A

B

C

D

Thank you for completing the form, please write below any comments you may have.

Page 27 of 68

Page 28 of 68

Page 29 of 68

Page 30 of 68

0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

Page 31 of 68

0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Page 32 of 68

0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

Page 33 of 68

Training Needs Analysis Microsoft Word At MTCTS we endeavour to treat all delegates in an individual way and therefore ask you to fill in this form so that we are able to put together a course that is most suited to you. For each question you are given the choice of 4 responses labelled A-D. Please choose one response that most accurately describes your knowledge level for each topic. Please note that this is not a test. I have never used it before or do not fully understand the topic. I have the basic understanding of the topic.

A

NO KNOWLEDGE

B C D

BASIC KNOWLEDGE GOOD KNOWLEDGE I understand most of it - there may be gaps COMPLETE KNOWLEDGE I understand it fully - use it often.

User Name: Dept/Section:

Topic

A

B

C

D

NO BASIC GOOD CO MPLETE KNOWLEDG KNOWLEDG KNOWLEDG KNOWLEDG E E E E

Starting New Documents

A

B

C

D

Saving a File

A

B

C

D

The difference between Save and Save As

A

B

C

D

Closing Documents

A

B

C

D

Opening Documents

A

B

C

D

Selecting/highlighting text

A

B

C

D

Moving and Copying text

A

B

C

D

Changing Font Type and Size

A

B

C

D

Changing Text Alignment

A

B

C

D

Indenting Paragraphs

A

B

C

D

Changing Line Spacing in the paragraphs

A

B

C

D

Changing Spacing between paragraphs

A

B

C

D

Applying Borders

A

B

C

D

Creating Bulleted and Numbered List

A

B

C

D

Using Format Painter

A

B

C

D

Revealing Formats

A

B

C

D

Clearing Formats

A

B

C

D

Spell Checking

A

B

C

D

Finding and Replacing text

A

B

C

D

Printing Documents

A

B

C

D

Changing Margins

A

B

C

D

Page 34 of 68

Adding Headers and Footers

A

B

C

D

Changing Page Orientation

A

B

C

D

Page Numbering

A

B

C

D

Inserting Page Breaks

A

B

C

D

Inserting Section Breaks

A

B

C

D

Setting your own Tabs

A

B

C

D

Setting Leader Tabs

A

B

C

D

Inserting a Table

A

B

C

D

Changing Column Widths and Row Heights

A

B

C

D

Inserting New Columns and Rows

A

B

C

D

Merging and Splitting Cells

A

B

C

D

Distributing Columns and Rows evenly

A

B

C

D

Using Autocorrect

A

B

C

D

Creating your own Autocorrect entries

A

B

C

D

Saving the selected text as Autotext

A

B

C

D

Creating Styles, i.e. Heading 1, Normal

A

B

C

D

Applying Styles

A

B

C

D

Heading Numbering Using Styles

A

B

C

D

Using the Style Organizer

A

B

C

D

Inserting Picture Files

A

B

C

D

Using Drawing Tools

A

B

C

D

Document Map

A

B

C

D

Structuring Documents using Outline view

A

B

C

D

Promoting and Demoting Levels

A

B

C

D

Creating and Modifying a Template

A

B

C

D

Creating a Layout for Forms

A

B

C

D

Using Text, Checkbox and Dropdown fields

A

B

C

D

Generating Table of Contents

A

B

C

D

Generating an Index

A

B

C

D

Creating Bookmarks

A

B

C

D

Creating letters using Mail Merge

A

B

C

D

Creating Labels

A

B

C

D

Comparing and Merging documents

A

B

C

D

Tracking Changes

A

B

C

D

Recording a Macro

A

B

C

D

Running Macros

A

B

C

D

Thank you for completing the form, please write below any comments you may have.

Page 35 of 68

Page 36 of 68

### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ###

Page 37 of 68

### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ###

Page 38 of 68

Page 39 of 68

Page 40 of 68

Page 41 of 68

Page 42 of 68

Training Needs Analysis Microsoft Outlook

www.mousetraining.com

At MTC, we endeavour to treat all delegates in an individual way and therefore ask you to fill in this form so that we are able to put together a course that is most suited to you. For each question you are given the choice of 4 responses labelled A-D. Please choose one response that most accurately describes your knowledge level for each topic. Please note that this is not a test. A B C D

I have never used it before or do not fully understand the NO KNOWLEDGE topic. BASIC KNOWLEDGE I have the basic understanding of the topic. GOOD KNOWLEDGE I understand most of it - there may be gaps COMPLETE KNOWLEDGE I understand it fully - use it often.

User Name: Dept/Section:

Topic

A

B

C

D

NO BASIC GOOD CO MPLE TE KNOWLEDG KNOWLE DG KNOWLEDG KNOWLEDG E E E E

Starting Outlook Exiting Outlook Identifing Outlook Bar & Folder List Starting a New Mail Message Addressing the message Using To, Cc and Bcc Address Fields Composing and Formatting Message Text Spellchecking Message Text Sending Messages Reading Messages Using the Preview Pane Replying, Forwarding Messages Inserting File Attachments Processing Attachments received Setting Importance and Sensitivity on messages Asking for a Return and Delivery Receipts Having Replies Sent to Somebody Else Setting an Expiry Date Setting up Voting Butons on messages Flagging Messages for follow up Deleting Messages Accessing Global Address List Accessing your Contacts List Adding a New Contact

●

Emailing a Contact Creating a Distribution List Modifiying and Deleting your Contacts Adding your V card to outgoing messages Sorting and Finding messages Using Quick and Advanced Find Using Out of Office Assistant Creating an Autosignature Categorising Messages Filtering Messages Creating Folders and Sub Folders Moving messages into folders Setting up Rules to automate repetitive tasks Creating Automatic Rules with Organize Creating a new Outlook bar group Adding Shortcuts to the Outlook bar Setting up Auto Archiving Viewing and Navigating in Calendar Entering Appointments Setting Alarms Customizing Calendar view Entering Recurring Appointments Entering Events Adding Holidays Checking other's availability for a meeting Scheduling Meetings with others Printing your Calendar Sharing your Calendar with Others Connecting to someone else's calendar Sharing your Inbox and other folders Giving Delegate Permissions Sending Mail as a Delegate Viewing Task List Entering Tasks Entering Recurring Tasks Delegating Tasks to others Entering and Editing Sticky Notes Recoloring Notes Sending Notes to Others Saving Notes onto your desktop Setting Journal Options Tracking work done on documents via Journal Adding a Journal Entry Thank you for completing the form, please write below any comments you may have.

Page 43 of 68

0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

Page 44 of 68

Training Needs Analysis Microsoft Visio

www.mousetraining.com

At Mouse, we endeavour to treat all delegates in an individual way and therefore ask you to fill in this form so that we are able to put together a course that is most suited to you. For each question you are given the choice of 4 responses labelled A-D. Please choose one response that most accurately describes your knowledge level for each topic. Please note that this is not a test. A B C D

I have never used it before or do not fully understand the topic. BASIC KNOWLEDGE I have the basic understanding of the topic. GOOD KNOWLEDGE I understand most of it - there may be gaps COMPLETE KNOWLEDGE I understand it fully - use it often. NO KNOWLEDGE

User Name: Dept/Section:

Topic

A

B

C

D

NO BASIC GOOD CO MPLETE KNOWLEDG KNOWLEDG KNOWLEDG KNOWLEDG E E E E

Starting a New Visio file

A

B

C

D

Saving a Visio file

A

B

C

D

The difference between Save and Save As

A

B

C

D

Opening and Closing Visio files

A

B

C

D

Magnification Settings

A

B

C

D

Opening Additional Stencils

A

B

C

D

Using the mouse Menu

A

B

C

D

Working with the Drawing Tools

A

B

C

D

Drawing with Precision Tools

A

B

C

D

Using Selection Techniques

A

B

C

D

Scaling and Resizing Objects

A

B

C

D

Duplicating Objects Quickly

A

B

C

D

Aligning Objects

A

B

C

D

Distributing Objects

A

B

C

D

Quick Analysis of Connected Drawings

A

B

C

D

Work with Grouped Shapes

A

B

C

D

Rotating Objects

A

B

C

D

Flowcharting Tips

A

B

C

D

Understanding Master Shapes

A

B

C

D

Placing Shapes

A

B

C

D

Connecting Shapes

A

B

C

D

Creating a Universal Connector

A

B

C

D

Adding Text To Shapes

A

B

C

D

Adjusting Text Blocks

A

B

C

D

Enhancing Drawing Elements

A

B

C

D

Formatting Text

A

B

C

D

Formatting Text Blocks

A

B

C

D

Drawing tools

Using Flow Charts

Basic Text Features

Page 45 of 68

Visio

Formatting Shape Fills

A

B

C

D

Formatting Lines

A

B

C

D

Creating a Workspace File

A

B

C

D

Replacing Shapes

A

B

C

D

Starting a New File

A

B

C

D

Creating Background Pages

A

B

C

D

Adding Fields

A

B

C

D

Importing Graphics

A

B

C

D

Applying Background Pages

A

B

C

D

Setting Snap and Glue Options

A

B

C

D

Using Typology Shapes

A

B

C

D

Printing Your Diagrams

A

B

C

D

Using Guides

A

B

C

D

Customizing Shapes

A

B

C

D

Adding Shape Data

A

B

C

D

Generating Property Data Reports

A

B

C

D

Linking Pages

A

B

C

D

Linking to Other Files

A

B

C

D

Creating Custom stencils

A

B

C

D

Creating a Custom Master Shape

A

B

C

D

Adding the Shapes

A

B

C

D

Creating Styles

A

B

C

D

Creating a Single Element Style

A

B

C

D

Creating a Template File

A

B

C

D

Thank you for completing the form, please write below any comments you may have.

Page 46 of 68

Page 47 of 68

Page 48 of 68

Training Needs Analysis Microsoft Frontpage

www.mousetraining.com

At Mouse, we endeavour to treat all delegates in an individual way and therefore ask you to fill in this form so that we are able to put together a course that is most suited to you. For each question you are given the choice of 4 responses labelled A-D. Please choose one response that most accurately describes your knowledge level for each topic. Please note that this is not a test. I have never used it before or do not fully understand the topic. I have the basic understanding of the topic.

A

NO KNOWLEDGE

B C D

BASIC KNOWLEDGE GOOD KNOWLEDGE I understand most of it - there may be gaps COMPLETE KNOWLEDGE I understand it fully - use it often.

User Name: Dept/Section:

Topic

A

B

C

D

NO BASIC GOOD CO MPLETE KNOWLEDG KNOWLEDG KNOWLEDG KNOWLEDG E E E E

Starting a new One Page Web

A

B

C

D

Choosing Location and Naming Web

A

B

C

D

Adding New Pages

A

B

C

D

Saving New Pages

A

B

C

D

Importing Pages

A

B

C

D

Using the Folder List

A

B

C

D

Creating and Deleting Folders

A

B

C

D

Moving Pages to Folders

A

B

C

D

Entering, Editing and Deleting text

A

B

C

D

Moving and Copying text

A

B

C

D

Using Line Breaks

A

B

C

D

Inserting Dates and Times

A

B

C

D

Using the Spell Checker and Thesaurus

A

B

C

D

Finding and Replacing Text

A

B

C

D

Formatting the Font

A

B

C

D

Changing Character Spacings and Positions

A

B

C

D

Removing Font Formats

A

B

C

D

Inserting Special Text Characters

A

B

C

D

Changing Alignments

A

B

C

D

Using Indentations

A

B

C

D

Applying Paragraph Spacing

A

B

C

D

Page 49 of 68

Applying Borders and Shading

A

B

C

D

Creating Lists using Bullets and Numbers

A

B

C

D

Changing Bullets and Number Styles

A

B

C

D

Using Images as bullets

A

B

C

D

Inserting and Formatting a Horizontal Line

A

B

C

D

Inserting Clipart

A

B

C

D

Saving Pages with Images

A

B

C

D

Moving, Resizing and Deleting Images

A

B

C

D

Changing the Image Position

A

B

C

D

Applying Text Wrapping around images

A

B

C

D

Changing Picture File Format

A

B

C

D

Changing Image Borders, Colours, Alignments

A

B

C

D

Flipping and Rotating Images

A

B

C

D

Changing the Contrast and Brightness

A

B

C

D

Cropping Images

A

B

C

D

Changing the Page Title

A

B

C

D

Changing Page Background Colour

A

B

C

D

Using Images as a Background

A

B

C

D

Changing the Margins

A

B

C

D

Using Page Set-up

A

B

C

D

Using Page Transitions

A

B

C

D

Using the Preview Tab

A

B

C

D

Previewing in Browser

A

B

C

D

Creating Hyperlinks to Other Pages

A

B

C

D

Removing Hyperlinks

A

B

C

D

Creating Email Hyperlinks

A

B

C

D

Creating Hyperlinks to External Websites

A

B

C

D

Creating Bookmarks

A

B

C

D

Creating Hyperlinks to Bookmarks

A

B

C

D

Changing Default Hyperlink Colours

A

B

C

D

Using Images as Hyperlinks

A

B

C

D

Using Hotspots on images to create hyperlinks

A

B

C

D

Using the Hyperlinks View

A

B

C

D

Inserting Tables

A

B

C

D

Inserting and Deleting Rows and Columns

A

B

C

D

Changing Row Heights and Column Widths

A

B

C

D

Distributing Rows and Columns Evenly

A

B

C

D

Splitting and Merging Cells

A

B

C

D

Applying Borders and Shading

A

B

C

D

Converting Tables to Text, Text to Tables

A

B

C

D

Drawing Tables

A

B

C

D

Creating New Pages using Frames

A

B

C

D

Adding and Removing Frames

A

B

C

D

Page 50 of 68

Creating new pages for frames

A

B

C

D

Changing hyperlink targets to frames or pages

A

B

C

D

Changing Margins

A

B

C

D

Adding a Page Border

A

B

C

D

Working with Frame Properties

A

B

C

D

Inserting a Standard Navigation Bar

A

B

C

D

Changing Navigation Bar Properties

A

B

C

D

Removing Navigation bar

A

B

C

D

Setting Web Shared Borders

A

B

C

D

Setting Page Only Shared Borders

A

B

C

D

Using Shared Borders

A

B

C

D

Removing Shared Borders

A

B

C

D

Creating and Updating a Table of Contents

A

B

C

D

Creating a Online form

A

B

C

D

Inserting Form Components

A

B

C

D

Sending Results to text file or email

A

B

C

D

Changing the text results name

A

B

C

D

Adding Subject and Address

A

B

C

D

Adding a Confirmation Page

A

B

C

D

Creating Custom Confirmation Page

A

B

C

D

Choosing additional fields to save to results

A

B

C

D

Creating Forms within tables for alignment

A

B

C

D

Using the Form Wizard

A

B

C

D

Using the Discussion Group Wizard

A

B

C

D

Deleting Material from the discussion

A

B

C

D

Inserting a Marquee

A

B

C

D

Inserting Banner Adds

A

B

C

D

Inserting Hit Counters

A

B

C

D

Adding Hover Buttons

A

B

C

D

Creating Search Forms

A

B

C

D

Inserting Charts, Pivot Tables, Spreadsheets

A

B

C

D

Applying Themes to pages or all documents

A

B

C

D

Removing Themes

A

B

C

D

Checking Broken Links

A

B

C

D

Recalculating Links

A

B

C

D

Creating Personal Tasks

A

B

C

D

Viewing Tasklists

A

B

C

D

Editing Tasks

A

B

C

D

Marking Tasks as Complete

A

B

C

D

Publishing your FrontPage Web to a Webserver

A

B

C

D

Updating your FrontPage Web

A

B

C

D

Choosing a location for your Web site

A

B

C

D

Choosing Files to Publish

A

B

C

D

Page 51 of 68

Marking the Pages to Publish

A

B

C

D

Viewing the Publishing Status of Files

A

B

C

D

Publishing to HTTP, FTP, or a File System

A

B

C

D

Adding or Changing an FTP Location

A

B

C

D

Deleting a File or Folder that has been published

A

B

C

D

Applying Predefined Styles

A

B

C

D

Creating your own Style

A

B

C

D

Modifying Existing Styles

A

B

C

D

Cascading Style Sheets

A

B

C

D

Adding Active X Components

A

B

C

D

Adding HTML, VBScripts or Java Applets

A

B

C

D

Thank you for completing the form, please write below any comments you may have.

Page 52 of 68

Page 53 of 68

Page 54 of 68

Page 55 of 68

Page 56 of 68

0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

Page 57 of 68

0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Page 58 of 68

0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Page 59 of 68

0 0 0 0 0 0 0 0 0

Page 60 of 68

Training Needs Analysis Microsoft Publisher

www.mousetraining.com

At MTCTS we endeavour to treat all delegates in an individual way and therefore ask you to fill in this form so that we are able to put together a course that is most suited to you. For each question you are given the choice of 4 responses labelled A-D. Please choose one response that most accurately describes your knowledge level for each topic. Please note that this is not a test. I have never used it before or do not fully understand the topic. I have the basic understanding of the topic.

A

NO KNOWLEDGE

B C D

BASIC KNOWLEDGE GOOD KNOWLEDGE I understand most of it - there may be gaps COMPLETE KNOWLEDGE I understand it fully - use it often.

User Name: Dept/Section:

Topic

A

B

C

D

NO BASIC GOOD CO MPLETE KNOWLEDG KNOWLEDG KNOWLEDG KNOWLEDG E E E E

About Microsoft Publisher

A

B

C

D

Publisher screen

A

B

C

D

Creating publications using the wizard

A

B

C

D

Designing and creating your own publications

A

B

C

D

Designing business cards, flyers,brochures and cards A

B

C

D

Formatting publications

A

B

C

D

Saving publications

A

B

C

D

Using WordArt

A

B

C

D

Working with the drawing tools

A

B

C

D

Inserting pictures

A

B

C

D

Layering text and objects

A

B

C

D

Using the drop cap facility

A

B

C

D

Moving and resizing objects

A

B

C

D

Design gallery objects

A

B

C

D

Importing text from other applications

A

B

C

D

Creating tables

A

B

C

D

creating web pages

A

B

C

D

saving publications

A

B

C

D

Page 61 of 68

Page 62 of 68

Page 63 of 68

Page 64 of 68

Page 65 of 68

Page 66 of 68

Page 67 of 68

Page 68 of 68