COT 0631004 – Introduction to Microsoft Excel

Fall2012 .5 Credit

Instructor: Joshua Nicholes775 293-8359 (Please no calls after 8:00 p.m.)

E-Mail:

Class Time: Thursday 7:00 pm - 9:00 pm

Class Dates: Nov.1stthruNov.15th

Book:Microsoft Excel2010 Brief by Elizabeth Eisner Reding

Catalog Description: This is a beginning course for those with no previous spreadsheet knowledge and an introduction to Microsoft Excel.

What is Microsoft Excel?

Microsoft Excel is a spreadsheet program that allows you to organize data, complete calculations, make decisions, graph data, and develop professional looking reports. The Three major parts of Excel are:

  • Worksheets: Allow you to enter, calculate, manipulate, and analyze data such as numbers and text. The term worksheet means the same thing as spreadsheet.
  • Charts: Pictorially represent data. Excel can draw a variety of two-dimensional and three-dimensional charts.
  • Databases: Databases manage data. For example, once you enter data onto a worksheet, Excel can sort the data, search for specific data, and select data that meet criteria.

Topics Covered

Day 1: Introduction To Microsoft Excel

Login Procedures

Expectations & Grading

Unit A – Getting Started with Microsoft Excel

Begin Unit B – Working with Formulas and Functions

Day 2: Finish Unit B – Working with Formulas and Functions

StartUnit C - Formatting a Worksheet

Day 3:Finish Unit C - Formatting a Worksheet

Unit D – Working with Charts

Grading will be based on attendance. Each class you attend will be worth 100 points. This makes a total of 300 Points, since this is a pass / withdraw course, should the student score under 200 points the student will receive a “W” withdrawal.

Expectations/Outcomes

Should students meet above criteria, they will have a solid understanding of the basic Microsoft Excel capabilities and functions. The successful student in this class will be able to perform the following tasks:

  1. Create and Edit spreadsheets with Excel
  2. Work with formulas and functions
  3. Create and Edit Formulas with Excel
  4. Format text and graphs with Excel

Each student outcomewill be measured by performance in class and on assignments. Additionally students will present completed projects for grading to the instructor.Studentswho meet the above criteria will gain a solid understanding of the basic Microsoft Word capabilities and functions.

Student Outcome Measurement
Measurement Method / Learner Outcomes
Class Discussion / Units- A,B,C,D
Hands on exercises / Units- A,B,C,D
Exams / Units- A,B,C,D

Emergencies If there is an emergency and the student cannot attend class, the student must contact the instructor and return to the next class with all work completed.

NO CALL – NO SHOW / NO MAKE-UP

*Please leave your cell phones off during class as they are a disruption to the rest of the students

ADA Statement:

GBC supports providing equal access for students with disabilities. An advisor is available to discuss appropriate accommodations with students. Please contact the ADA Officer, Julie Byrnes, in Elko at 775 753-2271 at your earliest convenience to request timely and appropriate accommodations.