Information Systems for Business Impact

Chapter 1: Introduction
Look Up!
Introduction to Microsoft Excel
Creating a Schedule in Microsoft Excel
Your Turn

Chapter 2: The Need for Cash
Look Up!
Business Concepts
Cash Flow Forecast
Cash Inflows and Outflows
Net Excess (Deficiency)
Beginning Balance
Microsoft Excel Concepts
Formulas and Functions
Absolute and Relative Referencing
Formula View
Creating a Cash Flow Forecast using Microsoft Excel
Your Turn

Chapter 3: Investment Decisions
Look Up!
Business Concepts
Loans
Net Present Value
Evaluating Alternatives
Microsoft Excel Concepts
PMT Function
What-if Data Table
NPV Function
Creating a Loan Analysis spreadsheet in Microsoft Excel
Your Turn

Chapter 4: Analyzing Data
Look Up!
Business Concepts
Data Analysis
Microsoft Excel Concepts
PivotTables
Charts and Graphs
Importing CSV and Text Files
The Index (Match) Function
Creating PivotTables to Analyze Sales Data using Microsoft Excel
Your Turn

Chapter 5: Keeping Track of Data
Look Up!
Business Concepts
Inventory
Manufacturing
Management Reporting
Database Concepts
Tables
Records
Fields
Primary Key
Foreign Key
Relationships
Microsoft Access Concepts
Create Tables
Add Fields
Determine Primary Key
Join Tables
Create a Database and Tables for Customers and Products
Output the Datasheet
Your Turn

Chapter 6: Analyzing Data using Microsoft Access Queries 
Look Up!
Business Concepts 
Business Data Analysis - Revisited 
Microsoft Access Concepts 
Creating queries 
Query by Example (QBE)
Sorting
Single and Multiple Criteria 
And, Or Criteria 
Exporting Data 
Analyze Look Up! Data using Microsoft Access 
Your Turn 

Chapter 7: User Interfaces and Data Entry
Look Up!
System Design Concepts
User Interface Guidelines
Microsoft Access Concepts
Building a Form
Form Controls
Properties
Main/Subform
Create Data Entry Forms for Customers, Products and Sales
Your Turn

Chapter 8: Reporting Business Information
Look Up!
Business Concepts
Management Reporting
Microsoft Access Concepts
Report Wizard
Report Design
Report Headers and Footers
Page Headers and Footers
Arranging Objects
Properties
Create Microsoft Access Reports for Products and Sales
Your Turn

Chapter 9: The Next Big Idea: A Mobile App!
Look Up!
Business Concepts
Conducting Research for App Ideas
SWOT Analysis
Target Market
Microsoft Word Concepts
Paragraph Formatting
Headings
Page Numbers
Conduct Research and Prepare a Proposal for a Mobile App for LookUp!
Your Turn

Chapter 10: Start Designing the App: Wireframes
Look Up!
App Design Concepts
Wireframe
Storyboard
Sketches
Splash Screen
Navigation
MarvelApp Concepts
Create an Account
Create a Project
Create and Upload Images
Add Timers and Hotspots
Play the App
Share the App
Create a Wireframe Prototype of the LookUp! App
Your Turn

Chapter 11: Create a Detailed App Prototype
Look Up!
App Design Concepts
Detailed Prototype
Design Guidelines
Microsoft PowerPoint Concepts
Using the Slide Master
Inserting Textboxes and Shapes
Importing Graphics
Design Formatting
MarvelApp Concepts
Archiving your Project
Create a Detailed Prototype of the LookUp! App
Your Turn

Chapter 12: Create an App Icon and Sell Your App!
Look Up!
Icon Design Concepts
Design Guidelines
Using PowerPoint to Create an Icon
Creating an Icon for LookUp!
Your Turn

Chapter 13: A Business Plan to Launch Your App
Look Up! 
Business Concepts 
Business Plan 
Purpose 
Components
Microsoft Word Concepts 
Cover Page
Section Breaks 
Table of Contents 
Pagination
Page Headers and Footers
Headings 
A Business Plan for Look Up! 
Your Turn

Chapter 14: Presenting Your Business Plan 
Look Up
Proper Presentation Concepts 
Microsoft PowerPoint Concepts 
Title Slide 
Animation and Transitions 
Creating and Presenting a Proposal for LookUp!
Your Turn