Number of students
- Select and apply appropriate cell formatting and conditional formatting.
- Use formulas and functions (basic statistical, counting, conditional counting, logical functions, etc.).
- Visualize data and results.
- Select and use appropriate chart types and create graphs.
- Develop collaborative skills
- Develop communication skills.
- Develop time management skills.
- Quickly and easily create a stylish simple to mid-level spreadsheet application.
- Effectively collaborate with their peers.
Computer lab computers, video projector, Internet, Learning Management System (LMS), MS PowerPoint, MS Excel, Google Sheets, Excel Online, WiFi, TRs.
One or more students who cannot physically participate in the computer lab can be virtually present and participate via TRs.
Flipped Classroom: Students first study the educational material (content, resources) at home and then interact with the teachers and their peers in class. During the computer lab, the teacher answers questions and consults them to solve the assigned problem in spreadsheets.
Collaborative Learning: Groups of two or three students work together to solve the assigned problem in spreadsheets.
Problem Solving: Students are actively engaged with the assigned problem trying to find a solution. They look for possible sources of needed information, analyse it, learn new knowledge and apply it to solve the problem.
Lab-based Learning: Students apply their knowledge, practice their skills, and experiment with the spreadsheets. They observe, think, discuss and experiment with the assigned problem.
Before the Lesson:
- Decides which topic to present.
- Decides which problem to assign.
- Prepares the material regarding the topic and the problem.
- Uploads the material on the LMS.
- Books the computer lab.
- Set up the computer lab.
- Informs students who cannot be physically present that they can book and use a TR.
- Read the material on LMS.
- Prepare for solving problems in spreadsheets.
- Presents and explains the material.
- Presents and explains the problem to be solved by the students.
- Divides students in teams.
- Helps teams during problem solving.
- Attend the teacher’s presentation.
- Meet with their team partners.
- Read carefully the assigned problem.
- Exchange ideas with their team partners.
- Solve the problem.
- Presents and explains the correct solution to the problem.
- Identifies students’ errors and misconceptions.
- Discusses the problem solution with the students.
- Reflects on the material and the problem.
- Reflect on their knowledge and skills about spreadsheets.
- Reflect on their collaboration and their team partners.
Media and materials:
Teaching materials are in Greek and are stored in password-protected LMS.
Bibliography includes the following (in Greek):
Α. Οικονομίδης, Β. Καρατζόγλου & Θ. Χατζιδάκη (2018). Χρήση και Εφαρμογές του Excel στην Οικονομία και τη Διοίκηση – καλύπτει τις εκδόσεις 2007 του Excel, τα Google Sheets και το Excel Online, εκδόσεις Κλειδάριθμος.
Excel help & learning: https://support.microsoft.com/en-us/excel
Excel Easy: https://www.excel-easy.com/
Excel by Lifewire: https://www.lifewire.com/excel-4781563
Make data-driven decisions, in Google Sheets: https://www.google.com/sheets/about/
Get started with Google Sheets: https://edu.google.com/for-educators/product-guides/sheets/?modal_active=none
Google Sheets training and help: https://support.google.com/a/users/answer/9282959?hl=en
Author: University of Macedonia
This work is licensed under a Creative Commons Attribution-NonCommercial 4.0 International License.
How did this Teaching Scenario work for you?
Have you tried this or a similar Teaching Scenario?
Feel free to share your experiences with a comment below.
Possible questions for your evaluation of the TRinE Teaching Scenario
- What feedback / reflection was provided by the teacher?
- How is the feedback from the students?
- Why did you decide to use TRs?
- How did the TRs inform your lesson plan?
- What shifts or stretches are you making regarding the TRs?
Does the use of the Telepresence robots:
- align to learning outcomes?
- align to assessment?
- support your educational context?
- differentiate for individual students?
- enhance student thinking by addressing different levels of thinking?
- extend learning authentically beyond the classroom?
- increase engagement and active learning?
- promote and support collaboration?
- provide opportunities to construct knowledge?
Are the students participating / motivated / progressing?
Share your Teaching Idea!
Do you also have experience with telepresence robots in education? Contact us and share your teaching idea! We are happy to publish it as a guest article on our website.