Syllabus

Schedule [PDF]

Week Date Topic Activities Readings / Handout
Module 1: Fundamentals of science data and data management
1 Jan 12 Introduction to the course pre-course assessment survery Carlson, S. (2006)
Guterman, L. (2001) a b
Howe, D. (2008)
Jan 14 Science data life cycle: collect, store, retrieve, use, present Anderson, W.L (2004)

How to identify datasets on the Web and Exercise 1 reqiurements

2 Jan 19 Martin Luther King, Jr. Day. No Class
Jan 21 Introduction to database, database programs and data attributes Rob, P. and Coronel, C. (2004), chapter 1, pp. 6-25, chapter 2, pp. 30-65, chapter 3, pp. 76-109

iLMS (WebCT): Example of data sets in relational database

3 Jan 26 Data relationships Due: Exercise 1, Identifying datasets

In class presentation: Share your informaion analysis of data repository / dataset

NSF (2007)

Cleaveland, J. C (1986), chapter 1

Scheiner, S. M. (2004), chapter 3

Jan 28 Fundamentals about data: forms, scales, types, levels

Data structures and modls: physical data, model data

In class presentations: Share your informaion analysis of data repository / dataset

Quiz 1: Data and database fundamentals

NSB (2005), chapter 2, 3

Brooks (1984), chapter 2

Lab: Design a database

4 Feb 2 Data formats: Data format standards, representation of data, communication of data markup languages and meta formats Abiteboul, S., Buneman, et al. (2000), chapter 2: A Syntax for Data, chapter 3: XML, Data on the Web
Feb 4 Describing datasets (1): Introduction to metadata: aboutness, types, elements, schemes, standards In class group work: investigate CSDGM profiles

Due: Exercise 2: Database design

Zeng,M.L, Qin,J. (2008), chapter 1

Caplan,P. (2003), chapter 14

McGlamery,P. (2004), chapter 13

5 Feb 9 Describing datasets (2): Metadata’s role in resource management Zeng,M.L, Qin,J. (2008), chapter 3, 4
Feb 11 Describing datasets (3): Metadata elements in schemes, tools

Case study

In class group work: form use for data description Hillmann,D.I., Westbrooks,E.L. (2004)

Hill, Janee, chapter 8

Arms, Arms, chapter 14

6 Feb 16 Describing datasets (4): Relationship-making and relational database lab In class work: Describe dataset and create and extension Bose,R., Frew,J. (2005)
Feb 18 Managing data (1): Encoding, storage, import / export, cleaning, transformation Due: Exercise 1 & 2 revision: 1 2

Quiz: Data formats and description (Thursday-Friday)

Gleason,D. (1007), chapter 13: Data Transformation

NRC (1995), chapter 2: Preservation and Use

7 Feb 23 Managing data (2): Data querying and retrieval

SQL Lab

Practice with SQL statements and data reports Rob,P., Coronel,C. (2004), chapter 6, pp. 226-316
Feb 25 Managing data (3): Ownership and access, data quality Statistics Canada (2001)

Dasu,T., Johnson,J. (2003), chapter 4, pp. 99-137

Learning module 2: Managing data in aggrgation
8 Mar 2 Managing data (4): Applying XML to data and metadata Exercise 3: Querying data and metadata Goldfarb,C.F., Prescod,P. (2000), chapter 53, 59, 62
Mar 4 Data aggregation scenario (1): Research collection Guest speaker Muller,R.J. (1999), chapter 3: Gathering Requirements
Spring break. No Class
9 Mar 16 Managing aggregation scenario (2): Reference collection Guest speaker Karasti,H., Baker,K.S et al. (2007)

Muller,R.J. (1999), chapter 4: Modeling Requirements with use Cases

Mar 18 Managing aggregation scenario (3): Resource collection Guest speaker

Due: Exercise 4: XML for metadata and data records

Parsons,M.A, Duerr,M. (2005)

Morris,S.P., Tuttle,J. (2007)

10 Mar 23 Data and usrs (1): Requirements interviewing faculty about data management needs and practices analysis

Data and usrs (2): Dataset charateristic analysis, needs assessment

Group report 1: Data and users Muller,R.J. (1999), chapter 6
Mar 25 Data and usrs (3): Case study In class group work Case handouts to be delivered in class
11 Mar 30 Organizational planning (1): Goals and objectives, procedures, quality control Muller,R.J. (1999), chapter 7
Apr 1 Organizational planning (2): Metadata issues, long-term preservation eport to class findings from interviews Gray,J., Liu,D.T. et al. (2005
Learning module 3: Broader issues in science data management
12 Apr 6 Enabling technologies: Organizing and managing data, stroing and retriving, using data Group report 2 on interview result
Apr 8 Understanding data curation: Metadata description, quality criteria, archival concepts
13 Apr 13 Data repositories and discovery: Directory services, controlled vocabularies Quiz 3: Using data Green, D., Bossomaier,T. (2002)
Apr 15 Data analysis: Data mining, meshing Treinish,L.A. (1997)
14 Apr 20 Data presentation: Visualization, tools, formatting for publication Sieber,J.E. (2005)

Gleick,P.H. (2007)

Apr 22 Sharing data: Ethics, publishing, citation Uhlir,P.F (2003)
15 Apr 27 Project presentations and discussions

Wrap-up

Due: Final prject

Post-course assessment survey

* The content is subject to change as the course undergoes.