Have students use spreadsheets to analyze a dataset of their choice in order to provide an interesting and relevant context for developing their spreadsheet skills.
Emphasize the importance of documentation when working with spreadsheets or any programming language for future reference.
Use programming spreadsheet functions as an introduction to programming to give students a simple but powerful mechanism for writing basic programs.
Have students write out test cases and their prediction for what their code will do in class before running it to teach them the practice of analyzing their code first.