Essentials of Computing I
Spring 2017

General material you should know:

Book:

Exploring: Microsoft Office 2013, Plus MaryAnne Poatsy, Montgomery County Community College
©2014 | Pearson

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 ,2,3

1/24 - 2/9

 

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.

  • Video I made a few year back on how to do this
  • 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, put in the drop box in D2L..

Assignment 2.

GCFLearnFree.org - Good resource for learning computer basics

Before doing Assignment 2, please go to the Comptuer Basics link below and go through the Hardware Basics tutorials, 3 through 7.

You have $400 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 paste it in a word document.

Concepts Notes

When done with that please review the Basic Skills section from the link below. Then choose the Operating System of your computer and review that. These are very helpful tutorials.

Sample exam

Exam 1 - Computing Concepts - Feb 9th

 

3 Weeks

2/14 -> 3/7

 

Custom Tutorials Here

Begin Working with Microsoft Word:

In-Class Walk Through: Formatting at the Word and Paragraph Level.

In-Class Walk Through: 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"
In-Class Walk Through: Formatting for Long Documents

Get all starter homework files here: Student Data Files

Assignments:

Chapter 1: Due 2/19

  • Hands on Exercise #1 page 151-156
  • Hands on Exercise #2 page 168-173
  • Hands on Exercise #3 page 180-183
  • Mid-level #1, Page 191

Chapter 2: Due 2/26

  • #1 Page 211 - 216
  • #2 Page 225 - 230
  • #3 Page 239 - 244
  • Mid Level Exercise number 1, Balloon Festival, Page 253

Chapter 3:Due 3/5

  • #1 Page 268 - 273
  • #2 Page 283 - 288
  • #3 Page 295 - 298
  • Mid Level Exercise number 1,Football Statistics, Page 306

Chapter 4:Due 3/7

  • #1 Page 326 - 331
  • #2 Page 337 - 339
  • Mid Level Exercise number 1,WWW Web Services Agency, Page 368 (skip Step h)

Exam 2 - March 7th
Sample Exam

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

3/9 & 3/14

 

Web Page:

 

Our week of webpage

1) Creating an initial webpage - Notepad

2) FTP it up to your web space on the EUP server
webstorage.edinboro.edu

3) How do people look at your web page
http://users.edinboro.edu/dt123456/

4) Make changes to your webpage
- background image
- Format the text
- Add an image

5) Make a 2nd Page
- backgroud color
- Bulleted list of hobbies

\\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\

Makeing Web page Part 1:



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

 

3/16 - 4/13

Excel:

Check Out !!! -> Introduction videos

Student Data Files

In-Class Notes

Assignments:

Chapter 1: DUE 3/23

  • Hands on Exercise #1 page 381
  • Hands on Exercise #2 page 389
  • Hands on Exercise #3 page 401
  • Hands on Exercise #4 page 411
  • Hands on Exercise #5 page 419
  • Hands on Exercise #6 page 428 (But don't actually Print)
  • Mid-level #1, Page 441
  • For Practice Only: Taxi Log

Chapter 2: DUE 3/30

Chapter 3: DUE 4/6

  • Hands on Exercise #1 page 520
  • Hands on Exercise #2 page 533
  • Hands on Exercise #3 page 541
  • Mid Level #2, Grade Analysis, Page 550 -551
  • For Practice Only: Appliance Sales

Chapter 4: DUE 4/13

  • Hands on Exercise #1 page 561
  • Hands on Exercise #2 page 571
  • Hands on Exercise #3 page 582
  • Hands on Exercise #4 page 590
  • Hands on Exercise #5 page 601
  • Mid Level #1, Biology Department Teaching Schedule, Page 612

Some Additional Practice Files:

Hints for the Excel exam - 4/13

  • Functions such as if(), average(), sum(), vlookup(), pmt(), average(), counta(), ......
  • Also how to format the spreadsheet, using currency, wrap text, colors, bold. 
  • Creating and adding Charts.
  • Know the some simple math such as:
    • percent increase or decrease
    • multiply, divide
    • weighted average
  • 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
  • Know the material in this tutorial → Excel Basics
  • Sample Exam
  • Excel Practice Exam (on video tutorial page)

 

4/25 - 5/4

Begin working with PowerPoint:

Lets do this exercise as our introduction and notes for Power Point

Student Data Files

Chapter 1:

  • Put all of the hands on in one drop box in D2L
    • Hands on Exercise #1 page 1078
    • Hands on Exercise #2 page 1087
    • Hands on Exercise #3 page 1097
    • Hands on Exercise #4 page 1108
  • Practice Exercise #2 page 1115

Chapter 2:

  • Put all of the hands on in one drop box in D2L
    • Hands on Exercise #1 page 1129
    • Hands on Exercise #2 page 1138
    • Hands on Exercise #3 page 1144
    • Hands on Exercise #4 page 1153
  • Practice Exercise #2 page 1161

For on-line help check out the Microsoft tutorial

Sample Exam

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

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

Notes about the Final Exam
 

Important Dates:
Assignment 1 & 2 are due Feb 2nd
Quiz 1 (Concepts) Feb 9th
Exam 2 (MS Word)

All MS Word Homework is due that day.

 March 7th
Web Page Due  
Exam 3 (MS Excel)

All MS Word Homework is due that day.

 April 13th
PowerPoint Due May 5th
Final Exam

12:30 Section - Thursday May 11th at 10:15

2:00 Section - Tuesday May 9th at 12:30