[ITM 207] - Final Exam Guide - Everything you need to know! (80 pages long)

• School: Ryerson University
• Department: Information Technology Management
• Course: ITM 207
• Professor: Arthur Wrigglesworth

Document Summary

Information system: software that helps the user organize and analyze data. Electronic spreadsheets and database management systems: software tools that allow user to organize, manage and analyze data in various ways. Spreadsheets: a software application that allows users to organize and analyze data using a grid labeled cells. Cells: contain data or formula that is used to calculate a value. Data stored can be text, numbers or special" data (dates) Spreadsheet cells are referenced by their row and column designation. Set of formulas that ultimately rely on each other. Spreadsheets useful due to their dynamic nature (provides the powerful ability to do what-if analysis) Database management system (dbms): a combination of software and data, made up of physical database, a database engine and a database schema. Physical database: a collection of files that contain the data. Database engine: software that supports access to and modification of database contents.