220 likes | 253 Views
SECRETARIAT OF THE PACIFIC COMMUNITY REGIONAL MEETING OF HEADS OF PLANNING AND HEADS OF STATISTICS (HOPS) (Noumea, New Caledonia, 12-16 July 2010) Data Dissemination Day 5 James Hemphill Web Developer/Data Dissemination Specialist Statistics and Demography Programme.
E N D
SECRETARIAT OF THE PACIFIC COMMUNITY REGIONAL MEETING OF HEADS OF PLANNING AND HEADS OF STATISTICS (HOPS) (Noumea, New Caledonia, 12-16 July 2010) Data Dissemination Day 5 James Hemphill Web Developer/Data Dissemination Specialist Statistics and Demography Programme 5.1 – DATA ACCESSIBILITY 5.2 - Data Quality 5.3 - Data Dissemination
Data Quality July 16th10.00 – 12.00Session 5.2 Pacific DATA QUALITY PRISM Redevelopment Plans for 2010 and Beyond TABLE-BUILDER INTRO Beyond2020 – Mark Feary Redatam – Alehandra French Polynesia
Data Accessibility July 16th10.00 – 10.45Session 5.2a Pacific DATA ACCESSIBILITY 3 Quotes of the Original Purposeof PRISM • “The concept of PRISM is, simply, to give NSOs the tools and the skills to develop, publish and maintain their own Internet websites containing key statistical indicators, statistical summaries, reports, concepts definitions and other documentation for the statistical indicators”. • “Benefits are an improved data dissemination service, more responsive to user needs, and a higher profile, reduced workload, and improved access to data for the NSOs”. • “to contribute to better informed policy and decision making in the Pacific region in order to reduce poverty in the Pacific Island countries and territories (PICTs)”.
Data Accessibility July 16th10.00 – 10.45Session 5.2a • A short history of PRISM • From 2002 to September 2004 the project was funded by DFID. This first phase was very successful with PRISM leading to 14 NSOs publishing Internet websites, bringing the number of NSOs in the region with websites to 19. • Funding was then taken over by AusAID which allowed the project to continue to September 2007. During this phase, further improvements and enhancements have been achieved to NSO websites through the training and technical assistance activities of the PRISM Manager, complemented by other Statistics Programme activities. • Support for the ongoing third phase has been provided by SPC to fund the PRISM Manager (Raymond Vuti) position to update the SPC PRISM website and the regional information system. With Raymond’s departure, the position of ‘PRISM Manager’ is no more, with James taking up the responsibilities of PRISM as the new ‘Web Developer/Data Dissemination Specialist’
Data Accessibility July 16th10.00 – 10.45Session 5.2a PRISM and its Evolving Role Original Role Set up NSO websites Provide training in Frontpage 2003 Develop regional tables Publish regional tables on PRISM Collate publications Ongoing and Future Role Enhance existing websites Provide training in CMS Quality checks on regional tables Increase functionality for dissemination
3 Main Objectives for PRISM 2010: Information Gathering and PRISM Healthcheck 1. Maintain and build strong relationships with the PICTs and SPC Programmes, to ensure maximum involvement with the Project, and timely collection/delivery of accurate data. 2. To construct a robust centralized database with standardized schemas, from which users can pull custom information in a variety of formats. 3. Focus on PRISM usability and design, to allow users to access information with minimal training. Use of a modern CMS such Joomla, Drouple, Wordpress or DotNetNuke… Training Schedule and Release Program
1. Maintain and build Strong Relationships by: • Regular email contact with PRISM Development News , and regular invitations for feedback. • Ensuring an efficient methodology is in place for collection and delivery of the core and non-core indicators. • Developing and maintaining verbal and in-person relationships wherever possible. Forums (e.g. PACPRISM) Social Networks Steering Groups SPC Section Meetings Progress Reports Involve as many specialists as possible to add value to the data and enable us to not only provide data but also to advise on usability
2. Centralization of Data. • The proposition is to have a database hosted at SPC to which other countries feed into via standard schemas and formats • Countries can still take snapshots so they can work with local data • Centralization will provide flexibility for multiple front-ends to be developed (websites, applications, etc.etc.) from the same data • Missing data can be tracked via alerts • Improve data reliability and accuracy • Improve overall trust of PRISM Database Design Normalization Clear Schema Requirements Include Spatial Data Backups and Security
2. Construct a robust centralized database: PRISM DB to WEB NSO Website NSO Website NSO Website NSO Website PRISM WEBSITE Text/CSV Files PDF Reports Data Visualization and File Downloads Charts and Graphs Charts and Graphs MetaData/MicroData Publications and Articles PRISM DB NSO DB NSO DB NSO DB NSO DB NSO Standard Data Input
3. Increase PRISM Usability and Design by: • Introducing some or all of the following: • Map Driven Interface • Customizable Look-and-Feel • Simplified Menu Bar • Multiple export formats • Interactive Bar Charts and Tables of Info • Use of Imagery/Photography • Option to Register and receive PRISM/SDP update emails • Analyzing PRISM workflows – ensuring these are supported by Design
Design Inspiration 1: Use of Map Navigation http://planet-connect.org/internship-colunteer/map Other Examples: http://apps.nowwhere.com.au/StatsNZ/Maps/default.aspx http://www.newcaledonia.com.au/discover/map/
Design Inspiration 2: Use of clear panels and Photography http://www.dfid.gov.uk/
Design Inspiration 3: Use of clear panels and Photography http://www.oxfam.org/
Design Inspiration 4: Use of clear panels and Photography http://www.worldpulse.com/
Design Inspiration 5: United Nations http://www.unric.org
What is Joomla and why use it? • Joomla helps you build your own website • Joomla is: • An open-source content management system • Easy to use, flexible and secure • Free! • Widely used • You have complete control over content
What’s a contentmanagement system (CMS)? • Like a library – manages information on your website • Can store everything – data, photos, articles, videos… • You choose if/when you want information to appear on your site • Can define who can edit/add/access information via user roles DotNetNuke Drupal JOOMLA! Wordpress
Who uses Joomla? • The United Nations www.unric.org • Governments http://oman.org.au http://www.kalselprov.go.id • Universitieshttp://www.lincoln.ox.ac.uk/ • Organisationshttp://www.refedd.org/ • Businesshttp://www.mitsubishi.pl/ http://www.epicier-bio.fr/ • The SPC http://www.spc.int/
Action! Develop and Publish a Fresh Web Banner to show clear contact Information Publish ‘a few’ RECENT publications and/or reports And some ‘latest news’ items Use this Initial Contact as a spring-board for dealing with switching to Joomla, country data gaps, and training
?Table Builder? Custom Results Control Large Datasets Cross Tabulation
Data Accessibility July 16th10.45 – 11.00Session 5.2b Table Builder – 3 Examples Laurent Pellet, French Polynesia