MrBertman.com
Contact
Questionbank 
Classes
Tutorials
Projects
Excel
Creating interactive spreasheets
Follow this tutorial to learn how to create interactive spreadsheets. The contents of the tutorial include:
  • Absolute and relative references

  • Mathematical functions

  • Conditional logic

  • Creating and updating graphs

  • Conditional formatting of graphs

Scratch
Programming a computer game
Follow this tutorial to programme a simple game in Scratch. The contents of the tutorial include:
  • Responding to user input

  • Creating and responding to events

  • Conditional logic

  • Loops

  • Local and global variables

  • Programming simple artificial intelligence
Geogebra
Creating interactive geometrical models
Follow this tutorial to learn some of the basics of Geogebra and investigate a geometrical problem. The contents of the tutorial include:
  • Drawing lines

  • Moving points along lines

  • Drawing circles

  • Perpendicular bisectors

  • Loci

  • Recording data to a spreadsheet