Edinboro University

Day

Lecture/Notes

Assignments

#1
July 17

Module 1-1 Computer Concepts

In Class: In Class Exercise #1

#2
July 18

Module 1-1 Computer Concepts
Module 1-2 Computer Concepts Networks

Homework Assignment #1
Due: Wednesday July 19th @ 1:00PM

#3
July 19

Module 1-1 Computer Concepts Review
Module 1-2 Computer Concepts Networks
Module 1-3 Computer Concepts Email

⟹ Computer Concepts Exam
Thursday July 20th
on Modules 1-1, 1-2 & 1-3

#4
July 20

**Exam on Computer Concepts**
Modules 1-1, 1-2 & 1-3
Intro to File Explorer and Office

In Class: In Class Exercise #2
Zip Folder Contents

Read:
Office 2016 Common Features
(pg. 64)
Chapter 1 - Introduction to Word (pg. 130)

#5
July 24

Module 2-1 Intro to Word

In Class: Word 1 Practice 1 - River City Media
(pg. 188)

Homework:
Word 1 Practice 2 - Working Space (pg. 190)
Word 1 Mid Level 1 - Runners at Heart (pg 192)
**Do NOT print the exercises**
Due: Tuesday July 25th @ 1:00PM

Read:
Chapter 2 - Document Presentation
(pg. 198)

#6
July 25

Module 2-2 Document Presentation

In Class: Word 2 Practice 1 - Campus Safety
(pg. 256)

Homework:
Word 2 Practice 2 - Drug Abuse
(pg. 259)
Word 2 Mid Level 1 - Balloon Festival (pg 262)
Due: Wednesday July 26th @ 1:00PM

Read:
Chapter 3 - Document Productivity
(pg. 268)

#7
July 26

Module 2-3 Document Productivity

In Class: Word 3 Practice 1 - Academics
(pg. 320)

Homework:
Word 3 Practice 2 - Fitness Matters
(pg. 322)
Word 3 Mid Level 1 - Football Statistics
(pg 325)
Due: Thursday July 27th @ 1:00PM

Read:
Chapter 4 - Collaboration and Research
(pg. 332)

#8
July 27

Module 2-4 Collaboration and Research

In Class: Word 4 Practice 1 - Live. Work. Dine. Shop. (pg. 391)

Homework:
Word 4 Practice 2 - DREAM Act Letter
(pg. 393)
Due: Monday July 31st @ 1:00PM

#9
July 31

Word Exam Review
Module 3-1 Introduction to Excel

⟹ Word Exam
Tuesday August 1st
on Modules 2-1, 2-2, 2-3 & 2-4

Read:
Chapter 1 - Introduction to Excel (pg. 402)

#10
Aug 1

**Exam on Word**
Modules 2-1, 2-2, 2-3 & 2-4
Module 3-1 Introduction to Excel

Read:
Chapter 1 - Introduction to Excel (pg. 402)
Chapter 2 - Formulas and Functions
(pg. 486)

#11
Aug 2

Module 3-1 Introduction to Excel
Module 3-2 Formulas and Functions

In Class: Excel 1 Practice 1 - Mathematics Review
(pg. 473)

Homework:
Excel 1 Practice 3 - Downtown Theatre
(pg. 477)
Excel 1 Mid Level 1 - Guest House Rental Rates
(pg. 479)
Due: Thursday August 3rd @ 1:00PM

Read:
Chapter 2 - Formulas and Functions
(pg. 486)

#12
Aug 3

Module 3-2 Formulas and Functions

In Class: Excel 2 Mid Level 1 - Metropolitan Zoo Gift Shop Weekly Payroll
(pg. 527)

Homework:
Excel 2 Practice 1 - Hamilton Heights Auto Sales
(pg. 524)
Excel 2 Practice 2 - Lockridge Marketing Analysis
(pg. 525)
Due: Monday August 7th @ 1:00PM

Read:
Chapter 3 - Charts
(pg. 532)

#13
Aug 7

Module 3-3 Charts

In Class: Excel 2 Mid Level 1 - Metropolitan Zoo Gift Shop Weekly Payroll
(pg. 527)
Excel 3 Mid Level 1 - Airport Passenger Counts
(pg. 591)

Homework:
Excel 3 Practice 1 - Hulett Family Utility Expenses
(pg. 587)
Excel 3 Practice 2 - Trends in Market Value of Houses on Pine Circle
(pg. 588)
Due: Tuesday August 8th @ 1:00PM

Read:
Chapter 4 - Datasets and Tables
(pg. 596)

#14
Aug 8

Module 3-4 Datasets and Tables

In Class: Excel 3 Mid Level 2 - Grade Analysis
(pg. 592)
Excel 4 Practice 2 - Sunny Popcorn, Inc.
(pg. 656)
*I will add modifications to this assignment while we complete it*

Excel Practice Exam
Excel Practice Exam Instructions
Excel Practice Exam Start
Due: Wednesday August 9th @ 1:00PM

#15
Aug 9

Excel Exam Review

⟹ Excel Exam
Thursday August 10th
on Modules 3-1, 3-2, 3-3 & 3-4

#16
Aug 10

**Exam on Excel**
Modules 3-1, 3-2, 3-3 & 3-4
Module 4-1 Introduction to PowerPoint

Homework:
PowerPoint Assignment
(Posted on D2L)
Due: Monday August 14th @ 1:00PM

Read:
Chapter 1 - Introduction to PowerPoint
(pg. 924)

#17
Aug 14

Module 4-1 Introduction to PowerPoint
PowerPoint Exam Review

In Class: PowerPoint 1 Practice 2 - Tips for a Successful Presentation
(pg. 982)

**REVIEW EXCEL EXAM**

⟹ PowerPoint Exam Tuesday Aug 15th
on Module 4-1

#18
Aug 15

**Exam on PowerPoint**
Module 4-1
Computer Concepts Exam Review
Word Exam Review
Excel Exam Review
PowerPoint Exam Review

**REVIEW FOR FINAL**

#19
Aug 16

FINAL
CSCI104-F01: WEDNESDAY AUGUST 16TH
1:00-3:00PM
Porreco 006