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.