STATUS REPORT
Project Name: Lockheed Martin
Student Name: Levi Smith

Week Ending on December 1, 2000
Accomplishments this week

3 hours: created Javadoc documentation for project
2 hours: presented system to client
1 hour: presented system to professor Smith 1 hour: revised my presentation slides 3 hours: prepared for presentation

Goals for next week

None

Problems this week

None

Week Ending on November 24, 2000
Accomplishments this week

8 hours: meeting with Mike and Brett at office to work on project; completed most of the work on the Data Generator; created about 5 JSP pages; helped Mike set up database on office computers

Goals for next week

Project wrapup; prepare for presentation

Problems this week

Who is this 'ajee' guy who keeps screwing with our web images??
Limited time to work on project this week due to Thanksgiving holidays

Week Ending on November 17, 2000
Accomplishments this week

1 hour: Group evaluation with Band group
2 hours: group meetings
1 hour: wrote database documentation with Tamrah for the website
2 hours: database and JSP development
- rewrote the user login code using separate Login and User beans instead of one UserBean that handled login and everything.
- currently the interface allows the user to log into the system with a username and password, view a list of devices and the behavior set related it, and and change their password; it also allows administrators to add new devices, add new users. When Mike and Brett finish the SQL writer class I will add it to the database package. I currently have the SQL statements hardcoded into the DatabaseConnection class.

Goals for next week

start thinking about bringing the project to an end this semester

Problems this week

Can't find a time to meet that fits everyone's schedule

Week Ending on November 10, 2000
Accomplishments this week

5 hours: continued work on database
3 hours: updated sql statements and screenshots on webpage

Goals for next week

Finish JSP pages??

Problems this week

Week Ending on November 3, 2000
Accomplishments this week

5 to 8 hours: database and UI development
3 hours: met with Mike and Brett at the office Friday to work on database, along with suggestions from Jeff
1 hour: late to team meeting on Wednesday... Mike and Brett gave me an overview of what was said during the meeting

Goals for next week

DB and UI development
Peer review with other group

Problems this week

- really busy schedule... hard to find time to work on project
- my procrastination on status reports

Week Ending on October 27, 2000
Accomplishments this week

Saturday - 5 hours: learned how to get Tomcat and Apache running
Sunday/Monday - 5 hours: worked on web interface; started creating JSP pages; posted screenshots of the JSP pages that I have created
Friday - 1 hour: meeting at office to discuss status
Firday - 1.5 hours: burned a CD with all of the tools I need to do the installation on the laptop

Goals for next week

- install Apache and Tomcat on server laptop today; hope the CD I made works

Problems this week

- couldn't install any software to the the laptop since it doesn't have dial-up networking or direct cable connection installed on it
- need a link to:
http://www.cc.gatech.edu/classes/RWL/Projects/lockheed/webdocs/screenshots/
on the main page

Week Ending on October 20, 2000
Accomplishments this week

Thrusday, October 19, 2000 - 1 hour: met with Mike at the office to make revisions to the database
Friday, October 20, 2000 - 1.5 hours: met with group at the office to discuss progress made and discussed what must be accomplished in the future
3 hours: setting up Apache and Tomcat on my system so I can create JSP pages; got apache running, but Tomcat seems to be a little harder to set up, especially since it hasn't been finalized yet

Goals for next week

- get sample screenshots of the user interface up on the web
- continue user interface programming

Problems this week

I'm a couple of days late getting my status report up

Week Ending on October 13, 2000
Accomplishments this week

2 hours: Meeting Sunday (October 8, 2000) to prepare for presentation.
2 hours: Meeting Monday (October 9, 2000) with Scott Hoyle after presentation in front of class; received suggestions for presentation improvements

Goals for next week

- finish database design
- continue working on the user interface

Problems this week

- inability to meet at 11am on Monday and Friday due to class presentations

Week Ending on October 6, 2000
Accomplishments this week

5 hours: database design and implementation in SQL Server; created database diagrams with SQL Server to post on the webpage
1.5 hours: UI design and implementation in Java; currently allows a user to log in with a password, displays devices, and allows a user to add devices and device types; all device and user information is stored into the SQL database, although only generic devices are stored
1 hour: meeting Sunday morning with team at noon to work on class presentation
1 hour: meeting Monday at 11am with team to work on database design
1 hour: meeting Friday morning at 9am with Mike to work on implementing the new database that Mike and David Morgan came up with; basically scrapped the design that we came up with on Monday
1 hour: another meeting on Friday at 11am in the CoC to get the updated database stuff on the web; moved the database designs to the short term project plan page

Goals for next week

- put final touches on presentation
- status report presentation for CS3351 class
- find out what Lockheed thinks about the new database design/diagram
- convert current Java application into a Java applet so it will run in a web browser

Problems this week

- I learned the syntax and semantics of SQL earlier this semester, but I am just now learning how professional databases are actually set up; I'm starting to wish I had taken a database course before signing up for this class

Week Ending on September 29, 2000
Accomplishments this week

3 hours: database design and implementation
2 hours: user interface design and implementation; learned how to connect and make SQL calls to the database from Java (user interface)
1 hour: created object and database diagrams, which Tamrah posted on the website today
1 hour: installed necessary Java files (Java SDK1.3) on laptop
2 hours: became familar with SQL Server 7.0 and constructed a database, thanks to the speedy installation by Brett and Michael
1.5 hours: Monday - meeting with Scott Hoyle of Lockheed at the office; spoke with David Morgan over the speaker phone; received two e-mails from David with database suggestions and criticisms
1 hour: Sunday - began database revisions with Eric at the office; Eric came up with questions for Lockheed that I asked at the Monday meeting

Goals for next week

- prepare for presentation in front of class
- continue working on database and interface

Problems this week

- the only way I was able to access the Lockheed database through Java was by setting the Lockheed database as the default in the data source in the ODBC Control Panel applet; there should be a way to access different databases in a data source through Java, but I haven't figured out how to do it yet; or maybe it's Micro$oft's way of giving Java developers a hard time(j/k).
- all team members need to write up their own damn status reports and not copy and paste from mine

Week Ending on September 22, 2000
Accomplishments this week

2 hours: Friday, September 22, 2000 - conference call with Lockheed; received information from Scott and Dave on database structure improvement
2 hours: began redesigning database structure
2 hours: kept in contact with group
2 hours: Friday, September 22, 2000 - learned more about SQL; learning how to connect Java front end to the database; found information on java.sun.com about JDBC, which allows java applications to connect to relational databases

Goals for next week

finish database design ASAP
help install SQL Server on laptops
get database running on laptops

Problems this week

waiting for a copy of SQL Server

Week Ending on September 15, 2000
Accomplishments this week

1 hour: Sunday, September 10, 2000 - meeting at Jeff's house to discuss use cases.
1.5 hours: Monday, September 11, 2000 - meeting with Scott Hoyle; he gave an overview of the project with a lecture slide presentation.
2 hours: Wednesday, September 13, 2000 - printed ER diagram, and created critique questions

1 hour: Wednesday, September 13, 2000 - downloaded and viewed lecture slide presentation from last year's team.
1 hour: Wednesday, September 13, 2000 - downloaded and examined the Access database created from last year's team; tried to convert the database to SQL using the export option in Access, but the SQL plugin for Access was not available on the CoC machine that I was using
1 hour: Thursday, September 14, 2000 - downloaded mySQL for Windows and became familiar with it
2.5 hours: Thursday, September 14, 2000 - began conversion of the Access database to a SQL script file; waiting to proceed any further until we find out the software that will be used for the database
1 hour: Friday, September 15, 2000 - conference call at the office with Scott Hoyle from Lockheed; discussed software issues

Goals for next week

- find out about the software we will need to use to code the database; the project sponsor wants to use Microsoft SQL Server but we do not have a copy or license for it yet
- meeting on Sunday to discuss risks
- find out how to update the SQL database from the front end (Java applet/ASP pages)

Problems this week

need MS Access on my machine at home, but I should be able to get by without it

Week Ending on September 8, 2000
Accomplishments this week

2 hours: Sunday September 3, 2000 - Met at Jeff's house and became familiar with UML diagrams. Also contributed to the construction of a UML diagram for the current Lockheed project.
2 hours: Tuesday Septemer 5, 2000 - Met at the office to begin work on the long term and short term plans for the Lockheed project.
2 hours: Thursday September 7, 2000 - Met at the office for a conference call with Scott Hoyle of Lockheed. Received criticism and suggestions from Lockheed about the direction of the project.
2 hours: September 3 - 9, 2000 - Continuing to learn SQL. Reviewed the completed long term and short term goals posted on web.

Goals for next week

Meeting with Scott Hoyle of Lockheed Monday.
Finish learning SQL.
Make sample screenshots of front end if no one else is doing them.
Maybe begin work on database / front end.
Whatever else the team needs me to do.

Problems this week

Just let me know what I can do to help and I'll jump on it.

Week Ending on September 1, 2000
Accomplishments this week

2 hours: downloaded, printed, and read project information. became familiar with the project
2 hours: team meetings
1 hour: explored project workspace on felix
3 hours: spent time learning SQL syntax and semantics. reviewed ASP.

Goals for next week

Learn more about the project

Problems this week

None that I can remember.

Week Ending on August 25, 2000
Accomplishments this week

0 hours: Friday, August 25, 2000 - assigned to Lockheed project and met with team in class.