| |
CS 210 Advanced Microcomputer Applications
Spring '98 Assignment Projects
Please formulate, design, type, and print the following
project documents. On each
document, include NAME, "CS210", the PROJECT
NUMBER, and date. Print a copy
of each project for both professor and student. Also,
keep a diskette copy just in case
and also backup your diskettes. The projects will total
to 25 points on the final grade.
Projects should satisfy the constraints and
specifications of the problem set below.
Grades will be determined by correctness of the final
document and its adherence to the
description of the problem. Form, content, and other
characteristics determine
correctness. Only hardcopy outputs from the computer will
be accepted. Best wishes!
Project 1: Web Page Design (Microsoft
Word '97)
After looking at many Web pages and their
source-file, make your own Web page using
Microsoft Word (using the "save as HTML" option
to induce the desired context-sensitive
menus).
Personalize it and make sure to include your name and the
page's purpose and/or your
interests. Include some text, a graphic image (GIF or
JPEG), one hyperlink (to a Web
page of interest), and an e-mail link. Use a nicely
textured background. Remember that
people often are judged by the first impression they
make, so let yours be a positive,
impressive one. Use of HOT-DOG, HOT-METAL, or any other
HTML editing tool is
permitted as an alternative to MS Word. Your final
documents must include both your
source-file (HTML text file) and the Netscape image
produced by it (no credit for
source only). (2 points)
Project 2: Web Page Design (Tables and
Lists)
Construct a web page that includes tables and lists.
In the table, include images and links.
Hand in HTML and Netscape image. These are examples of
textual structures used to
organize information in a large scale. (2 points)
Project 3: Low-Volume Animation
(Animated GIFs)
From the Oliver CD, install WINZIP and install the
GIF Construction Set (if you like
them, you may register for the products at home). Observe
some animated GIFs in the
Oliver text CD and many others on the Web (use a search
engine to find sites with
collections). Note that they are applied in 3 ways
primarily:
Your project is to apply at least one of these
methodologies, producing an animated GIF
with at least four frames (images). You may use
Paint or Paintshop-Pro from the CD.
Insert them into a simple web page, even one that just
has the HTML to display the
image. Your results should be on floppy and will be
graded on site. (2 points)
Project 4: AVI Animation
From the Oliver CD, access the lobster AVI and
practice inserting
it into a simple web page. Observe in Netscape, using
mouse clicks to
progress in the frames. Now for the real project. Grab an
AVI from
the Web (since we don't have access to video equipment or
cameras).
Some useful sites are:
Http://www.microjack.com/vc-pci1.htm
Http://geocities.com/Hollywood/Theater/6090/multimedia.html
Http://www.chrispappas.com/animation.html
Http://lonestar.rcclub.org/~sphillip/videoavi.html
Http://ourworld.compuserve.com/homepages/esmsoftware/avilink.htm
Http://www.nogatech.com./html/sampleavi.html
http://www.realvision.com/soundvideo.htm
Http://www.bluegrassduets.com/bluegrasspage/guguclip02.AVI
Http://www.madisonfilm.com/demo.html
Insert them into a web page you design and receive credit
on site.
Oliver's text provides greater detail on the process.
Be patient, since some plug-ins may be missing on these
workstations. (1 Point)
Project 5: VRML Virtual Reality Read
Oliver, chapters 9 and 10. Construct a
VRML file which describes a house or building. Get
insights from the text, in which
Oliver develops a virtual bank. Print the VRML file
(text) and the image generated in
Netscape. You may want to sketch it on paper first. (2
points)
Project 6: Database Introduction Read
Grauer, chapter 1. Conduct exercises 1 (pages 6-12) and 2 (pages 17-25)
in the chapter 1, but with no print-outs as these are practice activities.
Proceed to pages 33 and 34 to complete and hand-in problems 3 and 4. (2
points)
Project 7: Databases: Tables, Forms, and Wizards Read
Grauer, chapter 2. Conduct exercises 1 (table design, pages 44-52),
2 (forms design,pages 58-67), and 3 (advanced form design, pages 68-77).
in the chapter 2, but with no print-outs as these are practice activities.
Proceed to pages 83 and 84 to complete and hand-in problems 4 and 5.
To complete problem 5, use pictures of random people off the Internet. This
last phase may take time so this may require some out-of-classroom effort.
(2 points)
Project 8: Database: Reports and Queries Read
Grauer, chapter 3. Conduct exercises 1 (report wizard, pages 93-100),
2 (queries, pages 106-113), and 3 (grouping records, pages 115-126).
in the chapter 3, but with no print-outs as these are practice activities.
Proceed to pages 130-131 to complete and hand-in problems 3 and 4.
(2 points)
Project 9: Database: One-to-Many Relationships Read
Grauer, chapter 4. Conduct exercises 1 (1-to-many relations, pages 142-148),
2 (subforms, pages 152-160), 3 (2-table queries & reports, pages 163-170),
and 4 (linked subforms, pages 173-180) in the chapter 4, but with no
print-outs as these are practice activities.
Proceed to pages 183-184 to complete and hand-in problems 1 and 2.
(2 points)
Project 10: Database: Many-to-Many Relationships Read
Grauer, chapter 5. Conduct exercises 1, 2, 3, 4, but with no
print-outs as these are practice activities.
Proceed to pages 243-244 to complete and hand-in problem 1 for 2 point credit.
(2 point)
Project 11: Database: Macros & Prototyping Read
Grauer, chapter 6. Conduct exercises 1, 2, 3, 4, but with no
print-outs as these are practice activities.
Proceed to pages 304-305 to complete and hand-in problem 4 for 2 point credit.
(2 point)
Project 12: Powerpoint Presentation Read
Murphy, chapter 1-7. Conduct all exercises but with no
print-outs as these are practice activities.
Proceed to make a Powerpoint presentation, using at least
five slides. Use at least 3 pictures. The first slide is
a title and a table of contents. Make the full contents
meaningful and professional. Length = 100 - 300 words.
Use good layout and effects.
(4 point)
More to come.
Best of prospects in your endeavors!
|