Introduction to Computer Skills and Business Productivity Report

This report provides an introduction to computer skills, focusing on their application in a business context. It demonstrates how to store, analyze, retrieve, and present data using Microsoft Office applications. The report analyzes financial data from X-Fit gyms, highlighting revenue from peak and off-peak members, and discusses the benefits of Microsoft Word, Excel, and PowerPoint for business productivity. It also explores technological advancements like Perfect Gym, QuickBooks, and laser printers. The report concludes by emphasizing the role of Microsoft Office in increasing efficiency and productivity, and provides a financial overview of the X-Fit chain of gyms, including profit and loss data for different clubs, and includes references from various sources.

Running head: INTRODUCTION TO COMPUTER SKILLS
Introduction to computer skills
Name of the student
Name of the university
Student ID
Author note

1INTRODUCTION TO COMPUTER SKILLS
Table of Contents
Task 1.........................................................................................................................................2
Spreadsheet – Data view............................................................................................................2
Spreadsheet – Formula view......................................................................................................3
Bar graph....................................................................................................................................4
Task 2.........................................................................................................................................5
1.0 Introduction..........................................................................................................................5
2.0 Presentation and explanation of the business data...............................................................5
3.0 Benefits of Microsoft Office towards business productivity...............................................7
3.1 Microsoft Word................................................................................................................8
3.2 Microsoft Excel................................................................................................................8
3.3 Microsoft Power Point.....................................................................................................8
4.0 Technological advancement for business.............................................................................9
4.1 Technology advancement 1..............................................................................................9
4.2 Technology advancement 2..............................................................................................9
4.3 Technology advancement 3............................................................................................10
5.0 Conclusion..........................................................................................................................10
6.0 Reference List....................................................................................................................12

2INTRODUCTION TO COMPUTER SKILLS
Task 1
Spreadsheet – Data view
(Figure 1: Membership Numbers and Fees January 2018 – Data view)

3INTRODUCTION TO COMPUTER SKILLS
Spreadsheet – Formula view
(Figure 2: Membership Numbers and Fees January 2018 – Formula view)

4INTRODUCTION TO COMPUTER SKILLS
Bar graph
Enfield
Shoreditch
Deptford
Wembley
Peckam
£-
£50,000.00
£100,000.00
£150,000.00
£200,000.00
£250,000.00
£300,000.00
Total paid fees peak members
Total paid fees peak members
(Figure 3: Total paid fees peak members)
Enfield
Shoreditch
Deptford
Wembley
Peckam
£-
£20,000.00
£40,000.00
£60,000.00
£80,000.00
£100,000.00
Total paid fees off peak members
Total paid fees off peak
members
(Figure 3: Total paid fees off – peak members)

5INTRODUCTION TO COMPUTER SKILLS
Task 2
1.0 Introduction
The main objective of the report is to demonstrate the essentials for operating the
computer with regard to store, analyse, retrieve and present the data. The report will outline
the findings from monthly sales of X-Fit chain of gyms to state the revenue earned from peak
members as well as off peak members. There are numerous benefits that can be extracted by
the business through usage of Microsoft Office in their business activities. The report will
also explicate how Microsoft Office like MS – Word, MS – Excel and MS – Power point can
be used for increasing the productivity of the business (Norquest.ca 2017). It will also
describe various technological advancements that the business shall be aware off for ensuring
that they are updated with the technological advancements. Finally, the report will point out
some some key points on the basis of the discussion and findings and will suggest the
necessary recommendation (Bott and Siechert 2013).
2.0 Presentation and explanation of the business data
Financial position – Data view

6INTRODUCTION TO COMPUTER SKILLS
(Figure 5: Membership Numbers and Fees January 2018 – Data view)
Financial position – Formula view

7INTRODUCTION TO COMPUTER SKILLS
(Figure 6: Membership Numbers and Fees January 2018 – formula view)
It can be recognized from the above figures that the total number of members during
peak season is 17,680 whereas the number of members during off-peak season is 10,457.
Further, the fees charged from members during peak season are £ 58 and during off-peak
season is £ 36. Total fees received from both the season is £ 14,01892, out of which the
maximum part that is £ 10,25,440 is received from peak members and the rest part that is £
376,452 is received from off-peak members (Gprc.ab.ca 2017). The highest fees received by
X – Fit chain of gyms are from club located in Shoreditch and the fees received amounted to
£ 376,114. On the contrary the lowest fees received by X – Fit chain of gyms are from the
club located in Peckam and the fees received amounted to £ 240,610. Further, out of total 5
clubs, 3 clubs are earning profit and 2 clubs are in loss.
3.0 Benefits of Microsoft Office towards business productivity
Every company prefers to make the jobs easier for their employees to increase their
productivity. This will enable them to get higher productivity without investing large amount
on new business applications or technologies. Just the company has to invest the amount for
training the employees on new technology (Bu.edu 2017). With Microsoft office the
company can remove the burden of the employees with regard to storing the data, managing
the data and making various adjustments in the data. However, Microsoft itself does not
increase the productivity but it assists the employees to communicate in easy way, gain
knowledge from the business data and share crucial information among themselves.
Moreover, it makes the decision making procedure easy as the data are readily available to
compare, analyse and apply (Wilson 2014).

8INTRODUCTION TO COMPUTER SKILLS
3.1 Microsoft Word
Microsoft Word is the graphical program for word processing that are used to type
with. The purpose of MS Word is to enable the users in typing and saving the documents. It is
similar to the word processors and is helpful in preparing the document. Most obvious
advantage of MS Word is its availability. Further, it can be used to save the documents that
can be used conveniently and can be taken anywhere with the user. Another important
advantage of MS Word is that it enables the users to make various formats as per the
importance and need of the user. Apart from that it allows the users to prepare simple
documents for the business correspondence and greatly helps to design and create the
brochures, business cards, new letters and various other items as per the required shapes,
fonts, smart art, clip art and charts.
3.2 Microsoft Excel
MS Excel is the integral part of most of the businesses. It is used by the business
establishments for different purposes. It comes with million rows and columns of data and
automates the number crunching (Anderson, Sweeney and Williams 2014). It is further used
for raking sales trends, generating the memos and maintaining the business data. Te grid
interface of MS Excel enables the users to define the information structure that are required
to be managed in easy and simple way. Generally it is used for financial related tasks. Users
can use custom formula to calculate the quarterly, half-early and yearly results. Moreover, it
is used for presenting the data with graphs and statistical data (GCFLearnFree.org 2017).
3.3 Microsoft Power Point
Various businesses use the MS Power point for simplifying their creation efforts
associated with presentation. The main objective for which MS Power point is used by the
businesses is to relieve the employees from the burden of generating the business forms like
invoices, fliers and labels through tapping into the template collection of Power point (Larson

9INTRODUCTION TO COMPUTER SKILLS
and Gray 2013). Through power point interface the user can use bullet points for details and
in addition various formatting options are available to customize the data. Tasks like adding
the logo in the corner of a slide, reformatting of the fonts to match it with the logo or altering
the colours of template just takes single or couple of the clicks (Schoeneborn 2013).
4.0 Technological advancement for business
4.1 Technology advancement 1
Perfect Gym – it is the system for the club management and can be used by all kinds of sports
facilities, gyms and fitness clubs. It helps to tackle all the requirements associated with
facility management associated with membership management, tools for sales, booking,
reporting, marketing and billing. It offers various features for management of membership
that enables the users to manage the preference and profiles of the members, track purchases
and visits, manage discounts, view reports, measure KPIs and view the activity logs. Further,
the built in CRM allows the managers and owners to store the contact data, interact with the
sales representatives for assigning tasks and launch marketing initiatives and campaigns.
Moreover, the real-time analysis reveals the success and progress of the sales activities at the
glance (Leśniewska 2014).
4.2 Technology advancement 2
QuickBooks – it is leading software for accounting of the small business organizations and is
manufactured by Intuit. It manages all the finances with the online version or the licensed
version. It helps in instant access to the vendor, employee and customer information. Various
accounting features those are supported by QuickBooks are accounts receivable, accounts
payable, collections, cash management, fixed asset management and billing and invoice. The
condense data utility feature under QuickBooks streamlines the data file of the company
through removing the unused list of elements and condensing the closed transactions into the

10INTRODUCTION TO COMPUTER SKILLS
summary of journal entries. While conducting the business the professionals generally rank
up various expenses that are used for customer billing purposes. These include small
purchases like meals and mileage or the large expenses like international business visits.
Irrespective of type or size of the expenses, the QuickBooks software maintains the feature
that enables the users to record each data (Schiff and Szendi 2014).
4.3 Technology advancement 3
Laser-jet-printer – the business owners requires printing out various documents and business
materials on daily basis for the normal business activities. Therefore, he is required to invest
for high quality, energy saving laser jet printer for quick printing. As all individual business
has individual needs and preference the company shall contact a specialist for suggestions
before purchasing and implementations of the printer. Some printers are able to do multi-
tasking like scanning, photocopying and faxing. Purchasing the right kind of printer will
enable the company to stay organized and minimize the costs associated with completion of
task and enhancing the productivity. Moreover, the management shall spend some times for
analysing the specific requirements and selecting the most appropriate one. This will help in
minimizing the replacement cost and maintenance cost (Koch et al. 2013).
5.0 Conclusion
From the above discussion, it is concluded that Microsoft Office plays an important
role in daily business activities. The accountants can save large amount of times as well as
can minimize the manual errors through usage of MS Office which in turn assists in
increasing the efficiency and productivity of the business. Various MS Office components
that are used by the businesses are the Microsoft Office, Microsoft Excel and Microsoft
Power Point. Looking into the financial data of X-Fit chain of gyms it is identified that the
highest fees received by the company are from club located in Shoreditch and the fees

11INTRODUCTION TO COMPUTER SKILLS
received amounted to £ 376,114. On the contrary the lowest fees received by X – Fit chain of
gyms are from the club located in Peckam and the fees received amounted to £ 240,610.
Further, out of total 5 clubs, 3 clubs are earning profit and 2 clubs are in loss.

12INTRODUCTION TO COMPUTER SKILLS
6.0 Reference List
Anderson, D., Sweeney, D. and Williams, T., 2014. Modern business statistics with Microsoft
Excel. Nelson Education.
'BA 1150 - Introduction To Computers In Business | Grande Prairie Regional College
(GPRC)' (Gprc.ab.ca, 2017) <https://www.gprc.ab.ca/programs/courses/?c_code=BA1150>
accessed 16 March 2018
Bott, E. and Siechert, C., 2013. Microsoft Office inside out. Pearson Education.
'Free Microsoft Office Tutorials At Gcflearnfree' (GCFLearnFree.org, 2017)
<https://www.gcflearnfree.org/subjects/office/> accessed 16 March 2018
'Introduction To Computers In Business | 2017-2018 | Norquest College - Edmonton, Alberta'
(Norquest.ca, 2017) <https://www.norquest.ca/cal/current/course/busd1150-introduction-to-
computers-in-business.aspx> accessed 16 March 2018
Koch, L., Gruene, M., Unger, C. and Chichkov, B., 2013. Laser assisted cell
printing. Current pharmaceutical biotechnology, 14(1), pp.91-97.
Larson, E.W. and Gray, C., 2013. Project management: The managerial process with MS
project. McGraw-Hill.
Leśniewska, A., 2014. Customer relationship management in a fitness club–case study of it
solutions applied in a selected organization. Informatyka Ekonomiczna, (4 (34)), pp.66-76.
'Microsoft Office For Students Distribution : Techweb : Boston University' (Bu.edu, 2017)
<http://www.bu.edu/tech/services/cccs/desktop/distribution/microsoft/studentoffice/>
accessed 16 March 2018

13INTRODUCTION TO COMPUTER SKILLS
Schiff, A. and Szendi, J., 2014. Helping small business entrepreneurs avoid critical mistakes
in QuickBooks accounting software. The Entrepreneurial Executive, 19, p.169
Schoeneborn, D., 2013. The pervasive power of PowerPoint: How a genre of professional
communication permeates organizational communication. Organization Studies, 34(12),
pp.1777-1801.
Wilson, K., 2014. Microsoft Office 2013. In Using Microsoft Office 2013 (pp. 1-5). Apress,
Berkeley, CA.

14INTRODUCTION TO COMPUTER SKILLS