Sunday, March 2, 2008

Workshop - Week Two - 3rd March 2008

~Office Applications~
Lecture

Common PC tasks include:
· File handling – Windows Explorer
· Word processing – Ms Word
· Spread sheets – Ms Excel
· Presentations – Ms PowerPoint
· Internet access – Internet Explorer
· Email access – Outlook/Outlook Express
· Viewing PDF’s- Adobe Acrobat Reader

In using the computer and performing the required tasks, require specific knowledge and skills about the program you are using

· General skills that apply to use most PC applications
· Knowledge regarding which applications suit specific tasks
· Knowledge of how to perform specific tasks within a specific application

File management- using Microsoft Explorer
· Understanding files and folder structure
· ZIP technologies and file compression
· Name conventions
· Windows commands
· Send to, rename
· Move, copy, delete, undo etc

Word processing- using Microsoft Word
· Formatting and styles
· Document mapping
· Working with templates
· Inserting images
· Inserting and formatting tables and other objects
· Not just typing
· Document management
· Assignment presentation
· Working with templates
· Understanding shortcuts
· Toolbar manipulations
· Use of macro technology

Creating spread sheets – using Microsoft Excel
· Formatting and styles
· Columns and rows record keeping
· Data type (currency, text, numbers etc)
· Formulae & functions (Sum, Average etc)
· Multiple record keeping
· Graphs and charts (representation of records)

Creating Presentations – using Microsoft PowerPoint
· Formatting and styles
· Wise use of animation and PowerPoint features
· Using graphics to support a presentation it not rule it
· Note view
· RULES OF PRESENTATION
· Message first (PPT a support tool)

Internet browsing – using Internet Explorer
· Net navigations and hyperlinks
· Bookmarks/favourites
· Search engines
· Information authentication & validation skills

Browser stats – January 2008
Internet Explorer – 37.2%
The Mozilla Suite – 1.3% (Gecko and Netscape)
Safari – 1.9% (Konqueror)
Opcca-1.4%

Sending & receiving emails – using outlook/outlook express
· Email protocols
· Reply, forward, CC, BCC
· Email security
· Spam, attachments and viruses
· Email etiquette
· FWD’s, CC’s, privacy

Viewing PDF’s – using Adobe Acrobat Reader
· Downloading and updating the acrobat reader
· Browser integration
· Viewing PDF’s online
· Choosing zoom level
· Using viewing and note taking tools
· Bookmarks
· Thumbnails
· Saving PDF’s for offline viewing

Listening/watching audio and video
· Windows media played
· Winamp
· Real player

Viewing and editing graphic files
· Ms photoeditor
· Ms paint
· Adobe photoshop

Other useful tasks and applications

· Image fine management –ACDSee
· Screen capture-Snagit

For using and assisting knowledge in university we need to acquire the knowledge in:
· Word processing and presentation – these skills will help to develop well presented assignments
· Email skills – skills to help you communicate effectively with lecturers, tutorial leaders and students/peers
· Internet/browser skills – allow you to use online materials to assist with your learning, including
· Blackboard to access course materials
· WWW to search and use for research and to create and manage an online journal
· And knowledge regarding various applications and their uses for specific tasks – including Endnote (electronic management of reference)

Five things I learnt from the lecture and the tutorial.


1. How to make graphs using Excel
2. How to SUM and AVERAGE using Excel
3. How to adjust margin and line spacing on Word
4. How to alphabetize references
5. How to show my information in different views

Tutorial
In the tutorial I had to follow the tutorial worksheets and display information in ways I learnt from the workshop.

In word I had to copy and paste a written paragraph and adjust the typeface, margins and alignment and line spacing, then I had to create a heading and a header and footer to finish off my paragraph. I then had to alphabetize references given to me. I then added in an appropriate image for my information.



In Excel I had to build a table with headings and labels as indicated on the workshop sheet, I then had to format my tables by adjusting the border and alignment and colour in the toolbars to match the example on the workshop sheet.
After adding in all the information on the table I then had to use the formulae tool to calculate the columns and rows using SUM, when I had finished this I then AVERAGED my table and moved on to make my graphs. I would use graphs with this information to make a presentation more interesting and an easier way to view my findings.

Readings

In the word reading for this tutorial, it explains how to use Microsoft Word for APA tasks, going through step by step tips on how to do things on word, things include,general tips from changing typeface to adding comments to you work. This is a great information spreadsheet for people who are having difficulty with tasks needed to help there word document look more professional.

The second reading we had to look through was Adobe Photoshop, in this reading it explains the difference between file fomats (.bmp,.gif,.jpeg and .tiff) all are well known file formats used to save pictures/images to our computer. It explains what every format is used for and how to use it when it is in this format.

Emma
xoxox