Posts

EXERCISE 11: HYPERLINKS AND ACTION BUTTONS

Image
 EXERCISE 11: HYPERLINKS AND ACTION BUTTONS       For the Final Exercise in this Fisrt Semester, I want to apply my ample learnings from the prelim, midterm, and the final term. With my running theme being this retro and vintage appearance, it was really fun to play around the elements such as cutouts and textured shapes that would just simply go well with each other. For some parts of the slides, I used glitch or static moving backgrounds to add more depth to the appearance of the presentation. As per the fonts that I used, I have discovered this futuristic set of font family that would go well when organized and used in the right way.      From the previous lessons, I learned about various transition and effects to improve the interactiveness of the presentation. But I carefully used each animations to not make it too exhausting and messy to the viewers.      For the Hyperlinks and Action Buttons, I used a button that looks like o...

EXERCISE 10: ANIMATED AND AUTOMATIC POWERPOINT INSPIRATIONAL PRESENTATION

Image
 EXERCISE 09: ANIMATED AND AUTOMATIC POWERPOINT INSPIRATIONAL PRESENTATION      For this activity combined with the application of the principles of design, I have managed to create this presentation that centers on the topic of how relevant Multimedia Arts is in the modern world that we are currently in. As time progress in the development of our country and the world, Multimedia Arts holds the capacity to elevate and become sophisticated through adaptation in this modernity.      These are a couple of word edits and a little minimalistic art piece that I have created and used for the presentation. With the use of textures and the lines used for the buildings adds a subtle relaxing city view and as if the whole piece is in motion. Upon adding textured background, it sets the line art apart from the whole horizon of the clear sky. With the word art, it came along with the same princple of making it appear in motion. The word is repeated in a way that i...

EXERCISE 09: PIVOT TABLE & PIVOT CHART

Image
EXERCISE 09: PIVOT TABLE & PIVOT CHART      For this Exercie 09, we will be exploring the functionality of the Pivot Charts in Microsoft Excel. I personaly do not have that much idea and clue on how to use pivots charts from my previous years and I am lucky to have discovered it as it really is an efficient way to get specific data from a general table.      Upon commanding the Pivot Chart, there are four categories/areas to create certain table and filter out graph results. For instance, the Columns basically imply the portions of data that will be distrubuted in columns. As for the Rows, the information will be basically used and distributed by rows. For the Values, this will be numerical datas or will convert informations to numerical datas by the use of counts. When it comes to the Filter, it will be a setup for the whole table wherein the data placed in this area will be the main focus of the Pivot table. MAIN DATA TABLE WHAT IS THE TOTAL AMOUNT SO...

EXERCISE 08: PAYROLL

Image
 EXERCISE 08: PAYROLL      For this exercise, the main task is to use various formulas such as: VLOOKUP, IF Conditions, AVERAGE, MAXIMUM, and MINIMUM. Way back when I was on Grade-11, I was introduced to this formulas on Google Sheets and understood the elements needed to avoid errors on the formula. As of today, I recall some few formulas, but it was a relief to actually have my old files to use as reference. I have used the same business set-up with the previous exercise which is the "Haus of Cookies" with a total of 6 employees to run the small business. PAYROLL PAYROLL FORMULAS

EXERCISE 07: CHART, SORTING FILTER, SUBTOTAL

Image
 EXERCISE 07 CHART, SORTING FILTER, SUBTOTAL     For this Exercise, we are tasked to apply column formats that would allow to sort each data in a specific order using the drop down menu. I created this Food Service Restaurant type of business to be the base for the data and information that I will be using. These commands are really helpful in easily identifying a certain information  as the filters provide direct results. In creating the graph, I used the idea of Movie Genres as a basis for the data needed in order to complete the graph.  SORTED DATA OF ID TYPE LOWEST TO HIGHEST SORTED DATA OF NAME A TO Z SORTED DATA OF LOAN AMOUNT HIGHEST TO LOWEST FILTERED DATA OF ITEM DESCRIPTION  A TO Z FILTERED DATA OF ITEM TYPE  A TO Z SORTED DATA OF DEADLINE TYPE NEWEST TO OLDEST SUBTOTAL DATA OF LOAN AMOUNTS CUSTOM GRAPH BASED ON MOVIE GENRE

EXERCISE 06: BUDGET AND SUPPLIES & CUSTOMER INVOICE

Image
EXERCISE 06: BUDGET AND SUPPLY  & CUSTOMER INVOICE      In this activity, we are tasked to use the full potential of Microsoft Excel by using commands and various formulas that would be really useful and efficient for common job taskings. I have decided to have this Cookie Business as a basis for the computations and data for the formulas to function.  BUDGET AND SUPPLY      For the Budget and Supply, I researched on the main ingredients and packaging tools used to run a Cookie Business. I included specified measurements to be more accurate. The photo below displays the formulas that I have used. It can be seen that I used a conditional formatting for the Peso Sign in order to not encode manually. CUSTOMER INVOICE      When it comes to the Customer Invoice, it is actually just the similar process. I made  sure that I encoded the right cell numbers for the formula to avoid confusing and misleading results. With the whole tab...

EXERCISE 04: MICROSOFT WORD MANUAL

Image
  MICROSOFT WORD MANUAL SAVING & SHARING A DOCUMENT I have chosen the topic about how to Save and Share Microsoft Word Dosuments as I do believe that it is the most constant and important process to ensure that the progress is saved and on how sharing documents can be really efficient for school works.  _______________________________________________________________________________ 01   INSERT COVER PAGE      For the Document Cover Page, I have chosen the template design called "Insight 1", which can be found by clicking on the Insert > Cover Page > More Cover Pages from Office.com. By altering the Colors together with the text Font Style and Font Size, the cover page stays coordinated with the general design. _______________________________________________________________________________ 02   INSERT HEADER AND FOOTER      The Header has a Color Palette that stays in the spectrum of royal blue as a representation of the Microso...