Statement of Purpose (SOP) Generator -- docx version (DansonGo 5)
A simple module for generating a bunch of SOPs for different schools.
Using the same content framework, the model will generate multiple SOPs for different schools by replacing the school and program names with the target school and program in the statement.
- An excel that includes school names and program names (e.g., school_list.xlsx)
- A docx file of your statement template (e.g., SOP_template.docx)
How to use (Mac)
Method 1: Run from terminal
Run "GEN_SOP.py" in terminal from the folder that contains "GEN_SOP.py" and two prerequisite files.
Rename your school list excel file as "school_list.xlsx".
In "school_list.xlsx", please make sure that the school and program column names are "School" and "Program", respectively. (TAKE CARE OF THE FIRST CAPITAL LETTER)
Rename your docx as "SOP_template.docx"
In your "SOP_template.docx", please label the school position as "[SCHOOL_NAME]". Please label the program position as "[PROGRAM_NAME]"
Run the command below from terminal
Method 2: Run as module
from GEN_SOP import GEN_SOP GEN_SOP(school_list,SOP_temp_file,School_var,Program_var,output_path).gen_sop()
school_list : The excel file path where the list of schools and programs is saved.
SOP_temp_file : The docx file path of your SOP template.
School_var : The column name where the school name is saved in your school list.
Program_var : The column name where the program info is saved in your school list.
output_path : Output path where you want to save your output files.