Dates

Essentials of computing I
Fall 2008

Monday,Wednesday & Friday @ 1:00 pm

Subject to Change: This page was last edited on: 11/21/2008

Notes

August 25th

Official EUP Calendar

General material you should know:

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

 


August 25th - September 5th
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 5
    • Chapter 6
    • Chapter 7
    • Chapter 8
  • Do a print screen of your directory structure, paste it into MS Word, print and turn in on Monday.

Assignment 2. You have $1000 to buy a laptop, go to www.HP.com and customize a laptop for this price or less, type it up in MS Word and give a short reason why you chose the processor, RAM size, Hard-drive size and if you got a CD Burner or not.
Don't print from that web site.


Assignment1, Assignment2 & Chapter 1 due


3. Exploring your computer system worksheet

Due:


Sample exam
Exam 1 - Computing Concepts

Lecture Notes:

Lecture Slides
Additonal Notes on Concepts


September 8th - 26th

Begin Working with Microsoft Word:

Download the practice files the book publisher's web site 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.

  • Lab 1 :
    • Do the hands-on lab
    • Lab Exercises - on your own #3 Astronomy Class Memo; page WD1.88
    • Due: 9/17
  • Lab 2:
    • Do the hands-on lab
    • #4 "On Your Own" Wyoming Relocation; you are welcome to choose another state if you want.
    • Due 9/24/2008
  • Lab 3:
    • Do the hands-on lab
    • #5 page WD3.112 - Writing a Report
    • Due 26th
  • Working together 1: Word and your web browser
    • Do the hands-on lab
    • Make a web page about your hometown
      • 2 pages with links back and forth
      • include images
      • include a map
      • bulleted list of reasons to (or not to) visit
      • Title with word art
    • Due October 15th

Exam 2

Sample Exam

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:

Word Lab 1


- Creating and editing a document

Word Lab 2

- Revising and Refining a
Document

Word Lab 3

- Reports and Tables

Working Together: Wordk and the web browsers

- Save as Web Page

 


Computer related Current Events

 

Oct 6th - October 13th

 

Front Page:

 - Internet/Web Browsing
 - Web Page Development

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 type into front page 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

Her URL will be:

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


Web Page Assignment - e-mail the link to me by Monday October 17th.


Web Page Exam - on using Front Page and making your web page live, will be when we get back from break.   You will make a web page that you will have to post to your web account.  You then send me an e-mail with the URL of your exam web page. 

 Sample Exam (with a link to a possible solution at the bottom) 

Front Page Notes (To be fixed)

More Front Page Notes (To be fixed)

Internet 1

Check out the Web Page FAQs

 

October 13th - November 7th

 

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

  • Lab 1 :
    • Do the hands-on lab
    • Lab Exercise #5 -Pecan Groves Homeowners Association
    • Due Oct 22nd
  • Lab 2:
    • Do the hands-on lab
    • Lab Exercise #4 - Children's Sports participation
    • Due Oct 27th
  • Lab 3:
    • Do the hands-on lab
    • Lab Exercise #4 - Calculating total Points and GPA
    • Due Nov. 3rd
  • Working togeher 1:
    • Do the hands-on lab
    • Due Nov. 7th

Excel exam  - will be open book, know how to use functions such as if(), average(), sum(), etc.  Also how to format the spreadsheet.  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

Excel Lab 1 Notes

Creating and Editing a Worksheet

Excel Lab 2 Notes

Charting Worksheet Data

Excel Lab 3 Notes

Managing and Analyzing a Workbook

November 10th - December 5th

Thanksgiving break is November 26th -> 28th

Begin working with PowerPoint:

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

  • Lab 1 :
    • Do the walk through exercise on page PP1.1
    • Lab Exercise 'Employee Orientation' Page PP1.87
    • Due 11/19
  • Lab 2:
    • Do the walk through exercise on page PP2.1
    • Lab Exercise 'Sharing Favorite Vacation Spots' Page PP2.91
    • Due 11/24
  • Lab 3:
    • Do the walk through exercise on page PP3.1
    • Lab Exercise 'Flu Prevention Presentation' Page PP3.66
    • Due 12/3

Sample Exam

PowerPoint exam 12/5

 

PowerPoint Lab 1 Notes

PowerPoint Lab 2 Notes

PowerPoint Lab 3 Notes

For on-line help check out the Microsoft tutorial

Final Exam Friday December 12th - Comprehensive, hands-on, based on Word, Excel & PowerPoint