Almost a month ago I introduced the CLASS-MON spreadsheet Add-on. I have to admit that it has been better received than I expected. It is currently installed by just over 11000 users (source: G Suite Marketplace). Today I present an update that basically improves two aspects.
Although CLASS-MON is designed more to make students think about the tasks they are doing than to give feedback from the teacher, as the add-on gives the teacher the possibility to evaluate the tasks, I have added the possibility for the teacher to also enter comments.
Simply, in the same cell where you enter the rate of the assignment, you can use the Insert note option, which is displayed with the right mouse button.
For some students, it is also interesting to help them learn to self-regulate their work time in the classroom. Do they use their time? Do they concentrate and work? Do they get lost all the time?
CLASS-MON can also help us in these cases. When the template is created, CLASS-MON now offers the possibility of Activities (which is the template until now) and the possibility of Attitudes has been added.
The template basically differs in the options it offers in the form.
The student evaluates himself/herself with respect to the attitude and work in the classroom. Instead of introducing activities we will introduce sessions. At the end of each session, the student reflects on how he or she has worked and indicates this on the form. The teacher can also evaluate it and in this way the student compares whether his or her perception coincides with that of the teacher.
The experience of using similar tools (follow-up sheets, daily work grids…) in a significant percentage of the students has an important impact, as long as it is limited to a number of specific sessions. If it is taken as a habit, then it ceases to have an effect.
This is the first update, but I’m sure it won’t be the last. I have started to receive feedback from teachers who have started to use it and this provokes new ideas and new functionalities. Little by little I will try to improve the tool.
This course we have begun to use in a habitual way and more or less systematic the single-point rubrics. I speak in the plural because it is not only my own thing, but also that of the teachers of my school who work on projects in the 4th year of ESO.
For those of you who do not know single-point rubrics (here the link from where I knew them), they are nothing more than usual analytical rubrics, where only the expert level is indicated and, instead of evaluating by selecting a level, it is necessary to write down which points of each aspect must be improved to become an expert and which points are already correct. In the link you can see different models.
Next, one of the ones we use to evaluate the students’ portfolio.
Continue reading “Single-point rubric: Automate sharing with students”
CoRubrics launches new version. Fixes detected errors and adds a new option. Now allows you to display the results in radar charts.
One of CoRubrics’ weaknesses was sending the results to the students. It was difficult for young students, especially in primary school, to understand the numbers in the rubric. This new version includes the option to also send a radar chart.
Continue reading “New CoRubrics functionality: radar charts”
All of us who work mainly in the cloud (in my case, almost exclusively) have heard comments like: “It’s great to have all the information in the cloud, but the day you don’t have the internet you won’t be able to do anything”. This statement has not been true for a long time now, but it’s okay to remember it and see how to set it all up so that we can really work when we don’t have access to the network. In this article we will see how to access documents, presentations and spreadsheets in Google format that we have on Drive and how we can work. It is necessary to specify that, for the moment, we can only work with these 3 types of files. Therefore, without connection we will not be able to work with sites, forms, drawings, mymaps, etc.
Continue reading “Working with Google documents offline”
A couple of days ago, Alice Keeler (@alicekeeler) published a post (Google Sheets: Embed an Image) about the =IMAGE() function to insert images into a spreadsheet. It is a function that allows you to embed an image that is public on the Internet inside a cell. I encourage you to read her post.
With this function you can only embed images that are on the internet in a public way. But what if we want to insert photographs that we don’t want to publish? For example, what if we have created a pupil tracking sheet and we want that their pictures appear? In this article I show an option that can complement Alice’s article.
Continue reading “Inserting private images into a Google Sheet”