Dates

Essentials of computing I
Fall 2009

Subject to Change: This page was last edited on: 12/08/2009

Notes

September 1st

Official EUP Calendar

General material you should know:

Introduction to the class
Go over course syllabus
Roll
The Edinboro computing environment
- Why do I want/need to connect to the EUP network?
- What do I need and how do I connect to the EUP network?
- Should I use the e-mail EUP provided or my other on-line e-mail account?
- How do I check my EUP e-mail?
- Where can I go to use a computer?, What's software is on them?
Tech and Comm website resources
e-mail
Tech & Comm published “Technology Handbook”
Message from Professor Onderko about Testing out of this course.

Some common links:
My web page
Math/CS Home
Edinboro Univ.

September 3rd

through

September 17th

Computer Concepts

The PC hardware environment
The Windows operating system and system utilities
Overview of Computer Science
- Software/Programming
- Internals of a Computer
- Operating Systems
- Networks
- Internet
Computer Literacy
E-Mail

Assignment 1:Using Windows Explorer - show me a good directory structure of your flash drive for this semester. This will include directories for each course, topics, and assignments.

On the root of your flash drive make a folder for each course you are currently taking
- Within the folder for this class, make folders for:
  - Concepts Homework
  - MS Word
  - MS PowerPoint
  - MS Excel
  - Webpage
Put the homework file you made for the purchase of a laptop in the concepts homework folder.
Within the MS Word folder make folders for:
- Chapter 1
- Chapter 2
- Chapter 3
- Chapter 4
Do a print screen of your directory structure showing the folders, paste it into MS Word, print and turn in on by next Tuesday (9/08).

Assignment 2. You have $600 to buy a laptop, go to www.HP.com and customize a laptop for this price or less. Using MS Word give a short reason why you chose the processor, RAM size, Hard-drive size and if you got a CD Burner or not and any other special options.
Print the listing from the web site and attach the word document to it.

Due: Thursday, 9/10

3. Exploring your computer system worksheet

Sample exam
Exam 1 - Computing Concepts September 17th is Here

Lecture Notes:

Windows XP

Notes on Concepts

September 22nd

through

October 15th

Begin Working with Microsoft Word:

Download the practice files → Here

Click on the Word 2007 link then download the file. The file you download will be compressed (as we discussed in class) you'll need to download it then extract it, or run it directly from the site. Use the directory structure you made for the 1st assignment and save the practice files there. You will use these files as you make your documents throughout the chapters.

Assignments: The following activities walk you though, as much as possible, the completion of a document. Pay attention to what you are doing and you will be learning as you go.

Chapter 1 :
- Do the hands-on Exercises 1, 2 & 3
- Mid-Level Exercise #2 - Training Proposal page 124
- Due:
Chapter 2:
- Do the hands-on Exercises 1,2,3 & 4
- Mid-Level Exercise #2 - Tips for Healthy Living
- Due:
Chapter 3:
- Do the hands-on Exercises 1, 2 & 3
- Mid-Level Exercise #4 July Fireworks Poster
- Due:
Chapter 4: Word and your web browser
- Do the hands-on Exercises 1, 2, 3 & 4
- Mid-Level Exercise #2 Sidewalk Cafe page 305
- Due

Exam 2 - October 15th

Sample Exam

Discount on MS Office 2007 for Students

Talk about what Microsoft Word is and what it is used for.

I want to remind students about the use of Ctrl X, C, & V. These are Cut, Copy & Paste respectively. You may find this method of Cut & Paste much faster and easier.

Lecture Slides:

Computer related Current Events

Cyber Crime

October 20th

through

October 27th

Web Page:

- Internet/Web Browsing
- Web Page Development
Do this hands on Exercise

In case you want to work from home -> A link to Tech & Comm.'s explanation on how to edit your page from home.

\\storage1\dfs\webstorage\d123456t\index.htm <- this is a sample of what you would use to open up the index file. What will change is the name of the file. In this case it's index.htm, but your 2nd page might be page2.htm

The sample URL will be:

http:\\users.edinboro.edu\d123456t\

Web Page Assignment - e-mail the URL to me by

Internet 1

Check out the Web Page FAQs

If you need an FTP Client, you can right-clilck and "save target as" for the WS-FTP program here

WS-FTP.exe

October 29th

through

December 1st

No class November 26th, Thanksgiving Break

Excel:

Assignments are:

The following activities walk you though, as much as possible, the completion of a document. Pay attention to what you are doing and you will be learning as you go.

Download the practice files the book publisher's web site → Here

Chapter 1 :
- Do the hands-on Exercises 1, 2 & 3
- Mid-Level Exercise #5 Page 374,375
- Due:
Chapter 2:
- Do the hands-on Exercises 1,2,3 & 4
- Mid-Level Exercise #3 page 423
- Due:
Chapter 3:
- Do the hands-on Exercises 1, 2 & 3
- Mid-Level Exercise #5 Page 481
- Due
Chapter 4:
- Do the hands-on Exercises 1, 2
- Mid-Level Exercise : #4 Population Analysis, Page 539
- Due
Chapter 5:
- Mid-Level Exercise : #1 Compensation Analysis for Hotel Management, Page 611
- Due
Chapter 6:
- Mid-Level: #4 J&W Bank Mortgage Calculator, Page 680,681
- Due

Excel exam December 1st - will be open book, know how to use functions such as average, sum, if, vlookup, pmt, etc. Also how to format the spreadsheet, using currency, wrap text, colors, bold. Adding Charts. You'll e-mail me your solution.

Know the if and some simple math, as in the percent increase or decrease. Simple multiply, weighted average.

Sample Exam

Better one