Considering that SharePoint and InfoPath based Budget Request Form is not a viable solution in many districts, I added a new Budget Request Form developed in Microsoft Word to the CBB Toolkit. You can also download the form by clicking on this MS Word icon .
This version includes three critical elements that are often missing in a typical budget request form: 1) unit cost, 2) measurable target outcomes, and 3) review cycle. Compared to the web-based solution (SharePoint and InfoPath), using the MS Word based Budget Request Form has many limitations. With that said, it does provide the following features:
- It is a template file. When a user opens the template, a new file will be automatically created with the template intact.
- It is a password-protected fillable form. Users cannot make changes to the form except filling in the fields.
- The Subtotal, Total, and Unit Cost fields will be automatically calculated if users press the “Tab” key to move to the next field when filling out Section B and C.
After users fill out and return this MS Word based Budget Request Form, the next task is to extract (export) the data entered in the Word document for reporting and analysis. It is a tedious job to do this manually, and will become time-consuming and labor intensive as submitted budget requests accumulate after a few years. I will provide a solution that exports the data from all submitted budget request forms into Excel using the free open-source software R at a later date.
If you have any question about how to use or tweak this Word version Budget Request Form or suggestions, please contact me.