Over the last two weeks, we have been working with online spreadsheets and discussing software evaluation. I am fairly comfortable with spreadsheets as I have used them often in my classroom, but there are always new things to learn when using a new software.
I have used Microsoft Excel for many things in my own life. I coach track and field and use spreadsheets to track athletes' personal records and points earned throughout the season. In my classroom, I use spreadsheets often in Accounting. The spreadsheets become a valuable tool for the students. Once we cover basic accounting principles and the students become comfortable doing problems written, I then require them to work with spreadsheets for many problems. I create the form they will be using, and they fill in the required information and the formulas needed in the spreadsheet. The spreadsheets make journalizing and posting transactions much faster and prevents errors in math. The students also use spreadsheets for the financial statements. Again, I create the forms and they enter the appropriate information and formulas. By using these spreadsheets, students see there is another way of doing accounting. I also use spreadsheets in Personal Finance when the students are creating budgets. The spreadsheet allows them to use categories for income and expenses. The students can then use a formula to total each section and then subtract the totals to balance their budgets. It is very easy for them to then change the numbers the next month.
Where I teach, teachers are responsible for evaluating software and submitting a request to purchase the software. On the form, the teacher must indicate for what class the software will be used, how the software aligns with curriculum and what learning objectives will be reached by using the software, who will be using the software and where it will be used, how many copies of the software are required for purchase, and hardware/software requirements. The form is then submitted to the district technician for approval. If it is approved, the form must be attached to any requisition form to be approved by administration. It is a good process since the teacher is the one requesting the software and knows it is valuable to their curriculum. It also is a good process because the technician is consulted to see if the servers and computers have the capabilities required by the software.
This week's lessons have been very valuable for me and could easily be used in my classroom.
