Data Modeling in Education

50 %
50 %
Information about Data Modeling in Education

Published on June 8, 2008

Author: basiyr


Slide 1: Data Modeling Podcast 1 Modeling Data to Enhance Instruction : Modeling Data to Enhance Instruction Podcast 1 Introduction to Data Modeling Data Modeling Overview : Data Modeling Overview Data modeling has often been associated with design processes related to software development in the information systems and computer science fields (Carlis & Maguire, 2000). Traditional data modeling focuses on creating & understanding Logical Data Structures (LDS)‏ LDS are concepts or ideas which go into the creation of database software and applications for the storage, manipulation and retrieval of information. Traditional View Most Popular : Traditional View Most Popular This traditional view has gained more prominence since modern advancements in Web-based retail, financial, medical, educational and business-to-business applications have made it necessary to move large amounts of information throughout the globe (Carlis & Maguire, 2000) Such information is often stored in Physical Data Structures (PDS) such as Database Management Systems (DBMS) What’s a DBMS? : What’s a DBMS? Database Management Systems are computerized record-keeping systems (Jonassen 2006, p.91). These are primarily computer based filing cabinets. The Database is the most widely used computer application. Most of our computer based information is today stored in some sort of database. Examples of Databases in Action : Examples of Databases in Action Databases for purchasing things Storing & finding information on cheap airline tickets Databases for retail services Purchasing items such as books ( etc. Databases for student management Pinnacle, SIS, Gradepro, Gradequick for storing and retrieving student grades The Webster U student management portal Blueprint for Database Design : Blueprint for Database Design Typical ideas about data modeling focus on how such models support the development of information databases in particular. One maxim states “you should no more build a database without a model, than you should build a house without blueprints (BEA, Online).” Traditional DM Defined : Traditional DM Defined “Diagramatic and textual expressions of the kinds of data that an organization, a business, or a culture considers worth remembering” (Carlis & Maguire, pp.1). Data Modeling as Software/Application Design : Data Modeling as Software/Application Design This traditional focus of data modeling as software design dominates the literature As such most data modeling texts and discussions focus on developing conceptual skills, logical design structures and processes for database management systems In this context an individual (A Data Modeller) tries to understand the information needs of a user – s/he then tries to “think out” the design for a database that the user needs to store info Data Modeling in the Real World : Data Modeling in the Real World Data modeling forms a part of all information storage i.e. Database systems. Its primary concerns are: What does the user need to store? What does the user need to retrieve? In other words what needs to be kept in a file drawer for safe-keeping and later use? Data Modeling is the layout and syntax that is used to understand what ought to be saved and remembered by an individual, organization or group i.e. what is stored in a DBMS. What Does a Data Modeler Do? : What Does a Data Modeler Do? The data modeler helps users to: Think about what data needs to be stored & retrieved Articulate what types of data need to be stored Define categories of data for storing purposes Translates what people want to how databases (DBMS) think. An Example Data Model : An Example Data Model A school wishes to keep information on students based on performance, grade level, IEP status; A data modeler would help them think through the database that they wish to design to store such data To do this s/he would identify the Logical Data Structure (LDS) that reflects the database – usually in textual or graphical form Student Data Matrix : Student Data Matrix This matrix demonstrates how a data modeler would begin to organize and think about the data that the school would need. This matrix helps to categorize or classify the different types of data that the school needs and organizes them in such a way that more questions can be asked of the information .e.g. - Which student is performing at a high level more consistently? - How many students have IEP's etc. The data modeler would also be concerned with how the data may be organized differently based upon the questions the school needs to ask. Data Notation : Data Notation This is the same data in the matrix as on the previous slide but it is written in Logical Data Structure (LDS) Notation. This is how a data modeler in the traditional business environment translates information in such a way that a database programmer can then build the database to store the information. Later users like ourselves can connect to the database to retrieve this stored information. Data Modeling Skills for Educators : Data Modeling Skills for Educators Basic Data Literacy (Quantitative vs Qualitative Data) Sketching or drawing (to map out data relationships) Ability to break information down into small parts – convert information to data Ability to ask compelling questions of data References : References Bureau of Enterprise Architecture (date unkown)., Commonwealth of Pennsylvania. Online., Accessed May 31, 2008 Carlis, J., & Maguire, J., (2000) Mastering Data Modeling. Addison-Wesley Jonassen, David, H., (2005). Modeling with Technology: Mindtools for Conceptual Change (3rd Edition) by Prentice Hall; ISBN-13: 978-0131703452 Jonassen, D. H., Carr, C., and Yueh, H.-P. (1998). Computers as mindtools for engaging learners in critical thinking. TechTrends, 43(2):24-32. Available Online (See Blackboard Vista Weblinks) Mellar, H., Bliss, J., Boohan, R., Ogborn., & Tompsett, C., (ed.s) (1994). Learning with Artificial Worlds: The Falmer Press. P1RJ1S (2008) Smoothy Soothy., from, Available Online End of Podcast 1 : End of Podcast 1 Modeling Data to Enhance Instruction REMEMBR TO: Complete the Podcast Activity

Add a comment

Related presentations

Related pages

In-Depth Education "Data Modeling", vom 22.-24.Oktober in ...

Dear all, from 22nd - 24th October 2012 the 9th TDWI In-Depth Education takes place in Frankfurt. Topic this time is Data Modeling. Our instructor John O ...
Read more

Data Modeling, In-Depth Education in München, 26.-28 ...

Liebe Gruppenmitglieder, vom 26.-28. März findet in München die 7. TDWI In-Depth Education statt, zum Thema Data Modeling. Über 3 Tage wird John O'Brien ...
Read more

Data Modeling News, Articles, & Education

DATAVERSITY is a proven source of data modeling news. Read our data modeling articles and information from extensive data modeling research.
Read more

Education Data Model (National Forum on Education ...

The Education Data Model is a comprehensive localized education data model that provides a national blueprint for schools. This blueprint enables schools ...
Read more

Data modeling education: The changing technology (PDF ...

Official Full-Text Publication: Data modeling education: The changing technology on ResearchGate, the professional network for scientists.
Read more

Data Modeling News, Articles, & Education |

Data is the kind of ubiquitous resource that we can shape to provide new innovations and new insights, and it's all around us, and it can be mined very easily.
Read more

Online Data Modeling and Metadata Management Education

Our Data Modeling and Metadata Management curriculum includes 11 online courses, from fundamentals to advanced. You can purchase the courses individually ...
Read more

Onsite Course List - TDWI | Advancing all things data ...

TDWI Data Modeling: Data Analysis and Design for BI and Data Warehousing Systems. ... In-Depth Education and Research on All Things Data. For 20 years, ...
Read more

Modeling - LEARN NC

Modeling is an instructional strategy in which the teacher demonstrates a new concept or approach to learning and students learn by observing.
Read more