Spreadsheets Unit

  • Uncategorized

PEDAGOGY

Spreadsheets

Unit

Instrutcor

Spreadsheet is one of the programs in major computer operating systemprograms in the market such as the Windows. The application allowsindividuals to create and store data in tabulated formats in a mannerthat it can be manipulated easily. In my experience in using andteaching the use of the program of various purposes, I have employeddifferent strategies to develop various skills among students.Looking back, I can identify and map some of these cognitive skillsin Bloom’s revised taxonomy chart, more so the higher level skills.For the purposes,

Evaluating:

  1. Choice of formula

In teaching such aclass, one such strategy to reinforce evaluating capabilities inlearners in a spreadsheet classroom would entail making them justifythe use of certain formulas as opposed to others. They should alsoweigh on applying the formula in spreadsheet as opposed to manualmethods. The learners should be capable of identifying variousformulas shown to them and indicate where such formulas can be used.Simple formulas include in the program were very important to them.However, when introduced the standard variation formula, somestudents were surprised that there is exists manual methods ofcalculating it. This was my Ah-Ha moment that affirmed the role oftechnology in learning.

  1. Creation of new worksheets

Learners have tojustify why they feel that they should create new worksheets. Byintroducing existing spreadsheets, learner should identify whatnecessitates creation of new spreadsheet or workbook anddifferentiate between the two. They should seek to justify why theythink a new worksheet in a given spreadsheet was created.

Creating

  1. To ensure that learners create spreadsheet functions, I will ask them to identify situations where they think that spreadsheets can be used as opposed to any other programs. It is important for them to identify real life cases. A sample would be NFL table in a season or tabulating student GPA scores.

  2. Learners will create new spreadsheets and enter various data sets provided into a spreadsheet. Ideally, the data should be relevant to them such as their grades from various assessments in different classes/units.

  3. Learners will be required to manipulate provided data sets. Simple tasks such as calculating mean, median, midpoints, and frequencies will be completed. With time learners will be required to complete complex tasks such as creating frequency/histogram charts and the application of the same in real life.

The above activities as discussed can of course vary with theknowledge of learners or any special considerations. For instance,some leaners may have encountered spreadsheet programs on their ownoutside class. In other cases, some learners may face specialdifficulties such as disability that may affect their participationin the said activities.

References

Bloom, B. 2015.Blooms’ taxonomy. Retrieved from,

http://ww2.odu.edu/educ/roverbau/Bloom/blooms_taxonomy.htm

.

Close Menu