Bachelor of Business (Hons)

INFORMATION TECHNOLOGY FOR BUSINESS

(ITC101)
JULY 2024 SEMESTER

LAB-BASED ASSESSMENT
ASSESSMENT DETAILS: LAB-BASED ASSESSMENT

Release Date : 12 August 2024

Due Date : 26 August 2024
Value : 25% of total assessment in subject

Task:

This is an individual assignment focusing on database management using Microsoft Access

and data analysis using Microsoft Excel for a hypothetical restaurant or cafe.

Assignment Question:
You are tasked with creating a database system for a fictional restaurant or cafe. The database
should facilitate the management of menu, sales, and customer information.

Instructions for Microsoft Access:

Tables:

Menu: This table stores information about the food and beverage items offered at your
restaurant or cafe. Include the following fields:

 MenuID (AutoNumber): Unique identifier for each menu item.

 ItemName (Text): Name of the menu item.
 Category (Text): Category of the item (e.g., Appetizer, Main Course, Dessert,
Beverage).
 Price (Number): Price of the item.
 Description (Text): Optional description of the item.

Customers: This table stores customer information. Include the following fields:

 CustomerID (AutoNumber): Unique identifier for each customer.

 FirstName (Text): Customer's first name.
 LastName (Text): Customer's last name.
 Email (Text): Customer's email address.
 PhoneNumber (Text): Customer's phone number.

Orders: This table tracks customer orders. Include the following fields:

 OrderID (AutoNumber): Unique identifier for each order.

 CustomerID (Number): Foreign key referencing the Customers table.
 OrderDate (Date): Date the order was placed.
 OrderTime (Time): Time the order was placed.
 MenuID (Number): Foreign key referencing the Menu table (represents the item
ordered).
 Quantity (Number): Quantity of the item ordered.
Populate the Tables:

 Add at least 50 menu items with various categories and prices.

 Create at least 30 customer entries with different names, emails, and phone numbers.
 Simulate order history by entering at least 100 order records with CustomerID,
MenuID, quantity, and order date/time information.

Queries:

1. Popular Dishes: Identify the top 10 most frequently ordered menu items.
2. Customer Order History: List all orders placed by a specific customer. Allow
users to enter a CustomerID to view their order history.
3. Low Stock Alert: Identify menu items with a quantity below 5, indicating the
need for restocking.

Forms:

1. Menu Management Form: Create a user-friendly form to add, edit, and view
menu items. Users should be able to input details like item name, category, price,
and description.
2. Order Entry Form: Design a form for wait staff to easily record customer
orders. The form should allow selecting a customer, menu items with quantities,
and capturing the order date and time.

Reports:

1. Sales Report: Generate a report summarizing sales transactions. Include information

like total sales amount, order details with item names, quantities, and prices, and
order date/time.
2. Customer Listing: Create a report displaying a list of all registered customers with
their contact details.

Part 2: Microsoft Excel Data Analysis

Import Data: Import the "Orders" table from your Access database into an Excel
spreadsheet. All the data, analysis (using formula) and graph must be on the same
worksheet.

Data Analysis:

 Calculate the total revenue generated from all orders.

 Determine the average number of items ordered per transaction.
 Create a formatted table summarizing these calculations.

Sales Visualization: Construct a bar graph that illustrates the sales performance of
the top 10 most popular dishes identified in your Access query.
Submission:

Submit your assignment as a folder containing:

1. The completed Microsoft Access database file (Restaurant or Cafe Name.accdb).

2. The Microsoft Excel spreadsheet with data analysis and visualizations. (Restaurant or
Cafe Name.xlsx).

Assignment Marking Guide

Traits Performance levels

Excellent Good Fair Poor Needs
Improvement
(17-20) (13-16) (9-12) (5-8) (0-4)

Database Design Well-structured Some aspects of

Adequately Significant Database design
and organized the database
1 (Microsoft Access) database with
designed
design need
flaws in the is incomplete or
(20%) database database design non-functional
proper indexing improvement

Query Effectiveness Queries Queries Queries have Queries do not

Queries retrieve
accurately effectively limited retrieve the
2 (Microsoft Access) retrieve retrieve most
some
functionality or required
(20%) information information inaccuracies information
required
information
Form Design Forms are user-
Forms are well- Forms have Forms are Forms are non-
friendly and
3 (Microsoft Access) intuitively
designed and some usability difficult to use functional or
(20%) designed easy to use issues or confusing poorly designed

Reports are
Report Presentation Reports are Reports are
visually Reports have Reports are
well-presented incomplete or
4 (Microsoft Access) appealing and
with clear
some formatting poorly formatted
lack necessary
(20%) effectively or clarity issues or lack clarity
information information
summarized

Data Analysis Calculations

Calculations
Calculations are Calculations are have some Calculations are
Accuracy (Microsoft have significant
5 Excel)
accurate and mostly accurate accuracy or
errors or
incorrect or
well-presented and clear presentation absent
(20%) inconsistencies
issues
ACADEMIC INTEGRITY

Honesty and Responsibility

Academic integrity is an important tenet for HELP University (the “University”). In pursuit
of the highest standards of academic integrity, the University holds its students to the highest
ethical standards defined by the Rules and Regulations section of the Academic Handbook.
All students studying a HELP University programme are subjected to and are bound by the
Student Academic Misconduct Rule to assure academic honesty. Students are required to sign
a pledge on the assignment cover sheet before submitting your assignments.

What is Plagiarism?
Plagiarism is academic dishonesty or academic theft, and it is a serious academic offence.
Plagiarism includes, but is not limited to, the followings:
1. quote, paraphrase or summarise someone else’s ideas, theories or data, in whole or in
part, without appropriate acknowledgement;
2. borrow ideas, opinion or words, in whole or in part, from other sources without
properly crediting the author(s);
3. use any facts, statistics, diagrams or graphs, in whole or in part, without
acknowledging the source clearly;
4. claim or imply original authorship of someone else’s ideas, theories or data, in whole
or in part, as your own;
5. employ or allow someone to help to revise, amend or write your work and pass off as
your own original work;
6. collaborate with or allow other students to copy your work; and
7. draw on sources more than what you have acknowledged by citations.

While a student is not discouraged to discuss an assignment with his/her friends or classmates,
the work he/she submits must be done by the student alone. If a student shares his/her
assignment with other students and they plagiarise it, the student is as guilty as those students
who plagiarised his/her assignment. All parties to plagiarism are considered equally guilty.
Under no circumstances should a student be involved in collusion with other students unless
he/she is permitted to work on an assignment jointly by the lecturer/tutor. If a student is
unsure what constitutes plagiarism, he/she is obliged to consult the lecturer/tutor on the
matter before submission of his/her assignment.

When and How to Reference?

Knowing when and how to cite is a student’s responsibility. If he/she is in doubt or need
more help on this matter, the student may consult the lecturer/tutor. The following list
comprises some of the sources a student will need to reference. The list is by no means
exhaustive, but simply consists of the most common sources used by students to complete
their work.

1. Books
2. Chapters in books
3. Journal articles
 4. Conference papers
5. Newspaper articles
6. Magazines
7. Websites
8. Study guide

Students are advised to cite in the following cases [1]:

1. When he/she quotes two or more words verbatim, or even one word if it is used in a
way that is unique to the source;
2. When he/she introduce facts that he/she have found in a source;
3. When he/she paraphrase or summarise ideas, interpretations, or conclusions that
he/she find in a source;
4. When he/she introduce information that is not common knowledge or that may be
considered common knowledge in your field, but the reader may not know it;
5. When he/she borrow the plan or structure of a larger section of a source’s argument
(for example, using a theory from a source and analysing the same three case studies
that the source uses);
6. When he/she build on another’s method found either in a source or from collaborative
work in a lab;
7. When he/she build on another’s program in writing computer code or on a not-
commonly-known algorithm; and/or
8. When he/she collaborate with others in producing knowledge.

In general, a referencing system requires two parts:

1. In-text citations
This is information about a source within the text of an assignment.
2. List of references
This is a list of all sources a student has used to research his/her assignment. It is
alphabetically arranged by author surname and appears immediately after the last
page of an assignment.

Different faculties or departments may have different requirement on how referencing for an
assignment should be done. The various formats used for in-text citations and list of
references are available in the following websites:
1. Harvard System
(http://www3.imperial.ac.uk/library/subjectsandsupport/referencemanagement/harvar
d))
2. Chicago Style (http://www.chicagomanualofstyle.org/index.html)
3. American Psychological Association or APA Style (http://www.apastyle.org)
4. Modern Language Association of America or MLA Style (http://www.mla.org/style)

Once a student has selected a referencing style for his/her assignment, he/she must follow the
same style consistently throughout the assignment. We strongly suggest that the student
consults the lecturer/tutor about which method to use before submission of his/her assignment.
Penalties for Plagiarism

The Turnitin Similarity Index for all programmes offered should be not more than 15%.

1
http://www.yale.edu/bass/writing/sources/plagiarism/warning.html, accessed May 18, 2008.
Penalties for plagiarism ranges from mark reduction for the assignment to expulsion from the
University. If plagiarism has been found to have occurred, the action(s) taken will be
determined by the forms of plagiarism implicated:

1. Complete plagiarism
Verbatim copying another person’s work without acknowledgement
- To be referred to a panel2 for further investigation. If the student is found to be
guilty, a grade “FL” is to be awarded for the subject.

2. Substantial plagiarism (Turnitin Similarity Index ≥ 30%)

Near-verbatim copying another person’s work by simply altering the order of the
sentences or the format of presentation or by changing a few words or phrases without
acknowledgement.
- Based on a report submitted by the lecturer in charge of the subject, a Zero
mark will be awarded for the said assessment.

3. Minimal plagiarism (Turnitin Similarity Index ≥ 15%)

Paraphrasing by changing and/or eliminating some words without proper
acknowledgement.
- Based on a report submitted by the lecturer in charge, a deduction of up to
50% of marks the student is entitled to receive for the said assessment.

Pleading ignorance or unintentional plagiarism does not constitute valid reasons for
plagiarism and will not avoid the penalties from being imposed. Excuses for acts of
plagiarism such as the following, but not limited to, will not be entertained:
1. I don’t have time to do the assignment
2. I have too many assignments due on the same day
3. I don’t know, I really didn’t do it
4. I am not aware
5. I don’t understand what plagiarism means
6. I have no intention to plagiarize
7. I forgot to cite the reference
8. I forgot to include the bibliography
9. My English is not good
10. My lecturer/tutor did not explain to me
11. In my country, it is alright to copy someone else’s work
12. My friend copied my assignment when I let him/her to look at my assignment
13. My friend copied my assignment when I allow him/her to use my laptop
14. I did my assignment in the computer lab, someone must have copied my work
15. I asked my friend to submit my assignment and he/she copied my work
16. I discussed my assignment with my friends, so our answers are the same/similar
17. Even though I do not have in-text citation but I have bibliography/reference list

Students should be reminded that it is their responsibilities to take due care throughout their
written work to effectively reference or cite when they use others’ ideas from any source.

2
The panel consists of the HoD as the Chair and 2 to 3 senior academic staff.