CPSC 130 Computing with Spreadsheets Introduction to Spreadsheets

CPSC 130 Computing with Spreadsheets Introduction to Spreadsheets Week 1 Brenda Vander Linden and Aaron Armstrong

Introduction o o o Course Homepage Syllabus Assignment Schedule Where do spreadsheets fit? The history of spreadsheets Intro to Excel 5/19/2021 Brenda Vander Linden and Aaron Armstrong 2

The Idea of a Spreadsheet o o What is a spreadsheet? What are its uses? 5/19/2021 Brenda Vander Linden and Aaron Armstrong 3

Where Do Spreadsheets Fit? o o o Bit Byte, number, character, string Field Record File/Table Database 5/19/2021 Brenda Vander Linden and Aaron Armstrong 4

A Brief History of Spreadsheets o o The accountant’s ledger Dan Bricklin and Visicalc Mitch Kapor and Lotus 1 -2 -3 Bill Gates and Microsoft Excel 5/19/2021 Brenda Vander Linden and Aaron Armstrong 5

The accountant’s paper ledger o o Big sheets of paper (spread out the sheets? ) Permits storing figures Fig. 1. 1, p. 2 of book 5/19/2021 Brenda Vander Linden and Aaron Armstrong 6

Dan Bricklin (1951 -) and Visi. Calc o o 1979 Visible calculator Apple II Pushed sales of personal computers 5/19/2021 Brenda Vander Linden and Aaron Armstrong 7

Mitch Kapor (1950 -) and Lotus 1 -2 -3 o o o 1982 Spreadsheets for presentation too Wildly successful http: //www. nb-info. co. uk 5/19/2021 Brenda Vander Linden and Aaron Armstrong 8

Bill Gates and Microsoft Excel o o o 1985: originally written for Apple II 1987: shipped with introduction of Windows Graphical interface 5/19/2021 Brenda Vander Linden and Aaron Armstrong 9

Introduction to Excel o o o Spreadsheet: Excel calls it a Worksheet A Workbook is a collection of worksheets Grid of columns (labeled alphabetically) and rows (labeled numerically) Each box is called a cell Each cell is named by its cell reference (cell address) which is the column letter followed by the row number (such as B 3) 5/19/2021 Brenda Vander Linden and Aaron Armstrong 10

More on Excel o Cells can contain n Constants (literals) o o n Formulas o o 1239 Hello =(B 3+C 3) Electronic spreadsheet does the paper version one better: it performs the calculations 5/19/2021 Brenda Vander Linden and Aaron Armstrong 11

Advantages o Labor Savings n n o o Change all salaries for an company. Do this for 1000 or more employees! Allows "what-if" analysis; can play with the numbers… Allows graphing and charting 5/19/2021 Brenda Vander Linden and Aaron Armstrong 12

Components of the Interface o o o Active cell Displayed value Formula bar Name box Worksheet tabs Toolbars n n n o Standard toolbar Formatting toolbar View menu to change toolbars displayed Entering/replacing cell contents (Enter or arrow keys) 5/19/2021 Brenda Vander Linden and Aaron Armstrong 13

Don’t let this happen to you! TM & © 2002 Grimmy, Inc. Mike Peters from http: //www. grimmy. com (9/5/02) 5/19/2021 Brenda Vander Linden and Aaron Armstrong 14