Essentials of computing I
Summer 2014


Material Covered Notes

May 19th

1st Day

General material you should know:

Link to Video tutorials I made for using MyITLab, Word and Excel

Interestign graph on College Degree vs. Salary


MyitLab for Office 2010
Choose "Exploring" when given a list of options during registration on the MyITLab web site.

Course code:


5/19- 5/21

(3 days)

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

Lecture Notes:


Notes on Concepts We're using these

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 .

Assignment 2. You have $750 to buy a laptop, go to 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.


Sample exam

Exam 1 - Computing Concepts

5/22 - 5/27

(3 days)

No Class on Memorial Day; May 26th

Begin Working with Microsoft Word:

We will use the  MyIT Lab on-line assignments. 

Website :

Set-Up for a MAC

Exam 2 - MS Word

What will be on the Word Exam

*** All MS Word Myitlab homework is due the day of the exam ***

Sample Exam

Discount on MS Office 2010 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.

Computer related Current Events


(1 Days)


Web Page:

 - Internet/Web Browsing
 - Web Page Development

\\eup\dfs\webdir\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:


In case you want to work from home -> A link to Tech & Comm.'s explanation on how to edit your page from home.

Web Page Assignment - e-mail the URL to me by October 18th

Internet 1

Check out the Web Page FAQs

5/29 - 6/3

(4 Days)

Excel Tutorials


We will use the  MyIT Lab on-line assignments. 

Website :

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

Know the if and some simple math, as in the percent increase or decrease.  Simple multiply, weighted average.

Know the material in this tutorial Excel Basics

Excel Practice Exam (on video tutorial page)


6/4 - 6/5

(1.5 Days)

Begin working with PowerPoint:

Sample Exam

We'll have the PowerPoint exam integrated into the final exam.


For on-line help check out the Microsoft tutorial


Final Exam

Final Exam - Comprehensive, hands-on, based on Word, Excel & PowerPoint. It will be on the last day of class, June 5th

Notes about the Final Exam

How your final grade is determined:
(For your MyIT Lab Grades → Custom view in your My ITlab account)

Word Exam 15%
Excel Exam 15%
Final Exam 15%
Concepts Exam 5%
Web Site 5%
Directory HW 2%
PC Purchase 2%
My IT Lab Homework 41%
(graders are worth double the training)


Important Dates:

Assignment 1 & 2 are due May 21st
Quiz 1 (Concepts) May 21st
Exam 2 (MS Word)

All MS Word Homework on MyITLab is due the day you take the exam.

May 27th
Web Page Due May 29th
Exam 3 (MS Excel)

All MS Excel Homework on MyITLab is due that day.

June 3rd
PowerPoint Due June 5th
Final Exam

June 5th