IT Learning and Development
View Menu
Excel: Data Management

Excel: Data Management

In this hands-on workshop, participants will become familiar with the basic tools for data management in Microsoft Excel 2016. Participants learn how to import, extract, and manipulate spreadsheet data. Participants will also use some of Excel’s tools to help manage multiple worksheets, visually compare workbooks, and work more efficiently in Excel.

Objectives

• Create tables and pivot tables
• Explore workbook and worksheet protection
• Import, sort, filter and validate data
• Create built-in and custom lists

Faculty
Staff
Students
Live Training: Online
Data
Microsoft Excel
Microsoft O365
Kaltura and Zoom: Using Video to Recover Lost Class Time

Kaltura and Zoom: Using Video to Recover Lost Class Time

Snow day? Are you or your students sick? Students missing prerequisite skills? With Kaltura and Zoom, you can breathe easy knowing you can recover lost class time.  In this session, participants will learn strategies to keep students engaged and accountable for missed material.  Create reusable lectures with automatic chapters and slides allowing students to find exactly what they need, when they need it. Learn to use Kaltura Capture to create picture-in-picture videos giving students the flexibility to personalize the viewing experience.  Create Video Quizzes to ensure that students are engaged and interacting with your lecture recordings.

Objectives

  • Develop learning materials, including videos which chapters and slides, picture-in-picture videos, and video quizzes
  • Select the best way to deliver video-based learning materials to your students
  • Use video analytics to evaluate interaction and effectiveness
Faculty
Live Training: Online
Teaching and Learning
Zoom
Kaltura
LinkedIn Learning: An Introduction

LinkedIn Learning: An Introduction

Are you interested in developing your business, technology, or creative skills? Do you want to create curated lists of related video resources to share with others? LinkedIn Learning (formerly Lynda.com) is an online repository with 10,000+ high-quality video resources available to all current students, faculty, and staff at Penn State. This one-hour online session will help introduce you to the new LinkedIn Learning, including how to log in, find the right content, and share with others.

Faculty
Staff
Live Training: Online
Teaching and Learning
LinkedIn Learning

LinkedIn Learning: Learning Path

Submitted by lek136 on Mon, 07/29/2019 - 12:57
LinkedIn Learning (LIL) is an online collection of high-quality, self-paced videos and courses for all Penn State students, faculty, and staff. This LinkedIn Learning: Learning Path supports those who want to use LIL for their personal or professional development or with students for teaching and learning. Resources in this learning path are designed to help you work your way through the login process, find and share meaningful content, and manage your own learning.
Faculty
Staff
Learning Path
Teaching and Learning
LinkedIn Learning

Office 365: Excel Learning Path

Submitted by bxb11 on Fri, 01/19/2018 - 10:08
This Excel Learning Path supports all Penn State faculty, staff, and students using Microsoft Excel. Although you probably already know how to use Excel, this learning path teaches you how to do it within Office 365. Follow in the order of the modules or choose individual topics to review.
Faculty
Staff
Students
Learning Path
Collaboration
Data
Microsoft Excel
Microsoft O365

Office 365: OneNote Learning Path

Submitted by kaw160 on Thu, 02/15/2018 - 09:55
This OneNote Learning Path prepares Penn State faculty, staff, and students to take, organize, and share notes with others within Office 365. Follow this learning path in order of the modules or choose individual topics to review.
Faculty
Staff
Learning Path
Collaboration
Communication
Teaching and Learning
Microsoft O365
Microsoft OneNote

Office 365: Outlook Learning Path

Submitted by lek136 on Mon, 10/30/2017 - 14:44
This Outlook Learning Path supports all Penn State faculty, staff, and students using Outlook. Although you probably know how to use email and calendars in other systems, this learning path is designed to teach you how to do it in Office 365. Follow this learning path in order of the modules or choose individual topics to review.
Faculty
Staff
Learning Path
Collaboration
Communication
Other
Microsoft Outlook
Microsoft O365

Office 365: Sharing and Collaboration Learning Path

Submitted by lek136 on Fri, 01/19/2018 - 15:41
This Sharing and Collaboration Learning Path supports all Penn State faculty, staff, and students wanting to share and collaborate on files. Choose the appropriate tool to fit your needs. Find additional information about using Microsoft tools like OneDrive for Business, Groups, Teams, and SharePoint Online.
Faculty
Staff
Learning Path
Collaboration
Communication
Microsoft Outlook
Microsoft Teams
Microsoft SharePoint
Microsoft OneDrive
Microsoft O365

Zoom Learning Path: For Hosts

Submitted by ldu2 on Thu, 03/29/2018 - 15:33
This Zoom Learning Path supports all Penn State faculty, staff, and students who host Zoom meetings. Whether you are new to video and web conferencing, or just new to Zoom, this Learning Path teaches you how to host meetings and webinars through Zoom. Follow this learning path in order of the modules or choose individual topics to review..
Faculty
Staff
Students
Learning Path
Collaboration
Communication
Zoom

Zoom Learning Path: For Participants

Submitted by ldu2 on Fri, 03/02/2018 - 09:16
This Zoom Learning Path supports all Penn State faculty, staff, and students who use Zoom. Whether you are new to video and web conferencing, or just new to Zoom, this Learning Path teaches you how to to participate in Zoom meetings and webinars. Follow this learning path in order of the modules or choose individual topics to review.
Faculty
Staff
Students
Learning Path
Collaboration
Communication
Zoom

Pages