TESTS: 

            We will have four tests comprising 75% of the grade. The final is just another test. Each test is worth 25% of the final grade, the lowest test grade will be dropped. Test 1 will be a general in-class Java competency exam. Tests 3 will be a mock Java Programmers Certificate Exam. Test 4 (final) will be in-class written tests.

 Test 1: Has a Safety Net....

(If you do poor on in-class test you may do CIM7A assignments P1-P5 for C Grade)
(P1-P3 on CIM7B for B Grade)
(TicTacToe write an awesome player for A Grade)

Test 1 results: range 47..99 mean 80 median 89:
Grades for Test1: 99, 97, 90, 89, 83, 55, 47;

4/2/05 Added an additional sample file,
4/3/05 added some hints on creating the column header
4/5/05 Fixed number of fields per record vary file to file; report the number of fields per record

Addendums listed at end

Test 2: Due 4/9/05 11:59PM
Remember No Class 4/4/05
I will be in lab from 6-10:00PM (have Flash lecture 7-9) Thursday 4/7/2005;
If need arises, I can arrange to be in lab from 5-10:PM 4/7/2005

For C Grade Write a Program that can read a file, and outputs the number of characters, records and fields in the file. I will e-mail a sample file sometime this weekend. The file will have the following structure....

Each record will be terminated with a new line; the | vertical bar is the field separator. The first line in the file is the header line, containing column names, column names will not have spaces.

For Example, First Line: Header Line

ColumnName1|ColumnName2|ColumnName3...\n

Second Line to end.

Field1|Field2|....\n

Actual file example....

Name|Address|School|Age|Major
Dan|Mission Viejo|SB|26|PD
Tom|Oceanside|SB|25|T

You can assume the file will have no blank lines. Java.util.Scanner and other classes have a useDelimiter method, that you can use to set the delimiter. Note you last delimiter is the new line.

For B Grade, create a Vector that stores each field name.

For B+/A- Grade, implement SQL query statements.
Give Prompt Select-> if use enters a columnname
You need to printout each records field that corresponds to the column name.

For example

Select->Address

Program kicks out....

Mission Viejo, Oceanside

For A/A+ grade, you need to add the sum and min function to your select query.

Select->min Age

kicks out 25

Select->sum Age

kicks out 51

Additional Sample File 4/2/05

Data.txt....

Name|Balance|LastTransaction|Bank
Tom D|10000|-100|B of A
Dan D|20000|100|Wells Fargo
Rich|1000|-200|B of A
Santha Kumari|5000|1000|WM

End of File

Select-> Bank
Output-> B of A, Wells Fargo, B or A, WM

Select-> sum LastTransaction
Output-> 800

How do you setup the column headers...

Vector ColumnHeader = new Vector();

s = scan.nextLine(); //read the first line in the file;
StringTokenizer str = new StringTokenizer( s, "|" );

for each token
while( str.hasMoreTokens() )
ColumnHeader.add( str.nextToken() );

note vector size is dynamic, so it grows upon demand

> No of fields ? --- Is it the number of columns per record or total no
> of
> columns of all the records?

You can assume each record has the same number of fields
report the fields per record. Note you then have the total number of fields.

Test 3 Mock Java Exam. Due 5/14/2005

Create a 60 question Mock Java Exam at http://www.jchq.net/phezam/

You need to verify that you have taken the exam on the scoring send me your
grade and the precentage you need to pass the programmers exam.

To pass this test you need to complete a Java Exam Cram book maybe next
time I teach the class, I will include the Exam Cram Book as a recommended or alternative textbook.

You will automatically get 50/50 points for just taking the tests.

Second part of test complete homowork assignment P7

Test 4 Final Due 5/22/05 Midnight (No Later)

Assignment P8, Question 2 Page 791

Assignment 6 Page 821 (Turns P8 into an Applet)

Click below to log on to On-Line Quizzes
http://socccd.blackboard.com

For User ID - Password FAQ

5/17/04 T4/Fina1 7:30-9:30

Final Grades CIM7B Spring/04