1. Logo creation: Simple design with lines and shapes representing skiing, incorporating company initials TSR.
2. Database structure: HOLIDAY database with tables for HOTEL, GUEST, and BOOKING.
3. Web pages: Creation of Home and Ski Lessons pages, use of HTML, color schemes, image links, and interlinking pages.
4. Spreadsheet tasks: Handling equipment hire, ski pass discounts, and formula-based calculations in MEMBERS worksheet.
5. Querying database: Retrieving data using SQL queries on the GUEST and HOTEL tables.
6. Charts and data analysis: Creating charts for ski run percentage lengths and analyzing member costs.