BUS 150 Study Guide - Pivot Table, Lookup Table, Sorting

• School: University of Miami
• Department: Business
• Course: BUS 150
• Professor: Maryann Barber

Document Summary

Information: data made useful by rearranging/processing (filtering, sequencing, calculating) E. g: filtering & calculating: average grade for sections, count of males & females, average gpa for majors. Sequencing & filtering: alphabetical list by majors/ just finance major. Field: (column) characteristic or attribute of the entity. Record: (row) stores data on a specific occurrence of the entity; made up of fields. Table (entity): stores data on a single entity type; made up of of records. Record layout: for every record is identical, same field in the same order. When you do searches, it is important to know if it is unique or non-unique. Simple table (structured data) vs excel table: created from a simple table with the insert table command. Filtering data : w/in the same field or, and can be done with numeric data (preset filters: between). Ascending: oldest date, smallest number, a-z vs descending order: newest date, largest number, z-a.