Write Equations Based on Tables

Write Equations Based on Tables
Loading the math board and drawing, please wait…
2015-02-06 01:19
This example demonstrates how to write equations based on given table data. Key mathematical concepts include sequences and functions. Using GeoGebra commands such as Random, Sequence, and Join, dynamic table data and corresponding equation graphs can be generated. Suitable for high school math education and learning.

GeoGebra Commands & Parameters

  1. Random(1, 10) → intervalX1
  2. Sequence((-i), i, 1, 20) → list1
  3. Sequence(i, i, 1, 20) → list2
  4. Join({list1, list2}) → coefs
  5. Element(coefs, Random[1, 40]) → coef1
  6. Element(coefs, Random[1, 40]) → coef2
  7. Element(coefs, Random[1, 40]) → coef3
  8. Element(coefs, Random[1, 40]) → coef4
  9. Element(coefs, Random[1, 40]) → coef5
  10. Element(coefs, Random[1, 40]) → coef6
  11. Join({list1, list2, {0}}) → b
  12. FractionText((coef1 * A2^(2)) + b1) → B2
  13. FractionText((coef1 * A3^(2)) + b1) → B3
  14. FractionText((coef1 * A4^(2)) + b1) → B4
  15. FractionText((coef1 * A5^(2)) + b1) → B5
  16. FractionText((coef1 * A6^(2)) + b1) → B6
  17. FractionText((coef1 * A7^(2)) + b1) → B7
  18. Random(1, 10) → intervalX2
  19. FractionText((coef2 * D2^(2)) + b2) → E2
  20. FractionText((coef2 * D3^(2)) + b2) → E3
  21. FractionText((coef2 * D4^(2)) + b2) → E4
  22. FractionText((coef2 * D5^(2)) + b2) → E5
  23. FractionText((coef2 * D6^(2)) + b2) → E6
  24. FractionText((coef2 * D7^(2)) + b2) → E7
  25. Random(1, 10) → intervalX3
  26. FractionText((coef3 * G2^(2)) + b3) → H2
  27. FractionText((coef3 * G3^(2)) + b3) → H3
  28. FractionText((coef3 * G4^(2)) + b3) → H4
  29. FractionText((coef3 * G5^(2)) + b3) → H5
  30. FractionText((coef3 * G6^(2)) + b3) → H6
  31. FractionText((coef3 * G7^(2)) + b3) → H7
  32. Random(1, 10) → intervalX4
  33. FractionText((coef4 * J2^(2)) + b4) → K2
  34. FractionText((coef4 * J3^(2)) + b4) → K3
  35. FractionText((coef4 * J4^(2)) + b4) → K4
  36. FractionText((coef4 * J5^(2)) + b4) → K5
  37. FractionText((coef4 * J6^(2)) + b4) → K6
  38. FractionText((coef4 * J7^(2)) + b4) → K7
  39. Random(1, 10) → intervalX5
  40. FractionText((coef5 * M2^(2)) + b5) → N2
  41. FractionText((coef5 * M3^(2)) + b5) → N3
  42. FractionText((coef5 * M4^(2)) + b5) → N4
  43. FractionText((coef5 * M5^(2)) + b5) → N5
  44. FractionText((coef5 * M6^(2)) + b5) → N6
  45. FractionText((coef5 * M7^(2)) + b5) → N7
  46. Random(1, 10) → intervalX6
  47. FractionText((coef6 * P2^(2)) + b6) → Q2
  48. FractionText((coef6 * P3^(2)) + b6) → Q3
  49. FractionText((coef6 * P4^(2)) + b6) → Q4
  50. FractionText((coef6 * P5^(2)) + b6) → Q5
  51. FractionText((coef6 * P6^(2)) + b6) → Q6
  52. FractionText((coef6 * P7^(2)) + b6) → Q7
  53. If(b1 < 0, (-b1), b1) → forTextb1
  54. If(b2 < 0, (-b2), b2) → forTextb2
  55. If(b3 < 0, (-b3), b3) → forTextb3
  56. If(b4 < 0, (-b4), b4) → forTextb4
  57. If(b5 < 0, (-b5), b5) → forTextb5
  58. If(b6 < 0, (-b6), b6) → forTextb6
  59. If(b1 < 0, " - ", " + ") → sign1
  60. If(b2 < 0, " - ", " + ") → sign2
  61. If(b3 < 0, " - ", " + ") → sign3
  62. If(b4 < 0, " - ", " + ") → sign4
  63. If(b5 < 0, " - ", " + ") → sign5
  64. If(b6 < 0, " - ", " + ") → sign6
  65. If(showAnswers ≟ true, (("y = " * coef1) * "x²"), "y") → yText1
  66. If(showAnswers ≟ true, (("y = " * coef2) * "x²"), "y") → yText2
  67. If(showAnswers ≟ true, (("y = " * coef3) * "x²"), "y") → yText3
  68. If(showAnswers ≟ true, (("y = " * coef4) * "x²"), "y") → yText4
  69. If(showAnswers ≟ true, (("y = " * coef5) * "x²"), "y") → yText5
  70. If(showAnswers ≟ true, (("y = " * coef6) * "x²"), "y") → yText6
  71. TableText({{A1, B1}, {A2, B2}, {A3, B3}, {A4, B4}, {A5, B5}, {A6, B6}, {A7, B7}}, "|_") → Table1
  72. TableText({{D1, E1}, {D2, E2}, {D3, E3}, {D4, E4}, {D5, E5}, {D6, E6}, {D7, E7}}, "|_") → Table2
  73. TableText({{G1, H1}, {G2, H2}, {G3, H3}, {G4, H4}, {G5, H5}, {G6, H6}, {G7, H7}}, "|_") → Table3
  74. TableText({{J1, K1}, {J2, K2}, {J3, K3}, {J4, K4}, {J5, K5}, {J6, K6}, {J7, K7}}, "|_") → Table4
  75. TableText({{M1, N1}, {M2, N2}, {M3, N3}, {M4, N4}, {M5, N5}, {M6, N6}, {M7, N7}}, "|_") → Table5
  76. TableText({{P1, Q1}, {P2, Q2}, {P3, Q3}, {P4, Q4}, {P5, Q5}, {P6, Q6}, {P7, Q7}}, "|_") → Table6