Professor Porter EUP

Edinboro University

CSCI 104-006 Essential Computing I (Spring 2020)

CSCI 104-006 Course Information

Syllabus
Textbook - Inclusive Access
Student Files

Week

Lecture/Notes

Assignments

#1
Jan 13-17

Module 1-1 Computer Concepts

In Class: In Class Exercise #1

#2
Jan 20-24

NO CLASS ON MONDAY JANUARY 20TH Module 1-1 Computer Concepts
Module 1-1 Computer Concepts Review
Module 1-2 Computer Concepts Networks

Homework Assignment #1
Due: Monday January 27th @ 1:00PM

#3
Jan 27-31

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

In Class: In Class Exercise #2
Zip Folder Contents

⟹ Computer Concepts Exam
Monday February 3rd
on Modules 1-1, 1-2 & 1-3


Read:
Office 365 Common Features:
Taking the First Step
(pg. 2)
Chapter 1 - Introduction to Word:
Organizing a Document
(pg. 70)

#4
Feb 3-7

**Exam on Computer Concepts**
Modules 1-1, 1-2 & 1-3

Office 365 Common Features
Module 2-1 Introduction to Word

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

Homework:
Word 1 Practice 2 - Freshwater Research
(pg. 122)
Word 1 Mid Level 1 - Water for Life
(pg. 124)
Due: Monday February 10th @ 1:00PM

Read:
Chapter 2 - Document Presentation: Editing and Formatting
(pg. 128)

#5
Feb 10-14

Module 2-2 Document Presentation

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

Homework:
Word 2 Practice 2 - Drug Abuse
(pg. 185)
Word 2 Mid Level 1 - Mount Vernon Balloon Festival
(pg. 188)
Due: Monday February 17th @ 1:00PM

Read:
Chapter 3 - Document Productivity: Working with Tables and Mail Merge
(pg. 194)

#6
Feb 17-21

Module 2-3 Document Productivity

In Class: Word 3 Practice 2 - Fitness Matters
(pg. 241)

Homework:
Word 3 Practice 1 - Academics
(pg. 239)
Word 3 Mid Level 1 - Football Statistics
(pg. 244)
Due: Monday February 24th @ 1:00PM

Read:
Chapter 4 - Research and Collaboration: Communicating with and Producing Professional Papers
(pg. 250)

#7
Feb 24-28

Module 2-4 Research and Collaboration

⟹ Word Exam
Friday March 6th
on Modules 2-1, 2-2, 2-3 & 2-4

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

Homework:
Word 4 Mid Level 2 - Study Abroad
(pg. 305)
Due: Monday March 2nd @ 1:00PM

#8
Mar 2-6

**Exam on Word**
Modules 2-1, 2-2, 2-3 & 2-4

Word Exam Review

Read:
Chapter 1 - Introduction to Excel: Creating and Formatting a Worksheet
(pg. 310)

#9
Mar 9-13

SPRING BREAK - NO CLASSES

#10
Mar 16-20

Module 3-1 Introduction to Excel
Module 3-1 Introduction to Excel (2013)

In Class: Excel 1 Practice 1 - Mathematics and Formatting
(pg. 377)

Homework:
Excel 1 Mid Level 1 - Guest House Rental Rates
(pg. 381)
Excel 1 Mid Level 2 - Real Estate Sales Report
(pg. 382)
Due: Monday March 23rd @ 1:00PM

Read:
Chapter 2 - Formulas and Functions: Performing Quantitative Analysis
(pg. 388)

#11
Mar 23-27

Module 3-2 Formulas and Functions
Module 3-2 Formulas and Functions (2013)

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

Homework:
Excel 2 Practice 1 - Hamilton Heights Auto Sales
(pg. 424)
Excel 2 Practice 2 - Garten Realty
(pg. 425)
Due: Monday March 30th @ 1:00PM

Read:
Chapter 3 - Charts: Depicting Data Visually
(pg. 432)

#12
Mar 30-Apr 3

Module 3-3 Charts
Module 3-3 Charts (2013)

In Class: Excel 3 Mid Level 1 - Airport Passenger Counts
(pg. 484)
Excel 3 Mid Level 2 - Grade Analysis
(pg. 485)

Homework:
Excel 3 Practice 1 - Loza Family Utility Expenses
(pg. 480)
Excel 3 Practice 2 - Trends in Market Value of Houses on Pine Circle
(pg. 482)
Due: Monday April 6th @ 1:00PM

Read:
Chapter 4 - Datasets and Tables: Managing Large Volumes of Data
(pg. 490)

#13
Apr 6-10

Module 3-4 Datasets and Tables
Module 3-4 Datasets and Tables (2013)

⟹ Excel Exam
Wednesday April 15th
on Modules 3-1, 3-2, 3-3 & 3-4

In Class: Excel 4 Practice 1 - Institute for Study Abroad
(pg. 545)
*I will add modifications to this assignment while we complete it*

Homework:
Excel Practice Exam

Excel Practice Exam Instructions
Excel Practice Exam Start
Due: Monday April 13th @ 1:00PM

Read:
Chapter 1 - Introduction to PowerPoint: Creating a Basic Presentation
(pg. 784)

#14
Apr 13-17

**Exam on Excel**
Modules 3-1, 3-2, 3-3 & 3-4

Excel Exam Review

Module 4-1 Introduction to PowerPoint

⟹ PowerPoint Exam
Friday April 24th
on Module 4-1


Homework:
PowerPoint Assignment
(Posted on D2L)
Due: Wednesday April 22nd @ 1:00PM

#15
Apr 20-24

**Exam on PowerPoint**
Module 4-1

PowerPoint Exam Review

In Class: PowerPoint 1 Practice 2 - Introduction to PowerPoint
(pg. 835)

#16
Apr 27-May 1

FINAL EXAM REVIEW
Computer Concepts Exam Review
Word Exam Review
Excel Exam Review
PowerPoint Exam Review

FINALS WEEK
CSCI104-006: WEDNESDAY APRIL 29TH
12:30PM-2:30PM
BF LIB 114

Resources:

Office 2019/365 Audio PowerPoints
Office 365 Install on Windows 10
One Drive
Connect to EUP Wireless Network

Schedules:

Spring 2020 Open Lab Schedule - Main Campus
Spring 2020 CSCI Tutoring
Last update: