Summer A 2017 Class Schedule


Class
Date
Chapter
Coverage
Assignment
Due Date
1
05/15/2017
Introduction & Chapter 1
AIS: An Overview



2
05/16/2017
No Class



3
05/17/2017
Chapter 2 & 3
Transaction Processing & ERP
Systems Documentation Techniques
Model Assignment #1
05/22/2017
4
05/18/2017
Preparing DFD's

Depending on the first letter of your last name complete Problem 7 (A-L), or Problem 5 (M-Z) in Chapter 3 of your textbook. For all problems first prepare an Entities and Activities table then proceed with the problem preparing a context-level DFD and a Level-0 DFD. When finished submit your file(s) in either .pdf or .jpg format via WebCourses.
05/23/2017
5
05/22/2017
Preparing FlowCharts

Assignment #3: Complete the Flowchart (be sure to prepare the flowchart asked for in the problem), from assignment #2. When finished submit your file(s) in either .pdf or .jpg format via WebCourses2 (Canvas).
05/24/2017
6
05/23/2017
Chapter 4
Relational Databases/Queries


7
05/24/2017
Chapter 4
Relational Databases/Queries Continued
Complete Problem 3 in chapter 4, For requirements a-c your design should be similar to Table 5. If using Access you must use Access 2010 nothing earlier, if you don't have it, complete your assignment in one of the campus labs. You are required to do A-F. You need to have at least 3 queries: 1) Simple with fields from 1 table; 2) Simple with fields from 2 or more tables; 3) a query that contains a calculation.

After completing your database, please upload just the database file.
05/30/2017
8
05/25/2017
Exam 1
Covers Chapters 1 - 3, DFD and Flowcharts


9
05/29/2017
No Class
Memorial Day


10
05/30/2017
Chapter 5
The REA Data Model


11
05/31/2017
Chapter 5
The REA Data Model Cont'd
Depending on the first letter of your last name complete Problem 2 (A-L) or, Problem 1 (M-Z) from chapter 5. Use Draw.io to create your REA diagram.
06/03/2017
(This is a Saturday)
12
06/01/2017
Chapter 6
Implementing an REA Data Model - Cont'd
If you did problem #1 or #2 for the REA assignment prepare an integrated REA for Joe's Ice Cream. Prepare a table listing the relational database based on your integrated REA. The table should include the table names, primary keys, foreign keys and non-key attributes. For your table of primary/foreign keys use Word (or other word processing program to build a table). You do NOT need to create tables using Access for this assignment.
06/04/2017 (This is Sunday)
13
06/05/2017
Exam 2 (Ch 4, 5 and 6)



14
06/06/2017
XBRL - 1 & 2
XML and XBRL an Introduction


15
06/07/2017
XBRL - 2
XML & UBL
Ex 2-2
06/12/2017
16
06/08/2017
XBRL - 3
UBL Schema
Ex 3-2 - submit two files .xml and .xsd
06/13/2017
17
06/12/2017
XBRL - 4
XBRL


18
06/13/2017
XBRL - 4
XBRL
Ex 4-1, 4-2 & 4-3 - only one file should be submitted.
06/14/2017
19
06/14/2017
XBRL - 6
iXBRL


20
06/15/2017
Exam 3 - XBRL
White - Chapters (1-4)
Example Test Questions (1 per chapter)

21
06/19/2017
Tableau
Introduction


22
06/20/2017
Tableau
Creating Charts
Chart Assignment
06/21/2017
23
06/21/2017
Tableau
Creating Dashboards
Dashboard Assignment
06/22/2017
24
06/22/2017
Tableau

TBD
06/23/2017
(Must be submitted before taking the exam)
25
06/23/2017
Exam 4 - Tableau