Exam 1 Review

CSCI 101: Problem Solving with Computer Science
Fall 2006
Dr. Nazli Mollah

Computer Concepts (Chapter 1-3)

Chapter 1: Section A, B, C
Chapter 2: Section A, B
Chapter 3: Section A, C, D

Office 2003 (homework & lab tutorials)
Read WIN, FM, BEB, OFF, Word Level I Tutorials 1-3, Excel Level I Tutorials 1-4

Presentation Handouts (along with class discussion and class notes)

Exam 1
Multiple Choice questions
Monday October 2, 2006 at 9:00 AM

Lab 3

Lab Preperation:
Read EX94 - EX192 in the MS Office 2003 textbook before coming to lab.

Lab: From the Office 2003 textbook, please do the:

Excel tutorial 3
Excel tutorial 4
Excel tutorial 4 Case Problem 3

The course files can be found in the "Ganser PC Lab" folder on the desktop. The folder "CS101 Fall 2005" contains the files for this class. You should drag the folder you need to your flash drive to work with it since you are not allowed to make changes on the server

Deliverables: Before 11:59 PM on September 27. No lab will be accepted after this time

The heading of your e-mail should be "Your Last Name LAB 3" (e.g. Mollah Lab 3) Submit the following items to CSCI101Lab3@hotmail.com:

submit the Sales.xls file as you have changed it in Excel Tutorial 3 as lastname_Sales.xls
submit the Vega.xls file as you have changed it in Excel Tutorial 4 as lastname_Vega.xls
submit the Oil.xls file as you have changed it in Excel Tutorial 4 Case Problem 3 as lab lastname_oil.xls

Good Luck and Enjoy!

Lab 2: EX3 and EX51

Lab Preperation:

Read EX3 - EX94 in the MS Office 2003 textbook before coming to lab.

Lab:

From the Office 2003 textbook, please do the:

• Excel tutorial 1
• Excel tutorial 1 Case Problem 1
• Excel tutorial 2
• Excel tutorial 2 Case Problem 4

The course files can be found in the "Ganser PC Lab" folder on the desktop. The folder "CS101 Fall 2005" contains the files for this class. You should drag the folder you need to your flash drive to work with it since you are not allowed to make changes on the server

Deliverables:

Before 11;59 PM on September 20. No lab will be accepted after this time

The heading of your e-mail should be "Your Last Name LAB 2" (e.g. Mollah Lab 2)
Submit the following items to CSCI101Lab2@hotmail.com:

1. submit the Altac.xls file as you have changed it in Excel Tutorial 1 Case Problem 1 as lastname_Altac
2. submit the Budget.xls file as you have changed it in Excel Tutorial 2 as lastname_Budget
3. submit the Soup.xls file as you have changed it in Excel Tutorial 2 Case Problem 4 as lab lastname_Soup

Good Luck and Enjoy!

Lab Attendance Policy

Hi Class,

Please note that attendance in lab will be taken. Be sure to provide acceptable forms of excuses (see handout given on first day of class) if any labs are missed. Labs are part of class time; it is your responsibility to attend, and any absence must be accounted for.

I'll look forward to seeing all of you on Thursdays :-)

Lab 1; MS Word Tutorials 1, 2, 3

Lab Preperation:

Read OFF1- OFF32 in the MS Office 2003 textbook before coming to lab.

Lab:

From the Office 2003 textbook, please do the:

• 3 Word Tutorials, WD3, WD41, WD89

You do not need to do the Case Exercises.

The course files can be found in the "Ganser PC Lab" folder on the desktop. The folder "CS101 Fall 2005" contains the files for this class. You should drag the folder you need to your flash drive to work with it since you are not allowed to make changes on the server

Deliverables:

Before 11:59 PM on September 13. No lab will be accepted after this time

The heading of your e-mail should be "Your Last Name LAB 1" (e.g. Mollah Lab 1)
Submit the following 3 items to CS101Lab1@hotmail.com:

1. the TreeFAQ.doc file, as you have changed it in lab. Name it "yourlastname_Lab1a.doc" (e.g. mollah_lab1a)
2. the WAN.doc file, as you have changed it in lab. Name it "yourlastname_Lab1b.doc" (e.g. mollah_lab1b)
3. your one page write up on the postive and negative impact of computing. Name it "yourlastname_lab1c.doc" (e.g. mollah_labc)

Item 3 above must be in the following format:
Font: Arial 10
Margins: 1 inch on top and bottom and right, 0.5 inches on the left
The heading must be bolded and centered
There should be 2 paragraphs divided by 2 sub-headings: Postive Impact and Negative Impact
The subheadings must be bolded


Good Luck and Enjoy!