E-Commerce reassessment: Product Database

I set up my excel database for my products and have chosen Product name/product numbers and took the prices off the website. The other columns are unit prices, units sold and sales. 



I formatted my table to give  column headings, and made them bold, and added colours to clearly mark the columns from each other. The units price and items sold are added to give me data to work with for charts and formulas. I have also added the filter function on all the columns.


I pulled down the formula from first cell to apply it on the rest of the table. I also added the SUM function to my table to get the total number of sales, units and price.


I also added the pie chart by selecting the data in the table and inserting the 2d pie chart.




I changed the headings of the pie chart to show the total sales and the list of products underneath the pie chart. I could not get the figures to display the percentage on the chart so i had to modify it by changing the theme. 





Below is the final view of how my pie chart looks after the changes. 



Comments

  1. Carrie MansfieldNovember 9, 2021 at 1:53 AM

    More information is needed here about how you have used excel and also more detail on the database itself like product number, and profit, etc. We looked at this in the tutorial, but if you need further help we can look at examples.

    ReplyDelete

Post a Comment

Popular posts from this blog

Definition of E-Commerce

  Here is my homework on E-Commerce: E-commerce, is known as electronic or internet commerce, which refers to the buying and selling of goods or services using the internet. E-commerce is used to sale physical goods online, but it can also be used for commercial transactions which is facilitated through the internet. There are four main types of e-commerce models that can describe the transactions that takes place between consumers and businesses. 1. Business to Consumer (B2C): When a business sells a good or service to an individual consumer. 2. Business to Business (B2B): When a business sells a good or service to another business. 3. Consumer to Consumer (C2C): When a consumer sells a good or service to another consumer. 4. Consumer to Business (C2B): When a consumer sells their own products or services to a business. Some examples of E-commerce websites are given below: Apple :  Apple sells electronic products e.g Laptops, Computers, phones etc. B2B and B2C New Look: ...
Read more

Website Terms and Definitions

 Internet website cookies: A cookie is a small amount of data generated by a website and saved by user's web browser. The purpose of cookies is to remember information about the user, similar to a preference file created by a software application..  Some sites save both username and password in a cookie, while others only save username. Whenever a user check a box that says, " Remember me on this computer ," the website will generate a login cookie once you successfully log in and save the information for each time the user visits the website. Cookies are also used to store user preferences for a specific site. For example, a search engine may store search settings in a cookie. Financial websites sometimes use cookies to store recently viewed stock quotes. Browser cookies come in two different types: "session" and "persistent." Session cookies are temporary and are deleted when the browser is closed. These types of cookies are ...
Read more

Research on the inventors of the WWW and E commerce

Image
WWW (WORLD WIDE WEB) World Wide Web (WWW) was invented in 1989 by Tim Berners-Lee, a British scientist while he was working at CERN. The original aim of the web was to meet the demand for automated information-sharing between scientists in universities and institutes around the world. Tim Berners-Lee wrote the first proposal for the World Wide Web in March 1989 and his second proposal in May 1990. Together with Belgian systems engineer Robert Cailliau, this was formalised as a management proposal in November 1990 which went live for the first time in December 1990. This outlined the principal concepts and it defined important terms behind the Web. The document described a "hypertext project" called "World Wide Web" in which a "web" of "hypertext documents" could be viewed by "browsers".  In August 1991 Tim Berners-Lee announced the WWW software on the internet and by the end of December 1994, more than 10,000 web servers were online aro...
Read more