SILS iSchool

Task 04 | Spreadsheets

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

27 Sep | object layers
02 Oct | tools that read markup
04 Oct | document markup lab

Spreadsheets | sessions 15-19

09 Oct | spreadsheets
17 Oct | formulas & functions
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





You will be called upon to demonstrate specific spreadsheet skills on a set of worksheets.

Task ④ ⇒ spreadsheets

spreadsheets task logo

You will complete the following five exercises. Place the exercises in one workbook with each exercise on it's own worksheet. Name the worksheets "exercise 1," "exercise 2," etc. Exercise 1 has 6 parts. Place each part on the same worksheet and name each "exercise 1.1," "exercise 1.2," etc. Email the spreadsheet to me. Do not have to put it on your Opal account or link to it from your webpage. Make assumptions when necessary.

Everything in this task is something we will have demonstrated and/or tried in class.

back to top

back to top

Value Added | daily
Basics | sessions 01-05
Web Development | sessions 06-11
Document Markup | sessions 12-14
Spreadsheets | sessions 15-19
Relational Database | sessions 20-26
Presentation | sessions 27-30