Managing Student's Grades and Attendance Records using Google Forms and Google Spreadsheets

Abstract Google Spreadsheet is a powerful tool to manage student record online. It is more than a Web 2.0 version of Microsoft Excel as it performs many functions that are not available in Excel. One of many uses of Google Spreadsheetsthat could be useful to lecturers is managing students’ grades and attendance online. In this paper the author wishes to present his innovative ways of managing students’ grades and attendance records using the wonder of Google Spreadsheet. In order to experiment with the Google way of doing things, the author embarked on a self-directed learning journey of discovering the functionality of the tools. By immersing himself with hundreds of syntax used to create functions in Google Spreadsheet, he managed to create a number of potential useful innovations, one of which is the management of students’ grade and attendance record. In this paper, he wishes to share his recent experience of experimenting the innovation with a group of students in UKM. In conclusion, Google Forms and Spreadsheet not only offer the more innovative ways of of managing students ‘grades and attendance records but also provide a useful platform for exploring and experimenting with Google Spreadsheets’ functions.