Week 4: Company Brochure
As a customer a good website is a detailed and clear website easy to view and most needed information are be found on the first page. The web site should have home page, products and service and links for guidance and other relevant information. Therefore, a manager or a company should include, links to other information, “About tap”, “Products and Services”, “support tap,” scroll bar at the end to give customers an easy time in browsing the website. It is important to offer online chart to answer questions which customers might have as they browse through the website. The 24/7 online chart can be automated to ensure that various questions regarding services and products of a company is properly answered. Based on research and analysis of several websites, the components which should be included in the company’s websites are; things about the company which includes the board members, staff and the entire organizational chart. A company website should contain the details about the company’s products and services it offers the market, the link where customers can chart or interact directly with the company, if it is purchase or online store, there should be a purchase link and payment as well. A good website should provide navigating links on the top and should be clear and detailed with few pictures. The navigating links should be arranged on the top left of the website and there must be a bar link which gives customers links about the company and other information customers might need.
Week 4: Web Page
It is appropriate note the company’s website was built through “Bluehost.com”. A Bluehost.com is self web build site where individuals can use templates to design and build a good web site without having any problem. I choose to use “Bluehost.com” because it is simple and free site for building a website as long as the hosting as been paid and URL for the company is given. However, some of the problem which are experience when creating a website are gathering the right information for the website, getting the right hosting company, how to make website compliance with website accessibility standard and how to improve the users experience.
In order to over the challenges JQuery was used to improve the efficiently and usability if the website so that even people with disability can use the site. The detailed information was gathered and analyzes to make sure that the correct and only appropriate information are uploaded to the site. Research was also conducted on several hosting company through feedbacks to make sure that a reliable and effective company are chosen as the hosting firm. I did not know how to link social media page of a company with website and how they can be used simultaneously for the benefit of the company and through practicing, have known and I can properly link different social media page and make them so interactive in engaging customers.
Week 8: Assignment
Task 1: In Access, create one Query and then are port that summarizes the sales and profits by Agent (Susan, Karen, Bart, Connie, and Tony).
- Total Sales for all orders placed during the period for each agent
The total sales for placed during the period of each agent are; the total sale for Susan is $ 32,968.00, Karen is $ 54,352.75, Connie is $ 34,065.00, Bart is $ 99,812.25 and Tony is $ 77,718.75. Based on this analysis, it is evident that Bart had the highest total sales among the five agents.
- Average of all total sales for all orders placed during the period for each agent
The average total sale for Susan is 4709.71, Karen is 6039.19, Connie is $4,258.13, Bart is $9,073.84 and Tony is $8,635.42.
- Total Profit for all orders placed during the period for each agent
The total profit for Susan is $ 4,118.00, Karen is $ 7,157.75, Connie is $ 5,290.00, Bart, $ 15,662.25, and Tony is $ 9,518.75.
- Average Profit of all orders placed during the period for each agent
The average profit for Susan is $588.29, Karen is $795.31, Connie is $661.25, Bart is $1,423.84 and Tony is $1,057.64.
Task 2: In Access, create a Query and then a report that provides the following information by Product (Juicer, Toaster, Microwave, Can opener, Mixer, Blender).
- Sum of all Quantities sold by product
The total blender sold are 560, Juice are 1587, Toaster are 910, Microwave are 380 can Opener are 714 and the number of mixer sold are 241.
- Total Sales for all orders placed during the period for each product
The total sales for all orders during the period can opener is & 14,331.25, Blender is $ 27,963.00, $ 66, 603.25, Microwave is $ 110, 512.50, Mixer is 20, 950.50. Toaster is $ 52, 620.00.
- Average of all total sales for all orders placed during the period for each product
The average sales for blender are $ 5,592.60, can opener is $ 2,895.36, juicer is $ 6,054.84, microwave is $ 15,787.50, mixer is $ 4,190.10, and Toaster is $ 5,846.67.
- Total Profit for all orders placed during the period for each product
The total profits for all orders are as follow Blender $ 2,763, can opener $ 2417.50, Juicer is 9735.25, microwave is $ 15, 512.50, and Mixer is $ 2,875, and toaster is $ 7,120.00.
- Average Profit of all orders placed during the period for each product
The average profit for blender is $ 5,040.00, can opener is $ 2,550.00, Juicer is $ 5,049.55, microwave is $ 13,571.43, mixer is $ 3,615.00 and Toaster is $5,055.56.
