(Continuation from yesterday)
However, I think that education using this spreadsheet is still inadequate.
First of all, they should not come up with the power to "go to the PC."
I do not even think of it that, nobody can make children who think a PC is SNS and game terminals open the unfriendly spreadsheet.
Before starting learning, it becomes an decisive unfairness whether there are experienced PC users around themselves(e.g. parents or teachers)
In order to avoid these problems, we will give the children "intense motivation" for trying to use the spreadsheet like Excel.
=====================================
(Case 1) For primary school students
=====================================
(1)Do the calculations stated in this table during the summer vacation
(2)Copy other's stuff will be in vain, because the numerical value of the drill and the calculation pattern are different for each individual.
(3)The table of (1) above is also offered as an "electronic file" if desired
(4)You can submit a printed spreadsheet and written answers there, or you can use the spreadsheet to calculate it with a personal computer.
========================================
(Case 2) for junior high school students
========================================
(Student A)
(1)Submit the result of estimating the sales and profits per day of Super A near the school on a spreadsheet.
(2) The hypothesis that leads to estimation and the calculation result based on it are written in the spreadsheet so that they can be understood by the reader.
(3)Monitoring and interviewing may be done as long as it does not inconvenience the store, but it is not essential.
(Student B)
(1) The convenience store B near the school (hereinafter abbreviated)
(Student C)
(1)Vending machine C near the school (hereinafter abbreviated)
===================
(Case 3) For high school students
===================
A hole of 7 mm in diameter shall be drilled 5 cm from the bottom into a 1 liter milk pack filled with water. At that time, show the water level and water volume in a graph.
The means of calculation is not limited (use of differential equations is optional). However, it may be calculated using a spreadsheet.
How do you make the "homework" like the above?
This is based on the fact that human beings have a "strong motivation" with the inconsistent character of "doing any effort to make it easier"
"Programming education not to use programs (just define columns)"
(To be continued)