Exam 1 Review Sheet

The exam will begin at 8AM, Thursday, Oct. 3, in B-21. Questions may come from Chapters 1 through 5 (up to p. 164) of Simkin’s Core Concepts of Accounting Information Systems or from class notes. I expect the exam will contain ~40 points in multiple choice questions and about 30 points in short discussions.
Study tips: Learn to use the features of the text book. Study end-of-chapter material such as Key Terms and Test Yourself. Review the objectives at the beginning of each chapter and compare with the chapter-end summaries.
Terms you should know (by chapter): * AIS, audit trail, business intelligence, dashboard, e-business, ERP, ISACA, KPI, REA, SAR, sustainability reporting, VARs * GUI, MICR, operating system, OCR, pixels, POS, primary memory, RAID, secondary memory, SAAS, turnaround documents * Agent, attributes, event, cardinality, concurrency, field, data modeling, DBA, DBMS, entity, E-R diagram, foreign key, 1NF, 2NF, 3NF, record, relationship, table, transaction file, transitive dependency * DDL, DML, default value, field properties, input mask, query, referential integrity, schema, SQL, validation rule * Bound control, calculated field, control break, tab order, unbound control
You should be able to: * Describe an accounting information system * Distinguish between data and information * Discuss how IT has impacted areas in accounting * Discuss why IT is important to accountants * Discuss the potential impact of an AIS on how accountants work * Describe the data hierarchy in computer systems * Contrast a data warehouse with an operational database * Compare three techniques for capturing and recording accounting data * Define the word entity as used in entity-relationship diagrams * Discuss pros and cons of cloud computing * List and describe 4 ways a