Essentials of computing I
Spring 2015


Date

Material Covered
1st Day

General material you should know:

Date to purchase LyndaClassroom access: Jan 20th - Feb 1st ONLY
LyndaClassroom access will run from : Feb 8th → May 8th

I think it will be $40

You will need to purchase the LyndaClassroom access from the Edinboro bookstore between the dates indicated above. This is the only place you can purchase the bundle which is priced for use in this college course.  This access will not show up in the bookstores on-line site - you will need to call or go to the bookstore between the dates indicated above.

If you prefer you can actually enroll in Lynda.com for a monthly fee ($37/mo) and get all of the Lynda courses (and there are MANY) that are available. After the end purchase date indicated above you will have to purchase your access through Lynda.com for $37/mo.

Different Plans

LyndaClassroom is a bundle of five video courses provided at a reduced rate.  Each course has exercise files that should be downloaded and unzipped on your computer.  You will need to find the technique that works for you in learning the material.  Best practices would be to view a portion of a course and then use the application to walk through the skills with the exercise files.

I strongly recommend you purchase a copy of the reference book:

Title: Office 2013 In Depth

Author: Joe Habraken

This book is to be used as a reference book to look up various skills as you work through the application.  We will not be "working through" this book. The hope is that you will find it useful enough to keep it when the course is complete.

Best practices would be for you to "mark" various topics that you find difficult to remember.  There are special tab sticky notes you can purchase to mark these pages (I find they work great, certainly better than just dog-earring the page).  You will find this very helpful for exams and as you complete some of the items for the portfolio.

You will need a copy or access to a copy of MS Office 2013 or Office 365.  Office is available on all Edinboro Computer labs.
Office 365 Looks like any day now you will be able to use this for free (included in tech fee).  Look for an install button on your e-mail page.  I think you'll have 5 installs.  So choose wisely on where you install it.

1/20 - 2/6

(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 or "S" dirve make a folder for this semester (i.e.Spring 2015).  Then make a seperate folder for each course you are currently taking.
    • Within the folder for this class (CSCI 104 - Essentials of Computing I), make folders for each sub-topic:
      • Concepts Homework
      • MS Word
      • MS Power Point
      • MS Excel
      • Portfilio Report
    • In the MS Word Directory make folders for:
      • Job Document
      • Resume
      • Cover Letter
      • Computer System
  • Eventually you will put the homework file you will make for this assignment and the PC purchase assignment in the concepts homework folder.
  • Do a print screen of your directory structure showing the folders, paste it into MS Word, print and turn in .
  • Due: Feb. 6th

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.

 


Some Review Questions

Computing Concepts Exam - 2/4 and 2/5


2/9 - 2/27

(3 Weeks)

MS Word

Microsoft Word

Note from Prof. Zimmer about Lynda.com access sent out Feb. 6th

We are using Lynda.com for our course text book instead of a traditional text book.  We'll start out with:

Word 2013 Essential Training

MS Word Assignments


1st Project to work on during class (Week of 2/9)

Formatting at the Word and Paragraph Level.

Lynda Exercise 1

2nd Project to work on during class (Week of 2/16)

Formatting for an Essay

In addition I want to add

  • Generating a Table of Contents
  • Generating an Index , mark the words
    • Erie
    • Niagara
    • Pennsylvania
    • War of 1812
  • Add a footnote

Lynda Exercise 2


3rd Project to work on during class (Week of 2/23)

Formatting for Long Documents

Word Exam Reveiw Notes

3/2 - 3/6

and

3/16 -3/20

(2 Weeks)

Spring Break

Web Page:

 

 

\\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 (not the actual web pages) to me.

DUE: March 20th, midnight.

 

Internet 1


Check out the Web Page FAQs

3/23 - 4/17

(4 Weeks)

Excel

In Lynda.com we be using the courses:

Excel 2013 Essential Training

and

Excel 2013 Advanced formulas and functions

both with Dennis Taylor as a resource for you to supplement the lectures in class.  This is basically the book for the course.  There will be some exercise files that will be due.

If the links don't work for you simply search for those courses on the lynda.com web site.

In class exercises: (We are only doing the Taxi, Appliance & Fred's Vet)

Checkbook Example (Select A1.B5. G9)

Taxi Log

Appliance Sales & Lightbulb usage costs

Fred's Fine Feathered Friends & Cost of Living

Excel Assignment ← (budget) this is due the day you take the excel exam

Good local tax info site

For the exam:

  • Know some math, as in the percent increase or decrease; multiply, weighted average.
  • Creating Charts
  • Functions such as if, vlookup(), pmt(), average(), counta(), ......
  • You will need to figure out which formula to use.
  • Do the easy stuff first - formatting, easy formulas, charts, etc... you may need to type in dummy data
  • Your formulas must be copyable
  • leave your best guess to a formula in the top cell
  • But you may need some dummy data for a chart
  • Open Book

Know the material in this tutorial Excel Basics

Excel Practice Exam (on video tutorial page)

Dates:

  • 4/15 or 4/16

 

4/20 - 5/1

(2 Weeks)



Power Point

Again we'll be using the lynda.com for our resources beyond the classroom with power point

Power Point 2013 Essential Training

Go over what is expected for the PowerPoint Homework

Work on that during class.

There is also material from Microsoft at: Microsoft tutorial

Homework due on December 6th

Sample Exam

We'll have the Power Point exam integrated into the final exam.

 

 

Final Exam - Comprehensive, hands-on, based on Word, Excel & Power Point

** All Makeup Exams will be Friday May 8th @ 3:00 **

Section 005(Mon/Wed 3:00)- Wednesday, May 6th; 2:45 → 4:45
Section 008(Tues/Thur 12:30) - Thursday, May 7th; 10:15 → 12:15
Section 009(Wednesday Night) - Wednesday , May 6th; 5:00 pm

Notes about the Final Exam


How your final grade is determined:

  • Exams
    • Word Exam 15%
    • Excel Exam 15%
    • Final Exam 15%
    • Concepts Exam 5%
  • Web Site 5%
  • Directory HW 2%
  • PC Purchase 2%
  • Portfolio & Lynda Homework 41%
 

Important Dates:

Assignment 1 & 2 are due 2/6
Quiz 1 (Concepts)

2/4 or 2/5

Exam 2 (MS Word)

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

2/25 or 2/26

Web Page Due 3/20
Exam 3 (MS Excel)

All MS Excel Homework is due that day.

4/15 or 4/16
Power Point Due 5/1
Portfolio TBA
Final Exam

Finals week