Teaching

|  STATS 220  |  STATS 380  |  STATS 769  |  STATS 787  |  10x  |

The home page for Data Technologies in Vienna.

The STATS 782 Home Page.

769 Data Science Practice

787 Topic in Computational Data Analysis and Graphics

• Other courses:
  • Ross's 120 stuff.
  • Data Visualization course to be run by Bill Cleveland at Purdue.
  • Statistical graphics course to be run by Andrew Gelman (at Columbia).
  • Frank Harrell's Statistical Graphics Course (including links to others).
  • Ed Wegman's Statistical Graphics and Data Exploration (including link to CrystalVision software) and Virtual Reality/Scientific Visualization (Spring 1998).
  • Dan Carr's version of Statistical Graphics Course.
  • Michael Minnotte's 6560
  • Jim Robison-Cox's 438
  • Hugh Chipman's 441
  • A Statistical Graphics course at Vanderbilt Medical Centre.
  • A Data Mining course with lots of great visualisations (PDFs available for Lecture5 through Lecture11).
• General:
  • Handbook of Computational Statistics (e-book).
  • Chen's Lab for Information Visualization (Chun-Houh Chen, Associate Research Fellow Institute of Statistical Science, Academia Sinica)
• Graphics file formats:
  • Andrew T. Young's LaTeX overview which includes lots of stuff about converting between different graphics formats
  • E. Weingar's First Guide to PostScript
  • Paul Bourke's PostScript Tutorial
  • Part two of a tutorial on Imagemagick (with link to part one).
  • About.com's graphics formats section.
  • On-line version of the Encyclopedia of Graphics File Formats (hardcopy available from Tamaki Library: 006.6 M98).
  • Graphics File Formats FAQ
  • wikipedia entry on graphics file formats.
  • Paul Bourke's page on the BMP format.
  • The prepressure site. Info on graphics formats, especially PostScript and PDF, and fonts.
• Graphics hardware:
  • The PC Hardware FAQ/video FAQ.
• Interactive/Dynamic Graphics:
  • Mondrian
  • The talks from the workshops on "Modern Statistical Visualisation and Related Topics" (see especially workshop #5).
  • ggobi home.
  • XLispStat
  • iPlots (JGR)
  • Klimt
  • Orca
  • "Interactive and Dynamic Graphics for Data Analysis: With Examples Using R and GGobi" by Deborah F. Swayne, Dianne Cook, Andreas Buja, Heike Hofmann, Duncan Temple Lang (on-line version of book in preparation).
  • GIR
  • Resources from AgResearch

380 Statistical Computing

• home page.
• My book.
• The e-book version of my book (via University Library's access to CRC's STATSnetBASE).
• Some handouts on R graphics from an Introduction to Exploratory Data Analysis STAT 445 at UBC.
• R coding conventions
• John Fox's STATISTICAL COMPUTING IN S.
• Duncan Temple-Lang's course on Advanced Statistical Computing
• Deb Nolan(?)'s Statistical Thinking and the Data Analysis Cycle.
• The web site for John Chamber's Programming with Data.
• Thomas Lumley's slides for a two-day introductory course on R.
• John Maindonald's course materials on data mining using R .

220 Data Technologies

|  Apache  |  Databases  |  Spreadsheets  |  Data Warehousing  |  HTML  |  XForms  |  Perl  |  Regular Expressions  |  Resources  |  MySQL  |  PHP  |  SQL  |  XML  |

Other Courses and Links
• The web server root on stat18.
• A test file in my user account on the undergrad computer system (NOTE that it requires username+password entry).
• A link to Cecil.
• The University of Auckland Guidelines for the Use of University Computing Facilities and Services
• The University of Auckland WWW Standards and Guidelines
• A page containing Statistical Job Announcements in Australia and New Zealand -- useful for seeing what employers want in a stats graduate(?)
• The World Wide Web Consortium (W3C) home page.
• Courses/Notes
  • Duncan Temple-Lang's Statistical Computing course Stat 141 at Davis.
  • Supposedly-undergraduate-course description at Iowa State.
  • There's a course called "Statistical Computing" at Warwick University, which is taught by an interesting sounding guy, but no links to any content (16/06/03)
  • Some notes on modern statistical computing by Tony Rossini.
  • A list of How to's and Guides from the University of Kansas, including lots on internet-related stuff.
  • The Computer Science Department's Internet Programming Course home page. Includes lecture notes on HTML, XML, PHP, and HTML Forms. Also includes a Guide to Installing and Configuring Apache, PHP, and MySQL on Windows.
• Web Developer Sites
  • The plone web site; web content management software (for making the 220 pages look more professional). (a free on-line book about how to use plone.)
  • The ITtoolbox site with heaps of links to IT information.
  • The DevShed site; lots of tutorials on web tech stuff. Some relevant artilces are: cascading style sheets, xml, dtd's, database essentials, database normalisation, SQL, php, regular expressions.
• Books
  • A book review on slashdot about Web Database Applications with PHP & MySQL. As usual, lots of interesting "follow-ups" as well.
  • A book review on slashdot about PHP and MySQL Web Development. Some of the comments complained about its out-of-date-edness, but a Second Edition is due Feb 13 2003.
• Text Editors
  • The home page for the Crimson Editor. Nice (freeware) Windows text editor with syntax highlighting (for PHP, SQL, and HTML), parenthesis matching, auto indenting, regular expression searching, and line numbering (and it hasn't crashed on me yet like ConText did!).
  • Reference to Tinn-R. Tinn (Tinn is not notepad) is a text editor with the usual programmer-friendly features; Tinn-R has been set up to work nicely with R (including code submission to running R session). Couldn't find a manual though ...
  • The home page for brixoft makers and distributors of SourceEdit (free text editor).
Spreadsheets
• Eric Neuwirth's Spreadsheets, Mathematics, Science, and Statistics Education.
• Some stuff by Frank Harrell about bad things about spreadsheets
• Some stuff by Patrick Burns about bad things about spreadsheets
• Some basic stuff on Excel by Peter Mullins.
• A paper about Gnumeric and Excel by B. D. McCullough.
• There is a paper "On the accuracy of statistical distributions in Microsoft Excel 2003" in Computational Statistics & Data Analysis Volume 48, Issue 3, Pages 445-675 (1 March 2005). Also in Computational Statistics & Data Analysis, Volume 49, Issue 4, 2005(!?).
Databases
• A set of notes, slides, and references for a medical course on Principles of Database Design
• One of the sites referred to by the course above; in particular, a section on The Traditional Database Perspective - An Introduction and Overview and a Review of Entity-Relationship Modeling (a technique for designing databases [I think]).
• A reference to the "classic" or defining article for relational databases by E. F. Codd
• A page on Introduction to Relational Database Design -- heavy on SQL examples.
• A course on Database Systems and Structures PDF documents of all lecture notes. Stuff on general database concepts, E-R diagrams, and normalisation.
• See Chapter 13 in Bioinformatics Computer Skills. Gives nice database design example -- I should try to mirror the problems in that example in my "CD collection" example for an assignment.
• Some of Doug Bates' notes on multilevel models with mentions of advantages of databases, reasons for database use, and example data sets.
• A link to another dataset -- not huge, but a potential database application because of the structure of the data (see Doug Bates' stuff above).
• A list of steps involved in setting up and cleaning a large data set using a DBMS (again from Doug Bates).
• An article on Database Indexing.
• An article on Database Normalization And Design Techniques.
SQL
• A page of differences in SQL syntax between DBMS by Troels Arvin.
• How to do "pivot tables" (cross-tabulation) in SQL
• Using SQL an eBook (accessible from on-campus at least) by Rafe Colburn.
• An on-line SQL tutorial. Very cool because it allows interactive evaluating of SQL commands on-line! Also, a links-to-tutorials page from the same site.
• An SQL/PHP tutorial.
• A nice simple SQL/PHP example.
• See Chapter 13 in Bioinformatics Computer Skills.
• An on-line book called Beginning SQL Programming.
• The site where I nabbed the basic structure of the SQL quick reference from.
• An on-line tutorial on SQL including quiz. (Also the source I based the SQL intro handout on. See the terms of use.)
• SQL is an ANSI standard, but you have to purchase a copy to see it. Here is a page with info on the SQL standard.
• A list of SQL links.
Perl
• A Perl tutorial.
• The Active Perl download site.
• See Chapter 12 in Bioinformatics Computer Skills.
HTML
• The W3C page.
• The W3C HTML 3.2 Reference Specification
• An introduction to HTML from a W3C person (has link to advanced topics).
• An introduction to HTML document (NOTE the copyright notice).
• XForms "The Next Generation of Web Forms".
• An introduction to HTML forms tutorial (also with copyright notice).
• An HTML Forms tutorial.
• A free html-authoring tool called HTML-Kit.
• Another free html-authoring tool from W3C called Amaya.
• You could always use Netscape Communicator for html-authoring too (or even MS Word?).
• A document on composing good HTML.
• An HTML quick-reference -- possible candidate for student notes/handout?
• An HTML quick-reference for HTML 3.2 -- even better candidate for student notes/handout?
• CUNA online questtionaire company.
• How CGI Scripting Works
• An article on using CSS instead of tables for layout, plus lots more similar links.
XForms
• The W3C XForms site.
• The XForms for HTML Authors tutorial.
• The XForms Institute, including on-line lessons and the online book XForms Essentials.
• T. V. Raman's XML Powered Web Forms (IBM Research)
• Firefox extension for XForms.
XML
• A document discussing the relationship between XML and Databases.
• See Chapter 13 in Bioinformatics Computer Skills.
• Some really nice information on XML, but see the terms of use. Some useful things on uses of XML.
• A comprehensive XML tutorial
• Here's the place I got the DTD syntax handout stuff from.
• Another basic intro to XML.
• See some of the omegahat XML-related documents.
• A really comprehensive introduction to XML, XSL, DOM, ...
• XML for Molecular Biology as compiled by Paul Gordon.
• A general site on XML including lots justifying why you might want to use XML (including why XML could be preferred over a database).
• Another general XML site.
• An XML FAQ.
• A "free" on-line book called Processing XML with Java. Includes nice little section on motivating XML.
• A (very large) list of applications of XML in different projects.
• The MathPlayer free download. IE viewer for MathML.
Apache
• The (local) Apache on-line documentation.
• A tutorial on setting up password-protected areas of a web site using MySQL with Apache.
• A comprehensive guide to htaccess
• A much shorter guide to htaccess
PHP
• An on-line text A Programmer's Introduction to PHP 4.0 .
• A set of slides on OOP in PHP 5.
• The (local) PHP4 on-line documentation.
• The documentation for phpmyadmin (from the official phpmyadmin site).
• The site where I got the brief PHP manual from (possible class handout).
• The main regular expression syntax reference from the PHP4 manuals.
• A comparison of php, javascript, and vbscript, but it's a useful summary of PHP features/syntax too.
• A set of forums for asking questions about PHP. Point the students to these?
Regular Expressions
• An introduction to regular expression within PHP context quick reference sheet. Only problem with these is that they are PHP3-specific (don't know yet what the differences are to PHP4).
• Another regular expression tutorial -- this one includes some examples of validating form input(!)
• The PCRE man page with LARGE section explaining how PCRE regular expressions work. Maybe put copy on STATS 220 Home Page? Need to check that the syntax is relevant to the PHP implementation.
• The Perl regular expressions man page with nicer formatting -- but would need to check that the syntax is relevant to the PHP implementation.
• Regular expression documentation for JScript.
• The book "Mastering Regular Expressions" by Jeffrey E. F. Friedl (O'Reilly).
MySQL
• (Local) MySQL reference manual.
• The MySQL on-line documentation. This may get ahead of the local copy as updates are released. OTOH, as long as the local copy is matched to the version installed on stat18, what do I care?
Resources
• The Antarctica on-line survey. And the Antarctica: Scientific Journeys from McMurdo to the Pole web site itself.
• A Privacy Online survey (got data entry section from this?)
• Jeff Banfield's Rweb.
• The Lopix-Mondial case study. Integrating discrepant databases into a coherent whole by recoding each database into XML then merging the XML.
• A collection of databases for use in teaching.
• The DigiPoll site.
• The Victorian Government's repository of e-government resources.
• Information on the development of the E-census : The Swiss census on Internet.
Data Warehousing
A site devoted to data warehousing, including a page of introductory material on data warehousing.

769

• Statistical Learning online course from Stanford, based on free online texts An Introduction to Statistical Learning and The Elements of Statistical Learning.

10x

• 10x web resources

General Links

• The H20 Project. Software for innovative teaching environments.