Wednesday, October 29, 2008

Screenshots of the Software


Pictures of Project Implementation

Here are pictures of Ifeyani and I implementing the project. I could not take many because my camera battery was about to go out. Please use these in the slide show. 









Instructions for the first time user:

 

The start screen includes three buttons:

Personal Information

Sign-In

Make a donation

 

It looks like this:

You will need to start with the button labeled “Personal Information”. Click it with your mouse. This takes you to a screen where you can enter your information in order to acquire an ID number that you will use to access your information, sign in, and make donations.

 

This screen looks like :

 

For right now, enter in your information and press “Enter”. You should see a screen that looks like this:

If you see any other message, you should enter your information again, correctly. You must enter your first and last name. Your ID number will pop up like this:

 

You need to write down the ID number for future use.

You can now use the reports menus and sign in.

 

Click on the House labeled “Start” in the upper left corner to get back to the start screen.

Click on the “Sign In” button if you are here to volunteer.

It should look like this:

Enter your ID number in the spot marked ID number. Press “Calculate Hours Worked” to determine the number of hours you have worked. Press “Enter” when you are finished.  You should see this screen again:

The screen will clear, and your information will be entered.

 

Click the “Make a Donation” button to make a donation.

The screen should look like this:

Enter in your ID number, the date, and your amount donated. Press “Enter”. Your information will be entered, the record added message will appear, and the screen will clear.

 

If you would like to access records in order to total all your hours or add up all your donations, use the “Reports” menu at the top of the contacts, sign-in, and donations screens. Enter your user ID and press the button for your information.

The screen should look like this when you’re finished:

You can print the information if a printer is available or save the information to a disk or flash drive.

 

To save the information:

To select all the information on a grid, click anywhere on the grid and press CTRL & A at the same time. The entire grid should turn green. Then press CTRL & C at the same time to copy the information. Next, click a spot on the white box, press CTRL & V to copy the information into the box. The screen should look like this:

Select the “Save” option from the “File” menu. Show me where you would like to save the file. Finally, click on the save button and give your file a name. It should be saved in the area you specified.

 

To Print the Information:

Click the Print Button.

 

To View Reports and Access All of Your Records:

At the top of the screen, click on the menu item labeled “Reports”. Choose the report you would like to view, and click it. Enter your ID or last name to view all your information.

 

 

 

Monday, October 27, 2008

Program Design Notes II

Notes II

 

Today I have decided that I need menus

 

File

Print

 

Exit

Query

My Donations

My Hours

My Contact Info

About

Instructions

About program

 

 

 

 

 

 

 

 

 

Okay so to use the datagrid, I cannot use a variable to extract the information… That sucks for individual reports

 

To fill the data grid with the dataset the format is:

Me.dataset.clear()

Me.oledataadapter.Fill(dataset)

 

 

The person icon is going to be your “personal assistant” like the stupid paper clip in word.

 

 

A print button needs to be installed on each form( I am using a button and not a menu item because I have a copy of the code I can reuse.

 

Done.

 

Now I have come across a problem. I thought a data grid would work with a variable, but no such luck. I am working on a command builder. At the very least, I can provide a way for the user to flip through his/her records.

 

The dataset should be sorted by date in the records searches beginning with my

 

Things to fix:

Code for worker

Area worked combo box

 

 

The program is essentially finished.

 Could some one design me an about form in Word?

And we need to do instructions.

 

 

Saturday, October 25, 2008

Software Copies

If you would like a copy of the software that I have designed so far, please let me know and I can send you the files or provide you with a URL so that you can download them. 

Please see the discussion area for screen shots. 

Software Design Notes

Design elements for the database application program

 

 

First Database:

Contacts database

ID:

First Name:

Last Name:

Address:

Phone Number:

Worker Code:

 

Second Database:

Sign In Database:

ID:

Date:

Time In:

Time Out:

Area Worked:

Worker Code:

 Hours Worked:

 

Third Database:

Donations Database:

ID:

Date:

Amount Donated:



Worker Codes:

1:Volunteer

2:Community Service

3: College Student

4: Home Owner

5: Other

 

 

To Do List:

  1. Iconize the project yellow logo
  2. replace the logo on the first form with a picture of a house being built

 

 

VB Forms:

  1. Intro
  2. Contact Information
    1. See all Activity
  3. Donations
    1. See all donations
  4. Sign in
    1. See all work performed

 

So 7 forms

 

All forms 10pt Tahoma Font

Form Size: 968 628

Background Color: Light Yellow

Start Pos. Center Screen

 

 

Tasks to perform:

  1. I need to update related records
  2. I would like to pull the ID from a form or questionnaire
  3. I need original graphics for everything

 

 

 

 

 

 

 

 

 

**** Go back and make sure that the search for the ID # on the sign in page is correct or remove it!

 

 

A good idea may be to modify the contacts db to reflect a password!

 

 

 

 

 

You must include all the tables in the grid view for the contacts

Also you need to find some way to pull the user’s id # without having to enter in all the information

 


It is really messy right now, but I am in the functional stage – not the UI design phase.

 

Right now I need graphics….

 

Ummm it should take another 2-3 days at most (I hope).

 

Feel free to give any input.

 

When I have a fully functional draft, I will put it online for you guys.

 

Day2:

 

I need to make a (subprocedure?) for the work number.

This can’t be queried using a combo box and a text box leaves too much room for error

 

I am just going to have to hide the text box control to save time and use the combobox to insert the values into the text box.

 

 

*** Back/Forward buttons need to be formed and used********

 

 

Did you know that you have to have Access only by itself to save the changes.

This took an extra 4 hours for me to learn hahahahahah

 

I am using date/time pickers – don’t worry – I will add these things as I go along.

 

I need to install mouseovers for the images that are used as buttons if possible

 

 The next 2 big steps:

User ID interface and

Crystal Reports

 

I do need to go back and do all of the icons in the title bar again

 

 

 

Let me tell you something you should NEVER do – rewrite a VB file. I lost about 4 hours worth of work!

 

Oh well, I should have a working copy around tomorrow night or the day after.

 

 

Saturday, October 18, 2008

Wednesday, October 15, 2008

Software For the Project


Please feel free to offer any advice for the design of the software for the databases. This is just a rough draft of the Q&A software I found. I think this will be an excellant time-saver for our project and perfectly suits our needs.

List of Duties: Brandon and Joshua

List of Duties: Brandon and Joshua

PR Specialist
Design pamphlet and logo for our team
Smooze with Habitat people in order to get our project implemented.


Research Project:
You are free to choose your own, but I think that the most useful for our project would be:

1) What are the most important people skills that an IT person can possess?
2) What are the essential graphic designs for a small business?
3) What is public relations and how does it help to accomplish our teams goals?

Please, can each of you choose one or create your own.


Project Duties:Your Duties are ongoing. They include:

You should attend the implementation of the project if at all possible.
You two are responsible for all the graphic designs our not-for-profit company creates.
Design and e-mail a pamphlet for our team with photos
You guys are responsible for catching the overflow. Be there when something extra comes up that no one is technically responsible for.

List of Duties: Doug

List of Duties: Doug

Call Center / Director
One person needs to provide a phone number and act as the administrator and hub for our project.
Be able to answer phones for a certain number of hours at least 2 days a week
Coordinate Activities
Keep track of email addresses, phone numbers, due dates, etc.


Research Project:You are free to choose your own, but I think that the most useful for our project would be:
How does a career as an administrative assistant relate to the Information Technology field, and do you feel that the gap between the two fields has narrowed?
Newspaper ads would be a great source of information for this research project.


Project Duties:
Your Duties are ongoing. They include:
Coordinating Team Meetings
Providing the entire team with a way to contact you where you can be accessed in less than 24 hours
You must be up to date on everything the team does
I will email you a list of contacts and IM ID’s , you are to keep up with them
The entire responsibility of the PowerPoint presentation rests on your shoulders.
Email me a copy of the presentation 3 days before it is due.
You should attend the implementation of the project if at all possible.

Monday, October 13, 2008

List of Duties: Scott

List of Duties: Scott

Software Specialist
This person must provide the database design software.
The database must be written to the software
An instruction manual must be written for the software


Research Project:

You are free to choose your own, but I think that the most useful for our project would be:

What is Symantec Q&A and how is it used?
Is there a freeware alternative to this software?
http://www.lantica.com/Files/quickanswer2/cQA0110.PDF is a good source.
This is the software that I have acquired and we will be using for this project.



Before Oct. 24 I need you to:
· E-mail me 7 different links to completely free versions of educational software for children.
· Provide me with the files from the soup kitchen
· Edit and Proofread the Q&A simple instruction module that I will create for our databases.
· I need you to be familiar with Symantec Q&A! I will do the databases and designs, but I need you to know what it is and how to use it.
· Email me links to any other freeware that you think I could use for this project.

Sunday, October 12, 2008

List of Duties: Saint

List of Duties: Saint

1. Hardware Gatherer / Project Implementer
Responsible for gathering computer, table, and peripherals together
Must be able to acquire a used computer, table, etc. through donations, etc.
Must be able to transport them to the Habitat for Humanity Thrift Store


Research Project:
You are free to choose your own, but I think that the most useful for our project would be:
What are the key elements to an effective database design?

A great primary source for this research project would be an interview with any company at all that has a database system. What are the things that are most important about and useful about their database system? Please let me know if you decide to do something different.


Before Oct. 24 I need you to:

Possess a computer in good working order with the following software:
Microsoft Office (Access is especially important)
Microsoft Windows (XP preferred)
Driver for an HP Deskjet D145
AVG free edition anti-virus
IOBit Advanced Windows Care (free online )
A photo editing software (Picasso is a free one from Google)
I think it would be a good idea to have a back-up of the system, but this isn’t mandatory.
Possess a table for the computer.
Be able to transport these to Athens (I can meet you half way if necessary)

Project Assignment # 4: Investigative Report

Project Assignment # 4: Investigative Report
Type of Assignment: Individual (I)
Percentage of Grade: 10%

Assignment Description

Your Service Learning Project requires research using both primary and secondary research
As members of a project team, you will each write a memo report on a different area of research that pertains to your Service Learning Project. For example, one member might interview your sponsor or an appropriate subject matter expert and write a memo report that summarizes the results of the interview. Another project team member might develop a questionnaire to survey possible clients that would benefit from your Service Learning Project. Still another project team member might write a memo report summarizing research on secondary sources, including appropriate Internet sources that pertain to your Service Learning Project.
In short, your combined research reports should provide you with a range of information from a variety of sources that will help you develop your Service Learning project and provide you with information for your final project report.
Set up your report as a memo report directed to your instructor and other members of your project team. Post it to the Discussion section of this lesson. Make sure your memo report includes the following parts:

1. Introductory Summary
2. Description of Conducted Research
3. Evaluation of Research
4. Conclusion

Wednesday, October 8, 2008

Project Assignment # 3: Interim Assessment Memo

Project Assignment # 3: Interim Assessment Memo
Type of assignment: Individual (I)
Percentage of grade: 10%
Assignment Description
For this assignment you will write an interim assessment memo reflecting your view of the communication issues and status of the Service Learning project. The purpose of the memo is two-fold:
1. To support your understanding of the group’s process and the effectiveness of communication within the group and
2. To inform your instructor of the status of the group’s effort at an intermediate point in the project
Although this assignment will not be due until the mid-point in the semester, you should begin keeping a journal with the first group meeting.
For every team meeting, include the date, the duration, and the members “present” and “absent” in the meeting. Also include the actions taken and the issues raised. See page 115 in Lannon, project #2, for a description of the points to include in your journal.
In a memo report to your instructor (not to your team members), summarize the achievements and setbacks in your project and include recommendations for improving collaboration as the project goes forward.
As Lannon describes, avoid attacking or blaming anyone, but be specific about what the issues are and how they will need to be addressed. If you feel you need the instructor’s help in addressing any issues in your group, describe the sort of help you need.
Of course, if your team process is working well, be sure to describe this, as well as the basis for the success you feel is occurring in your process and the evolving project.
This report, in memo format, should reflect good use of effective document design techniques to communicate the information to your instructor. The report should include details and examples from your journal to support your points. The memo should be several pages long.

Saturday, October 4, 2008

Project Planning Form - Please feel free to revise/edit and repost

Project Planning Form


Project Title: Humanitarian Database DesignersAudience: Habitat for Humanity Thrift Store
Project Manager: Henry Scott EstesTeam Members: Ifeanyi Egebike, Brandon Greene, Joshua Harrell, Henry Scott Estes, Amanda Fouts, Douglas HartleyPurpose of the Project: Provide Sign-in Database for the Habitat for Humanity Thrift Stores



Specific Assignments Due Dates

Project Planning Forms October 4, 2008
Interim Assessment Memo October 11, 2008
Investigative Report October 18, 2008
Peer Review – Progress Report November 8, 2008
Final Project November 15, 2008
PowerPoint Presentation November 20, 2008


Work Schedule
Team Meetings:
Interim Assessment Memo October 9-11, 2008
Investigative Report October 16-18, 2008
Peer Review – Progress Report November 6-8, 2008
Final Project November 13-15, 2008
PowerPoint Presentation November 15-20, 2008


Please check email and all other correspondence during these hours. Be prepared with a rough draft of the assignment on these dates and submit it for review. Project Implementation is October 18 – Nov 6. Please sign in to check the status of class at least 4 times a week during this time period.


Miscellaneous
How will disputes and grievances be resolved?
Email
How will performances be evaluated?
Attendance
Punctuality
Participation
Other Matters (Internet searches, email routing, computer conferences, etc. )?
All Internet matters should be routed through our Google account and posted to the blog.
Discussions should be posted concerning these matters.


Positions necessary for the implementation of the project:

1. Hardware Gatherer / Project Implementer
Responsible for gathering computer, table, and peripherals together
Must be able to acquire a used computer, table, etc. through donations, etc.
Must be able to transport them to the Habitat for Humanity Thrift Store
2. Software Specialist
This person must provide the database design software.
The database must be written to the software
An instruction manual must be written for the software
3. Database Designer
Design databases and assist in writing the databases to the software.
4. PR Specialist
Design pamphlet and logo for our team
Smooze with Habitat people in order to get our project implemented.
5. Call Center / Director
One person needs to provide a phone number and act as the administrator and hub for our project.
Be able to answer phones for a certain number of hours at least 2 days a week
Coordinate Activities
Keep track of email addresses, phone numbers, due dates, etc.

Friday, October 3, 2008

Names of Team Members

For Future Quick Reference:

The Yellow Team Members Are:
  • Douglas Hartley
  • Brandon Greene
  • Amanda Fouts
  • Ifeanyi Egebike
  • Henry Estes
  • Joshua Harrel

Quick Email Reference:

wbsitbgreene

wbsitiegbebike

wbsithestes

wbsitafouts

wbsitjharrell

wbsitdhartley