Information Management Using Spreadsheets and Databases

Students obtain experience managing information using spreadsheet and database software applications for business and personal productivity through a problem-solving approach. Spreadsheet topics include formulas and functions, nested functions, representation of dates and date arithmetic, IF functions and nested IF functions, loan payment calculations, relative and absolute cell references, basic charts, filtering, what-if analysis such as goal seek and data tables. Database topics include tables, queries, forms, reports, relationships (one-to-many and many-to-many), primary and foreign keys, and validation. General topics include application design, testing and correctness, reliability, and usability.