IS 171 Computing with Spreadsheets Introduction to Spreadsheets

  • Slides: 13
Download presentation
IS 171 Computing with Spreadsheets Introduction to Spreadsheets Week 1 Fred Ferwerda

IS 171 Computing with Spreadsheets Introduction to Spreadsheets Week 1 Fred Ferwerda

Introduction o Course Overview and Policies o Where do spreadsheets fit? o The history

Introduction o Course Overview and Policies o Where do spreadsheets fit? o The history of spreadsheets o Intro to Excel 2/20/2021 Fred Ferwerda 2

The Idea of a Spreadsheet o What is a spreadsheet? o What are its

The Idea of a Spreadsheet o What is a spreadsheet? o What are its uses? o Have you ever used a spreadsheet? 2/20/2021 Fred Ferwerda 3

A Brief History of Spreadsheets o The accountant’s paper ledger o Dan Bricklin and

A Brief History of Spreadsheets o The accountant’s paper ledger o Dan Bricklin and Visi. Calc o Mitch Kapor and Lotus 1 -2 -3 o Bill Gates and Microsoft Excel 2/20/2021 Fred Ferwerda 4

The accountant’s paper ledger o o Big sheets of paper (spread out the sheets?

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 2/20/2021 Fred Ferwerda 5

Dan Bricklin (1951 -) and Visi. Calc o 1979 – Spreadsheet on Apple II

Dan Bricklin (1951 -) and Visi. Calc o 1979 – Spreadsheet on Apple II o Visible calculator o Pushed sales of personal computers 2/20/2021 Fred Ferwerda 6

Mitch Kapor (1950 -) and Lotus 1 -2 -3 o 1982 – Spreadsheet on

Mitch Kapor (1950 -) and Lotus 1 -2 -3 o 1982 – Spreadsheet on IBM PC o First to include Charts and Graphs o Very successful http: //www. nb-info. co. uk o 1985 – Bought out Visi. Calc 2/20/2021 Fred Ferwerda 7

Bill Gates and Microsoft Excel o 1985: originally written for Apple II o 1987:

Bill Gates and Microsoft Excel o 1985: originally written for Apple II o 1987: shipped with the introduction of the first Windows Oper. Sys. o Graphical interface 2/20/2021 Fred Ferwerda 8

Introduction to Excel o Spreadsheet: Excel calls it a Worksheet o A Workbook is

Introduction to Excel o Spreadsheet: Excel calls it a Worksheet o A Workbook is a collection of worksheets o Grid of columns (labeled alphabetically) and rows (labeled numerically) o Each box is called a cell o Each cell is named by its cell reference (cell address) which is the column letter followed by the row number (e. g. , B 3) 2/20/2021 Fred Ferwerda 9

More on Excel o o Cells may contain: n Text (literals) n Numeric Data

More on Excel o o Cells may contain: n Text (literals) n Numeric Data (numbers, percents, dates) n Formulas (=B 3+C 3) Electronic spreadsheet does the paper version one better: it performs the calculations 2/20/2021 Fred Ferwerda 10

Advantages o Labor Savings n n Increase all salaries for a company by 3%.

Advantages o Labor Savings n n Increase all salaries for a company by 3%. Do this for 10, 000 or more employees! o Allows "what-if" analysis using scenarios o Allows graphing and charting o Allows use of complex functions (PMT, FV) o Allows data to be passed between worksheets 2/20/2021 Fred Ferwerda 11

Components of a Worksheet o Title Bar o Menu Bar o Toolbars n n

Components of a Worksheet o Title Bar o Menu Bar o Toolbars n n n Standard toolbar Formatting toolbar View Toolbars menu option to display additional toolbars o Formula bar (active cell address and displayed value) o Worksheet area and scroll bars o Worksheet tabs 2/20/2021 Fred Ferwerda 12

Don’t let this happen to you! TM & © 2002 Grimmy, Inc. Mike Peters

Don’t let this happen to you! TM & © 2002 Grimmy, Inc. Mike Peters from http: //www. grimmy. com (9/5/02) 2/20/2021 Fred Ferwerda 13

Computing Spreadsheets Computing Year 56 Spreadsheets Ordering andComputing Spreadsheets Computing Year 56 Spreadsheets Ordering and
Computing Spreadsheets Year One Computing Year 56 SpreadsheetsComputing Spreadsheets Year One Computing Year 56 Spreadsheets
CPSC 130 Computing with Spreadsheets Introduction to SpreadsheetsCPSC 130 Computing with Spreadsheets Introduction to Spreadsheets
Introduction to Spreadsheets Fundamental Skills 1 Spreadsheets AIntroduction to Spreadsheets Fundamental Skills 1 Spreadsheets A
ICT Spreadsheets Lesson 1 Introduction to Spreadsheets ObjectivesICT Spreadsheets Lesson 1 Introduction to Spreadsheets Objectives
Spreadsheets for Accounting Introduction to Excel Spreadsheets 1Spreadsheets for Accounting Introduction to Excel Spreadsheets 1
Introduction to Spreadsheets What are Uses of SpreadsheetsIntroduction to Spreadsheets What are Uses of Spreadsheets
Al Baqarah 168 171 Sapi Betina 168 171Al Baqarah 168 171 Sapi Betina 168 171
Kwartvoorsewelelie 8 Bladsy 171 187 Bladsy 171 BettieKwartvoorsewelelie 8 Bladsy 171 187 Bladsy 171 Bettie
Liturgie Gz 171 1 2 Gz 171 3Liturgie Gz 171 1 2 Gz 171 3
Liturgie Gz 171 1 2 Gz 171 3Liturgie Gz 171 1 2 Gz 171 3
Pz V Sdkfz 171 Patrick Cannaerts Sdkfs 171Pz V Sdkfz 171 Patrick Cannaerts Sdkfs 171