Under construction
I am focusing this artifact on the Collaborator ISTE Standard 2.4.b Learn Alongside Students.
This artifact demonstrates competency by having students collaborate in groups and explore some unique, and possibly hidden, features in Excel. This lesson falls just after a basic lesson in Excel/spreadsheet terminology, and basic Excel uses including cell references and basic formulas. It is designed to challenge students to find out something new in Excel and demonstrate/teach it to the rest of the class -- so we are all learning together.
Background: Taught in the "Live Online" format, this Introduction to Computers course is delivered synchronously via Zoom. Students are very accustomed to working with Zoom, sharing their screens, and using Breakout Rooms.
Results: At the end of this class period, students shared their findings. Some picked some "standard" spreadsheet functionality to share and others. I learned alongside the students -- I didn't know you could translate to Spanish and draw diagonal lines across cells! Students were very actively participating as I visited the breakout rooms, and were a bit more motivated to learn about Excel.
April 1, 2021
Assign Teaching Assistants (TAs) - Zoom TAs monitor the chat and ensure screens are shared correctly.
Go over the new rubric for TAs.
Place the link to the Google Doc with the "Can you Excel in Excel?" assignment in the Zoom chat.
Explain the "Can you excel in Excel?" assignment (below 1st page). Make sure students understand how to use the Google Doc. Explain that students may use Excel or Google Sheets.
Assign students to breakout rooms.
Set an initial timer to 20 minutes.
Go to each Zoom Breakout room to check on the understanding of the assignment and if there are any questions.
Switch between breakout rooms as help is requested.
Monitor Google Doc to see how the groups are progressing (the Google Doc below is the result of the session. Visit those who are behind.
Check to see if more time is needed at 20 minutes.
Have breakout rooms present their findings.
The rest of class time is spent in the Virtual Office for questions as students work on their labs.