Practicum B

Either Practicum A or Practicum B must to be completed. Due date is published on Blackboard.

Question 1 (20 Points)

Build a UML Class Diagram that visualizes the ontology for the terms, attributes, constraints, etc. contained in this set of notes from an information collection session by a business analyst.
Information for Ontology
  • ​​The key to customized courseware to support customized training programs is the proper organization and development of supporting course materials, including presentation decks, exercises - with solutions, instructor notes, and examples.
  • At TTCG, courses are organized into modules. Each module is dedicated to a topic and is divided into units that last no more than 20 minutes, so that three units are an hour of material. Research has shown that workshop participants need to take a break at least once every hour, hence the insistence that a module be one hour or less.
  • To support teaching a unit requires a presentation deck, at least one example, and an exercise. It also needs instructor notes to support delivery by other instructors. All exercises must have a sample solution.
  • A customized course consists of one or more modules depending on the available time for delivery.
  • When customizing a course, an instructional designer (ID) works with the client to determine what topics should be covered and to what depth. Based on that conversation, the ID selects topics and organizes them into modules. There should be enough enough units so that each module takes exactly one hour.
  • A main customizing task is the creation of a custom presentation slide deck for each unit. Each presentation deck is one or more slides plus pre-recorded videos and demonstrations. These elements are commonly called presentation materials.
  • Workshop participants receive a workbook containing the modules organized by topics and units. For each unit, there are the presentation slides plus narratives for each slide so that the workbook is useful after the course.
Use Cases (Competency Questions)
  1. How are custom courses organized?
  2. What are the materials that must be prepared for a new course?
  3. What materials does a participant receive?
  4. How can an instructor prepare for teaching a course?
​As you build the diagram, realize that not every noun in the description is a class; some of them are likely attributes (or slots in ontology terminology) and others may not be relevant at all. Use your judgement but be mindful of the use cases (competency questions) that your ontology must be able to support.

While you may use any tool for constructing the diagram, it is recommended that you use either LucidChart or Microsoft Visio. Include a JPG or PDF of your UML Class Diagram in your submission.

Question 2 (15 Points)

Write an XSL style sheet that transforms this Course XML document into a CSV with headers for four columns: cnum, pdu, cdu, price. Extract the data from the XML file with the following mapping:
  • the number attribute of the <course> node is mapped to the column cnum
  • the child node <pdu> under <course> is mapped to the column pdu; likewise for cdu and price
For example, the first two rows of the CSV file should look like this.
Picture
Include the CSV file as part of your submission, along with the file containing the XSL style sheet.

Question 3 (10 Points)

Inspect the SQL table creation statements in this script and build an Entity-Relationship (ER) diagram using the Crow's Feet notation. While you may use any tool for constructing the diagram, it is recommended that you use either LucidChart or Microsoft Visio. Include a JPG or PDF of your ER Diagram in your submission.

Question 4 (20 Points)

Download this SQL database creation script and use it to create a SQLite or MySQL database. Then create SQL queries that answer the following questions:
  1. List the course number, title, and name of the author of each Business Analysis course.
  2. List all courses authored by Greta Deblasio.
  3. How many courses are offered?
  4. Which courses are suitable for Business Analysts?
  5. Who can teach either AD200 or DA100?
Submit the SQL code for each query and a screen shot of its output.

Question 5 (10 Points)

Load the Course Data XML file into Freeformatter.com and then write XPath expressions to obtain the following data:
  1. List the course number and title of each course.
  2. List the course numbers of all Business Analysis courses.
Submit the XPath expression for each query and a screen shot of its output.

Question 6 (15 Points)

For the potential information system constructed or used in Question (1), describe a security architecture in at least 1000 words. Specifically describe how you would deal with information security, privacy, and confidentiality. Are there other concerns that would need to be addressed?

Question 7 (15 Points)

Using a tool of your choice (or drawn by hand), sketch a process flow for creating a custom course using the notes from Question (1). The diagram must contain swimlanes, documents, databases, and tasks. If you can anticipate branch points in the flow, add them as well.

Question 8 (5 Points)

Describe (in at least 750 words) an information collection method in detail by which you would conduct a time study of the process described in Question (7). Pay particular attention to techniques used, likely biases to keep in mind, and analysis approach and tools.

Question 9 (10 Points)

What is the expected execution time of the process modeled below? Provide a detailed answer and show calculations.
Picture

Scoring

Total Number of Earnable Bonus Points: 100 +20 bonus points
Approximate Time to Complete: 4-6 hours
Due Date: see Calendar or Blackboard