Computer Skills Format for Project

Only available on StudyMode
  • Download(s) : 19
  • Published : December 3, 2012
Open Document
Text Preview
BBT1001 C omputer Systems & A pplications
MS‐Excel Project ‐ Individual
AY2012/13 Apr Semester
PROJECT SPECIFICATIONS
1

OBJECTIVES
1.1 To c r e a t e s p r e a d s h e e t s using basic
f e a t u r e s o f M S E x c e l 2 0 1 0 software.

and

advanced

1.2 To gain a deeper understanding of the selected scenario and its associated functions.
1.3 To explore functions that are not taught in class
and incorporate
MS Excel 2010 features that will make
the project interesting, convincing and useful.
2

SYNOPSIS
2.1 This is an

INDIVIDUAL project.

2.2 Choose 1 of the following 5 business scenarios and prepare relevant spreadsheets using MS Excel 2010.
Scenario 1 – Retail Industry
For your internship, you are attached to the head office of a retail chain that operates locally and overseas.
With the
increasing number of tourists coming to Singapore, the company would like to expand further by opening new r etail outlets in Singapore and the region.
You have been tasked to create
spreadsheets to review company performance and present the
necessary data to your manager.
Scenario 2 – Hotel Industry
For your internship, y ou are attached t o the head office of a regional hotel
chain.
The tourism industry has been
flourishing in recent years and Singapore has experienced
tremendous growth in terms of tourist arrivals and hotel room occupancy. The hotel management
would
like
to
remain
competitive
and
open
more
hotels
in
the
region
to
attract more business and leisure travellers. You have been
tasked to create spreadsheets to review company performance and present the necessary data to your manager.

Page 1

BBT1001 C omputer Systems & A pplications
MS‐Excel Project ‐ Individual
AY2012/13 Apr Semester
Scenario 3 – Logistics Industry
For your internship, y ou are attached to the head office of big local l o g i s t i c company. A s i t i n t e n d s to expand, the company would like to assess the feasibility of opening new
o perating offices outside of Singapore. You have been tasked to create spreadsheets to review company performance and
operations and present the necessary data to your manager.
Scenario 4 – Banking Industry
For your internship, you are attached to the head office of a big local bank. The bank is looking into setting up new banks in Europe. Its Chief Financial Officer has asked you to
prepare spreadsheets to review the feasibility of its expansion plan. The spreadsheet may also include analysis of individual branch operational costs and revenue.
Scenario 5 – Travel Industry
For your internship, you are attached to the head office of
one of the big travel agencies. The management of the agency would like to assess the feasibility of offering new services to t h e i r e x i s t i n g a n d n e w c u s t o m e r s i n S i n g a p o r e . You h a v e b e e n t a s k e d t o c r e a t e spreadsheets to review the various products and services (tour packages, hotel packages, air tickets, other transportations, tour guide services etc) and present the necessary data to your manager.

Page 2

BBT1001 C omputer Systems & A pplications
MS‐Excel Project ‐ Individual
AY2012/13 Apr Semester
3

GUIDELINES
3.1 Based
on
the
chosen
business
scenario,
you
are
required
to
collect
data
and information related to
the scenario and create an Excel workbook containing
several worksheets. Examples are as follow:








Sales Reports (from different office branches or
sales regions)
Inventory
management
reports
(for
many
products/services)
Employee records
Payroll/Overtime reports
Training records
Profit & Loss (Consolidated from other worksheets)
Any other relevant worksheets.

3.2 Based
on
the
assessment
criteria,
you
need
to
apply
both
basic
and
advanced Microsoft
Excel
2010
features
(e.g.
Formulas a nd functions, t ables , charts,
e tc. ) As listed under Section 5 (Part B , C, D, E, F, G and H) of...
tracking img