| Introduction to Audacity | In this one-hour workshop on Audacity, you will learn how to use the software to create dynamic interviews or podcasts. We will go over importing audio files, editing, recording, and playing back audio, then packaging and exporting the project. |
| Introduction to ArcGIS Online | The overall objective of the class: Discuss GIS basics and the concepts of map making; Explore some cool maps and discuss the data used and the story/analysis the maps are visualizing; Use an example topic to practice finding, adding, importing data and then use tools in ArcGIS to analyze the map; Create your own map by using a provided topic where you will be asked to find data, and analyze the map using ArcGIS tools. |
| Introduction to NVIVO (November 2020) | This module demonstrates NVivo 12, a qualitative analysis software. Module covers creating and importing data, coding and organizing theme nodes, and creating memos and annotation. Walk-through covers both Windows and Mac. |
| Open Source for Digital Communication & Learning Objects | Within this book, you will learn the necessary skills to create professional live streaming events, podcasts, and video content. Each section will provide a guide to understanding each of these open source technologies and methods of using them. While this book has a focus on digital communication and learning objects, there is no single way to create any of these media types. This book will provide you with techniques and features that are useful in the development of both digital communication and the development of learning objects. |
| Audacity 01 - FFMPEG Library | The optional FFmpeg library allows Audacity to import and export a much larger range of audio formats including M4A (AAC), AC3, AMR (narrow band) and WMA and also to import audio from most video files. Because of software patents, Audacity cannot include the FFmpeg software or distribute it from its own websites. Instead, use the following instructions to download and install the free and recommended FFmpeg third-party library. Advanced usage: If you already have Audacity-compatible FFmpeg 2.2.x or 2.3.x shared libraries in the system PATH, Audacity will use those as long as you do not install FFmpeg from the links below and as long as you do not specify the FFmpeg you want Audacity to use in Libraries Preferences. https://manual.audacityteam.org/man/installing_ffmpeg_for_windows.html |
| Sheets - M01 - L01 - The Basics | Understanding the basics about data. |
| OBS Studio 01 - Interface Intro | Introduction to the OBS interface |
| Excel - M01 - L01 - The Basics | Understanding the basics about data. |
| OpenShot 01 - Preparing Your Project | Preparing your project to be edited in OpenShot |
| OBS Studio 02 - Using Your Camera and Creating a Ticker | Using your camera and creating a ticker in OBS |
| Excel - M02 - L01 - Features of a Spreadsheet | Learn about features & components of a Spreadsheet and understand the difference between these features. |
| Sheets - M02 - L01 Features of a Spreadsheet | Learn about features and components of a Spreadsheet and understand the difference between these features. |
| OpenShot 02 - Video Playback & Navigation | Viewing your footage using video playback and navigation in OpenShot |
| Audacity 02 - Import Audio | Methods of importing audio files into Audacity |
| OpenShot 03 - Trimming Footage | Trimming your footage in OpenShot |
| Sheets - M02 - L02 - Technical Skills - Shortcuts 1 | Understand the use of Sheet's most common shortcuts |
| OBS Studio 03 - Starting Virtual Camera | How to start a virtual camera in OBS |
| Audacity 03 - Understanding Tracks | Tutorial and guide to how tracks work in Audacity |
| Excel - M02 - L02 - Technical Skills - Shortcuts 1 | Understand Excel's common and useful shortcuts. |
| Excel - M02 - L03 - Technical Skills - Shortcuts 2 | Understand Excel's common and useful shortcuts. |
| OBS Studio 04 - Creating a Headline Banner | Creating a headline banner for your production in OBS |
| OpenShot 04 - Layering Tracks & Making a Lower Third | How to layer tracks and making a lower third in OpenShot |
| Audacity 04 - Recording Audio | How to record audio directly into Audacity |
| Sheets - M02 - L03 Technical Skills -Shortcuts P2 | Understand the use of Sheet's most common shortcuts. |
| Excel - M03 - 01 Introduction to Data Types | Learn about data types, their importance and use and understand the difference between various data types. |
| Audacity 05 - Editing Audio | Methods of editing audio in Audacity |
| OpenShot 05 - Transitions & Effects | Adding transitions and effects to your footage in OpenShot |
| OBS Studio 05 - Using Display Capture and Recording | How to capture and record your display in OBS |
| Sheets - M03 - 01 Introduction to Data Types | Learn about data types, their importance and use. Understand the difference between various data types. |
| Excel - M03 - L02 - Formatting and Syntax | Learn how to format cells in Excel and understand various syntax applied to cells. |
| OBS Studio 06 - Using Window & Browser Capture | Using window and browser capture to watch a video with your participants in OBS |
| Sheets - M03 - L02 - Formatting and Syntax | Learn how to format cells in Sheets. Understand various syntax applied to cells. |
| Audacity 06 - Layer Tracks | Tips on methods of layering your tracks in Audacity |
| OpenShot 06 - Adjusting Audio | How to adjust your audio in OpenShot |
| OBS Studio 07 - Using Automatic Scene Switcher | Using automatic scene switcher in OBS |
| Sheets - M04 - L01 Date Formats | Learn how to format cells in Sheets. Understand various syntax applied to cells. |
| Audacity 07 - Saving Export | Saving and exporting your project and audio in Audacity |
| OpenShot 07 - Transforming Assets & Creating a Picture-in-Picture | Transforming assets and creating a picture-in-picture in OpenShot |
| Excel - M04 - L01 - Date Formats | Learn about calculation operators in formulas. |
| Sheets - M04 - L02 Extracting Dates | Learn to input dates and extract information from dates and use dates and formatting features to prepare unorganized data sets. |
| Excel - M04 - L02 - Extracting Dates | Learn how to divide a date into Days, Months, and Year columns. |
| OpenShot 08 - Understanding Properties & Keyframes | Tips for understanding properties and keyframes in OpenShot |
| OBS Studio 08 - Creating Panel Discussions with OBS Ninja | Creating panel discussions with OBS Ninja |
| Excel - M05 - L01 Sorting | Learn about Sorting data and identify Sort options and apply Sorting to a real-life dataset in Excel. |
| Sheets - M05 - L01 Sorting | Learn about Sorting data. Identify Sort options and apply Sorting to a real-life dataset in Sheets. |
| OpenShot 09 - Animating Objects Using Keyframes | Animating objects using keyframes in OpenShot |
| OBS Studio 09 - Adding a Remote Screen Share | Adding a remote screen share in OBS |
| Excel - M05 - L02 Data Filtering | Learn how to create header filters, how to filter your data, to Hide and Unhide columns. |
| Sheets - M05 - L02 Filtering | Learn shortcuts to turn filters on and off. Identify filter options and apply filter to a real-life dataset in Google Sheets. Learn to Hide and Unhide columns and rows. |
| OpenShot 10 - Exporting Projects; Closing Thoughts | Exporting Projects in OpenShot and some closing thoughts |
| OBS Studio 10 - Creating Live Captioning Using Google Slides | Creating live captioning using Google Slides for an OBS panel discussion |
| SimplyAnalytics 07 - Getting Help | Concluding thoughts on SimplyAnalytics and additional information on getting help |
| Excel - M06 - L01 Logical Operator SUMIF COUNTIF | Identify the purpose and uses of the IF, SUMIF, and COUNTIF function. |
| OBS Studio 11 - Using a Green Screen | Using a green screen to add a backdrop in OBS |
| Sheets - M06 - L01 Logical Operator IF SUMIF COUNTIF | Identify the purpose and uses of the IF function. Identify how to use SUMIF and COUNTIF. |
| Sheets - M06 - L02 - Logical Operators AND OR NOT | Learn what the AND, OR, NOT functions are. Understand how to apply AND, OR, NOT functions. |
| OBS Studio 12 - Using Media Sources | Sharing a locally stored video or audio source by creating a Media Source in OBS |
| Excel - M06 - L02 - Logical Operators AND OR NOT | Learn what the AND, OR, NOT functions are and understand how to apply AND, OR, NOT functions |
| OBS Studio 13 - Creating a Live Stream Profile | Create a live streaming profile in OBS Studio. |
| Sheets - M07 - L01 - Calculation Operators | Learn about calculation operators in formulas. |
| Excel - M07 - L01 - Calculation Operators | Learn about calculation operators in formulas. |
| Excel - M07 - L02 Cell References | Learn about cell referencing & different types of cell references used in spreadsheets and how to create formulas to perform calculations using cell references. |
| Sheets - M07 - L02 Cell References | Learn about cell referencing & different types of cell references used in spreadsheets. Learn how to create formulas to perform calculations using cell references. |
| Excel - M07 - L03 Basic Functions (Round, Int, Max) | Learn the functions ROUND, INT, and MAX. |
| Sheets - M07 - L03 Basic Functions - Round Int & Max | Learn Round, INT & MAX functions. Application of these functions to our dataset. |
| Sheets - M07 - L04 - Basic Functions Sum Average Count | Learn Sum, Average & Count functions. |
| Excel - M07 - L04 Basic Functions (Sum, Average, Count) | Learn how to use basic functions: Sum, Average & Count |
| Excel - M07 - L05 Aggregations | Learn about aggregations and understand how to group and filter flat data. |
| Sheets - M08 - L01 - Index Matching | Learn about INDEX and MATCH functions. Understand how to apply and combine the index and match functions to retrieve data from basic scenarios. |
| Excel - M08 - L01 - Index Matching | Learn about INDEX and MATCH functions. Understand how to apply and combine the index and match functions to retrieve data from basic scenarios. |
| Sheets - M08 - L02 - Vlookups | Learn about vertical lookups. Understand how to apply V Lookup functions to retrieve data from basic scenarios. |
| Sheets - M09 - L01 - Basic Chart Types | Learn how to create a chart. Learn about the different available chart types in Google Sheets. |
| Excel - M08 - L02 - Vlookups | Learn about vertical lookups. Understand how to apply V Lookup functions to retrieve data from basic scenarios. |
| Sheets - M09 - L02 - Modifying Charts | Learn how to customize a chart. |
| Excel - M09 - L01 - Basic Chart Types | Learn how to create a chart and about the different available chart types in Excel. |
| Sheets - M10 - L01 Pivot Tables | Learn how to set up a Pivot Table. Understand how to compare fields and filter data. How to use Google Sheets suggested pivot tables for your data. |
| Excel - M09 - L02 - Modifying Charts | Learn how to customize a chart. |
| Excel - M10 - L01 PivotTables | Learn how to set up a Pivot Table. Understand how to compare fields and filter data. Learn how to add additional levels to your pivot table. Understand how to change visual features like totals and subtotals. |
| Sheets - M10 - L02 - Pivot Charts | Learn how to set up a Pivot Chart. Understand how to visualize your source data in unique ways. |
| Excel - M10 - L02 PivotCharts | Learn how to create a PivotChart. |
