About of an experience of the teaching “statistics” by using the EXCEL

Author

Mehdialiyev, A.I.

Author_Institution

Acad. of Public Adm. under the President of the Republic of Azerbaijan, Baku, Azerbaijan

fYear

2011

fDate

12-14 Oct. 2011

Firstpage

1

Lastpage

6

Abstract

In the report is suggested an electronic resource (presentation of POWER POINT) developed by the author, consisting of slides, which contain instruction for use, the cause of the error and informative example for each statistical function MICROSOFT EXCEL 2007. Statistical functions are grouped on the functional proximity and purpose. In the each slides there are links to the slides of other functions in the same group. In most examples a solution was found by two ways, “manual” way and using EXCEL, which allows to the user better understand the essence of the considered function. In the report also established important mathematical properties of some statistical functions to facilitate the computing operations with them.

Keywords

computer aided instruction; computer science education; teaching; computing operation; electronic resource; functional proximity; mathematical property; statistical function MICROSOFT EXCEL 2007; statistics teaching; Helium; Manuals; Rail to rail outputs; Spreadsheet programs;

fLanguage

English

Publisher

ieee

Conference_Titel

Application of Information and Communication Technologies (AICT), 2011 5th International Conference on

Conference_Location

Baku

Print_ISBN

978-1-61284-831-0

Type

conf

DOI

10.1109/ICAICT.2011.6110935

Filename

6110935