BUSINESS INFORMATON SYSTEMS 1 (ISYS2056): “Flamingo Dance Studio”

BUSINESS INFORMATON SYSTEMS 1 (ISYS2056)
ISYS 2056 Business Report Semester 1, 2019 Page 1
ANALYSING A SPREADSHEET AND PRESENTING A BUSINESS
REPORT

(20% of Final Grade)
Case Study
“Flamingo Dance Studio” is a small dance school located in the southern suburbs of
Melbourne. Jane Flynn is the Owner/Manager and has been running the school for the past
two years. Jane handles bookings, accounts and organises the teaching timetable and roster for
the casual dance instructors she employs. Note that the instructors’ pay rates have been
determined by experience, age and qualifications and so they differ for each instructor. The
dance school offers a range of dance classes for children and a class for adults (referred to as
the “Adult Dance” class). Jane also offers private tuition for students taking a Year 12 Dance
subject. Classes are booked per semester.
Since purchasing the dance school, Jane has been operating essentially the same timetable from
semester 2 2017 through to semester 1 2019 and has continued to employ the same staff. In an
effort to encourage new and current students to take extra classes she introduced a discount
scheme during semester 2 2018 and semester 1 2019 (see the “Multiple class discount” columns
in the spreadsheet). A discount is offered if two or more members of the one family enrol in a
class or if a student enrols in two or more classes.
Jane believes that it is time to review the effectiveness of her dance studio with regard to
profitability. Is the business growing? Are her profits growing? What are the likely future
trends? She wants to revise the timetable and possibly take other steps, to further increase
profits and has asked you to:
• Undertake descriptive analysis of the data she has maintained over the past four
semesters.
• Provide an overview of profitability trends undertaking predictive analysis.
• Discuss the various options regarding possible future changes to the timetable based on
your analysis.
• Discuss at least one business issue you have identified as a result of your data analysis
that you believe may need to be further analysed. E.g. You require further information
from Jane before you can take action. Clearly explain your reasoning.
• Make recommendations with regard to future changes which might assist in further
improving profitability. Briefly justify these recommendations (i.e. prescribe what
should be done and why this would be helpful, drawing on your predictive and
prescriptive analysis).
Jane has set up a spreadsheet. She has asked you to use the data provided in the spreadsheet to
complete relevant calculations and to use Excel ‘tools’ to analyse the data provided. She then
requires you to write a business report which analyses and discusses both profit growth and the
various options available to help increase future profitability.
BUSINESS INFORMATON SYSTEMS 1 (ISYS2056)
ISYS 2056 Business Report Semester 1, 2019 Page 2
A spreadsheet has been provided containing the data for “Flamingo Dance Studio” enrolments
for semesters 2 in 2017, 1 and 2 in 2018 and 1 in 2019, and various related data on costs etc.
PREPARING THE BUSINESS REPORT
Report Content
The analysis, findings and recommendations which you prepare for Jane should be outlined in
a professional business report.
This report should include:
▪ A title page – with a relevant graphic, report title, student name/number, course name
(Business Information Systems), course number (ISYS2056), your workshop time
and your workshop tutors’ names.
▪ A Table of Contents (TOC) automatically generated by Microsoft Word. Default
settings for the table of contents should not be altered.
▪ A brief introduction which outlines clearly the purpose of the report.
▪ The analysis you have undertaken and a discussion regarding the results of this
analysis.
▪ A discussion, based on the results of your analysis that outlines possible options for
increasing future profitability.
▪ Discuss at least one business issue you have identified as a result of your data analysis
that you believe may need to be further analysed. E.g. You require further information
from Jane before you can take action. Clearly explain your reasoning.
▪ A short concluding summary of the major findings of the report.
▪ Clear recommendations that Jane can adopt. These recommendations must be drawn
from the analysis you have carried out and must have been discussed in the body of
your report.
Report Format
The report should be developed using the guidelines covered in the Pearson etext that has been
recommended for Business Information Systems 1 – also see Canvas WLA & CLA On Line
Communications
Specifically you should:
• Ensure your report is concise: 1000 words. This word count includes title page and
TOC. It does not include appendices. (Note: a 10% variance is acceptable – i.e. the
report should be between 900 and 1100 words.)
• Present the report in a professional, business format with no spelling or grammatical
errors.
• Use appropriate headings and subheadings throughout the body of the report.
▪ Use double or 1.5 spacing.
▪ Fully Justify all text in the report.
▪ Include a page header with a suitably formatted title (the header must not appear on the
title page).
▪ Include a page footer with your name, student number and page number (the footer
must not appear on the title page).
BUSINESS INFORMATON SYSTEMS 1 (ISYS2056)
ISYS 2056 Business Report Semester 1, 2019 Page 3
▪ Include relevant charts and tables you have created – either in the body of your report
(appropriately labelled) or as an appendix at the end of the report. The material in the
charts and tables must be discussed as part of the paper.
▪ In an appendix include screen shots of calculations (as discussed below) which you
have used to assist in your analysis. (Note: You do not need to refer to this appendix in
the body of your report.) A guide to inserting screen shots commences on page 4 of this
document.
Report Submission
The Business Report must be submitted, in MS Word format, by Saturday May 4th
, 11:59 pm,
via the link provided in the “Assignments” area on the ISYS2056 Business Information
Systems 1 site on Canvas. A Student Guide to submission (using Turnitin) is available at:
https://www.rmit.edu.au/students/support-and-facilities/it-services-forstudents/canvas/turnitin
BUSINESS INFORMATON SYSTEMS 1 (ISYS2056)
ISYS 2056 Business Report Semester 1, 2019 Page 4
A Guide to inserting a screenshot in ‘Word’
• Open and/or minimise the program/sheet you wish to create the screen shot from (in
this case your Excel document). As your screenshots are designed to show calculations,
you should make sure you have highlighted the relevant cell and the function is clearly
visible in the function dialogue (fx) box.
• Open your ‘Word’ document.
• Select Insert/Screenshot/Screen Clipping.
• Select the sheet you wish to create the screenshot from. The screen should fade and a
+ appear. Use the + as a cropping tool to select the required screenshot. Note: There
is no need to show every cell. (See Figure 1 in which one of the relevant cells is
highlighted (B3) and the function for column B is clearly visible.)
• Label the screenshot appropriately.
Figure 1 – Screen shot of Countif function
If you need to create a screenshot of a column that is not located near the fx box (see
Figure 2) you can:
• Select the relevant cell. Double click on the cell to show the formula.
• Create screen clipping as per the instructions above. Provide an appropriate label.
Figure 2 – Screenshot of Sumif function
To show several formulas in the one screenshot (see Figure 3) you can:
• Select the relevant cells.
• Select Formulas/Formula Auditing/Show formulas.
• Take the screenshot as per the directions above. (NOTE: Text needs to be large
enough to be read clearly.)
BUSINESS INFORMATON SYSTEMS 1 (ISYS2056)
ISYS 2056 Business Report Semester 1, 2019 Page 5
Figure 3 – Screenshot showing functions in several columns

Buy Now

Answer Excerpt

BUSINESS INFORMATON SYSTEMS 1 (ISYS2056) ISYS 2056 Business Report Semester 1, 2019 Page 1 ANALYSING A SPREADSHEET AND PRESENTING A BUSINESS REPORT (20% of Final Grade) Case Study “Flamingo Dance Studio” is a small dance school located in the southern suburbs of Melbourne. Jane Flynn is the Owner/Manager and has been running the school for […]



Buy Now