All subjects · Information Technology · WIT13 2 hour written exam on data, enabling technologies and systems development
Customer relationship management and management information systems
Edexcel IAL Information Technology · WIT13 2 hour written exam on data, enabling technologies and systems development
CRM systems manage an organisation's relationships with its customers. Management information systems (MIS) turn transaction data into information that managers use. A June 2024 question asked for a 12-mark evaluation of a college MIS (spec 14.1.3 and 14.1.4).
Customer relationship management (CRM)
A CRM system stores everything about each customer (contact details, purchase history, communications, complaints, preferences) in one place, available to sales, marketing and customer service staff. Uses named in the specification:
- Synchronising marketing events: campaigns, emails and offers timed and targeted to the right customers across channels.
- Loyalty schemes: points and rewards tracked per customer; data shows what loyal customers buy.
- Buying trends: analysing purchase history to predict demand and spot popular products.
- Customer service: any agent can see the full history, so problems are solved faster.
- Customer retention: identifying customers who may leave and contacting them with offers.
- Upselling: suggesting higher-value or additional products based on what similar customers bought.
Issues: cost and staff training; poor data quality makes it useless; privacy and consent for marketing; customers may dislike over-targeting.
Management information systems (MIS)
An MIS collects data from internal systems (transaction processing, HR, finance) and sometimes external sources, and turns it into summarised, timely information (reports, dashboards, exception reports, graphs) for managers.
Uses named in the specification:
- Record-keeping: central, up-to-date records (in a college: students, attendance, grades, staff, finances).
- Decision-making: reports showing trends and comparisons help managers plan (which courses to run, where to cut costs); exception reports flag problems (students below 85% attendance).
- Project management: tracking tasks, budgets, resources and deadlines.
Good information is accurate, relevant, timely, complete, easy to understand and cost-effective to produce.
Evaluating an MIS (12-mark style)
Benefits: faster, better-informed decisions; one source of truth; automatic reports save staff time; trends spotted early; easier monitoring of performance.
Drawbacks and implementation issues: high cost of software, hardware and customisation; staff training and resistance; data migration from old systems; reports are only as good as the data entered (garbage in, garbage out); security and privacy of personal data; dependence on the system; information overload.
A judgement might weigh the long-term gains in decision quality against the up-front cost and disruption, and state conditions (good training, data quality checks).
Worked example
A college MIS flags that attendance on one course has fallen below 80% for three weeks. How does this support decision-making?
- The MIS combines register data from all classes automatically.
- An exception report alerts the course manager without anyone searching manually.
- The manager can drill down to see which students and sessions are affected.
- Action (contacting students, changing timetables) is taken early, improving retention and results.
Answer: Timely exception reporting lets managers act before the problem grows
Check yourself
- A website suggests a more powerful laptop to a customer viewing a basic model. Which CRM use is this?
- Customer retention
- Record-keeping
- Synchronising marketing events
- Upselling
Show answer
Upselling. Encouraging a higher-value purchase.
- A phone company offers a discount to customers whose contract is ending and who have been looking at rivals' deals. Which CRM use is this?
- Upselling
- Customer retention
- Loyalty scheme design
- Project management
Show answer
Customer retention. Keeping customers who might leave.
- A manager receives a report listing only the products whose stock is below the minimum level. What type of report is this?
- A transaction log
- A data dictionary
- A backup report
- An exception report
Show answer
An exception report. It shows only items outside normal limits.
- Why might an MIS give misleading reports?
- Inaccurate or incomplete data was entered into the underlying systems
- The reports use graphs
- Managers read them too quickly
- The MIS has too many users
Show answer
Inaccurate or incomplete data was entered into the underlying systems. Garbage in, garbage out.
- How does a CRM system improve customer service?
- It removes the need for staff
- It stops customers complaining
- Any agent can see the customer's full history and solve problems without repeating questions
- It hides purchase history from staff
Show answer
Any agent can see the customer's full history and solve problems without repeating questions. A single customer view.
- Which is the main purpose of a management information system?
- To provide managers with summarised information to support decisions
- To process each sale at the till
- To control a robot arm
- To encrypt emails
Show answer
To provide managers with summarised information to support decisions. MIS turns data into management information.
- Explain how analysing buying trends in a CRM helps a clothing retailer.
Show answer
Purchase history shows which products are becoming popular and when, so the retailer can stock the right items at the right time and target promotions, increasing sales and reducing unsold stock.. Trend, action, benefit.
Sources
- Pearson Edexcel International Advanced Level in Information Technology specification (first teaching 2018), Issue 2, February 2021
- Pearson Edexcel IAL Information Technology: scheme of work for Unit 3
- Pearson Edexcel IAL Information Technology WIT13/01 mark scheme, June 2024 series
Last updated 8 November 2026. Spotted a mistake? Tell us.