Note: I will be making a few videos tutorials in the coming weeks to explain this process. For now, I wanted to post this so I could get some feedback on the structure/function, and use the feedback to strengthen the process. The package, including the tutorials, will be released Wednesday, August 24th.
What is the goal of this project?
- To make the tracking of student learning skills intuitive, timely, and relevant.
- To provide a free, open-source approach to tracking that can be improved and streamlined by other teachers.
What will be included in the package?
- A spreadsheet for tracking
- A few sample Word docs that demonstrate how the data from the spreadsheet can be published in a variety of ways.
Who is this for?
- While the spreadsheet could easily be adapted for users who have a wireless connection to Google Docs, Live365, or similar “clouds”, this process has been designed for teachers who do not have a wireless connection in the classroom.
- The spreadsheet is optimized for Ontario teachers. Still, the learning skills and other categories can easily be edited by teachers outside Ontario.
What can a teacher do with this?
- input learning skills (including things like homework completion) on a smartphone at the moment of observation
- input an observation of student behaviour (such as a short note about a student collaboration) and input the date of the observation
- since the spreadsheet tallies the number of E’s,G’s,S’s, and N’s, the task of assigning the final learning skill values for Report Cards and Progress Reports is much easier.
- since Excel data can be sent to Word via a mail merge, teachers can combine this spreadsheet with an electronic version of their board’s Progress Report, simplifying the reporting process. (this will be included in the upcoming video tutorial).
- similarly, a mail merge can be used to publish the student logs (including dates of observations) with a few simple clicks.
- finally, this package will make storage of information easier by taking advantage of two key aspects of smartphones: computing and USB-style storage. This means that by simply connecting a phone to a PC, a teacher will be able to edit/publish on the PC.
- Cutting and Pasting student names from a PDF or similar doc will populate the entire spreadsheet
- the “Name” column is frozen, meaning that the names of students remain visible as teachers move through worksheets
What apps are needed?
- You need an app that can run Excel and, optionally, Word. The spreadsheet does not use any macros, so this should make choosing an app more straightforward. (I am using ThinkFree Office on an Android. While I like the app, the main reason I chose it is because it came with my phone. )
- This spreadsheet can easily be adapted to formats that aren’t Microsoft dependent.