DEVELOPMENT OF TEACHER’S SUPPORT MATERIALS FOR
TEACHING SOLVING WORD PROBLEMS IN COLLEGE
ALGEBRA USING MICROSOFT-EXCEL PROGRAM
Prof. Jeim G. Alvar
THE PROBLEM
Objectives
The purpose of this study
was to develop teacher’s support materials for teaching Solving Word Problems in College
Algebra using Microsoft-Excel Program at Philippine Normal University-Agusan Campus, Prosperidad, Agusan
del Sur. Specifically, this study intended to:
1. identify the learning objectives of the topics on word problem solving,
particularly:
1.1 general objectives; and
1.2 specific objectives
2. develop a set of instructions for the topics on solving word problems
in college algebra using Microsoft-Excel program, specifically, on the following
topics:
2.1 number problems;
2.2 age problems;
2.3 geometry-related problems;
2.4 work problems;
2.5 mixture problems;
2.6 motion/distance problems;
2.7 investment problems
3. design a format of presentation using Microsoft FrontPage 2000;and
4. determine the level or degree of acceptability of the developed materials
in terms of:
4.1 Objectives;
4.2 Content Quality;
4.3 Instructional Quality;
4.4 Technical Quality; and
4.5 Significance
METHODOLOGY
The research study
followed three major stages in the research and development cycle, namely, (a) Planning Stage,
(b) Developing/Designing Stage, and (a) Evaluation Stage.
The planning
stage, involved a collection of resource materials, review of related studies and literature and formulation
of general and specific objectives. This process also involved the sequencing of presentations of the activities
and exercises.
The design and
developing stage was divided into two categories: a.) the design of a format of presentation program
using Microsoft FrontPage 2000 in a Hypertext Mark-up Language (HTML) format, as presentation software,
and b.) the development of the module on how to use Microsoft Excel program to solve word problems in college
algebra.
In evaluating
the developed learning material, the researcher used a 5-point Likert scale as suggested by Avila (1998)
for computer-aided instruction software (CAI) evaluation. The evaluation checklist was divided into categories,
namely; a.) Objectives (3 questions), b.) Quality of Content (6 questions), c.) Instructional Quality (8 questions),
d.) Technical Quality (7 questions), and e.) Significance (4 questions).
RESULTS
From the
results of evaluation, the summary mean responses for each criterion were as follows: a.) Objectives 3.44,
b.) Quality of Content- 3.28, c.) Instructional Quality – 3.29, d.) Technical Quality – 3.05, and e.) Significance – 3.21. The over-all mean rating was 3.25.
CONCLUSION
Based on
the analyses and findings of the data gathered, it was concluded that the content of the developed module
is fairly acceptable and can be used as a resource material or a supplement for teaching and learning word
problem solving in algebra using Microsoft Excel program. However, due to some limitations of the research
study, the researcher would like to emphasize that these teacher’s support materials are subject for further
validation in terms of their content effectiveness. Further revisions and necessary improvements in their contents
will increase the level of their acceptability in teaching and learning.
RECOMMENDATIONS
Given the limitation
of the research, it is suggested that this developed teacher’s support materials for teaching
solving word problem in college algebra be tried out, explored, and experimented for further improvements
as this will validate more the acceptability of the developed module.
From the findings on
the results of evaluation, it is recommended that teachers should also design and develop
a computer-based material or a computer-aided instruction in their own respective fields of specialization.
Especially in the field of science (such as physics) and mathematics, these materials open more opportunities
for teachers for further teaching explorations and innovations.
The researcher believes that
this kind of innovations offers a lot of techniques in teaching and learning solving
word problems in algebra using computer technology, specifically, using Microsoft-excel program.
BIBLIOGRAPHY
Books/Journals/Publications
Anaque, G. (2000). "Development & evaluation of a computer-assisted
instruction (CAI) in permutations." A special project; Manila: Philippine
Normal University.
Aurelio, M. (1991)."Journal
of computers in mathematics and science teaching comment on science education research".
A Crisis of Confidence. 30(8), 1009-1011
Avila, Arlene M. "Design
and evaluation of a computer-assisted instruction material in heat and thermodynamics".
Manila: De la Salle University, 1998
Balgos, Gina B. (2000); "Development
and evaluation of computer-based instructional materials in geometry for sophomore
students of Makati Science High School"; Special Project, manila: Philippine
Normal University.
Becker, H.J. (1986) Our national report card: preliminary results from
the New Johns Hopkins Survey. Classroom Computer Learning. 6(4): 30-33.
Bolter, J. D. (1992). Literature in the electronic writing space. In M.
C. Tuman (Ed.), Literacy online: The promise
(and peril) of reading and writing with computers (pp. 19-42). Pittsburgh:
University of Pittsburgh Press.
Boster, F. J., Meyer, G. S., Roberto, A. J., & Inge, C. C. (2002).
A report on the effect of the united streaming (TM)
application on educational performance. Farmville, VA: Longwood University.
Bruner, J. (1960). The Process of Education. Cambridge, MA: Harvard University
Press.
Bruner, J. (1966). Toward a Theory of Instruction. Cambridge, MA: Harvard
University Press.
Bruner, J. (1973). Going Beyond the Information Given. New York: Norton.
Bruner, J. (1983). Child's Talk: Learning to Use Language. New York: Norton.
Bruner, J. (1986). Actual Minds, Possible Worlds. Cambridge, MA: Harvard
University Press.
Bruner, J. (1990). Acts of Meaning. Cambridge, MA: Harvard University
Press.
Bruner, J. (1996). The Culture of Education, Cambridge, MA: Harvard University
Press.
Bruner, J., Goodnow, J., & Austin, A. (1956). A Study of Thinking.
New York: Wiley.
Cabalonga, Angelita "Design, development & evaluation on computer-aided
instruction (CAI)on circular functions". Special project; Manila: Philippine
Normal University, 2000-2001
Card, S., Moran, T. & Newell, A. (1983). The Psychology of Human-Computer
Interaction. Hillsdale, NJ: Erlbaum.
Carroll, J.M. (1990). The Nurnberg Funnel. Cambridge, MA: MIT Press.
Carroll, J.M. (1998). Minimalism beyond the Nurnbers Funnel. Cambridge,
MA: MIT Press.
Combs, A.W. (1982). Affective education or none at all. Educational Leadership,
39(7), 494-497.
Cognition and Technology Group at Vanderbilt. (1992). The Jasper series
as an example of anchored instruction: Theory, program description, and assessment
data. Educational Psychologist, 27,(3), 291-315.
Cruz, Amelita P. (2000). Computer-aided
instruction (CAI): creating web page design using hyper-text markup language
(HTML)." A special project; Manila: Philippine Normal University
De Leon r. (1987). "Adult learning styles and attitudes owards computer-assisted
instruction." Journal of Nursing Education, 29, 79-83.
Drier, H. S., Dawson, K. M., & Garofalo, J. (1999). Not your typical
math class. Educational Leadership 56(5), 21-25.
Encelan, Rodelito S. "The development of computer-assisted instruction
(CAI) ON SPECIAL PRODUCTS." Special project; Manila: Philippine Normal University,
2000-2001
Fisher, C., Dwyer, D. C., & Yocam, K. (Eds.). (1996). Education and technology: Reflections on computing in classrooms.
San Francisco, CA: Jossey-Bass.
Gagné, R.M. (1985). The conditions of learning (4th ed.). New York:
Holt, Rinehart & Winston, Inc.
Gagné, R.M. & Briggs, L.J. (1979). Principles of instructional
design (2nd ed.). New York: Holt, Rinehart & Winston, Inc.
Geisler, C. (1994). Academic
literacy and the nature of expertise: Reading, writing, and knowing in academic philosophy.
Hillsdale, NJ: Lawrence Erlbaum Associates.
Gumpert, G., & Cathcart, R. (1985). Media grammars, generations, and
media gaps. Critical Studies in Mass Communication,
2, 23-35.
Hannafin, M. and S. Hooper. (1993) "Learning Principles," in Fleming,
M. and W.Hansen, V. P. (Ed.) (1984).
Computers in mathematics education.
Reston, VA: National Council of Teachers of Mathematics.
Hativa, N., & Becker, H. J. (1994). Computer-based integrated learning
systems: Research and theory. International Journal of Educational Research,
21(1), 1-119.
Heerman, B. Personal Computers and the Adult Learner. San Francisco: Jossey-Bass.
Hughes, B., & Coyne, P. (1996, October). Meeting
the needs of 21st century literacy by using computers in family literacy centers.
Paper presented at the National Reading Research Center Conference on Literacy
and Technology for the 21st century, Atlanta, GA.
Jeffries, R., Turner, A., Polson, P., & Atwood, M. (1981). The processes
involved in designing software. In J.R.
Anderson (ed.), Cognitive Skills and Their Acquisition. Hillsdale, NJ:
Erlbaum.
Knowles, M. (1984). Andragogy in Action. San Francisco: Jossey-Bass.
Kulik, C. and J. Kulik. (1985) "Effectiveness of Computer-Based Education
in Colleges." Paper presented at the Annual Meeting of the American Educational
Research Association (69th, Chicago, IL, March 31-April 4, 1985.
Kulik, C. et al. (1986) "The Effectiveness of Computer-Based
Adult Education: A Meta-Analysis." Journal of Educational Computing Research 2: 235-52.
Kulik, J. (1983) "Effects of Computer-Based Teaching on Learners." Paper
presented at the National Forum of the College Board Symposium on Computer Competency
and the Curriculum (Dallas, TX, October.
Kulik, J. (1984) "The Fourth Revolution in Teaching: Meta-Analyses." Paper
presented at the Annual Meeting of the American Educational Research Association
(68th,New Orleans, LA, April 23-27).
Kulik, J. and C. Kulik. (1987) "Computer-Based Instruction: What 200 Evaluations
Say. " Paper presented at the Annual Convention of the Association for Educational
Communications and Technology (Atlanta, GA, February 26-March 1).
Kulik, J. (1994) "Meta-analytic Studies of Findings on Computer-based
Instruction." In E. L. Baker and H. O'Neil, Jr., eds. Technology Assessment
in Education and Training. Hillsdale, NJ: Erlbaum.
Lammers, S. (1986). Programmers at Work. Richmond, WA: Microsoft Corporation.
Landow, G. P. (1990). Changing texts, changing readers: in literary education,
criticism, and scholarship. In B.
Henricksen & T. E. Morgan(Eds.), Reorientations: Critical theories
and pedagogies (pp. 133-161). Urbana, IL: University of Illinois Press.
Mann, D., Shakeshaft, C., Becker, J., & Kottkamp, R. (1998). West Virginia story: Achievement gains from a statewide
comprehensive instructional technology program. Santa Monica, CA: Milken
Exchange on Educational Technology.
Mayer, R. (1988). Teaching and Learning Computer Programming. Hillsdale,
NJ: Erlbaum.
McKnight, C., Dillon, A., & Richardson, J. (1996). User-centered design
of hypertext/hypermedia for education. In D. H. Jonassen (Ed.), Handbook of
research for educational communications and technology (pp. 622-633).New
York: Macmillan Library Reference USA.
Means, B. and K. Olson. (1995) Technology’s Role
in Education: Reform, Findings from a National Study of Innovating Schools. Menlo Park, CA: SRI.
Morales, Ramon S. "Development and evaluation of a computer-assisted instruction
on projectile motion". Manila: De La Salle University, 1992
Norman, K. (1991). The Psychology of Menu Selection. Norwood, NJ: Ablex.
Nowaczyk, R. & James, E. (1993). Applying minimal manual principles
for documentation of graphical user interfaces. Journal of Technical Writing
and Communication, 23(4), 379-388.
Paguyo, J. (1995) "empirical
evidence that measuring user’s opinion is not a satisfactory way of evaluating computer-assisted
learning in nursing education." International Journal of Nursing Studies.
29(4),411-425.
Papert, S. (1993). Children’s Machines: Rethinking Schools in the
Age of the Computer. NY: Basic Books.
Papert, S. (1980). Mindstorms: Children, Computers and Powerful Ideas.
NY: Basic Books.
Park, O. (1996). Adaptive instructional systems. In D. H. Jonassen (Ed.),
Handbook of research for educational communications
and technology (pp. 634-664). New York: Simon & Schuster Macmillan.
Pask, G. (1i975). Conversation, Cognition, and Learning. New York: Elsevier
Patterson, C.H. (1973). Humanistic Education. Engelwood Cliffs, NJ: Prentice-Hall.
Riel, M., & Harasim, L. (1994). Research perspectives on network.
Machine-Mediated Learning, 4(2-3), 91-114.
Reinking, D. (1994a, Spring). Electronic literacy. Perspectives
in reading research, technical report No. 4. Athens, GA: National Reading
Research Center.
Reinking, D. (1994b). Reading and writing with computers:Literacy research
in a post-typographic world. In K.A.
Reinking, D., & Bridwell-Bowles, L. (1996). Computer in reading and
writing. In R. Barr, M. L. Kamil,
P.B. Mosenthal, & P. D. Pearson (Eds.), Handbook of reading research
(Vol. 2, pp. 310-340). Mahwah, NJ: Lawrence Erlbaum Associates.
Rogers, C.R. (1969). Freedom to Learn. Columbus, OH: Merrill.
Romiszowski, A. (1997).The use of telecommunications in education. In
S. Dijkstra, N. Seel, F. Schott, & R. D.
Tennyson (Eds.), Instructional
design: International perspectives. Volume 2: Solving instructional design problems
(pp. 183-220). Mahwah, NJ: Lawrence Erlbaum Associates.
Romiszowski, A. J., & Mason, R. (1996). Computer-mediated communications.
In D.H. Jonassen (Ed.), Handbook of research
for educational communications and technology. New York: Simon & Schuster
Macmillan.
Rouet, J. F., & Levonen, J. J. (1996). Studying and learning with
hypertext: Empirical studies and their implications.
In J. F. Rouet, J. J. Levonen, A. Dillon, & R. J. Spiro (Eds.), Hypertext
and cognition (pp. 9-23). Mahwah, NJ: Lawrence Erlbaum Associates.
Salomon, G. (1981). Communication and Education. Beverly Hills, CA: Sage.
Sandefur, E. W. Experimental
study of two methods of drill for mastering addition and subtraction facts.Dissertation Abstracts International, 1966, 26, 4401.
Scardamalia, M., & Bereiter, C. (1992,April). Computer support for
knowledge-building communities. In P. Feltovich (Chair). Instructional theories
underlying the use of networked computers in the classroom. Symposium conducted
at the meeting of the American Educational Research Association, San Francisco.
Schoenfeld, A. (1987). Cognitive Science and Mathematics Education. Hillsdale,
NJ: Erlbaum Assoc.
Schoenfeld, A. (1985). Mathematical Problem Solving. New York: Academic
Press.
Selfe, C. L., & Hilligoss, S. (1994). Literacy
and computers:The complications of teaching and learning with technology. New York: The Modern Language Association of America.
Senge, P. M. (1990). The fifth discipline: The art and practice of
the learning organization. New York: Doubleday Currency.
Shirk, H. N. (1991). Hypertext and composition studies. In G. E. Hawisher
& C. L. Selfe (Eds.), Evolving perspectives
on computers and composition studies (pp.177-202). Urbana, IL: National Council
of Teachers of English.
Skinner, B. F. (1958).Teaching machines. Science, 128(130), 969-977.
Soloway, E. & Iyengar, S. (1988). Empiricial Studies of Programmers.
Norwood, NJ: Ablex.
Spiro, R.J (1990). Cognitive flexibility and hypertext:Theory and technology
for the non-linear and multidimensional traversal of complex subject matter.
D. Nix & R. Spiro (eds.), Cognition, Education, and Multimedia. Hillsdale,
NJ: Erlbaum.
Suydam, M. N., & Dessart, D. J. (1976). Classroom ideas from research
on computational skills. Reston: National Council of Teachers of Mathematics.
Trifiletti J.J., Frith, G. & Armstong, S. (1984)
Microcomputers versus resource rooms for LD students: A preliminary investigation
of the effects on math skills. Learning Disability Quarterly. Vol 7, Winter:
69-76.
Turner, S. V., & Land, M. L. (1988). Cognitive effects of a logo-enriched
mathematics program for middle school students. Journal of Educational Computing
Research, 4(4), 443- 452.Valett, R.E. (1977). Humanistic Education. St Louis,
MO: Mosby.
Van der Meij, H. & Carroll, J.M. (1995). Principles and heuristics
for designing minimalist instruction. Technical Communications, 42(2), 243-261.
Weinberg, G. (1971). The Psychology of Computer Programming. New York:
Van Nostrand Reinhold.
Zemke, R. (1984). Computer Literacy Needs Assessment. Reading, MA: Addison-Wesley.
Zuboff, S. (1988). In the age of the smart machine: The future of work
and power. New York: Basic Books.
Electronic books/Internet publications
Cradler, J., & Cradler, R. (2000). The
curriculum technology integration plan (CTIP): Impact of the CTIP on technology
integration in the DoEA DoD presidential technology initiative. San Mateo,
CA: Educational Support Systems. Retrieved from http://caret.iste.org
Center for Applied Research in Educational Technology –CARET. (2000).
Topic: Curriculum and Instruction.Retrieved from http://caret.iste.org/index.cfm?fuseaction=questions&topicID=2
ERIC/SMEAC Mathematics Education Digest, No. 1); An overview of research: Computers in mathematics education, K-12 (1986).
[http://eric.org/smeac/htm]
Gregoire, R., Bracewell, R., & Laferriere, T. (1996),August). The contribution of new technologies to learning and teaching
in elementary and secondary schools. Quebec, Canada: Laval University and
McGill University.[http://www.rand.org/publications/MR/MR682/contents.html]
Hayes, D., Schuck, S., Dega, G., Dwyer, J. & McEwen, C. (2001). Net gain? The integration of computer-based learning
in six NSW government schools, 2000. Retrieved May 30, 2002, from http://www.curriculumsupport.nsw.edu.au/learningtechnologies/files/Lea_netgain.pdf
Kathy, Adkins(2000), Instructional Technology Specialist at Forsyth
County Schools Koedinger, K., Anderson, J., Hadley, W., & Mark, M., (1997).
Intelligent tutoring goes to school in the big city. Pittsburgh, PA: Human-Computer
Interaction Institute, Carnegie Mellon University. International Journal of
Artificial Intelligence in Education, 8, 30-43.
Retrieved February 11, 2002, from http://act.psy.cmu.edu/awpt/AlgebraPacket/kenPaper/paper.html.
Koedinger, K. and Anderson, J. (1999). PUMP algebra project: AI and
high school math. Pittsburgh, PA:.Carnegie Mellon University, Human Computer
Interaction Institute. Retrieved February 24, 2003 from http://act.psy.cmu.edu/awpt/awpt-home.html
McKenzie, J. (1998). Creating technology enhanced student-centered learning
environments. From Now On: The Educational
Technology Journal, 7(6). Retrieved March 19, 2002, from http://www.fno.org/mar98/flotilla.html#anchor275428
Means, B., & Olson, K. (1997). Technology and education reform. Office of Educational Research and Improvement,
Contract No. RP91-172010. Washington, DC: U.S. Department of Education. Retrieved
February 3, 2003, fromhttp://www.ed.gov/pubs/SER/Technology/title.html.
National Council of Teachers of Mathematics (1989).Curriculum and evaluation
standards for school mathematics. Reston, VA: author. Retrieved from http://www.iste.org/nctm
Rakes, G. C., Flowers, B. F., Casey, H. B., & Santana, R. (1999).
An analysis of instructional technology use and constructivist behaviors in K-12
teachers. International Journal of Educational Technology, 1(2). Retrieved October
31, 2001, from http://www.outreach.uiuc.edu/ijet/v1n2/v1n2articles.html
Society for Information Technology in Teacher Education from http://www.aace.org/conf/site/)
Sugar, W. (2001). PLATO evaluation: Forest Grove High School. In R. Foshay,
Ph.D. (Ed.), PLATO evaluation
series. Bloomington, MN: PLATO Learning Inc. Retrieved on January 8, 2003,
from http://www.plato.com/results_evaluations.asp?t=ZZ&p=ZZ&c=ZZ
The Educational Researcher, The Journal of Research in Technology in Education, and Contemporary Issues in Technology
and Teacher Education. Society for Information Technology in Teacher Education;
retrieved from http://www.aace.org/conf/site/
Walker, L., Rockman, S., & Chessler, M. (2000). A
more complex picture: Laptop use and impact in the context of changing home and
school access. The third in a series of research studies on Microsoft's Anytime
Anywhere Learning Program. San Francisco, CA: Rockman, et al. Retrieved February
13, 2003,from http://rockman.com/projects/laptop/laptop3exec.htm.
Zhao, Y., Pugh, K., Sheldon, S., & Byers, J. (2002). Conditions for
classroom technology innovations: Executive summary. Teachers College Record,
104 (3) 482-515. Retrieved July 4, 2002, from http://www.tcrecord.org/Collection.asp?CollectionID=7
|