Spreadsheets with feedback (w/ Excel)

This is an individual assignment using MS Excel that focuses on giving feedback and restricting access within spreadsheets.

Matrix multiplication

Create a spreadsheet to check 3x3 matrix multiplication.

The spreadsheet should:

Matrix challenge (+1)

Spread sheet gives more formative feedback based on common mistakes. Please indicate what types of mistakes I should test for, e.g. multiplying columns by row or multiplying corresponding cells.

Alternate algorithms

Create spreadsheets that provide step-by-step instructions for computing a product using other methods besides the US standard algorithm.

Alternate algorithms to address:

  1. Partial products
  2. Lattice multiplication

For each algorithm, the spreadsheet should:

Challenge (+1 TP)

Solve the 7-11 problem using a spreadsheet. Explanation should be given regarding how the spreadsheet helps solve the problem.

Discussion questions

  1. What are some advantages of creating interactive spreadsheets?
  2. What are some disadvantages of creating interactive spreadsheets?

SUBMISSION

  1. Publish the assignment to your EduBlog by:
  2. By submitting the assignment, you acknowledge that all work is your own.

Excel scoring guide 20 TP

Matrix multiplication

Directions for students are _____ accurate and clear.

  • 3 - very
  • 2
  • 1
  • 0 - not

Students can enter matrices for multiplication (1 TP)

Students receive feedback whether or not each cell of the product is correct (1 TP)

Students can only edit appropriate cells (1 TP)

Partial products (alternate algorithms)

Steps for students are _____ accurate and clear.

  • 3 - very
  • 2
  • 1
  • 0 - not

Students can enter values for each step (1 TP)

Students receive feedback whether or not each step/cell is correct (1 TP)

Students can only edit appropriate cells (1 TP)

Lattice multiplication (alternate algorithms)

Steps for students are _____ accurate and clear.

  • 3 - very
  • 2
  • 1
  • 0 - not

Students can enter values for each step (1 TP)

Students receive feedback whether or not each step/cell is correct.(1 TP)

Students can only edit appropriate cells (1 TP)

Discussion questions

Reasonable advantages (1 TP)

Reasonable disadvantages (1 TP)

CHALLENGES

MATRIX: Provides "extra" feedback for common misconception(s) (+1 TP)

7-11 PROBLEM: Clearly solves problem. (+1 TP)

Points: 0