Dates

Essentials of computing I
Summer 2009

Subject to Change: This page was last edited on: 05/26/2009

Notes

May 11th

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.

May 11th, quiz on the 12th

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 (1/20).

Assignment 2. You have $700 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: May 12th

3. Exploring your computer system worksheet

Sample exam
Exam 1 - Computing Concepts January 29th

Lecture Notes:

Windows XP

Notes on Concepts

May 12 thru 18th

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: May 12th
Chapter 2:
- Do the hands-on Exercises 1,2,3 & 4
- Mid-Level Exercise #2 - Tips for Healthy Living
- Due:May 13th
Chapter 3:
- Do the hands-on Exercises 1, 2 & 3
- Mid-Level Exercise #4 July Fireworks Poster
- Due: May 14th
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 May 15th

Exam 2 - May 18th

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

May 15th & 18th, part of Word

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 May 19th

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

May 18th

thru

May 22nd

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: May 18th
Chapter 2:
- Do the hands-on Exercises 1,2,3 & 4
- Mid-Level Exercise #3 page 423
- Due:May 19th
Chapter 3:
- Do the hands-on Exercises 1, 2 & 3
- Mid-Level Exercise #5 Page 481
- Due May 20th
Chapter 4:
- Do the hands-on Exercises 1, 2
- Mid-Level Exercise : #4 Population Analysis, Page 539
- Due May 21th
Chapter 5:
- Mid-Level Exercise : #1 Compensation Analysis for Hotel Management, Page 611
- Due May 22nd
Chapter 6:
- Mid-Level: #4 J&W Bank Mortgage Calculator, Page 680,681
- Due May 22nd

Excel exam May 25th - 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