Access Basics 1: Creating a Database
Microsoft Access allows you to create databases to store information and data so that it can be conveniantly retreived and analysed.
In this course you will plan and create a simple, one table database using Access 2003.
This course introduces you to:
- planning a database
- creating a database
- creating tables
- defining data types, a primary key and data entry
- entering data and forms
- retrieving data and the Report Wizard
- simple queries.
Assumes good PC skills, no previous experience using Access is required.
Limit: 12.
We offer these dates:
Thursday 24 August
9am-12.30pm
Multimedia Suite, Mezzanine Level, Rutherford House, 23 Lambton Quay, VUW — Pipitea Campus
Fee: $165 (excl. GST)
Course 06769
or
Wednesday 15 November
1.30-5pm
Multimedia Suite, Mezzanine Level, Rutherford House, 23 Lambton Quay, VUW — Pipitea Campus
Fee: $165 (excl. GST)
Course 06770
enrol | top
Access Basics 2: Queries and Relationships
This follow-up course builds on Access Basics 1 by looking at multiple-table, databases.
In this course you will learn how to integrate the database components: tables, queries, forms and reports, and develop the skills to build an efficient user interface. The result is a database which is easy for anyone to use.
Topics covered introduce you to:
- defining relationships between tables
- maintaining referential integrity between tables
- creating tables from query results
- using macros to perform multi-part operations
- using forms to activate macros
- designing queries to alter database content.
Assumes basic Access skills, as provided by Access Basics 1 or equivlalent knowledge.
Limit: 12.
We offer these dates:
Thursday 14 September
9am-12.30pm
Multimedia Suite, Mezzanine Level, Rutherford House, 23 Lambton Quay, VUW — Pipitea Campus
Fee: $165 (excl. GST)
Course 06773
or
Wednesday 29 November
1.30-5pm
Multimedia Suite, Mezzanine Level, Rutherford House, 23 Lambton Quay, VUW — Pipitea Campus
Fee: $165 (excl. GST)
Course 06774
enrol | top
Endnote: Managing Your References
Researching? Then your references need to be instantly accessible, searchable
and in a usable format. Endnote (version 8) is a powerful and versatile
research tool that enables you to create, manage and utilise your own reference
database.
This practical introductory course is intended for researchers, librarians,
teachers and everyone who is using reference materials.
The course covers:
- creating an Endnote library
- using an Endnote library to reference a paper
- applying styles to references
- generating a bibliography
- creating formatted reading lists.
Assumes experience in using Microsoft Word.
Limit: 12.
We offer these dates:
Wednesday 2 August
1.30-5pm
Multimedia Suite, Mezzanine Level, Rutherford House, 23 Lambton Quay, VUW — Pipitea Campus
Fee: $165 (excl. GST)
Course 06731
or
Thursday 5 October
9am-12.30pm
Multimedia Suite, Mezzanine Level, Rutherford House, 23 Lambton Quay, VUW — Pipitea Campus
Fee: $165 (excl. GST)
Course 06732
enrol | top
Excel
Smartskills
Are you using Excel but want to know more? This course gives you the opportunity
to fill gaps in your knowledge quickly so that you can manage data more effectively.
Come with your questions and learn tips and tricks to work efficiently
in with Microsoft Excel 2003.
Topics covered include:
- sorting, filtering and managing data
- creating and using formulae
- sharing and protecting your data
Assumes a basic knowledge of Microsoft Excel, as provided by Excel
Start or equivalent.
Limit per course: 12.
We offer these dates:
Monday 10 July
1.30-5pm
Multimedia Suite, Mezzanine Level, Rutherford House, 23 Lambton Quay, VUW — Pipitea Campus
Fee: $165 (excl. GST)
Course 06736
or
Thursday 31 August
1.30-5pm
Multimedia Suite, Mezzanine Level, Rutherford House, 23 Lambton Quay, VUW — Pipitea Campus
Fee: $165 (excl. GST)
Course 06737
enrol | top
Excel
Start
Never worked with Excel? Maybe you've tried but been put-off by its unfamilar appearance, or frustrated trying to use it.
This course demystifies Excel while introducing you to data inputting and editing, and simple formulae and spreadsheet formatting. You will learn the fundmental skills to manage and present your data more efficiently and professionally.
Topics include:
- creating a new workbook
- entering and editing data
- layout and working with columns and row
- formatting spreadsheets
- using simple formulae
- using fill.
Assumes basic PC skills, no previous experience using Excel is required.
Limit per course: 12.
We offer these dates:
Wednesday 5 July
1.30-5pm
Multimedia Suite, Mezzanine Level, Rutherford House, 23 Lambton Quay, VUW — Pipitea Campus
Fee: $165 (excl. GST)
Course 06742
or
Thursday 14 September
1.30-5pm
Multimedia Suite, Mezzanine Level, Rutherford House, 23 Lambton Quay, VUW — Pipitea Campus
Fee: $165 (excl. GST)
Course 06743
enrol | top
Freehand Basics
Macromedia Freehand is industry standard software used for graphic design for print or on the web. It can be used to create flyers, pamphlets and other publications. Freehand can also to create graphics, for example, logos and other company branding.
This course introduces you to Freehand and it’s features.
Topics include:
- getting started
- creating a new document
- editing an existing document
- working with text
- creating simple drawings
- making the finishing touches for publication.
No previous knowledge of Freehand is required.
Limit per course: 12.
Debby Murphy is a graphic designer,
e-Learning web developer and IT trainer at Victoria University College of Education.
We offer these dates:
Thursday 13 July
9am-1pm
Multimedia Suite, Mezzanine Level, Rutherford House, 23 Lambton Quay, VUW — Pipitea Campus
Fee: $195 (excl. GST)
Course 06726
or
Thursday 19 October
9am-1pm
Multimedia Suite, Mezzanine Level, Rutherford House, 23 Lambton Quay, VUW — Pipitea Campus
Fee: $195 (excl. GST)
Course 06727
enrol | top
NVivo Basics 1: Working with Data and Basic Analysis
Researchers require an efficient tool to manage and analyse qualitative data, and explore complex ideas with ease.
NVivo 7 is the very latest in qualitative data analysis software by QSR International, and combines their two previously popular packages, NUD*IST 6 (N6) and NVivo 2. NVivo can be tailored to suit your personal working style and methodology, whether you are a public or private sector researcher or an academic.
This introductory course covers:
- the NVivo 7 interface
- working with projects
- preparing and working with data (sources)
- node types and uses
- creating and working with nodes
- viewing coding and context
- working with memos
- reporting
- basic searching.
Competence in using Windows is assumed. It is strongly recommended that participants also enrol in NVivo Basics 2: Extending Analysis Features. 15% discount when enrolling on both NVivo Basics 1 and NVivo Basics 2
Lyn Lavery is an experienced researcher and software trainer, and the Director of Academic Consulting.
Wednesday 16 Aug
9.30am-4.30pm
Multimedia Suite, Mezzanine Level, Rutherford House, 23 Lambton Quay, VUW — Pipitea Campus
Fee: $495 (excl. GST)
Course 06273
or
Monday 4 December
9.30am-4.30pm
Multimedia Suite, Mezzanine Level, Rutherford House, 23 Lambton Quay, VUW — Pipitea Campus
Fee: $495 (excl. GST)
Course 06284
enrol | top
NVivo Basics 2: Extending Analysis Functions
This follow-up course builds on the basic functions learnt in NVivo Basics 1.
The interactive workshop looks at the additional NVivo 7 tools available and discusses the various means of extending and simplifying NVivo qualitative analyses. 15% discount when enrolling on both NVivo Basics 1 and NVivo Basics 2.
This course covers:
- coding extensions (auto-coding and relationships)
- internal and external linking
- attributes and sets
- working with models
- complex searching.
NVivo Basics 1 or equivalent knowledge is a pre-requisite for this course.
Lyn Lavery is an experienced researcher and software trainer, and the Director of Academic Consulting.
Wednesday 30 Aug
9.30am-4.30pm
Multimedia Suite, Mezzanine Level, Rutherford House, 23 Lambton Quay, VUW — Pipitea Campus
Fee: $495 (excl. GST)
Course 06274
or
Tuesday 5 December
9.30am-4.30pm
Multimedia Suite, Mezzanine Level, Rutherford House, 23 Lambton Quay, VUW — Pipitea Campus
Fee: $495 (excl. GST)
Course 06285
enrol | top
Outlook:
An Organising Tool
Outlook 2003 is not just for email. It can help you
organise your working day by scheduling meetings and setting up
appointments, as well as handling messages, tasks, contacts and
notes.
Explore Microsoft Outlook 2003's more advanced features and get tips for working more effectively.
The course covers:
- using advanced message and mailbox features
- managing calendars, appointments and scheduling
- working with tasks, contacts and notes
- integrating the above features to save time
and work.
This course assumes you already use Outlook to
send and receive emails, and that your organisation uses an exchange
server.
Limit per course: 12.
This course is currently offered to staff at Victoria
University.
Click here for more information.
enrol | top
PowerPoint
Polish: Projecting Your Professionalism
Do you have basic Microsoft PowerPoint 2003 skills but want to produce smarter,
more professional-looking presentations?
Learn essential design and PowerPoint 2003 skills to communicate with
clarity and professional flair, then put your skills into practice
through creating your own presentation.
Topics include:
- creating a master slide
- creating and editing content to convey a message clearly
- professional use of font and colour
- integrating illustrations, graphs and multimedia
- generating handouts and speaker notes.
Assumes a basic level of PowerPoint skills, as provided by Powerpoint Start or equivalent.
Limit per course: 12.
We offer these dates:
Thursday 29 June
1.30-5pm
Multimedia Suite, Mezzanine Level, Rutherford House, 23 Lambton Quay, VUW — Pipitea Campus
Fee: $165 (excl. GST)
Course 06749
or
Wednesday 13 September
9am-12.30pm
Multimedia Suite, Mezzanine Level, Rutherford House, 23 Lambton Quay, VUW — Pipitea Campus
Fee: $165 (excl. GST)
Course 06750
enrol | top
PowerPoint
Start
Powerpoint helps you to simply create professional presentations; it's fun and it's easy to use.
This quick introductory course gives you hands-on experience in working with PowerPoint. At the end of the course you will have designed and created your own presentation.
Topics include:
- creating a new presentation
- adding text and new slides
- formatting text, background colours and pictures
- intergrating images, graphics and multimedia
- drawing objects and organisational charts
- preparing your slide show for viewing.
Assumes basic PC skills. No previous experience using PowerPoint is required.
Limit per course: 12.
We offer these dates:
Thursday 3 August
1.30-5pm
Multimedia Suite, Mezzanine Level, Rutherford House, 23 Lambton Quay, VUW — Pipitea Campus
Fee: $165 (excl. GST)
Course 06754
or
Thursday 12 October
9am-12.30pm
Multimedia Suite, Mezzanine Level, Rutherford House, 23 Lambton Quay, VUW — Pipitea Campus
Fee: $165 (excl. GST)
Course 06755
enrol | top
SPSS Basics
SPSS provides a powerful system for the management, statistical analysis and presentation of data.
This interactive workshop introduces the basic functions of SPSS and teaches the skills necessary to perform a variety of statistical functions.
This course covers:
- navigating around the SPSS software
- creating a new data set and entering data
- importing data eg from MS Excel
- defining variable properties including value labels and missing value codes
- data transformations eg compute and recode variables
- calculating descriptive statistics and other statistical procedures
- creating tables, charts and graphs
- manipulating SPSS output files (including exporting to other software)
- SPSS Help functions eg. Results Coach and Statistics Coach
- basic SPSS syntax.
This course is suitable for analysts and researchers with a working knowledge of statistical concepts. Competence in using Windows and basic Microsoft Excel skills are assumed.
Lyn Lavery is an experienced researcher and software trainer, and the Director of Academic Consulting.
We offer this date:
Tuesday 29 August
9.30am-4.30pm
Multimedia Suite, Mezzanine Level, Rutherford House, 23 Lambton Quay, VUW — Pipitea Campus
Fee: $495 (excl. GST)
Course 06276
enrol | top
Windows
Smartskills
Get your PC under control: learn how to organise this essential
tool so you can work more efficiently and enjoyably. This workshop will
help you use Microsoft Windows XP more effectively by providing answers
to common queries and frustrations and exploring useful tips and tricks.
Come with your own set of questions.
Topics covered include:
- file management with Windows Explorer
- useful shortcuts and function keys
- working with multiple windows open
- transferring content between files and applications
- personalising your desktop
- toolbars and menus
- what right-clicks can do for you.
The workshop will give you the opportunity to solve many of
your own Windows problems and gaps.
Limit per course: 12.
We offer this date:
Thursday 21 September
1.30-5pm
Multimedia Suite, Mezzanine Level, Rutherford House, 23 Lambton Quay, VUW — Pipitea Campus
Fee: $165 (excl. GST)
Course 06758
enrol | top
Word
Smartskills
Are you fed up with Word pre-empting your moves?
Or just want to more about Word's features and tools for working better? Learn how to take control of your documents.
This course provides answers to common queries. Learn to customise Microsoft Word 2003 to produce professional-looking work. Come with your questions and troublesome documents.
Topics include:
- customising Word, eg by changing page size, measurement units or viewing options, or by using the zoom and autocorrect features
- useful tools, eg 'Show All' and 'Find and Replace'
- creating and using templates
- formatting paragraphs and numbered lists
- creating, modifying and using styles.
It is assumed that you can create, open
and save documents in Word as well as carry out basic editing
and formatting of text.
Limit per course: 12.
We offer these dates:
Thursday 20 July
9am-12.30pm
Multimedia Suite, Mezzanine Level, Rutherford House, 23 Lambton Quay, VUW — Pipitea Campus
Fee: $165 (excl. GST)
Course 06760
or
Thursday 19 October
1.30-5pm
Multimedia Suite, Mezzanine Level, Rutherford House, 23 Lambton Quay, VUW — Pipitea Campus
Fee: $165 (excl. GST)
Course 06761
enrol | top
Word
Wise: Formatting Long Documents
If you are using Microsoft Word to write a report, manual,
thesis or paper and are frustrated by formatting, numbering, creating
footnotes and generating a contents page, this is the course for
you.
The course covers:
- using styles and heading numbering
- working with captions, footnotes, endnotes
and cross-referencing
- utilising sections, headers and footers,
and page numbering
- generating tables of contents, tables of
figures, and indexes.
Bring your own long document, or use a supplied
model, and quickly master and apply the essential skills required
to efficiently produce professional documents.
This course assumes you have basic Word skills.
Limit per course: 12.
We offer these dates:
Thursday 6 July
9am-12.30pm
Multimedia Suite, Mezzanine Level, Rutherford House, 23 Lambton Quay, VUW — Pipitea Campus
Fee: $165 (excl. GST)
Course 06764
or
Thursday 28 September
9am-12.30pm
Multimedia Suite, Mezzanine Level, Rutherford House, 23 Lambton Quay, VUW — Pipitea Campus
Fee: $165 (excl. GST)
Course 06765
or
Monday 13 November
1.30-5pm
Multimedia Suite, Mezzanine Level, Rutherford House, 23 Lambton Quay, VUW — Pipitea Campus
Fee: $165 (excl. GST)
Course 06766
enrol | top
|
