Prof. Johnson teaches Data and Knowledge Management



I’ve had a couple of inquiries so I’ll make this announcement to the whole class: I expect to have final grades done on Monday, December 20.

Group Project Presentation Order

Here’s the presentation order for Wednesday evening.

  1. SmartPhone: Felicia, Jim, Judy, Patricia
  2. Mobile: Adi, Brandon, Isaac
  3. GPS: Deborah P., Gene, Ping, TJ
  4. ERP: Dawn, Venessa, Venkata, Yen
  5. EMR: Deborah H., Tuyet, Yikum
  6. EHR: Diane, Gloria, Gloria, Shiny
  7. Coding: Candice, Lesia, Michele, Tonya

See you soon.

Week 13 Follow-Up

Class Re-Cap

FoxNet Capture.

Final exam format

—Take-home: 5PM questions posted to class blog, 8PM due via email in a Word-compatible attachment

Open-note (including course blog): no other outside assistance or Internet assistance

4 short answer questions

  • Multiple bullet point answer or up to 1 paragraph answer
  • ~ 60% of grade (4 x 15% each)
  • Example: “What are 3 pros and 3 cons of giving ad-hoc SQL query access?” —

1 essay question

  • multi-part question or more involved question ¡mutli-paragraph answer required
  • pick from 2 or 3 choices
  • ~ 40% of grade
  • Example: “Temple University is looking for new revenue streams. They want your advice: should they offer to sell marketers the list of student email addresses? Why or why not?”

The study guide distributed in class is available here: MIS5101 Final Exam Study Guide

Group Project Presentation Guidelines

Here are guidelines for the group project presentation. Post any questions in comments or send me an email.


The goal of your presentation is to address the following questions:

(A) What business problem are you solving?

(B) How do you propose solving it?

(C) How will the solution provide business value?

Pretend that the audience (your fellow classmates) will be making an up-or-down decision on whether or not to fund the proposed project. Remember that the audience has not read any of your individual or group projects.


  • Your presentation should be 9-12 minutes long and will be followed by up 2-4 minutes for questions (and then 1 minute between presentations).
  • It is highly recommended that you practice your presentation so you can be sure you can efficiently and effectively get through all of the required material in the allotted time!
  • One or more group members may deliver the presentation, but all group members are expect to be present and available to answer questions about the project. During the presentation all group members should join together with the presenter at the front of the room.
  • Please put any electronic materials on a memory stick or post to the web in a readily available location.
  • Although these will be considered formal presentations, there is no dress code. Wear whatever you are most comfortable in for making a convincing presentation to fellow students.

Evaluation and Feedback

  • Presentations will be evaluated by these criteria:
  1. Content: Clear description of business problem
  2. Content: Effective justification of business value
  3. Content: Convincing discussion of project feasibility
  4. Presentation: Delivery and pacing
  5. Presentation: Connection with audience
  6. Overall Impression: Assessment of project
  • To facilitate active participation by audience members, everyone will complete and turn-in evaluation forms for the other group presentations. The completed evaluation forms will be used to anonymously inform additional constructive feedback. They will not be used to determine a grade.

Week 11 Follow-Up and Week 12 Reading

Week 11 Followup

Unfortunately, there is no Fox Class Capture available for Wednesday’s class. (The class capture did not follow us to the computer lab.) You can find a copy of the database we used for the exercises, along with the hand-out from class, here.

Week 12

Assigned reading:

a) Pivot Table Reports 101 (expand sections at bottom of page to read entire page.)

b) Learn to use Pivot Tables in Excel 2007 to Organize Data. If you have never used Pivot Tables before, or at a little bit rusty with them, I highly recommend downloading the example spreadsheet (available at the bottom of the article) and working through the examples.

c) Chapter 4 (Hacking Pivot Tables) of Excel Hacks, Second Edition by David Hawley and Raina Hawley (2007). Free online access available via Safari books online via Temple Library — on campus or search for Safari at Temple library database finder.

Reading discussion question:

a) When would you prefer to have a “data dump” to analyze data with Excel pivot tables and when would you prefer to use Access queries?

Ad Hoc Queries

ad hoc

Wikipedia provides a short definition of ad-hoc queries:

Ad hoc querying is a term in information science.

Many application software systems have an underlying database which can be accessed by only a limited number of queries and reports. Typically these are available via some sort of menu, and will have been carefully designed, pre-programmed and optimized for performance by expert programmers.

By contrast, “ad hoc” reporting systems allow the users themselves to create specific, customized queries. Typically this would be via a user-friendly GUI-based system without the need for the in-depth knowledge of SQL, or database schema that a programmer would have.

Because such reporting has the potential to severely degrade the performance of a live system, it is usually provided over a data warehouse.

Ad hoc querying/reporting is a business intelligence subtopic, along with OLAP, data warehousing, data mining and other tools.

What is your experience with ad hoc queries? What limitations have you run into in when “asking” questions of the data held in systems that you interact with? What kinds of things do you think systems designers could do to make ad hoc access easier for users?

Week 11 Reading

Week 11 Reading Assignment

Chapters 1, 2, 3, 5, 7 and 8 of The Language of SQL by Larry Rockoff (2011). (That’s six of the first eight chapters of the book… they are short chapters 🙂

Free online access available via Safari books online via Temple Library — on campus or search for Safari at Temple library database finder.

Reading Discussion Question

– Why is SQL so popular?

– In what ways is SQL easy to use? In what ways is it hard to use?