Using Google Sheets for Online Collaboration in Education
Collaboration is becoming increasingly important in education as teachers and school teams work together to manage information, plan learning activities, assess learners, and coordinate school programmes.
In Episode 26 of the EduTech Teachers Network (ETN) EdTech Exchange, educators explored how Google Sheets can support online collaboration, particularly in situations where several people need to work on the same information remotely and in real time.
The practical session was led by Mr. Julius Muwaya, an ICT teacher and trainer, who guided participants through the concept of online collaboration and demonstrated how Google Sheets can be applied to everyday school activities.
Understanding Online Collaboration
The session began by introducing the concept of online collaboration and its relevance to education.
Julius explained how digital platforms can allow educators to work together even when they are in different locations. Rather than sending different versions of a document back and forth, collaborators can work on a shared file, making updates and accessing information from a common location.
For schools, this approach can support activities such as collecting learner information, managing assignments, recording scores, preparing reports, and coordinating tasks among teachers.
Google Sheets as a Collaboration Tool
A major focus of the session was the use of ‘Google Sheets’ as an online collaboration platform.
Participants were introduced to features that make Google Sheets useful for teamwork, including:
- Real-time editing – multiple users can work on the same spreadsheet.
- Sharing and access permissions – users can control who can view or edit a document.
- Comments and communication – collaborators can communicate around shared information.
- Cloud storage – information can be accessed online rather than being confined to one computer.
- Link sharing – a spreadsheet can be shared with others using a link.
The session demonstrated how these features can support teachers who need to work together on common school data.
Hands-On Collaborative Activity
The training was designed as a practical learning experience rather than a purely theoretical presentation.
Participants were guided to create and access a shared Google Sheet and enter information collaboratively. Julius demonstrated the process of creating a spreadsheet, entering data, changing access permissions, copying the sharing link, and inviting others to participate.
Participants then worked together on a sample ‘student scores spreadsheet’ , with different educators taking responsibility for entering scores for different subjects.
This practical activity demonstrated how teachers can work on the same dataset remotely without needing to be physically present in the same location.
Applying Google Sheets to Student Assessment
One of the practical examples explored during the session was the management of learner scores.
Julius demonstrated how teachers could use spreadsheets to organize student marks and calculate results using formulas. The session included demonstrations of:
- Addition of scores.
- Calculation of averages.
- Cell references.
- Absolute cell references.
- Ranking students according to their scores.
- Sorting and organizing learner data.
The RANK function was demonstrated as a way of calculating student positions, while the use of absolute cell references was explained for situations where specific cells or ranges need to remain fixed when formulas are copied.
From Offline Excel to Online Collaboration
The discussion also considered the difference between traditional offline spreadsheet work and cloud-based collaboration.
While Microsoft Excel remains useful for many school activities, Google Sheets provides an additional advantage when several people need to access and update the same information remotely.
For school teams, this can reduce the challenge of maintaining multiple versions of a document and make it easier for authorized users to access updated information.
The session also highlighted the importance of helping teachers develop basic digital collaboration skills, particularly where some educators may have limited experience with tools such as email and online platforms.
Supporting Online Report Card Development
Another practical application discussed was the use of spreadsheet data in developing ‘online report cards.’
Julius shared work involving the organization of learner scores and the development of a marker sheet that could support report card generation.
This demonstrated how spreadsheet skills can form part of a wider digital workflow for school assessment and reporting.
The discussion reinforced the importance of training teachers not only to enter data but also to understand how digital tools can connect different stages of the assessment and reporting process.
Learning Beyond the Live Session
The EdTech Exchange session was recorded and shared through ETN’s online platforms, allowing educators who could not attend live to access the content later.
This supports ETN’s wider approach of creating continuous learning opportunities for educators through online communities, recorded sessions, workshops, and practical training.
Participants were also encouraged to join the ETN community and continue developing their digital skills through future sessions and activities.
Upcoming ETN Training Opportunities
The session concluded with information about upcoming ETN activities, including a workshop in Kampala focusing on digital portfolios and e-learning tools.
The announced training areas included:
- WordPress
- Microsoft Teams
- Zoom
- Artificial Intelligence tools
- Digital portfolios
- E-learning
Participants were encouraged to follow ETN communication channels for registration details and other upcoming opportunities.
Continuing the Digital Collaboration Journey
The practical Google Sheets session demonstrated that effective digital transformation in schools does not always require complex systems. Simple, accessible tools can make a significant difference when educators understand how to use them collaboratively.
By learning to create, share, edit, organize, and analyse information online, teachers can strengthen teamwork and improve the way school data is managed.
Through the EdTech Exchange, ETN continues to provide a platform where educators can learn practical digital skills, share experiences, and explore technology solutions that can be applied in their schools.
Watch the Full Session
Watch the full recording of ETN EdTech Exchange Episode 26 below and follow along with the practical demonstration of Google Sheets collaboration.
About EduTech Teachers Network
EduTech Teachers Network (ETN) is a professional community supporting educators to effectively use technology in teaching, learning, school administration, and innovation.
Through EdTech Exchange sessions, workshops, mentorship, professional learning communities, and resource sharing, ETN continues to support educators in building practical digital skills and transforming education one click at a time.
Leave a Reply