Dates

CSCI 104 - Essentials of Computing I
Course Schedule
Spring 2008

Subject to Change: This page was last edited on:08/04/2008

Notes

July 14th

Official EUP Calendar

General material you should know:

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

 

Week 1

July 14th - July 18th

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. Say 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 Thursday July 17th


3. Exploring your computer system worksheet

Due: Friday July 18th


Sample exam
Exam 1 - Computing Concepts on Friday

Lecture Notes:
Concepts
Week 2

July 19th

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
    • 7/21/2008
  • Chapter 6:
    • Do Activities 6A and 6B
    • Project 6K
    • 7/22/2008
  • Chapter 7:
    • Do Activities 7A and 7B
    • Project 7M
    • 7/23/2008
  • Chapter 8:
    • Do Activities 8A
    • Project 8K
    • 7/24/2008

Exam 2 Friday July 25

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 Chapter 5

Word Chapter 6

  • Alignment
  • AutoCorrect & AutoFormat
  • Bibliography
  • Citation
  • End Notes
  • Footnotes
  • Format Painter
  • Making Lists
  • Office Clipboard

Word Chapter 7

  • Getting images from the internet
  • Picture properties
  • Picture locations
  • Banners & more
  • Tabs
  • Word Art
  • Tables

Word Chapter 8

  • Columns
  • Mailing Labels & Mail Merge
  • Hyperlinks
  • Smart Art Graphic
  • Save as Web Page

 


Computer related Current Events

Week 3

 

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. 

Note The exam will be on Thursday July 31st, Bring your book.

 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

 

Week 3 &
Week 4


 

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 Monday August 4th
  • Chapter 10:
    • Do Activities 10A and 10B
    • Project 10O
    • Due Tuesday August 5th
  • Chapter 11:
    • Do Activities 11A and 11B
    • Project 11N
    • Due Wednesday August 6th
  • Chapter 21:
    • Do Activities 21A
    • Due  Thursday August 7th

Excel exam Friday August 8th  - 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
  • Last Semester's Exam



 

Excel Chapter 9 Notes
Excel Chapter 10 Notes
Excel Chapter 11 Notes
Week 5

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 - Do Project 22A in your book.  This exercise uses PowerPoint to import some data from other applications.

PowerPoint Projects are linked below:

If you have the White Book If you have the GO!  book (Most people have this)
  1. 22A - Get File Here
  2. 1st PowerPoint Project
  3. 2nd PowerPoint Project

 

  1. 22A - Get File Here
  2. You can do either:
      -
    15A & 15B
             -or-
      - The projects listed under the White Book
  3. Get Starter Files Here

 

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 Wednesday August 13th - Comprehensive, hands-on, based on Word, Excel & PowerPoint