Section2.0 - Module 2 Introduction Spreadsheets are useful...

Info iconThis preview shows pages 1–4. Sign up to view the full content.

View Full Document Right Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Module 2 Introduction Spreadsheets are useful tools for mass calculations, data summary and graphical representations of data. Spreadsheets are used in most workplaces to calculate budgets or payroll or even just to keep track of how much money everyone has put into the retirement gift fund! Knowledge of spreadsheets opens many doors in the work world. Employers value employees who can create, manipulate and manage a good spreadsheet. Skills such as using formulas and formatting spreadsheets help lay the foundation of spreadsheet knowledge. The goals of this module are: to learn how to use a common computer tool the electronic spreadsheet to become familiar with spreadsheet terminology and basics to learn some fundamental concepts from computer science to learn some fundamental design principles More specifically, by the end of the module, you will be able to: enter data and formulas into a spreadsheet distinguish between relative and absolute references and choose which to use when creating a spreadsheet formula identify and create named cells and ranges create formulas using a variety of spreadsheet functions, including simple arithmetics, text functions, and table look-ups express complex conditions using nested if-then-else logic format a spreadsheet for effective display and maintenance CS 100 Module 2 2.2 2.0 Introduction to Spreadsheets © 2009, University of Waterloo Programs to manipulate spreadsheets were among the first applications to earn the title “killer app,” since they demonstrated that computers could be used effectively by those who were not expert computer scientists. The first successful spreadsheet program was VisiCalc, invented by Dan Bricklin and Bob Frankston (Harvard Business School) in 1978. Photo from D. J. Power, “A Brief History of Spreadsheets,” http://www.dssresources.com/history/sshistory.html VisiCalc, and all spreadsheet programs that came after it, provided automation for common paper-based accounting practices. Therefore accountants and other financial officers were well-familiar with the user interface and found it natural to enter data and formulas and interpret the output that was presented. Soon others found the simplicity of working with rows and columns of data convenient for many diverse applications, and spreadsheet programs grew in popularity. Today spreadsheet software is a part of every collection of productivity tools, including Excel (from Microsoft), Quattro Pro (from Corel), Lotus 1-2-3 (from IBM), and Calc (from OpenOffice.org). In CS 100, you will use Excel or Calc , both of which can work with .xls files. Throughout these notes, examples will be displayed from Excel , but CS 100 Module 2 2.3 they would appear essentially identically in any other spreadsheet application....
View Full Document

Page1 / 35

Section2.0 - Module 2 Introduction Spreadsheets are useful...

This preview shows document pages 1 - 4. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online