Acct 4310 schedule: Fall 2009

1. Query databases to provide insights about business operations and performance
2. Design business processes and represent them with documentation tools
3. Design and implement well-structured databases to enable business processes.
4. Evaluate internal control in information systems and design controls to mitigate risks associated with information systems.

Class day: obj.

1. Examine learning outcomes
2. Course performance
   1. Identify graded items
   2. Prepare for exam questions
3. Find course resources
4. Complete learning research consent form in uLearn
5. Take CSP 1 Basic Skills quiz in uLearn
6. Get started on Car Maker/Car Dealer case

1. Satisfy CSPs for Basic Skills and Database Skills in uLearn. "Satisfy" means to attain 100% correct for both.
2. Read the business situation for the Car Maker/Car Dealer case and query the database (both parts), using as much of the provided assistance as you need. You are done when you can do the querying for each part in about 30 minutes.
   
   To facilitate querying and following the directions simultaneously, resize and reposition the windows with directions and the Access program to make them appear together on the screen.
   
3. Watch movie Outer joins

1. Car Maker/Car Dealer case
   1. How much querying did you need to do before you no longer needed any of the provided guidance for querying?
   2. What did you find out from the database?
   3. Prepare advice for the car maker and dealers: carMemo.htm
2. Search the web (google.com, ask.com, yahoo.com) and Alexander's ebook for Access help, e.g., for functions (MIN, ABS, ROUND) and for joining tables

1. Complete Car Maker/Car Dealer case querying
2. Answer Car maker/Car dealer questions in uLearn until you attain 100% correct.
3. Begin querying for the Romney problem 4.4 (p130) database. (Download to your disk first!) If you wish, work with other students.

1. Evaluate Car dealer/Car maker case progress: Querying and questions
2. Query the Romney problem 4.4 (p130) database. (Download to your disk first!)

1. With one or more other students, complete queries for all requirements of Romney problem 4.4 (p130).
2. With one or more other students, prepare list of query objectives for the Warranty Call Center case (Business situation, database)

Warranty Call Center case (Business situation, database)

1. Examine list of query objectives
2. Query the database

1. Warranty Call Center case (Business situation, database): Complete queries to answer:
   1. How much is technician expense over or under budget in:
      1. Minutes
      2. Dollars

1. Query to determine how much technician expense is over or under budget in:
   1. Minutes
   2. Dollars

1. Warranty Call Center case (Business situation, database): Complete queries to answer:
   1. How much is technician expense by productID and techLevel over or under budget in:
      1. Minutes
      2. Dollars
   2. When you need help, consult the Warranty Call Center Analysis in uLearn. The icon makes it look like a quiz, but it's not.

1. Warranty Call Center case (Business situation, database). Query to determine how much technician expense by productID and techLevel is over or under budget in minutes and dollars
2. Car dealer/car maker case: Examine questions in uLearn as models for exam questions

1. Prepare to answer exam questions
   1. Romney 4-4 queries
   2. Warranty Call Center queries

1. Warranty Call Center case: Business situation, database
   1. Answer questions in uLearn (exam 1 querying)
2. Determine initial business process expertise
   1. Open the business situation and diagram:
   2. Answer the EasyBuy questions in uLearn

1. Read Romney Chapter 3 and directions for flowcharting in Excel.
2. Warranty Call Center case (Business situation, database):
   1. Develop a flowchart in Excel or Visio for these processes:
      
      PC company designs, builds, and offers PCs for sale, customers order and take delivery of PCs, customers use PCs (sometimes encountering problems), customers call technical support, and technical support responds.
   2. Use black 8 pt font for text in the symbols, 1 pt lines with no fill for symbol shapes, as in these templates: Excel, Visio.
   3. Compare your flowchart with a complete flowchart.

1. Develop responses to documentation questions
2. Read Romney chapters 1-2
3. Examine 24-Seven part 1

1. Consider responses to documentation questions
2. Extract processes from 24-Seven part 1

1. Finish extracting processes from 24-Seven part 1 in groups of students
2. Prepare diagrams (one for the current system and one for the contemplated system)
   1. Select column headings: In-class
   2. Arrange headings to minimize crossed flow lines
   3. Identify events starting processes
   4. Put process events in order

1. Prepare 24-Seven part 1 diagrams (current and contemplated)

1. Work on 24-Seven part 1 diagrams (current and contemplated)

1. Answer 24-Seven part 1 practice questions in uLearn: Set 1
2. Develop ways to check diagrams
   1. Exchange with a partner(s)
   2. Audit: From conversation to diagram and from diagram to conversation
3. Examine/prepare 24-Seven part 1 diagrams

1. Complete 24-Seven part 1 diagrams

1. Answer 24-Seven part 1 practice questions in uLearn: Set 2
2. Debug 24-Seven part 1 diagrams
   1. Uncorrected: current and contemplated
   2. Corrected: current and contemplated

1. Prepare to answer exam questions

1. Answer 24-Seven part 1 questions (exam 2 documentation) in uLearn

1. Check on your progress on business process expertise
   1. Open the business situation and diagram:
   2. Answer the EasyBuy 2 questions in uLearn
2. Examine Introduction to BPMN and an example BPD
   1. How do flowcharts and BPDs differ?
3. Read the BloomScape conversation

1. Compare Warranty Call Center diagrams: Flowchart and BPD
2. BloomScape
   1. Examine the business processes
   2. Develop a process extraction strategy
   3. Form teams for BloomScape

1. In teams, extract BloomScape business processes

1. Improve learning strategies: GIFT questions
   1. Results: 1:00; 2:30
2. In teams, extract BloomScape business processes

1. Read Romney chapters 8, 10, 18
2. In teams, finish extracting BloomScape business processes

1. Develop BloomScape querying objectives
   1. Assure data quality
   2. Analyze business performance

1. Identify BloomScape events for a flowchart
2. Develop a BloomScape flowchart

1. Verify consistency of BloomScape diagram and query objectives

1. Read Romney chapters 15-16

1. Prepare an REA diagram: Directions
2. Develop BloomScape REA diagram
   REA cardinality shapes: Excel, Visio

1. Finish a BloomScape REA diagram
2. Read Romney pp. 316-332 and chapters 19-20

1. Consider how to edit objectives
2. Examine BloomScape REA diagrams
3. Structure a database for BloomScape: Directions

1. Implement BloomScape database; query the database

1. Identify BloomScape journal entries

1. Complete BloomScape journal entries
2. Prepare to answer practice questions

1. Answer BloomScape practice 1 questions in uLearn

1. Work in BloomScape teams

1. Get help with BloomScape querying

1. Work in BloomScape teams

1. Answer BloomScape practice 2 questions in uLearn
2. Get help with BloomScape querying

1. Submit all BloomScape project parts
   1. BloomScapeReport.htm
   2. BloomScape.xls (or .vsd) with separate sheets for the:
      1. System flowchart
      2. REA diagram
   3. BloomScapeQueries.mdb

1. Before class, zip BloomScape files and attach the zip file to a discussion message
2. Identify exemplary aspects of BloomScape projects: Evaluation template

1. Review BloomScape projects
2. Prepare to answer exam questions

1. Answer questions in uLearn (exam 3 design databases)

1. Read Romney chapters 7-8
2. Study internal control in payables and the Apex case

1. Consider practices for ensuring system security and reliability
2. Begin the table of control weaknesses and potential misstatements for the Apex case

1. Complete the table of control weaknesses and potential misstatements for the Apex case
2. Answer Apex questions in uLearn

1. Examine the table of control weaknesses and potential misstatements for the Apex case

1. Read Romney chapters 5-6
2. Add accounts payable processes to the 24-Seven (part 1, part 2) part 1 current system diagram

Begin constructing 24-Seven part 2 flowcharts

1. Read Romney chapter 9
2. Add accounts payable processes to 24-Seven (part 1, part 2) part 1 contemplated system diagram

1. Begin identifying control weaknesses for a table of control weaknesses and potential misstatements in 24-Seven (part 1, part 2)

1. Complete a table of control weaknesses and potential misstatements in 24-Seven as 24-SevenMisstatements.htm

1. Examine 24-Seven (part 1, part 2) table of control weaknesses and potential misstatements
2. Answer 24-Seven internal control practice questions in uLearn

1. Refine diagrams (current and contemplated) and table of control weaknesses
2. Prepare to answer exam questions

1. Answer questions (exam 4 internal control, based on 24-Seven: part 1, part 2)
   
   1:00 section: 12:30-2:30
   2:30 section: 2:45-4:45