Weeks of

Essentials of computing I
Fall 2008

Tuesday & Thursday @ 3:30 pm

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

Notes

August 25th

Official EUP Calendar

General material you should know:

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

Temp Guest Account Until August 29th:

Username: Firstdays
Password: Hamilton01


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.

This is a problem like any other. Can you apply Polya's Four Steps to problem to this problem?

Assignment1, Assignment 2 & 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 (Big step by step exercise in the beginning)
    • "On Your Own" #3 Astronomy Class Memo - WD1.88
    • Due 9/16/2008
  • 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/27/2008

    11/4 - Start back on Word

  • Lab 3:
    • Do the hands-on lab
    • #5 page WD3.112 - Writing a Report
    • Nov. 6th
  • 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 November 13th

    Jump to the web development assignment

Exam 2 November 18th

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

September 23rd

 

 



 

Excel:

We'll start with Excel Early, doing examples with taxes & percents

  • Make a spreadsheet that determines taxes
  • Make a spreadsheet that determines % increase

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 : Page EX1.3
    • Do the hands-on lab 1 exercise
    • Make an excel spreadsheet that calculates
      • simple interest
        • compute Interest
        • computer Amount
      • Future Value
      • Compound Interest
        • Compute Amount where number of payments per year varies
        • Compute Principle given the amount
      • Compute payment formula given the amount of the loan, number of payments per year, number of years and interest rate.
    • Due October 1st.
  • Lab 2:
    • Do the hands-on lab
    • Lab Exercise #4 - Children's Sports participation
    • Due Oct 9th
  • Lab 3:
    • Do the hands-on lab
    • Lab Exercise #4 - Calculating total Points and GPA
    • Due Oct 16th
  • Working together 1:
    • Do the hands-on lab
    • Due Oct 21st

We'll have our Excel Exam October 30th

Excel exam  - 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.

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

 

September 29th - October 10th

 

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


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

 

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/20
  • Lab 2:
    • Do the walk through exercise on page PP2.1
    • Lab Exercise 'Sharing Favorite Vacation Spots' Page PP2.91
    • Due 11/25
  • 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/4

 

PowerPoint Lab 1 Notes

PowerPoint Lab 2 Notes

PowerPoint Lab 3 Notes

For on-line help check out the Microsoft tutorial

Final Exam Thursday @ 2:00- Comprehensive, hands-on, based on Word, Excel & PowerPoint