Session 1368


 

National Statics Clearinghouse (NSC) Database


 

Scott Danielson1, Sudhir Mehta2, Clark Merkel3, Pratap Kotala2

1Arizona State University East / 2North Dakota State University /

3Stinar Corporation


 

 

 

Abstract

 

A National Statics Clearinghouse (NSC) containing information about, and links to, major publications, pedagogical advances, and course materials related to statics is under construction.  The NSC database will allow easy searching by keyword, author, and institution provides “one-stop shopping” for instructors searching for information and materials focused on improving student learning in statics.  The NSC enhances dissemination of knowledge and provides a launching platform for faculty efforts in teaching statics.

 

I.  Introduction

 

Statics is taught in almost all engineering and engineering technology programs (both 2 and 4-year).  Thus, a large number of instructors in colleges and universities are engaged in teaching statics.  Their background, training, and ability to stay current with the teaching resources available to them vary widely.  Also, there are faculty continually developing, often in isolation, innovative ways to improve teaching and learning of statics.  Thus, many new instructional insights or resources continually become available.  For instance, the ASEE 1998 and 1999 Annual Conference proceedings illustrate web-based multimedia courseware related to statics.  Work recorded by Ogleby et. al. (1998), Jack (1998), Toogood et. al. (1998), and Holzer & Andruet (1999) is available to any student or instructor who knows to access it. Similarly, there are a number of articles in journals and conference proceedings related to incorporation of design, using case studies and open-ended problems, simulations, physical models, hands-on experiments, and various other active-learning strategies.

 

It will be a great help to instructors if resources on statics (both new and old) are compiled at one site.  The National Engineering Education Delivery System (NEEDS), supported by the Synthesis Coalition, was started using a similar concept.  While NEEDS is intended to be a national resource for tracking educational materials, information and advances for the entire spectrum of engineering education, maintaining such a database is a huge task.  For example, none of the authors listed above are currently listed in the NEEDS database.  Even the recent funding by NSF’s Action Agenda for Engineering Education for continued development and maintenance of the NEEDS database may not solve this problem as there are a large number of engineering subjects and NEEDS may not be able to devote extensive attention to just one of them.

 

II.  The National Statics Clearinghouse

 

The National Science Foundation recently funded a proposal entitled "Statics: The next generation."  This proposal included creation of a National Statics Clearinghouse (NSC) to act as a web-based information portal to publications, pedagogical advances, and courseware related to statics education.  Creating and updating this database on a focused topic will be easier and more cost effective then developing and maintaining a huge database like NEEDS.  The National Statics Clearinghouse (NSC) will be a statics portal and resource for pedagogy, incorporation of design into statics, integration of related subjects, web-based learning materials, a launching pad for further development, and enhanced dissemination.

 

The NSC database is easily searchable by keywords, authors, institution, publication year, etc., via web browsers.  The NSC also features a content submission tool allowing user (statics' instructors and students) input of new information and reviews of existing items for inclusion in the database.  In addition, the NSC is dynamic in nature and includes links to other sites or resources related to statics teaching and learning.

 

This paper describes the design of the NSC database, the types of articles and resources included, and current database content.  Content will continue to be added during the spring 1999 semester (a live demonstration of the database will be included in the paper's presentation at the ASEE 2000 Annual Conference).  This paper is also an advertisement of the database and a request for all interested parties to help in its development by suggesting or adding new information.

 

III.  Initial Input

 

The first materials to be loaded into the NSC database were taken from ASEE Annual Conference proceedings.  Since ASEE proceedings have been put on CD-ROMs in recent years, they provide a significant resource already in electronic format.  The proceedings from 1996 to 1999 were searched using the keyword "statics" and over 300 papers were found.  These papers are being reviewed by three experienced faculty familiar with teaching statics.  The primary focus of the review is on the value of the material for teachers of statics, either because of content directly applicable to the classroom or support to instructors as they prepare for the teaching and learning process.  A star rating system is used, with a range of one to five stars.  Five stars indicate that the paper is a tremendous resource for a vast majority of statics instructors and contains significant content towards increasing the learning of students.

 

This same approach will also be taken towards other related conference proceedings, journals, and on-line resources.  For instance, recent Frontiers in Education conference proceedings are available via the world-wide-web.  In these cases, the database will not "contain" the actual paper, but will provide a rating (along with information like reviews or user feedback) and a link to the paper at its home web site.

 

IV.  Database Interface

 

The NSC database is being initially created in MySQL database system. Later this will be exported to PostgreSQL. PostgreSQL is a sophisticated open-source, Object-Relational Database Management System available at no cost. The database will consist of data-tables with the following fields: title, author, affiliation, abstract, keywords, ratings, comments, source, link addresses, and publication year. Each record in the data-table will provide a complete information set about one item on statics.

The NSC database can be searched through any standard web browser. The user interface is a HTML form with text fields, buttons, and pop-up menus so search information can be entered and sent to the web server (and from there to other Common Gateway Interface (CGI) programs) for processing.  CGI programs written in PERL will act as the engine searching the database for the required information.  PERL was selected as the best available language for string processing and its excellent Application Programming Interface (API) for working with MySQL and PostgreSQL. The database can be searched using criteria like keywords, author, year of publication, source, affiliation, and / or general text search. Once the user submits the search information through the HTML form, the CGI programs will process it. The CGI programs' embedded SQL queries will query the database and return search results to the users web browser.  Search results can then be sorted by year of publication, alphabetically, or by the star rating.  The results will also include links to the respective articles.

 

The ability to receive feedback and comments from the users will be created. All comments submitted by users will be e-mailed for review and inclusion in the database. The database will be dynamic in nature, supporting constant updating and editing.

 

V.  Contact Information

 

The authors would greatly appreciate a wide range of input for the NSC.  Suggestions of features or capabilities of the statics information portal and specific items related to teaching and learning in statics to be considered for inclusion are welcome.  Intellectual property rights will be maintained and enforced as appropriate.   The author's email addresses are given in their biographies.   The web URL for the NSC is www.ndsu.nodak.edu/instruct/mehta/NSC/.

 

VI.  Acknowledgements

 

This work is partially supported by the National Science Foundation (NSF) Grant No. DUE-9950358.  The proposal, "Statics: the next generation" was funded by the Division of the Undergraduate Education (DUE) at the NSF under their Course, Curriculum, and Laboratory Improvement (CCLI) Program.

 

 

 

References *

1.  Holzer, S. and Andruet, R. (1998).  "Learning Statics with Multimedia and Other Tools," Proceedings, ASEE National Conference, Seattle, WA.

2.  Jack, H. (1998).  "A Paperless (almost) Statics Course," Proceedings, ASEE National Conference, Seattle, WA.

3.  National Engineering Education Delivery System or NEEDS.  URL:  http://www.needs.org

4.  Oglesby, David, Edwin R. Carney, Michael Prissovsky, and Dave Crites,  (1998).  "Statics On-Line: A Project Review," Proceedings, ASEE National Conference, Seattle, WA.

5.        Toogood, Roger, Bill Lipsett, & Shelley Lorimer (1998).  "Computer Based Learning for Engineering Mechanics: If we build it, will they come?" Proceedings, ASEE National Conference, Seattle, WA.

 

 

* Note: The references in the text are given in a format (Author, Year) that is easier for the reader.  In the final paper, we can change the format to the style (Superscript number) suggested in the ASEE guidelines.

 

 

SCOTT DANIELSON

Scott Danielson has been an associate professor and chair of the Manufacturing and Aeronautical Engineering Technology Department at Arizona State University East (a new campus 23 miles east of the main ASU campus) since August 1999.  Previously he had been at North Dakota State University where he was a faculty member in the Industrial and Manufacturing Engineering department and past chair of the Engineering Technology Department.  Other responsibilities at NDSU included teaching courses in the Mechanical Engineering and Applied Mechanics Department and managing the Robert Perkins Engineering Computer Center.  Dr. Danielson received the NDSU College of Engineering and Architecture’s Teacher of the Year Award for the 1995-1996 year.  His research interests include effective teaching and engineering applications of geographic information systems.  Before coming to academia, he was a design engineer, maintenance supervisor, and plant engineer.  He is a registered professional engineer.  His e-mail address is sdanielson@asu.edu.

 

SUDHIR MEHTA

Sudhir Mehta is a professor of Mechanical Engineering at North Dakota State University. He was named the 1997 North Dakota Professor of the Year by the Carnegie Foundation and has received the HP award for excellence in laboratory instruction in 1999.  Dr. Mehta and his colleagues have received the best paper awards from the ASEE in 1999 and 1995.  His areas of interest are enhancing student learning, measurements, controls, robotics, mechanics, design optimization, and machine vision.  He has co-authored two CD-ROM’s containing hypermedia based instrumentation and communication resource modules.  He has also developed innovative techniques for active learning, collaborative learning, and quick assessment. He and his colleagues have received several grants from the NSF, 3M, and HP to enhance engineering education.  Dr. Mehta received the Carnot Award for the best teacher of the year, four times, from the students of Pi Tau Sigma Society. His e-mail address is mehta@badlands.nodak.edu.

 

CLARK MERKEL

Clark Merkel currently is a design engineer with Stinar Corporation, a manufacturer of airport maintenance equipment in Eagan, Minnesota.  He taught in the Mechanical Engineering and Applied Mechanics Department at North Dakota State University from 1988 to 1999.  From 1984 to 1988 he taught Physics and Pre-engineering at the two-year institution, North Dakota State University, Bottineau Branch.   In 1998 he was recognized as an FIE New Faculty Fellow and in 1999 as an ASEE-ERM Apprentice Faculty Recipient.  His professional interests include mechanics, robotics, system modeling, and engineering education.  His email address is cMerkel@stinar.com.

 

PRATAP KOTALA

Pratap Kotala is a graduate student in Department of Computer Science & Operations research at NDSU. He holds a B.Sc in Agriculture and M.Sc in Agricultural Economics from Andhra Pradesh Agricultural University, Hyderabad, India. Earlier, he worked as a Research Associate in National Academy for Agricultural Research Management, Hyderabad, India.  His professional interests include database development and the web interface design.  His e-mail address is kotala@badlands.nodak.edu.