Module 2-3 Excel Exercise EXCEL SPREADSHEET A spreadsheet is a software tool that allows large amounts of data to be stored, organised, analaysed and presented in graphical form. A spreadsheet is extremely useful because of its ability to make simple work of a mundane task (for example calculating the average time for all 5000 participants for the Tour Down Under Event). Calculating averages is not difficult but the sheer volume of work is time-consuming. A spreadsheet allows you to create your own “formula” and then apply that formula to all 5000 at the same time, reducing the amount of work necessary dramatically. Data, information and knowledge are important in all types of businesses. It is very important the correct data is recorded in the business systems to get the correct information and produce the right knowledge. In this assessment, you will learn how to manage and control data using spreadsheets. Module 2-3 Spreadsheet Exercise The weekly Spreadsheet exercise is designed to assist you in completing your Excel Assessment. Instructions: • Read the Tour Down Under (TDU) Case Study- Introduction.doc • If you want to read the guide on using Excel, read the Basic Skills in Using Excel 2013. Pdf (pages 1-9). However, if you prefer watching the video on how to use Excel, go to this website: Introduction to Excel - https://www.youtube.com/watch?v=J4zq3R8b5dQ • Create an Individual Participant Workbook • You need to identify what data are needed when a participant registers at TDU. • Go to this website to know details needed for individual participant a. https://satourism.myshopify.com/products/bupa-challenge-tour b. Go to select an event and select the BUPA Challenge Tour. You should see this screen:Module 2-3 Excel Exercise • c. The booking page will give you the details of what data you need to store in your excel workbook. d. For each kind of data, create a column and add 3 sample data. For example, if from analysing the registration page, you found out that the Santos TDU organisers ask for the name, address mobile number, and amount paid, then your Excel workbook should look like this. Name Address Date of Birth Mobile No. Amount Paid John 1234 Adelaide St, Melbourne 05/01/1990 +61 40123456 $120 …… • Format your worksheet a. The worksheet tab name is named individual registration b. The document has a title that says Individual registration (make sure the cells are merged for the title) c. Change the background colour of the column names to make it noticeable (you can choose the font and colour that you want) d. Apply styles on the columns. For example, if the data that will be stored are dates, then it should be formatted to the style date with this format dd/mm/yyyy. If the data can contain money, format it using the money format $xxxx.xx e. Your worksheet should something like this:Module 2-3 Excel Exercise • Save your Excel workbook. • Document either in Excel or in a Word document the step you undertook in producing the Individual Participant Regiistraion. Save your document. • BACK-UP! BACK-UP! BACK-UP! Do not forget to keep a back-up files. Either upload in your google drive or dropbox; and/or just e-mail the file to yourself so that you have a copy in your email; and/or save in a USB drive. • You can show your work to your lecturer for feedback. • REMEMBER THAT THIS EXERCISE IS PART OF THE FINAL EXCEL SPREADSHEET ASSESSMENT YOU HAVE TO SUBMIT ON WEEK 7.