Differences

This shows you the differences between two versions of the page.

--- emis_user_manual [2023/10/27 16:16] – [Professional Data Publications] ghachey
+++ emis_user_manual [2024/03/28 00:33] (current) – [School Accreditation Dashboard] ghachey
@@ Line 777: / Line 777: @@
 ==== School Accreditation Dashboard ====
-This is where you can get some live data analytics just like every other module in the EMIS. You access just like other dashboard, Click on ''School Accreditation -> Dashboard''
+This is where you can get some live data analytics just like every other module in the EMIS. You access just like other dashboard, Click on ''School Accreditation -> Dashboard''.
+<note important>In order for the dashboard to contain data from the most recently approved and uploaded cloudfiles, the EMIS warehouse has to be regenerated.</note>
 {{ :user-manual:school-accreditation-dashboard-1.png |}}
@@ Line 1180: / Line 1182: @@
 ===== Data Operations =====
+==== Annual Census Data Transfer ====
+The Pacific EMIS supports a number of ways to transfer data from schools to a centralized database. They have varying degrees of maturity and complexity of user adoption. They are summarized in the below table.
+^ Method      ^ Description       ^ Maturity          ^ User Adoption Complexity ^
+| PDF Survey    | A comprehensive survey of data with the majority of it in aggregate format containing enough for the main key performance indicators     | Very mature       | Easy       |
+| Excel Workbook    | A comprehensive survey of data with support for individual rosters and richer data containing enough for the main key performance indicators and more. Built on widely used spreadsheet (Excel)     | Very mature       | Moderate       |
+| Student Information System (SIS)    | The highest form of data management within the schools then pushed to the centralized system. An online web-based student information system meant for daily use by schools.     | On-going development       | Difficult       |
 ==== Upload PDF Survey ====
@@ Line 1195: / Line 1208: @@
 {{ :user-manual:pdf-survey-upload.png?nolink |}}
-==== Upload Workbook Census ====
+==== Upload Excel Workbook ====
 <note important>This documentation below is strictly how to load a Annual School Census Workbook into the EMIS. Information on how to use the workbook itself is documented in [[annual_school_census_workbook_user_manual|Annual School Census Workbook User Manual]]</note>
@@ Line 1420: / Line 1433: @@
 Further notes on the Flexible Excel/Word Reports type of reporting. We have a combination of tools (e.g. [[data_publishers_toolkit|Data Publishing Toolkit]], [[multi-part_word_documents|Multi-part Word Document]]) and practices for publishing data into Excel tables and pivot tables. This forms the basis for the construction of documents such as Annual Statistics Digest, etc. These connection are direct connections to SQL Server using Excel’s OLEDB capacity. It is possible to establish SQL connections across the WAN, but this entails some careful security setup to allows users through a firewall to reach the SQL Server. In particular, a "read only" user. In order to support users who do not have access to SQL (i.e. either across their LAN, or across the WAN) to access data in Excel we are building support for new options. This would allow more options for remote hosting, and also for a broader set of users to have access to Excel.
-The three available planned options are available in various levels of maturity
+The three planned options are available in various levels of maturity and the table below shows the comparative strength and weaknesses of the 3 approaches:
 ^ Mode 	^ Connection 	^ Refreshable? 	^ Flexibility 	^ Distribution ^ Maturity ^
@@ Line 1441: / Line 1454: @@
 Power query extends Excel’s ability to access data from relational sources with the ability to extract, transform and load data from a wide variety of sources including http rest end points.
 ‌
-=== Dynamic Workbooks ===
+==== Dynamic Workbooks ====
 Currently this design is prototyped:
@@ Line 1467: / Line 1480: @@
 </code>‌
-This table shows the comparative strength and weaknesses of the 3 approaches:
+====== Public Data Dissemination ======
+Aside from data about individuals, just about all other data benefits from being public for a number of reasons:
+  * **Transparency and Accountability**: Open data fosters transparency, holding organizations and governments accountable.
+  * **Innovation and Collaboration**: Public data fuels innovation, enabling collaboration among researchers, entrepreneurs, and developers.
+  * **Informed Decision-Making**: Accessible data empowers individuals and organizations for better decision-making.
+  * **Citizen Engagement**: Open data encourages citizen participation and engagement in public affairs.
+  * **Economic Growth**: Data availability stimulates economic growth, fostering entrepreneurship and creating jobs.
+  * **Research Advancement**: Open data accelerates research and scientific discoveries across various fields.
+  * **Public Services Improvement**: Governments utilize open data to enhance public services and address societal challenges.
+  * **Cross-Sector Collaboration**: Open data facilitates collaboration between sectors to address complex issues.
+  * **Community Empowerment**: Open data enables communities to address local challenges and actively participate in development.
+  * **Accountable Governance**: Open data supports accountable governance, allowing citizens to monitor government activities and foster trust.
+The Pacific EMIS supports a number of ways to disseminate data in a timely manner that KEMIS does not yet fully adopt. They are summarized in the table below:
+^ Method ^ Description ^ Time to Access ^ Access Difficulty ^
+| Publications | Often the most official and slowly curated sources of data. | Longest time. Requires more efforts in collecting, validating, preparing and publishing and can come sometime years after. | Easy. Typically through downloadable PDF documents. |
+| Mobile App | Download all data and view analysis on your phone. | Fast. New data immediately available. | Easy. Download the Pacific Open Education Data app on your Android or iPhone |
+| Public Login | The web application supports a public login to view all dashboards and download excel data exports. | Fast. New data immediately available. | Easy. Login the country EMIS public profile from login page. |
+| REST API | Access the raw data through special web requests in formats such as JSON and XML. | Fast. New data immediately available. | Difficult. Typically used by developers or researching with programming skills |
+A word of caution. The pacific island countries faces unique challenges making it hard to continuously improve the quality of data. Accessing the data any of the fast methods has the caveat that it has had less time for scrutiny and possible remediation. So it should always be used with care and we always appreciate any apparent issue brought to our attention so we can work to fix them.
+Each of these methods will have a sub-sections here with additional documentation.
 ===== References =====