School of Business
OPIM 3103: Business Information Systems


Hartford section: LP1 due 2/21, HW4 due 2/28
Waterbury Section: LP1 due 2/21, HW4 due 2/28

Check your grade



Wei-Kuang Huang

Waterbury: Rm. 339
Tel: 646-327-2789
Class Web Page
Class Time T 12:30pm - 3pm (Hartford)
W 12:15pm-2:45pm (Waterbury)
Office Hours W 3pm-3:45pm (Waterbury) T 3pm-3:30pm(Hartford)
By appointment
  • Information Technology. University of Connecticut, 1e. ISBN: 1269272675 (ISBN-13: 9781269272674)
  • (optional) Office 2010 All-in-One Desk Reference For Dummies
Software We will be using Microsoft Office 2010/2013 as an integral tool in this course. You are expected to work through the in-class exercises and a self-paced learning experience.
  • MS Office Help
  • Any MS Office 2010/2013 book
  • Online tutorials
Course Objective This is an introductory course in management information systems. The course focuses on both the concepts and hands-on development practice. Upon completion of this course, students should understand the concept, learn to analyze business problems, develop system solutions, and manage business systems in the digital firm. The course will cover the following fundamental concepts and techniques:
  • Understand concepts and components of information technologies infrastructure and how information systems support major business functions.
  • Management and organizational support systems for the digital firms
  • Learn to use information systems to enhance management decision making.
  • Managing information systems in the digital firms
  • Discuss the processes of acquiring and managing the firm's hardware and software assets.
  • Understand how Internet technology has transformed valuation propositions and business models as well as facilitating management and coordination of internal business processes.
  • Be aware of the security and control issues and measures that relate to the reliability, availability, and security of electronic commerce and digital business processes.
  • Hands on MS Office 2013.
  • Check the class web site regularly for the information update. Any change of class schedule, assignment requirement, exam format and date, grade,  and other important announcements will be posted on the class web site as the semester progresses. 
  • There is a home assignment for each chapter. They will be posted at the class web site and   are due on the specified date. Late assignment will be penalized at the rate of 10% per day late.
  • Submit your assignments via online submission
  • Homework should be the result of individual effort. You can treat homework as a preparation for the quizzes. Be sure to allocate sufficient time to complete and test your work.
Lab practicals
  • The lab practicals are mandatory to attend. The lab practical exam will test mainly on the proficiency of using MS office 2013 .
  • There are three written quizzes and one lab exam. The quizzes will be focusing on the comprehension of the concepts in the textbook and hands-on design questions (for lab practical exam). No make-up exam can be scheduled without prior arrangement.
Academic Integrity For all assignments, you must properly cite sources of information as well as the ideas and words of others. Misrepresenting someone else's work as one's own is a serious offense in any academic setting and it will not be condoned. Cheating of any sort will not be tolerated and will result in a failure of the exam or assignment, deduction in the class participation grading component, and potential failure of the course.

A student who knowingly assists another student in committing an act of academic misconduct shall be equally accountable for the violation, and shall be subject to the sanctions and other remedies described in The Student Code. For details refer to, appendix A.

Student expectation during exams/quizzes and class Assignments

  • Only resources approved by the faculty may be used
  • No communication with others
  • keep your eyes on your own work
  • All materials not approved for the exam (i.e., books papers and other materials) must be removed from the table/desk and chairs and placed on the floor
  • No caps/hats
  • No earphones
  • All cell phones must be turned off and put away unless expressly permitted by the instructor
  • No electronic devices unless explicitly allowed by the instructor
  • let your professor know if you witnesses someone cheating  

Students are required to be available for their exams. Students must inform the instructor in advance if they cannot make their exams.

Please note: vacations, previously purchased tickets or reservations, weddings (unless part of the wedding party), and other large or small scale social events, are not viable excuses for missing an exam. Please contact the Dean of Students office with any questions. Thank you in advance for your cooperation.

Project There is a group project consist of no more than 3 students in each group. The project provides an opportunity for students to conduct a case study on a topic of emerging information technologies. The case study requires students to analyze real world business problems, perform online researches and provide a technology solution/recommendation, its business value and applications. Support your reserch with factual data. The deliverables include a 20 minute presentation to the class and 10 minutes Q/A from field experts.
Project case
Case Presentation Sample 1
Case Presentation Sample 2
Grading  Assignments -- 27%
quizzes (6% each) -- 18%
Project (preparation, presentation, Q&A) -- 27%
lab practical exercises - 10%
Lab practical exam -- 18%

Students are responsible for checking their grade through the online grade reporter regularly. Any missing or incomplete grade should be reported to the instructor.

Tentative Schedule (subject to change)
Class Topics
Lab Topics
Assignment Due
Week 1
Class introduction
Chapter 1
Week 2
MS lab practical
Chapter 2
MS Excel   HW1 due(ch1)  chapter2.pptx
Excel working file  
Week 3
MS lab practical
Case topic presentation
(5-7 slides)
MS Excel

HW2 due(ch2)  
Week 4
Chapter 3
Project meeting
MS Excel   HW3 due(ch3)  chapter3.pptx  
Week 5
Quiz 1(ch. 1, 2, 3)
Case proposal presentation
(10 slides)
LP1 due   IT portal site      
Week 6
Chapter 4
MS lab practical
MS Access  HW4 due(ch4)  Chapter4.pptx
Access working file  
Week 7
MS lab practical
Chapter 5
MS Access HW5 due(ch5)    
Week 8
Chapter 6
Project meeting
  HW6 due(ch6)    
Week 9
Spring Break    
Week 10
Quiz 2 (ch.4, 5, 6)
Case progress report (15-20 slides)
  LP2 due    
Week 11
Chapter 7
lab practical review 
Week 12
Lab Practical Exam   HW7 due   
Week 13
Chapter 8
project meeting  
  HW8 due    
Week 14
Case roll-out presentation
Chapter 9
  HW9 due    
Week 15
Case Presentation      
Week 16
Final Exam(ch.7,8, 9)       
* Assignments due on Saturday 11pm of the week for both sections