Goals:

• Integrate and process Excel spreadsheets from multiple sources.

• Calculate and derive new metrics from combined data.

• Generate individual PDF reports for each district, ranging from 10 to 15 pages.

• Utilize conditional formatting and customized narrative text.

• Enable tailored goals and data tables specific to individual schools.

​

Constraints:

• Execute locally within Excel on a desktop environment.

• User-friendly, single-click execution.

​

Outcome:

• Develop a Word template utilizing bookmarks for seamless data integration.

• Create an Excel VBA script capable of:

  • Aggregating and processing multiple Excel data files.

  • Organizing data by school.

  • Computing trend analyses over multiple academic years.

  • Generating a distinct PDF report for each school, incorporating conditional formatting responsive to the underlying data.