Integrating marketing research and book production with excel/VBA and logogram–algorigram logic engineering field in education technical, technology tools assessment ,orientation lesson organization lesson ,electrical engineering/ engineering policy version 3

Read full text Summarise with VIRAT
Authors: tshingombe tshitadi, tshingombe tshitadi
Cited by: 0

Summary

No summary yet. VIRAT can read this paper and write a plain-language summary of its aim, methods, key findings and limitations.

Summarise with VIRAT Free to try with your Science Catalogs account.

Abstract

Abstract This research explores the integration of a marketing research plan and a book production schedule using Excel formulas and Visual Basic for Applications (VBA) . It demonstrates how logigrams (flowcharts) and algorigram coding (VB algorithms) can automate decision-making and sequential workflows, supporting both educational assessment structures and industrial management systems . Scope Marketing research planning (scope, objectives, vendor selection). Book production scheduling (drafting, reviews, layout, finalization). Excel/VBA automation for timelines and dependencies. Application in South African TVET and engineering contexts . Overview The project integrates two workflows: Decision-based research planning (in-house vs. vendor). Sequential production scheduling (chapters 1–5). Both are linked through Excel worksheets and automated with VBA. Description Worksheet 1: MarketingPlan → ID, Owner, Start, Days, End. Worksheet 2: BookSchedule → Chapter, Task, Start, Days, End. Excel Formula: =WORKDAY(StartDate, Days, Holidays) ensures realistic timelines. VBA Code: Automates start/end dates and dependencies. Statement The integration of research and production workflows enhances transparency, efficiency, and alignment with international educational standards. Data Analysis Inputs: Start dates, task durations, holiday ranges. Outputs: Calculated end dates, workload multipliers. Dependencies: Research completion feeds into book draft start. Advantages Transparent scheduling. Automated decision-making. Scalable for multiple projects. Supports bilingual curriculum design. Disadvantages Requires technical literacy in Excel/VBA. Initial setup time is significant. Holiday ranges must be updated manually. Management System Excel worksheets act as the management dashboard. VBA scripts enforce consistency and automate calculations. Logigram/algorigram logic ensures structured workflows. Information Investigation Research plan investigates vendor suitability. Book schedule investigates production bottlenecks. Both processes generate audit-ready timelines. Delivery Automated schedules delivered via Excel outputs. Flowchart logic delivered as VB code modules. Audit VBA ensures traceable calculations. Worksheets provide transparent task ownership. Technical Rewrite Flowchart logic (logigram) → VB code (algorigram). Example: vb If vendorNeeded Then EvaluateProposals() SelectVendor() Else ProceedInHouse() End If Norm Aligns with South African TVET norms for structured assessment. Supports international qualification equivalence .

Fields of Study & Subjects

Engineering and Information Technology Spreadsheets and End-User Computing Decision Support System Applications

Publication details

Publication date
18 March 2026
Language
EN