volunteer database
Database Development
Initially, the Vista member focused on database development to increase the technological capacity and efficiency of El Centro de la Raza (ECLR). Starting from scratch, Mr. Moore was able to build a centralized demographics database based primarily on Microsoft Access. In order to accomplish this, he needed to analyze previous systems utilized by staff, troubleshoot, and develop solutions to migrate the infrastructure in a manner that staff could utilize effectively. After completing this task, he completed a manual detailing usage and offered informal trainings to staff. The Vista member was also asked to update other databases (donor, volunteer, and grant tracker databases) in order to improve the tracking and reporting capacity of staff. Mr. Moore was also asked to monitored the server, install standard organizational computer configurations, update other technological systems, assist with events, and other software duties as necessary.
Throughout the service year, Mr. Moore showed a great deal of flexibility by taking on new tasks and meeting agency needs as well as those specifically involving the databases. He also showed his development capability by increasing the effectiveness of our databases, and helping our staff increase their reporting accuracy. Mr. Moore’s efforts led to the following successes:
1. Developed a new centralized demographics database to prevent duplication in reporting to major funders,
2. Increased the efficiency of the donor database,
3. Increased the accuracy of the grant tracker database,
4. Increased the accuracy and usability of the volunteer database,
5. Began to rebuild ECLR’s homepage,
6. Helped fulfill ECLR’s server needs in the absence of a part-time IT Manager,
7. Helped to install standard software packages on new ECLR hardware, and
8. Assisted staff with Microsoft Office problems.
Mike Moore came to El Centro de la Raza expecting to primarily customize an existing system, migrate data, tutor users and monitor data input. However, by the end of the first week, our staff realized his experience and capabilities were well suited for so much more. Mike quickly realized that the database El Centro proposed to utilize was difficult to tailor to our needs. Compounding the problem was an IT Staff that was difficult to reach and slow to respond. Mike projected that this customization and full utilization process would take close to the entire year simply to implement, no less train staff and begin to migrate data. This was time that our agency did not have, as major funders pressed us to improve our accuracy and develop unduplicated counts of individuals served. Mike recognized the immediacy of our needs, and proposed to build a database specifically customized to track demographic data in a format we could fully utilize. Working alongside staff members from a number of different departments, Mike noted each person’s need and a series of solutions to maximize the database’s efficiency and usability. On top of accomplishing other tasks associated with his placement (tutoring and modifying other databases), Mr. Moore was able to complete a workable system in just under five months. This left plenty of time to migrate data to the system and meet all of our deadlines.
"Star Center" Database Builder
Mr. Barker’s project is designed to expand the STAR Center’s capacity by creating a system for electronic storage of client files and implement these plans and procedures with the use of volunteers.
Mr. Barker has assisted with the development for electronic storage of client files, successfully scanned the entire contents of 75% of our client files, and provided electronic access to the files increasing staff efficiency by making information more available. This access has changed the process of checking out files to the simple click of a button.
CTC Outreach and Database Management
Shirl completed her year of service in November 2002 and extended service through January 2003.
Shirl assisted the president of the CTCNet board of directors (Erroll Reese, Durham, NC) with CTCNet program development and capacity building. She helped coordinate activities with national conference and meetings and followup with local leaders.
In addition, Shirl developed a PC Access database for RTPnet. The database consists of information gathered from an online form, http://www.rtpnet.org/rtpnet/vol.html The database allows us to find volunteers with skills that meet current needs and it allows us to keep information about volunteers current. The database contains about 50 entries.
CTC Outreach
C-CAN is a network of partner CTCs that was designed to provide resources and assistance to each other: Jeff’s job has been to organize these CTCs and provide start-up resources to seed the development of this collaborative. The success of Jeff’s work has resulted in increased activity and the development of formal collaborations between partners, and Jeff will report on this activity in the coming months.
Goal 1: Help local CTCs build capacity and increase usership through increased volunteer recruitment and better staff management of volunteers.
Goal 2: Increase community participation at CTC networking activities and at workshops.
Goal 3: : Ensure that the work of the C-CAN will continue after the AmeriCorps*VISTA members leave.
Goal 1: The project has accomplished its major goals for 2002 already, in the recruitment of over 170 local volunteers for CTCs in our network and setting up CompuMentor volunteer management training for CTC staff.
Goal 2: Increased attendance at Quarterly meetings and annual conference from last years’ numbers, signed up 20+ attendees for CompuMentor training.
Goal 3: Working with members from local CTCs to encourage committee work and leadership within the C-CAN.
C-CAN’s AmeriCorps/ VISTA members have finished work on development of our main project: The Volunteer Hub. This project required finalizing the database of local CTCs, contracting them to review their data, and training them in use of the online volunteer database and volunteer opportunities directory
Jeff Streier has concentrated on working with organizations to prepare them for using the Hub, Heidi Marshall has focused on recruitment of volunteers. Both Members staffed a booth at the MN State Fair in late August of 2002 for 10 days.
In addition to work on the volunteer management and recruitment projects, both Members helped to organize the second annual Twin Cities Community Technology Conference, which attracted over 75 participants. The Mayor of Minneapolis, R.T. Ryback, was on hand to deliver the keynote speech, and was so impressed by what the community is doing in terms of CTC activity that C-CAN was invited to a series of meetings at the Mayors’ Office.
These meetings have resulted in the development of a new Community Technology Task Force, featuring participation by local government, industry, and non-profit technology providers. The focus of this task force is to develop a City agenda for improving “Digital Opportunity” for residents of the City of Minneapolis. Another outcome of this partnership is that C-CAN and the City of Minneapolis have just submitted a proposal for a cluster of 25 new AmeriCorps members to serve in local CTC projects.
CTC Program Building
She has done a significant amount of development on our database and system for tracking participants and volunteers. She has also helped coordinate our curriculum development for our classes.
Katie has now organized and put curriculum materials for over 20 classes on the Web. These classes range from Introduction to Computer to Certification classes. Katie has also developed a system for us to track donations and give receipts to individuals. She has also been helping to set up accounting for TechMission, Inc. In all of this, Katie has done an outstanding job of documenting her processes for others to take over.
Katie has also finished development on our database and system for tracking participants and volunteers. She developed reports which allow us to monitor how participants are progressing through programs. In addition, she has developed over 20 pages of documentation for her position for someone else to take over. She has been training another staff person to take over many of her duties.
Katie has also helped coordinate our curriculum development for our classes. She has now organized and put curriculum materials for over 20 classes on the Web. These classes range from Introduction to Computer to Certification classes. Katie has also developed a system for us to track donations and give receipts to individuals. She has also been helping to set up accounting for TechMission, Inc. In all of this, Katie has done an outstanding job of documenting her processes for others to take over.
Outreach and Volunteer Coordinator
AmeriCorps/ VISTA member Heidi Marshall finished development work on the C-CAN Volunteer Hub project as well as work on a new initiative: developing a “technical assessment” report that local CTCs might use as a model.
The Volunteer Hub project required finalizing the database of local CTCs, contracting them to review their data, and training them in use of the online volunteer database and volunteer opportunities directory (www.c-can.org). In the course of this project, Heidi focused on recruitment of volunteers. To date, volunteers have been matched to 12 programs around the city, and several more are scheduled to come on board this coming fall of 2003.
In addition to recruiting and managing volunteers, Heidi has been very involved with local colleges and the University of Minnesota regarding placement of student interns within area CTCs. Heidi attended many meetings in the course of this project, and as a result, C-CAN was one of only a few, select non-profit organizations the U of Minnesota chose as partners for their community outreach program, a program that places undergraduates in social service agencies as part of course work.
This groundwork has helped us to develop a sustainable network of volunteers for local CTCs that will serve the community even after our AmeriCorps*VISTA members finish their service later this year.
Since February of 2003, Heidi has organized and facilitated two quarterly and one annual meeting for local CTCs, working with other national organizations to provide resources to our local CTC partners. As a result of her outreach work, 25 local CTC leaders and advocates, and a representative from CTC/national (Felicia Sullivan) made a presentation at our annual conference in September.
Heidi finished work with a local community agency (Pillsbury United Communities; see attached) to develop and implement a “technical assessment” project that will serve as a model for other organizations that have asked for assistance with assessments.
The success of Heidi’s service year has resulted in increased activity and the development of formal collaborations between partners, the public and our organization, and the development of a sustainable online volunteer matching service.