Where can I see a list of all your lessons?

The features mentioned in this article are available to all Teachers on paid and free subscriptions. However, only a limited number of lessons are available on free subscriptions.

Introduction

👉 You can navigate to the spreadsheet here. 👈

We have now constructed this spreadsheet to make the contents of our Lesson Library, over 1,300 lessons, easily accessible so that you can tailor them to your needs.

This Lesson Library Spreadsheet provides a summary of all lesson in the Off2Class Lesson Library. It also offers user-friendly navigation of the content for easy searching.

Objectives are listed for each lesson in our Lesson Library. Objectives help teachers define learning outcomes for a lesson and allow teachers and students to track and assess what students learn during a lesson. For lessons that are part of a progressive module, such as lessons in our Step-by-Step Curriculum, information about the Unit is also shown to explain sequencing.

In the Lesson Link column, links for each lesson are shown. These allow easy access to each lesson for quick teaching without navigating through the Lesson Library manually.

How to use the spreadsheet

First, download a copy of the sheet (File --> Download) to access the full range of search and filter features.
To access the Lesson Library data, click on the Lesson Library tab at the bottom of the spreadsheet. You can then toggle between the Curriculum Lessons tab and How to use this sheet tab as needed.
The spreadsheet clearly outlines the entirety of the Off2Class Lesson Library, with searchable filters for Level (absolute beginner to advanced) and Lesson Category.
To change the framework used to display levels, use the Framework drop-down menu in the top-right corner of the spreadsheet. This changes the terms used in the Level column to those of the selected framework.
The ability to perform searches for words and phrases, as explained on the top rows of the spreadsheet, gives users the versatility to explore the content of the Lesson Library. For example, a search for discuss would highlight in green each instance of discussions in the entire Lesson Library. See Tips below for how to use the spreadsheet effectively in your classes.

Tips

💡Institution administrators: Scroll the entirety of the spreadsheet to familiarize yourself with the scope of the content. Search the spreadsheet for key words to verify which lessons or units match your syllabus needs. Refer to Objectives and Can-do Statements for context.
💡Teachers: Use Objectives to define learning outcomes for your students and gauge their progress. Clear objectives let students know that there is a reason for the exercises and activities that come in a lesson. As students work through each lesson and complete homework, use the objectives to track ability, before culminating in assessment, such as the Unit Check. Understandably pause and review as needed if any student isn’t achieving lesson goals.
💡Teachers: You will notice that the Objective statements in the spreadsheet often begin with Learn, Review, Practice, or Expand understanding. These words hint at students’ predicted knowledge of a grammar point at the given level and will guide you to effectively move toward specific goals. For example, the objective for Lesson 64 of the Step-by-Step Curriculum states Review conditional forms; however if you see that your student is struggling, it may be necessary to turn to an earlier level that covers the topic in more detail. At the end of the lesson, return to the Objectives and have the student(s) confirm that they have achieved the goal. If they have not, determine what they still need to review.
💡Teachers: You may choose to offer your students Objectives as a self-assessment tool. At the start of every unit, send your students the list of Objectives for each lesson in the unit. They can check off the items they can do as they progress through a unit. Such consistent active measuring of one’s progress can empower a student and inspire accountability for learning.
💡Teachers: When you incorporate Objectives into a lesson, encourage discussion and give feedback--before, after, and during a lesson. Help students identify what they already know, skip topics if review is deemed unnecessary, and slow down and supplement if any students are struggling.
💡Teachers: Search and find the spreadsheet for the word write to pull up the variety of writing topics presented in the curriculum. Refer to the Objective for more details about a particular writing task. Similar searches can be performed for other types of activity.