Jubail University College

Department of Business Administration

Semester 401

Assignment No.: 1 & 2

Section No.:

Course Code: MIS 305

Course Name: Intelligent Support Systems in Business

Student Name

Student ID

1.

2.

3.

4.

5.

Project Based Assignment

The Assignment Objective: This is a project-based assignment divided into two deliverables: theoretical and practical part. Each with 10% of your final grade. It aims to familiarize and expose students to the business intelligence tools and the four phases of the decision making process as well as improving students’ effective communication and team working skills. In addition, it helps expose students to tools and techniques that aid them in practically developing a DSS to solve a problem or take advantage of an opportunity based on the four phases of decision making process.

Topic- A Business Case:

Each group should identify particular opportunity or problem to be solved by any managerial level in Business. You need to follow the 4 phases of decision making process. Use any tool in M.S. Excel to help automate this decision. Your DSS should provide a correct answer to be given to managers or staff. Examples that could help you:

· DSS to help HR answer Employees questions.

· DSS to help Marketing and development department to increase customer satisfaction.

Each group (of 3-4 members) create their own scenarios in relevance to their business case. Note that you need to consider the various users and existing operations as well as any new operations and functions for proper utilization of data and accurate decision making process.

Theoretical Part – Project Proposal (Submission on week 6): (10 %)

1) Deliverables and marks allocation: (100 marks = 10%)

· a Written Report due in Week 6 and should include: ( 100 marks )

a. Profasional Assignment Cover page

b. Tables of content. ( 5 marks )

c. Proposed Project Title

d. Introduction: covering their aim at the end of the assignment ( 5 mark)

e. Report’s body should include the following :

i. A general background for your DSS project

ii. In the Intelligence phase ensure: (20 mark)

· Providing a General description of the decision situation, i.e., what is the decision circumstances in which the decision is made?

· What type of decision and why? Why there is a need for a DSS instead of some other systems?

· Hint : “The final result should properly identified the right factors”

iii. Design phase: ( 15 mark )

· Identify all the possible alternatives which will affect your decision.

iv. Choice phase: ( 15 mark)

· Provide a clear articulation of the business need.The expected benefits and beneficiaries

· The model(s) which will be used along with any functions

· What are the different BI (tools) solutions that could be implemented to solve the problem (opportunity)? Which one will you use? The reasons behind selecting specific BI solution

f. Work breakdown structure(WBS) identifying the tasks that need to be completed to develop the DSS along with the task allocation for each team member along with the project leader. (20 mark)

g. Conclusions.( 5 mark )

h. Write your list of References at least 3 refernces using Harvard style . ( 5 mark)

2) Deadline:

· A soft of the report submitted on week 7 Sunday

1. The softcopy to be submitted via blackboard based on the deadline.

Notes:

1- It is a group assignment, 3-4 students in each group.

2- Ensure originality of the idea and uniqueness.

3- Each student must work to progress both, the team and individual aspects of the assignment tasks.

4- Pay attention to the following format guidelines (10 marks)

a. The report should include 5 to 10 pages (around 2000 -2500 words).

b. Using MSW 12 point Time New Romans font, MSW 14 points for heading.

c. Double spaced Line spacing for each paragraph. Standard format: 1″ each margin

5- Attaching the original copies of references.

6- Submit a softcopy of the report.

7- Ensure originality! Plagiarism is not allowed. Assignment will be rejected for each Plagiarized paragraph.

End of Deliverable 1

Practical Part (Submission on week 13): (10 %)

This part focuses on the implementation phase of your DSS for the problem (opportunity) that you have identified in assignment 1.

DSS Criteria:

· You should use analytical tool and functions.

· The design and format should be attractive yet clear.

· Use visualization to easily analyze the results.

· Develop two dashboards. Please ensure that you adhere to the dashboard design principles and guidelines.

· Keep intended users of your DSS in mind and ensure that you consider all the possible factors.

· Identify the routine business functions and the management activities supported by your DSS.

· Assume the business rules for the DSS users to follow and make sure to incorporate them.

The required materials: (100 marks = 10%)

A) Report contains the following: (60 marks)

1- Documentation:

a. Assignment cover page and Tables of content

b. Introduction: Brief introduction about the decision you will assist in. (2 mark)

c. Content

· This part shoud Breifly and consizly address all the work that you have done and assubsions you followed in preparing your DSS Implementation phase such as:

· How the solution is implemented.(10 mark)

· Explain the tools that you developed (10 mark)

· The functions you used with a brief explanation of it (10 mark)

· The dashboards. (20 mark)

d. Conclusion

· The results and benefits of using the BI system on the problem (opportunity) after the implementation? (2 mark)

· Visualization to analyze the results. ( 3 mark )

· Future recommendation, if applicable.

e. References (3 mark)

2- Appendixes

· All the soft files of the database and BI software.

· The presentation materials.

B) The presentation of actual tool developed, in accord with the documentation.

· This part is to be presented and explained “using examples” to the Instructor by the group members. Ensure that you are presenting a STORY ( 40 marks)

Criteria

Individual

Knowledge

Communication Skills

Peer Evaluation

Total

Maximum Mark

20

10

10

40

C) Following guidelines (10 marks)

Notes

· Besides the presentation, you will be engaged in small group discussion about your assignment and work. Students will reflect on their work and their learning process throughout the project duration, what are the challenges and lesson learned.

· Students who do not follow the dress code will not be allowed to present

· Please note that each requirement carries marks, don’t neglect any point in the assignment.

· Please do not overwrite; a proper concise explanation is enough.

· Pay attention to the following format guidelines:

· The project report (documentation) should address all the requirements concisely.

· Using MSW 12 point Time New Romans font, MSW 14 points for heading.

· Double spaced Line spacing for each paragraph. Standard format: 1″ each margin

End of Deliverable 2

Page 5 of 6