Lynda.com – Office for Educators (2013) [59 MP4]

Teachers, your time is valuable. Learn to reduce your workload, streamline grading and lesson planning, and share resources with students and other teachers with Microsoft Office. Aaron Quigley teaches you how to use Word’s templates to create lessons and worksheets more efficiently, use Track Changes to digitally grade papers, build gradebooks in Excel, give presentations from PowerPoint, collaborate over SkyDrive, and connect using Outlook and SharePoint. These lessons are explored using sample lessons, homework, and tests like you’d find at a real-world school. And at the end of each section, Aaron invites you to test what you’ve learned in a video challenge.

Topics include:

Creating lesson plan templates
Creating worksheets with math equations, charts, and graphs
Grading papers
Creating a gradebook in Excel
Creating an animated presentation
Setting up a school email account in Outlook
Storing documents online with SkyDrive
Creating a class website with SharePoint

1. Overview of Office for Educators
1m 37s

Exploring Office versions
33s

Using Office as an educator
36s

Using Office desktop and online applications
28s

2. Using Word: Lesson Plan Templates
7m 24s

Creating lesson plan templates
3m 25s

Adding form-field placeholders
3m 59s

3. Using Word: Worksheets and Handouts
13m 11s

Formatting headers and footers
3m 9s

Using AutoText
2m 9s

Writing math equations
3m 34s

Using charts and graphs
4m 19s

4. Using Word: Efficient Grading
13m 20s

Using tables to create rubrics
4m 21s

Grading papers with Track Changes and Comments
3m 49s

Creating grade reports with mail merge
5m 10s

5. Word Challenge
4m 23s

Challenge: Create a worksheet template with a dropdown menu
49s

Solution: Create a worksheet template with a dropdown menu
3m 34s

6. Using Excel
40m 51s

Creating a gradebook
1m 3s

Understanding cells
2m 50s

Creating the gradebook layout
3m 29s

Creating a dropdown list of assignment types
3m 36s

Writing the grade calculation functions
5m 44s

Using conditional formats
5m 45s

Setting the print area
3m 17s

Adding headers and footers
2m 28s

Adding list sorting
2m 38s

Freezing frames and cleaning up
2m 43s

Replicating sheets
2m 0s

Challenge: Write a conditional format
58s

Solution: Write a conditional format
4m 20s

7. Using PowerPoint
35m 28s

Creating a PowerPoint presentation
22s

Selecting and modifying templates
4m 1s

Enhancing student engagement with animations
6m 37s

Utilizing transitions
4m 42s

Adding graphs and charts
4m 17s

Adding and configuring media
4m 18s

Creating handouts and posters
4m 10s

Configuring presentation settings
3m 13s

Challenge: Fade transitions to simulate animated graph elements
37s

Solution: Fade transitions to simulate animated graph elements
3m 11s

8. Using Outlook
8m 57s

Adding a school email account and syncing to a remote calendar
40s

Setting up email accounts
22s

Creating calendars by class
3m 2s

Contact notes and groups
2m 22s

Challenge: Adding an online calendar
47s

Solution: Adding an online calendar
1m 44s

9. Using SkyDrive
13m 4s

Creating centralized file storage
3m 59s

Creating a home-office-to-school workflow
1m 13s

Surveying students
3m 59s

Challenge: Create a shared phone log using a survey
54s

Solution: Create a shared phone log using a survey
2m 59s

10. Using SharePoint
14m 32s

Creating a class website
31s

Using SharePoint to share information
42s

Student collaboration
3m 58s

Teacher collaboration
5m 21s

Challenge: Add a grading rubric to a SharePoint student site
49s

Solution: Add a grading rubric to a SharePoint student site
3m 11s

Conclusion
41s

Next steps
41s