A data type to exploit online data sources

ABSTRACT

Recent work in developing student assignments has involved making use of online data resources to make them more interesting and to give students real world information to interact with in some manner. While definitely a practical approach, the work that has been done so far is either for "CS0" courses targeted at non-majors, often using tools like Microsoft Excel, or courses that require a level of skill at programming from the students. Additionally, existing tools are specific to a particular structure of the data (CSV, XML, and others). As a result, these constraints make on-line real-world data sets difficult to use in typical introductory programming courses for majors.

Objects-first approaches to teaching introductory programming advocate the use of objects early on. Consequently, students are able to take advantage of using data types early on. We have created an interface that allows students to access real-world data sets from online (or local) sources in a uniform fashion. This abstraction allows students with minimal programming experience to load, process, and manipulate external data sets in a variety of formats. We also developed a lab assignment where students accessed an online CSV data source to demonstrate feasibility and to gain experience with classroom use of this approach.

REFERENCES

• 1: Peter DePasquale, Exploiting on-line data sources as the basis of programming projects, Proceedings of the 37th SIGCSE technical symposium on Computer science education, March 03-05, 2006, Houston, Texas, USA
• 2: Nick Parlante , Steven A. Wolfman , Lester I. McCann , Eric Roberts , Chris Nevison , John Motil , Jerry Cain , Stuart Reges, Nifty assignments, Proceedings of the 37th SIGCSE technical symposium on Computer science education, March 03-05, 2006, Houston, Texas, USA
• 3: Stephen H. Edwards, Improving student performance by evaluating how well students test their own programs, Journal on Educational Resources in Computing (JERIC), v.3 n.3, p.1-es, September 2003 [doi>10.1145/1029994.1029995]
• 4: Edwards, S.H. Web-CAT Wiki. 2008. Available from: http://web-cat.org/
• 5: Matthew Thornton , Stephen H. Edwards , Roy P. Tan , Manuel A. Pérez-Quiñones, Supporting student-written tests of gui programs, Proceedings of the 39th SIGCSE technical symposium on Computer science education, March 12-15, 2008, Portland, OR, USA
• 6: Ostermiller, S. Java Utilities. 2007. Available from: http://ostermiller.org/utils/
• 7: Nick Parlante , John Cigas , Angela B. Shiflet , Raja Sooriamurthi , Mike Clancy , Bob Noonan , David Reed, Nifty assignments, Proceedings of the 38th SIGCSE technical symposium on Computer science education, March 07-11, 2007, Covington, Kentucky, USA
• 8: Kim B. Bruce , Andrea Danyluk , Thomas Murtagh, A library to support a graphics-based object-first approach to CS 1, Proceedings of the thirty-second SIGCSE technical symposium on Computer Science Education, p.6-10, February 2001, Charlotte, North Carolina, United States
• 9: Kim Bruce , Andrea Danyluk , Thomas Murtagh, Java: An Eventful Approach, Prentice-Hall, Inc., Upper Saddle River, NJ, 2005

INDEX TERMS

Primary Classification:
  K. Computing Milieux
  K.3 COMPUTERS AND EDUCATION
      K.3.2 Computer and Information Science Education

Additional Classification:
  E. Data
  E.1 DATA STRUCTURES

  H. Information Systems
  H.3 INFORMATION STORAGE AND RETRIEVAL
      H.3.2 Information Storage
          Subjects: File organization
  H.4 INFORMATION SYSTEMS APPLICATIONS
      H.4.1 Office Automation
          Subjects: Spreadsheets

General Terms:
Design

Keywords:
csv, data mining, data table, objectdraw, spreadsheet, web-cat