Value Added | daily

**Class Schedule**

Basics | sessions 01-05

22 AUG | intro

27 AUG | clients

29 AUG | servers

05 Sep | networks

10 Sep | basics lab

Web Development | sessions 06-11

12 Sep | structural layer

17 Sep | presentational layer

19 Sep | working with layers

24 Sep | behavior layer

26 Sep | images & design

01 Oct | website lab

Document Markup | sessions 12-14

03 Oct | object layers

08 Oct | graphics

10 Oct | document markup lab

Spreadsheets | sessions 15-19

15 Oct | spreadsheets |

17 Oct | formulas |
functions |
all functions |
practice exercises |
next session

22 Oct | data display

18 Oct | Fall Break

24 Oct | database tools

29 Oct | spreadsheets lab

Relational Database | sessions 20-26

31 Oct | relational databases

05 Nov | tables

07 Nov | relationships

12 Nov | input & output

14 Nov | SQL

19 Nov | complex queries

26 Nov | databases lab

21 Nov | Thanksgiving

Presentation | sessions 27-30

28 Nov | presentation design

03 Dec | presentation delivery

05 Dec | presentation lab

12 Dec | 0800-1100 | final in class presentation

This work
is licensed under a
Creative Commons Attribution-NonCommercial-ShareAlike 3.0 Unported License.

home & schedule | class blog | syllabus | contact | grades

Do these practice exercises to familiarize yourself with the formulas and functions.

THEY DO NOT HAVE TO BE TURNED IN.

Use this example for practice

Note the formula in cell E3 on the Adding formulas tab. It adds the value of one cell to the value in a second cell and puts the result in cell E3.

Note the formula in cell H2 on the Adding formulas tab. It adds the value of one cell to an absolute value and puts the result in cell H2.

Note the formula in cell B3 through B19 on the Adding formulas tab follow the same pattern, but include cell formatting to reflect the increase in days by week.

Note the formula in cell I2 on the Adding formulas tab. It adds the value of one cell in a relative location to the value in a second cell at an absolute location and puts the result in cell I2.

Using the grab handle, drag the value in J2 down through J19.

In cell G28, create a formula that adds the value in cell C3 to the value in cell H3, then divides that answer by the value in cell D3. It makes little sense, but it does show a formula.

Using the grab handle, drag the value in G28 down until it no longer shows any values. If you see a cell that shows a "divide by zero error", use the trace precedents tool in the formulas ribbon to see where the problem lies.

In the Least Squares Calculations worksheet, look at the functions in lines 24 and 26.

Drag the value in cell B4 down to B23 and see what happens to the cells that are dependent on those values, both on the Least Squares Calculations worksheet and also on the Residuals Calculations worksheet. Try it several times.