Hi:

Hands-on Final
==============
This is an open notes and open book exam, similar to
the midterm exam. It is not an open-neighbor exam! This
exam is comprehensive and will cover material discussed
throughout the course in labs and homework assignments. 
Be prepared!

Topics
======
This exam will focus primarily on the material from the midterm, however,
any topic covered this term is a possibility.

1) Know how to search for files and directories using the
archie tool.

2) Know how to transfer a file from an anonymous ftp site
to your PC or unix account. You should be versed in
several ways of doing this (for example, using WS_FTP
program or using Internet Explorer or ftp from the unix
prompt). Be sure you understand the differences in
transferring files from an anonymous ftp site and
transferring files between your PC and unix account.


3) If the transferred file is zipped, know how to unzip
it. If the unzipped file contains an executable file, be
able to execute the program. If the unzipped file is a text
file, or Excel file, or Word file, or Paint file or an image, 
or a ..., be able to open this file with the appropriate 
application program on your PC.

4) Be able to construct a nicely formatted spreadsheet (formulas and all) 
and an associated chart. 

5) Know how to telnet to a computer providing a service (for
example, see "Preparing for Lab 8" in the lab manual (visit the
Cleveland Net) or "Lab 8" (visit the Library of Congress or
United Nations). We will be doing more of this in 
next week's lab along with archie searches.

6) Be able to subscribe to a newsgroup, read an article, save it.

7) Know how to install an applet with or without parameters. Know how to
change parameters.



Written Exam
============
This is a closed book exam. It will be an objective
exam, True or False, Multiple-Choice, etc... . The exam
is scheduled in the same room where our lecture has 
been given.

I visualize the final written exam to contain sections (Windows NT, Word,
Excel, Web page construction (HTML), Web Browser related topics, Search
tools (archie, gopher, hotbot.com, ...), Newsgroups). 

Look over the quizzes. 

 You should know:

1) the commom unix commands we've been using this term
(for example, ls, cat, more, lpr, pwd, ...).

2) how to recognize a file by its extension and choose
the appropriate application program on your PC to open
the file (for example plan98.xls is an excel file,
funny.jpg is an image which can be viewed in a web browser,
huge.zip is uncompressed with WinZip).

3) know the meanings of terms used throughout the semester
(for example, folder = a place to store related files on disk;
url = universal resource locator is the unique address of a web
page; b2:f5 = a selected range of cells in Excel). You might want
to page through the lecture notes, I will make up my 
questions from these slides.

4) know the html codes we discussed this term. 

5) know how to compose a simple Excel formula from a group of cells
containing data (remember the lecture example: weekly pay). Note: you
should know +, -, *, / operations and some of the built-in functions
(for example, SUM(), AVERAGE(), IF()). Also know the difference between
relative, absolute and mixed addressing and how a copied formula looks in
the cell it was copied to.

6) know the archie commands (for example, find, set pager, ...).

7) know how to use email PINE (even sending and receiving attachments).

8) Did you ever see a children's puzzle showing several pictures 
depicting an action, where the pictures are scrambled and the child must
place the pictures in the correct sequence. I will do something similar
on the final exam testing if you understand the correct order in which
a task must be done. For example, Leo Doitright wants to draw a picture
in the Paint program and place it into a Word document he is creating
for school. Rearrange the steps below in the correct order (assume both 
Word and Paint are running):

> In Word, click the mouse to mark the place where the boat 
  will be inserted.
> In Paint, choose Copy from the Edit menu.
> In Paint, use the Selection tool to select the boat.
> In Word, choose Paste from the Edit menu.
> In Paint, draw a picture of a boat.

9) know the use of various utility programs: LView, telnet, archie,
gopher, veronica, RPos, WinZip, WS_FTP...

10) know about the major programs we used this term: Word, Excel,
PowerPoint, Paint, Notepad, ...

-GAN