• Title/Summary/Keyword: Spreadsheets

Search Result 42, Processing Time 0.02 seconds

On Exploring the Properties of Pythagorean Triples Using Spreadsheets (스프레드시트를 활용한 피타고라스 삼원수 성질의 탐구)

  • Son, Hong-Chan
    • Communications of Mathematical Education
    • /
    • v.25 no.1
    • /
    • pp.147-166
    • /
    • 2011
  • In this paper, we listed and discussed the properties of the Pythagorean triples which 5 gifted 9th graders could draw in spreadsheets environments. And we also discussed their implications. In detail, in spreadsheets environments students could make the table of Pythagorean triples easily under several conditions of generate numbers of Pythagorean triples. And they could draw several properties of Pythagorean triples from the tables and could prove them. In spreadsheets environments it is easy to give students chances of generalization of the properties of Pythagorean triples which they had obtained from the concrete table of Pythagorean triples.

Using Spreadsheets with Mathematically Gifted Students

  • Arganbright Deane
    • Research in Mathematical Education
    • /
    • v.10 no.1 s.25
    • /
    • pp.33-47
    • /
    • 2006
  • Finding good ways to support the further development of mathematically gifted students is a challenge for all mathematics educators. Simply moving able students on more rapidly to the next level of traditional mathematical instruction seems to be a limited approach, while providing supplementary enrichment material or specialized mathematical software requires us to ensure that doing so is truly worthwhile for the students. This paper presents an approach that the author has used with students of diverse capabilities in both technologically advanced and developing nations investigating mathematical ideas using a spreadsheet.

  • PDF

Enabling a fast annotation process with the Table2Annotation tool

  • Larmande, Pierre;Jibril, Kazim Muhammed
    • Genomics & Informatics
    • /
    • v.18 no.2
    • /
    • pp.19.1-19.6
    • /
    • 2020
  • In semantic annotation, semantic concepts are linked to natural language. Semantic annotation helps in boosting the ability to search and access resources and can be used in information retrieval systems to augment the queries from the user. In the research described in this paper, we aimed to identify ontological concepts in scientific text contained in spreadsheets. We developed a tool that can handle various types of spreadsheets. Furthermore, we used the NCBO Annotator API provided by BioPortal to enhance the semantic annotation functionality to cover spreadsheet data. Table2Annotation has strengths in certain criteria such as speed, error handling, and complex concept matching.

A study on Use of a Spreadsheet (Excel) (스프레드시트 사용에 관한 연구)

  • Lee, Dae-Yong;Park, Kynng-Ah
    • Knowledge Management Research
    • /
    • v.13 no.2
    • /
    • pp.37-52
    • /
    • 2012
  • A spreadsheet is a office automation software which has been widely used in almost all areas in business. A spreadsheet is used for calculation, data analysis, model building and so on. As a result, spreadsheet is a very important tool for generating knowlege in a firm. Errors in a spreadsheet model can cause a serious financial damage in a corporation. However in Korea few researches for reducing errors have been performed. Neither serious efforts to reduce errors have been executed by corporations. In this research we provided summarized the results from a survey for spreadsheet usage, summarized researches on errors in spreadsheet up to now, and suggested a rules and structured development method for reducing errors in a spreadsheet. Errors in spreadsheets are prevalent. To solve this serious problem, we need much more attention on this problem in research area. Corporations must put more efforts on setting policies and rules. And also we need the government's concern and support.

  • PDF

Developing Mathematics Creativity with Spreadsheets

  • Deane Arganbright
    • Research in Mathematical Education
    • /
    • v.9 no.3 s.23
    • /
    • pp.187-201
    • /
    • 2005
  • The spreadsheet Microsoft Excel is the most widely used mathematical tool in today's workplace. Moreover, it is also an outstanding means for developing a surprisingly wide range of creative and innovative educational uses within such areas as mathematical modeling, visualization, and instruction. The spreadsheet's format provides us with a tool that closely parallels the way in which we naturally carry out problem solving, while the spreadsheet creation process itself illuminates the underlying mathematical concepts. In addition, the spreadsheet's visual layout allows us to introduce a broad variety of challenging and interesting topics, and to design creative demonstrations through eye-catching animated graphics. The material presented comes from actual classroom mathematics teaching experience in both industrially advanced and developing nations. A series of highly visual interactive illustrations from mathematics, the natural and social sciences, computing, engineering, and the arts provide a number of usable examples. The material discussed is applicable at diverse levels, ranging from schools and universities through adult education and in-service teacher development programs.

  • PDF

Mathematics Teacher's Development of TPCK (수학 교사의 테크놀로지 교수 학습 지식(TPCK) 개발)

  • Lee, Kwang-Ho
    • Journal of the Korean School Mathematics Society
    • /
    • v.10 no.2
    • /
    • pp.247-262
    • /
    • 2007
  • TPCK is the knowledge of intersection in mathematics, technology, and pedagogy. This study investigated a teacher's change of his TPCK. He participated in the professional development program which was designed to develop mathematics teachers' TPCK. The professional development program was based on using spreadsheets in teaching mathematics. The researcher suggests a consideration for the integration of technology in mathematics education and mathematics teacher education. The program consisted of a four week summer professional development program and three actual mathematics classroom teaching. Ten teachers took part in the program. One teacher who changed his TPCK most was selected to investigate what made it change most. Following teaching practice was the most influential factor in changing his TPCK.

  • PDF

Force-deformation behaviour modelling of cracked reinforced concrete by EXCEL spreadsheets

  • Lam, Nelson;Wilson, John;Lumantarna, Elisa
    • Computers and Concrete
    • /
    • v.8 no.1
    • /
    • pp.43-57
    • /
    • 2011
  • Force-deformation modelling of cracked reinforced concrete is essential for a displacement-based seismic assessment of structures and can be achieved by fibre-element analysis of the cross-section of the major lateral resisting elements. The non-linear moment curvature relationship obtained from fibre-element analysis takes into account the significant effects of axial pre-compression and contributions by the longitudinal reinforcement. Whilst some specialised analysis packages possess the capability of incorporating fibre-elements into the modelling (e.g., RESPONSE 2000), implementation of the analysis on EXCEL is illustrated in this paper. The outcome of the analysis is the moment-curvature relationship of the wall cross-section, curvature at yield and at damage control limit states specified by the user. Few software platforms can compete with EXCEL in terms of its transparencies, versatility and familiarity to the computer users. The program has the capability of handling arbitrary cross-sections that are without an axis of symmetry. Application of the program is illustrated with examples of typical cross-sections of structural walls. The calculated limiting curvature for the considered cross-sections were used to construct displacement profiles up the height of the wall for comparison with the seismically induced displacement demand.

Trend and Prospect on Using Technology in Mathematics Education in Korea (우리나라 수학교육에서 공학 활용의 역사와 현황)

  • Son, Hong-Chan
    • School Mathematics
    • /
    • v.13 no.3
    • /
    • pp.525-542
    • /
    • 2011
  • As teachers need to understand how to select and use technology in mathematics education, analysis on history, characteristics, and effects of various technology used in school mathematics will facilitate effective use of technology. This thesis aims to analyze through literary studies the history, characteristics, and effects of using spreadsheets Excel, dynamic geometry softwares GSP, Cabri and CAS, the most commonly used technology in teaching and learning mathematics in Korea. And we also study the current trends on using technology in mathematics education in Korea by investigating research trend, secondary mathematics curriculums past and present in Korea, mathematics textbooks, and classroom environments.

  • PDF

Modelling of seismically induced storey-drift in buildings

  • Lam, Nelson;Wilson, John;Lumantarna, Elisa
    • Structural Engineering and Mechanics
    • /
    • v.35 no.4
    • /
    • pp.459-478
    • /
    • 2010
  • This paper contains detailed descriptions of a dynamic time-history modal analysis to calculate deflection, inter-storey drift and storey shear demand in single-storey and multi-storey buildings using an EXCEL spreadsheet. The developed spreadsheets can be used to obtain estimates of the dynamic response parameters with minimum input information, and is therefore ideal for supporting the conceptual design of tall building structures, or any other structures, in the early stages of the design process. No commercial packages, when customised, could compete with spreadsheets in terms of simplicity, portability, versatility and transparency. An innovative method for developing the stiffness matrix for the lateral load resistant elements in medium-rise and high-rise buildings is also introduced. The method involves minimal use of memory space and computational time, and yet allows for variations in the sectional properties of the lateral load resisting elements up the height of the building and the coupling of moment frames with structural walls by diaphragm action. Numerical examples are used throughout the paper to illustrate the development and use of the spreadsheet programs.

Random Ordering of Experimental Design According to the Nested Factor, Block Factor and Repetition Types (지분인자, 블록인자와 되풀이 유형에 따른 실험계획의 랜덤화 순서)

  • Choi, Sung-Woon
    • Proceedings of the Safety Management and Science Conference
    • /
    • 2009.04a
    • /
    • pp.177-183
    • /
    • 2009
  • The research develops random ordering methodology of experimental design by the use of nested factor, block factor and repetition types. The spreadsheets developed are useful for quality practioner to acquire the experimental characteristics according to the random ordering.

  • PDF