University Report: Introduction to Computer Skills and Excel Analysis

This report, prepared for a university assignment, delves into the practical application of computer skills, specifically focusing on Excel calculations and their role in business management. The report begins with an introduction to the use of Excel spreadsheets for time schedule management and productivity enhancement, including the creation of graphs and the tracking of daily activities. It then details the benefits of Microsoft Office applications, such as MS Word, Excel, and PowerPoint, highlighting their features and functionalities in academic and professional contexts. The report also identifies and discusses two key technological advancements—IP Telephony and Firewalls—along with their impact on business productivity and their respective limitations. The findings from Excel calculations, including the use of formulas and graph generation, are explained, providing insights into how these tools can automate and visualize data. The conclusion summarizes the importance of Microsoft Office packages in improving student and business productivity, emphasizing the need to identify and manage technologies for effective business communication and framework development. The bibliography includes various academic sources supporting the research and analysis presented in the report.

Running head: INTRODUCTION TO COMPUTER SKILLS
Introduction to Computer Skills
Name of the Student
Name of the University
Author’s Note

1
INTRODUCTION TO COMPUTER SKILLS
Table of Contents
Task 1 – Excel Calculations.......................................................................................................2
Task 2 –......................................................................................................................................3
Introduction............................................................................................................................3
Explanation of findings from task 1.......................................................................................3
Benefits of using Microsoft office.........................................................................................5
Identification of two technological advancement..................................................................7
Enhancement of productivity.............................................................................................7
Explanation of its limitations.............................................................................................8
Conclusion..............................................................................................................................8
Bibliography.............................................................................................................................10

2
INTRODUCTION TO COMPUTER SKILLS
Task 1 – Excel Calculations

3
INTRODUCTION TO COMPUTER SKILLS
Task 2 –
Introduction
The report is prepared for the development of the excel spreadsheet that helps in
management of the time schedule for enhance the business management process for the
increase in the productivity. The report is created for the demonstration of the use of excel for
the management of the basic activity easily and it can be used for tracking the daily activity
and generate graphs for the management of the schedules. The benefits of the other Microsoft
Office applications are also described in the report. The technological advancement that the
has been implemented in the different business fields has been identified and described with
their limitations for helping in improvement of the business process management.
Explanation of findings from task 1
For the automation of the calculation of the sum of independent study hours the Sum
formula is used and it helps in calculating the total hours of independent study for the
modules for a period of 10 weeks.

4
INTRODUCTION TO COMPUTER SKILLS
For the calculation of the average hours the average formula is used and the rows for
which the average is needed to be calculated is selected for getting the result.

5
INTRODUCTION TO COMPUTER SKILLS
For generating the graph the of the average time spent on independent study the
columns are selected and the line graph is generated that would help to visualize statistically
the increase or decrease in the average study time for each of the modules.
Benefits of using Microsoft office
The Microsoft office can be used by students and tutors for the for teaching complex
fundamentals using simple methodology for accelerating the information exchange between
teacher and student. It also helps in improvement of the practical education practice for the
colleges and schools. If a wrong spelling is typed in Microsoft word it is automatically
highlighted in red lines and it can be corrected with right clicking and the students can
observe the mistake in real time.
A self-learning practice can be created for improvement of the brain power and the
pattern of thinking and correct the mistakes at a real time. The teachers can insert diagrams,
charts and tables for teaching and defining complex lessons and have a good understanding
on the topic. Microsoft office comes as a bundle of MS Word, MS Excel, MS and
PowerPoint and each of them has different functionality and features can be used for the
improvement of the academic work and are given below:

6
INTRODUCTION TO COMPUTER SKILLS
MS Word –
The main features of Microsoft word are listed below:
The word can be used for creation a new blank document, blogs and new or
existing templates - The documents are used for text files which have the support for
complex formatting and defining the page size and layout. The blogs are used by the bloggers
that can record the account details of the bloggers and used for uploading the posts
seamlessly. The Microsoft word templates can be used for saving time with using the word
with predefines formatting.
Use of tabbed ribbon – it contains a sequence of screens used for capturing the
capability Microsoft word and it contains tabs, commands, command groups. The tab
contains the home, file. The command is used for doing something in the word document and
if a text is typed simply in the document the commands helps in empowering
format/insert/handle the text in a multiple way.
MS Excel
The following features of Microsoft excel:
Pivot tables – It can be used for summing the large data formatted with rows
containing heading and category or values. A flexible methodology is followed for
summarising the data.
Conditional formatting – It is used for changing the format of the cell and depending
on the contents and it helps to quickly focus on the important points of the spreadsheet and
highlighting the errors.
MS PowerPoint
The main features of PowerPoint are given below:

7
INTRODUCTION TO COMPUTER SKILLS
Addition of smart art – It can be used for creating professional diagrams with the
combination of pictures and texts. It can help in creation of organization chart for creating
variety of slides using bullet points in the text.
Insertion of images – It has a screenshot option for allowing the user to capture a
window and including it in the slide. An image can be directly inserted by copying and
pasting it in the slide.
Identification of two technological advancement
The two technological advancement for the business that can be used for the
improvement of the productivity are categorized as software and hardware advancement and
given below:
Hardware – IP Telephony and Firewall
Software – Email and office applications and Mobile applications.
Enhancement of productivity
IP telephony – Moving the business from traditional landline to the VOIP technology
can help in improvement of the communication and provide better service to the organization.
The difference between the technology should be identified and it can help in reducing the
communication cost by using the same internet connection for connecting with the other
people. The IP telephony system are easier to install and configure and it is scalable for
adding more connection for the organization with the simply plugging the phones with the
existing network of the organisation (Orfanou, Tselios and Katsanos 2015). The
implementation of the VOIP can reduce the waiting time for connecting with the user and
helps in enhancing the productivity of the organisation.

8
INTRODUCTION TO COMPUTER SKILLS
Firewall – The deployment of the firewall in the business organization can help in
securing the organizational network by restricting the outbound traffic to reach the internal
resources of the organization. The firewall is needed to be configured with access control list
such that the unknown data packets cannot reach the company’s internal network.
Email and office applications – The need of internal email server and desktop client
has been reduced with the increase in use of spreadsheet, presentation application and
documents with sharing option. The office suite can help in improvement of the productivity
of the employees by sharing the work content with the employees and involve in team
development.
Mobile applications – The introduction of the mobile application can help in active
involvement of the employees for updating documents, make or receive phone calls and
participate in the web conference for increasing the productivity of the business.
Explanation of its limitations
The VoIP technology is dependent on the internet connection and if the internet
connection is down the whole communication process can collapse. The firewall also have
some limitation that is it cannot protect the network from the attacker using dial up
connection to reach the organization’s internal network (Laudon and Laudon 2016). The use
of the email and office application for sharing the information can also become a threat for
the organization because the id used by the user can be accessed by the attacker to get all the
information and use it for illegal activity.
Conclusion
From the above report it can be concluded that the implementation of the Microsoft
office package helps in the improvement of the productivity of the student and the different
business organization. A research is done on the different technology that can be used for

9
INTRODUCTION TO COMPUTER SKILLS
increasing the productivity of the selected business organization. The different hardware and
the software that can be used for the development of the application should be identified for
the management of the business framework and increase the productivity of the organization.
The limitations of the technology is also identified for taking precaution for arise in fault and
implementation of a strategy for the elimination of the error and provide various functionality
for creating effective business communication.

10
INTRODUCTION TO COMPUTER SKILLS
Bibliography
Bozarth, C.C. and Handfield, R.B., 2019. OPERATIONS AND SUPPLY CHAIN
MANAGEMENT.
Coronel, C. and Morris, S., 2016. Database systems: design, implementation, & management.
Cengage Learning.
El Tantawi, M.M., Abdelsalam, M.M., Mourady, A.M. and Elrifae, I.M., 2015. e-Assessment
in a limited-resources dental school using an open-source learning management
system. Journal of dental education, 79(5), pp.571-583.
Gonçalves, M.J.A., Rocha, Á. and Cota, M.P., 2016. Information management model for
competencies and learning outcomes in an educational context. Information Systems
Frontiers, 18(6), pp.1051-1061.
Lau, A.K., 2015. Teaching supply chain management using a modified beer game: an action
learning approach. International Journal of Logistics Research and Applications, 18(1),
pp.62-81.
Laudon, K.C. and Laudon, J.P., 2016. Management information system. Pearson Education
India.
Merchant, R.K., Inamdar, R. and Quade, R.C., 2016. Effectiveness of population health
management using the propeller health asthma platform: a randomized clinical trial. The
Journal of Allergy and Clinical Immunology: In Practice, 4(3), pp.455-463.
Orfanou, K., Tselios, N. and Katsanos, C., 2015. Perceived usability evaluation of learning
management systems: Empirical evaluation of the System Usability Scale. The International
Review of Research in Open and Distributed Learning, 16(2).

11
INTRODUCTION TO COMPUTER SKILLS
Propa, G., Banwet, D.K. and Goswami, K.K., 2015. Sustainable Operation Management
Using the Balanced Score Card as a Strategic Tool-A Research Summary. Procedia-Social
and Behavioral Sciences, 189, pp.133-143.
Strang, K. ed., 2015. The Palgrave handbook of research design in business and
management. Springer.