WILLIAM PATERSON UNIVERSITY OF NEW JERSEY
SCHOOL OF SCIENCE AND HEALTH
Computer Science Syllabus and Outline
Course: CS210-01, Advanced Microcomputer Applications
Monday-Wednesday 8:00 AM - 9:15 AM, Y123B
Instructor: Dr. John Najarian, Assoc. Prof. of Computer Science
Office: Coach House 205, Tele. (973)-720-2952
Office Hours: Monday & Wednesday 9:30AM-10:45AM
Tuesday 5:00PM-6:45PM & also by appointment.
Last day for course withdrawal 10/22/98. Classes: 9/2/98-12/10/98.
Holidays: 9/7/98 LD, 11/26/98-11/29/98 TGD
Final Exam. Period: Monday, 12/14/98, at 8:00AM-10:30AM
Class Rules:
1. Attendance will be recorded. Departmental guidelines require
that: 3 absences (2 for night) ---> departmental warning letter
7 absences (4 for night) ---> automatic failure in course
Only valid excuses (in writing) allay these consequences.
Attendance and success coincide.
2. Projects will be collected as scheduled.
3. All quizzes will be announced at least one full week in advance.
If you are absent on the day a quiz is announced, you are
responsible for finding out about it from a fellow student or
the professor. No make-up exams will be given except for
extraordinary circumstances.
4. Bring the specified textbook to each class session.
5. Before lab sessions, read relevant text to optimize productivity.
6. Final Grade = Projects (25%) + Average of 3-5 Quizzes (75%)
Objective of Course:
CS 210 Advanced Microcomputer Applications (Course Description)
This course introduces advanced-level topics in microcomputer
applications. Topics include state-of-the-art software packages
in the area of data communication (via Internet/Web), software
integration & CD-ROM applications, web-page design and management,
graphics, audio, multimedia, virtual reality construction,
presentation design, desktop publishing, database management, and
if time permits, scripting/web-programming basics.
Building upon the experience developed in CS 201 (Computer
Literacy & Microcomputer Applications), the CS 210 software
packages include: Microsoft Windows 98/NT, web-browsers, Paint,
Microsoft Photo-Editor, Wang's Image Editor, other Windows
graphics applications (Corel Draw, Paintshop Pro), GIF animators,
sound editors, VRML editors, several HTML editors,
MS Powerpoint, Aldus Pagemaker, and MS Access.
Brief presentations of theory and demonstrations followed by
intensive hands-on PC sessions characterize this course.
Projects supplement and reinforce these learning activities.
A holistic appreciation of PC graphics, desktop publishing,
databases, windowing integrated applications environments,
utilities, and connectivity to the Internet should result
from this process. Hardware is to be reviewed but only in the
context of these applications. While productivity is a goal,
exploration and discovery should be the spirit in which we
endeavor.
Session & Topic (Tentative Schedule) Chapter
------------------------------------ -------
1 Introduction Grauer Appndx
2 Windows: Fundamentals of Usage, Defaults, & Help; Grauer Appndx
"A Tale of Mice and Menus"
Applic. Launch., Multitasking, Networking
3 Windows: Configuration, Program Execution, Grauer Appndx
The Internet (web http vs chat vs e-mail
vs ftp vs telnet vs usenet)
Experiment with it (NT Communications Tools
Web-Browsing Oliver App. C
4 Web Browsing vs Web Capturing
Modes of Execution and Installation
5 Web Page Design: Basics & Web Editing in MS Word Oliver
Web vs True-Type Fonts, Word-Art, adding
graphics, http links and e-mail links
6 Web Page Design: Reverse engineering with Notepad, Oliver App. A&B
Reading HTML, basics of HTML writing
7 Web Page Design: Tables, frames, forms, ... Oliver
Using other Webpage editors and managers
8 Web Page Design: Adding sound and multimedia Oliver
9 Web Page Design: VRML and Virtual Reality Oliver
10 Web Page Design: Using Java Applets and modern mod Oliver
11 Quiz # 1 (Windows NT/98 & Web Page Publishing)
12 Graphics: (Paint) Drawing/Painting Basics
(Corel Draw 7) Drawing Tools
12 Imaging for Windows NT (Wang): Standard Package
Microsoft Photo-Editor, LVIEW, Paintshop Pro,
Corel Draw, Graphics file formats & types
13 Presentation Design: Powerpoint Fundamentals, Murphy
slides, using wizards & templates,
14 Presentation Design: Formatting, tables, charts Murphy
adding graphics, transitioning & timing,
15 Presentation Design: Adding animations and Murphy
professional delivery/interaction features
16 Review
17 Quiz # 2 (Graphics and Presentation Packages)
18 Pagemaker: Fundamentals, DTP Concepts
Graphics Files (EPS, TIFF, ...) & PCL, PS, PDF,...
Creating, Importing & Manipulating Graphics/Pagemaker
19 Pagemaker: Text-Oriented Operations, Letterhead
Design, Ads, Business Forms, Menus
20 Pagemaker: Layout Decisions & Effective Pub.
21 Pagemaker: Newsletters, Brochures and Fliers
Adding Special Effects, Bulletins
22 Quiz # 3 (Desktop Publishing)
23 ACCESS: Concepts, Menus, Env., Grauer 1
24 ACCESS: File Creation, Tables, Decisions, Queries, Grauer 2
Report generation
25 ACCESS: One-to-Many Relationships, Subforms, ... Grauer 3
27 ACCESS: Many-to-Many Relationships, Advanced Queries Grauer 4
28 ACCESS: Interface design, macros, Grauer 5
29 ACCESS: Prototyping Grauer 5
30 Quiz # 4 (Access and Relational Databases in Office 97)
31-32 Optional Topics
Several handouts will be distributed during the semester.
Required Texts:
1. Grauer, Robert T. & Maryann Barber [1998]
"Exploring Microsoft Access 97", Prentice-Hall, 0-13-754227-5
2. Murphy, Patricia [1998] "QuickTutorial in Microsoft
Powerpoint 97", South-Western, 0-538-96432-1
3. Oliver, Dick [1996] "Web Page Wizardry", SAMS.net, 1-57521-092-4
4. Handouts
5. 3.5" High Density floppy diskettes (1.44 MB Formatted) will be
supplied by the department and distributed.