2014
Lynda
Aaron Quigley
2:45
English
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.
Introduction
Welcome
Using the exercise files
Office at Orange Valley School
What you should know before watching this course
1. Overview of Office for Educators
Exploring Office versions
Using Office as an educator
Using Office desktop and online applications
2. Using Word: Lesson Plan Templates
Creating lesson plan templates
Adding form-field placeholders
3. Using Word: Worksheets and Handouts
Formatting headers and footers
Using AutoText
Writing math equations
Using charts and graphs
4. Using Word: Efficient Grading
Using tables to create rubrics
Grading papers with Track Changes and Comments
Creating grade reports with mail merge
5. Word Challenge
Challenge: Create a worksheet template with a dropdown menu
Solution: Create a worksheet template with a dropdown menu
6. Using Excel
Creating a gradebook
Understanding cells
Creating the gradebook layout
Creating a dropdown list of assignment types
Writing the grade calculation functions
Using conditional formats
Setting the print area
Adding headers and footers
Adding list sorting
Freezing frames and cleaning up
Replicating sheets
Challenge: Write a conditional format
Solution: Write a conditional format
7. Using PowerPoint
Creating a PowerPoint presentation
Selecting and modifying templates
Enhancing student engagement with animations
Utilizing transitions
Adding graphs and charts
Adding and configuring media
Creating handouts and posters
Configuring presentation settings
Challenge: Fade transitions to simulate animated graph elements
Solution: Fade transitions to simulate animated graph elements
8. Record PowerPoint Presentations
Installing the plugin
Recording your presentation
Adding video
9. Using Outlook
Adding a school email account and syncing to a remote calendar
Setting up email accounts
Creating calendars by class
Contact notes and groups
Challenge: Adding an online calendar
Solution: Adding an online calendar
10. Using SkyDrive
Creating centralized file storage
Creating a home-office-to-school workflow
Surveying students
Challenge: Create a shared phone log using a survey
Solution: Create a shared phone log using a survey
11. Using SharePoint
Creating a class website
Using SharePoint to share information
Student collaboration
Teacher collaboration
Challenge: Add a grading rubric to a SharePoint student site
Solution: Add a grading rubric to a SharePoint student site
Conclusion
Next steps
http://www.lynda.com/
Download File Size:414.77 MB
|
