CS 107

Fall Semester 2004

Section 51

Assignments

I hear and I forget, I see and I remember, I do and I understand

Ancient Chinese Proverb

UNH Home Page Computer Science Department Home Page Contact Instructor

Course Home Page

Syllabus

Lectures

Please check this page frequently as assignments will be updated frequently throughout the semester !

E-mail assignments should be submitted, as an attachment, to Sue@ox.ttsw.com

All assignments must include a header with the following information:

  • Student's Name
  • Course and Section
  • Assignment name
  • Due date

Information on creating a document header

Chief Assignment Monitor

Weekly Readings in Computer Confluence

Students should review all readings prior to attending class. Students are expected to know/understand all key terms at the end of each chapter and be able to define each term in the student's own words. A good aid for a student to test his/her knowledge are the self tests for each chapter that can be found on the CD-ROM which accompanies the textbook.

Weekly Article Synopsis

Students are expected to read one current computer related article from a newspaper, a magazine, or an online source each week. A well crafted page, written in the student's own words, summarizing the article must be turned in to the instructor at the start of each class. Please see specifications for article synopsis for more information.

Hands-On Work

In the hands-on portion of the class, each student will be working on assignments from Office XP - Volume 1. In addition to classroom work, students will also have a weekly assignment to be completed outside of the class.

Students must come to class prepared. This means that each student must have a copy of the files that are needed for the exercises that will be done in the class. Students not prepared for class will be asked to leave the class until they are prepared.

Please check this page each week for an updated list of the files needed for the hands-on portion of each class.

Week - Date Lecture Topic Software Exercises
One - September 7 Course Intro & Expectations
Living in an Information Society

Textbook Topics: Computer Basics; Computer Currents: From Calculation to Connection; Computers at School, Work, and Home
Reading: Computer Confluence - chapter 0 and 1, Chapter 11
Assignment: CC Assignment 1
Due Date: September 14

 The Windows Operating System
File Management
Using a Web Browser
E-mail

Files for in-class work: Windows XP Pretest
Assignment: Download the files needed for this class;
XP Assignment 1; Look over section WD-1 Introducing Word 2002
Due Date: September 14

Just for Fun Task:

Find a web site showing Bill Gate's mug shot and print out the picture. When was he arrested and what was he arrested for?
Two - September 14 Hardware - Computer Physical Components: The Brain of the Computer

Textbook Topics: Hardware Basics: Inside the Box
Reading: Computer Confluence - chapter 2
Assignment: CC Assignment 2
Due Date: September 21, 2004

Microsoft Word - Creating Documents; Editing and Formatting a Document

Files for in-class work: Word Data Files, Project_01 and Project_02
Assignment: pgs. WD 1-41-44, Guided Exercises 1 and 2; pgs. WD 2-4 to 2-53, Project 2. Try to get as far with this exercise as possible. Bring it to class to finish on Tuesday.
Due Date: September 21, 2004

Just for Fun Task:

Find the Blog or Forum on the Net where the alleged CBS document forgery was first uncovered
Three - September 21 Hardware - The Stuff Outside of the Box
Textbook Topics: Hardware Basics: Peripherals
Reading: Computer Confluence - chapter 3
Assignment: CC Assignment 3
Due Date: September 28, 2004 		Microsoft Word - Creating a Brochure;
We will be completing project 2 and starting project 3. Please be sure to bring the files for project 4 even though we may not get to it.

Files for in-class work: Word Data Files, Project_02, Project_03, Project_04
Assignment: pgs. 2-58 - 60, Guided Exercies 2 and 4; pgs. WD 3-44-45, WD 3-48-9, Guided Exercises 1 and 4;
Due Date: September 28

Just for Fun Task:

What is the "Click of Death?"
Four - September 28 What Makes the Computer Go
Textbook Topics: Software Basics: The Ghost in the Machine
Reading: Computer Confluence - chapter 4		 Microsoft Word - Working with Multipage Documents

Files for in-class work: Word Data Files, Project_04
Assignment: pgs WD 4-39-42, Guided Exercises 1, 2, and 4
Due Date: October 5

Just for Fun Task:

What was Microsoft's first software product? (and on what medium was it distributed)"
Five - October 5

Exam 1

Covering: Computer Confluence - chapters 1 through 4; and 11
Test #1 - Review 		Microsoft Word - Creating a Table

Files for in-class work: Word Data Files, Project_05
Assignment: WD 5-40-41, Guided Exercises 4
Due Date: October 12

Just for Fun Task:

In 1984 the Macintosh computer with a Graphical User Interface was introduced. The Mac GUI was based on what?
Six - October 12 What Can a Computer Do?
Textbook Topics: Basic Office Applications
Reading: Computer Confluence - chapter 5		 Microsoft Word -

Files for in-class work:Word Project_06
Assignment: pgs. WD 6-41-44, Guided Exercises 2 and 4
Due Date: October 19
Seven - October 19 Make It Sing, Make It Dance
Textbook Topics: Graphics, Digital Media, and Multimedia
Reading: Computer Confluence - chapter 6		 Microsoft Excel - Designing and Creating a Worksheet; Formatting Worksheets

Files for in-class work: Excel Data Files, Project_01 and Project_02
Assignment:
Due Date: October 26
Eight - October 26 Taking Care of Data
Textbook Topics: Database Applications and Implications
Reading: Computer Confluence - chapter 7		 Microsoft Excel - Analyzing and Distributing Worksheet Data

Files for in-class work: Excel Data Files, Project_03
Assignment:
Due Date: November 2
Nine - November 2 Surfers Meet the Spider
Textbook Topics: Networking and Telecommunications; Inside the Internet and the World Wide Web
Reading: Computer Confluence - chapter 8 and 9		 Microsoft Excel - Working with Workbooks

Files for in-class work: Excel Data Files, Project_04
Assignment:
Due Date: November 9
Ten - November 9

Exam 2

Covering: Computer Confluence - chapters 5 through 9 		Microsoft Excel - Using Financial Functions

Files for in-class work: Excel Data Files, Project_05
Assignment:
Due Date: November 16
Eleven - November 16 Viruses, Hackers, and Worms - Oh My!
Textbook Topics: Computer Security and Risks
Reading: Computer Confluence - chapter 10		 Microsoft Access - Introducing Access; Creating Basic Access Objects

Files for in-class work: Access Data Files, Project_01 and Project_02
Assignment:
Due Date: November 23
Twelve - November 23 Taking Care of Business
Textbook Topics: Information Systems in Business; Electronic Commerce and E-Business
Reading: Computer Confluence - chapter 12 and 13		 Microsoft Access - Manipulating Table Data

Files for in-class work: Access Data Files, Project_03
Assignment:
Due Date: November 30
Thirteen - November 30 Making the Computer Do What We Want It To
Textbook Topics: System Design and Development
Reading: Computer Confluence - chapter 14		 Microsoft Access - Modifying Tables and Establishing Relationships

Files for in-class work: Access Data Files, Project_04
Assignment:
Due Date: December 7
Fourteen - December 7 Thinking Machines
Textbook Topics: Is Artificial Intelligence Real?
Reading: Computer Confluence - chapter 15		 Microsoft Access - Creating Queries

Files for in-class work: Access Data Files, Project_05
Assignment:
Due Date: December 21
Fifteen - December 14 Reading Day No Class

Final Exam

 December 21
Last Updated: 9/2/04