01:198:170 Lecture Notes - Lecture 17: Common Application, Level Of Measurement, Spreadsheet

• School: Rutgers University
• Department: Computer Science
• Course: 01:198:170
• Professor: S Stoll

Document Summary

Inventory status: easy to share information, financial information, operational statistics, schedules, project plans, graphically display information, consolidate information, what-if scenarios, spot emerging trends. Computing with spreadsheets: spreadsheets don"t have to contain a single number to be useful, their most common application is to process numerical data, numerical data is usually associated with textual information so most spreadsheets allow both. Spreadsheet: an array of cells for setting up a list, the guide lines are part of the gui. It is convenient to name the rows and columns with more meaningful names by giving them headings. Format cells with merge & center, cell styles, and. Sorting the data: a common operation on any list is to alphabetize or sort it, we must specify which items to sort - highlighting. If the whole list is highlighted, how do we specify which column should be sorted: spreadsheet programs automatically provide a naming scheme for referring to specific.