## 17 Oct 2018

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

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

22 Oct | data display
18 Oct | Fall Break
24 Oct | database tools

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

## School Information

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

THEY DO NOT HAVE TO BE TURNED IN.

### Practice exercises with formulas and functions

Use this example for practice

### Formulas

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.