Evaluate and improve teaching programs
PROFICIENT 3.6.2
Evaluate personal teaching and learning programs using evidence, including feedback from students and student assessment data, to inform planning.
EVIDENCE
The NSW Department of Education and Training, Code of Conduct (2007) states that 'employees responsible for assessing and recording marks for students' must do so accurately, fairly and in a manner that is consistent with relevant policy...' and an effective way this can be done is through spreadsheets.
Spreadsheets are efficient and safe way to record student records, marks and progress. Not only is it easy to use and update, sections or the whole spreadsheet can also be displayed in a variety of ways including graphs and charts for visually clear picture, effective for both targeted individual information and a whole class analysis. I use spreadsheets as demonstrated below to inform my teaching as it enables me to easily identify student capabilities and from there determine the action depending on if a student is excelling or needing some extra assistance with a particular learning area. This information is vital for short and long term planning as It outlines the level and direction of the learning activities. Based on this information I can prepare lessons, group students and ensure students are working in the 'zone of proximal development' (Bozhovich, 2009). Mapping a students progress over a period of time, can be easily done through spreadsheets and this is important to see if students are improving or requiring invention in that area. Spreadsheets can also assist with recording such things attendance, student needs, medical information, completion of tasks, behaviour or other things such as who has recieved an award this term or been class leader.
Click here for a link to spreadsheet excel document
PROFICIENT 3.6.2
Evaluate personal teaching and learning programs using evidence, including feedback from students and student assessment data, to inform planning.
EVIDENCE
The NSW Department of Education and Training, Code of Conduct (2007) states that 'employees responsible for assessing and recording marks for students' must do so accurately, fairly and in a manner that is consistent with relevant policy...' and an effective way this can be done is through spreadsheets.
Spreadsheets are efficient and safe way to record student records, marks and progress. Not only is it easy to use and update, sections or the whole spreadsheet can also be displayed in a variety of ways including graphs and charts for visually clear picture, effective for both targeted individual information and a whole class analysis. I use spreadsheets as demonstrated below to inform my teaching as it enables me to easily identify student capabilities and from there determine the action depending on if a student is excelling or needing some extra assistance with a particular learning area. This information is vital for short and long term planning as It outlines the level and direction of the learning activities. Based on this information I can prepare lessons, group students and ensure students are working in the 'zone of proximal development' (Bozhovich, 2009). Mapping a students progress over a period of time, can be easily done through spreadsheets and this is important to see if students are improving or requiring invention in that area. Spreadsheets can also assist with recording such things attendance, student needs, medical information, completion of tasks, behaviour or other things such as who has recieved an award this term or been class leader.
Click here for a link to spreadsheet excel document
REFERENCES
Bozhovich, ED. (2009) Zone of proximal development. Journal of russian and east european psychology. p48-69
Department of Education and Training (2007) Code of Conduct, Fairness, respect, integrity and responsibility. Sydeny, NSW
Department of Education and Training (2015) Student mapping tool. State government Victoria. retrieved from: www.education.vic.gov.au/school/teachers/support/pages/smt.aspx?Redirct=1
Investingtech.com (2015) Teaching with technology: using microsoft excel in the classroom. Retrieved from: www.investintech.com/content/excelclassroom