BIS 245 Innovative Educator/bis245.com

1
BIS 245 Innovative Educator/bis245.com
2
BIS 245 Innovative Educator

• BIS 245 Entire Course (Keller)
• For more course tutorials visit
• www.bis245.com
• BIS 245 Week 1-7 All Discussion Questions
• BIS 245 Week 1 Lab 1 Introduction to MS Visio and
  MS Access
• BIS 245 Week 2 Lab - Skills Development in Visio
• BIS 245 Week 3 Lab - Visio ERD
• BIS 245 Week 4 Lab - ER Diagram

3
BIS 245 Innovative Educator

• BIS 245 Final Exam (Keller)
• For more course tutorials visit
• www.bis245.com
• TCO 1) Which object would you use to enter,
  delete, or modify data?
• (TCO 1) Which object would you use to retrieve
  customers who live in Germany and the United
  States?
• (TCO 1) To design a report you should do all of
  the following EXCEPT
• (TCO 1) Which of the following is NOT a Report
  Section?
• (TCO 1) A Detail line is used to

4
BIS 245 Innovative Educator

• BIS 245 Week 1 Lab 1 Introduction to MS Visio and
  MS Access (Keller)
• For more course tutorials visit
• www.bis245.com
• A. Lab BSBA BIS 245A-1B. Lab 1 of 7
  Introduction to MS Visio and MS AccessC. Lab
  Overview--Scenario/Summary
• TCOs1. Given a business situation in which
  managers require information from a database,
  determine, analyze and classify that information
  so that reports can be designed to meet the
  requirements.

5
BIS 245 Innovative Educator

• BIS 245 Week 1-7 All Discussion Questions
  (Keller)
• For more course tutorials visit
• www.bis245.com
• Week 1 DQ 1 - Databases and Gathering
  Requirements
• Week 1 DQ 2 - Choosing a Database
• Week 2 DQ 1 - Entity Relationship (ER) Modeling
• Week 2 DQ 2 - Database Table Design
• Week 3 DQ 1 - Conceptual Database Design
• Week 3 DQ 2 - Requirements Analysis
• Week 4 DQ 1 - Creating Queries from Woodcraft
  Database

6
BIS 245 Innovative Educator

• BIS 245 Week 1-7 All Labs (Keller)
• For more course tutorials visit
• www.bis245.com
• BIS 245 Week 1 Lab 1 Introduction to MS Visio and
  MS Access
• BIS 245 Week 2 Lab - Skills Development in Visio
• BIS 245 Week 3 Lab - Visio ERD
• BIS 245 Week 4 Lab - ER Diagram
• BIS 245 Week 5 Lab - ER Diagram and ER Matrix

7
BIS 245 Innovative Educator

• BIS 245 Week 2 Lab - Skills Development in Visio
  (Keller)
• For more course tutorials visit
• www.bis245.com
• A. Lab BSBA BIS 245A-2
• B. Lab 2 of 7 Skills Development in Visio
  Creation of MS Access Database
• C. Lab Overview--Scenario / Summary
• TCOs
• 1. Given a business situation in which managers
  require information from a database, determine,
  analyze, and classify that information so that
  reports can be designed to meet the requirements.

8
BIS 245 Innovative Educator

• BIS 245 Week 3 Lab - Visio ERD (Keller)
• For more course tutorials visit
• www.bis245.com
• Lab 3 of 7 Database Design Using Visio and Based
  on Data Requirements and Business Rules
• You have been asked to create a database model
  using MS Visio Database Model Diagram Template.
  The purpose of this lab is to provide experience
  designing, with limited instructions, a simple
  database based on a list of data requirements and
  associated business rules.

9
BIS 245 Innovative Educator

• BIS 245 Week 4 Lab - ER Diagram (Keller)
• For more course tutorials visit
• www.bis245.com
• Page 1 of 5
• A. Lab BSBA BIS 245A-4A
• B. Lab 4A of 7 Database design based on data
  requirements and business rules focusing on
  interpreting business rules to determine
  relationships.
• C. Lab Overview --Scenario/Summary
• TCO(s)

10
BIS 245 Innovative Educator

• BIS 245 Week 5 Lab - ER Diagram and ER Matrix
  (Keller)
• For more course tutorials visit
• www.bis245.com
• A. Lab BSBA BIS 245A-5A
• B. Lab 5A of 7 Database design using Visio, and
  based on data requirements and business rules
  focusing on normalizing data to third normal
  form.
• C. Lab Overview--Scenario/Summary
• TCO(s)
• 2. Given a situation containing entities,
  business rules, and data requirements, create the
  conceptual model of the database using a database
  modeling tool.

11
BIS 245 Innovative Educator

• BIS 245 Week 6 iLab Creating Reports (Keller)
• For more course tutorials visit
• www.bis245.com
• A. Lab BSBA BIS 245A-6B. Lab 6 of 7 Creating
  ReportsC. Lab Overview Scenario / Summary
• TCO(s) 7. Given a database application with a
  completed relational schema, populated tables,
  and business reporting requirements, create the
  necessary reports and make a business decision.

12
BIS 245 Innovative Educator

• BIS 245 Week 7 iLabDevry University (Keller)
• For more course tutorials visit
• www.bis245.com
• BIS 245 Week 7 iLabDevry University

13
BIS 245 Innovative Educator