1 / 14

Church Mgt and Report Generation

Church Mgt and Report Generation. MSCM 8630 IT for Church Management Dr. Wagner Sept. 25, 2008. 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 Articles from CC magazine

Download Presentation

Church Mgt and Report Generation

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. Church Mgt and Report Generation MSCM 8630 IT for Church Management Dr. Wagner Sept. 25, 2008

  2. 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 Articles from CC magazine Finish talking about spreadsheets and reporting Review the details of the second assignment Do Excel tutorials in Element K as needed This week in class…

  3. Questions about class so far?

  4. Caroline Beatty Jim Brady Felicia Hedgepeth Joe Croteau John Burger Let’s look at some PPT presentations…

  5. IT and Church Mgt in a Bad Economy • Can IT make a difference? • Effect of higher gas prices? • $3000/year in gas costs to drive to church? • ChurchRides.com • $15/month? • Small Group Mgt • Support for home meetings uroomtech.com • Member networking sites mychurch.com, myflock.com • Sales of smart phones keep rising • Online giving? • IM vs. email

  6. Portable, free, hassle free? Not necessarily for primary repository Security issues? Save local drives? Platform agnostic? At least 1 GB free Box.net – recipient of files must register Xdrive.com – AOL, 5 GB free; desktop tool eSnips.com – social networking + storage Dropboks.com – secure; file size capped at 50MB Mediamax.com – 25 GB free!! (now closed) On-line Storage for Churches

  7. Mac vs Windows compatibility tools? Export feature Save as feature Save as a .pdf file? Version issues? Problems with obscure fonts File compression Winzip common utility in Windows world File conversion issues/utilities?

  8. Review of Spreadsheet features • Entering and formatting text and numbers • Sizing columns and row • Centering text with Merge & Center • Use autosum • Format worksheet with autoformat • Created 3-D column chart

  9. More spreadsheet features… • Standard functions • Inputting formulas • Formatting worksheet • Printing worksheets • Renaming tabs • Copy, paste, insert, and delete cells • Absolute vs. relate cell addresses

  10. More spreadsheet features • Docking toolbars • Hide and unhide cells • IF function for a logical test • Payment function • Adding a system date • Collaboration tools

  11. What are some typical documents? Accounting – GL, costs, budgets, payroll, fund accounting, AP/AR, direct deposit Church Mgt – member tracking, groups, contributions, contacts, events, phone trees, volunteers Facility scheduling – church calendar mgt, event planning, building schedule, maintenance, weekly bulletin, holidays Miscellaneous – list mgt, certificates, class mgt, name tags, email notifications, etc.

  12. Let’s try some spreadsheet practice

  13. Assignment for next week • Read chapter 4 of Welch book • Practice using the Excel tutorials on Element K (if necessary) • Work on assignment 2 • Choose a sample report you might encounter • Enter and format sample data, headings • Use formulas and create a chart • Show formulas and chart on separate, named tab

  14. Questions?

More Related