Essentials of computing I
Fall 2013


Date

 Material Covered Notes
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

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

Course codes:

MWF (FYE section):
CRSKL2N-4014781

Tuesday/Thursday:
CRSKLT8-4014782

8/26 - 9/9

(3 Weeks)

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:

Windows

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 .
  • Due: September 13th

Assignment 2. You have $750 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: Due September 13th

3. Exploring your computer system worksheet - Not Assigned
 

Sample exam

 Exam 1 - Computing Concepts
MWF Class → September 13th
Tue/Thur → September 12th


9/16 - 9/30

(3 Weeks)

Begin Working with Microsoft Word:

We will use the  MyIT Lab on-line assignments. 

Website : www.myitlab.com

Exam 2 - MS Word
MWF → October 4th
Tues/Thur → October 3rd
*** All My IT Lab 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

10/7 - 10/14

(2 Weeks)

Oct 15th, no class

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:

http:\\users.edinboro.edu\d123456t\

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

10/21 - 11/11

(4 Weeks)
Excel Tutorials

Excel:

We will use the  MyIT Lab on-line assignments. 

Website : www.myitlab.com

Exam 3 - MS Excel
MWF → November 15th
Tues/Thur → November 14th

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)

 

11/18 - 12/2

(2 Weeks)

This spans Thanksgiving Break

Begin working with PowerPoint:

Homework due on December 6th

Sample Exam

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

  

For on-line help check out the Microsoft tutorial

Check your grades in MYITLab → Custom View  !!!!

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

MWF - 11:00 am class: 12/11 @ 10:15
T/Th - 11:00 am class: 12/10 @ 10:15

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 September 13th
Quiz 1 (Concepts)

September 12th
September 13th
Exam 2 (MS Word)

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


October 3rd
October 4th
Web Page Due October 18th
Exam 3 (MS Excel)

All MS Excel Homework on MyITLab is due that day.

 November 14th
November 15th
PowerPoint Due December 6th
Final Exam

December 10th
December 11th