BISM7202 Excel Assignment Specification Semester 1, 2025
Page | 1
BISM7202 Excel Assignment

WEIGHT 45%
DUE DATE 26 May 2025 at 17:00
DELIVERABLES One electronic file must be submitted via the Blackboard
Assignment Submission Tool consisting of a single Excel file.

Overview
This assignment requires you to create a professional business application using Microsoft Excel 365
(Excel 2019 or newer versions). The purpose of this assignment is to test the student’s ability to operate
and manage business data in spreadsheets. The assignment requires no prior technical background.
Moreover, it is designed for business students in general to appreciate basic IS applications. Prior
familiarity with the software tool could be beneficial but will not guarantee a significant advantage or
higher marks. Through tutorials, students are exposed to practical exercises like those in the assignment
and develop the skills to manage business data in Excel to complete this assignment. It is essential that
students carry out the required readings and preparation for each tutorial before attending/attempting
each tutorial and this assignment.

The assignment is worth 45% of your grade in this course. This is an individual assignment – group
work or any collaboration on the assignment is not permitted. This assignment consists of several tasks
to be completed in Excel.

The Excel template of the expected worksheets is available on the BISM7202 Blackboard site. The
Excel template provided must be used as the basis for the assignment. You may change the visual
formatting (colour, fonts, data format presentation, etc) to provide a professional finished product, but
nothing else, e.g. template structure, except when you are asked to do so.

Your Task
This assignment requires you to complete an Excel workbook file using Microsoft Excel 365 (Excel 2019
or newer versions) based on the specifications in this document. The Excel workbook contains several
sheets you should develop.

Background
Yuan Yards Ltd is a real estate agency specialising in property rentals in the western suburbs of Brisbane.
Yuan Yards operates from five different office locations around the western suburbs to provide owners
and tenants with the best possible service. A large number of property owners entrust their properties
to the property managers. Tenants are able to lease properties for a period of 13, 26, or 52 weeks.

Ms Lina Zhang, one of the owners of Yuan Yards, has asked you to improve their information system
for managing their rental properties. She has provided you with a sample of properties the business
managed during the 2024-25 financial year. She would like you to complete the workbook containing
multiple spreadsheets to analyse the business. Also, she asks if you spot anything that might put her in
trouble with the law.

BISM7202 Excel Assignment Specification Semester 1, 2025
Page | 2
Documentation Sheet
First, enter your details: Student name and student number (8 digits without an ‘s’).

In addition, list any assumptions that you have made when you developed your assignment. The
assumptions allow examiners to understand your work in context. If you do not make any assumptions,
please leave the section empty. Assumptions to be considered when marking must be logical.

There is also a separate section for Reflections on Generative AI Use, which will be explained later in
the assignment.

Constant Sheet
This sheet contains all the lookup tables that you will need to use in the assignment. When using
lookup tables in your formulas, please make sure they are accessed using appropriate named ranges.
In fact, appropriate named ranges should be used as much as possible throughout the whole workbook.

Employee Salary Table
Employees are paid at different rates based on their job titles. Each job comes with a different
employer superannuation percentage rate. The details of the different job descriptions are presented
below. You are required to complete the data entry of the table in the workbook.

Table 1: Employee Salary Table for 2024-25
Job Title Annual Salary Employer Super
Accountant $112,504 16.50%
Office Manager $124,096 16.50%
Owner $156,061 22.00%
Property Manager $95,525 11.50%
Receptionist $53,906 11.50%
Sales Officer $100,453 15.00%
Marketing Manager $97,048 11.50%
Senior Property Manager $113,792 16.50%


Annual Tax Table
Income Tax is withheld using the following tax rates for 2024-25. This information has been entered
for you in the Constants Sheet.

Table 2: Australian Taxable Income Table for 2024-25 (available at https://www.ato.gov.au/tax-rates-and-codes/tax-rates-australian-residents)
Taxable Income Tax on this Income
0 – $18,200 Nil
$18,201 – $45,000 16c for each $1 over $18,200
$45,001 – $135,000 $4,288 plus 30c for each $1 over $45,000
$135,001 – $190,000 $31,288 plus 37c for each $1 over $135,000
$190,001 and over $51,638 plus 45c for each $1 over $190,000


Employee Superannuation Table
Employees at Yuan Yards have collectively agreed to contribute a percentage of their post-tax annual
salary to their superannuation fund based on their age at the end of the financial year. You are required
to complete the data entry of the table in the workbook.
o Employees aged under 40 have elected to sacrifice 4.5%.
o Employees aged 40 and over (but younger than 50) have elected to sacrifice 5.5%.
BISM7202 Excel Assignment Specification Semester 1, 2025
Page | 3
o Employees aged 50 and over (but younger than 65) have elected to sacrifice 6%.
o Employees aged 65 and over have elected to sacrifice 6.5%.

Service Bonus Table
Employees at Yuan Yards who have had extended service with the company are paid an annual bonus.
You are required to complete the data entry of the table in the workbook.
o Employees who have been employed for at least 2 years at the beginning of the calendar year
receive a 1.5% bonus on their annual salary.
o Employees who have been employed for at least 5 years at the beginning of the calendar year
receive a 2.5% bonus on their annual salary.
o Employees who have been employed for at least 8 years at the beginning of the calendar year
receive a 3.5% bonus on their annual salary.
o Employees who have been employed for at least 11 years at the beginning of the calendar year
receive a 4.5% bonus on their annual salary.
o Employees who have been employed for at least 14 years at the beginning of the calendar year
receive a 5% bonus on their annual salary.

Beginning of the Financial Year
Please enter the first day of the financial year of 2024-25.

Distance Survey Table
Each office manages different properties in various suburbs. Recently, a survey of distances between
offices and suburbs was completed based on actual travel distance rather than physical distance. This
table shows the distances from the office suburbs to the property suburbs. In each cell, the first suburb
indicates the office location, and the second suburb indicates the suburb where the property is located.
This information has been entered for you.

Employees Sheet
The employee sheet keeps track of the employees currently employed at Yuan Yards. You’re required to
complete this sheet using the information provided.

Your first task is to insert a lookup-based formula to retrieve the annual salary of the employee based
on their jobs. Following this, insert formulas to calculate the employer and employee superannuation
contributions. Please note that employer superannuation is not included in the employee’s annual
salary. Next, insert a lookup-based formula to calculate the commission that a property manager earns
based on the rent paid for the property he manages. The commission rate is 2% as per the Business
Income Sheet. Also, insert a lookup-based formula to determine the service bonus. Then use a
lookup-based formula to calculate the annual income tax based on their taxable income. Finally, insert a
formula to determine the annual take-home balance, for each employee – this is how much is deposited
into their bank accounts during the year.

Business Income Sheet
This sheet lists the property managers of the business. It shows the number of properties that an
employee manages, along with the amount of rent the business received from those properties. From
the rent to be received, the owner receives 90%, the business receives 8%, and the employee receives
2% as a commission. The commission should be calculated in the Employees Sheet.
Office Location Analysis
Using the information on the Employees Sheet and Business Income Sheet, create a new Data
Model and generate a PivotTable, which shows the total annual rent paid to different offices. Make sure
the PivotTable has meaningful label headers.
BISM7202 Excel Assignment Specification Semester 1, 2025
Page | 4
Using the created PivotTable, create a PivotChart and move it to a new sheet with a meaningful sheet
name. Format the chart as a Pie Chart with a meaningful chart title to show each office’s location name,
total annual rent income and its percentage.

Properties Sheet
This sheet contains a basic setup to apply advanced filtering to a database.
You have been provided with a data file consisting of rental property information.

Synthetic Property Data Generation with Generative AI

Task Overview
Synthetic data is widely used in business analytics, machine learning, and software testing to
supplement real-world data, improve model training, and maintain data privacy. To explore the
potential of this method for Yuan Yards Ltd, you will generate a few additional rental property
records and assess its usefulness in expanding datasets.
This task requires you to generate 5 to 10 additional property records and integrate them into
the rental properties data.

Step 1: Generate Synthetic Property Data
Run the following prompt in an LLM of your choice (ChatGPT, Gemini, Llama, or others). You
may refine the prompt if needed, but this is optional.

Prompt:
“Based on the provided data, generate between 5 and 10 synthetic property records with
similar characteristics. Ensure the data remains realistic and consistent with the existing
dataset.
Data:
Office Location ID,Street Address,Suburb,Postcode,Dwelling
Type,WeeklyRent,Bedrooms,Bathroom,Carport
YY-LOC-03,2/68 Carawa St,St Lucia,4067,Flat,434,2,1,0
YY-LOC-03,2/73 Warren St,St Lucia,4067,Other,538,1,2,2
YY-LOC-03,2/89 Hiron St,St Lucia,4067,Student accommodation,554,1,1,2
YY-LOC-03,20 Carmody Rd,St Lucia,4067,House,252,1,3,1
YY-LOC-03,20/18 Ninth Av,St Lucia,4067,Student accommodation,296,0,3,0
YY-LOC-03,20/19 Austral St,St Lucia,4067,Student accommodation,414,0,3,0
YY-LOC-03,20/23 Carawa St,St Lucia,4067,Student accommodation,202,6,1,2
YY-LOC-03,20/46 Dell Rd,St Lucia,4067,Student accommodation,431,2,3,2
YY-LOC-03,20/58 Blair Dr,St Lucia,4067,Student accommodation,238,0,1,0”

Step 2: Integrate the Data
1. Append the generated records to the rental property information.
2. Ensure consistency in formatting and structure.

Step 3: Reflection
In the “Documentation” sheet, there is a section titled “Reflections on Generative AI Use.”
Write 3-5 statements reflecting on this activity, including:
 The name and version of the LLM you used (and any adjustments to the prompt)
 The quality and accuracy of the generated data, such as whether the addresses are valid (you
can still proceed even if they are not).
 Any other refinements made and why

Your final submission must include the newly generated property records and reflections in the
Documentation sheet.
BISM7202 Excel Assignment Specification Semester 1, 2025
Page | 5

Once you have added these 5-10 synthetic new records, you are required to import the details from the
file into this sheet starting from row 12 of the spreadsheet. This will become the database for filtering.
Make sure there are no duplicated headings.

Using two named ranges (Database and Criteria), set up an advanced filter for the criteria entered in
the Criteria range and show all properties in St Lucia. Using the same named ranges, apply database
functions to calculate the total, minimum, average and maximum values for the listed headings. The
formulas should be robust and not display errors. When you submit your assignment, make sure the
advanced filtering with the criteria “St Lucia” is active.

ABS Data - Median Weekly Rent
This sheet includes data from the Australian Bureau of Statistics (ABS) Census data. The sheet shows
median rent by Statistical Area 2 (SA2).
In major urban areas, SA2s often reflect one or more related suburbs. The SA2 is the smallest area for
the release of many ABS statistics.

Suburb to SA2
This sheet includes a mapping of Suburbs (Localities) to Statistical Area 2 (SA2) codes. It also includes
approximate geographical coordinates (longitude and latitude) for each suburb.
Benchmarking
Complete the Benchmarking sheet by including the median weekly rent of properties managed by Yuan
Yards in each suburb vs the median weekly rent of all of the properties in the same SA2 (as reflected in
ABS census data).
Use conditional formatting (red fill colour) to highlight suburbs in which Yuan Yards properties' median
weekly rent is smaller than the suburb's median rent.
Based on this data, create a 3D Map with a Clustered Column Chart that visualises the median weekly
rent of properties managed by Yuan Yards in each suburb vs the median weekly rent of all of the
properties in the same SA2. Include the map in the Excel file. ALSO, add a new worksheet with the
name “Benchmark Map Screenshot” and include a screenshot from your map.
Hint: you need to use the data from Suburb to SA2 Sheet. Note that geographical coordinates
(longitude and latitude) are approximate. Often, different suburbs are given the same longitude and
latitude values. Given the geographical proximity of these suburbs, it is okay to display the merged
values on the same point. However, make sure the median weekly rent values that are visualised on the
map are valid and meaningful (even if they represent merged values from multiple suburbs).
Property Analysis
Using the information on the Properties Sheet, create a PivotTable on a new sheet to analyse the
locations and properties. On the PivotTable, show the label headings as dwelling type, broken down by
the property suburb and grouped by the office where the property is managed. Make sure the table
displays the average weekly rent for the property suburb and dwelling type.

Using the created PivotTable, create a PivotChart and move it to a new sheet with a meaningful sheet
name. Format the chart as a clustered column PivotChart with a meaningful chart title.

Office Redistribution Sheet
This sheet shows the current suburb allocation and number of properties in each suburb. Your task is
to run a Solver to reallocate property suburbs to various offices to ensure the property managers do not
have to travel too far from their offices to the properties. Using a mix of text and lookup formulas,
retrieve the distances from the Distance Survey Table on the Constant Sheet.
BISM7202 Excel Assignment Specification Semester 1, 2025
Page | 6

The redistribution has been discussed previously, and the following requirements have been identified:
o Each suburb should be managed by only one single office.
o Each office should be responsible for a maximum of ten suburbs and a maximum of six
hundred properties.
o Properties should be managed by the closest office, where possible, to ensure the property
managers and tenants do not need to travel too far.
o If a suburb has an office, it must be serviced by that office.

To easily identify the suburbs and offices which require changes, use conditional formatting to
highlight (background) the suburb names in green if they stay the same and yellow if they change.
Where changes exist, highlight (background) the old allocation in red and the new allocation in blue
(both with white text). Save the results of Solver to an answer sheet and restore the original values
before submitting. Make sure you save your work before running Solver. Also, be mindful when
choosing solving method.

Short-Stay Holiday Rentals Sheet
Yuan Yards Pty Ltd has recently expanded into providing short-stay holiday rentals in Brisbane in
addition to long term rentals. You are required to perform a What-If Analysis using a number of
scenarios to see what the possible revenue will be for the venture. You can leave the Midweek
information blank. But, insert proper formulas in the file (if the information is provided later on, the
spreadsheet should still be functional). A basic structure has been provided for you to complete.
Perform a What-If Analysis using the following information:

Current Scenario
Yuan Yards Pty Ltd has 10 properties which are rented out for three-night weekend getaways for $700
each. The properties have each been rented for 40 weekends in the past year. 100 of these bookings
ordered the premium service for an additional $100. A single employee is responsible for managing the
short stay rentals and is paid an annual salary of $95,525. Only 25% of the employee’s work is
attributed to managing the holiday rentals. The business earns 40% of the rent on each property; the
remaining 60% is the owners’ in its entirety. Cleaning costs of $130 need to be paid after each booking
by the business. Sundry expenses of the business for the holiday rentals is a flat $4000 a year. Premium
bookings include a bottle of wine for each night and chocolates on arrival. The wine costs $15.98 and
chocolates cost $8.45.

Calculate the total income, total expenses and total profit values.

Scenarios to Consider (12 scenarios)
Bookings Variations – 4 Input Varieties
o Current bookings – As per current scenario.
o Lower bookings – Bookings decline to only 32 bookings for each property and premium
bookings decline to 80 bookings.
o Higher bookings – Bookings increase to 45 bookings for each property and premium bookings
increase to 150 bookings.
o Maximum bookings – Bookings increase to 52 bookings for each property and premium
bookings to 200 bookings.
Additional Costs – 3 Input Varieties
o No change to employee workload or cleaning costs – As per current scenario.
o Employee workload increase – Employee spends 50% of their time working on the weekend
rentals.
o Cleaning costs increase – Cleaning costs increase to $140.

BISM7202 Excel Assignment Specification Semester 1, 2025
Page | 7
Save the results of the scenarios to a new sheet, which contains meaningful labels for each of the
values.

Market Analysis
Each quarter, the Queensland RTA (Residential Tenancies Authority) analyses new rental bond
lodgements to determine the median weekly rental prices for houses, townhouses and flats/units across
Queensland. Download this data from: https://www.rta.qld.gov.au/forms-resources/median-rents-
quick-finder/median-rents-quarterly-data

The "total bonds lodged with the RTA" represents the number of new rental bonds received by the
RTA. The data is a general indicator of rental activity within the region for a given period.

(a) Use this data to develop a chart that represents two trends from March 2012 to December 2024:
1. The median value of weekly rent paid for new tenancies commencing in each quarter (for all
dwellings)
2. Number of new bonds lodged with the RTA during each quarter (for all dwellings)
(hint: use a “combo” chart that combines two line charts using a secondary axis)

(b) Calculate the AVERAGE value of weekly rent paid for new tenancies commencing in the fourth
quarter of 2024 (Dec 2024) by postcode for all available postcodes (hint: You can use a PivotTable and
copy & paste the results to the template).

(c) Use Excel to develop a map that highlights the MEDIAN value of weekly rent paid for new
tenancies commencing in the fourth quarter of 2024 (Dec 2024) by postcode (hint: use a “region”
visualisation). Include the map in the excel file. ALSO, add a new worksheet with the name “Postcode
Map Screenshot” and include a screenshot from your map. In your “Insights to Lina” specify a few
postcodes outside the Brisbane Metropolitan Area that have high rent prices.

Note: For this section, you can add up to four new worksheets to the assignment template. Add them
at the end of the existing worksheets. Do not copy whole worksheets from the external data - only
include the necessary elements.
Insights to Lina
After completing the Excel workbook, provide insightful discussion in regard to the weaknesses and
the strengths of the business analysis model (i.e., this workbook). Provide suggestions to Lina if there is
room for improvement. The length requirement is a 5 -6 sentence paragraph.

Implementation Guidance, Formatting and Professionalism
You must use Microsoft Excel 365 (Excel 2019 or newer versions) for this assignment. Any of the
previous Microsoft Excel versions (e.g. Microsoft Excel 2007) might cause some unnecessary
problems. It is highly recommended that, prior to assignment submission, you check that your solution
works on the university computers if you have developed it on your own device.

Please develop your solution based on the provided files. In general, you are not allowed to insert any
other columns or tables. If you modify any existing features (except where explicitly instructed),
please specify and explain them in the assumption section on the student details sheet. When you
develop your solution, you should use (but are not limited to) the functions and features you were
taught in the tutorials. If you need functions or techniques that are not addressed explicitly in tutorial
BISM7202 Excel Assignment Specification Semester 1, 2025
Page | 8
exercises, you should explore your pre-tutorial reading materials and preparation exercises or refer to
the help component of Excel. Aspects of the assignment have purposefully been designed to train and
test a student’s self-learning ability with a software application, and thus, has not been included directly
in a tutorial exercise.

Yuan Yards Pty Ltd is operated in a professional manner and it is expected that your Excel workbook
will be used by other staff, and potentially updated in the future by others. Therefore, you would be
well advised to make your work of the highest quality (e.g. apply screen freezing to long pages, use
name references where appropriate, use lookup functions instead of nested If()s where a data table
exists, do not hardcode changeable data, use appropriate fonts and colours, graph axes and titles, etc).
Keep in mind, however, that your work will be judged primarily on the quality of your solution, less on
their appearance.

Plagiarism
It is understandable that students talk with each other regularly, and discuss problems and potential
solutions. However, it is expected that the submitted assignment is a unique document – all parts of the
assignment are to be completed solely by the individual student. The best practice to avoid
misconduct is to not look at another student’s file and not show your solution to another
student. In case where an assignment is perceived to not be a unique work, a loss of marks and other
implications can result. For further information about academic integrity, plagiarism and consequences,
please visit http://ppl.app.uq.edu.au/content/3.60.04-student-integrity-and-misconduct.

Submission
To be done through Blackboard Assignment Submission. Your Excel Workbook file MUST be named
in the format of BISM7202_StudentLastName_StudentID.xlsx. If your ID is 41724943 (8 digits)
and your last name is Smith, the name of your files would be BISM7202_Smith_41724943.xlsx.

Consultation Sessions
To ensure that an equal and sufficient amount of time is allocated for every student who attends
consultation sessions regarding the practical aspects of BISM7202, the average consultation time
(during busy consultation times) will be limited to 5 minutes per student. The main aim of this
restriction during busy periods is to ensure equality to students and minimise waiting time. However, in
circumstances where no other students are waiting, longer consultation times will be provided. Tutors
have advised you of their consultation times during tutorials.
Please note that course staff are not allowed to look at your assignment files to provide feedback or
answer questions. Questions regarding your assignment can be answered if they are related to the
understanding of the concepts and/or techniques of Excel.

For convenience, you may email the tutors with questions. Tutor email address has been advised in
tutorials and is available on the BISM7202 Blackboard site under “Course Staff”. Tutors will endeavour
to respond to all questions within 2 business days.

Late Submissions
Students must fill in an Application for Extension of Assessment Due Date and provide supporting
documentation to the Course Coordinator, Dr Saeed Akhlaghpour, at least 24 hours prior to the
BISM7202 Excel Assignment Specification Semester 1, 2025
Page | 9
submission due date. Applications directly through emails will not be processed. The extension
application instruction can be found on the website https://my.uq.edu.au/information-and-
services/manage-my-program/exams-and-assessment/applying-extension.

o Supporting documentation such as a medical certificate, funeral notice etc. must be provided.
Scanned or photographed copies should be attached to your email.
o For an application on medical grounds, the medical practitioner must not be a near relative or
close associate. Examples of near relatives are partner, child, brother, sister, parent. Examples
of close associates are close friends, neighbours and partners or children of colleagues.
o Extension criteria are applied consistently for equity reasons.
o You may discuss your situation with your course coordinator, but you still need to make a
formal extension request using this form.
o Applications on medical grounds will be approved for the number of calendar days the
medical certificate indicates you were unfit for study. You are expected to act in a timely
manner and must make an appointment as soon as your condition impacts on your ability to
study.
o If you have a continuing condition you should contact Student Services to arrange a Student
Access Plan (Disability) [SAPD]. You must still submit the application form.

Non-permissible circumstances
Extensions will not be granted where the School is not satisfied you took reasonable measures to avoid
the circumstances that contributed to you not submitting by the due date. The following are not
grounds for an extension:
o holiday arrangements (including overseas travel);
o misreading a due date;
o social and leisure events;
o moving house;
o pressure of work/competing deadlines;
o computer issues.

You will incur penalties if your work is submitted late (i.e. after the due date and without an
approved extension).

Assignments (for which no extension has been granted) submitted after the due date and time, incur a
late submission penalty. The penalty is at the rate of 5% of the total available marks for that particular
piece of assessment, for each calendar day or part thereof that the item is overdue. The penalty once
calculated is deducted from the marks awarded for the assessment. Assessment submitted more than
10 days after the due date will receive zero marks.


BISM7202 Excel Assignment Specification Semester 1, 2025
Page | 10
Marking Rubric
The marking rubric below is designed to reflect a marking scheme of 100 marks that are at the end
scaled back to 45 marks. If you received 75 out of 100 marks, your final mark out of 45 is calculated as
follows: 75 / 100 x 45 = 33.75. Therefore, the final mark would be 33.75 out of 45.

Criteria
Marks
(100)
Poor Satisfactory Good
Formulas &
Functions 33 0 – 15
D
em
on
st
ra
te
s a
p
oo
r u
nd
er
st
an
di
ng
o
f f
un
ct
io
na
lit
y
re
lat
in
g
to

cr
ite
ria
in
E
xc
el.
M
an
y
er
ro
rs
e
xi
st
in
so
lu
tio
n.

15 – 26
D
em
on
st
ra
te
s a
sa
tis
fa
ct
or
y
un
de
rs
ta
nd
in
g
of
fu
nc
tio
na
lit
y
re
lat
in
g
to
c
rit
er
ia
in
E
xc
el
in
li
ne
w
ith
tu
to
ria
l k
no
w
led
ge
o
nl
y.
So
m
e
er
ro
rs
e
xi
st
in
so
lu
tio
n.

26 – 33
D
em
on
st
ra
te
s a
g
oo
d
un
de
rs
ta
nd
in
g
of
fu
nc
tio
na
lit
y
re
lat
in
g
to

cr
ite
ria
in
li
ne
w
ith
tu
to
ria
l k
no
w
led
ge
/s
elf
-le
ar
ni
ng
. F
ew
o
r n
o
er
ro
rs
e
xi
st
in
so
lu
tio
n.

PivotTables,
PivotCharts,
Charts, and Maps
12 0 – 6 6 – 9 9 – 12
Database &
Advanced
Filtering
10 0 – 5 5 – 8 8 – 10
What-If Analysis 15 0 – 5 5 – 8 8 – 10
Solver 10 0 – 5 5 – 8 8 – 10
Conditional
Formatting 5 0 – 2 2 – 4 4 – 5
General 10 0 – 5
M
an
y
er
ro
rs
e
xi
st
in
so
lu
tio
n.
F
ol
lo
w
s
un
pr
of
es
sio
na
l p
ro
ce
ss
in
d
ev
elo
pi
ng

so
lu
tio
n.

5 - 8
So
m
e
er
ro
rs
e
xi
st
in
so
lu
tio
n.
F
ol
lo
w
s a

sa
tis
fa
ct
or
y
pr
oc
es
s i
n
de
ve
lo
pi
ng
so
lu
tio
n.

8 – 10
Fe
w
o
r n
o
er
ro
rs
e
xi
st
in
so
lu
tio
n.
F
ol
lo
w
s
an
e
xc
ell
en
t p
ro
ce
ss
in
d
ev
elo
pi
ng
so
lu
tio
n.

BISM7202 Excel Assignment Specification Semester 1, 2025
Page | 11
Criteria
Marks
(100)
Poor Satisfactory Good
Reflections and
recommendations 5 0 – 2
Li
m
ite
d
gu
id
an
ce
to
d
ec
isi
on
m
ak
er
s.
Li
ttl
e
un
de
rs
ta
nd
in
g
of
w
ea
kn
es
se
s o
f d
ev
elo
pe
d
m
od
el
sh
ow
n.
.

2 – 4
So
m
e
us
ef
ul
g
ui
da
nc
e
to
d
ec
isi
on
m
ak
er
s.
So
m
e
un
de
rs
ta
nd
in
g
of
w
ea
kn
es
se
s o
f
de
ve
lo
pe
d
m
od
el
sh
ow
n.

4 – 5
V
er
y
us
ef
ul
g
ui
da
nc
e
to
d
ec
isi
on
m
ak
er
s.
E
xc
ell
en
t u
nd
er
st
an
di
ng
o
f w
ea
kn
es
se
s o
f
de
ve
lo
pe
d
m
od
el
sh
ow
n.



学霸联盟