Dates

Essentials of computing I
Summer 2010

Subject to Change: This page was last edited on: 05/28/2010

Notes
May 17th

Official EUP Calendar

General material you should know:

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

 

 

May 17th
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 $500 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: May 20th

3. Exploring your computer system worksheet
 

Sample exam
Exam 1 - Computing Concepts May 19th

Lecture Notes:

Windows XP

Notes on Concepts

May 18 thru 21st

Begin Working with Microsoft Word:

 

Ok, lets try the MyIT Lab on-line assignments. 

Website : www.myitlab.com

Our course code is: CRSABYU-616220

Students in other sections have commented how they like using this much more then the text.

 

So... ignore this part

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: May 19th
  • Chapter 2:
    • Do the hands-on Exercises 1,2,3 & 4
    • Mid-Level Exercise #2 - Tips for Healthy Living
    • Due:May 20th
  • Chapter 3:
    • Do the hands-on Exercises 1,  2 & 3
    • Mid-Level Exercise #4 July Fireworks Poster
    • Due: May 21th
  • Chapter 4: Word and your web browser
    • Do the hands-on Exercises 1, 2, 3 & 4
    • Mid-Level Exercise #2 Sidewalk Cafe page 305
    • Due May 24th

Exam 2 - May 24th
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

 

May 24th & 25th

 

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 May 26th

Internet 1

Check out the Web Page FAQs

 

If you need an FTP Client, you can right-clilck and "save target as" for the WS-FTP program here

WS-FTP.exe
May 26th

thru

May 31st

 

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

Excel exam June 1st  - 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

Better one
 

June 1st

thru

June 3rd

 

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: June 1st
  • Chapter 2:
    • Do the hands-on Exercises 1,2,3 & 4
    • Mid-Level Exercise #1 USDA Food Pyramid page 1248
    • Due: June 2nd
    •

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

Last day of class, June 3rd