Mic 102e - Introduction to MS Excel

Course Description

This course provides the student with an introduction to using Microsoft Excel.

Prerequisites

Basic understanding of Windows operation and navigation is recommended.

Student Outcomes

After completing this course the students will be able to:

  • Create an Excel workbook with multiple worksheets
  • Create and edit formulas
  • Create charts
  • Format text and use styles in spreadsheets.

Textbook

There is no textbook to purchase for this course. Materials will be presented in class, and may be supplemented with handouts and web resources.

Course Schedule

Please note that this may change.

Day Topic/Discussion Book Chapters
1

Introduction to class

What all can excel do?

Excel window orientation

Moving around a worksheet

Dealing with cells, columns, and rows

Copying and moving cell entries

Editing cell entries

 

1, 2, 3
2

Formatting worksheets

Printing

Creating, inserting, and using formulas

 

4, 5, 6
3

Using multiple worksheets

Creating charts

Formatting charts

Modifying charts

 

7 & 10
4

 

Enhancing text

Adding and Modifying borders

Creating 3-d objects

Using styles

Using autoformats

 

8 & 9

Grade Scale

Attendance 80 points
In class work 5 points each (20 points total)
Total 100 points