校務研究資料庫的建構與分析應用

Research output: Contribution to journalArticle

1 Citation (Scopus)

Abstract

This article elaborates on the possible best practice of developing databases for institutional research and analysis, based on the knowledge of Educational Science, Library Science, and Information Engineering, years of experience in developing educational databases, and a recent survey of related technology and products. Several developing options are compared to show their benefits and disadvantages under different conditions. Three representative analysis tasks are reported to verify and show the synergy of the mentioned ideas and experience. In particular, this article proposes a sustainable workflow: (1) data collection and aggregation, (2) cataloguing, (3) regulation, (4) archiving, and (5) usage, and describes their must-known caveats. The application situations of data normalization and de-normalization are described. Capability of domestic vendors of related products is briefly mentioned based on a proof-ofconcept testing. And finally, real-world institutional analyses are conducted to share our experience. Overall, the first four processes in the above workflow are most timeconsuming and costly. Once data have been well prepared, recent visualization analysis tools allow users to easily discover meaningful patterns and inspire hypotheses, and allow them to explore the database to find evidence to support their hypotheses and decisions. In the future, we expect that event evolution simulation techniques, which allow users to foresee the results given various input scenarios, could play an important role in educational data analysis, in addition to the maturing data visualization tools.

Original languageEnglish
Pages (from-to)107-134
Number of pages28
JournalContemporary Educational Research Quarterly
Volume24
Issue number1
DOIs
Publication statusPublished - 2016 Mar 30

Fingerprint

workflow
normalization
visualization
experience
synergy
science
aggregation
best practice
data analysis
engineering
scenario
regulation
simulation
event
evidence

Keywords

  • Data consistency
  • Data literacy
  • Data normalization
  • Data warehouse
  • Visualization analysis

ASJC Scopus subject areas

  • Education

Cite this

校務研究資料庫的建構與分析應用. / Tseng, Yuen-Hsien.

In: Contemporary Educational Research Quarterly, Vol. 24, No. 1, 30.03.2016, p. 107-134.

Research output: Contribution to journalArticle

@article{418b5beeca8a42edbb23ed4eaec664af,
title = "校務研究資料庫的建構與分析應用",
abstract = "This article elaborates on the possible best practice of developing databases for institutional research and analysis, based on the knowledge of Educational Science, Library Science, and Information Engineering, years of experience in developing educational databases, and a recent survey of related technology and products. Several developing options are compared to show their benefits and disadvantages under different conditions. Three representative analysis tasks are reported to verify and show the synergy of the mentioned ideas and experience. In particular, this article proposes a sustainable workflow: (1) data collection and aggregation, (2) cataloguing, (3) regulation, (4) archiving, and (5) usage, and describes their must-known caveats. The application situations of data normalization and de-normalization are described. Capability of domestic vendors of related products is briefly mentioned based on a proof-ofconcept testing. And finally, real-world institutional analyses are conducted to share our experience. Overall, the first four processes in the above workflow are most timeconsuming and costly. Once data have been well prepared, recent visualization analysis tools allow users to easily discover meaningful patterns and inspire hypotheses, and allow them to explore the database to find evidence to support their hypotheses and decisions. In the future, we expect that event evolution simulation techniques, which allow users to foresee the results given various input scenarios, could play an important role in educational data analysis, in addition to the maturing data visualization tools.",
keywords = "Data consistency, Data literacy, Data normalization, Data warehouse, Visualization analysis",
author = "Yuen-Hsien Tseng",
year = "2016",
month = "3",
day = "30",
doi = "10.6151/CERQ.2016.2401.04",
language = "English",
volume = "24",
pages = "107--134",
journal = "Contemporary Educational Research Quarterly",
issn = "1814-4810",
publisher = "國立台灣師範大學教育研究與評鑑中心",
number = "1",

}

TY - JOUR

T1 - 校務研究資料庫的建構與分析應用

AU - Tseng, Yuen-Hsien

PY - 2016/3/30

Y1 - 2016/3/30

N2 - This article elaborates on the possible best practice of developing databases for institutional research and analysis, based on the knowledge of Educational Science, Library Science, and Information Engineering, years of experience in developing educational databases, and a recent survey of related technology and products. Several developing options are compared to show their benefits and disadvantages under different conditions. Three representative analysis tasks are reported to verify and show the synergy of the mentioned ideas and experience. In particular, this article proposes a sustainable workflow: (1) data collection and aggregation, (2) cataloguing, (3) regulation, (4) archiving, and (5) usage, and describes their must-known caveats. The application situations of data normalization and de-normalization are described. Capability of domestic vendors of related products is briefly mentioned based on a proof-ofconcept testing. And finally, real-world institutional analyses are conducted to share our experience. Overall, the first four processes in the above workflow are most timeconsuming and costly. Once data have been well prepared, recent visualization analysis tools allow users to easily discover meaningful patterns and inspire hypotheses, and allow them to explore the database to find evidence to support their hypotheses and decisions. In the future, we expect that event evolution simulation techniques, which allow users to foresee the results given various input scenarios, could play an important role in educational data analysis, in addition to the maturing data visualization tools.

AB - This article elaborates on the possible best practice of developing databases for institutional research and analysis, based on the knowledge of Educational Science, Library Science, and Information Engineering, years of experience in developing educational databases, and a recent survey of related technology and products. Several developing options are compared to show their benefits and disadvantages under different conditions. Three representative analysis tasks are reported to verify and show the synergy of the mentioned ideas and experience. In particular, this article proposes a sustainable workflow: (1) data collection and aggregation, (2) cataloguing, (3) regulation, (4) archiving, and (5) usage, and describes their must-known caveats. The application situations of data normalization and de-normalization are described. Capability of domestic vendors of related products is briefly mentioned based on a proof-ofconcept testing. And finally, real-world institutional analyses are conducted to share our experience. Overall, the first four processes in the above workflow are most timeconsuming and costly. Once data have been well prepared, recent visualization analysis tools allow users to easily discover meaningful patterns and inspire hypotheses, and allow them to explore the database to find evidence to support their hypotheses and decisions. In the future, we expect that event evolution simulation techniques, which allow users to foresee the results given various input scenarios, could play an important role in educational data analysis, in addition to the maturing data visualization tools.

KW - Data consistency

KW - Data literacy

KW - Data normalization

KW - Data warehouse

KW - Visualization analysis

UR - http://www.scopus.com/inward/record.url?scp=85002582835&partnerID=8YFLogxK

UR - http://www.scopus.com/inward/citedby.url?scp=85002582835&partnerID=8YFLogxK

U2 - 10.6151/CERQ.2016.2401.04

DO - 10.6151/CERQ.2016.2401.04

M3 - Article

AN - SCOPUS:85002582835

VL - 24

SP - 107

EP - 134

JO - Contemporary Educational Research Quarterly

JF - Contemporary Educational Research Quarterly

SN - 1814-4810

IS - 1

ER -