This resource provides strategies for cleaning data in Microsoft Excel. Below is a brief overview of five situations you may find yourself in (“What”) and corresponding solutions (“How”), followed by detailed instructions to implement the solutions.
An evaluation plan should include a clear description of what data will be collected, from what sources and how, by whom, and when, as well as how the data will be analyzed. Placing this information in a matrix helps ensure that there is a viable plan for collecting all the data necessary to answer each evaluation question and that all collected data will serve a specific, intended purpose. The table below may be copied into another document, such as a grant proposal, and edited/ expanded as needed. An example is provided on the next page.
On the 2015 ATE survey, 65 of 230 principal investigators (28%) reported spending some portion of their annual budgets on research. Six of these projects were funded as targeted research. Among the other 59 projects, expenditures on research ranged from 1% to 65% with a median of 14%. With just six targeted research projects and less than a third of all ATE grantees engaging in research, there is immense opportunity within the ATE program to expand research on technician education.
The full report of 2015 ATE survey findings, along with data snapshots and downloadable graphics, is available from www.evalu-ate.org/annual_survey/.