Information Technology

Home > Information Technology > Core units of competency > Integrate commercial computing packages > Integrate commercial computing packages

Integrate commercial computing packages

ICAITU013C

Introduction

The Integrate commercial computing packages unit is designed to help you integrate the skills gained during the Level II Information Technology course. The unit concentrates on producing workplace documents with at least three commercial software application packages.

On completion of this unit, you should be able to apply appropriate conversion formats and manipulate data between commercial application software.

Elements of competency for the unit are as follows:

Produce required organisational documents

Determine and use self help

The NSW HSC Online© site is bound by the responsibilities outlined in the disclaimer.

Information Technology

Home > Information Technology > Core units of competency > Integrate commercial computing packages > Integrate commercial computing packages

Produce required organisational documents

Appropriate packages and conversion techniques are used to achieve an integrated outcome.

The Windows operating system has made it simpler to share data among computer program applications such as word processors, spreadsheets, databases, graphic packages and so on. A user can create data in one application and then very easily share that data by importing or exporting it to another application by using the windows ‘clipboard’ facilities or by saving the file in a format that another application can open.

Please note that the activities and exercises are mostly based around using the Microsoft® family of products, including Windows XP and Office XP. However the ideas and concepts can be used in most other current computer applications.

Tip: For the following activity, if you cannot see the file extension in Windows Explorer, use the menu, look for and remove the tick that states ‘Hide Extensions for Known File Types’.

File extensions

Each Windows application has a file extension associated with it that is used when saving a document (sometimes referred to as a file). An extension simply describes the document to Windows and also the programs on your computer. You may have noticed that when you view files with Windows Explorer, most have a certain icon attached to them. This icon is derived from the file extension. The figure at right shows an example image from Windows Explorer that has the icons associated with the file names.

Notice how the file called solver_examp.doc has the Microsoft Word icon attached to it, the file called ASSESS3.MDB has the Microsoft Access icon attached to it and the file called Orders_filterex.xls has the Microsoft Excel icon attached to it. When you save a document, the applications program gives it a default file extension. Therefore, when you double click a document within Windows Explorer or My Computer, this action will open the program and also the associated document.

Activity 1 – Saving a file and then opening it from Windows Explorer

Open the Microsoft Word program on your computer. This should load the program and also create an empty Word document.
For this exercise, simply type your first and last name into the document.
Select and from the menu and save the document into the ‘My Documents’ folder on your computer. For the exercise simply call it ‘ex_open’. Notice how the default file extension is .doc.
Close the Microsoft Word program.
Open the Windows Explorer program and navigate to the ‘My Documents’ folder on your computer. The ex_open.doc document should have the Microsoft Word Icon attached to it.
Double click the document and notice how it opens the Microsoft Word program and also ex_open.doc at the same time.

Tip: You can create a shortcut on the Windows Desktop to any document on your computer. Simply right click on the document and select the option to ‘Create Shortcut’. If you then double click the document from the desktop it will open the associated program and also the document at the same time.

Exercise 1

Create some documents in other applications on your computer. Use the techniques described in the previous activity and save and open the various documents.

Please note that there is no suggested answer for this exercise.

Saving documents in a different file format

When you save a document, you have the option of saving it in a different format other than the one associated with the program you are using. For example, you could save a Word document as an HTML document, WordPerfect® document or a Microsoft Word document. You could also save a Microsoft Excel document as an HTML document or as a Lotus123® document. When a document is saved in another format, the file extension name changes, (in most cases), and that file can then be opened in the other application program. Generally, any formatting or special features created in the original document are maintained.

Most application programs keep the same file extension names through different versions of their products. For example, Microsoft Word has kept the .doc extension through all versions of its program. Excel has also kept the .xls extension through all its versions, as Access has kept the .mdb extension. When you save a file in a different format, you have the option of saving to an earlier version of the same program. In this case, the extension will still be the same but the document can be opened in earlier versions of the program. This feature can be useful if you create a document at school on one version of the program and then take it home for further use, but you have a different version of the application at home.

Activity 2 – Saving documents with different extensions

This activity will give you practice in saving documents in different formats. You will also find out what type of file formats your computer supports.

Microsoft Word 1 - Save as a Works document

Create a new Microsoft Word Document and type your name in it.
Select the option from the menu. (Note that you could also click the icon of the disk on the toolbar to do this).
Name the document ‘change1.doc’.

Click the small down area beside the input box for ‘Save File as Type’.
Note the different formats available. The number of formats and the types will be dependent on the version of Word that you are using and the filters installed on your computer.
Find and select the file type .wps.

This will save the file as a Microsoft Works document. Note in the figure above how there are two entries for *.wps. These are both Microsoft Works documents but they are different versions.
Once you have saved the document, open Windows Explorer and navigate to where you saved the ‘change1’ document. If you have Microsoft Works installed on your computer, then the document will have the Works icon attached to it. If you do not have the program the icon will be a generic one.

If you now double click the icon it will open the document within Works (if you have it installed).
OR if Microsoft Works is not installed, you will be asked what application you would like to open the file with. See the figure at right. (The exact message and shape of the box may differ depending on your version of Windows.) Click the button as you need to install Microsoft Works on your computer if you want to open the file within that application.

Microsoft Word 2 – Save as a Text document

Within most applications you will generally have the option of saving a document as plain text. If the document is saved in this format, it will lose any formatting features that have been applied to it. However, saving documents as text can be very useful. Most application programs can open a text document. Therefore, if the application you use, (Word, Excel etc) cannot save in a format that is suitable for another application program that you want to use, you can at least save the text content and then open it in the other program and reapply the formatting.

Open the ‘change1.doc’ file you created in the previous activity.
Add some formatting to your name. (For example, make it bold and coloured.)
Select the , option from the menu.
Change the to ‘Plain Text *.txt.’ Leave the file name the same (change1) and click .

After you have saved it, use Windows Explorer and navigate to where you saved your document. Note that if you saved it in the same folder as the last exercise, you will have two files in the folder with the same name. This is allowable in this instance because the two files have different extensions.
Double click the text document. (Identify it by its icon). It should open your default text editor, (probably Windows Notepad) and also the document. Note that the formatting you applied within Word, (making your name bold etc), has been removed by saving as text.

Microsoft Excel – Save as a text document

When you save a spreadsheet document, you can easily save the spreadsheet into another application's format if Excel has a save filter for that particular application. For example, you can save an Excel document as a Lotus123 file, a Microsoft Works file or an earlier Excel version.
However, if the application type that you want to save to is not in the small down area beside the input box for ‘Save as Type’, then you can only save the file as a delimited text file. A delimited file is a pure text file that has an extra character, (a space, a comma, a tab etc) between the different entries in the file to distinguish each entry from the next. Once the file is saved in this format, there would generally be an import routine in the other application, to import a text delimited file.
Download the home_budget.xls (Excel document) file.
Save the file to your computer and open it with Microsoft Excel.
Select , .
Change the 'Files of Type' to ‘Text (Tab Delimited) (*.txt)’. Leave the same name (home_budget).
When saving the file you may get a warning message about formatting problems. Click OK (or yes) if this happens. This simply warns you that if you save as a text document you will lose some formatting features in the document.Use Windows Notepad and open the home_budget.txt file.
Note how the data is the same as the spreadsheet, with each cell and column entry delimited (separated) by extra spaces. The extra spaces are the tab entries, (the same as typing and pressing the TAB key on the keyboard).

Tip: This technique is very useful for importing/exporting data from very old versions of different databases. Most application programs can read delimited files, so once the text is imported, it is only a matter of reapplying the lost formatting.

Exercise 2

Try creating various documents in different application programs that are installed on your computer. Then save these documents in different formats. Try to reopen the document. If you can then you have the associated program installed on your computer. If not, then the associated program is not installed. Note that there is no formal answer to this exercise.

Exercise 3

Go to activity

File compression

When a file/document is saved on a computer, it is saved in a native format relative to the type of file it is. i.e. word, excel, text etc. However, by using certain compression programs, you can take a file, or a number of files, and reduce the size of those files or roll them up into one file. This can be useful when you want to transfer files between computers or across the Internet. Compression programs extract certain characters out of the contents of a file to reduce the size of the file. Unfortunately, once you extract the characters, you cannot open the document/file again, until you put the characters back in.

There are various programs that can do this, but the industry standard at the moment is a program called WinZip®. (There are others that do just as good a job such as WinRar.) WinZip is a compression program that creates a file called an archive. Within this archive there can be one or more files. Many files that are available for download on the Internet are compressed. The reason for this is that they are smaller, allow quicker download and thereby reduce the amount of traffic on the Internet.

Archives created with WinZip have an extension of .zip. In Windows the default icon for an archive is the figure on the right.

Activity 3 – Using WinZip

Ensure that you have WinZip installed on your computer. If you need the program you can download it from http://www.winzip.com/ . Please note that WinZip is not freeware. If you intend to keep using the program, you are expected to pay for it.

Extracting files from an archive

There are various ways that you can add or extract files from an archive. This activity will walk you through the most common method.
Before you begin, download the zip_activity.zip (Zip file) file to your computer and store it in the My Documents folder. Note that the size of the zip file is approximately 3Kb (3000 bytes).

Open the WinZip program from the start menu.

A program screen similar to the image at right should appear.
Depending on the task, some icons will be greyed out.
Click the ‘Open’ icon and navigate to where you saved the zip_activity.zip file. (My Documents)
Select the .zip file and click open.
In this archive, there are two compressed files - a text Document and a Word Document.
Note the Microsoft Word Document. If you view the right of the Winzip Screen, you will notice that the original document size was 19968 bytes. The compressed size is just 1767 bytes.
To extract the files from the archive, click the ‘Extract’ icon. You will be prompted by a screen that asks you where you want to extract the files to. Ensure that the ‘Extract to’ input box shows the My Documents folder. You can either type in the location or use the ‘Folders/Drives’ box and navigate to where you want to extract them to.
Ensure that the ‘All files’ Radio box is selected. If you select a file/s within the archive window, the ‘Selected Files’ button will be activated and only those files selected will be extracted. (Note that there are some other options available in here). For our purposes we can leave these at the default. You should, however, read the Help files and explore the other options as well.
Click the button and the files will be extracted from the archive to the My Documents folder.
Check to see if the two documents are in the My Documents folder. To open them, simply double click on them.
Close the WinZip program.

Creating an archive

To Create an archive, open the WinZip Program.
Click the ‘New’ Icon.
You will be asked for a name for your archive. For this exercise, call it ‘My_Zip’. Type this into the ‘File Name’ box, ensure that the ‘Save In’ option shows the My Documents folders and click OK.
You will then be prompted to select the files that you want to add to your archive.
Navigate to the My Documents folder and select the two files extracted from the last exercise.
Tip: To select multiple files, hold down the key while clicking on the files. There are other options in here, including the ability to protect the archive with a Password. Please read the Help file for an explanation of the options.
Once the files are selected, click the ‘Add’ button. The archive will be created.
Close the WinZip program and check the contents of the My Documents folder for the zip file called My_zip.zip. In this archive will be the two files you selected in the activity.

Hints & tips for WinZip

There are various ways of using the WinZip program.

To open an existing archive, simply click on the archive from within Windows Explorer. This will start the WinZip program using the archived file.
To add files to an existing archive, simply drag and drop them onto the archive. If you have set a password on the archive, the added files are not password protected.
To extract files from an archive, you can drag and drop them from the archive into any folder.
If you double click on a file/document within an existing archive, the file will open with the associated program.
By default, WinZip adds a shortcut to the right click menu in Windows Explorer. If you select a file(s) and right click the mouse within Windows Explorer, you can create, add, or create and email a zip file.
Normally, to be able to extract files from an archive, a user must have a copy of WinZip on their computer. However, you can create an ‘executable’ archive. The files of an executable archive can be extracted in Windows, without WinZip.
WinZip also allows you to span an archive across multiple floppy disks, which is useful if you have an archive that is bigger than 1.44 MB. When you create an archive, specify that you want to save it on the A: drive (floppy disk) and an option to span disks becomes available.

Exercise 3

Practise adding/extracting files to/from archives using the following activity. Also, have a look at some of the options within the program and try to work out what they do. Tick each item as you complete each activity. You may need to read the help file and also the previous notes to complete some of the items.

Activity	Completed
Create an archive with one file.	?
Create an archive with multiple files.	?
Extract one file from an archive.	?
Extract multiple files from an archive.	?
Use ‘Drag and drop’ to add a file to an archive.	?
Use ‘Drag and drop’ to add multiple files to an archive.	?
Use ‘Drag and drop’ to extract a file from an archive.	?
Use ‘Drag and drop’ to extract multiple files from an archive.	?
Password protect an archive.	?
Extract files from a ‘Password Protected’ Archive.	?
Use a right mouse click within Windows Explorer to create an archive.	?
Use the WinZip wizard.	?
Create a self extracting archive. Hint: Use the ‘Actions – Make.Exe’ menu option).	?
Create an archive that will recreate the folder structure when being extracted.	?

Note, there is no answer to this exercise. Complete each task within the exercise and remember to use the Help file if needed.

File formats

Various types of file formats have been mentioned as you have been reading the previous notes and doing the activities and exercises. Here is a table that explains these types of file and graphic formats.

Graphics formats

Type	Explanation
.bmp	Bitmap File – A standard graphics format for Windows applications, (Paintbrush). Large Size. Comprised of small dots or squares called pixels.
.gif	Graphic Interchange File – A compressed format. Commonly used for web pages because of its size. Creates images in 8 bit colour and is used for animation and transparency.
.jpg or .jpeg	Joint Photographic Experts Group – Also used extensively on web pages. It is a compressed format mainly used for photographs because at a high compression rate, very little colour is lost. Uses 24 bit colour.
.png	Portable Network Graphic – A newer file format for use on web pages. It is of better quality than .jpg and uses a better compression technique. Its main drawback is that older web browsers do not support and cannot display the format.
.tif or .tiff	Tagged Image File Format – Used for scanning pictures. Also compatible on both the Windows and Macintosh computer platforms.

File formats

Type	Explanation
.txt	Text - A file that consists of only text characters (numbers, letters, special characters), that has no formatting set on the characters. It is also known as an ASCII file. Text files can be read by any word processor, most spreadsheet programs and most database applications, as well as any text editor program on any operating system platform.
.pdf	Portable Document Format – A file format for documents that can be read and created on different operating system platforms. Can contain text, images, formatting, colour etc. It is very popular for document distribution across the world wide web, where users download documents to their computers on different operating system platforms such as Apple, Unix, and Windows. The contents are read using the free Adobe® Acrobat program. They are highly compressed during creation but are still generally very large.
.csv	Comma Separated Values – A text file in which entries in the value are separated by a comma. When exporting data from a table in a database, the individual field values can be saved in a CSV text file, with each value separated by a comma. This text file can then be exported into a spreadsheet with each entry going into a separate cell within the spreadsheet. You could also use the same technique to export data from a spreadsheet to a database table.
.dif	Data Interchange File – A file similar to a CSV file in that the data is oriented towards being stored in columns and rows for import/export to spreadsheets and databases. It also contains extra information to allow easy import and export.
.rtf	Rich Text Format – This is a file format where the contents of a document can be saved with formatting, (bold, underline, colour etc) and be reopened by just about any word processor and the formatting in the document will be retained. For example, a document saved with WordPerfect as an .rtf file can be opened by the Word program on an Apple Macintosh and the original formatting of the document will be retained.

Exercise

Go to activity

The NSW HSC Online© site is bound by the responsibilities outlined in the disclaimer.

Information Technology

Home > Information Technology > Core units of competency > Integrate commercial computing packages > Integrate commercial computing packages

Produce required organisational documents

Data is saved and re-accessed without loss of data

If you need to refresh your memory of these procedures please click on this link: Appropriate packages and conversion techniques are used to achieve an integrated outcome.

Storage media

When data, files or documents are saved on your computer there are various storage media that can be used. Each of these storage media has different characteristics, benefits and drawbacks. The table below shows the characteristics of some of the more popular storage media.

Medium	Picture	Characteristics
Floppy Disk		Portable and relatively cheap. Most computers have the ability to read and save to a floppy disk. Standard floppy disks have limited storage capacity – generally 1.44Mb, although there are some disks that can store 100Mb. Note that these require a special type of floppy disk drive. Slow to access and read/save data. High possibility of viral infection. High probability of losing stored data.
Hard Disks		Generally not portable but you can purchase removable hard drives. Not cheap, although the price of hard disk drives is continually falling. Capable of storing large amounts of data - tens of Gigabytes (Gb). Faster than other media for storage and retrieval of data. Prone to virus infection. Low to moderate probability of losing the data stored on the medium.
CDs		Portable storage medium. Most computers sold these days have a CD-ROM (Compact Disk- Read Only Memory) capable of reading the CD disks. Come in various formats. Disks and the CD drives are relatively inexpensive. Some CDs can be used many times for storage of data. These are Compact Disk re-writable (CD-RW) disks. Some CDs can only be used once for storage of data but used many times for accessing the data. These were called recordable (CD-R) disks. Hold a limited amount of data, generally 800Mb - not as much as hard disks but considerably more than floppy disks. Popular in multimedia applications for storing music, video, and images. Low probability of losing stored data in the short term.
DVDs (Digital Video Disk)		Come in various formats. Currently capable of storing 4.7Gb of data Some DVDs used for Hollywood type movies are double layered. This allows the DVD to store the data twice. Quality of output of DVD movies is more than twice the quality of standard VHS tapes. Looks like a normal CD but a little more expensive as are the DVD reader/writers, although this may soon change. High speed access but not as quick as a hard disk drive. DVD medium is portable but your computer needs a DVD reader to access the data. Extremely popular for multimedia applications. Movies and sophisticated presentations can be created on a computer and played on a standard DVD desk top player on your television. Will last a long time, as there is no contact between the disk heads and the actual medium. Low probability of losing stored data in the short term.
USB drives		A newer popular type of portable storage media. Currently capable of storing up to 2Gb. Reasonably expensive, although this may soon change. Small and light. Can be carried in your pocket or on your keychain. Reasonably fast access. Computers need a USB port to access the drive, so they cannot be used on earlier computers without installing a USB peripheral card. Low to medium probability of losing stored data in the short term.

Exercise 1

Go to activity

Using images in documents

The popularity of computers, scanners and digital cameras has given the average business and home user the possibility of producing eye-catching documents. The use of carefully placed images in documents can help a reader understand a concept or attract their eye to a particular part of a document. For example, when you started reading this section, the first thing that you probably would have noticed was the image on the right.

Images can be obtained from various sources. Images may be:

scanned in using a digital scanner
downloaded from a digital camera
purchased on CD from various vendors
downloaded from the Internet from sites that offer free images
drawn in various drawing programs on a computer.

Whatever source you obtain your images from, consider the following points when using the image within documents.

Some documents only support limited types of images. For example a web document (displayed in a web browser) only supports a .jpeg, .gif or .png image. Early browsers do not support the .png image type.
Some applications will only save images as a certain type. Early versions of Windows Paint, would only save as a bitmap (.bmp), for example.
The size of the image can vary considerably depending on how the image has been saved.
Placement of the image within the document needs to be carefully considered and also how the text can flow with the image. Ask yourself if text should flow around the image, or stay only on the left or right of the image.

Activity 1 - Comparing image files

The two images below are exactly the same image created in the Windows XP version of Paint. The XP version of Paint has the ability to save your drawing masterpieces in a format other than a bitmap. The difference in quality between the two is not significant (unless you load them into an image viewer and zoom in on each image), but notice the size of each image and the number of colours. Although only small, the size of the .gif file is around 60-70% larger.

This is a 256 colour .gif image of approximately 14k.

This is a 16.7 million colour .jpeg image of approximately 9k.

Activity 2 - Inserting images into a word document

In the following activity you will insert an image created in another application into a word processed document and manipulate placement of the image within Microsoft Word.

Right click on each smiley image above and save them to your hard disk. Do not change the name and file type. Download the image_exercise.doc (word document) and save it on your hard disk. Once you have downloaded the document, open it in Microsoft Word. The document has some information in it and also two tables. The tables will be used to place the graphics within the document. The second table also has some text in it so we can place the image amongst text to practice wrapping text around images and also resizing the images. (The text in the second box is actually two verses of our National Anthem!).
Click behind the text ‘The gif image will be placed behind here’. This text is in the first table. See the image on the right.

Select the menu and then select . Navigate to where you saved the two smiley face images. Select the Smiley_gif.gif image and click the button.
The gif image will be inserted into the first table. Click on the image. The ‘handles’ (small boxes) will be placed around the image. Note that there is a small problem in that the text is pushed to the left and top and bottom of the document. It needs to be tidied up.

Move the mouse cursor over the bottom right handle of the image. The shape of the cursor will change to an angled, two headed arrow. Once you have this shape, click and hold the left mouse button and drag up. This will allow you to resize and reduce the image. Reduce it down to around 50% of its original size. Click on the smiley image and hold down the left mouse button. You can now move the image left or right within the table. Drag the image across to the right of the existing text and let the mouse button go. The image will be placed at the end of the text.

In the above activity you learnt how to insert an image into your document and move it around the table to make placing the text easy. In the next part of the activity, you will learn how to place the image among existing text, and to get text to flow around the image.
Ensure that the image_exercise.doc is open and click behind the red text in the second table. Select the menu and then select . Navigate to where you saved the two smiley face images. Select the Smiley_jpeg.jpg image and click the button. This will place the image in the table. Because of the size of the image, the document will probably now extend over two pages.
Use the techniques you learned in the previous activity and resize the image to a more manageable size, so the table and the image fit on one page.

Delete the red text in the second table. The image will move to the left, although there is still a gap between the first and second verse of the anthem. It would be better if the text flowed around the image, as shown in the graphic on the right. To do this we need to format the picture within Microsoft Word.

Double click the image. This will open the ‘Format Picture’ dialog box. Select the Layout tab. This shows the various layouts the text can form around the image.

Click the button at the bottom of the layout box. Ensure the ‘Text Wrapping’ tab is selected and click the picture named ‘Square’. This setting will allow you to move the image anywhere around your document without affecting the text. The images in this area show you how your text will flow around the image once selected. Click the button twice.
You will notice that the handles (the small black boxes) around the image have changed to circles. You can now drag the image around the table amongst the text. When you place the image, the text will flow around it. Place the image in the top right of the table and notice how the text flows to the edge and underneath. Practice moving the image around the table and placing it in various positions.

Hints:

The activities above can be done with any type of image that can be imported into a word processed document. We could have completed the second exercise using the bitmap file or the jpeg.
The Microsoft Office program includes a set of images in the .wmf (Windows Metafile Format) format that can be used within your Word or Excel documents.
When you are creating your images, ensure that the size of the files are not too large. When saving your documents it may make the files too large and they cannot be saved on floppy disks or used on web sites.

Exercise 2

Create an image using Windows Paint (Simply draw a picture - any picture).
Try not to put too much in the picture because the file size may get too large.
Save the image on your hard disk as a bitmap. If possible, use the option to save as a 24 bit colour bitmap to keep to a smaller size. This will depend on your version of Windows.
Use the techniques learned above and import the image into a new Word document.
Type some text in your document and manipulate the image so that the text flows around it.

As additional exercises do the following.

Exercise 3

Draw your image in Microsoft Paint.
Use the
Simply the image into Word using the Clipboard. (You have completed these steps in previous activities.)
If your Paint program allows, save some images in different formats and compare the saved sizes between each format. If you have Windows XP, you can save in different formats.
If you have access to other image programs on your computer such as Jasc Paint Shop Pro® or Adobe Photoshop®, create some images and save them from those programs.

Creating documents for use on web pages

Please note that the exercises and screen shots in this section are from Office XP. However, the ideas and concepts are the same throughout all versions of Office. Your computer may show different screens and layouts than the ones demonstrated here.

With recent versions of Microsoft Office applications you can export data into pages that can be used on a web site. These pages are saved in a format known as HTML (Hypertext Mark-up Language). Although a detailed discussion of HTML goes beyond the scope of this subject, you should know that HTML is the code used by your web browser to display the images, text, sounds and video on your computer screen.

When exporting data from Microsoft Access or Microsoft Excel to a web page, the data can be static or dynamic.

Dynamic data means that the contents of the web page are automatically updated every time a user accesses the web page. The programming code on the web page requests new data from a spreadsheet or database on the web server and then creates a page with the new data.
Static data means that the contents of the web page will not change every time a user accesses a page. The data only changes if somebody (or the application program) generates a new page using Excel or Access and saves it in HTML format.

For the purposes of this subject we will only be looking at static data.

Activity 3

Download and save the television.xls (Excel document) file.

This file shows the number of viewers per 100 that watch specific television shows on various TV channels.
Open the file in Microsoft Excel.
Fix the spreadsheet so that the columns are the correct width, and it has some colour and formatting (we want it to look good if it’s to be placed on the web).
Once you are happy with your formatting select the option from the menu.

At the bottom of the dialog box, there is an option to ‘Save as type:’.
Click the down arrow to the right of the file name. This will open a drop list from which you can select the option to save as different file types.
Select the option for web page, (HTM or HTML)

When you select the option to save as a HTML file, the layout of the save box will change.
Leave the name of the file as Television.htm. As there is only one sheet in this workbook, leave the option to publish entire workbook selected.

There may be an option on your screen to ‘Add interactivity’, (if you are using Office XP). Leave this option un-ticked. When selected, this would allow a user via the web, to manipulate the spreadsheet within a browser. Your web server must be capable of handling this complex interactivity.
Ensure that the My Documents folder is selected as the place to save the file.
Click the button.

A second dialog box will appear. This box offers more options when publishing the web page, including interactivity and the ability to update the web page when the data in the source document changes. You must be publishing the document to an existing Intranet or Internet server to use this function.
For now leave all options unchanged and click the button.

This will create a document in HTML format that could be used on a web site.
You can still look at the web page, if you have a web browser (such as Internet Explorer or Netscape Navigator) installed on your computer.
Navigate to where you saved the television.htm file and double click the file. Your default web browser and also the document will open.
Here is a link to a sample of what the television.htm (HTML document) file may look like.

Exercise 4

Use the spreadsheet downloaded in earlier activities called home_budget.xls (Excel document) and practice exporting the spreadsheet to a web page.

The NSW HSC Online© site is bound by the responsibilities outlined in the disclaimer.

Information Technology

Home > Information Technology > Core units of competency > Integrate commercial computing packages > Integrate commercial computing packages

Produce required organisational documents

Data is saved and re-accessed without loss of data

If you need to refresh your memory of these procedures please click on this link: Appropriate packages and conversion techniques are used to achieve an integrated outcome.

Storage media

Medium	Picture	Characteristics
Floppy Disk		Portable and relatively cheap. Most computers have the ability to read and save to a floppy disk. Standard floppy disks have limited storage capacity – generally 1.44Mb, although there are some disks that can store 100Mb. Note that these require a special type of floppy disk drive. Slow to access and read/save data. High possibility of viral infection. High probability of losing stored data.
Hard Disks		Generally not portable but you can purchase removable hard drives. Not cheap, although the price of hard disk drives is continually falling. Capable of storing large amounts of data - tens of Gigabytes (Gb). Faster than other media for storage and retrieval of data. Prone to virus infection. Low to moderate probability of losing the data stored on the medium.
CDs		Portable storage medium. Most computers sold these days have a CD-ROM (Compact Disk- Read Only Memory) capable of reading the CD disks. Come in various formats. Disks and the CD drives are relatively inexpensive. Some CDs can be used many times for storage of data. These are Compact Disk re-writable (CD-RW) disks. Some CDs can only be used once for storage of data but used many times for accessing the data. These were called recordable (CD-R) disks. Hold a limited amount of data, generally 800Mb - not as much as hard disks but considerably more than floppy disks. Popular in multimedia applications for storing music, video, and images. Low probability of losing stored data in the short term.
DVDs (Digital Video Disk)		Come in various formats. Currently capable of storing 4.7Gb of data Some DVDs used for Hollywood type movies are double layered. This allows the DVD to store the data twice. Quality of output of DVD movies is more than twice the quality of standard VHS tapes. Looks like a normal CD but a little more expensive as are the DVD reader/writers, although this may soon change. High speed access but not as quick as a hard disk drive. DVD medium is portable but your computer needs a DVD reader to access the data. Extremely popular for multimedia applications. Movies and sophisticated presentations can be created on a computer and played on a standard DVD desk top player on your television. Will last a long time, as there is no contact between the disk heads and the actual medium. Low probability of losing stored data in the short term.
USB drives		A newer popular type of portable storage media. Currently capable of storing up to 2Gb. Reasonably expensive, although this may soon change. Small and light. Can be carried in your pocket or on your keychain. Reasonably fast access. Computers need a USB port to access the drive, so they cannot be used on earlier computers without installing a USB peripheral card. Low to medium probability of losing stored data in the short term.

Exercise 1

Go to activity

Using images in documents

Images can be obtained from various sources. Images may be:

scanned in using a digital scanner
downloaded from a digital camera
purchased on CD from various vendors
downloaded from the Internet from sites that offer free images
drawn in various drawing programs on a computer.

Whatever source you obtain your images from, consider the following points when using the image within documents.

Some documents only support limited types of images. For example a web document (displayed in a web browser) only supports a .jpeg, .gif or .png image. Early browsers do not support the .png image type.
Some applications will only save images as a certain type. Early versions of Windows Paint, would only save as a bitmap (.bmp), for example.
The size of the image can vary considerably depending on how the image has been saved.
Placement of the image within the document needs to be carefully considered and also how the text can flow with the image. Ask yourself if text should flow around the image, or stay only on the left or right of the image.

Activity 1 - Comparing image files

This is a 256 colour .gif image of approximately 14k.

This is a 16.7 million colour .jpeg image of approximately 9k.

Activity 2 - Inserting images into a word document

In the following activity you will insert an image created in another application into a word processed document and manipulate placement of the image within Microsoft Word.

Right click on each smiley image above and save them to your hard disk. Do not change the name and file type. Download the image_exercise.doc (word document) and save it on your hard disk. Once you have downloaded the document, open it in Microsoft Word. The document has some information in it and also two tables. The tables will be used to place the graphics within the document. The second table also has some text in it so we can place the image amongst text to practice wrapping text around images and also resizing the images. (The text in the second box is actually two verses of our National Anthem!).
Click behind the text ‘The gif image will be placed behind here’. This text is in the first table. See the image on the right.

Select the menu and then select . Navigate to where you saved the two smiley face images. Select the Smiley_gif.gif image and click the button.
The gif image will be inserted into the first table. Click on the image. The ‘handles’ (small boxes) will be placed around the image. Note that there is a small problem in that the text is pushed to the left and top and bottom of the document. It needs to be tidied up.

Move the mouse cursor over the bottom right handle of the image. The shape of the cursor will change to an angled, two headed arrow. Once you have this shape, click and hold the left mouse button and drag up. This will allow you to resize and reduce the image. Reduce it down to around 50% of its original size. Click on the smiley image and hold down the left mouse button. You can now move the image left or right within the table. Drag the image across to the right of the existing text and let the mouse button go. The image will be placed at the end of the text.

In the above activity you learnt how to insert an image into your document and move it around the table to make placing the text easy. In the next part of the activity, you will learn how to place the image among existing text, and to get text to flow around the image.
Ensure that the image_exercise.doc is open and click behind the red text in the second table. Select the menu and then select . Navigate to where you saved the two smiley face images. Select the Smiley_jpeg.jpg image and click the button. This will place the image in the table. Because of the size of the image, the document will probably now extend over two pages.
Use the techniques you learned in the previous activity and resize the image to a more manageable size, so the table and the image fit on one page.

Delete the red text in the second table. The image will move to the left, although there is still a gap between the first and second verse of the anthem. It would be better if the text flowed around the image, as shown in the graphic on the right. To do this we need to format the picture within Microsoft Word.

Double click the image. This will open the ‘Format Picture’ dialog box. Select the Layout tab. This shows the various layouts the text can form around the image.

Click the button at the bottom of the layout box. Ensure the ‘Text Wrapping’ tab is selected and click the picture named ‘Square’. This setting will allow you to move the image anywhere around your document without affecting the text. The images in this area show you how your text will flow around the image once selected. Click the button twice.
You will notice that the handles (the small black boxes) around the image have changed to circles. You can now drag the image around the table amongst the text. When you place the image, the text will flow around it. Place the image in the top right of the table and notice how the text flows to the edge and underneath. Practice moving the image around the table and placing it in various positions.

Hints:

The activities above can be done with any type of image that can be imported into a word processed document. We could have completed the second exercise using the bitmap file or the jpeg.
The Microsoft Office program includes a set of images in the .wmf (Windows Metafile Format) format that can be used within your Word or Excel documents.
When you are creating your images, ensure that the size of the files are not too large. When saving your documents it may make the files too large and they cannot be saved on floppy disks or used on web sites.

Exercise 2

Create an image using Windows Paint (Simply draw a picture - any picture).
Try not to put too much in the picture because the file size may get too large.
Save the image on your hard disk as a bitmap. If possible, use the option to save as a 24 bit colour bitmap to keep to a smaller size. This will depend on your version of Windows.
Use the techniques learned above and import the image into a new Word document.
Type some text in your document and manipulate the image so that the text flows around it.

As additional exercises do the following.

Exercise 3

Draw your image in Microsoft Paint.
Use the
Simply the image into Word using the Clipboard. (You have completed these steps in previous activities.)
If your Paint program allows, save some images in different formats and compare the saved sizes between each format. If you have Windows XP, you can save in different formats.
If you have access to other image programs on your computer such as Jasc Paint Shop Pro® or Adobe Photoshop®, create some images and save them from those programs.

Creating documents for use on web pages

When exporting data from Microsoft Access or Microsoft Excel to a web page, the data can be static or dynamic.

Dynamic data means that the contents of the web page are automatically updated every time a user accesses the web page. The programming code on the web page requests new data from a spreadsheet or database on the web server and then creates a page with the new data.
Static data means that the contents of the web page will not change every time a user accesses a page. The data only changes if somebody (or the application program) generates a new page using Excel or Access and saves it in HTML format.

For the purposes of this subject we will only be looking at static data.

Activity 3

Download and save the television.xls (Excel document) file.

This file shows the number of viewers per 100 that watch specific television shows on various TV channels.
Open the file in Microsoft Excel.
Fix the spreadsheet so that the columns are the correct width, and it has some colour and formatting (we want it to look good if it’s to be placed on the web).
Once you are happy with your formatting select the option from the menu.

At the bottom of the dialog box, there is an option to ‘Save as type:’.
Click the down arrow to the right of the file name. This will open a drop list from which you can select the option to save as different file types.
Select the option for web page, (HTM or HTML)

When you select the option to save as a HTML file, the layout of the save box will change.
Leave the name of the file as Television.htm. As there is only one sheet in this workbook, leave the option to publish entire workbook selected.

There may be an option on your screen to ‘Add interactivity’, (if you are using Office XP). Leave this option un-ticked. When selected, this would allow a user via the web, to manipulate the spreadsheet within a browser. Your web server must be capable of handling this complex interactivity.
Ensure that the My Documents folder is selected as the place to save the file.
Click the button.

A second dialog box will appear. This box offers more options when publishing the web page, including interactivity and the ability to update the web page when the data in the source document changes. You must be publishing the document to an existing Intranet or Internet server to use this function.
For now leave all options unchanged and click the button.

This will create a document in HTML format that could be used on a web site.
You can still look at the web page, if you have a web browser (such as Internet Explorer or Netscape Navigator) installed on your computer.
Navigate to where you saved the television.htm file and double click the file. Your default web browser and also the document will open.
Here is a link to a sample of what the television.htm (HTML document) file may look like.

Exercise 4

Use the spreadsheet downloaded in earlier activities called home_budget.xls (Excel document) and practice exporting the spreadsheet to a web page.

The NSW HSC Online© site is bound by the responsibilities outlined in the disclaimer.

Information Technology

Home > Information Technology > Core units of competency > Integrate commercial computing packages > Integrate commercial computing packages

Determine and use help

Help is accessed through online help and manuals

Using many computer application programs these days can lead to sheer frustration in trying to do even the simplest of tasks. There are many ways of working out how to complete a task. You could ask a friend, buy a textbook, search the internet or use the Help facilities built into the program.

These notes will concentrate on using the help facilities within the Microsoft Word program, although the concepts, tasks and ideas can be applied to just about any program available on a computer.

Using Help

Within Microsoft Word (and other application programs) there are different types of help:

context sensitive help
help where you can search for information on a particular subject
the (some say dreaded) Office Assistant.

Back to Produce required organisational documents

Context sensitive help

Most Windows programs provide the ability to get help on a particular part of the screen, function or task by accessing a facility called context sensitive help. In Microsoft Word (and most Windows programs) help can be accessed from the Help menu or by using a combination of keyboard keys.

Activity 1 - Use context sensitive help

Open the Microsoft Word program and create a new document.
Select the menu and then select the option.

The shape of the pointer will change to a left pointing arrow with a question mark attached to it.
The cursor will stay this shape until you click on something in the current window.

Move the mouse pointer over the icon of the floppy disk on the toolbar menu.
Click the left mouse button.
Information on that particular item will appear in a balloon box on the screen.
If you want help on another item, select the menu option again or hold down the + keys at the same time.

On some items, there may be no information available on the item you select. In this case the help system will inform you that: ‘There is no help available for this subject’.

Exercise 1

Use context sensitive help and click on different items in the Windows screen and get help on those items. For example, while in context sensitive help click the printer icon, the ABC icon etc.

Using the question mark icon

In some dialog screens, you may notice an icon of a question mark in the right hand top corner of the dialog box. This can also be used for context sensitive help on the dialog box currently showing.

Activity 2

While in Microsoft Word, click and .
This will open the ‘Save As’ dialog box.
In the top right of the dialog box, you will notice an icon of a question mark.
Move the cursor over the question mark and click the left mouse button.
The cursor will change shape to the context sensitive help pointer.
Move it over an item in the ‘Save As’ dialog box and click on it.

Help on the item will be displayed or you will get a message that no help topic is associated with the item.

Exercise 2

Go to activity

Using the built in help system

Microsoft Word, like most programs, has built in help systems. You can access these systems by clicking on the menu item, pressing the key or clicking the icon on the toolbar that shows a question mark within a yellow box.

Help can then be accessed by clicking on different items within Help or searching for specific data.

Activity 3 – Using general help

Note: For this part of the activities it is important that the Office Assistant is not active. To ensure this, please complete the following steps.

Click the menu. Select . This will cause the office assistant to appear. Right click on the Office Assistant and select . Select the tab and remove the tick from the ‘Use the Office Assistant’ option. The Office Assistant will close and the following activities will work correctly.
Ensure that Microsoft Word is open with an empty document. Press the key on the keyboard. This will open the help system. Note that the help system is a separate process in later office applications. It will run a new application called the Microsoft Word Help Program.
Click the tab. The contents section allows you to navigate through the help system. To expand the help contents, click the small plus sign beside ‘Microsoft Word Help’. Notice beside each of the small icons of books, there are plus signs. Clicking on any of these plus signs will expand more help on that subject.
Note that the wording and location of help between versions of Office differs. Below is one example that shows what happens when some of the items are expanded to navigate down to help on OLE (Object linking and embedding) within Word.
As an activity, determine where help on OLE is within your help system. It may be the same as the image above or the wording and location could be a little different.

Searching Help

You need to know where to find help in the contents list to be able to get information.

However, a better option is to use the search system within help.

Activity 4 – Searching for Help

Ensure that Microsoft Word Help is open. Click the ‘Answer Wizard’ tab. Note: on some Help systems this may be called ‘Search’. There is an input box in which you type the text that you would like to search for in the help system.
For the exercise, we will do a search on OLE objects. If not already selected, click the text in the input box. Type in OLE. Click the button. The bottom area will then display a list of topics within Help that relates to our search criteria, OLE.
If you click on a topic, the right side of the Help screen will display information about the topic.

In some Help screens you will notice that the information includes hyperlinks to more information. A hyperlink is simply a navigation link between this part of Help and another part of Help. If you click on the link it will display more help related to the search topic.

Exercise 3

For this exercise, search for any help items that you may have had trouble with when using Word.
If you can’t think of any, try searching on items such as:

importing
exporting
integration.

Note there is no answer for this exercise because of the differences between help systems.

Using the Office Assistant

The Office Assistant is a help feature integrated into recent versions of Microsoft Office. The Office Assistant is another way to access Help by typing in your query and searching the help system. Many computer users do not like the intrusive nature of the Office Assistant and it is regularly disabled.

Activity 5 – Using the Office Assistant

Because we deactivated the Assistant in the previous activity, we need to turn this feature back on. Click the menu and select the option .
An animated image of the Office Assistant will appear somewhere on your desktop. The character may also be different to the one shown at right as they can be changed.
Click the Office Assistant animation with the left mouse button. A balloon box will appear into which you can type your help query.
For the exercise, type OLE in the search box. Another balloon will appear with topics from the help system about OLE items. Select a topic that interests you and you will be hyperlinked to that topic within the normal help system. Note that Office Assistant remains active and allows you to select different topics or do another search for other help items.

Information Technology

Home > Information Technology > Core units of competency > Integrate commercial computing packages > Integrate commercial computing packages

Determine and use help

Internal organisation client documentation is obtained and used

Commercial computing packages also include programs for the storage of data to produce documents such as customer lists, price lists, overdue accounts and so on. These storage programs are called databases. A database program has two parts. First there is the actual data that is stored in tables and second there is the database management system that is used to control access to and retrieval of data from the tables.

Mail Merge documents

The data that is stored in the tables can include basically anything that could be stored on paper lists, forms or cards. Because it is stored in electronic format, you can use tools in programs such as Microsoft Word, Access or Excel to extract the data and create other documents for use within the organisation.

One such procedure is to produce Word documents called Mail Merge letters. For example if you had table(s) in a database that contained information on your customers such as their name, address, and personal information you could use this information to send out a letter informing them of brand new product that you wish to advertise.

If you have the data already stored in your database, then you can simply use tools (within Excel and Word) to extract the required data, (name, address etc) and print the data (customer details) once on the top of a generic letter.

Remember, (for the exercise) that a database consists of tables. A table consists of different entries and is also sometimes called a file.

Within each table are fields which may contain information such as a person’s name, address, date of birth etc. Each form is a record of the person’s application and when you put all the forms together you have a file of member applications.

The image above shows a table from a database.
The table is a file of customers. The information could be written down on a customer card file.
Each row represents a record on customers or the individual cards.
Each record is broken into individual fields - ID, CustomerID, First Name etc.
For each customer there must be exactly the same mount of fields, although the data in the fields can be the same or different.

Importing data into a table in a database

Activity 1 - Importing data into a database table First a database needs some valid records in it. Download the Customers.txt (Text document) file and store it in your My Documents folder. This text file is a delimited file that holds basic information on six customers. (Remember that a delimited file is a text file that holds data that is separated by a particular character.) You will use this text file to create a table in Microsoft Access that you can use in a Mail Merge letter.
Please note that these notes, activities and screen shots refer to using Office XP. However the concepts are the same for all versions of Microsoft Office.
Open your Microsoft Access program and create a new empty database. Click , and .
Navigate to where you saved the customer.txt file in My Documents. Change the ‘Files of type’ option to display *.txt files. Select the customer.txt file and click .
Your Access program should start to run an ‘Import Wizard’. The wizard will recognize that this is a text file and ask if it is a delimited or fixed width file. Notice how each entry in the Sample data box has quotes around it and there are commas between some of the words. When the data is imported, the entry will be stored in a separate field in the table, wherever there is a comma. Accept all the defaults in here and click .
The next screen gives you the option to change the delimiter character from something other than a comma. Make sure you pick the right delimiter character otherwise the data that is imported will be placed incorrectly into the table and the records will be invalid. For the exercise, leave the delimiter character as the comma.
The other important item in this screen is the tick box for ‘First Row Contains Field Names’. Ensure that this option is selected. This tells the wizard that the very first row of information in the text document is used to identify the fields in the table. Click the button.
The next screen gives you the option to import the data into an existing table or create a new table. For the exercise you will create a new table. Leave all the options as they are and click .
The next screen gives you an option to change the way your data is imported into the table. You could change the names of the fields or specify different formats for dates etc. If the data you were importing was stored in the American date format (MM/DD/YY), you could change this to display the Australian date format (DD/MM/YY). For the exercise, leave all options as they are and click .
The next screen asks how to specify a ‘primary key’. A primary key is used to uniquely identify each person in the table. For example, each person in Australia has a unique Tax File Number that identifies that person. The primary key in the table uniquely identifies that customer. For the purposes of the exercise leave all the options as they are and click .
The last screen simply asks for a name for your table. Leave it as the default of ‘Customer’ and click . This will import the data into Microsoft Access, create a new table called ‘Customers’ and populate the table with data from the text file. You can now use this data for your Mail Merge. Save your database as ‘Customers’.

The Mail Merge wizard

Activity 2 – Doing a Mail Merge You can now import the data into a generic letter that could be sent to customers. Again these instructions are for Office XP, but the same concepts can be applied to any version of Microsoft Office. Download the Merge_letter.doc (Word document) and save it on your hard drive. This is a sample document that a company could use to send to their customers about the opening of a new computer store. Open the merge_letter.doc.
In Microsoft Word, select , and . This will start the Mail Merge wizard.

The screen will split into two sections - one showing the document and the other showing the wizard steps.

The first question in the wizard is what type of document you are creating. Leave this at the default of letters. Notice also the option to continue to the next step at the bottom of the wizard screen. Click ‘Next: Starting Document’. This will move on to the next step.
You will now be asked for the document to use for the Mail Merge. You can use the current document, load a new document or use a template document. For the exercise, leave it at ‘Use the current document’. Click the next step ‘Select Recipients’.
The next step asks for a list of the recipients to include in your mail merge. You can use an existing list from a database, text document or spreadsheet, or create your own list. For the purposes of this exercise, you want to use the list (table), in the customer database. Note that you could also click ‘Browse’ here and navigate to the database. to perform the same operation as the next step. Leave the default option to ‘Use an existing list’ and click the next step ‘Write your letter’.
The ‘Select Data Source’ navigation box will appear asking you to select the data source. Navigate to where you saved your customer database and click . The ‘Mail Merge Recipients’ dialog box will appear. As the customer table is the only table in your database, it opens that table. Each record that has a tick beside it will be included and a letter will be generated for each customer.

To exclude a customer from the list, remove the tick beside their record. You could also sort the tables into different order. For example, if you wanted the letters printed in town order for delivery purposes, you could sort them by clicking the ‘City’ identifier. If you click the City identifier again, the table is sorted into reverse order. Click the button to close the Mail Merge Recipients box. Select the next step ‘Write your letter’.
As the letter is already written, you do not need to add anything. However, you do need to place the fields that you have imported on the letter in their correct positions. This is the procedure ‘add recipient information’.
Click in the document at the top and to the left, just below the graphic. This is where you will place the first field. It is easier to click where you want the fields to be placed before placing them, but they can be moved after if required.
Select the ‘More Items’ hyperlink from the wizard.
This will open the ‘Insert Merge Field’ dialog box. This dialog box shows the fields from the database table that can be inserted into the document. For the exercise, you do not need all the fields shown in here.
Click on the first field, ‘First Name’, and click the button. The field is placed into the document. Repeat the previous two steps for each of the remaining fields for the merge document - ’Last Name’, ‘Street’, ‘Address’, ‘City’ and ‘Postcode’. This will place them all in one line (which you will fix in a moment). See the graphic below.

To tidy the layout of the document, click between each of the fields and either press the or the key so the fields look like the graphic at right.
There is one more task to complete in this section. Use the technique just learned and insert the ‘First Name’ field after the word ‘Dear’. There is now enough information in the letter to continue. However you could continue to add fields to the letter if necessary. Select the next step ‘Preview the Letter’.
This step will show how the first of your merge letters will look. If the layout is not to your liking, select the previous step and adjust the letter. Note that you also have the option to display a particular recipient’s details or to modify the list. Also, the documents will not print with the grey backgrounds around the field names. Select the next step: ‘Complete the merge’.
In the last step you have the option to print all the documents or edit each document. For the exercise, don’t send them to the printer. Click the hyperlink to ‘Edit individual letters’.
The ‘Merge to New Document’ box appears. This box allows you to create a new document with separate pages for each recipient, create a new document for the current recipient or pick a range of recipients. For this exercise, leave the ‘All’ option selected and click . This should generate a new document called ‘Letters1’. The document should contain 6 separate pages, one for each recipient. Note that the content of each letter is the same, but the names and addresses have been inserted from the records in your database.

Exercise 1

in this exercise you create documents for medical histories kept on dogs at a Vet clinic. The dogs’ information is to be kept in an Access database. You will import the dog information from:

a text file to a table in Microsoft Access
the database table to a Word document.

You will also create an image to place on the top of the document. An example of a finished document is supplied.

Download the dogs.txt (Text document) file and save it on your hard drive.
Download the dog_history.doc (Word document) file and save it on your hard disk.
Download the finished.doc (Word document) file and save it on your hard disk.
Import the dogs.txt file into Microsoft Access as a table called ‘Dogs’. Note that the first row contains field identifiers. Save your database as ‘Dogs’ too.
Create an image using Windows Paint that could be used as a document header image for the Vet surgery.
Save the image as a bitmap or as a jpeg file if you have the option.
Open the Word document called dog_history.doc (downloaded earlier) and replace the first piece of red text with the image you created in the previous step.
Insert the fields from the dog table into the Word document.
Create a merge document for each of the dogs in the table.

This completes the reading, exercises and activities for this topic. If you are unsure about any of the concepts covered in these notes, please review the readings and complete the exercise and activities again. This should help you to understand how you can integrate the data and information from commercial computing packages.

I would delete this paragraph as it doesn’t add any new information.

reza restaurant

Tuesday, October 30, 2007

Integrate commercial computing packages

Information Technology

Integrate commercial computing packages

ICAITU013C

Introduction

Information Technology

Produce required organisational documents

Appropriate packages and conversion techniques are used to achieve an integrated outcome.

File extensions

Activity 1 – Saving a file and then opening it from Windows Explorer

Exercise 1

Saving documents in a different file format

Activity 2 – Saving documents with different extensions

Microsoft Word 1 - Save as a Works document

Microsoft Word 2 – Save as a Text document

Microsoft Excel – Save as a text document

Exercise 2

Exercise 3

File compression

Activity 3 – Using WinZip

Extracting files from an archive

Creating an archive

Exercise 3

File formats

Graphics formats

File formats

Exercise

Information Technology

Produce required organisational documents

Data is saved and re-accessed without loss of data

Storage media

Exercise 1

Using images in documents

Creating documents for use on web pages

Information Technology

Produce required organisational documents

Data is saved and re-accessed without loss of data

Storage media

Exercise 1

Using images in documents

Creating documents for use on web pages

Information Technology

Determine and use help

Help is accessed through online help and manuals

Using Help

Context sensitive help

Using the question mark icon

Using the built in help system

Searching Help

Using the Office Assistant

Information Technology

Determine and use help

Internal organisation client documentation is obtained and used

Mail Merge documents

Importing data into a table in a database

Activity 1 - Importing data into a database table

The Mail Merge wizard

Activity 2 – Doing a Mail Merge

Exercise 1

No comments:

Blog Archive

About Me