1 / 21

Database Technology and Church Management

Database Technology and Church Management. MSCM 8630 IT for Church Management Dr. Wagner October 2, 2008. This week in class…. Two on-line sessions this week Thursday night 7:30 p.m. EST Tuesday morning 9:30-10:30 EST (repeat session) Continue reading Chapter 4 in Welch book

zulema
Télécharger la présentation

Database Technology and Church Management

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Database Technology and Church Management MSCM 8630 IT for Church Management Dr. Wagner October 2, 2008

  2. This week in class… Two on-line sessions this week Thursday night 7:30 p.m. EST Tuesday morning 9:30-10:30 EST (repeat session) Continue reading Chapter 4 in Welch book Go over articles from CC magazine Start discussing database technology Review the details of the second assignment Do Access (or other Database package) tutorials in Element K as needed

  3. Questions about class so far?

  4. The Church IT Director (article) Shows growth in role of IT in churches IT budgets Using some outside vendors Church IT Directors not aware of resources journals CMS user groups Special software and hardware discounts www.1computerbargains.com, Dell Grassroots network of blogs http://jpowell.blogs.com Challenges?

  5. The Virtual World Dawning (article) • How are virtual environments transforming churches? • Multi-site distributed model • 47 of 100 fastest growing churches use this (?) • Church sites can be anywhere • Non-threatening, easy access, collaborate across time zones • Movement from push to pull communication model • TIVO, iPod, Youtube • On-line digital libraries? • Security issues? Worlds interacting? • IBM and Cisco experiment with virtual buildings for team meetings • People tend to mingle after meetings • Discussion groups form spontaneously

  6. The Virtual World Dawning (cont.) • Virtual World Technologies • Forterra Systems software • Qwaq hosting (now virtualworldsmanagement) • Virtual confession booth • Virtual cemeteries http://www.worldgardens.com/ • http://www.virtualchurch.org • Life Church Purchases 16 acres in Second Life • 6 million Google searches by spiritual searchers each day (?) • Advantages for churches? • Anonymous, opportunity to explore, funnel into church, build a global presence?

  7. Database Technology Why is this important? What are the basics? Look at some examples Practice in Access

  8. Why manage data? • Changing view of data • Higher costs of lost data • Encouragement of “team problem-solving” • Flexible reporting • Integrating it into decision-making better

  9. What kind of data do churches manage? • What is structured data? • What is unstructured data?

  10. What kind of data do churches manage? • Sermons, research prep • Letters, email – internal and external • Databases • Member lists, contacts, contributions, baptisms, attendance • Problems with multiple databases • Multimedia files – photos, videos, audio, bulletins • Governance docs – minutes, agendas, meeting notices • Custom templates, programs, etc.

  11. Data Management Tasks Common tasks for databases include: • designing the database structure • entering the data • updating data by adding, changing, or deleting • sorting the data • searching through the data for a record or group of records • obtaining screen or printed output

  12. Why not just use spreadsheets?

  13. Why not just use spreadsheets? • Redundancy • Duplication of data or the storing of the same data in more than one place • Difficulty accessing data • Lack of powerful query capabilities • Limited security • Size limitations

  14. Approaches to Data Management include: • Custom Program Approach • File Processing System Approach • Database Management System Approach

  15. Operating System Database Management System Application Programs Database Management Databases Data Dictionary Database Management Systems

  16. External Databases Database Server End User Workstation Distributed Databases Operational Databases End User Databases Data Warehouse Databases Analytical Databases Major Types of Databases

  17. Database Management Systems • Program(s) through which users interact with database • Popular DBMSs include • Access • Filemaker Pro • Oracle • DB2 • SQL Server

  18. Employee Record 1 Employee Record 2 Employee Record 3 Employee Record 4 Name SS Salary Name SS Salary Name SS Salary Name SS Salary Data Data Data Data Data Data Data Data Data Data Data Data Logical Data Elements Personnel Database Payroll File Benefits File

  19. Let’s try some database practice MS Access 2003 You can also get to a version of this by going to https://citrixweb.villanova.edu Login with VU userID and PW Navigate to “General Applications” folder You should see both Office 2003 and Office 2007

  20. Assignment for next week Finish spreadsheet assignment Start using the Access tutorials on Element K (if necessary) Start thinking of project ideas

  21. Questions?

More Related