Course Calendar - Fall 2007

Subject to Change (mostly dates, some of the material may be moved to the next block of dates)
This page was last edited on:03/03/2008

Dates: Material to be covered Notes

August 27th - September 14th

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
A Special note for the ESP students:

1) ESP students will not be taking Univ 100 and should cross that class off their schedules and not attend that class (if you check your schedule in SCOTS, you will see that it is no longer on there.

2) ESP students will have a special Common Hour session this Tuesday 8/28 from 12:30-1:45pm in Van Houten Dining Hall (South) mandatory for all ESP students.

3) ESP study tables originally scheduled to begin this first week, will begin next week details will be provided at the Tuesday Common Hour session.

4) If students need to speak to someone regarding ESP this first week contact Dr. Carol Gleichsner, gleichsner@edinboro.edu or 732-1282.
 

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


Review for exam
Exam 1 - Computing Concepts


Note: We may finish the concepts portion of the course early and start working with MS Word in the 1st week.

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

Lecture Notes:
Concepts

Assignment 1:

1. Say you have $650 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.

Due: Sept. 7th

2. 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.

Due: Sept. 10th

September 17th - October 5th

Homecoming Weekend October 6th & 7th

Begin Working with Microsoft Word:

Download the practice files the book publisher's web site Here
Look in the Word 2007 box and select the chapter you are working with.  For example when you first start you'll choose chapter 5.  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 chapter 5 practice files there.   When finished with the download and extraction you can start the chapter 5 activity.

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.

  • Chapter 5 (is actually the 1st Chapter in your book): 
    • Do Activities 5A and 5B
    • Project 5E
    • Due Wednesday September 19th
  • Chapter 6:
    • Do Activities 6A and 6B
    • Project 6K
    • Due September 26th
  • Chapter 7:
    • Do Activities 7A and 7B
    • Project 7M
    • Due October October 3
  • Chapter 8:
    • Do Activities 8A
    • Project 8K
    • Due October 10th


Exam 2 - Microsoft Word Monday October 10th

Sample Exam

 

Side note:  I am getting a lot of e-mailed schedules, which is fine, but I'm not responding, let me know if you need some sort of reply and I'll reply back.

 

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

Presentations:
Word Chapter 5

Word Chapter 6
Word Chapter 7
Word Chapter 8

October 8th - October 17th or 19th, depending on how we do.

 

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 - demo this for me by the end of the week


Web Page Exam - on using Front Page and making your web page live, will be Thursday (TBA) during the 1st part of the class.   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

More Front Page Notes

Internet 1

Check out the Web Page FAQs

 

October 22nd -November 16th-

Makeup for the Word exam Monday Oct 22nd in the Hamilton Lab (where we meet for class)

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 9 :
    • Do Projects 9A and 9B  (no practice files needed, start from scratch)
    • Project 9O
    • Due Friday Oct. 26th
  • Chapter 10:
    • Do Activities 10A and 10B
    • Project 10M
    • Due  Friday November 2nd
  • Chapter 11:
    • Do Activities 11A and 11B
    • Project 11L
    • Due by  Friday November  9th
  • Chapter 21:
    • Do Activities 21A
    • Due by Friday November 16th

Excel exam on November 16th - will be open book, know how to use functions such as if(), sumif(), average(), sum(), etc.  Also how to format the spreadsheet.  You'll e-mail me your solution.

 


 
  • Excel - One spreadsheet with many features, similar to your practice exercises, know the if & vlookup statements
  • Sample Exam



 

Excel Chapter 9 Notes
Excel Chapter 10 Notes
Excel Chapter 11 Notes

November 19th - End of semester

Make-up Excel exam will be December 5th at Noon, meet in the classroom.

Begin working with PowerPoint:

Note: These activities are not included in your book, only found here.  You'll do these as hands-on exercises similar to how the Word and Excel Activities A & B of each chapter were.

Monday November 19th - Do Project 22A in your book.  This exercise uses PowerPoint to import some data from other applications.

PowerPoint Projects are linked below:

1st PowerPoint Project

2nd PowerPoint Project

Power Point exam on December 7th

Sample Exam

 

PowerPoint Chapter 15 Notes
PowerPoint Chapter 16 Notes
PowerPoint Chapter 17 Notes

For on-line help check out the Microsoft tutorial

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

8:00 am class - December 10th, 8:00am

9:00 am class - December 12th, 8:00 am

11:00 am class - December10th , 11:00am

Double check your schedule to be sure these time are correct!!!