Final Exam Grade Tabulator

Recall that a few weeks ago you had an assignment to use Microsoft Excel to write a spreadsheet which would determine what you need to make on the Final Exam in order to receive the grade you want from the course. If you want, you may download a version of that spreadsheet, the CIS 150 Final Exam Score Tabulator.

RECALL!!!!!!!!!

There are mistakes on Template 2 and Template 3 on the Spreadsheet Assignment. In Column H of Template 2, replace D with G, i.e. in all formulas, the final column in the sum should be G. So for instance, the formula in cell H5 should be =SUM(B5:G5). Also, in Template 3, the formulas should contain column E instead of D. So, for instance, the formula in cell F5 should be =SUM(B5:E5).

The Extra Credit Assignment

Due Date: Date of Final Exam

Recall that you have a chance to earn 5 extra points on your final grades.

This assignment is not required, but if you wish to do it, it will be worth 5% on your final grade.

This assignment is intended to introduce you to the creation of a web document.

The assignment is to create your own web page. You may create multiple pages if you wish. The following are requirements for your page.

  1. Your page must contain your name as the title. That is, when the page is viewed your name should be listed in the title bar of the browser. You may add more than your name if you want.

  2. Your page must contain at least 5 (five) paragraphs.

  3. Your page must contain at least one italicized phrase, at least two words which are boldfaced, and two words which are underlined.

  4. Your page must contain at least one word which is centered and at a larger font size than default.

  5. Your page must contain at least 2 (two) images. You may find an image on the World Wide Web or you may bring me photographs and a floppy, and I will scan the photographs for you and place them on the floppy.

  6. Your page must contain at least 5 (five) hyperlinks to other locations.

  7. Your page must contain some background image. You can find many to choose from on the World Wide Web. You must make sure that when you select a background image you also select an appropriate text color and link and visited link color.

  8. Your page must contain some tabular information. You may choose something like the example I gave.
The page should read like a normal report you would write. That is, don't just place these things somewhere in a document. Write the page like you would a standard report but use these things to enhance the report. You may use any other HTML code you wish .

Microsoft FrontPage Express

There is a web authoring tool which you may find useful. It is called Microsoft FrontPage Express. You may download it as part of the Internet Explorer from www.microsoft.com.

FrontPage Express is a tool which allows you to use a GUI to create and/or edit web pages.

When you start up FrontPage Express, you will see something similar to what you have seen in the other Microsoft products we have used. You will see a title bar, menu bar, etc. On the Menu Bar, you will find File. If you choose this menu item, the first option will be New...

When you choose this option, you will be presented with a choice of several templates and wizards. Two of the most useful to you will be Normal Page and Personal Home Page Wizard.

Normal Page

Normal Page is a template. It allows you to add things to a basic page, and then either publish it at a site or save it to a file.

Personal Home Page Wizard

Personal Home Page Wizard asks you a series of questions, and then builds a web page based on your answers. You can use this wizard to create a basic page, and then customize it according to your desires.

Now let us see how we accomplish some of the basic tasks in creating a web document. In the instructions that follow you must hit the OK button where appropriate in order for whatever you do to take effect in the page.

  • Titles

          When you save the document, you will be given a chance to give the page a title. You will recall that the title of a page appears in the title bar of the browser window.

          You may add other titles in your document. Recall that their different heading sizes for titles. If you click the down arrow in the box on the line directly below the Menu Bar, you will find a list. In this list you can choose the heading size you want. After you choose this heading size, it will be in effect until you change it to another size.

  • Background Images

          Go to the Format Menu, and select Background... Choose the Background tab. Click the checkbox beside Background Image and then in the box below list the name of the image.

  • Background Colors, Text Colors, and Link Colors

          Go to the Format Menu, and select Background... Choose the Background tab. Make sure that the checkbox beside Background Image is not checked. Click the down arrow in the box next to Background: and choose the background color you want to use. You can do the same thing for text colors and link colors.

  • Centering Text

          Choose the paragraph you wish to center. Go to the Toolbar directly below the Menu Bar. Click the Center Icon.

  • Enhancing Text

  • Inserting Images

          Move the cursor to the place in the document where you want to insert the image. Go to the Insert Menu and choose Image... Choose the Other Location tab. If you want to insert an image which is on the hard drive, then select the button beside From File. If you want to put an image in that is located at a URL, then select the button beside From Location. Choose the image you want to insert.

  • Inserting Hyperlinks

          Move the cursor to the place in the document where you want to insert the hyperlink. Go to the Insert Menu and choose Hyperlink... Choose the World Wide Web tab. Choose the protocol of the hyperlink. Then give the URL.

  • Tables

          Move the cursor to the place in the document where you want to insert the table. Go to the Table Menu and select Insert Table... Choose the parameters for the table. You can choose the number of rows and columns. Also you can choose whether or not you want a border displayed. If you choose a border size of 0, then no border will be displayed.

  • Line Breaks

          Move the cursor to the place in the document where you want to insert the break. Go to the Insert Menu and choose Break... Select the button beside Normal Line Break.

  • Horizontal Lines

          Move the cursor to the place in the document where you want to insert the horizontal line. Go to the Insert Menu and choose Horizontal Line.

    Saving your document

    If you are trying to publish your page on a site at which you have the ability to use ftp, then you may save your page directly to the site. If not, then you must save your document on the hard drive, and then upload it to the site.

    If you are using a site at which you have ftp access, then go to the File Menu and select Save or Save As (depending on whether or not you have given the document a name yet). You will be prompted for the document title. Also you will be prompted for the URL where you want the document to be saved.

    If you are using a site at which you don't have ftp access, then go to the File Menu and select Save or Save As (depending on whether or not you have given the document a name yet). Click the button that says As File... Then choose the directory where you want to place the file. You can also give the document another name if you want.

    Final Extra Credit Assignment of the Semester

    This assignment is worth up to five (5) points added to your score on the final exam.

    In order to receive the points, the assignment must be completed and turned in tonight.

    Recall that last class you went on sort of a scavenger hunt. Tonight you will get a chance to try again. For this scavenger hunt, you are trying to locate the answers to the following questions.

  • How old was Evariste Galois when he died, how did he die, and who was he?

  • Where was Agatha Christie born?

  • Approximately how much would it cost to take a trip to the Ross Ice Shelf in Antarctica?

  • How much would the following pets cost?
  • How large is the country of Mongolia, what is its climate, what are one of its natural resources, and what is its population?

  • Who are seven (7) British Guitar Legends?

  • What is Bathymetry?

  • What is the Marianas Trench, where is it located, and how deep is it?

  • What are the names of five (5) hard cheeses?

  • How late will the Woodson Regional Library Computer Center in Chicago, Illinois be open tonight, and how does one get a Chicago Public Library Card?

    In addition to answering these questions, find the home pages of at least five (5) people you have never heard of, and locate at least two pictures of the outdoors (mountains, oceans, etc.)

    The Assignment

    1. Take the answers to the above questions and compile them into at least two paragraphs of narrative. You should pretend that you have a profound interest in these questions and make your paragraphs as interesting as possible. Creativity will count in the number of extra credit points you recieve.

    2. Along with the paragraphs, put hyperlinks to the five people you found, and place the images you found into the document. Pretend that these are five close friends with whom you share professional interest. It would be helpful if you tried to find images that go along with your paragraphs.
    If you have a geocities site, upload the HTML document there. (One additional point for doing this.) If you do not have a geocities site, then view the HTML code in a browser, and print out the page. If you want, you may also place the HTML document on a floppy and turn it in.