Easier to read with cream paper, a tint, more contrast or larger text? Choose your colours and text, once, for every page.

Preview

AC 5.2: Digital help for selling, design and people

This is the first page of the lesson. Read it and have a go at the activities. The rest is in the full lesson.

55 minutes

Why the shop knew what you wanted

You look at trainers on a web shop. An hour later the shop shows you the same trainers on another site. The next day it emails you a small offer.

Nobody in the shop watched you. Digital systems counted your visit and matched it to an offer. Today you see what such systems do for sales, design and staff records.

Key words

WordWhat it meansExample
Sales and marketingfinding customers and selling to them
Analyticstools that count and study what people dovisits to a web page
Market researchfinding out what customers want
Brandthe name, look and values people link to a firm
Personaliseto change what you offer so it fits one person
Customer retentionkeeping customers so they buy again
Personal datainformation about a living person who can be named or found
SQLa language for asking questions of data held in tables
Human Resourcesthe team that looks after staff, often called HR
Performance managementsetting goals for staff and reviewing how they do

The cells students fill in are left blank in this preview.

By the end of this lesson

Note

I can describe how a digital system helps sales and marketing, design and development, and Human Resources.

Starter: what you already know

Have a go

Starter: what you already know

3 questions
Have a go: your answers are marked here and then forgotten. Sign in if you would like your score kept, and to pick up where you left off.Sign in to keep your score

Your answers are marked here and are not kept. A college account keeps every student’s marks.

Sales and marketing find and keep customers

Digital systems help a firm learn who its customers are. Market research is quicker with online surveys. Social media promotes the brand. A web shop sells all day.

Analytics show what each customer looks at. The firm can then personalise offers. Happy customers come back. That is customer retention.

Sales and marketing: system and benefit

What the system doesBenefit to the firm
Online survey and reviewsBetter market research
Posts on social mediaPromotes the brand to many people
Web shop with card paymentOnline selling, open at any time
Shows each visitor items like ones they viewedPersonal offers that fit the customer, from studying their behaviour
Email offers and loyalty pointsCustomers come back, so better retention
Search and social media analyticsShows what works and what to stop
A clear brand look and message onlineThe firm stands out from rivals and shows its values

The cells students fill in are left blank in this preview.

An analytics question in SQL

Code: sql
-- Which page gets the most visitors in total?
SELECT page, SUM(visitors) AS total
FROM visits
GROUP BY page
ORDER BY total DESC;

Check: sales and marketing

Have a go

Check: sales and marketing

4 questions
Have a go: your answers are marked here and then forgotten. Sign in if you would like your score kept, and to pick up where you left off.Sign in to keep your score

Your answers are marked here and are not kept. A college account keeps every student’s marks.

The lesson goes on

6 more parts of this lesson are in the full curriculum, with the tasks, the final check and the labs. A college account gives your students all of it.