Ethics, Analytics and the Duty of Care ~ Data Systems and Tools
Data Systems and Tools
The knowledge and skills required to use appropriate software, tools, and processes to gather, organize, analyze, visualize and manage data (Statistics Canada, 2020).
Many different types of databases exist. The most common types in use today include flat files, spreadsheets, relational databases, multi-dimensional databases, and NoSQL databases. Data literate individuals need to be capable of working with databases of many different kinds (Wells, 2020)
• Spreadsheets (such as Excel and Open Office) – essential tools for quickly scanning
and checking data as well as providing simple data manipulation and combination.
• Geographic Information Systems (such as QGIS and ESRI’s Arc toolset) – tools
for holding, managing and integrating spatial information.
• Databases (such as Access, SQL Server, Oracle, PostGres, PostGIS) – powerful
tools for manipulating and querying larger volumes of data.
• Database management tools (such as Toad, SQL Developer) – provides clear
access to database structure for exploring and querying databases (Heeley & Wilkinson, 2018).
Relevant Links
These links are typically articles defining data literacy that include this theme in their definition.
Antti Poikola, Canada.ca, 2021;, Statistics Canada, Antti Poikola, Canada.ca, 2020;, Antti Poikola, Open Data Institute, 2020;, Chantel Ridsdale, et.al., Dalhousie University, Proceedings of the Doctoral Consortium of Sixteenth European Conference on Technology Enhanced Learning, 2015;, Annika Wolff, Daniel Gooch, Jose J. Cavero Montaner, Umar Rashid, Gerd Kortuem, Canada.ca, 2016;, Andreas Grillenberger, Ralf Romeike, Kateryna Maltseva Reiby, Proceedings of the 13th Workshop in Primary and Secondary Computing Education, Safegraph, 2018;, Edith Gummer, Ellen B. Mandinach, Kateryna Maltseva Reiby, Teachers College Record, Safegraph, 2015;, Australian Public Service Commission, Christian Fieseler, Government of Australia, The Information Society, 2021;, Dave Wells, Christian Fieseler, Eckerson Group, The Information Society, 2022;, ;