To effectively showcase my product plans and creation designs. I will set a timeline, to make sure I am able to complete tasks before my deadline, with good product in the end. I have decided to create a gantt chart to show the amount and progress of my work daily. I have decided to take in account 10 days to portray the tasks that need to be completed for this criteria. The objective of this criteria is to create a solution for the user/client that will be using this product. This will help in creating a more efficient, effective, and easy to use product for the user or client. To effectively create a product that will be useful for my client, I will be referring to the interview I have taken previously, in order to create a successful and useful product for my client, to match their needs and showcase an appropriate style for their company. In order to achieve the best outcome for my product, each task has to be allotted a realistic time period allowing me to concentrate on individual sections, to complete each task with the highest of my abilities.
I will make sure that after I have completed the design I make sure the design is appropriate to my user/client - and is easy and quick and efficient for them to use. I have decided to spend more time on the creation for my designs and less time on the evaluation, as the designs are the most difficult part, when creating a design solution for a user/client. I will also be spending quite a bit of time in refining my product in the end for my user's satisfaction and expectations. I will be asking different people for a variety of opinions, to understand how my product is for different users, and whether it is successful or not. This process will be time consuming - as I will have to go around and collect data from different age people, to see the simplicity of the product, and what mistakes have been made to correct or changes that need work on. This will help me improve my product, before giving it to my client, for the company's use. This evaluation task will help me refine my work and fix any aspects of the software that are not up to date or up to the standard of the company.
When I will start to create a product plan I will create a table with the dates I will work on each task, the name of the task, the requirement of each task, the time frame - duration for each task, a column to show whether the task is complete or no by deadline, and the last column for evaluation for the results (How the task was done, and what went well, and any improvements that can be made). I will be spending one day on creating my result and information table for my product, this will make my product creation a lot easier, as I will clearly have all the tasks that need to be done, listed in a table.
When I start creating my designs on excel spreadsheet. I will be creating 3 tabs, for the user to use and navigate to reach different areas of the spreadsheet. The first tab will consist of a bold and clear heading of the electronics company (Sharaf DG). Under this I will have two option buttons, which will be made using the product designs I made earlier. The two I have chosen to fit my company appropriately are:
1) Employees: Company employee data which includes the staff ID (staff number), name title (Mr, Ms, Mrs), First Name, Last Name, age, sex, nationality, years worked (to keep record for each employee's number of years worked - for what position in the company), Position (to help the company's managers/heads to clearly see who has what position in the company/what role), qualification (this helps the company managers decide promotions depending on the qualification the employee has done), email (each employee has their own company email, which can be used by customers to contact these specific people in the company), phone number (to contact employees or to let managing directors and heads contact their employees on mobile), monthly salary, and annual salary (yearly).
2) The second design I have created is for products of the company. The company's product database has different product related data to determines different aspects of the company's product details. The different information I have added in my spreadsheet are: Product ID, the type of product (camera, TV, laptop, printer, wifi-router), features of that product (such as: abilities), distributer (who is providing the company with these types of products - electronics), manufacturer, net profit (how much money does the company receive yearly because of a particular product, this helps the company evaluate which product brings in how much money), warranty (when a manufacturer is promising to repair or replace it if necessary within a specified period of time), demand (measured in millions, this helps determine how much value each product has and how many people require and want it), stock availability (how much of that product is available in the company for consumers), price of product (this piece of information allows the company managers and heads decide if any changes need to be made for a particular product being sold).
Compared to my design sketch I made earlier for my client, while I was creating my solution in excel I added many new details, accounts, and formulas to make my product more professional and suitable for my company, and to fit the company's requirements. I spent some time to research on websites about real database on electronic companies around the world, this helped me develop my learning further to come to this conclusion to add more data onto my database for my excel spreadsheet, this made my product look further sophisticated and professional from the design sketches I had made earlier.
Home Page:
When creating the main menu, I decided to create a similar look to the Sharaf DG logo look, color, and style, to make my product similar to the actual shop websites, flyers, and advertisements - this will make my product match with the existing softwares used in the company. I have made my main menu very clear and easy so that the user can easily read and use it with no queries - to the system. The word Sharaf DG is bold and emphasized - to make the system look more clear. The layout is very simple, and as well eye-catching because of the various chosen colors. (Yellow), this color has been used to create a good effect to the user, and will match real Sharaf DG sites - making this database high standard and official for the company to use. This menu has been created, through some brain storming ideas and thoughts to help come to a conclusion for the most easy and feasible design, that can be made also professionally but also a capable design, for the user to look at.
Employees Macro:
On the home page/main menu of the spreadsheet, there are 2 macros (Employees and Products). I have created this for easy access to the Employees page/Products page. In this macro I have chosen to keep a dull color - unfortunately I was unable to choose my preference for the color fill in for the macro. I chose the dark blue color for my text, as it matches the Sharaf DG text in the logo. To make my macro button further detailed I decided to add a small icon of a person to represent the employees. I have tested this button multiple times to ensure that my software that I have chosen works to it's potential, to avoid errors or mistakes that may occur when the user is using the system.
Products Macro:
On the home page/main menu of the spreadsheet, there are 2 macros (Employees and Products). I have created this for easy access to the Employees page/Products page. In this macro, in order for it to match the Sharaf DG logo I decided to make the text dark blue - the same as the employees macro. Although, in this macro instead of a picture of a person I have chosen this image of horizontal lines. Before I chose this sign/symbol for my macro I did quite a bit of research. I looked at many different electronic websites, and most of them used this symbol to indicate the products that the company has (in stoke availability, type of product, price of product, etc).
Employees Page:
Employees: Company employee data which includes the staff ID (staff number), name title (Mr, Ms, Mrs), First Name, Last Name, age, sex, nationality, years worked (to keep record for each employee's number of years worked - for what position in the company), Position (to help the company's managers/heads to clearly see who has what position in the company/what role), qualification (this helps the company managers decide promotions depending on the qualification the employee has done), email (each employee has their own company email, which can be used by customers to contact these specific people in the company), phone number (to contact employees or to let managing directors and heads contact their employees on mobile), monthly salary, and annual salary (yearly).
Employees Formulas:
I have also created a data validation on the staff ID on the employee database page (tab 2). I made a number limit of 6 numbers - since the ID can only have 6 digit numbers. This will help decrease the rate of errors that the user might make during entering any data into the system. To do this I went and selected the entire row which I wanted to have this feature on, then clicked data in the options above, then I clicked data validation, and then I chose in the settings column: less than - from the options available, and then I typed in the maximum number - which was 6. In the message box I wrote down the message that I wanted to appear when a mistake was made, to inform the user what mistake they have made. In the title I wrote Staff ID Number Invalid, and in the main text I wrote - The staff ID number may not exceed 6 digits. Then to try this I entered different incorrect data, to test the validation of my data. And when this message appeared when incorrect data was entered, I knew that my system design was properly done.
In the employees tab, I have various information about the employee, and one column has title (Mrs, Ms, Mr). It seemed appropriate to add a combo box for this as it makes it easier for the user to choose from a certain set of data. To do this I selected the entire row which I chose to add this feature on and then I went to data, then data validation, then this time I selected list, and I entered in the data that I wanted to appear when the column box was clicked.
I did the same steps as before, to create another combo box. I selected the entire row, clicked on data, then data validation, chose, list, but this time in the list I entered the two options for the column. These options are male and female, for the combo box I made my system formal using F and M.
For the employee data, I have a column for the phone number for each staff. To avoid calculation errors/mistakes, that can be made when typing in large amounts of data, I decided to use data validation. I went in the data selection, then clicked data validation, and then I chose whole number and wrote the maximum number that can be entered in that particular column/box. I chose 10 - this is because all UAE numbers consist of 10 digits. In the message box I wrote down the message that I wanted to appear when a mistake was made, to inform the user what mistake they have made. In the title I wrote Phone No. Invalid and in the main text I decided to write - The phone number may not exceed 10 digits. To test this I entered multiple different incorrect data, consisting of 11, 12, 13, 14, and so on, to test my system for any errors. When the message appeared each time, I knew that my feature for my product was successful.
Products Page:
I have created this design for products of the company. The company's product database has different product related data to determines different aspects of the company's product details. The different information I have added in my spreadsheet are: Product ID, the type of product (camera, TV, laptop, printer, wifi-router), features of that product (such as: abilities), distributer (who is providing the company with these types of products - electronics), manufacturer, net profit (how much money does the company receive yearly because of a particular product, this helps the company evaluate which product brings in how much money), warranty (when a manufacturer is promising to repair or replace it if necessary within a specified period of time), demand (measured in millions, this helps determine how much value each product has and how many people require and want it), stock availability (how much of that product is available in the company for consumers), price of product (this piece of information allows the company managers and heads decide if any changes need to be made for a particular product being sold).
In the product's tab in my product design spreadsheet, the first column consists of the product ID, and since it is to do with numbers, when typing by hand many mistakes can occur, creating calculation problems/issues for the user. To avoid this simple mistake, I chose to add a data validation feature for this column. To do this I went on the data on the top, then I clicked data validation, then I chose whole number in the box - since I am not working with decimals in this particular data piece. Then I wrote in 6 - Since, the ID only consists of 6 digits. In the message box I wrote down the message that I wanted to appear when a mistake was made, to inform the user what mistake they have made. In the title I wrote Product ID Number Invalid and for the main text I wrote in - The Product ID number may not exceed 6 digits. To test this feature, I randomly inputed many different numbers in each box to test the integrity of the product feature. I received the error message each time, reassuring me that my feature was successful.
For the type of product column, I chose to input a combo box, since this was appropriate for this particular column. In the text that shows the options of what will appear I decided to write a few electronics which were: Camera, flatscreen TV, laptop, phone accessory, printer, projector, smartphone, tablet, USB drive, WiFi router.
For the warranty column I decided to add in a combo box - as this would be appropriate, because this column consists of data which can have several different options, that the user can chose from. In the text when creating my combo box, I wrote in the following data: None, 1 year, 2 years, 3 years, 4 years, 5 years, 6 years, 7 years, 8 years, 9 years, 10 years, and a lifetime.
In the last column for products - Price of product, I decided to input a data validation. This is to avoid any mistakes that can be made when typing in the data. I went and clicked data, and then data validation to open up the options to input this particular feature for the column which consists the prices of the products. I chose whole number and decided to choose a realistic price (10,000). After doing this I went on the message box and I wrote down the message that I wanted to appear when a mistake was made, to inform the user what mistake they have made. In the title I wrote Price Number Invalid, and for the main text I though to write - The price number may not exceed 10,000 AED. I decided to write in the units along with the number, this made more sense, and also allowed the user to know what unit they are working with.
In one of the columns for my products tab, there is a column for the stock availability of each product, mentioned in the list. To avoid error/mistakes when entering numerical amounts, I decided to input a data validation for this particular column. To do this I followed the exact same steps I had previously done for a few other data columns. I went on the data button, then clicked data validation - since I wanted to use this particular feature for this column. I selected whole number since this particular data does not require decimals or other various numerical options. For the whole number I accurately placed in the number - 10,000. Since, this number makes sense, and fits in with the pattern that the column is already following. In the message box I wrote down the message that I wanted to appear when a mistake was made, to inform the user what mistake they have made. In the title I wrote Stock Availability Invalid, and for the main text below I wrote down - The stock availability number must be at least 10,000.
When I will start to create a product plan I will create a table with the dates I will work on each task, the name of the task, the requirement of each task, the time frame - duration for each task, a column to show whether the task is complete or no by deadline, and the last column for evaluation for the results (How the task was done, and what went well, and any improvements that can be made). I will be spending one day on creating my result and information table for my product, this will make my product creation a lot easier, as I will clearly have all the tasks that need to be done, listed in a table.
When I start creating my designs on excel spreadsheet. I will be creating 3 tabs, for the user to use and navigate to reach different areas of the spreadsheet. The first tab will consist of a bold and clear heading of the electronics company (Sharaf DG). Under this I will have two option buttons, which will be made using the product designs I made earlier. The two I have chosen to fit my company appropriately are:
1) Employees: Company employee data which includes the staff ID (staff number), name title (Mr, Ms, Mrs), First Name, Last Name, age, sex, nationality, years worked (to keep record for each employee's number of years worked - for what position in the company), Position (to help the company's managers/heads to clearly see who has what position in the company/what role), qualification (this helps the company managers decide promotions depending on the qualification the employee has done), email (each employee has their own company email, which can be used by customers to contact these specific people in the company), phone number (to contact employees or to let managing directors and heads contact their employees on mobile), monthly salary, and annual salary (yearly).
2) The second design I have created is for products of the company. The company's product database has different product related data to determines different aspects of the company's product details. The different information I have added in my spreadsheet are: Product ID, the type of product (camera, TV, laptop, printer, wifi-router), features of that product (such as: abilities), distributer (who is providing the company with these types of products - electronics), manufacturer, net profit (how much money does the company receive yearly because of a particular product, this helps the company evaluate which product brings in how much money), warranty (when a manufacturer is promising to repair or replace it if necessary within a specified period of time), demand (measured in millions, this helps determine how much value each product has and how many people require and want it), stock availability (how much of that product is available in the company for consumers), price of product (this piece of information allows the company managers and heads decide if any changes need to be made for a particular product being sold).
Compared to my design sketch I made earlier for my client, while I was creating my solution in excel I added many new details, accounts, and formulas to make my product more professional and suitable for my company, and to fit the company's requirements. I spent some time to research on websites about real database on electronic companies around the world, this helped me develop my learning further to come to this conclusion to add more data onto my database for my excel spreadsheet, this made my product look further sophisticated and professional from the design sketches I had made earlier.
Home Page:
When creating the main menu, I decided to create a similar look to the Sharaf DG logo look, color, and style, to make my product similar to the actual shop websites, flyers, and advertisements - this will make my product match with the existing softwares used in the company. I have made my main menu very clear and easy so that the user can easily read and use it with no queries - to the system. The word Sharaf DG is bold and emphasized - to make the system look more clear. The layout is very simple, and as well eye-catching because of the various chosen colors. (Yellow), this color has been used to create a good effect to the user, and will match real Sharaf DG sites - making this database high standard and official for the company to use. This menu has been created, through some brain storming ideas and thoughts to help come to a conclusion for the most easy and feasible design, that can be made also professionally but also a capable design, for the user to look at.
Employees Macro:
On the home page/main menu of the spreadsheet, there are 2 macros (Employees and Products). I have created this for easy access to the Employees page/Products page. In this macro I have chosen to keep a dull color - unfortunately I was unable to choose my preference for the color fill in for the macro. I chose the dark blue color for my text, as it matches the Sharaf DG text in the logo. To make my macro button further detailed I decided to add a small icon of a person to represent the employees. I have tested this button multiple times to ensure that my software that I have chosen works to it's potential, to avoid errors or mistakes that may occur when the user is using the system.
Products Macro:
On the home page/main menu of the spreadsheet, there are 2 macros (Employees and Products). I have created this for easy access to the Employees page/Products page. In this macro, in order for it to match the Sharaf DG logo I decided to make the text dark blue - the same as the employees macro. Although, in this macro instead of a picture of a person I have chosen this image of horizontal lines. Before I chose this sign/symbol for my macro I did quite a bit of research. I looked at many different electronic websites, and most of them used this symbol to indicate the products that the company has (in stoke availability, type of product, price of product, etc).
Employees Page:
Employees: Company employee data which includes the staff ID (staff number), name title (Mr, Ms, Mrs), First Name, Last Name, age, sex, nationality, years worked (to keep record for each employee's number of years worked - for what position in the company), Position (to help the company's managers/heads to clearly see who has what position in the company/what role), qualification (this helps the company managers decide promotions depending on the qualification the employee has done), email (each employee has their own company email, which can be used by customers to contact these specific people in the company), phone number (to contact employees or to let managing directors and heads contact their employees on mobile), monthly salary, and annual salary (yearly).
Employees Formulas:
In the employees database spreadsheet that I have created I decided to use a formula for my annual salary to make it easier for my client to use effectively with ease. The client will just have to enter the monthly salary of the employee - and the annual salary of the employee will be automatically calculated. The formula I used for this was: = cell number × 12, to calculate the annual salary for each employee. Since there are 12 months in a year, I multiplied my cell value to 12 to get the final value of the employee's earnings in a year. For example, for the first value if you click the annual salary, on the top left-hand corner in the formula box (fx) you can see the formula I have used. (=M10*12) M10 is the cell number, this symbol * is to show multiplication and 12 is the number in the box that it will be multiplied with.
I have also created a data validation on the staff ID on the employee database page (tab 2). I made a number limit of 6 numbers - since the ID can only have 6 digit numbers. This will help decrease the rate of errors that the user might make during entering any data into the system. To do this I went and selected the entire row which I wanted to have this feature on, then clicked data in the options above, then I clicked data validation, and then I chose in the settings column: less than - from the options available, and then I typed in the maximum number - which was 6. In the message box I wrote down the message that I wanted to appear when a mistake was made, to inform the user what mistake they have made. In the title I wrote Staff ID Number Invalid, and in the main text I wrote - The staff ID number may not exceed 6 digits. Then to try this I entered different incorrect data, to test the validation of my data. And when this message appeared when incorrect data was entered, I knew that my system design was properly done.
In the employees tab, I have various information about the employee, and one column has title (Mrs, Ms, Mr). It seemed appropriate to add a combo box for this as it makes it easier for the user to choose from a certain set of data. To do this I selected the entire row which I chose to add this feature on and then I went to data, then data validation, then this time I selected list, and I entered in the data that I wanted to appear when the column box was clicked.
I did the same steps as before, to create another combo box. I selected the entire row, clicked on data, then data validation, chose, list, but this time in the list I entered the two options for the column. These options are male and female, for the combo box I made my system formal using F and M.
For the employee data, I have a column for the phone number for each staff. To avoid calculation errors/mistakes, that can be made when typing in large amounts of data, I decided to use data validation. I went in the data selection, then clicked data validation, and then I chose whole number and wrote the maximum number that can be entered in that particular column/box. I chose 10 - this is because all UAE numbers consist of 10 digits. In the message box I wrote down the message that I wanted to appear when a mistake was made, to inform the user what mistake they have made. In the title I wrote Phone No. Invalid and in the main text I decided to write - The phone number may not exceed 10 digits. To test this I entered multiple different incorrect data, consisting of 11, 12, 13, 14, and so on, to test my system for any errors. When the message appeared each time, I knew that my feature for my product was successful.
Products Page:
I have created this design for products of the company. The company's product database has different product related data to determines different aspects of the company's product details. The different information I have added in my spreadsheet are: Product ID, the type of product (camera, TV, laptop, printer, wifi-router), features of that product (such as: abilities), distributer (who is providing the company with these types of products - electronics), manufacturer, net profit (how much money does the company receive yearly because of a particular product, this helps the company evaluate which product brings in how much money), warranty (when a manufacturer is promising to repair or replace it if necessary within a specified period of time), demand (measured in millions, this helps determine how much value each product has and how many people require and want it), stock availability (how much of that product is available in the company for consumers), price of product (this piece of information allows the company managers and heads decide if any changes need to be made for a particular product being sold).
In the product's tab in my product design spreadsheet, the first column consists of the product ID, and since it is to do with numbers, when typing by hand many mistakes can occur, creating calculation problems/issues for the user. To avoid this simple mistake, I chose to add a data validation feature for this column. To do this I went on the data on the top, then I clicked data validation, then I chose whole number in the box - since I am not working with decimals in this particular data piece. Then I wrote in 6 - Since, the ID only consists of 6 digits. In the message box I wrote down the message that I wanted to appear when a mistake was made, to inform the user what mistake they have made. In the title I wrote Product ID Number Invalid and for the main text I wrote in - The Product ID number may not exceed 6 digits. To test this feature, I randomly inputed many different numbers in each box to test the integrity of the product feature. I received the error message each time, reassuring me that my feature was successful.
For the type of product column, I chose to input a combo box, since this was appropriate for this particular column. In the text that shows the options of what will appear I decided to write a few electronics which were: Camera, flatscreen TV, laptop, phone accessory, printer, projector, smartphone, tablet, USB drive, WiFi router.
For the warranty column I decided to add in a combo box - as this would be appropriate, because this column consists of data which can have several different options, that the user can chose from. In the text when creating my combo box, I wrote in the following data: None, 1 year, 2 years, 3 years, 4 years, 5 years, 6 years, 7 years, 8 years, 9 years, 10 years, and a lifetime.
In the last column for products - Price of product, I decided to input a data validation. This is to avoid any mistakes that can be made when typing in the data. I went and clicked data, and then data validation to open up the options to input this particular feature for the column which consists the prices of the products. I chose whole number and decided to choose a realistic price (10,000). After doing this I went on the message box and I wrote down the message that I wanted to appear when a mistake was made, to inform the user what mistake they have made. In the title I wrote Price Number Invalid, and for the main text I though to write - The price number may not exceed 10,000 AED. I decided to write in the units along with the number, this made more sense, and also allowed the user to know what unit they are working with.
In one of the columns for my products tab, there is a column for the stock availability of each product, mentioned in the list. To avoid error/mistakes when entering numerical amounts, I decided to input a data validation for this particular column. To do this I followed the exact same steps I had previously done for a few other data columns. I went on the data button, then clicked data validation - since I wanted to use this particular feature for this column. I selected whole number since this particular data does not require decimals or other various numerical options. For the whole number I accurately placed in the number - 10,000. Since, this number makes sense, and fits in with the pattern that the column is already following. In the message box I wrote down the message that I wanted to appear when a mistake was made, to inform the user what mistake they have made. In the title I wrote Stock Availability Invalid, and for the main text below I wrote down - The stock availability number must be at least 10,000.
No comments:
Post a Comment