Essentials of computing I
Spring 2014


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 001:
CRSKLKB-4031677

MWF 002:
CRSKLWQ-4031678

T TH 009:
CRSKLSC-4031679

1/22 - 2/7

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

 

Sample exam

 Exam 1 - Computing Concepts


2/10 - 2/28

(3 Weeks)

Begin Working with Microsoft Word:

We will use the  MyIT Lab on-line assignments. 

Website : www.myitlab.com

Set-Up for a MAC

Exam 2 - MS Word
*** 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

3/3 - 3/14

(2 Weeks)

Spring Break
3/17 - 3/21

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

3/24 - 4/18

(4 Weeks)
Excel Tutorials

Excel:

We will use the  MyIT Lab on-line assignments. 

Website : www.myitlab.com

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)

 

4/21 - 5/5

(2 Weeks)

We have class the Monday of finals week.

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

Section 001 - Friday May 9th 10:15  → 12:15
Section 002 - Wednesday May 7th 10:15 → 12:15
Section 009 - Tuesday May 6th 10:15 → 12:15

Notes about the Final Exam

Notes on Spring 2014 Review from class

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

Feb 6th or 7th

Exam 2 (MS Word)

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

Feburary 28th

(Tues/Thur) March 4th
Web Page Due March 14th
Exam 3 (MS Excel)

All MS Excel Homework on MyITLab is due that day.

 April 17th or 18th
PowerPoint Due May 5th
Final Exam

May 6th, 7th or 9th