Ron's teaching notes

Digital information literacy

Topics from a level-100 general education course on working with digital information.

• Structured information: digital files, spreadsheets, databases
• Data insight techniques: aggregation using pivot tables, and visualisation
• Information management: specialised systems to manage files, bibliographies, passwords, and projects.
• Societal impact of digital information

Data management

Topics from a level-200 course for business students on managing digital data.

• Digital data: files, formats, and databases
• SQL (use cases in SQL Server and SSMS)
• Data storage design considerations (using the relational model)
• Data flows: an introduction to ETL (use cases in SSIS)

Data wrangling

Topics from a level-300 course for business students on wrangling digital data.

• Introduction and software
• Wrangling tabular data (use cases in Excel)
• Wrangling web data (use cases in XML and XPath)
• Wrangling big data (use cases in MongoDB)
• Wrangling text data (learning Regular Expressions; use cases in MongoDB and plaintext)

All notes are licensed under a Creative Commons Attribution 4.0 International License.