Essentials of Computing I
Summer 2016

General material you should know:

  • Go over course and other part of the Syllabus
  • The Edinboro computing environment
    • Why do I want/need to connect to the EUP network?
    • What do I need and how do I connect to the EUP network?
    • Should I use the e-mail EUP provided or my other on-line e-mail account?
    • How do I check my EUP e-mail?
    • Where can I go to use a computer?, What's software is on them?
    • Tech & Comm published “Technology Handbook”
  • Tech and Comm website resources
  • Make sure you can use your e-mail

Book:

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

May 16th - 18th

Today is the last day to drop or add a course for the 1st session.

3 Days

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 May 18rd

Assignment 2. 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.
Print the listing from the web site and attach the word document to it.

Due: May 19rd

Sample exam

Exam 1 - Computing Concepts - Tuesday May 19th

 

May 19th - 23rd

(3 days)

Begin Working with Microsoft Word:

Student Data Files

Assignments:

Chapter 1:

  • 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:

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

Chapter 3:

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

Chapter 4:

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

Exam 2 - May xxth
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

 

May 24th

(1 day)

Web Page:

 

Our day of webpage

1) Creating an initial webpage - Dreamweaver

2) Copy it up to your web space on the EUP server
\\eup\dfs\webdir\dt123456\index.html

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\

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

 

May 25th -31st

(4 days)

Memorial day on the 30th , no class

Excel:

Student Data Files

Assignments:

Chapter 1:

  • 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

Chapter 2:

  • Hands on Exercise #1 page 452
  • Hands on Exercise #2 page 466
  • Hands on Exercise #3 page 478
  • Hands on Exercise #4 page 485
  • Practice #2: Steggel Consulsting Firm Salaries Page 492
  • In Class Practice: Fred's Fine Feathered Friends

Chapter 3:

  • 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
  • In Class Practice Appliance Sales

Chapter 4:

  • 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-613

Some Additional Practice Files:

Excel exam May 31st - 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. You'll e-mail me your solution.

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

Sample Exam

Better one

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)

 

 

June 1st & 2nd

Begin working with PowerPoint:

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

Student Data Files

Chapter 1:

  • Hands on Exercise 1 to 4
  • Practice Exercise #2

Chapter 2:

  • Hands on Exercise 1 to 4
  • Practice Exercise #2

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 May 18th
Quiz 1 (Concepts) May 19th
Exam 2 (MS Word)

All MS Word Homework on MyITLab is due that day.

 May 23rd
Web Page Due May 24th
Exam 3 (MS Excel)

All MS Word Homework on MyITLab is due that day.

 May 31st
PowerPoint Due June 2nd
Final Exam

June 2nd