Name: Georgeann Schenker
School District: Greater Egg Harbor,Oakcrest High School
Category: 9 to 12
Title of Plan: Tchnology Utilization in Marketing
Support Materials: Excel Worksheet

"Technology Utilization in Marketing"

Goals and Objectives of Lesson

GOALS
Through technology based marketing trends, students will create a web page, photo portfolio and various other sellable products for the "Falcon Sprout", which is a floral shop at Oakcrest High School.

OBJECTIVES

• Students will develop marketing skills, which will be used to sell a product or service.
  
  
• Students will master various software previously introduced, i.e. MS Publisher ’98, MS Office ’97, Adobe PhotoDeluxe 2.0.
  
  
• Students will be introduced to MS FrontPage.
  
  
• Students will master the use of technology resources including the scanner and digital camera in conjunction with a color printer and assorted printing materials.

Specify which New Jersey Core Curriculum Content Standards addressed

Cross-Content Workplace Readiness Standards And Progress Indicators

• Standard 1:
  All Students will Develop Career Planning and Workplace Readiness Skills (Specifically 1-1, 1-8, 1-11, 1-12) – through the development of marketing skills and working together in groups
  
  
• Standard 2:
  All Students Will Use Information, Technology, And Other Tools (Specifically 2-2, 2-3, 2-7, 2-8, 2-9) – use of the various softwares and peripherals in the project
  
  
• Standard 3:
  All Students Will Use Critical Thinking, Decision Making And Problem-Solving Skills (Specifically 3-11, 3-12, 3-14, 3-15) – creating the excel spreadsheet, brainstorming marketing strategies
  
  
• Standard 4:
  All Students Will Demonstrate Self-Management Skills. (Specifically 4-3, 4-4, 4-5, 4-10) – keeping an accurate, honest record of their time and working independently
  Visual and Performing Arts
  
  
• Standard 1.1:
  All Students Will Use Information, Technology, And Other Tools – Web Page, Portfolio

Language Arts Literacy

• Standard 3.3:
  All Students Will Write In Clear, Concise, Organized Language That Varies In Content And Form For Different Audiences And Purposes. – greeting card phrases, Web Page

Mathematics

• Standard 4.2:
  All Students Will Communicate Mathematically Through Written, Oral, Symbolic, And Visual Forms Of Expression – Excel spreadsheet/graphs
  
  
• Standard 4.5:
  All Students Will Regularly And Routinely Use Calculators, Computers, Manipulatives, And Other Mathematical Tools To Enhance Mathematical Thinking, Understanding, And Power – Excel Spreadsheet/graphs
  
  
• Standard 4.11:
  All Students Will Develop An Understanding Of Patterns, Relationships, And Functions And Will Use Them To Represent And Explain Real-World Phenomena – graphs, product pricing
  
  World Language
  
  
• Standard 7.1:
  All Students Will Be Able To Communicate At A Basic Literacy Level In At Least One Language Other Than English. greeting card translation

Summary of the Lesson

• Guest Speaker – "Marketing Innovations"
  
• Floral Portfolio
  
• "Falcon Sprout" Web Page
  
• Greeting Cards/T-Shirt Designs
  
• Marketing Analysis

Equipment, materials and other technology needed

• Microsoft Office Microsoft Publisher ’98
  
• Microsoft FrontPage Digital Camera and/or 35mm Camera
  
• Scanner Color Printer
  
• Photo Paper Greeting Card Paper
  
• Iron-On Transfer Paper T-shirts (various sizes)
  
• Portfolio – Easel Design Adobe Photo Deluxe 2.0
  
• Poly Protectors

Detail of Activities

A guest speaker from a local marketing firm will make a small presentation to the students. The presentation will focus on Marketing in the future, including advertising and public relations trends. The presentation will also include a short segment on how to market the "Falcon Sprout". In class students will follow-up by brainstorming and discussing their own

Marketing strategies for the project. Students will photograph floral designs using a digital camera and utilize photo editing software, Adobe Photo Deluxe, to maximize picture quality, etc. If a digital camera is not available, a 35 mm camera can be used, and the pictures can then be scanned. Pictures will then be printed on 8 ½ X 11 photo paper, and placed in poly protectors and finally in a portfolio. (see attached handout)

The end result in this phase of the project is a portfolio of products that are numbered and priced, which will be used as a selling tool. Students will visit various web sites to begin collecting ideas for creating their site, i.e., http://excite.netscape.com/shopping/flower/ Students will create a web site using thumbnail photos of various floral design samples, along with pricing.

The final Web Page will allow students, faculty, parents, friends and relatives to use the Internet as their "catalog" to view the product or services and place orders. (see attached handout) It is important at this stage to advertise the web site via flyers and/or letters home to parents. Students from various other classes will have an opportunity to share in this project during this phase. Greeting cards will be made to accompany floral designs. "Creative Writing" classes will be asked to compose short phrases for various occasions. After the best phrases are selected, "Advanced Art" students will create original artwork to be photographed and/or scanned and used along with the phrases.

Next, Spanish IV students will translate the phrases to Spanish as to attract the large number of Hispanic speaking students. Any of these art designs and/or phrases can be transferred to a T-shirt, which would also advertise the "Falcon Sprout". This phase of the project requires much coordination on the students’ part, however, the end resulting product will be unique and inexpensive to create. Finally, students will do a marketing analysis of sales before and after the implementation of the marketing tools created in this project using MS Excel and bar graphing. (see sample attached)

Student Feedback and Assessment

Assessment will be ongoing, and as with most technology-related projects, drafts are important. Students should be asked to keep a time log of work their work, along with drafts of all finished products they create. If they are working with a group of students, this should be noted in the log. This can all be kept in a three-ring binder or portfolio of their own.

Additional comments and suggestions

In this lesson plan floral designs are used as the product to be marketed, however, this can be substituted by school store products, logoed items, fundraiser items… Also, there are many different web design and desktop publishing software, which can be substituted for the ones mentioned. Finally, this project should be an ongoing effort. Each year students can add, change or enhance the marketing efforts created by the previous class, and each year an analysis can be done to determine their success.Computer Applications IV Floral Design Marketing Project Phase 3 – Web Site   Begin by visiting various sites for ideas on how to create a Web Site for the "Falcon Sprout".

A site you can visit
http://excite.netscape.com/shopping/flowers/

Be prepared to report on your ideas and brainstorm on other ideas.After we determine the basic design of the site, we will break into groups of 5 people and each group will be responsible for a specific part of the site.

All groups must elect

• Group Leader:
  
• Record Keeper:  
  
• Designer:  
  
• Time Keeper:  
  
• Liason:  
  
• Record Web Sites:
  
• Record Ideas

Computer Applications
Floral Design Marketing Project
Phase 2 – Floral Design Portfolio
Begin by taking 15-20 digital photos of various floral designs (high quality setting).
Each student will be responsible for at least 1 useable photo to be included in the "Falcon Sprout" Portfolio.
Utilize Adobe Photo Deluxe to enhance photos.
Print a black and white draft; you will need to get pricing from the "Falcon Sprout".
Print a color draft for your portfolio.
Print a final draft for the "Falcon Sprout" Portfolio.