Spreadsheets with feedback

This is a group or individual assignment using Google Sheets or 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:

• Allow students to enter two 3x3 matrices and their product.
• Provide clear directions to students regarding how to use the spreadsheet.
• Provide feedback regarding the correctness of each cell of the product.
• Allow students to ONLY edit appropriate areas.

• Check answers with WolframAlpha's Matrix Multiplication Calculator

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 corresponding cells, multiplying columns by row or multiplying corresponding cells, etc.

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:

• Allow a student to enter factors up to two place values, e.g. 99×99.
• Provide directions for how to complete each step of the algorithm.
• Allow students to enter values for each step of the algorithm.
• Provide feedback whether or not the student's answers for each step are correct.
• Allow students to ONLY edit appropriate areas.

• Diagonal borders are found in Excel: Format → Cells → Border
  or Google Drive: Diagonals =SPARKLINE({1,2})
• mod() might be useful for isolating ones
• trunc() might be useful for isolating tens
• How will you handle "carry" values?

Three digit challenge (+2)

Modify each algorithm to allow for three-digit factors, instead of just two-digit numbers. Remember \(999 \cdot 999 = 998001 \).

Discussion questions

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

Protect Sheet

Google Sheets:

1. Data > Protect Sheet and Ranges
2. Select "Sheet"
3. Type description (this can be anything like sheet name or activity name)
4. Select "Except certain cells"
5. Select or type cells that can be edited by student
6. Select "Set permissions"
7. Select "Show warning when editing cells"
8. To get a link for your blog, please use the following directions to share in copy mode

Excel:

1. Unlocking appropriate cells (Format > deselect Lock Cell)
2. Protect worksheet (Format > Protect worksheet).
3. PLEASE keep password blank!!!

Submission

Submission

Submit the URL for your assignment to the correct Canvas discussion board. Recall that the discussion board is used as a way to share ideas between (preservice) teachers.

Please print relevant pages if you want more detailed feedback.

For group assignments, only one submission is needed per group, but please make sure all group members have included their names on the submission.

Also, calculator programs will be run for the instructor on the due date.

Excel scoring guide 20 MTP