Consulting/Business Service: ATX Global Solutions and Consulting Inc.

http://www.facebook.com/pages/ATX-Global-Solutions-and-Consulting-Inc/139350546140618

http://www.facebook.com/pages/ATX-Global-Solutions-and-Consulting-Inc-BPO-Recruiting/207109359321303

Synergy

Synergy, in general, may be defined as two or more things functioning together to produce a result not independently obtainable.

Etymology

The term synergy comes from the Greek word syn-ergos, συνεργός, meaning "working together".

Definition and Uses

In the context of organizational behavior, following the view that a cohesive group is more than the sum of its parts, synergy is the ability of a group to outperform even its best individual member. These conclusions are derived from the studies conducted by Jay Hall on a number of laboratory-based group ranking and prediction tasks. He found that effective groups actively looked for the points in which they disagreed and in consequence encouraged conflicts amongst the participants in the early stages of the discussion. In contrast, the ineffective groups felt a need to establish a common view quickly, used simple decision making methods such as averaging, and focused on completing the task rather than on finding solutions they could agree on.

In a technical context, its meaning is a construct or collection of different elements working together to produce results not obtainable by any of the elements alone. The elements, or parts, can include people, hardware, software, facilities, policies, documents: all things required to produce system-level results. The value added by the system as a whole, beyond that contributed independently by the parts, is primarily created by the relationship among the parts; that is, how they are interconnected. In essence, a system constitutes a set of interrelated components working together with a common objective: fulfilling some designated need.

If used in a business application it means that teamwork will produce an overall better result than if each person was working toward the same goal individually. However, the concept of group cohesion needs to be considered. Group cohesion is that property which is inferred from the number and strength of mutual positive attitudes among members of the group. As the group becomes more cohesive, its functioning is affected in a number of ways. First, the interactions and communication between members increase. Common goals, interests and small size all contribute to this. In addition, group member satisfaction increases as the group provides friendship and support against outside threats.

There are negative aspects of group cohesion which have an effect on group decision-making and hence on group effectiveness. There are two issues arising. The risky shift phenomenon is the tendency of a group to make decisions that are riskier than those that the group would have recommended individually. Group Polarisation is when individuals in a group begin by taking a moderate stance on an issue regarding a common value and, after having discussed it, end up taking a more extreme stance.

 A second, potential negative consequence of group cohesion is group think. Group think is a mode of thinking that people engage in when they are deeply involved in cohesive group, when the members' striving for unanimity overrides their motivation to appraise realistically the alternative courses of action. Studying the events of several American policy "disasters" such as the failure to anticipate the Japanese attack on Pearl Harbor (1941) and the Bay of Pigs fiasco (1961), Irving Janis argued that they were due to the cohesive nature of the committees that made the relevant decisions.

That decisions made by committees lead to failure in a simple system is noted by Dr. Chris Elliot. His case study looked at IEEE-488, an international standard set by the leading US standards body; it led to a failure of small automation systems using the IEEE-488 standard (which codified a proprietary communications standard HP-IB). But the external devices used for communication were made by two different companies and the incompatibility between the external devices led to a financial loss for the company. He argues that systems will be only safe if they are designed, not if they emerge by chance.

The idea of a systemic approach is endorsed by the United Kingdom Health and Safety Executive: The successful performance of the health and safety management depends upon the analyzing the causes of incidents and accidents and learning correct lessons from them. The idea is that all events (not just those causing injuries) represent failures in control, and present an opportunity for learning and improvement.  This book describes the principles and management practices, which provide the basis of effective health and safety management. It sets out the issues which need to be addressed, and can be used for developing improvement programs, self-audit or self-assessment. Its message is that organizations need to manage health and safety with the same degree of expertise and to the same standards as other core business activities, if they are to effectively control risks and prevent harm to people.

The term synergy was refined by R. Buckminster Fuller who analyzed some of its implications more fully^[9] and coined the term Synergetics. Synergy can be understood as the opposite of the concept entropy. Hence it was perhaps more of a "discovery"etymologically speaking.

§  A dynamic state in which combined action is favored over the difference of individual component actions.

§  Behavior of whole systems unpredicted by the behavior of their parts taken separately, known as emergent behavior.

§  The cooperative action of two or more stimuli (or drugs), resulting in a different or greater response than that of the individual stimuli.

Learning theory (education)

In psychology and education, learning is commonly defined as a process that brings together cognitive, emotional, and environmental influences and experiences for acquiring, enhancing, or making changes in one's knowledge, skills, values, and world views (Illeris, 2004; Ormrod, 1995). Learning as a process focuses on what happens when the learning takes place. Explanations of what happens constitutelearning theories. A learning theory is an attempt to describe how people and animals learn, thereby helping us understand the inherently complex process of learning. Learning theories have two chief values according to Hill (2002). One is in providing us with vocabulary and a conceptual framework for interpreting the examples of learning that we observe. The other is in suggesting where to look for solutions to practical problems. The theories do not give us solutions, but they do direct our attention to those variables that are crucial in finding solutions.

There are three main categories or philosophical frameworks under which learning theories fall: behaviorism, cognitivism, and constructivism. Behaviorism focuses only on the objectively observable aspects of learning. Cognitive theories look beyond behavior to explain brain-based learning. And constructivism views learning as a process in which the learner actively constructs or builds new ideas or concepts.

In psychology and education, learning is commonly defined as a process that brings together cognitive, emotional, and environmental influences and experiences for acquiring, enhancing, or making changes in one's knowledge, skills, values, and world views (Illeris, 2004; Ormrod, 1995). Learning as a process focuses on what happens when the learning takes place. Explanations of what happens constitute learning theories. A learning theory is an attempt to describe how people and animals learn, thereby helping us understand the inherently complex process of learning. Learning theories have two chief values according to Hill (2002). One is in providing us with vocabulary and a conceptual framework for interpreting the examples of learning that we observe. The other is in suggesting where to look for solutions to practical problems. The theories do not give us solutions, but they do direct our attention to those variables that are crucial in finding solutions.

There are three main categories or philosophical frameworks under which learning theories fall: behaviorism, cognitivism, and constructivism. Behaviorism focuses only on the objectively observable aspects of learning. Cognitive theories look beyond behavior to explain brain-based learning. And constructivism views learning as a process in which the learner actively constructs or builds new ideas or concepts.

Open Office Manual

Open Office is more flexible than Microsoft Word.  It can work with files in either OpenOffice file formats or in Microsoft file formats. However,Microsoft Office, such as Microsoft Word, can only work with files in Microsoft file formats.

PART 1

Microsoft And OpenOffice On Your computer

Both OpenOffice and Microsoft Office can be on your computer at the same time and work well together. However, it can be confusing when you are opening and closing files on your computer. It may appear as if your Microsoft files are converted into OpenOffice files and you cannot get the Microsoft files back. This tutorial will allow you to avoid the confusion.

Open Files

1.       When you installed OpenOffce, you were given the choice to use OpenOffice or Microsoft to open Microsoft files.

2.       By default there are no check marks in the boxes before “Microsoft Word Documents”, “Microsoft Excel Spreadsheets”, and “Microsoft Power Point Presentations”

3.       IF a check-mark WAS NOT placed in the boxes when OpenOffice is installed, Microsoft Office will open and use Microsoft Office files in the normal way..

4.       IF a check-mark IS placed in the boxes when installing OpenOffice , OpenOffice will open Microsoft files into the OpenOffice file format. (To open the Microsoft file, be in OpenOffice then click File > Open) OpenOffice can work with the file than originally was in the Microsoft format.

5.       If you are just trying out OpenOffice, you probably do not want to add check-marks.

Save Files

1.       IF you are working in Microsoft Word, do a normal “Save”. The file will be saved in the Microsoft format.

2.       IF you are working in OpenOffice, you can choose to save the file in either the Microsoft format or in the OpenOffice format (Click File > Save As. In the “File type:” box, select the format of your choice.)

3.       IF you have opened a Microsoft document in OpenOffice and have made no changes to the Microsoft document (.doc) and click File >Close, the file will be saved in the Microsoft format, (.doc) IF you have made changes to the Microsoft document, ( .doc) and clickClose, you will get a choice to Save , Discard, or Cancel.

4.       IF you click Cancel, the option of closing is canceled and you will go back into the the document.

5.       IF If you click Discard, the modified Microsoft file that you were working with will be discarded (will be lost), however the original Microsoft file that you had opened will still be there..

6.       IF you click Save, you will get this message:

Getting Microsoft Files From The Internet

1.       On the Internet, Copy the Microsoft material of your choice.

2.       In OpenOffice, click the  to the right of the Paste  icon to open the menu below.

3.       Click Unformatted text. (The material appears on your OpenOffice document.)

4.       If you have already saved material from the Internet in OpenOffice and you did NOT use Paste > Unformatted text, the following will happen

5.       When you open the document to make changes, you may experience some difficulties when you attempt to add headings to paragraphs so that you can add a Table of Contents. (It may be written in MS Word.) Click the Non-printing characters  icon. If you see this icon at the end of each paragraph instead of the OpenOffice Non-printing characters icon, you will need to delete those icons and replace them with the OpenOffice Non-printing characters  icon. After doing that, you can make formatting changes without any problems. There may be other formatting issues affected by the difference between OpenOffice and other word processing programs.

6.       Note: You have to manually delete and replace the with the OpenOffice Non-printing characters . None of the steps below will replace the  with the OpenOffice Non-printing characters 

• Format > Default Formatting
• Clicking on  in the Apply Styles > Clear Formatting
• Saving the document in OpenOffice format

Icons

The icon of a file indicates what application Windows uses to open the file.

1.       IF check marks are NOT added, the icon for a Microsoft file will be the Microsoft icon.

2.       IF check marks ARE added, the icon for a Microsoft file will be the OpenOffice icon. Even though the OpenOffice icon appears for a file with a Microsoft extension (DOC, XLS, PPT), that file on the hard-drive is still in a Microsoft format.

Stop Microsoft Files Opening Into OpenOffice Formats

When you installed OpenOffice, If you chose to click on the boxes to put check marks by “Microsoft Word Documents”, “Microsoft Excel Spreadsheets”, and “Microsoft Power Point Presentations” to have OpenOffice start when these file types are opened and you change your mind, you will need to re-associate all word processing, spreadsheet or presentation files with the appropriate file type.

Use one of the following methods;

Method 1: Change The Three Letter Extension

1.       Go into your file types setting (it should be under either Tools or Folder Options) from one of the windows in My Computer.

2.       Delete the association for .doc, .xls, and any other file types that you do not want associated with OpenOffice.

3.       When you next click on a file of that type (such as .doc or .xls), it will ask you what you want to use to open it. Click on word, excel, or whatever you want to use. You will also be given the option to select always use this application to open the file type.

Method 2: Change The Default Setting Within OpenOffice

4.       Launch any OpenOffice.org application such as OpenOffice Writer.

5.       Click on Tools > Options.

6.       Expand the Load/Save section in the left pane by clicking the + (plus sign).

7.       Click on General under the Load/Save section.

8.       In the area labeled as Default file format near the bottom of the dialog window, select the type of document you want, for example, Text Document for Writer files, in the Document Type drop-down list.

9.       To the right drop down list labeled as Always save as, change or select the format as Microsoft Word 97/2000/XP.

10.    Repeat the above 2 steps for other documents such as spreadsheets or presentations that you want to save in Microsoft Office file format, and select the appropriate default save as format for them.

11.    Click OK to save the settings.

12.    From now on, whenever you want to save a document, the default format will be .doc, .xls or .ppt and other Microsoft Office file formats and extensions.

PART 2

Sending OpenOffice Files To Others

1.       If you send a file in the OpenOffice format to someone who does not have OpenOffice on his or her computer, he or she cannot open the file.

2.       If you send a file to someone without OpenOffice on his or her computer, send the file in the Microsoft file format. Most people may have Microsoft Office (or Word) on their computers.

3.       If someone does not have OpenOffice on their computer, you might suggest they download OpenOffice to their computer.

4.       Another solution for a person who only has Microsoft on their computer is to download a free plugin that will give users of Microsoft Office the ability to open, edit, and save files in the OpenOffice format. To get more information go tohttp://www.sun.com/software/star/odf_plugin

FIRST TIME USER - OpenOffice Writer

Writer is the word processing feature in OpenOffice. This tutorial explains how to use the “Tips” feature, open a new text document, change paper size, change margins, change the indentation of paragraphs, use icons, Close and Open files, Undo entries, and get help.

Activate The “Tips” Feature

When the Tips feature is activated and the pointer is placed over an Icon, the name of the icon will appear on the screen.

1.       Click Tools > Options. If there is a + before the "OpenOffice.org", click on the +. (A menu appears directly below the words “OpenOffice.org.) Click General. (The “Options – OpenOffice.org – General” window appears.) Do either 2 or 3 below.

2.       IF there is no check mark before the word “Tips”, click on the word Tips to place a check mark before the word "Tips". Click the OKbutton (The window closes and the pointer goes back to the document. The "Tips" feature is activated.)

3.       IF there is a check mark before the word “Tips”, click the OK button. (The window closes and the pointer goes back to the document. The "Tips" feature is activated.)

Open A New Text Document

1.       IF on the desktop, click  > All Programs > OpenOffice.org 2.3 > OpenOffice.org Writer.

2.       IF you are in OpenOffice.org Writer, click File > New > Text Document.

3.       In either case, A text document appears on your screen. (The name of the text document appears at the top of the screen

4.       The next line down that starts with the word File is called the Menu Bar. (Clicking on a word in the Menu Bar shows a list of things that you can choose to do in Writer. This list is called a Menu.)

5.       The third line down is the Standard Toolbar. (Clicking on a small picture will make available a specific function that can be done in Writer.)

6.       The fourth line down is the Formatting Toolbar. (Additional specific functions that can be done in Writer are on this line.)

7.       The fifth line down is the Ruler which appears on the top and the left side of the page. (Click “View”. If there is a check mark by Ruler, a ruler will appear at the top and the left side of your page on the screen.) The Horizontal Ruler is below.

8.       The numbers on the Ruler on the left side of the page indicate where the text is located on the page from the top of the page. The numbers at the top of the page indicate the location of the text from the left or right sides of the page.)

9.       Right-click on the Ruler to see the choices for the settings which are Millimeter, Centimeter, Inch, Point, and Pica.

10.    The Horizontal Scroll bar (by clicking and holding the pointer, you can navigate a document left and right) is located at the bottom of the page above the Status Bar which is the line at the bottom of the screen that starts with Page 1/1. (This line gives you information about the document you are presently using.)

11.    The Vertical Scroll Bar (by clicking and holding the pointer, you can navigate up and down) is located on the right side of your screen.

Paper Size

1.       Click Format > Page > Page tab. (The “Page Style: Default” window appears)

2.       For this tutorial we will use a paper size of 8 ½ by 11 inches which is a common size in the USA. Under “Paper format”, in the “Format” pull-down menu, select Letter if it is not already selected. To use other paper sizes, open the “Format” pull-down menu and select a size of your choice.

3.       Words, numbers, and graphics can be placed anywhere on a sheet of paper except for a small border at the four outer edges of the paper. The word margin is used to describe the boundary lines where the borders end and the words begin. All future added words, numbers, and graphics will stay within the lines that indicate the margins. The margin lines appear on the screen and will not appear on the printed page.

Change Margins

We will change the margins so there is 7 inches across the page instead of 6 inches. To do this both the left margin and the right margin is reduced from 1.25” to .75”.

1.       In the “Page Style: Default” window, Click the Page tab if it is not already selected. Under “Margins”, In the Left dialog box, change whatever number is there to 0.75”.

2.       One way to get 0.75” is to click repeatedly on the  until .75 appears in the Left dialog box (The up-facing triangle increases the number and the down-facing triangle decreases the number).

3.       Another way to get 0.75” is to type .75 (Click on the number that is there then type 75 then delete the original number by pressing the Delete key)

4.       In the Right dialog box, change the 1.25” to .75”, (This is done the same way that you changed the “Left” dialog box)

5.       Click the OK button. (The “Page Style: Default” window closes.)

Use The Ruler To Change The Indentation Of Selected Paragraphs

Indents are adjusted with the three small triangles on the horizontal ruler or use the “Paragraph” window > “Indents & Spacing” tab by double-clicking anywhere on the horizontal ruler.

1.       To change the left or the right paragraph indent, highlight the paragraph(s) that you want to change the indent, drag the bottom left or the bottom right triangle on the horizontal ruler to a new location.

2.       To change the first line indent of a selected paragraph, drag the top left triangle on the Horizontal Ruler to a new location.

3.       You can adjust the indents by double-clicking anywhere on the Horizontal Ruler and adjust the indents in the Paragraph dialog. (The “Paragraph” window appears.)

Icons, Click, Right-click, Insert

1.       The small pictures on the Standard Toolbar and some of the other toolbars are called icons. Click on each icon. (Click means to press and release the button on the left side of the mouse with your index (pointer) finger. Click only one time unless instructed to “double- click”.)

2.       Find the Gallery icon, . Click on the Gallery icon. (The Gallery window appears on the screen. The background changes color when the icon is in use. Some users may see a white background and some may see a blue background.)

3.       Click on the Gallery icon again to close the window. (There is no background color on the “Gallery” icon.)

4.       Right-click anywhere on the printed or white page area of this tutorial. (Right-click means to press and release the button on the right side of the mouse with your middle finger. Click only one time unless instructed to double-click. A menu appears on the page. To close the window, click anywhere on the page other than on the menu.)

5.       On the Menu Bar, click on Insert. (The “Insert” menu appears. This is a list of the various things you can choose to do in Writer.)

Turn Off The Word Completion Feature

1.       Click Tools > AutoCorrect > Word Completion tab. (The “AutoCorrect” window appears.)

2.       Remove the check-mark in the box, if it is there, before the words Enable word completion. Click on the OK button.

Close And Open Files

1.       On the Menu Bar, click on the word File. (A menu opens that has a list of words.)

2.       Click on the words, Save As. (The “Save As” window appears.)

3.       Click My Documents > File name: (If the words, "My Documents", are not already in the "Save in:" dialog box, click the  at the right end of the “Save in:' dialog box. A menu will appear; find “My Documents'” on this menu and click it. "My Documents" appears in the "Save in:" dialog box. If the cursor is not flashing in the “File name:” dialog box at the bottom of the “Save As:” window, move the I-beam pointer into the box and click. The cursor is flashing in the “File name:” dialog box.)

4.       In the File name: dialog box, type the words, My Lesson. In the Save as type: pull-down menu box, click OpenDocument Text (.odt)if it is not already selected. Click on the Save button located to the right of the File name: dialog box. (The “My Lesson” file has been saved on your computer in the folder, "My Documents", and can be opened later. The top line on the screen has changed to. This indicates the file “My Lesson” is still open on your computer.)

5.       Click the word, File, again. Click the word, Close. (The “My Lesson” file is closed and is not seen on the screen.)

6.       Click File > Open. (The “Open” window appears. If "My Documents" is not already in the Look in: dialog box at the top of the "Open" window, in the list of directories below the Look in: box, click "My Documents". The words, "My Documents", appear in the "Look in:" dialog box.)

7.       Click on My Lesson in the list below the Look in: dialog box. (The words, “My Lesson”, appear in the “File name:” dialog box.)

8.       Click the Open button which is to the right of the File name: dialog box. (The top line on the screen changes to  and the first page of the file, “My Lesson”, appears on the screen below the ruler.)

Undo Entries

Entries can be undone (can be deleted) in the reverse order in which the entries were made. Word(s), graphic(s), and paragraph(s) can be deleted and "Undo" can be used to put them back in your document. Type the three paragraphs below.

This is the first paragraph.

This is the second paragraph.

This is the third paragraph.

Delete Word(s)

1.       In the first paragraph, (This is the first paragraph.), highlight the word, first. Press the delete key. (The word, “first”, is deleted.)

2.       Click Edit. (You will see the menu below.)

3.       Click on Undo: Delete 'first'. (The word, "first", that was deleted is placed back in the document and the menu will close.)

Delete One Paragraph

1.       Highlight the first paragraph, This is the first paragraph. Press the Delete key to delete the paragraph. Click Edit. (When you deleteone paragraph and you click Edit, you will see the menu below,

2.       Click Undo: Delete 'This is ...agraph.' (The paragraph, "This is the first paragraph" is placed back in the document. The length of the sentences in the paragraph determines how much of the paragraph is shown after the "Undo: Delete".)

Delete More Than One Paragraph

1.       Highlight the three paragraphs (This is the first paragraph. This is the second paragraph. This is the third paragraph.) at the beginning of the section, Undo Entries. Press the delete key to delete the paragraphs. (The three paragraphs are deleted.)

2.       Click Edit. (You will see the menu below.)

3.       Click on the Undo: Delete 'Paragraphs'. (The deleted paragraphs are placed back in the document.)

Delete Graphic(s)

1.       Click on the image below. (The green handles will appear.)

2.       Press the Delete key. (The graphic is no longer on your document.)

3.       Click Edit. (You will see the menu below.)

4.       Click Undo: Delete graphics Alt+Backspace. (The graphic reappears on the document.)

Insert Special Character

1.       Place the pointer on the page and click where the symbol is to appear.

2.       Click Insert > Special Character. (The "Special Characters" window appears. You will see two dialog boxes. The one on the left is the "Font" menu and the one on the right is the “Subset” menu.

3.       In the Subset menu, click on the  until you see Miscellaneous Symbols. Click Miscellaneous Symbols.

4.       Scroll until you see the "☺" symbol. Click on the "☺" .

5.       Click OK.

6.       The ☺symbol appears on the page.

Getting Help

1.       On the Menu Bar, click on the word Help. (A menu appears)

2.       Click on the words, What's this?. (The mouse pointer becomes .

3.       On the Standard Toolbar, move the pointer onto a picture (icon). (A brief description of what the picture does appears on the screen)

4.       On the Standard Toolbar and the Formatting Toolbar, move the pointer onto the icons to see what is there.

5.       To get rid of the question mark, click anywhere on the screen below the Standard Toolbar and the Formatting Toolbar.

What is Word Completion?

Word Completion can save time. When you have typed the beginning letters of a word, the remaining letters may appear on your screen as a suggestion without you typing the last letters. If the last letters are correct, press Enter. The rest of the letters are accepted. If the last lettersare not correct, keep typing as normal. The suggested letters are ignored.

How To Accept a Suggestion

1.       In a blank Writer document, type the following sentences: The Word Completion feature automatically finishes words. You may accept the suggestions or you may ignore them. (Your text appears on the screen.)

2.       Press the Enter key. (The cursor appears on the line below your text.)

3.       Type the letters, sug. (The word “suggestions” appears, with the end of the word highlighted.)

4.       Press the Enter key twice, then type the word magic. (The word ,“magic” appears without any highlighting.)

How To Reject a Suggestion

1.       Type the letters sug. The word “suggestions” appears with the end of the word highlighted.

2.       Type the letters ar. (The word “sugar” appears on the screen.)

To Change Word Completion Options

1.       Click Tools > AutoCorrect. (The “AutoCorrect”window appears.)

2.       Click the Word Completion tab (if it is not already there)

3.       Select the Word Completion option from the list below.

The AutoCorrect Dialog Box

Enable word completion This check box lets you click to turn the Word Completion feature on and off. A check mark indicates when the feature is enabled.

Append space When this option is enabled, a space will be automatically added after the completed word when you accept a Word Completion suggestion. A check mark indicates when the feature is enabled.

Show as tip When this option is enabled, Word Completions will appear as a tip above the word you type. A check mark indicates when the feature is enabled.

(You can press Enter on the keyboard to accept the suggested word or simply keep typing to ignore the suggestion.)

Collect words This check box lets you tell Writer whether or not to collect words for use by Word Completion. When you disable this option, writer will not collect any more words from your documents for use by the Word Completion feature. Word Completion will continue to automatically complete words already in the list.

When closing a document, save the list for later use in other documents When this option is enabled, Writer will save the list of Word Completion words for use in other documents. If you disable this option, when you close your document, all words in the Word Completion list will be deleted and unavailable in the next document you open.

Accept with This drop-down list lets you choose the key to use to accept Word Completion suggestions. Your choices are:

·         End: The End key on the keyboard.

·         Enter: The Enter key on the keyboard.

·         Space: The space bar on the keyboard.

·         Right: The right arrow key on the keyboard.

Min. word length This text box lets you enter the minimum number of letters a word must have to qualify for Word Completion. Writer will collect and automatically complete words containing at least the number of letters you chose.

Max. entries This text box lets you enter the maximum number of words Writer will save for use in Word Completion.

Delete Entry This button lets you remove words collected in the Word Completion list. You can click on a word in the list or click and drag to select multiple words for deletion.

INTRODUCTION TO STYLES

Styles Provide The Following Advantages

Makes OpenOffice Easy To Use.

Provide Powerful Capability such as Consistency throughout documents.

Determines the Appearance Of Just About Anything in OpenOffice.

A Few Examples Of What Styles Can Do

The above words, Styles Provide The Following Advantages and A Few Examples Of What Styles Can Do, are centered, bigger, and in bold.

The paragraphs below the words start at the left margin are smaller print, and are not Bold.

Styles can cause all pages to be numbered or just some pages to be numbered.

Styles can cause the margins to be different on the same page or different on different pages.

Styles can make tables, columns, calculations, and/or graphics appear in a document.

Styles can create a table of contents, indexes, footers, and footnotes.

Using The Gallery

Open The Gallery

1.       Click File > New > Text Document.

2.       Click on the Gallery icon  or click Tools > Gallery. (You may have changed your icons to another display; if so, click on the icons to find the "Gallery" icon. The “Gallery” window appears with a lot of colored graphics (pictures). On the left side of the Gallery window are the words, “Backgrounds, Bullets, etc. These words are the names of different "Themes". In the "Gallery', the folders are called "Themes".

3.       Click on the Bullets Theme. The graphics that are in the Bullets Theme (Bullets folder), appear on the screen.

Add/Rename/Delete/Themes In The Gallery and Use Undo

1.       To add a Theme in Gallery, click Gallery > New Theme....> Properties > General (The “Properties of New Theme" window appears.)

2.       Replace the words, New Theme, with a name of your choice. (If you do not select a name for the Theme, each time you click on the "New Theme" button, a new theme will appear with the names, "New Theme, New Theme 1", etc.)

3.       To rename a Theme in Gallery, Select the Theme you want to rename. Right-click on the Theme. Click Properties > Rename. (A window appears with the current name of the Theme highlighted.) Replace the Theme name with a name of your choice. (The Theme in Gallery is renamed. )

4.       To delete a Theme in Gallery, select the Theme you want to delete. (A window appears.) Right-click on the Theme. Click Delete. (The Theme is deleted. The Theme is no longer on the page.)

5.       Click Edit > Undo: (item's name appears here) (The Theme reverts to its former name or reappears in the Gallery.)

Add A New Graphic To The Gallery

Graphics may be downloaded from the Internet, scanned, created with a graphics program, or be photos taken with a digital camera and uploaded to your computer. To insert a graphic image from a file, the file must be stored in a folder on your computer.

1.       Click Gallery > My Theme. (For this tutorial, we are going to use "My Theme". "My Theme" appears on the screen and it has no entries.You can add the picture to any Theme in Gallery.)

2.       Right-click on My Theme. Click Properties > File tab > Find Files button. (The “Properties of My Theme” window appears.) Select the folder in which to start the search and the file types to limit the search.

3.       Select the picture(s) you want to add to Gallery. Click Add. (To select more than one file, hold the Control Key down while you click on each file. To add all the files, click "Add All". The picture(s) appears in "My Theme".)

Find The Path To The Gallery File

If you want to add more graphics to the Gallery, there are several clipart libraries designed for OpenOffice on the Internet. One source is the KAMI's Clipart Collection which can be found

http://www.oooforum.org/forum/viewtopic.phtml?t=23393&start=0

You will need to know the path to the Gallery File in order to place the Clipart libraries in the Gallery so you can use it.

1.       Click Tools > Options. If there is a – in front of the words, “OpenOffice.org”, click on the words, "OpenOffice.org. (A list of choices appear under the word “OpenOffice.org”.)

2.       Click on the word “Paths”. The Options – OpenOffice.org - Paths window appears) The path to the Gallery is on the screen.

Working With Graphics In Your Document

Copy A Graphic (A Picture) From The Gallery

1.       Click Format > New > Text Document. Type the word, Learning. Highlight it. (To highlight the word, "Learning", click and hold on the first letter while moving the pointer over the word and when you reach the end of the word, "Learning", release the mouse button.) Click the Bold icon and the Centered icon. (Place your cursor on the icons on the "Formatting toolbar" to find the "Bold" icon and the "Centered" icon.) Press Enter. (The word, "Learning", moves to the center and is in bold.)

2.       Click on the Homepage Theme The graphics that are in the Homepage Theme appear in the Gallery.

3.       Scroll down until you see  (To scroll down, click on the  a number of times until the picture appears.)

4.       Drag the graphic,  , below the word, Learning. (Dragging is done by clicking on the graphic and moving the mouse without letting go of the mouse button until the graphic is where you want to place it. The picture is moved below the word, "Learning".)

5.       Click on the Gallery icon. (The "Gallery" window closes.)

Resize The Picture

Using The Mouse

1.       Click on the picture. ( An anchor will appear. Eight points (green squares), called handles, will appear along the sides of the picture. )

2.       Place your pointer on any of the points. Click and drag the mouse to modify the picture. (A double-headed arrow ,., will appear. The size of the picture changes but is distorted.)

3.       To keep the proportions of the graphic, press and hold the Shift key. Click and drag a handle of the picture. Release the mouse button to complete the resize. (The size of the picture changes and is not distorted.)

4.       When you have changed the picture to the desired size, click anywhere on the page except on the picture. (The picture will be the desired size.)

Using The “Picture" Window

5.       Right-click anywhere on the picture. (A menu appears.)

6.       Click Picture. (The “Picture” window appears.)

3.       Click on the Type tab. In the Size section, set the Width to 1.0”. (The cursor is flashing just before the numbers in the “Width” box. Highlight and delete (using the Del key) the numbers and type "1.0".) Set the Height to 2.0. (In the “Height” box, click just before the number. Highlight and delete (using the Del key) the numbers . Type 2.0. The picture changes size.)

Relocate The Picture

In The Document Itself

Using The Mouse

1.       Click on the graphic/picture. The mouse pointer turns into a four-way arrow like this  . (An anchor will appear. Eight points (green squares), called handles, will appear along the sides of the picture.)

2.       Long-click on the  and drag the picture to the desired place on your page. (Dragging is done by clicking on the graphic and moving the mouse without letting go of the mouse button until the graphic is where you want to place it. The picture changes location.)

Using The "Picture" Window

3.       Right click in the picture, click Picture. (The "Picture" window appears.) Click the Type tab. Under the Position section, click From leftin the dialog box to the right of Horizontal. In the dialog box to the right of by, change the setting to 1.0”. (In the “by” box, click just before the number. Type 1.0, then press Del to delete the original number.)

4.       In the dialog box to the right of Vertical, click From top. In the dialog box to the right of by, change the setting to 1.0” (In the “by” box, click just before the number. Type 1.0, then press Del to delete the original number.)

5.       Click the OK button. (The picture changes location.)

The Same Picture In Another Location In Your Document Or In Another Document

6.       Right-click on the picture. Click Copy (The picture is saved onto the clipboard.)

7.       Place the pointer and click where you want to put a copy of the same picture in your current document or in another document. ClickPaste. (The same picture is in the document or in another document.)

Insert Graphic As A Background

1.       In the document, click on the page OR on the paragraph that will have the background. For this tutorial, we will click on the page.

2.       Click the Gallery icon > Backgrounds. In the Backgrounds Theme, right- click on the graphic of your choice. (For this tutorial , we will use the "Backgrounds" Theme folder but you may use any Gallery Theme folder. You may use a picture as a background.)

3.       Click Insert > Background > Page (OR Paragraph). The background you selected becomes the background for the page.

4.       To close Gallery, click on the Gallery icon.

Anchor The Graphic/Picture - A Brief Introduction

You can anchor graphics to a page, paragraph, or character, or as a character. You can place graphics in a frame and anchor the frame to a page, paragraph, or character. Anchored items remain even if you insert or delete text. Further information about the anchoring is contained in the Anchoring Help section.

To Page

1.       Anchors the selected item to the current page. Format > Anchor > To Page

2.       The anchored item remains on the current page even if you insert or delete text.

3.       The anchor icon is displayed at the top left corner of the page.

To Paragraph

4.       Anchors the selected item to the current paragraph. Format > Anchor > To Paragraph.

5.       The anchor icon is displayed at the left page margin at the beginning of the paragraph.

To Character

6.       Anchors the selected item to a character.

7.       This command is only available for graphic object. Format > Anchor > To Character

As A Character

8.       Anchors the selected item as a character in the current text. This is usually the one you would use to insert a picture between text.

9.       If the height of the selected item is greater than the current font size, the height of the line containing the item is increased.

10.    Format > Anchor > As Character

To Frame

11.    Anchors the selected item to the surrounding frame.

12.    Format > Anchor > To Frame

Change Anchor

13.    Allows you to switch between anchoring options.

14.    The Change Anchor icon is only visible when an object such as a graphic, control field or frame is selected.

What This Tutorial Does

This tutorial explains how to select the words that will appear in an Alphabetical Index, create an Alphabetical Index that has the selected words, and how to change words in an Alphabetical index.

A Table of Contents will also be created.

You will need to download the Sample Document. Click here to download this document.

Select Index Entries In the Sample Document

1.       In the Sample Document, highlight the words, Paragraph Styles. (The words are at the top of the first section. To highlightParagraph Styles, click just before the P and keep holding the mouse button down as you move the cursor over the words 'Paragraph Styles" then release the mouse button.)

2.       Click Insert -> Indexes and tables -> Entry (The Insert Index Entry window appears.)

3.       In the Index pull-down menu, select Alphabetical Index, if it is not already selected. Click on the words Main Entry. (The highlighted words, "Paragraph Styles"; appear in the "Entry" box. A check mark appears before the words, "Main Entry")

4.       Click the Insert button. (There is no indication that anything happened.)

5.       Highlight the words, Heading 1. Click in the Entry box. ("Heading 1" appears in the "Entry" box.)

6.       In the "1st key" box, type the words, Paragraph Styles.

7.       Click the Insert button. (There is no indication that anything happened.)

8.       Highlight the words, Heading 2. Click in the Entry box. ("Heading 2" appears in the "Entry" box.)

9.       Click the Insert button. (There is no indication that anything happened.)

10.    Highlight the words, Heading 3. Click in the Entrybox. ("Heading 3" appears in the "Entry" box.)

11.    Click the Insert button. (There is no indication that anything happened.)

12.    Highlight the words, Modify and Apply. Click in the Entrybox. ("Modify and Apply" appear in the "Entry" box.)

13.    In the 2nd Key box, type Heading 1.

14.    Click the Insert button. (There is no indication that anything happened.)

15.    In the 2nd Key box, type Heading 2.

16.    Click the Insert button. (There is no indication that anything happened.)

17.    In the 2nd Key box, type Heading 3.

18.    Click the Insert button. (There is no indication that anything happened.)

19.    Click Close. (The "Insert Index Entry" window closes.)

Field Shadings In The Sample Document

In a document, the entries that have been selected can be seen or not seen.

1.       In the Sample Document, click View -> Field Shadings. (You will see the highlighted entries that were selected in the "Sample Document".)

2.       Click View -> Field Shadings again. The entries will no longer be highlighted.)

Create A Table Of Contents In The Sample Document

1.       In the Sample Document, click after the last word in the title of the document, just after the words, Working With Paragraph Styles. (The flashing cursor () appears just after the word, "Styles".)

2.       Click Insert -> Indexes & Tables -> Indexes & Tables. (The "Insert Index/Table" window appears.)

3.       Select the Index/Table tab, if it is not already selected. In the "Type" dialog box , select Table Of Contents, if it is not already selected. Uncheck Protected against manual changes. Click OK. (The "Table of Contents" appears.)

Create An Alphabetical Index In The Sample Document

1.       Scroll to the end of the Sample Document. Click Insert -> Indexes & Tables -> Indexes & Tables. (The "Insert Index/Table window appears.)

2.       Select the Index/Table tab, if it is not already selected. In the Type dialog box, select Alphabetical Index, if it is not already selected. Uncheck Protected against manual changes.

3.       If there is a check mark before Combine identical entries with p or pp, click on the words to remove the check mark. Click OK.

Update An Index

New entries to the index will not be seen in the index until the index is updated.

1.       Click in the index then right-click.

2.       Click Update index\Table.

Delete An Index

An Index can be deleted so that it does not appear in the document. It does not delete the entries that have been selected. A new index can be made by the "Insert Indexes and Tables" command.

1.       Click in the index then right-click.

2.       Click Delete Index/Table.

Mail Merge

The Mail Merge feature includes the following

1.       Address Book: An Address Book is created that can be used in very many different ways.

2.       Form Letters: One document is created that is sent by regular mail to multiple recipients. Each individual who receives a letter will have their name and address printed within their letter.

3.       Labels: Address Labels are created that are placed on envelopes. Return Labels can be created and can have various images such as for a company or the Holiday Season.

4.       Envelopes: Envelopes are printed with the recipients name and address. The senders name and address may also be printed on the envelope.

Select, Copy & Paste, Cut & Paste, Drag

Select

Before you can do anything with text, you need to select it.

Select words that are next to each other

1.       Move your cursor, , so that it is on or just before the capital M at the beginning of what you had typed.

2.       Press and hold down the left button of your mouse, then drag the cursor, , to the right, going over the first typed sentence, thenrelease the left mouse button.

3.        will appear. The black background and white letters means that the sentence has been selected. (The sentence has been copied onto your clipboard which is a place where you can save information)

Copy and Paste

Copy means to Selected text then Copy that text onto your “clipboard”. The “clipboard” is a place on your computer where the text is electronically remembers.

Paste means to place the text that is on the “clipboard” into your document.

1.       Rights-click anywhere on the selected text (This means, move the cursor anywhere on the selected sentence, then press the right button of your mouse) (A menu appears)

2.       Click Copy. (The menu goes away.)

3.       Click just after the question mark, then press Enter. (The cursor move down to the next line.

4.       Right-click, then click Paste. (The sentence is copied below the first sentence)

Select text that is not next to each other

1.       Press and hold down the Control (Ctrl) key then select Jane Doe, then select Joe Blow, then release the Control key. (both Jane Doe and Joe Blow have a black background and are in white letters indicating they have been selected)

2.       Click on the Bold , B, icon that is toward the top of your screen. ((both “Jane Doe” and “Joe Blow” become Bold)

Cut and Paste

Cut means to Select text then Copy that text onto your “clipboard”. That text is deleted from your document. That text is now only on your “clipboard”.

1.       Select any word that you have typed. Right-click on that word. Click Cut (The word is removed from your document and is copied onto the “clipboard”)

2.       At a place of our choice, right-click then click Paste.

Use two different documents

Both Copy and Paste and Cut and Paste can be used between separate documents. You can Copy or Cut in one document and Pasteinto a different document

Drag

The statement above, “Press and hold down the left button of your mouse, then drag the cursor,  to the right, going over the first typed sentence, then release the left mouse button.”, used Drag to select some text. Drag can do other things

Drag used to move text

1.       Select a word of your choice from what you typed.

2.       Move the cursor, , any where on the selected word. Press and hold down the left button of your mouse, then drag the cursor, , to anywhere in your document, then release the left mouse button. (The word will move to where you have your cursor.)

Drag used to copy text

1.       Select a word of your choice from what you typed. Move the cursor, , to any where on the selected word.

2.       With one hand press and hold down the Control (Ctrl) key. With the other hand, Press and hold down the left button of your mouse, thendrag the cursor to anywhere in your document, then release the left mouse button. (The word will be copied to where you have your cursor.)

Graphics and Icons

Graphics and Icons can be selected and processed the same way as text. The Graphics and Icons can be processed by themselves or they can be processed along with text.

Master Documents

A Master Document combines separate documents (separate files) so that the separate documents act as if they are one document.

For example, a book may be created by writing each chapter in a separate document and then creating a Master Document to combine the separate documents into one book. Different people may work separately on different chapters (on different documents).

Lessons 2 And 3 In This Chapter

Lessons 2 and 3 shows how to creates a separate document for each chapter of a book. A Master Document is then created that coordinates “separate chapters” to be “one book”. The “book” can be printed, has a Table Of Contents, an Index, and numbered pages.

Templates

Templates are critical with with Master Documents for standardization, for saving time, and for having less chance of errors.

PRESENTATION

Automate Slides In Your Presentation

Tutorial Donated by Bill Shelley

Once you have created your Impress Presentation you might now want to automate the slides so that you don't have to click the mouse to move to the next slide every time.

Activity	Explanation
1.       Click File  >  Open .	The "Open" window appears.
2.       In the menu below the Look in: dialog box, click My Documents if it is not already there.  In the menu below the File name: dialog box, click  the name of your Presentation.            .	Your Presentation appears on your screen.
In the Tasks window, click Slide Transition.	The "Tasks" window is on the right side of your "Impress Presentation" screen.
Under Apply to selected slides, click the    to scroll to select a transition like Wipe Down or Wipe right.
Click  the    to scroll to Fast in the dialog box to the right of Speed under Modify transition.  Click Fast.	In the "Speed "dialog box, you have three choices for the speed of the transition.  The choices are "Slow", "Medium", and "Fast".
Click Automatically after in the dialog box below Advance slide.   Click the to   set the Seconds to 5sec.	You can also highlight the number in the dialog box and type the number of seconds.
Click Apply to All Slides.
Press F5 to view your presentation to see if you have the speed and format the way you want it. If you want to change the speed or the type of transition you simply apply the process again.

Open And Use The Presentation Wizard

1.       OpenOffice has two ready-made presentation templates, Introducing a New Product and  Recommendation of a Strategy.2.       Click File > New > Presentation > From Template.           (Window 1 of the “Presentation Wizard” appears.)

Introduction

This tutorial converts Microsoft PowerPoint Presentations to OpenOffice Impress Presentations.

When opening a PowerPoint presentation using OpenOffice, the slide transition settings do not always convert and are not applied. You will need to manually set the transition settings using Open Office Impress (Presentation).

Once you have set the transitions, you can save in MS PowerPoint format and the transitions will work for both PowerPoint and Open Office Presentations.

Different Ways To Use This Tutorial

1.       The quickest way to use this Step-By-Step tutorial is just to read it online.

2.       Print this tutorial.

(a)    Read a step.

(b)    Do a step.  

(c)     See what happens on the computer screen.

3.       If you already have a PowerPoint file, use that file with this tutorial.  If you do not have a PowerPoint file, use the  “Sample Presentation” file.

Convert PowerPoint to Impress Presentation

Activity	Explanation
1.       Open a PowerPoint file in Impress OR open the Sample Presentation file.  Click File – Open and choose the file you want to open.	You should now be seeing the first slide of the presentation.
2.       Click Slide Show - Slide Show Settings	“Slide Show” window appears.
3.       Under Options, ensure that “Change slides manually” and “Change Slides by Clicking on background” are NOT checked. Click  OK.
4.       Click Slide 1 tab	The first slide appears on the computer screen. If using a projector, the first slide is seen
5.       Click Slide Show   Under Tasks, click Slide Transition if it is not already available.	“Slide Transition” window opens.
6.       In the Advance slide box, click Automatically after. select how long this slide appears before the next slide will appear.	The Duration box is below the "Automatically after" button.    00:00:05 means 5 seconds.    02:00:00 means 2 hours. Do this by clicking on the Duration box.  Highlight the "sec" and type 00:00:05 OR Click on the at the edge of the Duration box to enter a time.
7.       Click the Apply To All Slides button.
8.       Click File > Save As.  In the Save in: " pull-down menu box, click My Documents (if it is not already selected). In the Save as type:" pull-down menu box, click OpenDocument Presentation (.odp) (if it is not already selected).
9.       In the File name: box, type Cats.    .
10.    Click Save.	" CATS" is saved.  The file, "Cats" is still on the screen.
11.    Click File > Close.	The file, " Cats", is no longer on the screen.

3.       Click Next.  (Window 1 of the “Presentation Wizard” reappears.)

4.       If not already selected, select Introducing a New Product. 

5.       Click Next.  (Window 2 of the "Presentation Wizard" appears.  Note that "Introducing a New Product" is highlighted.  If you prefer another background than the default, under "Select a slide design", click "Presentation backgrounds" and select your choice.)  In the dialog box under Select a slide design, click Presentation if it is not already selected.   In the dialog box under Select an output medium, click Slide. 

6.       Click Next. (Window 3 of "Presentation Wizard" appears.)  Under Select a slide transition, use the default for Effect and Speed.  Under Select Presentation Type, click Automatic.  In the Duration of pages dialog box, type  11 in the seconds place.   In the Duration of pause, type 11 in the seconds place.  (Highlight and type the numbers or use the    to select a number.  The format for the numbers is:  00.00.11.  The "hours setting" is before the first decimal (period).  The "minutes setting" is before the second decimal.  The "seconds setting" is before the third decimal.)

7.       Note:  If you use the default settings, click Create and you have your presentation ready for pictures, text. Etc.

8.       Under Describe your basic ideas, in the dialog box under What is your name or the name of your company?, type The Save Time Company.  In the dialog box under What is the subject of your presentation?, type A New Watch.  In the dialog box under Further ideas to be presented, type Use the Stopwatch Function and Use The Date Function. 

9.       Click Next.              (Window 4 of the 'Presentation Wizard" appears.)

10.    Under Choose your pages, select what you want in your presentation or use the default settings.  Click Create. (Note: "Next" is grayed. "Create" is the next step.)

11.    Click Slide Transition if it is not already selected.  To see your presentation that you just made, click Slide Show.

Save And Close Your Presentation

1.       Click File > Save As.  In the Save in:  pull-down menu box, click My Documents (if it is not already selected). In the Save as type:"  box, click OpenDocument Presentation (.odp) (if it is not already selected).

2.       In the File name: box, type My Slide Show  .    

3.       Click Save.              (" My Slide Show" is saved.  The file, "My Slide Show" is still on the screen.)

4.       Click File > Close.   (The file, " My Slide Show", is no longer on the screen.)

To Watch "My Slide Show” at a Later Time

1.       Click File  >  Open.                (The "Open" window appears.)

2.       In the menu below the "Look in:" dialog box, click My Documents if it is not already there.  In the menu below the File name: dialog box, click My Slide Show.  ("My Slide Show" appears on your screen.)

3.       Click Slide Transition if it is not already selected.  To see your presentation that you just made, click Slide Show.

Drawing

Purpose

This tutorial introduces OpenOffice.org Draw for making small labels. We cover creating a new document, creating Draw objects and changing their properties, and copying and pasting. The result will be 20 labels with a gold appearance and a brick border.

Introduction

OpenOffice.org Draw is a vector-based drawing program rather than a raster-based program. This means Draw is created of distinct objects that can individually be selected and manipulated. In contrast, raster-based programs, like MS Paint or the Gimp, store pixels. In a vector-based program, a line is defined by as a starting point, an ending point, and a color. You can change the color and other properties after creating the line. In contrast, a line in a raster-based program is simply a series of pixels and cannot readily be changed once created.

Objects are anything created in a drawing. Objects have position, orientation, color properties, etc. Several objects can be grouped together and the group can be relocated, scaled, etc.

Many objects can have a text label as well. By default, these text labels are centered vertically and horizontally within the object. The text can have different color, position, font, and size properties.

Creating Labels

Learn by Example: We are going to create a small drawing and repeat it twenty times to make  labels. These are labels for home-brew beer bottles. I want each label to be 1.5”x2.5”.

1.       Click File > New> Drawing.  (A new drawing window appears with the "Drawing" toolbar at the bottom.)

2.       Select the Rectangle icon on the Drawing tool bar:          

3.       On the canvas, click in the upper middle of the screen and drag down and to the right. This will create a box. Don’t worry about the exact position or dimensions—we will fix those shortly.

4.       Right-click in the rectangle.  In the menu,  click Position and Size.  (The "Position and Size" dialog box appears.  (You can also click "Format > Position and Size" or F4 to open the "Position and Size" window.   Note:  A rectangle is created.  The rectangle can be manipulated with the mouse but it is more difficult  to control the position and size.)

5.       Click the  in the dialog box to the right of Position X.  Select 0.00 (if it is not already selected).   Repeat for Position Y.   ("Position" is relative to the upper left-hand corner of the printable area of the page.)  (You can also highlight the current value and type in the new value.)

6.       Click in the dialog boxes to the right of Width and Height.  Click the to set the Width to 1.5” and the  Height to 2.5”.  (You can also highlight the number and type the new number in the dialog box.)  Click OK.  (A basic blue rectangle appears.)

7.       Right-click in the rectangle.    Click Area. (The Area dialog box appears.)  Click the Bitmaps tab, select Brownstone.  Click OK.  (The rectangle area changes from pale blue to a rock or brick pattern.)

8.       Select the Rectangle icon from the drawing tool bar and create a second rectangle in the center of the page.  (There are now two rectangles on the page.)

9.       Right-click in the Rectangle.  Click Position and Size (or press F4 to bring up the "Position and Size" window.) To center the second rectangle over the first with 1/10^th of an inch smaller on all sizes, set the Position X to 0.1” and the Position Y to 0.1”.

10.    To make the second rectangle smaller on each side by 0.1",  click the  to set the Width to 1.3” and the  Height to 2.3”.  Click OK.                

11.    Right-click in the Rectangle and select Area. Select the Gradients tab. Select linear yellow/brown.  Click  OK.        (You should see a golden box with brick trim.)

Adding Text

1.       Click View > Zoom or click the Zoom icon on your toolbar.    (The Zoom dialog box appears.)  Select the Optimal radio button and press OK.              

2.       Click in the golden box to select the inner rectangle.   Press F2 and enter some text, India <enter> Pale <enter> Ale and then press the Escape key. (Note:  The "Line and Filling" toolbar changes to the "Text Formatting" toolbar when you press F2.  If you accidentally click inside the rectangle and the "Text Formatting toolbar changes back to the 'Line and Filling" toolbar, just press F2 again.)

3.       With the inner box still selected, Choose a font and a font size which nicely fills the area. I chose Arial Black at 32 points.

4.       I’d like to know when this brew was bottled, so I’ll add another line of text. Press F2 (Your cursor is now inside the rectangle and the "Line and Filling Toolbar" changes to the "Text Formatting Toolbar".)  Press Enter. Type Bottled 4/10/05. However, this is too large. Let’s select only this newly typed line of text. Hold down the Shift key and tap the left arrow until this entire line is selected. Change the font size to something which fits nicely on the label. I chose font size of 10, which happened to work for this label.  Press the Escape key to exit the label.

Duplication

OK, that is one label, let's make a bunch of them.

1.       First we’ll zoom out a bit. View > Zoom..., select Entire Page, and click OK. Now, we’ll need to make sure we have the Select tool icon chosen in the Drawing toolbar:          

2.       Select both boxes. (Left-click in the center of the canvas and drag up and to the left. As you drag, a ‘crawling ants’ dotted line box covers the area your mouse covers, selecting all objects under it.)               

3.       Group the objects together.  Click Modify (on the Menu Bar at the top of your screen.)  Click the Group icon (or press Alt+Ctrl+Shift+G) to group all the objects into one new object. (This new object can be cut, copied, pasted, stretched, resized, or otherwise changed like most other objects.)    

4.       Now we’ll copy this one and paste one.  Right-click in the label and select Copy.  Right-click in the label again and select Paste (there are now two labels at the same position).  To reposition the top label click in the label and click Position and Size.  (If the menu does not appear with "Position and Size" as a choice, click outside the label and then right-click in the label or press F4 to bring up the "Position and Size" window.)   I want there to be 0.1 inch between each, so I set the Position X to 1.6.  Repeat the procedure, positioning each at 1.6” further to the right. (at 1.6”, 3.2”, 4.8”, and 6.4”).

5.       Now we want to copy these down the page. Select all five labels, and again click the Copy   icon (or CTRL C).  Now click the Paste   icon (or CTRL V) to paste all five new labels.          

6.       These are layered over the original five, we need to move them down. Press F4 to access the Position and Size dialog box. Set the Position Y to 0.1” greater than the height of the labels, or 2.6”. Repeat at 5.2” and 7.8”.        

7.       Now you have twenty labels. Print three copies, and affix to your beer bottles.

Spreadsheet

The Word Spreadsheet

The term spreadsheet  was derived from a large piece of paper that accountants used for business finances. The accountant would spread information like costs, payments, taxes, income, etc out on a single, big, oversized sheet of paper to get a complete financial overview.

Spreadsheets Today

Some examples of spreadsheet usage:

●  Spreadsheets act like a calculator by automatically doing calculations.

●  Spreadsheets are used for tracking personal investments, budgeting, invoices, inventory tracking, statistical analysis, numerical modeling, address books, telephone books, printing labels, etc.

●  Spreadsheets are used in almost every profession to calculate, graph, analyze and store information.

●  Spreadsheets are used for What-if calculations.  Change one number in a spreadsheet and all the calculations in a large spreadsheet will re-calculate, will automatically change.

Open A Spreadsheet

1.       IF on the desktop, click  >  All Programs  >  OpenOffice.org 2.3  > OpenOffice.org Calc.

2.       IF you are in a OpenOffice program, click File > New > Spreadsheet.

3.       In either case a spreadsheet called    appears on our screen.

The Calc Toolbars

The following four Calc Toolbars appear at the top of all Calc screens

Main Menu Toolbar

The first toolbar is the Main Menu toolbar that gives you access to many of the basic commands used in Calc.

Function Toolbar

The second toolbar down is the Function Toolbar. The Function Toolbar contains icons (pictures) to provide quick access to commands like New, Open, Print, Copy, Paste, etc.  When you place your mouse cursor over any of the elements of a toolbar, the name of the element appears on your screen. 

Move your cursor over the icon    .  (The word “New” appears.  Clicking on opens a new spreadsheet.)

Formatting Toolbar

The third toolbar down is the Formatting Toolbar.  The Formatting Toolbar has icons plus drop-down menus that allow you to select a font, font color, alignments, number formats, border options and background colors.

Formula Toolbar

The fourth toolbar down is the Formula Toolbar. The Formula Toolbar contains the Name Box drop-down menu and a long white box called the Input Line.

Note:  If your Toolbars look different, it is because these toolbars are in 800x600 screen resolution and the last eight icons are not shown but are available by clicking on the  the far right of the toolbar.

The Spreadsheet Itself

The rest of the window contains the spreadsheet.  The spreadsheet is divided into rows that have a number at the left of each row and divided into columns with letters at the top of each column.

Cells

A cell is the fundamental element of a worksheet. This is where things are added and where things are seen.  A cell address in a spreadsheet identifies the location of the cell in the spreadsheet. A cell address is a combination of the column letter and the row number of a cell, such as A2 or B16.etc.  When identifying a cell by its address, the column letter is always listed first followed by the row number.

Enter Data

1.                   Click on the A1 cell (The cell at the very top left of the spreadsheet).

2.       Notice the heavy black border around the A1 cell.  The heavy black border indicates that A1 is the active cell.  (A is at the top of the first column and 1 is on the first row.  Both are highlighted.  The highlighting  also indicates that A1 is the active cell.)

3.       Type Hello World and press Enter.

4.       The active cell is now A2.  (The words “Hello World” are in A1.)

5.       When you type something in a cell and press Enter, what you typed is seen in that cell and the cell below becomes the next active cell.

Delete Data

1.       Click on A1 again.

2.       Press the Delete key.  (The “Delete Contents” window appears.)

3.       Check the Delete all box then click OK. (“Hello World” is deleted from A1)

Format Data

Separate Thousands, Two Decimal Places,  Red Negative Numbers 

1.       Click cell A1.   >   Type the number -9999.129   >   Press Enter.  (The cursor moves to cell A2)

2.       Right-click cell A1.  (A small menu appears)   >   click Format cells.  (The “Format cells” window appears)

3.       Click Numbers tab.  Under “Category”, click on Number.  Under “Format”, click on -1,234.12.  Click In the small box before “Negative numbers red”.  (A check-mark appears in the box)  >  Click OK.  (The number '-9,999.13” appears in cell A1.

Align Left

1.       Click Alignment tab.  In the “Horizontal” pull-down menu, select Left.  Click OK.  (the numbers move to the left edge of the cell.)

Addition

The  + sign is used for addition.  To enter the + sign, press the Shift key and the  +,  key.

1.       Click on A6.

2.       Type the number 10, then press Enter.  ("10" appears in "A6" and the active cell is "A7".)

3.       Type the number 5, then press Enter.   ("5" appears in "A7" and the active cell is "A8".)

4.       Type =A6+A7 (Or click the “Function”,  ,  icon.  The “=” appears in “A8'. The “Function”,  ,  icon changes to the “Accept”, , icon. Then type "A6+A7".). 

5.       Press Enter (or click the “Accept”, , icon).  The answer, 15, appears in A8.

Sum (Calculate The Total Of A Column)

1.       In A1, type 5, press Enter. 

2.       In A2, type 5, press Enter,

3.       In A3, type 5, press Enter,

4.       In A4, type 5, press Enter

5.       In A5, type 5, press Enter.

6.       Click In A6, the last cell in the column of numbers you want to add.  ("A6" has a heavy dark border and is the "Active Cell." )

7.       Click on the Sum, Σ, ("Σ" is the mathematics symbol for sum.)  icon on the Formula Toolbar just left of the Input Line   The Function, , icon changes to the Accept, , icon.

8.       Click the Accept, , icon (green check mark) or press Enter.  The formula, =SUM(A1:A5),  appears in the A6 cell.

9.       Press Enter.  The sum, 25, will appear in A6.   A7 becomes the active cell.

Cell Range

In the section above, the SUM function appears as =SUM(A1:A5).  The A1:A5 in the parenthesis is called a Cell Range.  It is shorthand for "from A1 to A5".

Subtraction

The - sign is used for subtraction.  To enter  the – sign, press the   key.

1.       Click on A8.   To clear cell A8, press the Delete key.  (The “Delete Contents” window appears.)  Check the Delete all box and click OK.

2.       Type =A6-A7  (Or click the “Function”,  ,  icon.  The “=” appears in “A8" The “Function”,  ,  icon changes to the “Accept”, , icon. Then type "A6-A7".). 

3.       Press Enter (Or click the “Accept”, , icon.)   The answer, 20, appears in A8.

Multiplication

The star ,*, sign is used for multiplication.  To enter the * sign, press the Shift key and the number 8     key.

1.       Click on A8.  To clear cell A8, press the Delete key.  (The “Delete Contents” window appears.)  Check the Delete all box and click OK.

2.       Type =A6*A7  (Or click the “Function”,  ,  icon. The “=” appears in “A8”.  The “Function”,  ,  icon changes to the “Accept”, , icon.  Then type "A6*A7").3.       Press Enter (Or click the “Accept”, , icon.)  The answer, 125, appears in A8.

Division

The slash, /, sign is used for division.  To enter the slash, /, sign, press the  key [? And /].

1.       Click on A8.   To clear cell A8, press the Delete key.  (The “Delete Contents” window appears.)  Check the Delete all box and click OK.

2.       Type =A6/A7  (Or click the “Function”,  ,  icon.  The “=” appears in “A8'. The “Function”,  ,  icon changes to the “Accept”, , icon. Then type "A6/A7".).  

3.       Press Enter (Or click the “Accept”, , icon.) The answer, 5, appears in A8.

Average

1.       Click on A7, type =Average(A1:A6), press Enter.  (8.33 appears in A7 and 3 now appears in A8)

Enter Formulas

When you type in formulas, the order of operations must be correct.  The correct order is: exponentiation, multiplication, division, addition, then subtraction.  Let's pretend we want to perform a calculation using the equation:

1.       Click on B1.

2.       Type 2 in B1 and press Tab. (Cell C1 becomes active)

3.       Type 4 in C1 and press Tab.  (Cell D1 becomes active)

4.       In D1 type the formula =B1+10/C1 + 20. (Or click the “Function”    icon  which changes to the “Accept”, , icon.  Type "B1+10/C1+20").

5.       Press Enter (Or click the “Accept”,  icon. The answer, 24.5, appears in D1.)

The answer is wrong, it should be 1, using x = 20 and y = 10, but we got 41 for an answer! Why? Because Calc interpreted the equation as:

20 + (10/10) + 20

which equals 41. If you use formulas with equations in the numerator and denominator, you need to use parenthesis () to force the spreadsheet to calculate them properly. Make the following changes:

1.       Click on C1.

2.       Click on the Input Line.

3.       Edit the formula to read  =(A1+10)/(B1+20).  (Click just before the A, then Press the ( key [Shift-9].  Click after the 0 in 10, then press the ) key [Shift-0].  Click just before the B, then Press the ( key [Shift-9].  Click after the 0 in  20, then press the ) key [Shift-0]).

4.       Click the Accept,  icon (green check mark.)  The correct answer, 1, appears in C1.

Copy Formulas

You can copy a formula so that the formula itself is copied OR that the answer to the formula is copied. 

Copy The Formula Itself

1.       Select (click on) the cell(s) that is to be copied.

2.       Right-click, then click Copy.  (The material is copied to the clipboard)

3.       Select (click on) the cell where the material is to appear.

4.       Right-click, then click Paste.

Copy The Answer of a Formula

1.       Select (click on) the cell(s) that has a formula.

2.       Right-click, then click Copy.  (The material is copied to the clipboard)

3.       Select (click on) the cell where the material is to appear.

4.       Right-click, then click Paste Special.  (The “Paste Special” window appears)

5.       Remove the check mark at Paste all.

6.       Remove the check mark at Formulas and add a check mark at Numbers.  Click OK.

Exponentiation

The number 10² is written as 10^2.  To enter the ^ sign, press the Shift key and the number 6, , key.

1.       Click on A9.

2.       Type =A6^A7 (Or click the “Function”,  ,  icon.  The “=” appears in "A9". The “Function”,    icon changes to the “Accept”, , icon. Then type "A6^A7".).

3.       Press Enter (Or click the “Accept”, , icon.)  The answer, 100000, appears in A8.

Open A Spreadsheet

IF on the desktop, click  >  All Programs  >  OpenOffice.org 2.x  >  OpenOffice.org Calc.  IF you are in OpenOffice.org Writer, click File > New > Spreadsheet.  (The spreadsheet called   appears on our screen.

Sheets

When you are working with spreadsheets, there are several items that will help you manage sheets such as Select Sheets, Insert Sheets, Delete Sheets, Rename Sheets, Move/Copy Sheets, And Select All Sheets.

Spreadsheet Rows And Columns

The spreadsheet is divided into rows and columns. Rows are numbered from 1 to 32,000. Columns are labeled with letters from A to IV.

The scroll bars on the right and bottom are used to move around the worksheet.  Click on the downward facing image at the lower, right corner of your screen.  (Lower parts of your spreadsheet appear on your screen and the row numbers on the left side of your screen increase.)

Select Sheets

1.       If the sheet tab that you need is shown, you can click on the sheet tab with the sheet tab number, ,  to select a sheet.  If you have more than three sheets (sheet tabs 1, 2, 3, 4)  and you are on sheet tab 4, you will only see sheet tabs 2, 3, 4.  To get to sheet tab 1, you will have to use the bar. 

2.       The bar has to be used when you have more than three sheets in the spreadsheet.  Click on the bar at the bottom left on the spreadsheet,  (The first arrowhead, , will take you to the beginning of the sheets (pages), the second   arrowhead will take you to the previous sheet, ,  .  the third arrowhead will take you to next sheet, , the fourth arrowhead, , will take you to the last sheet.)

Insert Sheets

Method 1:  Click On The Blank Tab

1.       If more sheets are needed, click on the blank tab after Sheet 3 to quickly add a sheet.  (The "Insert Sheet" window appears.).

2.       Under Position, you can select Before current sheet or After current sheet.  Under Sheet, you can select New sheet, select the number of new sheets you want to add to your spreadsheet, and enter a Name for the sheet.  Another selection is From file. You can use the Browse  button to select a file.

3.       Click OK.   (The "Insert Sheet" window closes.)

Method 2:  Right Click On A Numbered Tab

1.       Another method to insert a sheet is to right-click on one of the tabs. (A menu appears.)

2.       Click on Insert Sheet...  (The "Insert Sheet" window appears.)

3.       Under Position, you can select Before current sheet or After current sheet.  Under Sheet, you can select New sheet, select the number of new sheets you want to add to your spreadsheet, and enter a Name for the sheet.  Another selection is From file. You can use the Browse  button to select a file.

4.       Click OK.   (The "Insert Sheet" window closes.)

Delete Sheets

1.       Right-click on one of the numbered tabs. (A menu appears.)

2.       Click Delete Sheet...  (The message below appears.)

3.       Click Yes to permanently delete the current sheet or No to cancel deleting the sheet.  (The message closes.)

Rename Sheets

1.       Right-click on one of the numbered tabs. (A menu appears.)

2.       Click Rename... (The "Rename Sheet" window appears.)

3.       In the dialog box under Name, name this sheet,  Working Sheet.

4.       Click OK.

Move/Copy Sheets

1.       Right-click on one of the numbered tabs. (A menu appears..)

2.       Click Move/Copy Sheets...(The 'Move/Copy Sheet' window appears.)

3.       In the dialog box under To document, click on the , you are given the choice of Untitled 1 or -new document-.

4.       In the dialog box under Insert before, you can select where you want to move or copy the sheet.  Click Sheet1.  ("Sheet2" appears before "Sheet1".)

Select Cells

There are many ways to select cells in a worksheet. (To unselect the cells, click anywhere on the Spreadsheet.) The primary ways are listed below:

By Dragging

1.       Click a single cell with the left mouse button.

2.       Click the left mouse button and drag the cursor over many cells. (over Row(s), column(s)

By Columns And Rows

1.       Click on a column label to select a column.  (Click on the gray A column label.)

2.       Click on a row label to select a row.  (Click on the gray 1 row label.)

By Selecting All Cells In A Spreadsheet

Click on the empty box that is above row 1 and to the left of column A.

Cell Range

The SUM function appears as SUM(A1:A3).  The A1:A3 in the parenthesis is called a cell range.  It is shorthand for "from A1 to A3"

Data

The rectangles you see are called cells. A cell is the fundamental element of a worksheet. This is where the action takes place. Every cell has an address that is determined by the letter of the column and the number of the row that the cell is in. Addresses are written in the form A2, B16.

Click on a cell on your screen. Notice the black box and the darker gray shading on the column and row labels. The black box identifies the active cell, or the one that will receive whatever you type. A cell can contain text, numbers or formulas. Let's enter something into cell A1:

1.                   Click on the A1 cell (The cell at the very top left of the spreadsheet).

2.       Notice the black rectangle around the A1 cell. The A and the 1 are highlighted.

3.       Type Hello World and press Enter.

4.       The active cell is now A2.  (The words “Hello World” are in A1.)

5.       When you type something in a cell and press Enter, or Tab, or click the left mouse button or use one of the arrow keys, whatever you typed is entered into that cell.

Enter Data Into More Than One Spreadsheet At The Same Time

Method 1:  Use Control Key

1.       While holding down the Ctrl (Control) key, click on the numbered tab Sheet1, then click on Sheet2, then click on Sheet3.  Release the Ctrl key.  (All 3 numbered tabs  now have a white background. The numbered tab of the current (opened) sheet will have the word Sheet in bold)

2.       In cell A1 type the word test then press Enter.  (The word test will be entered in cell A1 on all 3 of the spreadsheets)

3.       To stop adding data into all three Sheets, hold down the Ctrl key then click on the Sheet tab for each of the sheets.

Method 2:  Use "Select All Sheets"

1.       Right-click on one of the numbered tabs, Sheet1, Sheet2, etc. The Menu below appears.

2.       Click Select All Sheets.  (There is no indication that anything happened.)

3.       In cell A2, type the word test2 then press Enter.  (The word, test2, will be entered in cell A2 on all the spreadsheets)

4.       To stop adding data into the Sheets, hold down the Ctrl key then click on the Sheet tab for each of the sheets.

Delete Data

1.       Click on A1 again.

2.       Press the Delete key.  (The “Delete Contents” window appears.)

3.       Check the Delete all box and click OK.   (Note the delete options in the “Delete Contents” window.)

Delete Data From More Than One Spreadsheet At The Same Time

Method 1: Use Control Key

1.       While holding down the Ctrl (Control) key, click on the numbered tabs. Sheet1, then click on Sheet2, then click on Sheet3.  Release the Ctrl key.  (All 3 numbered tabs  now have a white background. The numbered tab on the current sheet will have the word Sheet in bold)

2.       Click on A2.

3.       Press the Delete key.  (The “Delete Contents” window appears.)

4.       Check the Delete all box and click OK.   (The word, test, is no longer on the sheets.)

Method 2: Use "Select All Sheets"

1.       Right-click on one of the numbered tabs, Sheet1, Sheet2, etc. (The Menu below appears.)

2.       Click Select All Sheets.  (There is no indication that anything happened.)

3.       Click on A2.

4.       Press the Delete key.  (The “Delete Contents” window appears.)

5.       Check the Delete all box and click OK.  (The word, "test2", is no longer on the sheets.)

Add A Column Of Numbers For The Total

By A Simple Entry

1.       Click on A1 to make it the active cell.

2.       Type 12.5 and press Enter.  (A2 becomes the active cell.)

3.       Type 23 and press Enter.  (A3 becomes the active cell.)

4.       Type 1000 and press Enter.  (A4 becomes the active cell.)

5.       On the Formula Toolbar, click on the Function, , icon . (The equal sign “=” appears in A4)

6.       Click on A1 (A red line appears around cell A1)  Press and keep holding down the Shift key then press the + key. Release the Shift key.

7.       Click on A2. Press and keep holding down the Shift key then press the + key. Release the Shift key.

8.       Click on A3. Press Enter. The answer, 1035.5, appears in A4. (The cursor moves down to cell A5.)

By The Input Line

1.       Click on A4.

2.       Press Delete.  (The “Delete Contents” window appears.  Make sure the “Delete all“ box is checked.)

3.       Press OK.

4.       Click on the Input Line. 

5.       Click  on the Function, , icon on the Formula Toolbar.   Type =A1+A2+A3.

6.       Press Enter.  The answer, 1035.5,  appears in A4.  (The cursor moves down to cell A5.)

By Using The Sum CommandDe Chavez, Marlen Chel R.                                                                                                MSC 2-05 TF 8:30-10:00 pm

OPEN OFFICE MANUAL

DOCUMENT

OpenOffice Is More Flexible Than Microsoft Word

OpenOffice can work with files in either OpenOffice file formats or in Microsoft file formats. However,Microsoft Office, such as Microsoft Word, can only work with files in Microsoft file formats.

PART 1

Microsoft And OpenOffice On Your computer

Both OpenOffice and Microsoft Office can be on your computer at the same time and work well together. However, it can be confusing when you are opening and closing files on your computer. It may appear as if your Microsoft files are converted into OpenOffice files and you cannot get the Microsoft files back. This tutorial will allow you to avoid the confusion.

Open Files

1.       When you installed OpenOffce, you were given the choice to use OpenOffice or Microsoft to open Microsoft files.

2.       By default there are no check marks in the boxes before “Microsoft Word Documents”, “Microsoft Excel Spreadsheets”, and “Microsoft Power Point Presentations”

3.       IF a check-mark WAS NOT placed in the boxes when OpenOffice is installed, Microsoft Office will open and use Microsoft Office files in the normal way..

4.       IF a check-mark IS placed in the boxes when installing OpenOffice , OpenOffice will open Microsoft files into the OpenOffice file format. (To open the Microsoft file, be in OpenOffice then click File > Open) OpenOffice can work with the file than originally was in the Microsoft format.

5.       If you are just trying out OpenOffice, you probably do not want to add check-marks.

Save Files

1.       IF you are working in Microsoft Word, do a normal “Save”. The file will be saved in the Microsoft format.

2.       IF you are working in OpenOffice, you can choose to save the file in either the Microsoft format or in the OpenOffice format (Click File > Save As. In the “File type:” box, select the format of your choice.)

3.       IF you have opened a Microsoft document in OpenOffice and have made no changes to the Microsoft document (.doc) and click File >Close, the file will be saved in the Microsoft format, (.doc) IF you have made changes to the Microsoft document, ( .doc) and clickClose, you will get a choice to Save , Discard, or Cancel.

4.       IF you click Cancel, the option of closing is canceled and you will go back into the the document.

5.       IF If you click Discard, the modified Microsoft file that you were working with will be discarded (will be lost), however the original Microsoft file that you had opened will still be there..

6.       IF you click Save, you will get this message:

Getting Microsoft Files From The Internet

1.       On the Internet, Copy the Microsoft material of your choice.

2.       In OpenOffice, click the  to the right of the Paste  icon to open the menu below.

3.       Click Unformatted text. (The material appears on your OpenOffice document.)

4.       If you have already saved material from the Internet in OpenOffice and you did NOT use Paste > Unformatted text, the following will happen

5.       When you open the document to make changes, you may experience some difficulties when you attempt to add headings to paragraphs so that you can add a Table of Contents. (It may be written in MS Word.) Click the Non-printing characters  icon. If you see this icon at the end of each paragraph instead of the OpenOffice Non-printing characters  icon, you will need to delete those icons and replace them with the OpenOffice Non-printing characters  icon. After doing that, you can make formatting changes without any problems. There may be other formatting issues affected by the difference between OpenOffice and other word processing programs.

6.       Note: You have to manually delete and replace the  with the OpenOffice Non-printing characters . None of the steps below will replace the  with the OpenOffice Non-printing characters .

• Format > Default Formatting
• Clicking on  in the Apply Styles > Clear Formatting
• Saving the document in OpenOffice format

Icons

The icon of a file indicates what application Windows uses to open the file.

1.       IF check marks are NOT added, the icon for a Microsoft file will be the Microsoft icon.

2.       IF check marks ARE added, the icon for a Microsoft file will be the OpenOffice icon. Even though the OpenOffice icon appears for a file with a Microsoft extension (DOC, XLS, PPT), that file on the hard-drive is still in a Microsoft format.

Stop Microsoft Files Opening Into OpenOffice Formats

When you installed OpenOffice, If you chose to click on the boxes to put check marks by “Microsoft Word Documents”, “Microsoft Excel Spreadsheets”, and “Microsoft Power Point Presentations” to have OpenOffice start when these file types are opened and you change your mind, you will need to re-associate all word processing, spreadsheet or presentation files with the appropriate file type.

Use one of the following methods;

Method 1: Change The Three Letter Extension

1.       Go into your file types setting (it should be under either Tools or Folder Options) from one of the windows in My Computer.

2.       Delete the association for .doc, .xls, and any other file types that you do not want associated with OpenOffice.

3.       When you next click on a file of that type (such as .doc or .xls), it will ask you what you want to use to open it. Click on word, excel, or whatever you want to use. You will also be given the option to select always use this application to open the file type.

Method 2: Change The Default Setting Within OpenOffice

4.       Launch any OpenOffice.org application such as OpenOffice Writer.

5.       Click on Tools > Options.

6.       Expand the Load/Save section in the left pane by clicking the + (plus sign).

7.       Click on General under the Load/Save section.

8.       In the area labeled as Default file format near the bottom of the dialog window, select the type of document you want, for example, Text Document for Writer files, in the Document Type drop-down list.

9.       To the right drop down list labeled as Always save as, change or select the format as Microsoft Word 97/2000/XP.

10.    Repeat the above 2 steps for other documents such as spreadsheets or presentations that you want to save in Microsoft Office file format, and select the appropriate default save as format for them.

11.    Click OK to save the settings.

12.    From now on, whenever you want to save a document, the default format will be .doc, .xls or .ppt and other Microsoft Office file formats and extensions.

PART 2

Sending OpenOffice Files To Others

1.       If you send a file in the OpenOffice format to someone who does not have OpenOffice on his or her computer, he or she cannot open the file.

2.       If you send a file to someone without OpenOffice on his or her computer, send the file in the Microsoft file format. Most people may have Microsoft Office (or Word) on their computers.

3.       If someone does not have OpenOffice on their computer, you might suggest they download OpenOffice to their computer.

4.       Another solution for a person who only has Microsoft on their computer is to download a free plugin that will give users of Microsoft Office the ability to open, edit, and save files in the OpenOffice format. To get more information go tohttp://www.sun.com/software/star/odf_plugin

FIRST TIME USER - OpenOffice Writer

Writer is the word processing feature in OpenOffice. This tutorial explains how to use the “Tips” feature, open a new text document, change paper size, change margins, change the indentation of paragraphs, use icons, Close and Open files, Undo entries, and get help.

Activate The “Tips” Feature

When the Tips feature is activated and the pointer is placed over an Icon, the name of the icon will appear on the screen.

1.       Click Tools > Options. If there is a + before the "OpenOffice.org", click on the +. (A menu appears directly below the words “OpenOffice.org.) Click General. (The “Options – OpenOffice.org – General” window appears.) Do either 2 or 3 below.

2.       IF there is no check mark before the word “Tips”, click on the word Tips to place a check mark before the word "Tips". Click the OKbutton (The window closes and the pointer goes back to the document. The "Tips" feature is activated.)

3.       IF there is a check mark before the word “Tips”, click the OK button. (The window closes and the pointer goes back to the document. The "Tips" feature is activated.)

Open A New Text Document

1.       IF on the desktop, click  > All Programs > OpenOffice.org 2.3 > OpenOffice.org Writer.

2.       IF you are in OpenOffice.org Writer, click File > New > Text Document.

3.       In either case, A text document appears on your screen. (The name of the text document appears at the top of the screen

4.       The next line down that starts with the word File is called the Menu Bar. (Clicking on a word in the Menu Bar shows a list of things that you can choose to do in Writer. This list is called a Menu.)

5.       The third line down is the Standard Toolbar. (Clicking on a small picture will make available a specific function that can be done in Writer.)

6.       The fourth line down is the Formatting Toolbar. (Additional specific functions that can be done in Writer are on this line.)

7.       The fifth line down is the Ruler which appears on the top and the left side of the page. (Click “View”. If there is a check mark by Ruler, a ruler will appear at the top and the left side of your page on the screen.) The Horizontal Ruler is below.

8.       The numbers on the Ruler on the left side of the page indicate where the text is located on the page from the top of the page. The numbers at the top of the page indicate the location of the text from the left or right sides of the page.)

9.       Right-click on the Ruler to see the choices for the settings which are Millimeter, Centimeter, Inch, Point, and Pica.

10.    The Horizontal Scroll bar (by clicking and holding the pointer, you can navigate a document left and right) is located at the bottom of the page above the Status Bar which is the line at the bottom of the screen that starts with Page 1/1. (This line gives you information about the document you are presently using.)

11.    The Vertical Scroll Bar (by clicking and holding the pointer, you can navigate up and down) is located on the right side of your screen.

Paper Size

1.       Click Format > Page > Page tab. (The “Page Style: Default” window appears)

2.       For this tutorial we will use a paper size of 8 ½ by 11 inches which is a common size in the USA. Under “Paper format”, in the “Format” pull-down menu, select Letter if it is not already selected. To use other paper sizes, open the “Format” pull-down menu and select a size of your choice.

3.       Words, numbers, and graphics can be placed anywhere on a sheet of paper except for a small border at the four outer edges of the paper. The word margin is used to describe the boundary lines where the borders end and the words begin. All future added words, numbers, and graphics will stay within the lines that indicate the margins. The margin lines appear on the screen and will not appear on the printed page.

Change Margins

We will change the margins so there is 7 inches across the page instead of 6 inches. To do this both the left margin and the right margin is reduced from 1.25” to .75”.

1.       In the “Page Style: Default” window, Click the Page tab if it is not already selected. Under “Margins”, In the Left dialog box, change whatever number is there to 0.75”.

2.       One way to get 0.75” is to click repeatedly on the until .75 appears in the Left dialog box (The up-facing triangle increases the number and the down-facing triangle decreases the number).

3.       Another way to get 0.75” is to type .75 (Click on the number that is there then type 75 then delete the original number by pressing the Delete key)

4.       In the Right dialog box, change the 1.25” to .75”, (This is done the same way that you changed the “Left” dialog box)

5.       Click the OK button. (The “Page Style: Default” window closes.)

Use The Ruler To Change The Indentation Of Selected Paragraphs

Indents are adjusted with the three small triangles on the horizontal ruler or use the “Paragraph” window > “Indents & Spacing” tab by double-clicking anywhere on the horizontal ruler.

1.       To change the left or the right paragraph indent, highlight the paragraph(s) that you want to change the indent, drag the bottom left or the bottom right triangle on the horizontal ruler to a new location.

2.       To change the first line indent of a selected paragraph, drag the top left triangle on the Horizontal Ruler to a new location.

3.       You can adjust the indents by double-clicking anywhere on the Horizontal Ruler and adjust the indents in the Paragraph dialog. (The “Paragraph” window appears.)

Icons, Click, Right-click, Insert

1.       The small pictures on the Standard Toolbar and some of the other toolbars are called icons. Click on each icon. (Click means to press and release the button on the left side of the mouse with your index (pointer) finger. Click only one time unless instructed to “double- click”.)

2.       Find the Gallery icon, . Click on the Gallery icon. (The Gallery window appears on the screen. The background changes color when the icon is in use. Some users may see a white background and some may see a blue background.)

3.       Click on the Gallery  icon again to close the window. (There is no background color on the “Gallery” icon.)

4.       Right-click anywhere on the printed or white page area of this tutorial. (Right-click means to press and release the button on the right side of the mouse with your middle finger. Click only one time unless instructed to double-click. A menu appears on the page. To close the window, click anywhere on the page other than on the menu.)

5.       On the Menu Bar, click on Insert. (The “Insert” menu appears. This is a list of the various things you can choose to do in Writer.)

Turn Off The Word Completion Feature

1.       Click Tools > AutoCorrect > Word Completion tab. (The “AutoCorrect” window appears.)

2.       Remove the check-mark in the box, if it is there, before the words Enable word completion. Click on the OK button.

Close And Open Files

1.       On the Menu Bar, click on the word File. (A menu opens that has a list of words.)

2.       Click on the words, Save As. (The “Save As” window appears.)

3.       Click My Documents > File name: (If the words, "My Documents", are not already in the "Save in:" dialog box, click the  at the right end of the “Save in:' dialog box. A menu will appear; find “My Documents'” on this menu and click it. "My Documents" appears in the "Save in:" dialog box. If the cursor is not flashing in the “File name:” dialog box at the bottom of the “Save As:” window, move the I-beam pointer into the box and click. The cursor is flashing in the “File name:” dialog box.)

4.       In the File name: dialog box, type the words, My Lesson. In the Save as type: pull-down menu box, click OpenDocument Text (.odt)if it is not already selected. Click on the Save button located to the right of the File name: dialog box. (The “My Lesson” file has been saved on your computer in the folder, "My Documents", and can be opened later. The top line on the screen has changed to. This indicates the file “My Lesson” is still open on your computer.)

5.       Click the word, File, again. Click the word, Close. (The “My Lesson” file is closed and is not seen on the screen.)

6.       Click File > Open. (The “Open” window appears. If "My Documents" is not already in the Look in: dialog box at the top of the "Open" window, in the list of directories below the Look in: box, click "My Documents". The words, "My Documents", appear in the "Look in:" dialog box.)

7.       Click on My Lesson in the list below the Look in: dialog box. (The words, “My Lesson”, appear in the “File name:” dialog box.)

8.       Click the Open button which is to the right of the File name: dialog box. (The top line on the screen changes to  and the first page of the file, “My Lesson”, appears on the screen below the ruler.)

Undo Entries

Entries can be undone (can be deleted) in the reverse order in which the entries were made. Word(s), graphic(s), and paragraph(s) can be deleted and "Undo" can be used to put them back in your document. Type the three paragraphs below.

This is the first paragraph.

This is the second paragraph.

This is the third paragraph.

Delete Word(s)

1.       In the first paragraph, (This is the first paragraph.), highlight the word, first. Press the delete key. (The word, “first”, is deleted.)

2.       Click Edit. (You will see the menu below.)

3.       Click on Undo: Delete 'first'. (The word, "first", that was deleted is placed back in the document and the menu will close.)

Delete One Paragraph

1.       Highlight the first paragraph, This is the first paragraph. Press the Delete key to delete the paragraph. Click Edit. (When you deleteone paragraph and you click Edit, you will see the menu below,

2.       Click Undo: Delete 'This is ...agraph.' (The paragraph, "This is the first paragraph" is placed back in the document. The length of the sentences in the paragraph determines how much of the paragraph is shown after the "Undo: Delete".)

Delete More Than One Paragraph

1.       Highlight the three paragraphs (This is the first paragraph. This is the second paragraph. This is the third paragraph.) at the beginning of the section, Undo Entries. Press the delete key to delete the paragraphs. (The three paragraphs are deleted.)

2.       Click Edit. (You will see the menu below.)

3.       Click on the Undo: Delete 'Paragraphs'. (The deleted paragraphs are placed back in the document.)

Delete Graphic(s)

1.       Click on the image below. (The green handles will appear.)

2.       Press the Delete key. (The graphic is no longer on your document.)

3.       Click Edit. (You will see the menu below.)

4.       Click Undo: Delete graphics Alt+Backspace. (The graphic reappears on the document.)

Insert Special Character

1.       Place the pointer on the page and click where the symbol is to appear.

2.       Click Insert > Special Character. (The "Special Characters" window appears. You will see two dialog boxes. The one on the left is the "Font" menu and the one on the right is the “Subset” menu.

3.       In the Subset menu, click on the  until you see Miscellaneous Symbols. Click Miscellaneous Symbols.

4.       Scroll until you see the "☺" symbol. Click on the "☺" .

5.       Click OK.

6.       The ☺symbol appears on the page.

Getting Help

1.       On the Menu Bar, click on the word Help. (A menu appears)

2.       Click on the words, What's this?. (The mouse pointer becomes ).

3.       On the Standard Toolbar, move the pointer onto a picture (icon). (A brief description of what the picture does appears on the screen)

4.       On the Standard Toolbar and the Formatting Toolbar, move the pointer onto the icons to see what is there.

5.       To get rid of the question mark, click anywhere on the screen below the Standard Toolbar and the Formatting Toolbar.

What is Word Completion?

Word Completion can save time. When you have typed the beginning letters of a word, the remaining letters may appear on your screen as a suggestion without you typing the last letters. If the last letters are correct, press Enter. The rest of the letters are accepted. If the last lettersare not correct, keep typing as normal. The suggested letters are ignored.

How To Accept a Suggestion

1.       In a blank Writer document, type the following sentences: The Word Completion feature automatically finishes words. You may accept the suggestions or you may ignore them. (Your text appears on the screen.)

2.       Press the Enter key. (The cursor appears on the line below your text.)

3.       Type the letters, sug. (The word “suggestions” appears, with the end of the word highlighted.)

4.       Press the Enter key twice, then type the word magic. (The word ,“magic” appears without any highlighting.)

How To Reject a Suggestion

1.       Type the letters sug. The word “suggeestions” appears with the end of the word highlighted.

2.       Type the letters ar. (The word “sugar” appears on the screen.)

To Change Word Completion Options

1.       Click Tools > AutoCorrect. (The “AutoCorrect”window appears.)

2.       Click the Word Completion tab (if it is not already there)

3.       Select the Word Completion option from the list below.

The AutoCorrect Dialog Box

Enable word completion This check box lets you click to turn the Word Completion feature on and off. A check mark indicates when the feature is enabled.

Append space When this option is enabled, a space will be automatically added after the completed word when you accept a Word Completion suggestion. A check mark indicates when the feature is enabled.

Show as tip When this option is enabled, Word Completions will appear as a tip above the word you type. A check mark indicates when the feature is enabled.

(You can press Enter on the keyboard to accept the suggested word or simply keep typing to ignore the suggestion.)

Collect words This check box lets you tell Writer whether or not to collect words for use by Word Completion. When you disable this option, writer will not collect any more words from your documents for use by the Word Completion feature. Word Completion will continue to automatically complete words already in the list.

When closing a document, save the list for later use in other documents When this option is enabled, Writer will save the list of Word Completion words for use in other documents. If you disable this option, when you close your document, all words in the Word Completion list will be deleted and unavailable in the next document you open.

Accept with This drop-down list lets you choose the key to use to accept Word Completion suggestions. Your choices are:

·         End: The End key on the keyboard.

·         Enter: The Enter key on the keyboard.

·         Space: The space bar on the keyboard.

·         Right: The right arrow key on the keyboard.

Min. word length This text box lets you enter the minimum number of letters a word must have to qualify for Word Completion. Writer will collect and automatically complete words containing at least the number of letters you chose.

Max. entries This text box lets you enter the maximum number of words Writer will save for use in Word Completion.

Delete Entry This button lets you remove words collected in the Word Completion list. You can click on a word in the list or click and drag to select multiple words for deletion.

INTRODUCTION TO STYLES

Styles Provide The Following Advantages

Makes OpenOffice Easy To Use.

Provide Powerful Capability such as Consistency throughout documents.

Determines the Appearance Of Just About Anything in OpenOffice.

A Few Examples Of What Styles Can Do

The above words, Styles Provide The Following Advantages and A Few Examples Of What Styles Can Do, are centered, bigger, and in bold.

The paragraphs below the words start at the left margin are smaller print, and are not Bold.

Styles can cause all pages to be numbered or just some pages to be numbered.

Styles can cause the margins to be different on the same page or different on different pages.

Styles can make tables, columns, calculations, and/or graphics appear in a document.

Styles can create a table of contents, indexes, footers, and footnotes.

Using The Gallery

Open The Gallery

1.       Click File > New > Text Document.

2.       Click on the Gallery icon  or click Tools > Gallery. (You may have changed your icons to another display; if so, click on the icons to find the "Gallery" icon. The “Gallery” window appears with a lot of colored graphics (pictures). On the left side of the Gallery window are the words, “Backgrounds, Bullets, etc. These words are the names of different "Themes". In the "Gallery', the folders are called "Themes".

3.       Click on the Bullets Theme. The graphics that are in the Bullets Theme (Bullets folder), appear on the screen.

Add/Rename/Delete/Themes In The Gallery and Use Undo

1.       To add a Theme in Gallery, click Gallery > New Theme....> Properties > General (The “Properties of New Theme" window appears.)

2.       Replace the words, New Theme, with a name of your choice. (If you do not select a name for the Theme, each time you click on the "New Theme" button, a new theme will appear with the names, "New Theme, New Theme 1", etc.)

3.       To rename a Theme in Gallery, Select the Theme you want to rename. Right-click on the Theme. Click Properties > Rename. (A window appears with the current name of the Theme highlighted.) Replace the Theme name with a name of your choice. (The Theme in Gallery is renamed. )

4.       To delete a Theme in Gallery, select the Theme you want to delete. (A window appears.) Right-click on the Theme. Click Delete. (The Theme is deleted. The Theme is no longer on the page.)

5.       Click Edit > Undo: (item's name appears here) (The Theme reverts to its former name or reappears in the Gallery.)

Add A New Graphic To The Gallery

Graphics may be downloaded from the Internet, scanned, created with a graphics program, or be photos taken with a digital camera and uploaded to your computer. To insert a graphic image from a file, the file must be stored in a folder on your computer.

1.       Click Gallery > My Theme. (For this tutorial, we are going to use "My Theme". "My Theme" appears on the screen and it has no entries.You can add the picture to any Theme in Gallery.)

2.       Right-click on My Theme. Click Properties > File tab > Find Files button. (The “Properties of My Theme” window appears.) Select the folder in which to start the search and the file types to limit the search.

3.       Select the picture(s) you want to add to Gallery. Click Add. (To select more than one file, hold the Control Key down while you click on each file. To add all the files, click "Add All". The picture(s) appears in "My Theme".)

Find The Path To The Gallery File

If you want to add more graphics to the Gallery, there are several clipart libraries designed for OpenOffice on the Internet. One source is the KAMI's Clipart Collection which can be found

http://www.oooforum.org/forum/viewtopic.phtml?t=23393&start=0

You will need to know the path to the Gallery File in order to place the Clipart libraries in the Gallery so you can use it.

1.       Click Tools > Options. If there is a – in front of the words, “OpenOffice.org”, click on the words, "OpenOffice.org. (A list of choices appear under the word “OpenOffice.org”.)

2.       Click on the word “Paths”. The Options – OpenOffice.org - Paths window appears) The path to the Gallery is on the screen.

Working With Graphics In Your Document

Copy A Graphic (A Picture) From The Gallery

1.       Click Format > New > Text Document. Type the word, Learning. Highlight it. (To highlight the word, "Learning", click and hold on the first letter while moving the pointer over the word and when you reach the end of the word, "Learning", release the mouse button.) Click the Bold icon and the Centered icon. (Place your cursor on the icons on the "Formatting toolbar" to find the "Bold" icon and the "Centered" icon.) Press Enter. (The word, "Learning", moves to the center and is in bold.)

2.       Click on the Homepage Theme The graphics that are in the Homepage Theme appear in the Gallery.

3.       Scroll down until you see  (To scroll down, click on the  a number of times until the picture appears.)

4.       Drag the graphic,  , below the word, Learning. (Dragging is done by clicking on the graphic and moving the mouse without letting go of the mouse button until the graphic is where you want to place it. The picture is moved below the word, "Learning".)

5.       Click on the Gallery icon. (The "Gallery" window closes.)

Resize The Picture

Using The Mouse

1.       Click on the picture. ( An anchor will appear. Eight points (green squares), called handles, will appear along the sides of the picture. )

2.       Place your pointer on any of the points. Click and drag the mouse to modify the picture. (A double-headed arrow ,., will appear. The size of the picture changes but is distorted.)

3.       To keep the proportions of the graphic, press and hold the Shift key. Click and drag a handle of the picture. Release the mouse button to complete the resize. (The size of the picture changes and is not distorted.)

4.       When you have changed the picture to the desired size, click anywhere on the page except on the picture. (The picture will be the desired size.)

Using The “Picture" Window

5.       Right-click anywhere on the picture. (A menu appears.)

6.       Click Picture. (The “Picture” window appears.)

3.       Click on the Type tab. In the Size section, set the Width to 1.0”. (The cursor is flashing just before the numbers in the “Width” box. Highlight and delete (using the Del key) the numbers and type "1.0".) Set the Height to 2.0. (In the “Height” box, click just before the number. Highlight and delete (using the Del key) the numbers . Type 2.0. The picture changes size.)

Relocate The Picture

In The Document Itself

Using The Mouse

1.       Click on the graphic/picture. The mouse pointer turns into a four-way arrow like this  . (An anchor will appear. Eight points (green squares), called handles, will appear along the sides of the picture.)

2.       Long-click on the  and drag the picture to the desired place on your page. (Dragging is done by clicking on the graphic and moving the mouse without letting go of the mouse button until the graphic is where you want to place it. The picture changes location.)

Using The "Picture" Window

3.       Right click in the picture, click Picture. (The "Picture" window appears.) Click the Type tab. Under the Position section, click From leftin the dialog box to the right of Horizontal. In the dialog box to the right of by, change the setting to 1.0”. (In the “by” box, click just before the number. Type 1.0, then press Del to delete the original number.)

4.       In the dialog box to the right of Vertical, click From top. In the dialog box to the right of by, change the setting to 1.0” (In the “by” box, click just before the number. Type 1.0, then press Del to delete the original number.)

5.       Click the OK button. (The picture changes location.)

The Same Picture In Another Location In Your Document Or In Another Document

6.       Right-click on the picture. Click Copy (The picture is saved onto the clipboard.)

7.       Place the pointer and click where you want to put a copy of the same picture in your current document or in another document. ClickPaste. (The same picture is in the document or in another document.)

Insert Graphic As A Background

1.       In the document, click on the page OR on the paragraph that will have the background. For this tutorial, we will click on the page.

2.       Click the Gallery icon > Backgrounds. In the Backgrounds Theme, right- click on the graphic of your choice. (For this tutorial , we will use the "Backgrounds" Theme folder but you may use any Gallery Theme folder. You may use a picture as a background.)

3.       Click Insert > Background > Page (OR Paragraph). The background you selected becomes the background for the page.

4.       To close Gallery, click on the Gallery icon.

Anchor The Graphic/Picture - A Brief Introduction

You can anchor graphics to a page, paragraph, or character, or as a character. You can place graphics in a frame and anchor the frame to a page, paragraph, or character. Anchored items remain even if you insert or delete text. Further information about the anchoring is contained in the Anchoring Help section.

To Page

1.       Anchors the selected item to the current page. Format > Anchor > To Page

2.       The anchored item remains on the current page even if you insert or delete text.

3.       The anchor icon is displayed at the top left corner of the page.

To Paragraph

4.       Anchors the selected item to the current paragraph. Format > Anchor > To Paragraph.

5.       The anchor icon is displayed at the left page margin at the beginning of the paragraph.

To Character

6.       Anchors the selected item to a character.

7.       This command is only available for graphic object. Format > Anchor > To Character

As A Character

8.       Anchors the selected item as a character in the current text. This is usually the one you would use to insert a picture between text.

9.       If the height of the selected item is greater than the current font size, the height of the line containing the item is increased.

10.    Format > Anchor > As Character

To Frame

11.    Anchors the selected item to the surrounding frame.

12.    Format > Anchor > To Frame

Change Anchor

13.    Allows you to switch between anchoring options.

14.    The Change Anchor icon is only visible when an object such as a graphic, control field or frame is selected.

What This Tutorial Does

This tutorial explains how to select the words that will appear in an Alphabetical Index, create an Alphabetical Index that has the selected words, and how to change words in an Alphabetical index.

A Table of Contents will also be created.

You will need to download the Sample Document. Click here to download this document.

Select Index Entries In the Sample Document

1.       In the Sample Document, highlight the words, Paragraph Styles. (The words are at the top of the first section. To highlightParagraph Styles, click just before the P and keep holding the mouse button down as you move the cursor over the words 'Paragraph Styles" then release the mouse button.)

2.       Click Insert -> Indexes and tables -> Entry (The Insert Index Entry window appears.)

3.       In the Index pull-down menu, select Alphabetical Index, if it is not already selected. Click on the words Main Entry. (The highlighted words, "Paragraph Styles"; appear in the "Entry" box. A check mark appears before the words, "Main Entry")

4.       Click the Insert button. (There is no indication that anything happened.)

5.       Highlight the words, Heading 1. Click in the Entry box. ("Heading 1" appears in the "Entry" box.)

6.       In the "1st key" box, type the words, Paragraph Styles.

7.       Click the Insert button. (There is no indication that anything happened.)

8.       Highlight the words, Heading 2. Click in the Entry box. ("Heading 2" appears in the "Entry" box.)

9.       Click the Insert button. (There is no indication that anything happened.)

10.    Highlight the words, Heading 3. Click in the Entrybox. ("Heading 3" appears in the "Entry" box.)

11.    Click the Insert button. (There is no indication that anything happened.)

12.    Highlight the words, Modify and Apply. Click in the Entrybox. ("Modify and Apply" appear in the "Entry" box.)

13.    In the 2nd Key box, type Heading 1.

14.    Click the Insert button. (There is no indication that anything happened.)

15.    In the 2nd Key box, type Heading 2.

16.    Click the Insert button. (There is no indication that anything happened.)

17.    In the 2nd Key box, type Heading 3.

18.    Click the Insert button. (There is no indication that anything happened.)

19.    Click Close. (The "Insert Index Entry" window closes.)

Field Shadings In The Sample Document

In a document, the entries that have been selected can be seen or not seen.

1.       In the Sample Document, click View -> Field Shadings. (You will see the highlighted entries that were selected in the "Sample Document".)

2.       Click View -> Field Shadings again. The entries will no longer be highlighted.)

Create A Table Of Contents In The Sample Document

1.       In the Sample Document, click after the last word in the title of the document, just after the words, Working With Paragraph Styles. (The flashing cursor () appears just after the word, "Styles".)

2.       Click Insert -> Indexes & Tables -> Indexes & Tables. (The "Insert Index/Table" window appears.)

3.       Select the Index/Table tab, if it is not already selected. In the "Type" dialog box , select Table Of Contents, if it is not already selected. Uncheck Protected against manual changes. Click OK. (The "Table of Contents" appears.)

Create An Alphabetical Index In The Sample Document

1.       Scroll to the end of the Sample Document. Click Insert -> Indexes & Tables -> Indexes & Tables. (The "Insert Index/Table window appears.)

2.       Select the Index/Table tab, if it is not already selected. In the Type dialog box, select Alphabetical Index, if it is not already selected. Uncheck Protected against manual changes.

3.       If there is a check mark before Combine identical entries with p or pp, click on the words to remove the check mark. Click OK.

Update An Index

New entries to the index will not be seen in the index until the index is updated.

1.       Click in the index then right-click.

2.       Click Update index\Table.

Delete An Index

An Index can be deleted so that it does not appear in the document. It does not delete the entries that have been selected. A new index can be made by the "Insert Indexes and Tables" command.

1.       Click in the index then right-click.

2.       Click Delete Index/Table.

Mail Merge

The Mail Merge feature includes the following

1.       Address Book: An Address Book is created that can be used in very many different ways.

2.       Form Letters: One document is created that is sent by regular mail to multiple recipients. Each individual who receives a letter will have their name and address printed within their letter.

3.       Labels: Address Labels are created that are placed on envelopes. Return Labels can be created and can have various images such as for a company or the Holiday Season.

4.       Envelopes: Envelopes are printed with the recipients name and address. The senders name and address may also be printed on the envelope.

Select, Copy & Paste, Cut & Paste, Drag

Select

Before you can do anything with text, you need to select it.

Select words that are next to each other

1.       Move your cursor,  so that it is on or just before the capital M at the beginning of what you had typed.

2.       Press and hold down the left button of your mouse, then drag the cursor, , to the right, going over the first typed sentence, thenrelease the left mouse button.

3.       will appear. The black background and white letters means that the sentence has been selected. (The sentence has been copied onto your clipboard which is a place where you can save information)

Copy and Paste

Copy means to Selected text then Copy that text onto your “clipboard”. The “clipboard” is a place on your computer where the text is electronically remembers.

Paste means to place the text that is on the “clipboard” into your document.

1.       Rights-click anywhere on the selected text (This means, move the cursor anywhere on the selected sentence, then press the right button of your mouse) (A menu appears)

2.       Click Copy. (The menu goes away.)

3.       Click just after the question mark, then press Enter. (The cursor move down to the next line.

4.       Right-click, then click Paste. (The sentence is copied below the first sentence)

Select text that is not next to each other

1.       Press and hold down the Control (Ctrl) key then select Jane Doe, then select Joe Blow, then release the Control key. (both Jane Doe and Joe Blow have a black background and are in white letters indicating they have been selected)

2.       Click on the Bold , B, icon that is toward the top of your screen. ((both “Jane Doe” and “Joe Blow” become Bold)

Cut and Paste

Cut means to Select text then Copy that text onto your “clipboard”. That text is deleted from your document. That text is now only on your “clipboard”.

1.       Select any word that you have typed. Right-click on that word. Click Cut (The word is removed from your document and is copied onto the “clipboard”)

2.       At a place of our choice, right-click then click Paste.

Use two different documents

Both Copy and Paste and Cut and Paste can be used between separate documents. You can Copy or Cut in one document and Pasteinto a different document

Drag

The statement above, “Press and hold down the left button of your mouse, then drag the cursor,  to the right, going over the first typed sentence, then release the left mouse button.”, used Drag to select some text. Drag can do other things

Drag used to move text

1.       Select a word of your choice from what you typed.

2.       Move the cursor, , any where on the selected word. Press and hold down the left button of your mouse, then drag the cursor, , to anywhere in your document, then release the left mouse button. (The word will move to where you have your cursor.)

Drag used to copy text

1.       Select a word of your choice from what you typed. Move the cursor, , to any where on the selected word.

2.       With one hand press and hold down the Control (Ctrl) key. With the other hand, Press and hold down the left button of your mouse, thendrag the cursor to anywhere in your document, then release the left mouse button. (The word will be copied to where you have your cursor.)

Graphics and Icons

Graphics and Icons can be selected and processed the same way as text. The Graphics and Icons can be processed by themselves or they can be processed along with text.

Master Documents

A Master Document combines separate documents (separate files) so that the separate documents act as if they are one document.

For example, a book may be created by writing each chapter in a separate document and then creating a Master Document to combine the separate documents into one book. Different people may work separately on different chapters (on different documents).

Lessons 2 And 3 In This Chapter

Lessons 2 and 3 shows how to creates a separate document for each chapter of a book. A Master Document is then created that coordinates “separate chapters” to be “one book”. The “book” can be printed, has a Table Of Contents, an Index, and numbered pages.

Templates

Templates are critical with with Master Documents for standardization, for saving time, and for having less chance of errors.

PRESENTATION

Automate Slides In Your Presentation

Tutorial Donated by Bill Shelley

Once you have created your Impress Presentation you might now want to automate the slides so that you don't have to click the mouse to move to the next slide every time.

Activity	Explanation
1.       Click File  >  Open .	The "Open" window appears.
2.       In the menu below the Look in: dialog box, click My Documents if it is not already there.  In the menu below the File name: dialog box, click  the name of your Presentation.            .	Your Presentation appears on your screen.
In the Tasks window, click Slide Transition.	The "Tasks" window is on the right side of your "Impress Presentation" screen.
Under Apply to selected slides, click the    to scroll to select a transition like Wipe Down or Wipe right.
Click  the    to scroll to Fast in the dialog box to the right of Speed under Modify transition.  Click Fast.	In the "Speed "dialog box, you have three choices for the speed of the transition.  The choices are "Slow", "Medium", and "Fast".
Click Automatically after in the dialog box below Advance slide.   Click the to   set the Seconds to 5sec.	You can also highlight the number in the dialog box and type the number of seconds.
Click Apply to All Slides.
Press F5 to view your presentation to see if you have the speed and format the way you want it. If you want to change the speed or the type of transition you simply apply the process again.

Open And Use The Presentation Wizard

1.       OpenOffice has two ready-made presentation templates, Introducing a New Product and  Recommendation of a Strategy.

2.       Click File > New > Presentation > From Template.           (Window 1 of the “Presentation Wizard” appears.)