Dates

Essentials of computing I
Spring 2009

Subject to Change: This page was last edited on: 04/21/2009

Notes

January 13th

Official EUP Calendar

General material you should know:

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

 


January 13th

thru

January 29th

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 $800 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: January 27th


3. Exploring your computer system worksheet

Due: N/A


Sample exam
Exam 1 - Computing Concepts January 29th

Lecture Notes:

Windows XP

Notes on Concepts


February 3rd

thru

February 19th

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: 2/3/2009
  • Chapter 2:
    • Do the hands-on Exercises 1,2,3 & 4
    • Mid-Level Exercise #2 - Tips for Healthy Living
    • Due:2/10/2009
  • Chapter 3:
    • Do the hands-on Exercises 1,  2 & 3
    • Mid-Level Exercise #4 July Fireworks Poster
    • Due 2/17/2009
  • Chapter 4: Word and your web browser
    • Do the hands-on Exercises 1, 2, 3 & 4
    • Capstone Exercise on page 308
    • Due 2/19/2009

Exam 2 - Feb 24th Feb 26

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

 

February 26

thru

March 12th

 

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 Friday the 13th of March.

Internet 1

Check out the Web Page FAQs

 

March 17th

thru

March April 14th

 

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: 3/19/2009
  • Chapter 2:
    • Do the hands-on Exercises 1,2,3 & 4
    • Mid-Level Exercise #3 page 423
    • Due:3/26/2009
  • Chapter 3:
    • Do the hands-on Exercises 1,  2 & 3
    • Mid-Level Exercise #5 Page 481
    • Due 4/2/2009
  • Chapter 4:
    • Do the hands-on Exercises 1, 2
    • Mid-Level Exercise : #4 Population Analysis, Page 539
    • Due 4/9/2009
  • Chapter 5:
    • Mid-Level Exercise : #1 Compensation Analysis for Hotel Management, Page 611
    • Due 4/14/2009
  • Chapter 6:
    • Mid-Level: #4 J&W Bank Mortgage Calculator, Page 680,681
    • Due 4/14/2009

Excel exam April 14th  - 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

 

April 14th

thru

April 23rd

 

Begin working with PowerPoint:

Download the practice files from the book publisher's web site here

  • Chapter 1 :
    • Do the hands-on Exercises 1,  2, 3,4
    • Mid-Level Exercise #2 University Housing page 1188
    • Due: Thursday
  • Chapter 2:
    • Do the hands-on Exercises 1,2,3 & 4
    • Mid-Level Exercise #1 USDA Food Pyramid page 1248
    • Due: Thursday

 

Sample Exam

We'll have the PowerPoint exam during the final exam period, It will be similar to the others, make me a presentation and e-mail it.

 

 

For on-line help check out the Microsoft tutorial

Final Exam - Comprehensive, hands-on, based on Word, Excel & PowerPoint

9:30 am section has the Final Exam on Thursday at 8:00 am

11:00 am section has the Final Exam on Tuesday at 11:00 am