IT

Pg. 1 Version 1

FACULTY OF BUSINESS AND MANAGEMENT STUDIES

UNDERGRADUATE BUSINESS PROGRAMME

ACADEMIC YEAR 2020-2021, 1st Semester

January - 2021

WRIT 2

Programme Title: BMS, A&F, MM, BE, BIS

Module Title: Information Technology in Business

Module Code: GCO3000

Assessment Method: Scenario based Project

Level: 3 Block: 1

Module Credits: 20 Weighting: 50%

Due Date: 24-Dec-2020, 9:00PM Word Count: 2,000 equivalent

Examiner(s): Mr. Aumir Shabbir & Mr. Jawad Tauheed

Date of Submission: December 24, 2020

Version: 1

Pg. 2 Version 1

Gulf College – Faculty of Business and Management Studies – In academic

Affiliation with CARDIFF SCHOOL OF MANAGEMENT

A. Written work

➢ A signed declaration that the work is your own (apart from otherwise referenced acknowledgements) must be included after the reference page of your assignment

➢ Each page must be numbered. ➢ Where appropriate, a contents page, a list of tables/figures and a list of abbreviations should

precede your work. ➢ All referencing must adhere to School/Institutional requirements. ➢ A word count must be stated at the end of your work. ➢ Appendices should be kept to the minimum and be of direct relevance to the content of your

work. ➢ All tables and figures must be correctly numbered and labelled.

B. Other types of coursework/assignments

➢ Where coursework involves oral presentations, discussions, poster presentations, etc., specific instructions will be provided by your module leader/team.

---------------------------------------------------------------------------------------------------------------------------------------------

Rewrite below part just after the References of your assignment.

WORK DECLARATION

I, [Name of Student], hereby declare that the uploaded Scenario based Project through Turnitin is my

own work. I affirm that this has been researched and completed in accordance with the college rules

and regulations on plagiarism.

I acknowledge the advice given by the module tutors on proper referencing to avoid plagiarism and

the rules on the academic unfair practice.

I acknowledge that I read and understand the plagiarism guide written at the end of this assessment.

Any academic misconduct will be handled according to the rules and regulations of the university.

[Name of Student]

Pg. 3 Version 1

General instructions

Scenario based Project must be submitted online through Turnitin before due date.

The only circumstance in which assignments can be uploaded late via Turnitin is if a Mitigating

Circumstances (MC) form is submitted at the same time. In these circumstances work may be

submitted within five (5) working days. Make sure to secure MC form and submit the same to the

concerned staff.

Write the number of words used, excluding references, at the end of your assignment. Provide the

list of sources you used at the last page of your assignment with proper label ‘References’. You may

include diagrams, figures etc. without word penalty. The number of words will be + or – 10% of the

total words allowed.

A work declaration must be included on the first page of your assignment. This ensures that you

prepare your work in good faith. Any form of collusion and/or academic unfair practice will be dealt

with according to the pertinent rules and regulations of the partner university. Please read carefully

the plagiarism guide.

Assessment Details and Guidelines to Students:

This Scenario based Project comprises 50% of the total assessments’ marks. Make sure you reference

(proper Harvard Referencing should be observed) any sources you have used to complete this

assessment.

Analytical skills. The reflection report enables the students to analyse and evaluate the benefits of

the different activities done in the class. This skill will eventually help them evaluate options

necessary to make decisions in the workplace.

In addition, the assessment will test the following learning outcomes:

Lo2: Develop and apply current application software to support business objectives.

Pg. 4 Version 1

Assessment Task

Task 1 (Microsoft Excel): (80 marks)

City Cinema-Muscat

A well renowned Cinema in Oman named as “City Cinema-Muscat” wants to introduce the

automation process in order to facilitate the customers. The Manager of the Cinema has decided to

assign a task to you as a developer to maintain the billing system for the customers.

In this regard, you are requested by him to prepare and submit a report in Excel worksheet to keep

the complete record of customers along-with the calculation of their bill amount for tickets, snacks,

soft drinks and other facilities (if any) provided by the Cinema management.

The task should contain the following:

Task 1 (a):

Create a COMPLETE worksheet with appropriate labels for this Scenario. The following should be

included in your worksheet:

i. Title of the worksheet:

ii. Name of the file: (Your Name – Student ID)

iii. Complete contents and headings of the table.

iv. Page orientation to Landscape along-with the professional look of document.

v. Use filter by category.

Task 1 (b):

i. Calculate the Total bill of each visitor that includes the real price of ticket(s), snacks, soft drinks,

e.tc. before applying the discount/promotion by using appropriate formula in the respected cells.

ii. Calculate the 10% Discount on Total bill against each visitor by using appropriate formula in the

respected cells.

iii. Calculate the Grand total after subtracting the discount amount (10%) from the total bill against

each visitor by using appropriate formula in the respected cells.

Pg. 5 Version 1

iv. Display the Remarks of each visitor by using IF statement.

Condition for Remarks:

IF, Grand total of each visitor is less than OR equal to 15, remarks would be “Affordable”,

IF, Grand total of each visitor is more than 15, remarks would be “Not affordable”.

v. Count the number of visitors given in the table by using the appropriate formula in the respective

cell.

vi. Calculate the Maximum bill from Grand total column by using the appropriate formula in the

respective cell.

vii. Calculate the Minimum bill from the Grand total column by using the appropriate formula in the

respective cell.

viii. Count the number of remarks “Affordable” from Remarks column by using the appropriate

formula in the respective cell.

ix. Count the number of remarks “Not affordable” from Remarks column by using the appropriate

formula in the respective cell.

Task 1 (c):

i. Create a Column graph (labeled) that will show the Grand total of each visitor.

ii. Create a Pie chart (labeled) that will show the Discount amount of each visitor.

Task 2 (Microsoft Word): (20 marks)

In a separate word file, write the functions that you used in all tasks mentioned in the above activity

(e.g. header, footer, formulae, etc.). Explain the purpose of each function appropriately.

(Word count: 250 words)

Pg. 6 Version 1

Guideline to the Students:

• Check that all the data has been entered accurately

• Use formatting features to make sure the spreadsheet is easy to read and looks professional

• Use correct capitalisation

• Use correct formulas and functions

• Header (write the Student name and Student ID)

• Footer (write the Module name and Module code)

• Font – Calibri, Font Size – 12 (body), font size heading – 14

• Apply background colour in table header and the columns with formulas

• Border line should be strictly observed

Note: Complete your file(s) by keeping in mind that your document(s) should look professional and

submit the original files of each task i.e. (Task 1-Microsoft Excel and Task 2-Microsoft Word) to the

concerned link on Turnitin accordingly.

***END OF ASSIGNMENT TASK***

Pg. 7 Version 1

GCO3000 - Information Technology in Business AY: 2020-2021 / 1st Semester

Marking Scheme

Question

Number Description

Marks

Allocated

Section A

Task 1(a)

(Introduction)

i. Title of the worksheet 2

ii. Name of the file 3

iii. Complete contents and headings of the table 5

iv. Page orientation to Landscape along-with the professional look of

document 2

v. Using Filter by category 3

Task 1(b)

(Knowledge)

i. Calculation of Total bill against each visitor 10

ii. Calculation of 10% Discount against each visitor 5

iii. Calculation of Grand total against each visitor 5

iv. Calculation of Remarks 10

v. Count number of visitors given in the table 5

vi. Calculation of Maximum bill from Grand total column 5

vii. Calculation of Minimum bill from Grand total column 5

viii. Count the number of “Affordable” from Remarks column 5

ix. Count the number of “Not affordable” from Remarks column 5

Task 1(c)

(Analysis)

i. Column graph that will show the Grand total of each visitor 5

ii. Pie chart that will show the Discount amount of each visitor 5

Section B

Task 2

(Conclusion)

Complete report (Word File)

Explaining the purpose of each function (e.g. header, footer, formulae, etc.)

that used in all tasks mentioned in Microsoft Excel activity. 20

TOTAL MARKS 100

Pg. 8 Version 1

Plagiarism

1. Plagiarism, which can be defined as using without acknowledgement another person’s words or ideas and submitting them for assessment as though it were one’s own work, for instance by copying, translating from one language to another or unacknowledged paraphrasing. Further examples of plagiarism are given below:

Use of any quotation(s) from the published or unpublished work of other persons, whether published in textbooks, articles, the Web, or in any other format, which quotations have not been clearly identified as such by being placed in quotation marks and acknowledged.

Use of another person’s words or ideas that have been slightly changed or paraphrased to make it look different from the original.

Summarising another person’s ideas, judgments, diagrams, figures, or computer programmes without reference to that person in the text and the source in a bibliography or reference list.

Use of services of essay banks and/or any other agencies.

Use of unacknowledged material downloaded from the Internet.

Re-use of one’s own material except as authorised by the department.

2. Collusion, which can be defined as when work that has been undertaken by or with others is submitted

and passed off as solely as the work of one person. This also applies where the work of one candidate

is submitted in the name of another. Where this is done with the knowledge of the originator both

parties can be considered to be at fault.

3. Fabrication of data, making false claims to have carried out experiments, observations, interviews or

other forms of data collection and analysis, or acting dishonestly in any other way.

Plagiarism Detection Software (PDS) - Turnitin

As part of its commitment to quality and the maintenance of academic standards, the University reserves the right to use Plagiarism Detection Software (PDS), including Turnitin. Such software makes no judgment as to whether a piece of work has been plagiarised; it simply highlights sections of text that have been found in other sources.

The use of plagiarism detection software fulfills two functions. The first is to enhance student learning (i.e. as a developmental tool); the second is to guard against and identify unfair practice in assessment.

Further information and guidance can be found in the University’s policy on the Use of Plagiarism Detection

Software (Turnitin).