Marketing/Ent 10

Assignment #5 – Wearables Brand

Create your own unique brand and create a branded product line.
Wearables can be clothing, watches, hats, shoes, bags, backpacks, jewelry, tech, glasses, sports gear, makeup etc.

Name
Logo
Slogan
Billboard – Celebrity Ad
Vehicle
Delivery Box/Bag


Website – Home Page, About Us, shopping cart, reviews, FAQ’s, Photo Gallery, AI Video
SEO – 100 words
Product line – 10-50 products – Images, Description, Pricing

Bonus: Splash Page, SWAG, Guerilla Marketing

Assignment #4 – Real Estate Company

Name
Logo
Slogan
Business Card
Billboard
Vehicle
Print Ad
SWAG
Website – Home Page, About Us, Listings, reviews
SEO – 100 words
Video Ad

Assignment # 3 – Adventure Tourism Website/Branding
Pick an adventure tourism business – surfing, skiing, whale watching, bungee, ziplining, nature tours, etc.

Websites

AI Graphics Program

Canva

AI VIDEO

Name
Logo
Slogan
Billboard
Social Media Ads
Clothing
Vehicle
Swag
Tours – 3 with description and pricing
Flier – with tours and prices and images

Website – done in Wix, create an account and choose a template

HOME PAGE
SERVICES PAGE with PRICES
BOOKING PAGE – WON’T FULLY WORK
VIDEOS PAGE
PHOTO PAGES
ABOUT US PAGE
LOCATION/CONTACT AND HOURS PAGE (map)
SEO – 100 WORDS – ON HOME PAGE
CUSTOMER TESTIMONIALS/REVIEWS

BONUS – SPLASH PAGE, PRODUCT PAGE (STORE) for products related to your service

WIX VIDEOS

 

 

 

https://jamiemitchell0.wixsite.com/serenity-diving

https://maddoxstanton.wixsite.com/shred-society-1

https://gryphonhodgson.wixsite.com/island-escape-char-1

https://connorchislett4.wixsite.com/lensinthewild

https://masonfawcett24.wixsite.com/my-site-2

https://maddisonshortt4.wixsite.com/storycometrue/home

https://ikemichels-lesage.wixsite.com/blue-horizon-tidal-1

https://asherarichard.wixsite.com/beyondbackpacking

https://graydenbarker.wixsite.com/fishandfeast

https://deathdropbungee.wixsite.com/masonandmike

https://theajean8.wixsite.com/my-site-8

https://maddoxstanton.wixsite.com/shred-society-1

https://gracecochran17.wixsite.com/pacificparks

https://catherineyahn.wixsite.com/thrilltopia-3

https://loganthompson0.wixsite.com/my-site-1

https://masonfawcett24.wixsite.com/my-site-2

ASSIGNMENT #1

Presentation – Use PPT, Google Slides or any other software

Define, explain and/or illustrate, Every slide should have at least one image or graphic, but the more the better

  • Entrepreneurship
  • Market Research
  • Business Plan Development
  • Profit and Loss
  • Supply and Demand
  • Marketing and Advertising
  • Branding
  • Product Development
  • Customer Service
  • Leadership and Management
  • Teamwork and Collaboration
  • Sales Techniques
  • Financial Literacy
  • Investment and Return on Investment (ROI)
  • Corporate Social Responsibility (CSR)
  • Innovation and Creativity
  • Digital Marketing
  • E-commerce

Assignment 2: Sales Data Analysis

Objective: Students will input and analyze sales data using basic formulas and create visualizations to interpret the data.

Instructions:

  1. Create the Spreadsheet Layout:
    • Open a new spreadsheet in Excel, Google Sheets, or another spreadsheet software.
    • Label the columns as follows:
      • Column A: Product Name
      • Column B: Units Sold
      • Column C: Unit Price
      • Column D: Total Sales
  2. Input Data:
    • In Column A (Product Name), list 10 different fictional products (e.g., T-shirts, Laptops, Headphones).
    • In Column B (Units Sold), input the number of units sold for each product. Use realistic figures (e.g., 120, 85, 230).
    • In Column C (Unit Price), enter the price for each product (e.g., $15, $500, $30).
  3. Calculate Total Sales:
    • In Column D (Total Sales), calculate the total sales for each product using the formula =B2*C2. This formula multiplies the number of units sold by the unit price.
    • Drag the formula down from D2 to D11 to calculate the total sales for all products.
  4. Calculate Overall Sales:
    • Below your data (e.g., in cell D13), use the SUM function to calculate the overall sales for all products: =SUM(D2:D11).
  5. Calculate Averages:
    • In a separate cell (e.g., F2), calculate the average units sold using =AVERAGE(B2:B11).
    • In F3, calculate the average unit price using =AVERAGE(C2:C11).
    • In F4, calculate the average total sales using =AVERAGE(D2:D11).
  6. Create Charts:
    • Highlight the data in columns A and D.
    • Go to the “Insert” tab and choose a chart type (e.g., Bar Chart) to visualize the total sales for each product.
    • Add a title to the chart (e.g., “Total Sales by Product”).
  7. Formatting and Presentation:
    • Apply formatting to the spreadsheet for better readability:
      • Bold headers (Row 1).
      • Format the currency columns (C and D) to display as currency ($).
      • Add borders around the data range.
    • Save the spreadsheet with an appropriate name (e.g., “Sales_Data”).

2B. Spreadsheet Setup for Stock Prices

1. Basic Structure

  1. Open a New Spreadsheet:
    • Excel: Open Excel and create a new workbook.
    • Google Sheets: Open Google Sheets and create a new spreadsheet.
  2. Sheet Layout:
    • Column A: Date
    • Column B: Stock Symbol
    • Column C: Opening Price
    • Column D: Closing Price
    • Column E: Highest Price
    • Column F: Lowest Price
    • Column G: Volume
    • Column H: Daily Change
    • Column I: % Change

2. Input Data

Enter your stock data into the corresponding columns. For example:

Date Stock Symbol Opening Price Closing Price Highest Price Lowest Price Volume Daily Change % Change  
2024-09-01 AAPL 175.00 177.50 179.00 174.50 1000000      

3. Formulas

Here are the formulas for the relevant columns:

  1. Daily Change (Column H):
    • Formula: =D2 - C2
    • Explanation: This calculates the difference between the closing price and the opening price.
  2. % Change (Column I):
    • Formula: =(H2 / C2) select percentage icon for cell
    • Explanation: This calculates the percentage change based on the daily change divided by the opening price.
  1.  

ADD 2 MORE STOCKS USING REAL NUMBERS OF STOCKS YOU CAN FIND – USE THEIR SYMBOL

 

Example Spreadsheet

Here’s how a portion of your spreadsheet might look with formulas in place:

Date Stock Symbol Opening Price Closing Price Highest Price Lowest Price Volume Daily Change % Change  
2024-09-01 AAPL 175.00 177.50 179.00 174.50 1000000 2.50 1.43%  
2024-09-02 BSC 177.50 180.00 182.00 176.00 1050000 2.50 1.41%  
2024-09-03 DNI 180.00 178.00 181.00 177.00 1100000 -2.00 -1.11%  
… … … … … … … … … …

Assignment # 3 – Adventure Tourism Website/Branding
Pick an adventure tourism business – surfing, skiing, whale watching, bungee, ziplining, nature tours, etc.

Websites

AI Graphics Program

Canva

Name
Logo
Slogan
Billboard
Social Media Ads
Clothing
Vehicle
Swag
Tours – 3 with description and pricing
Flier – with tours and prices and images

Website – done in Wix, create an account and choose a template
Home Page, Videos page (5 videos), About Us, Contact, Booking Page

WIX VIDEOS

Adventure Tourism Business

  1. Hiking Tours: Organize guided hikes in scenic locations.
  2. Cycling Tours: Lead bike tours through picturesque landscapes.
  3. Whitewater Rafting Trips: Offer exhilarating river rafting adventures.
  4. Rock Climbing Expeditions: Plan climbing trips for enthusiasts of all levels.
  5. Wildlife Safaris: Create safaris to observe local wildlife in their natural habitats.
  6. Ziplining Adventures: Set up zipline courses in stunning natural settings.
  7. Scuba Diving Excursions: Guide underwater diving trips to explore marine life.
  8. Adventure Racing Events: Organize challenging adventure races like obstacle courses or mud runs.
  9. Canoe and Kayak Tours: Lead tours on rivers, lakes, and coastal areas.
  10. Cave Exploration: Offer spelunking adventures for those who love exploring caves.
  11. Paragliding and Hang Gliding: Provide tandem flights and training for these air sports.
  12. Surfing Camps: Offer surf lessons and camps in popular surf destinations.
  13. Ski and Snowboard Tours: Plan winter sports adventures in snowy destinations.
  14. Desert Safaris: Create tours through arid desert landscapes, including camel treks.
  15. Kiteboarding and Windsurfing Lessons: Teach water sports in coastal areas.
  16. Hot Air Balloon Rides: Provide scenic balloon rides in unique locations.
  17. Adventure Retreats: Combine adventure with wellness by offering retreats.
  18. Fishing Tours: Lead fishing expeditions in scenic fishing destinations.
  19. Stand-Up Paddleboarding (SUP) Tours: Offer SUP excursions on lakes and rivers.
  20. Horseback Riding Adventures: Organize horseback riding tours in natural settings.
  21. Bungee Jumping Excursions: Plan bungee jumping adventures from safe and scenic locations.
  22. Skydiving Experiences: Offer tandem skydiving jumps with breathtaking views.
  23. Helicopter Tours: Provide aerial tours of stunning landscapes by helicopter.
  24. Mountain Biking Trips: Lead mountain bike tours on challenging terrain.
  25. Multi-Activity Tours: Create packages that combine various adventure activities in one trip.

Samples Below

Squamish Rafters

El Lujoso Tours

Whale Tail Tours

Tosurfino

Roma Rentals

Island Tours

Ocean Surf Inn

Blue Heron Surfing

Paddle Channel

Van Isle Ballooning

Sea Earth & Air

X-2

69 Hikes

STUDENT SITES

WIX.COM

HOW TO SELL ONLINE

WIX LEARNING

Name
Domain Name
Brand
Slogan
Home Page
100 Word site description
Keywords
Product Category
Product Line 5-100 Items
Pricing
Delivery Box – Branded
Shopping Cart
Product images
Product Descriptions
Billboard
Social Media Ads
Other Pages – FAQ’s, Contact, Reviews, About Us

OTHER OPTIONS – Guerilla Marketing, Vehicle, Coupon, Swag, You Tube Commercial, Tik-Tok ad

Scoring Guide

  • 45-50 Marks: Excellent – Outstanding work with high creativity and professionalism.
  • 35-44 Marks: Good – Solid work with minor areas for improvement.
  • 25-34 Marks: Satisfactory – Adequate work, but several areas need enhancement.
  • 15-24 Marks: Needs Improvement – Significant issues in multiple areas.
  • 0-14 Marks: Unsatisfactory – Incomplete or poorly executed work.

Marking Rubric (Total: 50 Marks) – ME 10 – Assignment 3

CriteriaDescriptionMarks
Logo DesignCreativity, originality, and relevance of the logo to the business theme.10
Tours/PricingClarity and organization of the services section, including descriptions of each service.5
BillboardEffectiveness and creativity of the billboard design concept, including messaging.5
Social Media AdInnovation and appeal of the social media ad concept, including target audience consideration.5
Swag ItemsCreativity and variety of swag items proposed (3-5 items), and their relevance to the brand.5
Vehicle BrandingOriginality and effectiveness of vehicle branding concept, including visual impact.5
Clothing DesignCreativity and marketability of the clothing design concept for branding purposes.5
FlierClarity and professionalism of the flier design, including necessary information.10