Supplier database and stock/sales comparison

Assessment Task 1 BSBITU304A Produce spreadsheets (STUDENT’S NAME)

Student’s name

Assessor’s name

Date submitted

The candidate must demonstrate knowledge and skills in creating a database from supplied raw data using an Excel spreadsheet.

Using the raw data supplied to you by your assessor, you are required to develop a database of contact information for a simulated workplace (Cindy’s CDs). Once you have developed the database, you must be able to sort, filter and print the data successfully.

1. Using Excel, create a database of contact information for suppliers to Cindy’s CDs using data supplied by your assessor.

2. Format the database to comply with Cindy’s CDs Style Guide (Appendix 4).

3. Save your work with an appropriate filename to the required destination as specified by your assessor.

4. Sort the supplier database you have selected alphabetically by specialisation.

5. Print the sorted information.

6. Use the filter to display only Victorian suppliers.

7. Print the filtered information.

© 2009 IBSA MC v.2 2015 Page 1 of 1