Basic Computer Skills Module 5 Introduction to Microsoft ...

Basic Computer Skills Module 5

Introduction to Microsoft Excel 2010

PROFITT Curriculum

Module # 5 ? Introduction to Excel 2010

Basic Computer Skills Module 5

Introduction to Microsoft Excel 2010

Summary

Goals:

Instructor:

Identify spreadsheet terms. Create and manipulate worksheets and workbooks. Enter formulas and functions into a worksheet. Format cells within worksheets. Apply page setup features to enhance a worksheet.

Delivery Method(s): Lecture Hands On Lab Setting Group Work

SMART Objectives:

Specific, Measurable, Achievable, Realistic, and Time-sensitive

By the end of this module, students should be able to:

BCS5.1: Identify components of the spreadsheet window using industry terminology and efficiently navigate throughout the worksheets and workbook.

Length: Three Topics Total Length of 4 hours Any Applicable Business and/or Soft Skills?

BCS5.2. Apply editing and enhancement features to cell contents, e.g. edit, fill, rotate, move, merge, size, number formats, styles, borders, and colors.

Corresponding NLS Lesson #?

BCS5.3: Differentiate among and enter text, numbers, formulas, and functions.

BCS5.4: Create, insert, modify, and position appropriate graphics.

Take Away Message(s): Microsoft Excel 2010 will allow you to manage data effectively. Information such as contact information, inventory, and other data relevant to a small business can be analyzed quickly and easily.

Basic Computer Skills Module 5-1

PROFITT Curriculum

Module # 5 ? Introduction to Excel 2010

Instructor Preparation

Title of Module: Introduction to Microsoft Excel 2010

The intent of this module is to provide the students with a basic understanding of the internal and external hardware parts of a computer.

The following are potential introductory remarks as well as relevant context or background information that may be useful for the instructor.

Technology is ever evolving. Thus, certain topics/information in this module may change or become obsolete during the course of instruction. It is a good idea for the instructor to review all content for accuracy and relevance, and to be prepared to present updated information if necessary.

Agenda ? topics to be covered in the module and length of each item

Topic: Microsoft Excel

Time Allotted: 4 Hours

A. Spreadsheet vocabulary review

(1.5 hours)

B. Creating Spreadsheets

(1.5 hours)

C. Enhancing Spreadsheets

(1 hour)

Materials & Supplies ? items needed in order to carry out the agenda and classroom activities 1. Post-Its or index cards 2. Introduction to Excel 2010 supplementary video (5.A.3) 3. Handouts and PowerPoints for activities: Topic A ? Spreadsheet Vocabulary Review

Spreadsheet Vocabulary List BCS (5.A.1) Excel 2010 Screen Blank handout BCS (5.A.2) Topic B ? Creating Spreadsheets Grocery List BCS (5.B.1) Topic C ? Enhancing Spreadsheets

Basic Computer Skills Module 5-2

PROFITT Curriculum Employee List Handout BCS (5.C.1)

Module # 5 ? Introduction to Excel 2010

Classroom Preparation ? steps to follow when setting up the learning environment

1. Whenever possible, it is a good idea to create samples of each product to have ready for students to view and to anticipate any issues or concerns that may arise during instruction.

Basic Computer Skills Module 5-3

PROFITT Curriculum

Module # 5 ? Introduction to Excel 2010

Curriculum Content

A. Spreadsheet Vocabulary Review

(1.5 hours)

Objective BCS 4.1: Identify components of the spreadsheet window using industry terminology and efficiently navigate throughout the worksheets and workbook.

PREINSTRUCTIONAL ACTIVITIES

Identify and preview the unit vocabulary. Lead the transcribers-in-training in a discussion of their knowledge of and/or experience with Excel. First, ask students what they think a spreadsheet is and its purpose. Ask students to think of different ways that someone might use a spreadsheet. Ask them if they can identify any parts of a spreadsheet.

CONTENT PRESENTATION AND LEARNER PARTICIPATION

Lead the discussion with various ways to use spreadsheets and why. Students can follow along using the Spreadsheet Vocabulary List (5.A.1) which contains the words listed below.

Range

Fill Handle

Active Cell

Grid lines

Auto Format

Sheet

Numeric label

Graph

Sheet tab

Row

Label

Spreadsheet

Formula

Value

Workbook

Selecting

Cell

Column

Auto Sum

Cell Address

Open and project a new Excel screen so that all the students in the class can see it. If possible, use post-its or index cards to label parts of the screen as you discuss each term with students.

ASSESSMENT

Basic Computer Skills Module 5-4

 ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download