Workshop 2 - Office Applications

Lecture

Today’s lecture was focused on Application Skills. This included sub topics of common word applications such as Microsoft Word, Excel and PowerPoint, Differentiating and using different file formats such as PDF for Adobe Acrobat Reader and carrying out common PC tasks such as using the Web and Microsoft Office.

Components of the lecture I learnt from and found most useful

• Recognising the differences between 2003 Microsoft applications (the edition I use at home) and 2007 Microsoft applications. This giving me the knowledge and skills to be able to perform the basic commands when I went into the Tutorial.
  


• Knowing how to use Adobe Acrobat Reader and what its purpose is for. The purpose of Adobe Acrobat Reader being a document that you are able to view the on the web and able to update more effectively and efficiently than a normal web page.

• Learning about the alternative Internet Explorer and media player applications besides from Windows Internet Explorer and Windows Media Player. Alternative Internet Explorer applications include AOL Netscape, The Mozilla Suite and Opera. Alternative media player applications include Winamp Real Player.
  

Tutorial

In the tutorial components Gary went through step by step on how to produce screen captures, using Microsoft office programs Word and Excel to be able to produce assignments to university standards.

Workshop 2 - Office Applications

Task 1 was to produce a screen capture and be able to put it in your Blogger post.

• Going to the desired page that you wish to produce a screen capture of, Press the print screen button on the keyboard.



• Open up MS Paint and right mouse click paste, the image of the page should come up
  


• Then save the image once it has come up inside paint and save the image in the appropriate and now I would be able to use this image in my blogger post.

Second task was using Microsoft Word 2007

Listening to the Microsoft Online tutorial http://www.baycongroup.com/wlesson0.htm I learnt how to conduct the following excercises .

Topics that we had covered today in using Microsoft Office
1. Shortcut keys

Ctrl Backspace, Delete Word

• Ctrl Z, Undo
  Ctrl Y, Redo



• Ctrl Home, Go to top page



• Ctrl Shift, Highlight words
  


• Ctrl A, Select whole document
  


• Ctrl C, Copy
  


• Ctrl X, Cut
  

2. Inserting a cover page (only avaliable on Vista)

• Click Insert icon
  


• Choose a cover page
  


• Print preview
  

3. Page Break.

• This features enables me to seperate work wihout pressing enter
  


• Placing my mouse cursor where I want to separate my work
  


• Clicking the insert icon
  


• Then clicking page break

4. Line Spacing

• Highlight Sentence typed up on Word
  


• Right Click mouse Paragraph
  


• Select double line spacing

5. Header and Footer

• Click Insert Header and Footer
  


• Choose Style that you want
  


• View header and footer by print preview
  

6. Page Break

• More effective and effecint than pressing enter to seperate work.
  

Able to seperate work by

• Clicking insert and then into page break
  

7. Word and number search finding function

• Able to find a certain word or number by using the function within the document.




• By pressing Ctrl F Finding key you brings up the search function.




• Then type in the word or number that may you are looking for in the document and it will come up.
  
  

Microsoft Excel O7

Microsoft Excel over the years has become an increasnigly popular and essential tool for many people over the years . Microsoft Excel has a number of purposes some of these uses include adding sums, making graphs and tables and representing statistics.

Excercises were completed by listening to the Microsoft Excel online tutorial http://www.baycongroup.com/excel.htm

Some basic tasks we were taught in class and I had learnt from the online tutorial.

Copy A Figure

• Highlight Figure



• Then Drag with the right corner box

New Sheet Colour and name.

Colour

• Click sheet tab
  
• Right click sheet tab
  
• click Tab colour and choose a colour
  

Name

• Click sheet tab
  
• Right Click sheet tab
  
• Click rename and choose an apprpoiate name for the data and infromation on the sheet
  

Adding up and subtracing figures

• Adding a figure use the function bar, put equal sign first, and type the cells that u want to be added up and put the anwser in a seperate cell eg Cell B7 =B1 + B2
  
• Subtracting a figure same rules apply except subtracing instead of adding

Readings

Week 2 Reading was on using Microsoft Word for APA tasks. The most useful tips I had retrieved and processed to using Microsoft Word was using the page break function, customising spell and grammar checks and avoiding irregular spacing . Page breaks allow me to space my work out without having to continuously press enter, to use the page break function I press CTRL Enter. Using customise spelling check and grammar allows me to turn on and off spell check when I want so I am not distracted by errors when typing. This is done by selecting Tools from the menu bar, Click on Options, click the Spelling & Grammar tab and click to remove checks from "Check spelling as you type" and from "Check Grammar as you”. Irregular spacing is seen usually when information is pasted into Word. To remove irregular spacing paste the text into a normal document first, highlight and copy the electronic text, select edit in the window, then paste and once the dialogue paste special appears select unformatted text. Sometimes assessment texts require a table of contents with dot leaders to sort information or topics.