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 [email protected]

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 Exercises 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
Assignment: Computer Confluence, p. 197, Discussion Questions #1 and #2
Due Date: October 19, 2004
Microsoft Word - Merging Documents

Files for in-class work:Word Project_06
Assignment: pgs. WD 6-41-44, Guided Exercises 2 and 4
Due Date: October 19, 2004

Just for Fun Task:

What do these two pictures represent: http://www.bfec.us/bfecpho26_3.jpg and http://ttsw/SuesClasses/jpf5.gif
Seven - October 19 MultiMedia, Graphics - Hypermedia to Virtual Reality
Textbook Topics: Graphics, Digital Media, and Multimedia
Reading: Computer Confluence - chapter 6
Assignment: Computer Confluence, p. 233, Discussion Questions #1 and #2
Due Date: October 26, 2004
Microsoft Excel - Designing and Creating a Worksheet; Formatting Worksheets

Files for in-class work: Excel Data Files, Project_01 and Project_02
Assignment: pgs, EX 1-26, Guided Exercise 2, pgs, EX 2-31 & 2-32, Guided Exercises 3 and 4
Due Date: October 26

Just for Fun Task:

What is this man doing and what year is he doing it in?
Eight - October 26 Mining for Trend
Textbook Topics: Database Applications and Implications
Reading: Computer Confluence - chapter 7
Assignment: Computer Confluence, p. 265, Crosscurrents - Privacy and Security: Finding a Balance - Discussion Questions #1 and #2
Due Date: November 2, 2004
Microsoft Excel - Analyzing and Distributing Worksheet Data

Files for in-class work: Excel Data Files, Project_03
Assignment: pgs. Ex-3-39 to Ex-3-43, Guided Exercises 1 & 2
Due Date: November 2

Just for Fun Task:

Which presidential candidate has the most experience to be in charge of Data Warehousing at a company?
You may wish to look beyond the two front runners
Nine - November 2 The Spider's Web
Textbook Topics: Networking and Telecommunications; Inside the Internet and the World Wide Web
Reading: Computer Confluence - chapter 8 and 9
Assignment: Computer Confluence, p. 339, Crosscurrents - Info with a Ball and Chain - Discussion Questions #1 and #2
Due Date: November 16, 2004
Microsoft Excel - Working with Workbooks

Files for in-class work: Excel Data Files, Project_04
Assignment: pgs. 4-33 - 4-38, Guided Exercises 1, 2, 3, and 4
Due Date: November 9

Just for Fun Task:

What is the Top Level Domain for the following Countries:
Antartica, Reunion Island, Heard and McDonald Islands, Christmas Island, and Mayotte
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:pgs. 5-35 - 5-39, Guided Exercises 1, 2, 3, and 4
Due Date: November 16


Eleven - November 16 Viruses, Hackers, and Worms - Oh My!
Textbook Topics: Computer Security and Risks
Reading: Computer Confluence - chapter 10
Assignment: Computer Confluence, p. 381, Discussion Questions #3 and #4
Due Date: November 23, 2004
Microsoft Access - Introducing Access; Creating Basic Access Objects

Files for in-class work: Access Data Files, Project_01 and Project_02
Assignment:pgs. AC 1-29 - 1-34, Guided Exercises 1 and 2; pgs. 2-28 - 2-29, Guided Exercises 1, 2 and 3
Due Date: November 23

Just for Fun Task:

In a hackers world = what is the significance of 2600 and what part does Captain Crunch play in it?
Twelve - November 23 Computers and Business Management
Textbook Topics: Information Systems in Business
Reading: Computer Confluence - chapter 12
Assignment: Computer Confluence, p. 453, Crosscurrents - The Case for Rest - Discussion Questions #1 and #2
Due Date: November 30, 2004
Microsoft Access - Manipulating Table Data

Files for in-class work: Access Data Files, Project_03
Assignment: pgs. 3-25 - 3-29, Guided Exercises 1 and 2
Due Date: November 30

Just for Fun Task:

What famous presidential address is on the web as an example of a bad Powerpoint presentation? Print out the presentation and bring it to the next class.
Thirteen - November 30 Buying Online
Textbook Topics:Electronic Commerce and E-Business
Reading: Computer Confluence - chapter 13
Assignment: Computer Confluence, p. 486, Discussion Questions #1 and #2
Due Date: December 7, 2004
Microsoft Powerpoint - Building Presentations; Enhancing Presentations

Files for in-class work: Powerpoint Data Files, Project_01 and Project_02
Assignment: pgs. pp 1-37 - pp 1-39, Guided Exercises 1 and 3; pgs. pp 2-38 - pp 2-42, Guided Exercises 2, 3, and 4
Due Date: December 7


Fourteen - December 7 Program Design
Textbook Topics: System Design and Development
Reading: Computer Confluence - chapter 14
Assignment:None
Microsoft Powerpoint - Viewing and Arranging Slide Shows

Files for in-class work: Powerpoint Data Files, Project_03
Assignment: None


Fifteen - December 14 Reading Day No Class

Final Exam

December 21
Last Updated: 11/23/04