Documentation:Information Technology Literacy Resources

From UBC Wiki

Word Processing Software

Microsoft Word

Overview

Documentation & tutorials

Google Docs

Overview

Documentation & tutorials

OpenOffice Writer

Overview

  • Word processing program within the Apache OpenOffice suite
  • Open-source software
  • Free alternative to Microsoft Word
  • Installed on the Windows computers in the Kitimat Lab
  • Compatible with Windows, macOS, and Linux operating systems

Documentation & tutorials

LibreOffice Writer

Overview

Documentation & tutorials

Pages

Overview

Documentation & tutorials

Spreadsheet Software

Microsoft Excel

Overview

Documentation & tutorials

Google Sheets

Overview

Documentation & tutorials

OpenOffice Calc

Overview

  • Spreadsheet program within the Apache OpenOffice suite
  • Open-source software
  • Free alternative to Microsoft Excel
  • Installed on the Windows computers in the Kitimat Lab
  • Compatible with Windows, macOS, and Linux operating systems

Documentation & tutorials

LibreOffice Calc

Overview

Documentation & tutorials

Numbers

Overview

Documentation & tutorials

Presentation Software

Microsoft PowerPoint

Overview

Documentation & tutorials

Google Slides

Overview

Documentation & tutorials

OpenOffice Impress

Overview

  • Presentation program within the Apache OpenOffice suite
  • Open-source software
  • Free alternative to Microsoft PowerPoint
  • Installed on the Windows computers in the Kitimat Lab
  • Compatible with Windows, macOS, and Linux operating systems

Documentation & tutorials

LibreOffice Impress

Overview

Documentation & tutorials

Keynote

Overview

Documentation & tutorials

Prezi

Overview

Documentation & tutorials

Relational Databases

Relational Database Concepts

Overview

These resources provide a conceptual overview of relational databases. Although these tutorials refer to specific relational database management systems (e.g, Access, SQL Server) in their examples, the specific sections linked here apply across multiple relational database management systems.

Books

  • Coronel, C., & Morris, S. (2016). Database Systems: Design, Implementation, & Management (12th edition). Boston: Cengage Learning. [ISBN-13: 978-1305627482]
  • Elmasri, R., & Navathe, S. B. (2015). Fundamentals of Database Systems (7th edition). Hoboken: Pearson. [ISBN-13: 978-0133970777]

Documentation & tutorials

Microsoft Access

Overview

Documentation & tutorials

SQL

Overview

  • SQL (Structured Query Language) is a programming language used for creating and manipulating relational databases
  • Used in several relational database systems, including Microsoft SQL Server and MySQL
  • Microsoft SQL Server 2017 is installed on the Windows computers in the Kitimat Lab
    • Proprietary software
    • Developer and Express versions are free to download
    • Compatible with Windows and Linux operating systems
  • MySQL Workbench 6.3 is installed on the Windows computers in the Kitimat lab
    • Open-source software
  • Compatible with Windows, macOS, and Linux operating systems

Tutorials

Documentation & other resources

OpenOffice Base

Overview

  • Database program within the Apache OpenOffice suite
  • Open-source software
  • Free alternative to Microsoft Access
  • Installed on the Windows computers in the Kitimat Lab
  • Compatible with Windows, macOS, and Linux operating systems

Documentation & tutorials

LibreOffice Base

Overview

Documentation & tutorials

Web Development

HTML & CSS

Editors

  • Brackets: HTML and CSS editor with live preview functionality; installed on the Windows computers in the Kitimat lab
  • Atom: popular text editor for web development
  • Adobe Dreamweaver: web development tool from Adobe; installed on the computers in the Kitimat lab
  • Mozilla Thimble: a web-based, what-you-see-is-what-you-get, basic HTML and CSS editor to try out your HTML skills and visualize results in real time
  • W3Schools - TryIt Editor: another web-based HTML editor

Books

  • Robbins, J. N. (2018). Learning Web Design (5th edition). O’Reilly Media. [ISBN-13: 978-1491960202]
  • Meyer, E. & Weyl, E. (2017). CSS: The Definitive Guide (4th edition). O’Reilly Media. [ISBN-13: 978-1449393199]
  • Frain, B. (2017). Responsive Web Design with HTML5 and CSS3 (2nd edition). Packt Publishing. [ISBN-13: 978-1784398934]
  • Freeman, E., & Robson, E. (2012). Head First HTML and CSS (2nd edition). O’Reilly Media. [ISBN-13: 978-0596159900]

Documentation & tutorials

Social Media

Tumblr

UBC Wiki