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 students learning using a variety of methods.”
Competency 12.5: “Organizational and management strategies that support active student involvement, inquiry, and collaboration.”
Context
I used Microsoft Excel to create a spreadsheet to use when I begin my career. I chose to create a spreadsheet to average grades so I would learn how to manipulate grades as I begin my career. I put my name at the top by creating a custom header. I made up students names and gave them imaginary grades that I could average in a spreadsheet. I then chose to weight each grade individually by creating a formula to place in the cells that required a total. I then printed the spreadsheet twice: one with the formulas showing, and one without. I then used this spreadsheet to create two graphs to display the data. I also printed these graphs. I then copied part of my spreadsheet to the clipboard and pasted it in a letter to a principal using Microsoft Works.
Impact
After creating a spreadsheet that simulates what I will be using as a teacher, I now feel confident in using spreadsheets to manipulate data from my students in a classroom. This also gives me the opportunity to understand the use of spreadsheets to use with many different kinds of data, like spreadsheets for my student’s use, average speech clinic tests, or analyze coaching statistics.
Alignment
I have created a spreadsheet and charts to use in my future career as a teacher and have met competency 11.3. I have used computers to compile information from my student’s learning so I have met competency 12.2. Competency 12.5 was met by making a chart that shows my student’s progress.