Marketing/Ent 10

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:

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
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).
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.
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).
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).
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”).
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

Open a New Spreadsheet:
- Excel: Open Excel and create a new workbook.
- Google Sheets: Open Google Sheets and create a new spreadsheet.
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:

Daily Change (Column H):
- Formula: =D2 - C2
- Explanation: This calculates the difference between the closing price and the opening price.
% 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.

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

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

Samples Below

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

Criteria	Description	Marks
Logo Design	Creativity, originality, and relevance of the logo to the business theme.	10
Tours/Pricing	Clarity and organization of the services section, including descriptions of each service.	5
Billboard	Effectiveness and creativity of the billboard design concept, including messaging.	5
Social Media Ad	Innovation and appeal of the social media ad concept, including target audience consideration.	5
Swag Items	Creativity and variety of swag items proposed (3-5 items), and their relevance to the brand.	5
Vehicle Branding	Originality and effectiveness of vehicle branding concept, including visual impact.	5
Clothing Design	Creativity and marketability of the clothing design concept for branding purposes.	5
Flier	Clarity and professionalism of the flier design, including necessary information.	10