Artifact # 15
Competency 11.3: Use technology-based tools that are specific to the
discipline.
Competency 12.2: Use computers and other technologies effectively and
appropriately to collect information on student learning using a variety
of methods.
Competency 12.5: Organizational and management strategies that support
active student involvement, inquiry, and collaboration.
Context: I made a spreadsheet using Microsoft Excel that I will be able to use to average grades when I begin teaching. I used these basic computer signs to make formulas in the spreadsheet: =, +, *, -, /, average, and parenthesis to weight grades. I then printed out two different graphs that display the data in a more eye-pleasing manner. Then I copied part of the spreadsheet and pasted it in a short letter to one of my student’s parents.
Impact: As a teacher, doing grades on a spreadsheet will save me time and energy. Being able to copy and paste a portion of the spreadsheet will enable me to keep grades as confidential as possible.
Alignment: Spreadsheet work in Microsoft Excel is a technology
based tool that is makes figuring out grades less time consuming so it
aligns with competency 11.3. Competency 12.3 is met because making a spreadsheet
of grades and converting the information is collecting information on student
learning. Competency 12.5 is met because graphing, spreadsheets and
letters home are all organizational and management strategies.