Spreadsheets

Charlestown Adult Education

TAGS: #InstructionalRoutine #Spreadsheet #GoogleSheets #CAE

WHAT: Create an online lesson/unit glossary for students using a spreadsheet program that includes content vocabulary, pronunciation prompts, and images.  Students/teachers will be able to communicate via a comment field.

WHY: Transferrable, independent language learning skills. Provide learners with relevant vocabulary in an accessible format online to enhance learning and provide opportunities to review and practice what was learned in class.  Students can apply these skills while working independently and add words to their glossary as they discover new words.  Learning new vocabulary is key to understanding every subject and builds confidence in future learning and skill acquisition.  

Connected Evidence-Based Strategies | This strategy connects to the following evidence-based strategies:

• Accessible vocabulary and syntax

• Explicit Instruction: Vocabulary

• Multimodal Instruction

HOW | Google Sheets 

• Create a Google Sheet with key vocabulary words from each lesson.  The document will contain the following fields:

  • Word(s)  

  •  Image        

  • Pronunciation  

  • Usage/Example          

  • Comments/Questions

• Lock all fields except for the Comments.  This will provide communication between students/teachers/peers if needed to clear up any problems or misunderstandings.

• Allow forced copy to allow learners to add new words and personalize their glossary

• Key vocabulary will be added to the sheet after each lesson so that by the end of the year, students will have a complete glossary of terms.

The glossary will be stored in the same google drive folder as the class materials, accessed via the class QR code.

DIGITAL SKILLS | Implementing this strategy connects to the following digital skill(s):

• CO.2: Collaborate with Technology

• CO.7: Share Information with Others

• EF.6: Save & Find Documents

• IS.2: Access Information Sources

• WO.8: Create Spreadsheets

X-Cel Education

TAGS: #Spreadsheets #GoogleSheets #XCelEducation

WHAT | Use spreadsheets for attendance, study hours, and progress tracking.

Learners use an online spreadsheet to mark their attendance, log study hours, and track progress. Progress tracking may include class notes, links to content, and/or other evidence that works for the learner. 

WHY | Self-Monitoring and digital literacy

By setting up a spreadsheet to help learners keep track of their attendance, study hours, and what they learn in class each week, the students are given the chance to build base skills and comfort with spreadsheets. They will also be able to use their spreadsheet to help them review something they learned in class if the need arises.

Connected Evidence-Based Strategies | This strategy connects to the following evidence-based strategies:

• Spaced Learning

• Self-monitoring

HOW | Google Sheets: The instructor will guide students through the process of creating a spreadsheet. Students will then access their individual spreadsheets at the end of the class sessions and log their attendance, hours, or time spent, along with evidence of learning for that day. Students will tag their instructor to notify them so the instructor can check it; once checked, this can be used as an exit ticket.

DIGITAL SKILLS | Implementing this strategy connects to the following digital skill(s):

• WO.8: Create Spreadsheets: Spreadsheets are useful tools that can be used in various ways to assist us at work, school, etc. This routine helps students build base skills and comfort with this tool. It will help prepare them for learning the more advanced uses of spreadsheets and the use of local and cloud storage tools.

• OL.10: Save and Manage Content: Saving and managing content from different devices is an essential skill in our society. By consistently saving and updating their progress through the use of a spreadsheet, this skill will become second nature to them over time since they’ll need to use the spreadsheet repeatedly.