Recordkeeping is a crucial task for any organization, business, or project team. It provides dependable information and data from past experiences that can improve present and future decision making. Recordkeeping, however, is a time consuming process, and it is difficult to know what information to capture and how to best organize that information. Gamma Iota Sigma is an international risk management, insurance and actuarial science collegiate fraternity with an existing recordkeeping system that is relatively inefficient and only of limited value to the organization's chapters. By designing and creating programming-enabled workbooks in Microsoft Excel, I have worked to improve the efficiency, organization, and applicability of Gamma’s recordkeeping system. This project has required an analysis of the current recordkeeping system and discovery of the organization's present and future information needs followed by the creation, testing, implementation, and modification of a new system. By leveraging the many capabilities of Excel and working collaboratively with the Grand Chapter throughout the entire process, the new system should enable chapters to spend less time recordkeeping and more time using their records to make better decisions and further the organization.
展开▼
