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  and unification master engineering auditing  auto grade  engineering /version 3 revised note

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