Supplier database and stock/sales comparison
Donald Trump
bsbitu304a_-_assessment_task_1_2015.docx
Assessment Task 1 BSBITU304A Produce spreadsheets (STUDENT’S NAME)
Supplier Database
Submission details
|
Student’s name |
|
|
Assessor’s name |
|
|
Date submitted |
|
Performance objective
The candidate must demonstrate knowledge and skills in creating a database from supplied raw data using an Excel spreadsheet.
Assessment description
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.
Procedure
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
