A Homework

Ch 17, do the Progress towards a goal, and the Gantt chart.

Take home midterm #1

The midterm is available here.

Take home midterm

is still in development. Sorry.
:(
Check back later.

Schedule for coming weeks

Wednesday, Oct 8 -- no class
Monday, Oct 13 -- Columbus Day, no class
Tuesday, Oct 14 -- Monday schedule, but even so, no class
Wednesday, Oct 15 - no class
Monday, Oct 20 -- no class
Wednesday, Oct 22 -- no lab, but there will be lecture. (at 7:30 PM-8:20 PM)
Monday, Oct 27 -- there will be class

Last Class Home Work

1) Generate the ASCII chart using the code function.

2) Using the pattern in the book as a template, write a formula which will make a letter uppercase.

3) Write a statement using the AND function and CODE function which tells whether a character is a lowercase character.

Video explanation of part of HW #4: Relational Database Using Offset and Match

Lab 4

Intended topics:

VLOOKUP
HLOOKUP
LOOKUP
MATCH with INDEX

SEARCH to find position within string.
MID to take a slice of a string
LEN to get length of a string
TRIM trims whitespace from beginning and end, and doubled whitespace in the middle.

1) Given a field containing someone's firstname followed by lastname, extract the first name.
2) Given the same field, extract the last name.

UDFs.

Homework:
1) Do relational database with MATCH and INDEX.
2) Given a field containing someone's firstname middlename lastname, extract the middle name.
3) Let us say that a sentence can contain up to 5 words. Combining IF with SEARCH, write a formula which will tell you how many words exist.
4) Write a UDF which returns X squared.