Term 3

Term 3
Website creator
file:///C:/Users/Student/Desktop/trans.html

Term 2 Tech Fair Criteria A

CRITERIA A

My two ideas for a project:

1. A Surveillance Drone to help the Police

Purpose and Audience:

The purpose of this product is to make it easier for the police to catch their targets easily. The main audience is for the police at situations where they cannot find their target during a chase or maybe a shootout.

Materials Needed:

A quad copter kit

A battery

Multicopter motor

Wings

Quad copter prop set

Flight controller mini board

Flight controller

A camera

3 multimotors

SWOT Analysis

Strengths Easy to use Reliable Durable Saves lives	Weaknesses Takes time to charge Very expensive to mass produce May malfunction Requires a good user
Opportunities Robotics skills Could add radio control Assembling components of a mechanical structure Could be made with cheaper parts	Threats Could Fall on someone Could cause mayham at a shootout Could cause destruction to property

Advantages:

Creating a surveillance drone has its own perks. It is very helpful for a mass audience. It is not very heavy so it can be easily carried around. It has powerful motors so it can fly various heights. As it is small it can do various maneuvers. It will be convenient for the police as when they are trying to catch someone they can just use this drone as it is very quite and will be able to see far distances due to its HD camera. And as it being a drone it is prone to malfunctions.

Disadvantages:

I think that this project has very less disadvantages as it is made for a good. The only disadvantages are that it will not be easy to make one. They will also be some problems due to the range of the controller to the drone. The last problem will be that it will require either a professional or a pilot to control the drone during important situation.

2. Rover 5 (Android controlled RC Vehicle with real-time Video via Bluetooth & Wi-Fi)

http://www.instructables.com/id/Android-controlled-RC-Vehicle-with-real-time-Video/

Purpose and Audience:

The purpose of the application is to help Parents to keep an eye on their kids without moving around and it can also help the police for surveillance. The audience targeted would be the parents or the police or schools to keep surveillance around the place.

Materials Needed:

Dagu Rover 5 platform

Electronic control boards

Remote control boards

A smart phone or tablet device

A power system

SWOT Analysis

Strengths It allows android users to have a piece of mind on what is happening around It is very easy to make It is cheap It is durable	Weaknesses We have a lack of knowledge on how to make it There maybe problems due to the range Can be easily spotted
Opportunities Application development skill Could make it camouflage Could make it look more visually deceiving.	Threats Could be an inconvience for some people Could start threats around places Can be used for other uses which are not targeted for.

Advantages:

The advantages for this project are many. This generally helps everyone around the world. The camera on this can be used to see what is going on around the place. It is a commercial product and can be sold around the world. The main purpose for this is that it can help parents look after their babies/kids when they r busy and for schools where they can see whether all the kids are behaving or even for the police to go into situations where a normal human being cannot enter. It can be controlled through your phone or a remote control.

Disadvantages:

It is easy to make but very complicated for ali and I because we have no experience in robotics. It is easily spotted during operations because it is on the ground where anyone can see during the morning. The controller is a phone so if there is no charging then the drone will be of no use for the owner. The rover can also malfunction due to various users at once as phones control it.

Secondary Research:

•   Ali and I will be searching up YouTube for projects and steps to make drones.

•   We will be using various websites to do research and development for the product.

•   We will be looking at self-made robots as they will have more instructions and also easy to make.

•   We will have to research various websites for getting the parts and how to get them.

Design Brief:

After doing thorough research on our ideas Ali and I have come to a conclusion that we will make a drone as it is easier to make and also it will teach us how to do robotics and improve our skills on software development. This will be a major challenge for both of us as we are only 15 with no experience of how to develop a software for the drone. This product will feature:

Surveillance of the place targeted at.

Can drop  items from various heights.

Can collect voice and video with HD quality.

Can help catch thieves/terrorists.

Criteria D

CRITERION D

EVALUATING

Criterion D Reflection and Evaluation

Reflection on Investigation

This was my first time using the software Microsoft Access. I has never heard of this software in my life before so it was very exciting for me to learn on how to use a new software. To start creating my program i had to first learn on how to make a program and then I had to research on what my program would be based on. I interviewed the owner of Car Expo Rentals as they needed a replacement for their program they had before. After the interview I made a research plan and conducted my research accordingly. After the research I made a SWOT analysis and a design brief to gain a clear idea of the product that I will create. Overall I think that my product has been created professionally and has kept up the expectations the client needed.

Reflection on Design

I created the designs for my work as i needed a base to start on because I had no idea on how the program works in the first place. I then researched various validation rules that can be used to make the program more usable and to have easy access to data. I created a test plan so that the program that i was creating would be functional and would not be dis functional by the time i finish the final product. I created several designs onpaper for me to choose on as it would be required to make what my client would like. I only had 1 design as I did not know how to use the program so I could nt risk it on making a bad design. The design that I used for my final program was the one I drew but I had to make changes in the process as I was learning on what to do in the program.

Reflection on Project
-Problems faced

The biggest problem I faced during the creation of the final product was learning what to do in the program.During the creation process I struggled on how to create a Login form as it was hard to find scripts on-line but then when I did more research I found all the data I needed for creating it.The second problem I faced was to put tools onto my program as I had no idea on what to do because I was absent on the day my teacher taught us on how to do it. I had to do alot of research and also ask my friends on how to do it. Thee research I had done sometimes had some outdated scripts which did not work so I had to jumble up the scripts to make them work. 

-Design Specification Evaluation

·         The background had to have a nice scenic picture 

·         Had to promote the company by putting the logo in it

·         Had to look colourful

·         Had to look professional and organize

·         display pictures of cars in the rental fleet

·         contain information on the make of car; year of production; gas mileage; overall mileage; service information; rental dates; body type; color and other important information

·         be easy to use

·         look professional

After carefully analyzing the design specifications made by my client Mr.Copper i feel that I've kept up to his expectations and also can say that I've added some more features than he has asked me to put in the program.

-Peer Reflection 

To gain further feedback and advice I asked some of my peers about my database.

Laith:

"This database has been made with a lot of hard work. I feel that this database is very easily accessible and also the background is very nice to see whilst using the database. I am looking forward to using this as a base and also very excited to use the final product"

Ahmed:

"I feel that that this project is very nice to use. I really liked the way the colors all matched up and how it was laid out as a whole program.The database is easy to use and I really like all the useful tools and the queries. The only improvement I would make is making the queries/reports easier to close." 

-Possible Improvements

·         To remove the glitch that happens when you try to see the other cars in the fleet as it seems to be a problem to be solved with professional help.

·         Fix the Microsoft Access shortcut

·         Create an easier way to close form and queries. This fix would allow the database to be easier to use.

·         A feature that allows the simple creation of queries

·         A feature that informs the user about regular backups. 

·         Need to create another button in all the forms so that backing up is easier for all types of users.

Criteria C

Criteria C
Creating the solution/product:

The Login Menu:

The Main Menu:

The Car Data Form:

The Rental Data Form:

Customer Information:

The Query Menu:

Reports Menu:

Tools Menu:

This is the product that I've created for my customer Mr. John Copper. The final product/database has been made with specific specifications as per of the users in my clients company and also it has been modified with my peers reflections on my product. The product will be given to my client for further response on how it is and also on how it needs to be improved.

CRITERION B

CRITERION B
Developing ideas

Plan for: Car Data

Field Name	Data Type	Width	Example
License Plate	Text	7	A 12345
Brand	Text	25	Nissan
Mode	Text	19	Lancer
Year of Production	Number	5	2012
Mileage	Text	15	10000KM
Engine Displacement	Text	10	2000cc
No. of cylinders	Text	4	V2
Color	Text	19	Red
Seats	Number	2	5
Transmission	Text	15	Automatic
Picture	OLE object
Service History	Scan as picture
Rent per Day	Number	8	345
Date Rented	Date		22/2/2015
Date Returned	Date		28/2/2015
Days borrowed	Number		13
Type	Text	20	Sedan
Accident	Yes/No  Field	3	Yes or no
Extra Features	Text	1000	Air Conditioning

Validation Rules:

Field Name

Validation Rule

Validation Text

License Plate	Presence check, Is not null	This field cannot be left empty
Brand	Presence check, Is not null	This field cannot be left empty
Model	Presence check, Is not null	This field cannot be left empty
Mileage	Presence check, Is not null	This field cannot be left empty
Colors	Presence check, Is not null	This field cannot be left empty
Transmission	“Automatic” or “Manual”	Please write Automatic or Manual
Date rented	Presence check, Is not null	This field cannot be left empty
Return Date	Presence check, Is not null	This field cannot be left empty
Accident	“Yes” or “No”	Please write Yes or No
Extra features	Presence check, Is not null	This field cannot be left empty

Plan for: Customer Data

Field Name	Data Type	Width	Example
First Name	Text	15
Last Name	Text	30
Phone No.	Number		0567890123
Date of Birth	Date		14/6/1996
Nationality	Text	30
ID Number	Number		21656
License Number	Number		123456
Police History	Text	150	No fines

Menu layout flow chart:

Login Flow chart:

Design 1:

Login:

Main Menu:

Fleet:

Rental Information:

Customer Data:

Query Menu:

Tools:

Evaluation:

This chosen design showcases the basic layout of my database. It does not showcase what will be a combo-box and a button but the features will be implemented into the final product. This design has the employers chose color scheme and can look very professional once finalized. There are quite a few improvements that can be added if this design is chosen, The sizes and positioning should be adjusted slightly and the data fields need to be adjusted to correspond with the correct data. If finalized the design should include the company's logos and pictures instead of text on some of the buttons. This design is good as a basic idea but would need major adjustments that can make it even better.

Test plan:

Test Level	When?	Who?	Passed/Failed
Unit Testing	20th Oct	Personal Testing
Integration Testing	21st Oct	Personal Testing
Security Testing	23rd Oct	Secondary Testing
Connectivity Testing	25th Oct	Personal Testing
User Acceptance Testing	27th Oct	Secondary Testing
Production Verification Testing	30th Oct	Secondary Testing

Chosen Design:

I have chosen the first design as it looks more visually appealing and fits the exact color scheme of the employers company. It looks a bit messy as it is a basic design but with small adjustments the design can be improved to look really professional with many features that are useful for the company. Buttons and combo boxes will be used to make it have professional features and the size of the components will be adjusted to make a good design. Logos and pictures will also be used to give the database an added WOW factor. In conclusion the design itself appears to be a bit messy but with some finalization can be made to look very professional. I believe that this design has the most potential and that is why I have chosen it. All the features missing in the first design will be added in the next criteria as they couldn't be shown visually.