School of Business
OPIM 3103C: Business Information Systems


HW4 due Sunday (11/15)11pm

LP5 due Sunday (11/8)11pm
LP4 due Sunday (11/1)11pm
LP-exam1 this week
HW3 due Sunday (10/25) 11pm
due Sunday (10/11) 11pm

class video

Check your grade



Wei-Kuang Huang

Waterbury: Rm. 339
Tel: (Office)203-236-9922; (Cell)646-327-2789
Class Web Page
Class Time TU 3:45pm - 6:15pm (Waterbury)
TH 12:35pm-3:05pm (Hartford)
Office Hours TU 3pm-3:45pm (Waterbury) TH 3:05pm-4.05pm(Hartford)
By appointment
  • Fundamentals of Information Systems Concepts, second custom edition for University of Connecticut. ISBN-10: 1269518283 (ISBN-13: 9781269518284)
  • (optional) Office 2013 All-in-One Desk Reference For Dummies
Software We will be using Microsoft Office 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 2013 book
  • Online turorials
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.
  • Email will be the best communication channel between students and the instructor. You are also responsible to check the class web site regularly for the information update. Any change of class schedules, 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  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.
in-class discussions
  • There will be in-class discussions. The questions will be posted prior to the class. Students are encouraged to participate actively in the discussion.
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/receommendation, 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 -- 16% (4% for each homework)
Quizzes -- 14% (7% each quiz)
lab practical homework - 15% (3% for each LP homework)
Lab practical exams -- 25% (15% for Excel, 10% for Access)
Project (rehearsals & presentation) -- 30%

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 Agenda
Assignment Due
Week 1
Course Introduction      
Week 2
Lab practical- Excel 1
Formulas and Functions   LP1 due  loans.xlsx
Lab practical video
Week 3
Chapter 3
Case Topic Discussion

HW1 due Ch3 slides
IT portal  
Week 4
Lab practical -Excel 2
Project discussion
Charts   LP2 due  ex2-chart.xlsx
Lab practical video  
Week 5
Chapter 6
Project Rehearsal(10 slides)
  HW2 due     Ch6 Slides      
Week 6
Lab practical - Excel 3
Research Tips
PivotTables  LP3 due  ex3-pivot.xlsx
Lab practical video  
Week 7
Quiz 1
Chapter 7
Lab Q&A / Project Meeting
  Ch7 slides  
Week 8
Lab Practical Exam 1
Tables & Forms   HW3 due    
Week 9
Lab Practical - Access 1
Project Rehearsal(15 slides)
  LP4 due   Accounts.accdb
Week 10
Lab practical - Access 2  Reports & Queries   LP5 due   Coffee.accdb
Lab practical video  
Week 11
Project Rehearsal(20 slides)
Chapter 5  
  HW4 due   Ch 5 slides  
Week 12
Lab Practical Exam 2 Lab practical Q/A      
Week 13
Thanksgiving Break    
Week 14
Project roll-out rehearsal
Week 15
Case Project Presentation      
Week 16
Final Exam       
* Assignments due on Sunday 11pm of the week for both sections