ITSW 2334—Advanced Spreadsheets

Course Schedule (Tentative)

Week

Read/Practice

Assignments

Tests

1

Jan 16

Excel Tutorial 1

Tutorial 1 Review Questions due Jan 22.

Case Problem 1, page EX 46 due Jan 24.

 

2

Jan 22

Excel Tutorial 2

Tutorial 2 Review Questions due Jan 29.

Case Problem 1, page EX 87 due Jan 31.

 

3

Jan 29

Excel Tutorial 3

Tutorial 3 Review Questions due Feb 5.

Case Problem 1, page EX 137 due Feb 7.

 

4

Feb 5

Excel Tutorial 4

Tutorial 4 Review Questions due Feb 19.

Case Problem 1, page EX 187 due Feb 21

 

5

Feb 12

Complete test by Feb 15 at 8:00 am.

 

Test 1—Tutorials 1 through 3

6

Feb 19

Excel Tutorial 5

Tutorial 5 Review Questions due Feb 26.

Case Problem 1, page EX 246 due Feb 28.

 

7

Feb 26

Excel Tutorial 6

Tutorial 6 Review Questions due Mar 5.

Case Problem 1, page EX 293 due Mar 7.

 

8

Mar 5

(Mar 12-16 is Spring Break)

Excel Tutorial 7

Tutorial 7 Review Questions due Mar 19.

Case Problem 1, page EX 346 due Mar 21.

 

9

Mar 19

Excel Tutorial 8

Tutorial 8 Review Questions due Apr 2.

Case Problem 1, page EX 399 due Apr 4.

 

10

Mar 26

Complete test by Mar 29 at 8:00 am.

 

Test 2—Tutorials 4 through 7

11

Apr 2

Excel Tutorial 9

Tutorial 9 Review Questions due Apr 9.

Case Problem 1, page EX 450 due Apr 11.

 

12

Apr 9

Excel Tutorial 10

Tutorial 10Review Questions due Apr 16.

Case Problem 1, page EX 490 due Apr 18

 

13

Apr 16

Review for Hands-on exam.

   

14

Apr 23

Complete Hands-on Exam by Apr 26 at 8:00 am.

 

Hands-on Exam

15

Apr 30

Review for final

   

16

May 7

Complete test by May 9 at 8:00 am.

 

Test 3—Tutorials 8 through 10