140 likes | 206 Views
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
E N D
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 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…
Caroline Beatty Jim Brady Felicia Hedgepeth Joe Croteau John Burger Let’s look at some PPT presentations…
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
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
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?
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
More spreadsheet features… • Standard functions • Inputting formulas • Formatting worksheet • Printing worksheets • Renaming tabs • Copy, paste, insert, and delete cells • Absolute vs. relate cell addresses
More spreadsheet features • Docking toolbars • Hide and unhide cells • IF function for a logical test • Payment function • Adding a system date • Collaboration tools
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.
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