Spreadsheet

Spreadsheet Module (Revised Oct. 15)

Date	Assignment	MyItLab	Group	Assessment
Oct. 12	Introduction to Excel Video on computer literacy
Oct. 14	Terminology Part 2
Oct. 16	Charts
Oct. 19	Formulas and Functions Bonus and Sample Notes on Operators
Oct. 21*	9a	(10)
Oct. 23	Upload PowerPoint or Spreadsheet on Terms due Oct. 26 (Note change in date)		(25)
Oct. 26*	Oct. 27 is the last day to withdraw 9b	(10)
Oct. 28	10A in MyITLab (opt. 5 pt.)
Oct. 30	Review for Excel and Concepts exams
Nov. 2	Excel Project Due Wednesday, Nov. 4 Data			25
Nov. 4	Objective exam on Excel			25
Nov. 6	Excel workbook with two worksheets using template	(5)

Objectives

1. Learn to use a spreadsheet, including formulas, functions, charts, and applications

2. Learn about storage devices and types of software, including destructive software, and other terms

3. Learn about UH Policies on Internet privileges

Learning Outcome 3
Use a search engine to locate sources of information

Learning Outcome 4
Define, explain, and demonstrate proper computer terminology usage (Chaper 1, Part 2)
Complete online terminology quiz (on terminology and Excel concepts)

In-class Activity

We'll be working in Chapter 5 (Projects 9A and 9B) and possibly Chapter 6 (Projects 10A and 10B).

When you open Excel, you are opening a workbook with three worksheets: Sheet 1, Sheet 2, and Sheet 3. Open the spreadsheet and study the different parts. Your instructor will show you how to enter your name on three sheets at the same time. You'll be placing your name in cell A1.

___ Change the name of the first worksheet tab to Mod 1.

___ Change the name of the second worksheet tab to Mod 2. Repeat for five modules.

___ Familiarize yourself with the parts of the Excel window and the Home Ribbon.

___ Work on Charts

___ Computer Terms Part 2

Homework

Exam Preparation

___ Chapter 1, Part 2 Terms.

___ Review for concepts quiz. (.ppt)

Assessment

Complete the Spreadsheet Project.

Complete Objective Exam covering spreadsheet terminology and the Chapter 1 concepts with score of 60% or higher.

Prepare for the concepts portion of the exam by going over the chapter questions at the end of Chapter 5 and part of Chapter 6.

Study questions for spreadsheet terminology related to Excel:

Where is the formula bar?
Where are the Sheet tabs?
What is the difference between a cell and a range?
What is the quick way to select a range?
How do you select nonadjacent ranges?
What is the Fill handle? Draw a sketch of a cell with a fill handle.
If text "bleeds" over from one column to another, does it occupy two cells?
What is the default width of a column in pixels?
How does one insert or delete rows?
Describe three number formats in Excel.
How do you change the number of decimal places?
What conditions must occur for you to consider using an absolute cell reference?
Should a total be included in pie chart?
Is it possible to add pictures to a chart? How?
Name two ways to put a header or footer in a spreadsheet.
How can you put a spreadsheet that might print on 1.5 sheets of paper on one sheet of paper?

Additional Links

http://www.listeningtowords.com/lecture.php?id=613 Origins and Impact of Visicalc (click on video)

http://people.usd.edu/~bwjames/tut/excel/3.html (introduction tutorial)

http://video.google.com/videosearch?hl=en&rls=com.microsoft:*&um=1&q=worksheet%20excel&ie=UTF-8&sa=N&tab=iv&start=0# (Excel formula; some coughing)