Grade Calculations

During lab today, we went through your grade calcultions - please note that the number we calculated is the grade you would have if you score a 0% on the Final.

Your current grade average would be (your total lab points+ cumulative test points)/460 points

For the record, the grade calculations are as follows:

Grade Calculation as per the syllabus (40 % for labs and 60% for the 3 tests):
(0.4 * lab grade) + (0.4 * Test 1&2 ) + (0.2 * Test 3)

Your Final grades are calculated as follows:
(0.4 * your total lab grade/ 260) + (0.4 * your test 1 & 2 grades / 200) + (0.2 * your test 3 grade/100)

Maximum Grade
(0.4 * 260/260)+(0.4*200/200) + (0.2* 100/100) * 100 = 100 %


Have a great Thursday! :-)

Exam 3 Review and other things

You will be examined on the following

1. Database Packet
2. Programming Basics Packet (to be given out in class on Monday 12/11/06)
3. Access (Lab 10)
4. INT - Word & Excel (Lab 5)

In addition, with respect to the Access labs, many of you successfully sent me this lab. If you are having difficulties in sending me the 3 .mdb files in one e-mail, send them to me in 3 separate e-mails - but please have your last name as the subject heading to each e-mail. During the 8:00 AM session I had mentioned that I wanted the hard copy to circumvent the e-mail transmission issues - however, the hard copies are no longer necessary - please just e-mail me the 3 files.

Also - the final call for any "lost" labs - Friday (12/8/06) 11:30 AM is the deadline.
****************************************************************************

Have a great Thursday! :-)

Lab 10 Access I

Preparation

Read the first two Access tutorials in the MS Office 2003 book

Assignment

You are to do the following tutorials and case problems. Make sure you save your databases.

• Do the Access Tutorial 1
• Do Case problem 2 in Access Tutorial 1
• Do Access Tutorial 2
• Do Case problem 2 in Access Tutorial 2

Deliverables

• Submit the Seasonal.mdb database file after completing the first tutorial as LastName_Seasonal.
• Submit the Northeast.mdb database file from the second tutorial as assignment LastName_Northeast.
• Submit the Fitness.mdb database file from the second tutorial case problem 2 as assignment LastName_Fitness. Note that this is a continuation of the Fitness.mdb from case problem 2 in the first tutorial

You may have to send the 3 files in 3 separate e-mails, but please ensure that each has a heading that shows your name. Thanks.

Please e-mail to CSCI101Lab10@yahoo.com by 11:59 PM on Wednesday, December 6

Wiki Wiki World

CSCI 101

Lab 9 - Wiki

Class - hope you are as excited as I am about our Millersville wiki project. We will be spending some quality time brainstorming this morning.

Your assignment is due on Tuesday, November 21 by 11:59 PM. Please e-mail the Word document with hyperlinks and any pictures to the following e-mail address: CSCI101Lab9@yahoo.com

The heading should be the topic on which you have decided to embark, e.g. History, or Athlectics, Schools, or Diversity, or Location etc. Also remember to include all the members in your group on the top right hand side of your document.

Lab 8: HTML (II)

Lab Preperation:
Refer to the HTML primer

Lab:
Objective: to create a simple html document

Create a resume using HTML because you have decided to post your resume on the web. To do this you will need to write the resume in HTML. To help you write the resume, do the following steps:

• Create a simple LastnameResume.html file (e.g. MollahResume.html) using NotePad. I suggest that you begin with just the body and a header. Save it and view it with Internet Explorer. To view it you should need only double click on the resume.html file
• Add a little to the document to give your name and address. Save again and view it. If you keep Internet Explorer running, you should only need to reload the page to see the changes
• Continue adding a little at a time and checking to see that it displays as expected

Your simple resume should have the following:

• your name, address, and phone number.
• a description of your educational background, including a link to the Millersville University home page (www.millersville.edu) .
• a list of previous employment (summer work, etc), with dates.
• a list of references contact information, for example phone numbers. You can just make up some names here.

Note that you must hand code the HTML for this assignment. Rest assured that it will be very obvious if you generate the HTML from a program such as Word. Such programs generate very difficult to read HTML and I will be checking.

Deliverables:

LastnameResume.html file to assignment HTML_Resume.:

1. hard copy in class on Thursday November 9

2. e-mail

Before 11:59 PM on November 8. No lab will be accepted after this time The heading of your e-mail should be "Your Last Name LAB 8" (e.g. Mollah Lab 8) Submit to CSCI101Lab8@yahoo.com (please ensure you receive the autoreply confirmation for your submission)

THe HTML Primer

Hi Class! :-)
Hope you are enjoying your day so far. The HTML primer is an important reading material - so important that quizes and tests know it's name ...

Here is a picture of Miami this morning.The conference is going very well so far. Enjoy your weekend and take very good care!

Thinking of you!
Dr. Mollah

Lab 7: HTML (I)

Part 1

First Read pages 90 - 107 (it is imperative that you read these pages before attempting the next part)

1. Then go to the following Web site:

http://wps.aw.com/wps/media/objects/893/915029/files/SecondPage.html

While on this site, click on "view", and then "source". You will find the html source for this site (compare with pages 98 and 107). Pretty Cool!

2. Alright next step: you will find that the source code opens up in Notepad. Save the notepad in 2 formats:

a) lastname.txt (this should be your last name e.g. mollah.txt)

b) lastname.html (this should be your last name e.g. mollah.html)

Close both

3. Open lastname.html. What do you see? Exciting! This page is nearly the same as in the book - except the picture does not show up. What to do?

4. Go back to the actual Web site, right click on the picture of the pipe. Then look under "properties". Copy the URL of the pipe image.

5. Open lastname.txt Then paste the URL from (4) in the appropriate place (you should know once you have read pages 90-107). Save this page. Do not close.

6. While on lastname.txt, click on "save as" again and save the page as lastname.html (this should replace the previous one)

7. Open lastname.html and voila, you should be able to see a replica of the actual Web site!

Part 2

Read pages 107 - 115

Answer the Multiple Choice Questions and the Short Answer questions at the back.

Deliverables:

In class on Monday, October 30, 2006

1. lastname.txt and lastname.html

2. Typed answers to Multiple Choice & Short Answer questions

Refer to the format in which documents should be handed in

Good Luck Enjoy!

Lab 6: PowerPoint Slides

Lab Preperation:
Refer to the PPT tutorials in the Office 2003 textbook before coming to lab

This is a very creative lab project that is profeesional and easily navigable, but also keeps your personals style

Lab:
Create 4 PowerPoint files

File 1 (LastName_HomePage) should have the title, "What I Love About Life". This page should contain links to the 3 things you love most about life. In addition, write something about yourself. Include pictures. Note that you can use pictures as icons to link to the other 3 files too. Be creative with the colours and presentation. Refer to your PPT tutorials for guidance.

File 2 (LastName_FirsItem) should have the title of your first item, e.g. Manchester United Football Club. Again this page will have pictures and interesting inforamation and my insight on why I love this club.

File 3 (LastName_SecondItem) should have the title of your seconditem, e.g. Humanitarian Issues. This page will have pictures and interesting inforamation and my insight on what humanitarian causes I support.

File 4 (LastName_ThirdItem) should have the title of your third item, e.g. Beautiful Palces. Again this page will have pictures and interesting inforamation and my insight on beautiful places.

File 2, 3, 4, each should have a link back to the Home Page

All 4 files shoudl be created before you can link one to another.

At this time, please save all 4 files under one folder on your computer/ flash drive. Call the folder "101Web"

Deliverables:
Submit all 4 files in 2 formats:

1. hard copy in class on Thursday November 2

2. e-mail

Before 11:59 PM on November 1. No lab will be accepted after this time The heading of your e-mail should be "Your Last Name LAB 5" (e.g. Mollah Lab 6) Submit to CSCI101Lab6@yahoo.com (please ensure you receive the autoreply confirmation for your submission)

Be Creative and Enjoy!

Lab 5: Integrating Word & Excel and WILAL :-)

Lab Preperation:
Read INT1-19 in the MS Office 2003 textbook before coming to lab

Lab:

I. From the Office 2003 textbook, please do:
Integration Tutorial 1

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.

II. Create a Word document. Give it the heading: "What I Love About Life". State 3 items that interest you/ make you happy e.g. Manchester United Football , Beautiful Places, Human Rights. State your name at the end of the paper. You will be using this document later when working on your web page.

Deliverables:

I. Submit the LHCLetter.doc file as you have changed it in Integration Tutorial 1 lab to lastname_HospitalLetter (e.g. Mollah_HospitalLetter). In addition, please sign the letter with your name.

II. Submit the "What I Love About Life" document as lastname_WILAL (e.g. Mollah_WILAL). Remember to state your name on the paper

Before 11:59 PM on October 18. No lab will be accepted after this time The heading of your e-mail should be "Your Last Name LAB 5" (e.g. Mollah Lab 5) Submit to CSCI101Lab5@yahoo.com (please ensure you receive the autoreply confirmation for your submission)

Please note that this is a comparatively short lab to accomodate the October break and thus the Wednesday deadline stands.

Good Luck and Have a great October Break!

Lab 4 - PowerPoint

Lab Preperation:
Read the two PowerPoint tutorials in the MS Office 2003 textbook before coming to lab

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

PowerPoint Tutorial 1
PowerPoint Tutorial 2

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 October 11. No lab will be accepted after this time

The heading of your e-mail should be "Your Last Name LAB 4" (e.g. Mollah Lab 4) Submit the following items to CSCI101Lab4@yahoo.com (please ensure you receive the autoreply confirmation for your submission)

1. submit the Global Humanitarian Overview.ppt file as you have changed it in PowerPoint Tutorial 1 lab lastname_GlobalHumanitarian (e.g. Mollah_GlobalHumanitarian)
   
2. submit the Peru Expedition.ppt file as you have changed it in PowerPoint Tutorial 2 lab lastname_Peru (e.g. Mollah_Peru)
   

Good Luck and Enjoy!

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!

Preliminary Lab Assignment

Microsoft Office 2003/ 2nd Edition Lab Book

Objective: to familiarize yourself with the computer environment

Please complete the WIN, FM, and BEB tutorials - it is not necessary for you to complete the Case Problems

The CS101 course files should be located in the "Ganser PC Lab" folder on the desktop. You will need to drag the files onto your desktop since it is not possible to manipulate the files on the server

Since this is a preliminary lab assignment, there is no deliverable. Please use the full 2 hours to go through the 3 assigned tutorials

Problem Solving with Computer Science

Hello Class! Wonderful to see you first thing on the first day of class! Hope you navigated your way easily to your class blog.

See you in class on Wednesday at 9:00 AM!

Your first class assignment:

1. navigate my website - you've passed with flying colours
2. remember to read through the hand outs before class
3. write a couple of sentences about how the computer/ computer science has greatly enhanced the quality of life, and how it has contributed to any negatives. You should look for relevant articles to support your argument
4. this is due in class on Wednesday for discussion over this week
   

Please note the adjustments in the office and class hours on the website and make the corresponding corrections to your syllabus. Thanks.

To the Freshman Class at Millersville University - we all welcome you on campus and wish you a successful academic tenure!

Best,
Dr. Mollah