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.