Here's a small resource. Currently, it's aimed for developing understanding of sequences through fill handle. Later, a formula with absolute referencing can fill the table. As well, there is a lot of formatting present that can be used to illustrate the importance and utility of formatting.
Love it, I will try it this semester as an exercise for semi-absolute referencing. And I think I will give it without instructions first to see if the "Excel way", meaning fill handle and references, is integrated or if there are still students that will at first do it one by one.

This is a tough problem that uses ifs to solve it. easyBridge solution: In cell E3, =C3+E1 then copy it to all the intersections. hardbridge solution: In cell E3, =IF(D3=1,C3,0)+IF(E2=1,E1,0) then copy it to all the intersections.

Some patterns that can be painted to create nice tilings.

Implicit, explicit, and formula

Start with fill handle to do odd numbers. Move to explicit reference +2 drag. Show how powers of 2 can be computed the same way. (what about squaring the last number?) Finish with a formula like 2n-1 and 2^n using two columns. (2^(2^n) yikes!) Here's a summary after the activity

## mini topics

## Table of Contents

## Times Table

importanceandutilityof formatting.Love it, I will try it this semester as an exercise for semi-absolute referencing. And I think I will give it without instructions first to see if the "Excel way", meaning fill handle and references, is integrated or if there are still students that will at first do it one by one.

## Weighted Average

## Standard Deviation motivation?

## Frequency vs Countif

## Simulation / Random

## Sum so far a.k.a. running total

running total. Maybe introduceifhere to say what's the most expensive item.## Text manipulation with & and len()

## Lookup tables

## HailStone

## percent change example

Here's an example that might connect things for the students:- A camp of 20 people and 80 people arrive--big change (400% -- like 4 new camps)
- A city of 1000000 people (Abu dhabi or Dubai) and 80 people arrive. (0.008% -- no change)

might be useful to talk of supplies (food, water) to drive the point home## Bridges

## Format painting Tilings

## Implicit, explicit, and formula

Start withfill handleto do odd numbers. Move to explicit reference +2 drag. Show how powers of 2 can be computed the same way. (what about squaring the last number?) Finish with a formula like 2n-1 and 2^n using two columns. (2^(2^n) yikes!) Here's a summary after the activity## Data sets

SubwayNutrition.xlsx

- Details
- Download
- 27 KB

transcribed from the website (should have used the PDF link)

(wow, lot of work there! Nice data set, will be for sure useful)