Essentials of computing I
Winter 2015/16

Important Dates | Computer Concepts | MS Word | MS Excel | Internet | MS Power-point

 

Material Covered

General material you should know:

REQUIRED RESOURCE!  THIS IS OUR "TEXTBOOK"!

You will need to purchase the Lynda.com access from Lynda.com website. This is the only place you can purchase the access for this college course. The access level you need is $24.99 per month.  You will have access to the required course videos as well as the other 4,000 videos.  Since the course runs from Dec 14- Jan 15, you should make this purchase ASAP.  Lynda.com offers a free 10 day trial period, so you can sign up for the free trial right now and start the subscription payment after the 10 day free period.

This is our primary textbook and the assignments and notes will be aligning with the videos from Lynda.com.

This is a required resource! (and a good deal compared to most course texts)

Get the "Standard Package"  & below are the practice file

FILES
Download the zip file and then extract the items into a folder

Exercise files for Windows play list
Computer Literacy for Windows
Word 2013
Excel 2013
Excel 2013 - functions and formulas
Power-point 2013
Office for students

Exercise files for Mac Play list
Computer Literacy for Mac
Word 2011
Excel 2011
Excel 2011- functions and formulas
Power-point 2011
Office for students

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 or Office 2011/2016 for MAC.  Office is available on all Edinboro Computer labs.

Edinboro University provides students with a copy of Office 365 and the desktop version (Office 2013).  This can be downloaded and installed on your computer for use in this course.  The link Technology Resources - student information is

Office 365 Advantage

Office 365

Office 365 is a subscription service.  Office 2011/2013 is the desktop software that you can purchase for your computer and have forever.  Your subscription to Office 365 is already provided by Edinboro University so you do not need to purchase Office 2011/2013.  To read more about Office 365 vs Office 2011/2013:

Plural Sight
How To Geek

If you have any problems you need to call the Edinboro help desk at (814) 732-2111 or use the link: Help Desk

Week 1

December

14 →18

Concepts

 

Computer Concepts


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" drive make a folder for this semester (i.e.Spring 2016).  Then make a separate 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
      • Portfolio Report
    • In the MS Word Directory make folders for:
      • Job Document
      • Resume
      • Cover Letter
      • Computer System

    Watch this Video on how to use Windows Explorer, getting started with this project

  • Eventually you will put the homework file you will make for this assignment and the PC purchase assignment in the concepts homework folder that you made for this assignment.
  • Do a print screen of your directory structure showing the folders, paste it into MS Word, and turn in to the D2L drop box. .
  • Read through the this Power-point on Good Passwords and Email
  • Due:12/18

Assignment 2: Knowing how to purchase a PC.

Watch the following video to get some background info on what your needs are:

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.

Screen print the listing from the web site and attach the word document to it. Put it in the D2L drop box

Link to Sample of good solution.


Assignment 3: Lynda  Videos & Concepts Scavenger Hunt

  • View Lynda Videos:
  • Some Review Questions I go over in the lecture you may want to look at and ask questions about
  • Computing Concepts Exam -> this is the "Computing Concepts Internet Scavenger Hunt" quiz in D2L

Week 2

 

MS Word

Microsoft Word

Custom Tutorials Here

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: Chapters 1 → 14 (except 10 & 12)

I also made some videos for the on-line version of this course
(Navigate to the Microsoft Word box)

MS Word Assignments

 

Check the due dates below

1st Walk Through Project

Formatting at the Word and Paragraph Level.

Lynda Exercise 1

2nd Walk Through Project

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 next to the word "Niagara" near the end in the table.  Have the footnote say "Currently docked at the Erie Maritime Museum"

Lynda Exercise 2


3rd Walk Through Project

Formatting for Long Documents



Word Exam Review Notes

Hands on Word Exam  - December 30th

Week 2.5 ?

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\

Web Page Assignment - e-mail the URL (not the actual web pages) to me.

 

Internet 1


Check out the Web Page FAQs

Week 3 & 4

Excel

In Lynda.com we be using the courses:

Excel 2013 Essential Training & Excel 2013 Advanced formulas and functions

Windows
Excel 2013 Essential Training
exclude: chapters 11-15

Excel 2013 Adv Formulas & Functions
exclude: chapters 7-12

MAC OS
Excel for Mac 2011 Essential Training
exclude: chapters 9 & 11

Excel 2011 for the Mac:Mastering fnctn & formulas
exclude: chapters 9-13



Walk throughs:          Videos for some of these




Assignment (only one big):



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)

 

Week 5

 



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 Power-point Homework

 

There is also material from Microsoft at: Microsoft tutorial

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

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:

Concepts

  • Assignment 1, 2 and 3 are due
12/18

MS Word

  • Watch Lynda Videos 1 - 5 (PC)   ( 1-6,11 if you use a Mac)
  • Job Document in D2L Drop box
Dec 22
  • Watch Lynda videos 6 & 7(PC)  ( 7-11 if you use a Mac)
  • Cover Letter
  • Watch Lynda videos 8-11(PC)   (12-17 if you use a Mac)
  • Resume
Dec 23
  • Watch Lynda videos 13 & 14 (PC)    (21-23 if you use a Mac)
  • Computer System
Dec 27
  • Formatting at the Word and Paragraph Level
  • Formatting for an Essay
  • Formatting Long Documents
  • Lynda Exercise 1
  • Lynda Exercise 2
Dec 29
  • Exam 2 (MS Word)
Dec 30
  • Web Page (Extra Credit)
Before End of the Course

MS Excel

  • Excel 2013 Essential Training ch 1-5    - OR -
    Excel for Mac 2011 Ess Training ch 1-5
  • Checkbook
  • Taxi
Jan 2
  • Excel 2013 Essential Training ch 6-10  - OR -
    Excel for Mac 2011 Ess Training ch 6-8, 10
  • Appliance Sales
Jan 4
  • Excel 2013 Adv Form& Func ch 1-6   - OR -
    Excel 2011 for the Mac:Mastering ch 1-8
  • Fred's Fine Feathered Friends
Jan 6
  • Budget Assignment as part of the portfolio
  • Make sure you check out the tutorials for this class
Jan 8
  • Exam 3 (MS Excel)
Jan 10th

Power Point

Power Point Due Jan 12

Final Exam and Project

Final Exam Jan 15