1MICROSOFT EXCEL:
- it provides an automated way of displaying any statistical data.
2MICROSOFT EXCEL:
It can be used to automatically compute for several factors that are not easy to notice especially
31. QUICK ACCESS TOOLBAR
- Is in the top left corner of the screen.
- This toolbar allows you to add frequently used commands.
4RIBBON
- Is the strip of buttons and icons located below the quick access toolbar.
5RIBBON
- The tabs are part of the horizontal ribbon menu that contains links to various features of the program.
6RIBBON TAB
- The tabs are part of the horizontal ribbon menu that contains links to various features of the program.
7FORMULA BAR
- It is located below the ribbon
- This area displays the contents of the active cell.
- It can also be used for entering or editing data and formulas.
8Active cell.
- Recognized by its green outline.
- Data is always entered in the _
9 ‘’=’’
Always type_ before the formula
10AVERAGE
- It is the arithmetic mean and is calculated by adding a group of numbers and then dividing by the count of those numbers.
11COUNT
- It gets the number of entries in a number field that is in a range or array of numbers.
12MIN
- It returns the smallest value from the numbers provided.
13MAX
- It returns the largest value from a supplied set of numeric values.
14COUNTIF
- A function used to count the cells with a specified content within a range.
15- Formula: COUNTIF(range,criteria)
FORMULA OF COUNTIF
16RANGE
the cells where the counting will take place
17CRITERIA
the label or value that determines if it is to be counted.
18 good website
• a___must know its target audience, determine its needs, and communicate effectively using the basic principles of graphics and layout.
19web design
• __ matters to every user, whether they can decide to stay or just leave.
20USABILITY
is important for the users as it satisfies their experience on the website.
21MICROSOFT EXCEL:
- it provides an automated way of displaying any statistical data.
22MICROSOFT EXCEL:
- it provides an automated way of displaying any statistical data.
23MICROSOFT EXCEL:
- it provides an automated way of displaying any statistical data.
24MICROSOFT EXCEL:
- it provides an automated way of displaying any statistical data.
25MICROSOFT EXCEL:
- it provides an automated way of displaying any statistical data.
26MICROSOFT EXCEL:
- it provides an automated way of displaying any statistical data.
27MICROSOFT EXCEL:
- it provides an automated way of displaying any statistical data.
28SYMMETRICAL BALANCE
o where the elements are equally distributed on both sides of your design
o technically a mirror-based design
29ASYMMETRICAL BALANCE
o a free layout where the elements can be places in any order.
o opposite of symmetrical
30EMPHASIS
• refers to something that need to stand out or emphasize.
•
31emphasis
when working on __, you can change the color, size, or even the element itself to lead the eye to the focal interest.
323. PATTERN, REPETITION, AND RHYTHM
• the use of repetitive elements such as lines, shapes, forms, textures, space, colors, font style, and the like to create texture, movement continuity, and consistency in the design.
333. PATTERN, REPETITION, AND RHYTHM
• it also makes the design formal and more comfortable to read because of its uniformity.
• consistency
34ALIGNMENT
• refers to the proper placement of an element in your design
35center, right, left, and justified
• the standard texts or paragraph alignment we apply are __
365. HIERARCHY
• refers to the proper arrangement of the details such as text, characters, numbers, and symbols.
•
375. HIERARCHY
changing its character size, thickness. spaces, or even font type to stand out is its most critical feature.
•
385. HIERARCHY
by applying this principle, it can help the viewer to recognize and navigate the highlight of the event smoothly.
39CONTRAST
• refers to the use of different or opposite elements such as:
• gives visual weight to an object or design.
41FUNNEL CHART
Use this chart type to show progressively smaller stages in a process
42o spaces
- negative or positive
43 form
o - real or abstract
o
44o values
- light or dark
45CONTRAST
You must consider and limit the use of different elements, colors, styles, and typography to avoid cluttered design.
46• Infographics
• is the combination of the words ‘information’ and ‘Graphics’, meaning, information from graphics.
47Graphics, pictures, and images
• can convey a lot of information especially when it has context.
48• Infographics
• __ can greatly enhance the way you present your information.
49BAR CHART
These are primarily used in comparing sets of data.
50BAR CHART
They visualize the difference between values in a table and show the rate of change over time.
51LINE OR AREA CHART
These are similar to bar graphs in terms of use, with the difference that this graph are more suitable for showing trends.
52PIE OR DOUGHNUT CHART
Use this chart to show the proportions of a whole.
53PIE OR DOUGHNUT CHART
Use it when the total of your number is 100%
54STATISTIC CHART
Use this chart type to show statistical analysis of your data.
55HISTOGRAM
A chart that shows frequencies for intervals of values of a metric variable
56FUNNEL CHART
Use this chart type to show progressively smaller stages in a process