Artifact # 11
Competencies:
11.3: "Use technology based tools that are specific to the discipline"
12.2: "Use computers and other technologies effectively and appropriately to collect information on student learning using a variety of methods"
12.5: "Organizational and management strategies that support active student involvement, inquiry, and collaboration"
Context:
This artifact required me to make
a grade book spreadsheet by using Microsoft Excel. I made up five students
to be in my class and I made sections on the spreadsheet for homework,
tests, final exam and final grade. I also inserted a section for the average
class score.
After I made the chart I had to create
two graphs. I made one graph that showed the homework scores of each student.
I then made a graph that showed the homework, test and exam scores of each
student.
The last part of this artifact required
me to transfer the information from the spreadsheet into a word processed
document. I copied the spreadsheet and pasted it into the word document.
I then wrote a letter to a "principal" explaining why I was sending the
information and the significance of the information.
Impact:
I will have to use a program to calculate
and organize that grades of my students. Excel is an easy program to use
and it will be beneficial in organizing my student's grades.
I will have to be able to display
this information on to a word processed document in order to show the results
to other people. I will also have to display the information on graphs
so people can better visualize the information on the spreadsheet.
Alignment:
This artifact aligns with competency
11.3 by using Excel to perform a task directly related with the teaching
profession. This aligns with competency 12.2 by using Excel to organize
an display student's information and grades. This artifact aligns with
competency 12.5 by organizing and displaying student involvement.