[SOLVED] Bism7202 excel-assignment p0

Assessment Guideline:

Summary

Type: Individual Computer-based Assessment
Learning Objectives Assessed: 3, 4
Deliverable: One electronic file must be submitted via the Blackboard
Assignment Submission Tool consisting of a single Excel file.
Weight: 35%

Task Description
Requirements
The purpose of this assignment is to test the student’s ability to operate, manage, and interpret Add business data in spreadsheets.

The assignment MUST be done individually.

This is a difficult assignment worth 35% of your course grade, and you should start working on the assignment early in the semester.

Guideline
Expectation
/ Microsoft Excel 365 based on the specification provided in the UrbanEats Delivery (UED) Assessment Case Specification. This document is a companion to a template Excel workbook that contains several sheets you are to develop as part of this assessment.
The specification relates to UrbanEats Delivery (UED), which is a franchise business that deliver daily groceries by the box to homes and businesses in nearby suburbs (their ‘franchise area’). The case has four main requirements for you to develop:
• Summarize the data using database functions in a summary table.
ii. Undertake a Solver Analysis on Business Franchise AreasAdd :
• Use Excel’s Solver tool to analyze and reallocate franchise areas to minimize the distance travelled from each store.
iii. Undertake a Scenario Analysis for Saving Monthly/Fortnightly:
• Analyze different scenarios for saving money either monthly or fortnightly to fund the construction of a new store, estimating the required amount in a few years.
iv. Provide Business-Focused Comments:
• Offer insights and recommendations based on the spreadsheet analysis, focusing on the business impact and environmental benefits.
More details on the specific requirements of the case are contained in the Case Specification.
The Excel template of the expected worksheets will be made available on the BISM7202
Implementation Guidance

Please develop your solution based on the provided files. In general, you are not allowed to insert any other columns or tables.

When you develop your solution, you should aim to use the functions and features you were taught in the tutorials as appropriate. However, if you need functions or techniques that are not addressed explicitly in tutorial exercises, you should explore your pre-tutorial reading materials and preparation exercises or refer to the help component of Excel or other online resources.
Aspects of the assignment have purposefully been designed to train and test a student’s selflearning ability with a software application, and thus these have not been included directly in a tutorial exercise.

Formatting and professionalism
UrbanEats Delivery (UED) 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. Add Therefore, you would be well advised to make your work uniqueness quality.
(e.g., freeze panes to long pages, use named ranges where appropriate, use lookup functions instead of nested IFs where appropriate, use hard coding only where appropriate, use appropriate fonts and colors, graph axes and titles, etc.).
You should use meaningful Named Ranges whenever referring to a Cell on a separate worksheet.

Keep in mind, however, that your work will be judged primarily on the quality of your solution rather than upon its appearance.

Submission
Your Excel Workbook file MUST be named in the format of
BISM7202_StudentLastName_StudentID.xlsx.

If your ID is 41724245 and your surname is Smith, the name of your files would be BISM7202_Smith_41724245.xlsx.

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 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.

Add

Administrative Requirements
Consultation Sessions
Questions regarding your assignment can be answered if they are related to the understanding of the concepts and/or techniques of Excel.
will endeavor to respond to all questions within 2 business days.

Submission Datehttps://.com

For each calendar day (i.e., including Saturdays and Sundays) Add assignmentchefor part of after the submission

5.3 of the relevant Electronic Course Profile (ECP).

• Supporting documentation such as a medical certificate, funeral notice etc. must be provided. Scanned or photographed copies should be attached to your email. A request for an extension based on medical grounds can use a statement of circumstances signed by the student as its supporting documentation.
• 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, neighbors and partners or children of colleagues.
• Extension criteria are applied consistently for equity reasons.
• 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.
• If you have a continuing condition, Add assignmentchefyou should contact Student Services to arrange a Student Access Plan (Disability) [SAPD]. You must still submit the application form.

• holiday arrangements (including overseas travel).
• social and leisure events.
• moving house.
• pressure of work/competing deadlines.
• computer issues.

(100) Basic and needs improvement Meets reasonable expectation Outstanding

Formulas & Functions
Assign

men25
t

Pr0 –
2
–
oject
wcod
hat p

Ex12
20

elp20
– 25

PivotTables, Pivot htt
Charts and Charts
ps://

15
po

0 – 7
er.c

7 – 12

12 – 15
Ad
Database and advance functions d

15 WeC

0 – 7 owc

7 – 12

12 – 15

Solver
15
0 – 7
7 – 12
12 – 15

What-If Analysis
15 0 – 7
7 – 12
12 – 15

General

5

0 – 2

2 – 4

4 – 5

Recommendations

10

0 – 5

5 – 8

8 – 10

Add