Second 8 week classes begin

• Syllabus overview
• How to be successful in this course
• Using the ARC computing environment
• Weekly Schedule:
  • Read textbook
  • Watch screen casts/videos
  • Quiz
  • Lab activities
  • Lab exercises

Activities and Exercises are due by midnight on the date due unless it is stated otherwise.

Study Module

Course Syllabus and Tips and Tricks discussion board

Study Module 0

Course Orientation

• M1.1 Overview of Microsoft Excel
• M1.2 Entering, Editing, and Managing Data
• M1.3 Formatting and Data Analysis
• M1.4 Printing

Study Module 1

Fundamental Skills

• Exercise due

Friday, March 24 is last day to drop this class without notation on record, and to qualify for tuition refund.

Due: Exercise 1

Syllabus Review quiz,
Introductory Survey,
Student Learning Contract,
Post and Reply to Introductions Discussion Board,
File Upload Practice

• Assignments due

Quiz 1

on Module 1

Due: Activity 1

M1.1-M1.4 CH1 Merchandise City Sales Data

Due: Activity 2

Basic Monthly Budget for Medical Office

• Peer reviews due

Due: Peer Reviews

for Activities 1 & 2

• M2.1 Formulas
• M2.2 Introductory Statistical Functions
• M2.3 Functions for Personal Finance
• M2.4 Preparing to Print

Study Module 2

Mathematical Computations

• Exercise due (post-poned from Friday due to holiday)

Due: Exercise 2

Sales and Inventory Items

• Assignments due

Quiz 2

on Module 2

Due: Activity 3

M2.1-M2.4 CH2 Personal Budget

Due: Activity 4

Financial Plan for a Lawn Care Business

• Peer reviews due

Due: Peer Reviews

for Activities 3 & 4

• M3.0 Introduction
• M3.1 More on Formulas and Functions
• M3.2 Logical and Lookup Functions
• M3.3 Conditional Formatting
• M3.4 Preparing to Print

Study Module 3

Formulas, Functions, Logical and Lookup Functions

• Exercise due

Due: Exercise 3

Hotel Occupancy and Expenses

• Assignments due

Quiz 3

on Module 3

Due: Activity 5

M3.1-M3.4 CH3-Gradebook and Parks

Due: Activity 6

Household Budget

• Peer reviews due

Due: Peer Reviews

for Activities 5 & 6

• M4.0 Introduction
• M4.1 Choosing a Chart Type
• M4.2 Formatting Charts
• M4.3 Using Charts with Microsoft Word and Microsoft PowerPoint
• M4.4 Preparing to Print

Study Module 4

Presenting Data with Charts

• Exercise due

Due: Exercise 4

Midas Coffee Company

• Assignments due

Quiz 4

on Module 4

Due: Activity 7

M4.1-M4.4 CH4 Charting

Due: Activity 8

Charting Historical Data

• Peer reviews due

Due: Peer Reviews

for Activities 7 & 8

• M5.0 Introduction
• M5.1 Table Basics
• M5.2 Intermediate Table Skills
• M5.3 Preparing to Print

Study Module 5

Tables

• Exercise due

Due: Exercise 5

Charting Sales Data

• Assignments due

Quiz 5

on Module 5

Due: Activity 9

M5.1-M5.3 CH5 HR Report

Due: Activity 10

Tables for a Tourism Company

• Peer reviews due

Due: Peer Reviews

for Activities 9 & 10

• M6.0 Introduction
• M6.1 Multiple Sheet Basics
• M6.2 Formulas with 3-D References
• M6.3 Templates
• M6.4 Preparing to Print

Study Module 6

Multiple Sheet Files

• Exercise due

Due: Exercise 6

Tables for a Retail Company

• Assignments due

Quiz 6

on Module 6

Due: Activity 11

M6.1-M6.4 CH6 Personal Budget

Due: Activity 12

Creating a Multiple Sheet Workbook for a Sports Team

• Peer reviews due

Due: Peer Reviews

for Activities 11 & 12

• M7 M6.3-continued: Creating Custom Templates
• M7 Inserting, Formatting, and Modifying Graphics
• M7 Find and Replace
• M7 What-If Analysis
• M7 Flash Fill
• M7 Sparklines

Study Module 7

Advanced Features

• Exercise due

Due: Exercise 7

A Multiple Sheet Workbook for National Parks Data

• Assignments due

Quiz 7

on Module 7

Due: Activity 13

Module 7 chapter workbooks

Due: Activity 14

Team Template and Retirement Planning

• Peer reviews due
• Exercise due (moved earlier due to final exam due date on Friday)

Due: Peer Reviews

for Activities 13 & 14

Due: Exercise 8

Templates, 3D References, Goal Seek

• Final Exam Due