Сообщения

Сообщения за апрель, 2022

Exercise #13

Изображение
  Go to "wix.com" Select "Create New Slide" Search for your website type Start creating your magic website    

Exercise #28

Изображение
  How do I do an order form in Excel:  Create Product Drop Downs On the Order Form worksheet, select cells B10:B14. On the Excel Ribbon's Data tab, click Data Validation. From the Allow dropdown, choose List. In the Source box, type: =ProductList. Click the OK button. What are orders in Excel: Excel employs a common arithmetic process called "order of operations" when assessing a calculation. Excel's sequence of operations is based on the acronym PEMDAS (Parentheses, Exponents, Multiplication, Division, Addition, Subtraction), but with some tweaks to deal with the formula syntax in a spreadsheet. What is an Excel form: A form is a collection of controls, like boxes and dropdown lists, that make it easy for others to input or change data in your worksheet. See Excel templates for additional information on templates you may download.

Exercise #27

Изображение
  Where is data analysis on Excel: Q.   Where is the data analysis button in Excel? Click the File tab, click Options, and then click the Add-Ins category. In the Manage box, select Excel Add-ins and then click Go. In the Add-Ins available box, select the Analysis ToolPak check box, and then click OK. How do you do data analysis on Excel: To access the Add-Ins category, navigate to the File tab, Options, and Add-Ins. Select Excel Add-ins from the Manage drop-down menu and click Go. Check the Analysis ToolPak check box in the Add-Ins box before clicking OK. Is Excel enough for Data Analysis: For data analysis, Excel is insufficient. If you simply need to conduct simple activities like percentages and distributions, Excel spreadsheets may be sufficient. If you want to go beyond the fundamentals, though, Excel will not suffice. Excel may be a bit dangerous to rely for sophisticated analyses.

Homework #6

Изображение
  What is DBMS easy definition: A database management system, sometimes known as a DBMS, is essentially a computerised data-keeping system. Users of the system are given the ability to execute a variety of actions on it, such as manipulating the data in the database or managing the database structure itself.  What is DBMS with example: The database management system (DBMS) organises and maintains incoming data, as well as allowing users and other applications to modify or extract it. MySQL, PostgreSQL, Microsoft Access, SQL Server, FileMaker, Oracle, RDBMS, dBASE, Clipper, and FoxPro are some examples of database management systems.  What is a DBMS and what are its functions: Summary of the lesson. A database management system (DBMS) is a piece of software that allows you to arrange data in a database. The abbreviation DBMS is commonly used to refer to it. Concurrency, security, backup and recovery, integrity, and data descriptions are all features of a database managemen...

Exercise #25

Изображение
  What are database products examples: MySQL, Microsoft Access, Microsoft SQL Server, FileMaker Pro, Oracle Database, and dBASE are examples of prominent database management systems (DBMSs).  What are 3 examples of a database: Examples: Microsoft SQL Server, Oracle Database, MySQL, PostgreSQL and IBM Db2. Examples: Apache Cassandra, MongoDB, CouchDB, and CouchBase. Examples: Microsoft Azure SQL Database, Amazon Relational Database Service, Oracle Autonomous Database.  What is a database product: A product database may be readily defined as an organised collection of product-related data that is kept and maintained electronically. These data are referred to as product specifications.

Exercise #24

Изображение
  What is customer database: A customer database is a collection of data that comprises contact information for leads such as first and last names, phone numbers, and email addresses, among other things. It can also contain the following information: Age, gender, marital status, and family composition are all demographic factors. What are customer databases called: Customer relationship management systems (CRM) are a type of database that stores customer information (CRM).

Exercise #23

Изображение
What is entity relationship diagram design:   An entity relationship diagram (ERD), often called an entity relationship model, is a graphical depiction of relationships between people, things, locations, concepts, and events in an information technology (IT) system. What is entity relationship diagram with example: An entity is a type of data item or component. In an ER diagram, an entity is represented by a rectangle. Consider the following scenario: We have two entities in the following ER diagram: Student and College, and these two entities have a many to one connection since many students attend a single college.

Exercise #22

Изображение
  What is meant by entity relationship diagram: An Entity Relationship (ER) Diagram is a form of flowchart that shows how "entities" within a system, such as people, things, or concepts, interact with one another. What is ER model explain with example: Real-world things are represented using an ER model. An entity is a creature or object in the real world that can be distinguished from its surroundings. Each employee in a company, for example, is a separate entity.

Exercise #21

Изображение
 What is database and example: A database is a collection of data that has been organised in a systematic manner. They allow for electronic data storage and manipulation. Data handling is simplified thanks to databases. Let's look at an example of a database: An online telephone directory keeps track of persons, phone numbers, and other contact information in a database. Purpose of database: Any collection of data or information that is specially arranged for rapid search and retrieval by a computer is referred to as a database, often known as an electronic database. Databases are designed to make data storage, retrieval, modification, and deletion as well as other data-processing tasks easier. Where is database used: Databases are utilized in a variety of applications, including banks, retail, websites, and warehouses. Databases are used by banks to track customer accounts, balances, and deposits. Databases can be used to maintain prices, customer information, sales information, a...

Exercise #20

Exercise #19

Exercise #18

Изображение
  What are the 4Ps of marketing? A product is a good or service that a business provides to its clients. A product should, in theory, satisfy an existing consumer demand. Alternatively, a product may be so attractive that buyers believe they need it, resulting in a new demand. The four Ps are meant to help marketers consider everything about a product or service when they're deciding how to market it for their business. Framing your marketing around the four Ps will help you learn what the competition is doing and what customers want from you. You can use the four Ps to answer questions about the product, price, place, and promotion of your product or service. For example, you can ask yourself: Product : How does your product meet your customer's needs? Price : What is the value of your product? Place : Where are customers looking for your product? Promotion : How can you differentiate your product from competitors? Thinking about your marketing in terms of the four Ps will hel...

Exercise #9

Homework #2

Exercise #12

Изображение
  What is wireframe sketching? Wireframes visualize a user path or flow, as well as page layouts, information hierarchy, and even interactions. Depending on their purpose, they can vary in fidelity — from quick sketches to detailed representations of the final design. For people with limited or no drawing abilities, wireframing can be daunting. Digital wireframe: A wireframe is  a two-dimensional illustration of a page's interface that specifically focuses on space allocation and prioritization of content, functionalities available, and intended behaviors . For these reasons, wireframes typically do not include any styling, color, or graphics. Hand sketch wireframe: Essentially — wireframes are basic design layouts of your product. Wireframes present the key information that you want to display on the page. They also give a clear sign of what your app or website page structure is going to look like. And finally, wireframes give basic information about specific elements in...

Exercise #10

Изображение
  The structural projection of an informational space that offers intuitive content access can be defined as the structure of a website. When creating a systematic approach to the process of generating effective navigation, the structure of a website is especially crucial. What is a website structure, and why is it needed? A website’s structure helps to form understandable, discoverable, and predictable patterns. A proper website structure helps the site’s visitors find information easily though consistency. Users feel satisfied when they find information quickly, and a solid and relatable structure is essential to the usability of the website. In fact, UX designers can solve broader issues in  UI design  and usability through good website structuring. Good website structure is necessary for grouping and cataloging content. When considering potential architectures, designers can typically choose from either a top-down or bottom-up approach based on their users’ needs and ...

Exercise #7

 Advantages of meta tags: Meta tags are crucial because they influence how your site shows in search engine results pages (SERPs) and how many people will click through to your site. As a result, they will have an impact on your traffic and engagement rates, which in turn will have an impact on your SEO and rankings. Meta tags are an essential component of any SEO strategy. Although some tags may not directly affect rankings, they do have an impact on how your site appears in the digital environment. They could also play a role in non-traditional search results such as Knowledge Graph, Google picture search, voice, and others. When creating content, no brand should overlook them. Some low search engines are thought to still use it. Including a meta description element on each page may provide those pages a search engine optimization boost. Some search engines include it in their results, especially if it contains the term sought for. (Depending on the search engine and what is...

Exercise #4

Terms:        A website is a collection of interconnected, publicly accessible Web pages with a single domain name. Individuals, groups, businesses, and organizations can construct and maintain websites for a variety of objectives. The World Wide Web is made up of all publicly accessible websites.   The header on the website:    The first thing visitors see when they visit a website is the header, which appears on every page of the site. An excellent website header strikes a mix between clean design and crystal-clear navigation to the site's inner pages.

Homework #1

Изображение
W ho invented e-commerce:  Michael Aldrich (22 August 1941 – 19 May 2014) was an English inventor, innovator, and entrepreneur. In 1979 he invented online shopping to enable online transaction processing between consumers and businesses, or between one business and another, a technique known later as e-commerce. Who invented www: Tim Berners-Lee , a British scientist, invented the World Wide Web (WWW) in 1989 while working at CERN. The web was originally conceived and developed to meet the demand for automated information-sharing between scientists in universities and institutes around the world.

Exercise #3

Изображение
  A programming language is a man-made language that may be used to control the behavior of a machine, most notably a computer. The structure and meaning of programming languages, like human languages, are determined by syntactic and semantic rules. Programming languages are used to communicate the work of organizing and manipulating data, as well as to precisely define algorithms. Some authors confine the word "programming language" to languages that can express all possible algorithms; the term "computer language" is sometimes used for artificial languages with fewer capabilities.

Exercise #2

Изображение
 Advantages: #1: Low Financial Cost One of the e-commerce benefits is that it has a lower startup cost. Physical retail stores have to pay up to thousands of dollars to rent one of their store locations. They also have several upfront costs such as store signs ,  store design , buying inventory, sales equipment, and more. And let’s not forget, the store owner also has to hire staff to work and run each location. They may also need to hire security staff depending on the product value in the store. However, for an  e-commerce dropshipping store , startup costs are estimated at $418and e-commerce stores only pay $3192 a year on Shopify at most for virtual ‘rent’. Shopify also includes an easy-to-use platform, hosting, free  Shopify themes , great apps, and lots of other great perks.  Depending on what type of e-commerce business you run, you may only need to hire employees when you grow to a certain level. As your online store is online, these employees can...