STC Workshops

Data-Analysis-Series

Workshop

Description

Resources

Intro to Excel:

This is the beginners workshop for Excel to learn the basics. You will be taught how to create, save and edit spreadsheets, format cells, enter basic arithmatic functions, etc.

Pre-requisites:

  • Basic keyboarding skills

  • Basic math

 

Intermediate Excel

Pick up from where you left off in the Intro to Excel workshop. Learn how to use formulas, advance in formatting, create multiple worksheets, link seperate worksheets, etc.

Pre-requisites:

  • Intro to Excel

  • Basic math

Advanced Topics Excel: Managing Data

This is the last workshop in the Excel series. This class covers the features used in Excel to manage and format data imported from external sources such as .csv or .txt files or created within the program in order to create usable content for use in reports. Manage large datasets by cleaning data, recoding data, deleting and consolidating data, sort data, and prepare data for creation of pivot table/reports.This class is useful to students that import data from external sources or that enter data into excel and need to create data reports/pivot tables.

Pre-requisites:

  • Intro to Excel

  • Intermediate Excel

Intro To SPSS: Entering, Formatting and Analysing Data

In this course, students will learn how to navigate the different views and windows in SPSS, how to enter data collected from a sample study/survey directly into the SPSS data editor window, how to do some basic formatting of that data in SPSS, how to perform some basic descriptive statistics such as Frequencies and crosstabs, and how to save/copy/export the data, analysis results, and charts.

Pre-requisites:

  • All attendees must be enrolled in a statistics class or have an assignment from that class.

  • Undergraduate Students Only

Intermediate SPSS: Running Descriptive and Inferential Analyses for Data Imported into SPSS

In this workshop, students will learn how to import existing data from Excel into SPSS or from an SPSS data file .sav. We will go over how to manage a data set in SPSS e.g. Sorting or Transforming data variables in the Data View, learn the menu/options to select in SPSS to run the appropriate analysis types we need (Descriptive or Inferential Analysis types) for a sample assignment like Standard Deviation, Correlation, T-test, Chi-square and ANOVA, how to navigate through the Output Window after running an analysis and how to save and/or export work.

Pre-requisites:

  • All attendees must be enrolled in a statistics class or have an assignment from that class.

  • Undergraduate Students Only

Course Collaboration Files

SPSS Workshop

Workshop Presentation

Excel Data Sample File

SPSS Data .SAV File