Developing a Data Analysis Toolbox

The array of available data analysis and visualization tools, coupled with the rate of change and innovation in this field, can be daunting. Within the framework of the Certificate in Community Data Science, this course is a survey of available data analysis tools. You will be introduced to various data analysis and visualization software packages through demonstrations of, and exercises using, introductory functions. In doing so, you will learn of the relative strengths and challenges of a given tool. This survey approach will acquaint you with options upon which you can independently develop your professional practice. The objective for this course is to enhance your curiosity about, and confidence with, new software rather than develop mastery with any given tool.

Acknowledging that you may not have access to advanced data analysis software, Microsoft Excel will be a fundamental software package for this course, and you will learn how to conduct advanced analysis functions with this program. With Excel as a cornerstone, you will learn how to choose the right software for the task at hand, and how to migrate data between analysis tools. Class time will be set aside for participant-led, collaborative, and experiential learning oriented towards exploration of the skills needed for applied research problems relevant to your professional practice.

You will work independently or in teams, collaborate with instructors and colleagues in using online resources to answer procedural software questions, and produce methodologies that show the processes through which you conduct analysis.

This course is available at the following time(s) and location(s):

This course is available at the following time(s) and location(s):

Campus Session(s) Instructor(s) Cost Seats available  
Online, Vancouver 4 Craig E. Jones
Samuel Walker
Lyn Bartram
Martin Monkman
$1412.00 10 Register

Schedule clarification: This course consists of two online sessions on Wednesday evenings (6:30 p.m. – 8:30 p.m.) and four in-class sessions at the Vancouver campus on Fridays and Saturdays (9 a.m. – 5 p.m.).

What will you learn?

By the end of this course, you will be able to do the following:

  • Identify major software packages and tools in community data science
  • Install data analysis and visualization software onto your computer
  • Manage quantitative data in Microsoft Excel
  • Perform core functions in various software packages
  • Choose an oppropriate software package or tool for a given task
  • Migrate data between data analysis and visualization software packages
  • Independently experiment with data analysis and visualization software packages
  • Locate and interpret online resources to get help answering procedural questions
  • Produce detailed methodologies that ensure transparency, justifiability and reproducibility

How will you learn?

  • Lectures with hands-on practice in Microsoft Excel, Graphical Information Systems, spatial data, and statistical software
  • Class discussions
  • In-class assignments

How will you be evaluated?

You will receive a post-course assignment, guidance and feedback.

Hardware and software requirements

  • You are required to bring a PC laptop (with full administrative privileges) to each class.
  • Your laptop must have a recent install of Microsoft Excel.
  • Beyond 20/20 (an open-source data publishing, dissemination and analytics tool), installed during the CDSC101 course.
  • Esri ArcGIS (graphical information systems software), installed during the CDSC102 course.
  • R virtual online console (an open-source statistics and data science tool). Login instructions will be provided at the introductory online session on January 8.
  • Tableau (data visualization tool). Login instructions will be provided at the introductory online session on January 8.
  • Online sessions in this course will be delivered through SFU's online course management system, Canvas. You will receive course details and Canvas access instructions on the first day of the course. You can check if your browser is compatible with Canvas here.
  • New to online learning? See Online Programs and Courses for helpful videos and additional information.

Textbooks and learning materials

We will provide custom course materials.

Look at other courses in