Introduction

Purpose

Background

Activity 1
Components

Activity 2
Components

Conclusion/
References

Module Evaluation

 

 

Activity 2 Student Learning Strategies:

Purpose:
Creating Web pages that successfully communicate, educate, and entertain is a task considered highly essential in an ever-changing technological society. Nothing has captured the imagination and interest of the user more than the World Wide Web. Yet, this task causes many users to gain a sense of apprehension due to the “unknowns” or basics of creating a Web page. This fear often stems from unfamiliar software programs, which are sometimes confusing and non-user-friendly. Wouldn’t life be great if a user could create a Web page with a software program he/she already is familiar? Guess what, this is possible! Most users are unaware of the Web page capabilities of one of the most popular word processing programs used by millions world-wide. In other words, Microsoft Word can be used to create a simple Web page. Microsoft Excel can also be used to include interactivity in a Web page.

In this activity we will use Microsoft Word to create a simple Web page, and Microsoft Excel for the interactive element in the Web page. Integrating commonly used programs in which users are familiar, aids in the stimulation of interest and eases the apprehension of the user. As far as Microsoft Office 2000 is concerned, most applications included in the software package can be used quickly and easily to create Web pages simply by clicking the Save as Web page command on the File menu. Such software applications include Word, Excel, and PowerPoint. Microsoft Excel is a spreadsheet application used to solve problems that involve numbers. Besides hyperlinks, this is where the interactivity of the Web page becomes evident.

In the beginning, a common integration operation is to paste numbers from an Excel worksheet into a Word document. When the Excel data is copied to Word, it is then generated in table form. How is this interactivity included then you ask? Interactivity will occur through a process called linking. Copying and pasting the data frequently can be avoided through linking the two documents. In this process, data changed in the original file or Excel file (source file) is automatically updated in the Word file (destination file) to which it was copied. Using the Paste Special command from the Edit menu will perform the linking. When the data is linked, the information pasted into the destination file is connected to the information in the source file. Each time changes are made to the Excel file and saved; the changes are automatically reflected in the Word file when it is opened. This task is important for users to learn if a worksheet needs to be updated frequently and reflected in a report made in Microsoft Word.

Key Concepts
After this activity, students will be able to:

  • Define Excel, source file, and destination file
  • Create a basic Web page using Microsoft Word and previous knowledge
    of good Web design principles
  • Include interactivity in a Web page through the use of hyperlinks
    and Microsoft Excel
  • Link a source file with a destination file
Proceed to Activity 2 Student Procedure