Software Excel Assists College Mathematics Teaching

Liang Haibin; Ling Haiqing

doi:doi:10.11648/j.sd.20221005.22

| Peer-Reviewed

Software Excel Assists College Mathematics Teaching

Liang Haibin, Ling Haiqing

Published in Science Discovery (Volume 10, Issue 5)

Received: 22 September 2022 Accepted: 20 October 2022 Published: 27 October 2022

Views: Downloads:

Download PDF

Share This Article

Twitter
Linked In
Facebook

Abstract

The cultivation of mathematics application ability is an important purpose in college mathematics teaching, and it is also a weak link. The significance of introducing Excel software in college mathematics courses is to improve students' learning efficiency and interest, and to cultivate students' ability to use mathematical knowledge to solve practical problems. Compared with other mathematical software, Excel has great simplicity. Using the calculation, drawing, built-in functions, and statistical analysis functions of EXCEL software, explore a teaching method that is beneficial to students' learning of mathematics courses, and help students to understand and master the theoretical basis and methods of calculus, probability and statistics, and linear algebra skill. Through the comparative analysis of the scores of the control group who introduced the software Excel, as well as the effect analysis of the improvement of students' mathematical ability and computer ability, it is found that the introduction of the software Excel in the university mathematics classroom is conducive to improving the students' big data processing ability, mathematical modeling ability and Apply innovation capabilities. At the same time, the introduction of the software Excel in the mathematics classroom has also improved the teachers' software office ability.

Published in	Science Discovery (Volume 10, Issue 5)
DOI	10.11648/j.sd.20221005.22
Page(s)	361-365
Creative Commons	This is an Open Access article, distributed under the terms of the Creative Commons Attribution 4.0 International License (http://creativecommons.org/licenses/by/4.0/), which permits unrestricted use, distribution and reproduction in any medium or format, provided the original work is properly cited.
Copyright	Copyright © The Author(s), 2024. Published by Science Publishing Group

Keywords

Advanced Mathematics, Excel, Auxiliary Teaching

References

[1]	王志军. 利用Excel函数解决数学题 [J]. 电脑知识与技术 (经验技巧), 2015, (73): 40.
[2]	史玉磊Excel函数与图标实用大全 [M]. 北京: 电子工业出版社, 2007: 5-6.
[3]	吴赣昌. 经济数学 [M]. 中国: 人民大学出版社, 2011: 36-37.
[4]	吴赣昌. 经济数学 [M]. 中国: 人民大学出版社, 2011: 88-89.
[5]	崇美英, 曲梦琪, 黄宏博等. 基于Excel的数据挖掘处理及应用分析 [J]. 北京信息科技大学学报, 2016, 31 (1): 90-93.
[6]	刘力平. Excel软件在回归分析教学中的应用 [J]．发明与创新 (教育信息化), 2014, 3 (10): 55-58.
[7]	邓芳. Excel高效办公: 数据处理与分析 [M]. 北京: 人民邮电出版社, 2012: 100-101.
[8]	吴志远. 基于excel的概率论与数理统计数学实验的研究 [J]. 钦州学院学报, 2011, 26 (06): 5-8.
[9]	陈琰明. Excel2003函数编程实现工程数学矩阵类运算的自动化处理 [J]. 教育教学论坛, 2016, 3 (1): 38-42.
[10]	丁岚. 调查分析基本技能 [M]. 北京: 中国财政经济出版社, 2007: 10-11.
[11]	刘昕辉, 巩晓秋. Excel在高校数学教学中的应用 [J]．辽宁师专学报 (自然科学版), 2020, 9 (3): 8-10.
[12]	赵文雯. 利用Excel构造高等数学题库的方法探究 [J]. 现代职业教育, 2022, (20): 154-156.
[13]	邓芳. Excel高效办公: 数据处理与分析 [M]. 北京: 人民邮电出版社, 2012: 2-3.
[14]	惠小健等. 基于网络课程平台的高等数学课程题库建设的探索与实践 [J]. 数学学习与研究, 2020, (23): 4-5.
[15]	佟玲, 王春雨. EXCEL在数学文化课程中的应用 [J]. 科技视界, 2020, (16): 146-147.

Cite This Article

Plain Text BibTeX RIS

APA Style

Liang Haibin, Ling Haiqing. (2022). Software Excel Assists College Mathematics Teaching. Science Discovery, 10(5), 361-365. https://doi.org/10.11648/j.sd.20221005.22

Copy | Download

ACS Style

Liang Haibin; Ling Haiqing. Software Excel Assists College Mathematics Teaching. Sci. Discov. 2022, 10(5), 361-365. doi: 10.11648/j.sd.20221005.22

Copy | Download

AMA Style

Liang Haibin, Ling Haiqing. Software Excel Assists College Mathematics Teaching. Sci Discov. 2022;10(5):361-365. doi: 10.11648/j.sd.20221005.22

Copy | Download

@article{10.11648/j.sd.20221005.22,
  author = {Liang Haibin and Ling Haiqing},
  title = {Software Excel Assists College Mathematics Teaching},
  journal = {Science Discovery},
  volume = {10},
  number = {5},
  pages = {361-365},
  doi = {10.11648/j.sd.20221005.22},
  url = {https://doi.org/10.11648/j.sd.20221005.22},
  eprint = {https://article.sciencepublishinggroup.com/pdf/10.11648.j.sd.20221005.22},
  abstract = {The cultivation of mathematics application ability is an important purpose in college mathematics teaching, and it is also a weak link. The significance of introducing Excel software in college mathematics courses is to improve students' learning efficiency and interest, and to cultivate students' ability to use mathematical knowledge to solve practical problems. Compared with other mathematical software, Excel has great simplicity. Using the calculation, drawing, built-in functions, and statistical analysis functions of EXCEL software, explore a teaching method that is beneficial to students' learning of mathematics courses, and help students to understand and master the theoretical basis and methods of calculus, probability and statistics, and linear algebra skill. Through the comparative analysis of the scores of the control group who introduced the software Excel, as well as the effect analysis of the improvement of students' mathematical ability and computer ability, it is found that the introduction of the software Excel in the university mathematics classroom is conducive to improving the students' big data processing ability, mathematical modeling ability and Apply innovation capabilities. At the same time, the introduction of the software Excel in the mathematics classroom has also improved the teachers' software office ability.},
 year = {2022}
}

Copy | Download

TY  - JOUR
T1  - Software Excel Assists College Mathematics Teaching
AU  - Liang Haibin
AU  - Ling Haiqing
Y1  - 2022/10/27
PY  - 2022
N1  - https://doi.org/10.11648/j.sd.20221005.22
DO  - 10.11648/j.sd.20221005.22
T2  - Science Discovery
JF  - Science Discovery
JO  - Science Discovery
SP  - 361
EP  - 365
PB  - Science Publishing Group
SN  - 2331-0650
UR  - https://doi.org/10.11648/j.sd.20221005.22
AB  - The cultivation of mathematics application ability is an important purpose in college mathematics teaching, and it is also a weak link. The significance of introducing Excel software in college mathematics courses is to improve students' learning efficiency and interest, and to cultivate students' ability to use mathematical knowledge to solve practical problems. Compared with other mathematical software, Excel has great simplicity. Using the calculation, drawing, built-in functions, and statistical analysis functions of EXCEL software, explore a teaching method that is beneficial to students' learning of mathematics courses, and help students to understand and master the theoretical basis and methods of calculus, probability and statistics, and linear algebra skill. Through the comparative analysis of the scores of the control group who introduced the software Excel, as well as the effect analysis of the improvement of students' mathematical ability and computer ability, it is found that the introduction of the software Excel in the university mathematics classroom is conducive to improving the students' big data processing ability, mathematical modeling ability and Apply innovation capabilities. At the same time, the introduction of the software Excel in the mathematics classroom has also improved the teachers' software office ability.
VL  - 10
IS  - 5
ER  -

Copy | Download

Author Information

Liang Haibin

School of Liberal Education, Liaoning University of International Business and Economics, Dalian, China
Ling Haiqing

School of Economics, Liaoning University of International Business and Economics, Dalian, China

Download PDF

Sections

Plain Text BibTeX RIS

APA Style

Liang Haibin, Ling Haiqing. (2022). Software Excel Assists College Mathematics Teaching. Science Discovery, 10(5), 361-365. https://doi.org/10.11648/j.sd.20221005.22

Copy | Download

ACS Style

Liang Haibin; Ling Haiqing. Software Excel Assists College Mathematics Teaching. Sci. Discov. 2022, 10(5), 361-365. doi: 10.11648/j.sd.20221005.22

Copy | Download

AMA Style

Liang Haibin, Ling Haiqing. Software Excel Assists College Mathematics Teaching. Sci Discov. 2022;10(5):361-365. doi: 10.11648/j.sd.20221005.22

Copy | Download

@article{10.11648/j.sd.20221005.22,
  author = {Liang Haibin and Ling Haiqing},
  title = {Software Excel Assists College Mathematics Teaching},
  journal = {Science Discovery},
  volume = {10},
  number = {5},
  pages = {361-365},
  doi = {10.11648/j.sd.20221005.22},
  url = {https://doi.org/10.11648/j.sd.20221005.22},
  eprint = {https://article.sciencepublishinggroup.com/pdf/10.11648.j.sd.20221005.22},
  abstract = {The cultivation of mathematics application ability is an important purpose in college mathematics teaching, and it is also a weak link. The significance of introducing Excel software in college mathematics courses is to improve students' learning efficiency and interest, and to cultivate students' ability to use mathematical knowledge to solve practical problems. Compared with other mathematical software, Excel has great simplicity. Using the calculation, drawing, built-in functions, and statistical analysis functions of EXCEL software, explore a teaching method that is beneficial to students' learning of mathematics courses, and help students to understand and master the theoretical basis and methods of calculus, probability and statistics, and linear algebra skill. Through the comparative analysis of the scores of the control group who introduced the software Excel, as well as the effect analysis of the improvement of students' mathematical ability and computer ability, it is found that the introduction of the software Excel in the university mathematics classroom is conducive to improving the students' big data processing ability, mathematical modeling ability and Apply innovation capabilities. At the same time, the introduction of the software Excel in the mathematics classroom has also improved the teachers' software office ability.},
 year = {2022}
}

Copy | Download

TY  - JOUR
T1  - Software Excel Assists College Mathematics Teaching
AU  - Liang Haibin
AU  - Ling Haiqing
Y1  - 2022/10/27
PY  - 2022
N1  - https://doi.org/10.11648/j.sd.20221005.22
DO  - 10.11648/j.sd.20221005.22
T2  - Science Discovery
JF  - Science Discovery
JO  - Science Discovery
SP  - 361
EP  - 365
PB  - Science Publishing Group
SN  - 2331-0650
UR  - https://doi.org/10.11648/j.sd.20221005.22
AB  - The cultivation of mathematics application ability is an important purpose in college mathematics teaching, and it is also a weak link. The significance of introducing Excel software in college mathematics courses is to improve students' learning efficiency and interest, and to cultivate students' ability to use mathematical knowledge to solve practical problems. Compared with other mathematical software, Excel has great simplicity. Using the calculation, drawing, built-in functions, and statistical analysis functions of EXCEL software, explore a teaching method that is beneficial to students' learning of mathematics courses, and help students to understand and master the theoretical basis and methods of calculus, probability and statistics, and linear algebra skill. Through the comparative analysis of the scores of the control group who introduced the software Excel, as well as the effect analysis of the improvement of students' mathematical ability and computer ability, it is found that the introduction of the software Excel in the university mathematics classroom is conducive to improving the students' big data processing ability, mathematical modeling ability and Apply innovation capabilities. At the same time, the introduction of the software Excel in the mathematics classroom has also improved the teachers' software office ability.
VL  - 10
IS  - 5
ER  -

Copy | Download