| |
WILLIAM PATERSON UNIVERSITY OF NEW JERSEY
COLLEGE OF SCIENCE AND HEALTH
Computer Science Syllabus and Outline
|
| 1, |
Course: CS210-01 Advanced Microcomputer Applications, 3
credits |
| 2. |
Department secretary: Carol Parken (Coach House 120) can be contacted
by telephone at (973)_720-2649 and by e-mail at ParkenC@wpunj.edu. |
| 3. |
Semester offered: Fall 2000
Time: Monday-Wednesday 12:30 PM - 1:45 PM
Location: Coach House Y123B |
| 4. |
Faculty: Dr. John Najarian, Assoc.
Prof. of Computer Science
Office: Coach House 205, Phone: (973)-720-2952,
E-mail: najarian@cs.wpunj.edu
Office Hours: Monday 2:00 PM - 6:55 PM, Wednesday
11:00 AM-12:15 PM,
and by appointment. |
| 5. |
Required Texts (2):
Grauer, Robert T. & Maryann Barber [1998] Exploring
Microsoft Access 97",
Prentice-Hall, ISBN 0-13-754227-5
Murphy, Patricia [1998] QuickTutorial in Microsoft Powerpoint
97, South-Western,
ISBN 0-538-96432-1
Required Web Material:
HTML
& Javascript Slides:
http://www.cs.bc.edu/~perezab/mc021/Assignments.html
Powerpoint Free Viewer
http://officeupdate.microsoft.com/2000/downloadDetails/Ppview97.htm.
HTML
Tutorial at: http://www.pagetutor.com/pagetutor/makapage/
Free Dreamweaver Trial Version:
http://www.macromedia.com/software/dreamweaver/download/00_download.html
Access 97 Student Data-disk and Powerpoint lectures on Access:
http://www.prenhall.com/grauer/win98/student.html
(more to be appended)
Suggested Further Readings: (not required)
Bradley, Julia, Floyd, Rittman,
& Sherman [1997] Desktop Publishing with
Pagemaker,
Irwin/McGraw-Hill
Duffy, Tim [2000], Microsoft Access
2000, Prentice-Hall
Duffy, Tim [1999] Microsoft Access 97,
Blue Ribbon Edition, 2/e
Holzschlag, Molly E. [1996] Professional
Web Design, (w/CD), Prima Publishing
Hubbell, Arlyn, [2000] Understanding Web Development
Interactive Workbook,
Prentice-Hall
Oliver, Dick [1996]
Web Page Wizardry, SAMS.net.
Ray, Deborah S. and Eric J. Ray [1997]
Mastering HTML 4.0 (/w CD ROM), Sybex
Other Material for Study (not required):
|
| 6. |
Course Objectives:
This course introduces advanced-level topics in microcomputer applications
and extends student knowledge and capabilities in working with microcomputers
and their software.
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.
|
| 7. |
Student learning outcomes:
-
Students will demonstrate a solid understanding of
advanced applications and aspects of computers far-beyond the scope of
CS201.
-
Students will produce professional level web page
design and support, including HTML, Javascript, elementary pre-designed
Java-applets, virtual-reality-based page modeling, and other methodologies.
-
Students will be capable of image processing/enhancement
and graphics design up to and including animation construction and multimedia
incorporation.
-
Students will demonstrate the ability to analyze
case study problem situations, prepare strategies for and complete the
full composition/setup/implementation and management of relational databases.
-
Demonstrate the ability to think critically and solve
problems in the design process..
-
Demonstrate the ability to integrate knowledge and
ideas in a coherent and meaningful manner. The documents they produce
will include content from several sources and their incorporation into
effective entity and subsequent exposition, thereby addressing the next
learning outcome (cited below).
-
Effectively express themselves in written and oral
form. In particular, students will give presentations using Powerpoint
slides they researched and designed.
|
| 8. |
Topical outline of the course content (Tentative Schedule)
Chapter
| 1 |
Introduction |
Grauer Appdx. |
| 2 |
Windows: Fundamentals of Usage, Defaults, & Help;
Applic. Launch., Multitasking, Networking,
Document-centrism |
Grauer Appndx |
| 3 |
Windows: Configuration, Program Execution, The Internet (web http vs
chat vs e-mail vs ftp vs telnet vs usenet). Experiment with it (NT communications
tools, HTTP, Web-Servers, Web-Browsing |
Grauer Appndx
and powerpoint
slides |
| 4 |
Basics of HTML (reading and writing in tags), Web Page Design:
Reverse engineering with Notepad, Handouts, HTML attributes, lists,
working with graphics files (GIF, JPEG,...), hyperlinks, ... |
Powerpoint slides
and
Tutorial pages |
| 5 |
Web Page Design: Basics & Web Editing in MS Word, Web Browser
based vs True-Type Fonts, Word-Art limitations, conditions for adding
graphics, extending http links and e-mail links |
Powerpoint slides
practice, and
Tutorial pages |
| 6 |
Web Page Design: tables, frames, forms, ... using Netscape Composer |
Powerpoint slides |
| 7 |
Web Page Design: Tables, frames, forms, ... using Arachnophilia,
DreamWeaver (trial), and other Webpage editors and managers |
Powerpoint slides
and practice |
| 8 |
Web Page Design: Adding Animation, Sound, and Multimedia
Using GIFcon and other facilities.
Other animation and video file types. |
Powerpoint slides
and practice |
| 9 |
Web Browsing vs Web Capturing (site-snagger, webwhacker, ...) |
Handouts |
| 10 |
Javascript: Part 1 |
Powerpoint slides
and practice |
| 11 |
Javascript: Part 2
Web Page Design: Using Java Applets and modern modes |
Powerpoint slides
and practice |
| 12 |
Web Page Design: VRML and Virtual Reality |
Powerpoint slides
and practice |
| 13 |
Quiz # 1 (Windows NT/98, the Internet, & Web
Page Publishing) |
Handouts |
| 14 |
Graphics: Painting Basics, (Corel Draw 7) |
Handouts |
| 15 |
Graphics: Imaging for Windows NT (Wang): Standard Package, Microsoft
Photo-Editor, LVIEW, Paintshop Pro, Corel Draw,
Graphics file formats & types |
Handouts |
| 16 |
Animation File Types, Design, and Support |
Handouts |
| 17 |
Presentation Design: Powerpoint fundamentals, slides, using wizards
& templates |
Murphy |
| 18 |
Presentation Design: Formatting, tables, charts adding graphics, transitioning
& timing |
Murphy |
| 19 |
Presentation Design: Adding animations and professional delivery/interaction
features |
Murphy |
| 20 |
Powerpoint: Advanced Issues |
Handouts |
| 21 |
Quiz # 2 (Graphics and Presentation Packages) |
|
| 22 |
DTP with Pagemaker: Fundamentals, DTP Concepts Graphics Files (EPS,
TIFF, ...) & PCL, PS, PDF,... Creating, Importing & Manipulating
Graphics/Pagemaker |
Handouts |
| 23 |
DTP with Pagemaker: Text-Oriented Operations, Letterhead Design, Ads,
Business Forms, Menus
Pagemaker: Layout Decisions & Effective Pub. |
Handouts
|
| 24 |
Pagemaker: Newsletters, Brochures and Fliers Adding Special Effects,
Bulletins |
Handouts
|
| 25 |
Quiz # 3 DTP with Pagemaker |
|
| 26 |
ACCESS: Concepts, Menus, Env., |
Grauer 1 |
| 27 |
ACCESS: File Creation, Tables, Decisions, Queries, Report generation |
Grauer 2 |
| 28 |
ACCESS: One-to-Many Relationships, Subforms, ... |
Grauer 3 |
| 29 |
ACCESS: Many-to-Many Relationships, Advanced Queries |
Grauer 4 |
| 30 |
ACCESS: Interface design, macros, |
Grauer 5 |
| 31 |
ACCESS: Prototyping |
Grauer 5 |
| 32 |
Quiz # 4 (Access and Relational Databases in Office 97) |
|
|
| 9. |
Teaching methods (e.g., lecture, discussions, presentations, etc.)
-
Brief presentations of theory, lectures, and demonstrations followed by
intensive hands-on PC sessions characterize this course. Students
get to discuss strategies and work in groups in the development process.
-
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.
-
Projects are assigned for students to develop professional web pages, construct
animations, and conduct design decision making at the level of applications
usage and integration. These are for completion in the lab after class
hours.
Readings are assigned and Internet inquiries are formulated to give
students current knowledge of the field.
|
| 10. |
Course expectations:
a. Reading Assignments
Item 8 (above) addresses the reading
schedule issue.
b. Tentative timeline for submission of written assignments
or other work
Projects
will be collected as scheduled with a grace period of one week.
c. Attendance
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.
d. Participation in out-of-class activities (e.g. workshops,
performances, etc.)
Not Applicable
e. Examinations (tentative dates, make-up policy,
etc.)
All exams will be announced at
least one full week in advance.
If you are absent on the day an
exam 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.
Item 8 (above) addresses the examination
schedule issue.
Final Exam. Period: Wednesday
12/20/2000
at 11:00am-1:30pm, Y123B.
f. Class participation
Bring the
specified textbook to each class session.
Before
lab sessions and lectures, read relevant text to optimize productivity. |
| 11. |
Grading and other methods for assessing student academic performance
-
Four examinations, the culminating one being a final examination.
-
Weekly projects with submitted documents, graphic works, or reports near
professional expectation levels.
-
Computation: Final Grade = Projects (25%)
+ Average of 3-5 Quizzes (75%)
|
| 12. |
Additional information:
Last day for course withdrawal 10/24/2000.
Classes will be in session from 9/5/2000 to 12/14/2000.
Holidays: 11/23-26/2000 Thanksgiving Day
Tutorial support is provided by CS Dept. tutors, STC's, and Academic
Support Center. |