Business Information System Assignment 2022

BUSINESS INFORMATION SYSTEM
EXCEL ASSIGNMENT
LAURA CATALINA POVEDA VARGAS
00161328T
TORRENS UNIVERSITY OF AUSTRALIA
2018-1
The objective of this report is to highlight the steps followed when creating excel data
base and practice the excel skills that have been gained in the course of the study.
In the first calculation worksheet named individual registration, the data used is
obtained from the formula 1 website and the information is based on the case study of
the Formula 1 Grand Prix in Australia.
The picture below provides details of the information that was needed so as to prepare
the registration database for the clients.

The steps highlighted below were followed when creating the individual registration
data sheet in the excel workbook.
a. Individual registration
The first step was to enter all the details that were needed so as to create the database for
a reservation system, these include basic information. The worksheet name is thereafter
changed and written as individual registration
The neext step is to align the title of the database on a row on top of the created table

In the columns ticket type, cost of ticket and the number of tickets bought, data
validation was undertaken. This validation gives a restriction of the type of data that can
be accepted by the cells under these columns. This feature of Excel prevents the user of
the database from entering incorrect information in the Excel sheet.
Under the cell format option, the features available allows the user to perform a number
of functions examples being
 Aligning the text
 Changing the font size
 Setting borders
 Adding background colour as well as changing the colour of the texts.
 Under the post code and telephone columns, it can be established that the
information presented in the cells will be numbers.
 The cost column and the amount paid column contains currency. These can be
formatted to be in Australian dollar and necessary decimal places specified.