Loading...
Ebenezer Higher Institute of Science and Technology
Loading...
Ecomerce and Digital marketing
Students design a small relational database from a business case, create it in MySQL and query it with SQL. Covers DBMS concepts; relational model; MERISE MCD/MLD; normalisation to 3NF; SQL DDL/DML; joins and subqueries; relational algebra; intro to transactions and backup. Tools: XAMPP, phpMyAdmin/DBeaver, draw.io. HND: Case Study Section B; Practice of Computer Section A. Joint with SWE112. 2 hrs/week (26 semester hrs). Project: online-shop database (MCD, MLD, SQL script, sample data, 15 marketing queries).
Students use a computer confidently for study and marketing work: hardware/software fundamentals (COS11); OS skills; digitising information; Word, spreadsheets and simple databases; presentations and Canva; internet/email/cloud collaboration; basic networking; cybersecurity and responsible digital use. HND: Computer Studies (COS11); Digital Marketing Section A. Joint with SWE117. 2 hrs/week (26 semester hrs). Portfolio: report, sales spreadsheet, database file, slides, Canva posts and security exercise.
Students solve problems with clear algorithms first, then working C code. Trains HND Case Study Section C format: structured pseudo-code, trace tables and equivalent programs. Topics: algorithms and flowcharts; C basics; selection and loops; functions; arrays; searching and sorting; strings; structures; intro to pointers and files. Tools: GCC, Code::Blocks/VS Code. HND: Case Study Section C (40%); Practice of Computer Section B base. Joint with SWE114 (Friday only). 2 hrs/week (26 semester hrs). Project: menu-driven product stock manager.
Students analyse a business information system with MERISE from user needs to a working MySQL database, ready for a timed HND Case Study Section A. Topics: information systems; MERISE method; user needs; information flow diagrams; data dictionary and FDG; MCD; MLD/LMD; normalisation; physical model and MySQL implementation; MCT/MOT; intro UML (use case and class diagrams). Tools: draw.io, XAMPP. HND: Case Study Section A (30%); Practice of Computer Section A. 2 hrs/week (26 semester hrs). Project: full MERISE analysis of a local business with MySQL implementation.
Students learn core marketing principles and apply them with digital tools, producing a basic marketing and digital plan for a real small business. Topics: marketing concepts; environment (PESTEL/SWOT); market research; STP and personas; consumer behaviour; 4Ps/7Ps; branding; intro to digital marketing; digitising information and digital foundations; web channels; metrics; digital marketing plan. Tools: Google Forms, Canva, Google Business Profile, WhatsApp Business. HND: Digital Marketing (EDM16) Section A. Lecturer TBC. 2 hrs/week (26 semester hrs). Project: marketing and digital plan for a partner business.
Students master algebra, functions, sequences, matrices and calculus for the HND Discrete Mathematics analysis section, with business/marketing applications (sales growth, interest, cost/revenue, break-even, profit maximisation). Topics: algebra review; functions; sequences and series; matrices and determinants; limits; differentiation; integration; HND exam practice. Tools: GeoGebra, Desmos, spreadsheet. HND: Discrete Mathematics (EDM18) — analysis. Joint with SWE116. 4 hrs/week (52 semester hrs). Project: applied break-even and profit study for a local business.
Students build and publish a responsive multi-page website by hand with HTML5, CSS3 and basic JavaScript, ready for search engines and marketing use. Lab-based: how the web works; HTML5 structure and forms; CSS3, Flexbox and Grid; responsive design; JavaScript and the DOM; marketing pages (meta tags, Open Graph, landing pages, WhatsApp links); publishing with Git/GitHub Pages or Netlify. HND: Practice of Computer (EDM15) Section C — web design (35%). Joint with SWE111. 2 hrs/week (26 semester hrs). Project: 4–5 page Cameroonian small-business site with landing page, validated form and public link.
Students take a database from a business case through the full MERISE cycle to a secure, tested MySQL implementation. Topics: MCD/MLD/MPD at exam level; normalisation to BCNF; relational algebra; advanced SQL (joins, subqueries, window functions); views; stored procedures and functions; triggers; transactions and concurrency; security, roles and backup. Tools: MySQL 8/MariaDB, DBeaver/Workbench, draw.io. HND: Case Study Section B; Practice of Computer Section A. Joint with SWE211. 2 hrs/week (26 semester hrs). Project: multi-seller online marketplace database with views, procedures, triggers and roles.
Students explain how networks work, plan IP addressing with subnetting, configure a small office network in a simulator, and set up basic services an online business needs. Topics: network fundamentals; OSI/TCP-IP; media and devices; IPv4 addressing and VLSM; IPv6; protocols and services (DNS, HTTPS, email); routing; VLANs; network administration; wireless and security. Tools: Packet Tracer, Wireshark, VirtualBox, Ubuntu Server. HND: Case Study Section D; Practice of Computer Section D. Joint with SWE213. 4 hrs/week (52 semester hrs). Project: e-commerce company network (VLSM, VLANs, DHCP, web/DNS, ACL, Wi-Fi).
Explore our programs to see how you can pursue your academic goals in E-commerce & Digital Marketing.
Students explain electronic payments in Cameroon and CEMAC, compare methods and providers, test a payment integration in sandbox mode, and protect a business against fraud. Topics: payment systems overview; cards; mobile money (MTN MoMo, Orange Money); other methods; gateways/aggregators; website integration; transaction security; fraud and risk; receipts and reconciliation; BEAC/COBAC regulation and trends. No real money in practicals. HND: E-Commerce Technology (EDM17) Section B — electronic payment systems. Lecturer and timetable TBC. Assumed 2 hrs/week (26 semester hrs). Project: payment design with sandbox test record, security and fraud procedures.
Students make a website findable on search engines, measure traffic, plan search advertising and use email to convert visitors. Topics: how search engines work; keyword research; on-page and technical SEO; Search Console; off-page and local SEO; Google Analytics 4; Google Ads (draft); display advertising and conversion; email marketing; integrated web marketing strategy. Tools: Search Console, GA4, PageSpeed Insights, Keyword Planner, free email tool. HND: Digital Marketing (EDM16) Section B — web knowledge, ads, email, strategy. Lecturer and timetable TBC. Assumed 2 hrs/week (26 semester hrs). Project: SEO audit and web marketing plan for a local business site.
Students compute probabilities, use main distributions, describe data and test simple claims, applied to marketing and business data (surveys, clicks, sales, A/B tests). Topics: counting; probability basics; conditional probability and Bayes; random variables; binomial/Poisson/normal; descriptive statistics; sampling and estimation; hypothesis testing and A/B testing; correlation and regression; HND exam practice. Tools: spreadsheet, Python in Google Colab. HND: Discrete Mathematics (EDM18) — probability and statistics. Joint with SWE214. 4 hrs/week (52 semester hrs). Project: marketing data study with descriptive stats, hypothesis test and regression.
Students turn a UML class diagram into a working OOP program (C++) with classes, inheritance, polymorphism, collections and file storage, ready for forms and database access in Semester 2 (EDM221). Topics: C to C++; classes and objects; MCD/UML to code; inheritance; polymorphism; STL collections; exceptions and files; intro to event-driven programming. Tools: g++, VS Code/Code::Blocks, draw.io. HND: Case Study Section C; Practice of Computer Section B (OOP base). Joint with SWE212. 2 hrs/week (26 semester hrs). Project: console order-management system from a supplied MCD and class diagram.
Students explain the technology behind online selling and build, configure and run a working online store suited to the Cameroonian market. Topics: e-commerce foundations and models; infrastructure; platforms (WooCommerce, marketplaces, social commerce); building a store; configuration and policies; online media; advertising; retailing and services; EDI/APIs; security and logistics. Tools: WordPress/WooCommerce on XAMPP, draw.io. HND: E-Commerce Technology (EDM17) Sections A and B (infrastructure). Lecturer and timetable TBC. Assumed 2 hrs/week (26 semester hrs). Project: working online store (15+ products) with infrastructure/advertising/security/delivery report.
Students plan, create, run and measure social media marketing for a real small business, including community, ethical and legal issues. Topics: social landscape in Cameroon; strategy and KPIs; business accounts and branding; content planning and creation; community management; influencer marketing; paid social (draft only); analytics; digital society, ethics and crises. Tools: Meta Business Suite, Canva, CapCut, WhatsApp Business. HND: Digital Marketing (EDM16) Section B. Lecturer and timetable TBC. Assumed 2 hrs/week (26 semester hrs). Project: 4-week organic campaign for a partner business (strategy, calendar, content, draft ads, results report).