APPLICATION 001.pdf

MODULE 1 Information and Communications Technology (ICT)- is a variety of technologies that facilitate communications. The Function of ICT- there is a growing demand for educational institutions to use ICT to teach the skills and knowledge students need for the 21st century. COMPONENTS OF ICT ▪...

MODULE 1 Information and Communications Technology (ICT)- is a variety of technologies that facilitate communications. The Function of ICT- there is a growing demand for educational institutions to use ICT to teach the skills and knowledge students need for the 21st century. COMPONENTS OF ICT ▪ DATA- Is the raw material of any ICT system and this is processed by the system to provide the information ▪ HARDWARE- These are the physical components that make up the ICT system.(tangible components) ▪ SOFTWARE- These are the computer programs which provide step by step information to the hardware. (nontangible components) ▪ INFORMATION- The results from processing data. ▪ PROCEDURES- These are series of actions conducted in a specific order to make sure that the system runs smoothly. ▪ PEOPLE- Are needed to supply data to the ICT system and to make judgements and decisions from the output supplied from the system Business and organizations use ICT to: 1. Improve communication with suppliers and customers, 2. Improve organization’s responsiveness to new developments, 3. To keep up with competition, 4. Improve Organization’s overall performance. ICT FOR EDUCATION- It is the use of technology as a mental instrument by the students, that supports their learning and promotes the achievement of their learning goals. ICT FOR INDIVIDUAL- People use technology to gratify their information needs. Also, Individuals use ICT to increase their social network and connections. MODULE 2 Exploring Information Communication Technology TOP 10 TECHNOLOGY TRENDS IN 2022 AND BEYOND: 1. Locationless Organizations 2. Distributed Cloud 3. Internet of behaviors 4. Cybersecurity 5. Increase in Demand for Certifications 6. No Code / Low Code – Low code 7. Artificial Intelligence 8. AR / VR – Augmented Reality (AR) 9. Blockchain 10. Hyper-automation Archipelagic country- improves connectivity: there was the ultimate belief that ICT usage will make each country to become part of the global trend, Web 3.0. Online System Functions Social networking websites are online platforms that allow people to create profiles, connect with others, share content, and interact in various ways. Search engine websites are online tools that help users find information on the internet by indexing and retrieving web pages based on search queries. Online storage, also known as cloud storage, refers to the practice of saving digital data on remote servers that are accessible via the internet. Instead of storing files on a local device. Collaborative tools and web applications are designed to enhance teamwork, communication, and productivity among individuals or teams working together on projects. MODULE 3 Knowing the different principles and theoretical concepts of online safety and information security (Spam Messages, antivirus) when using ICT. Ethics are a system of moral principles or rules that say what is and is not acceptable. It came from the Greek word ‘ethos’, which means “custom”, “habit”, and “way of living”. Computer ethics it is a set of moral principles that regulate the use of computers. ETHICAL PROBLEMS RELATED TO THE USE OF COMPUTERS: 1. Privacy 2. Property 3. Access 4. Accuracy 5. Hacking, cracking and virus creation 6. Software piracy Computer viruses is a kind of malicious computer program, which when executed, replicates itself and inserts its own code. When the replication is done, this code infects the other files and program present on your system. Spreading of Virus ▪ Through E-mail Attachments, Instant Messaging messages, Funny Images, Audio and Video files ▪ Downloading files from Internet, Greeting cards, and many more. HACKER - Is a person who breaks into a computer system. The reasons for hacking can be many: installing malware, stealing or destroying data, disrupting service, and more. MODULE 4 Distinguishing Software and Getting Started with Word Processing Software and Understanding and exploring its working environment SYSTEM SOFTWARE- It refers to the low-level software that manages and controls a computer’s hardware and provides basic services to higher-level software. Examples are Operating systems and Device drivers APPLICATION SOFTWARE- is a type of computer program that performs specific functions. These functions, performed by application software, can be personal, business as well as educational. Thus, application APPLICATION SOFTWARE (PRODUCTIVITY TOOLS): Word Processor - is a software application capable of creating, storing, editing, and printing documents. Spreadsheet - is an interactive computer application program for organization, computation, analysis, and storage of data in tabular form. Presentation - is a software package used to display information in the form of a slide show. It has three primary functions: an editor that allows text to be inserted and formatted, a method for inserting and manipulating graphic images, and a slide-show system to display the content. PART OF THE LIBREOFFICE WRITER Title bar is located at the top of the Writer window, and shows the file name of the current document. Menu bar is located just below the Title bar. When you select one of the menus, a submenu drops down to show further options. Toolbars have sections which you can tear-off. Docked toolbars can be moved to different locations or made to float, and floating toolbars can be docked. You can use vertical and horizontal rulers at the left and upper edges of the LibreOffice Impress workspace to assist you in creating your slide. Your working place for writing text and inserting any objects or images. Status bar is at the bottom of the window. Use the Document View options at the bottom right to change the view of the document to a single page, multipage or book view. Scroll bar is a vertical or horizontal bar commonly located on the far right or bottom of a window that allows you to move the window viewing area up, down, left, or right. MODULE 5 Creating, Encoding, Editing, and Saving Copying/Copy (Ctrl + C) - it copies the text or image you have selected and stores is on your virtual clipboard. Cutting/ Cut (Ctrl +X) - it is used to remove text or images from the screen you are currently working on. "CUT" moves the information to your virtual clipboard. Paste (Ctrl +V) - it is used to place the information that you have stored on your virtual clipboard in the location that you have placed your mouse cursor your First Document using LibreOffice Writer Undo (Ctrl + Z) and Redo (Ctrl +Y) is also used to move back and forth to the latest revisions on your document. (SHORTCUT KEY FROM A-Z) MODULE 6 Integrating Images and External Materials FILE EXTENSION - is a suffix added to the name of a file to indicate the file's layout, in terms of how the data within the file is organized ▪ LibreOffice Writer=.odt ▪ LibreOffice Impress=.odp ▪ LibreOffice Calc=.ods Kinds of Materials 1. PICTURES ▪ JPEG- Joint Photographic Experts Group. ▪ PNG- Graphics Interchange Format ▪ GIF- Portable Network Graphics 2. CLIPART- vector images which are pre-made to illustrate any subject or situation. 3. SHAPES- printable objects or materials that can be integrated in your document to enhance its appearance or tools for representing ideas or messages. Insert Menu > Shapes 4. CHARTS- Represent data characteristics and trends. Used to illustrate and compare data. Insert Menu > Chart Image Placement: Image Wrapping Wrap off- With this option the text is placed above and below the image but not to either side of it Page Wrap- option if you want your image to be surrounded by the text based on your image size Optimal Page Wrap- prevents text from being placed to the side of the image if the spacing between the image and the margin is less than 2 cm Wrap Left- option if you want your image to be on the right side and texts on the left side. Wrap Right- if you want your image to be on the left side and texts on the right side. Wrap Through- your image on top of your text and the text remains in the back side of the image. In background- option to send the image back side of your text and all texts are passing in front of the image. Edit Contour- This customized wrap option gives you the ability to reshape your image to any shape so that the texts can wrap around it. Module 8 Header - section of information that appears at the top margin of each page document. (Inserting) - Insert menu > header and footer > header > Default style Footer - section of information that appears at the bottom margin of each page document. (Inserting) - Insert menu > header and footer > footer > Default style Watermark - image or text behind the main text of a document. Usually a lighter shade than the text, so you can read it easily. (Inserting) - Format Menu > Watermark Page number - numerals printed on each page to show the order of progression through a document and to facilitate a particular chapter, paragraph or other section. (Inserting) - Go to Insert Menu > select Page number - Go to Insert Menu > select Field > select Page Number Hyperlink - navigate around a website, and hyperlinks are used within a document to make navigating around the document easier. (Inserting) - Click your image or object then use the shortcut key Ctrl + K - Click your image or object > go to Insert Menu > then select Hyperlink Module 9 (Mas advance dito sa pic sa baba eh) Column - vertical alignment of cells. Each column has its unique address, which is labeled as an alphabet (A to XFD). More than one million cells in a single column total of 16384 columns in a single worksheet. Rows - horizontal alignment of cells and it runs from left to right across the worksheet. Total of 1, 048, 576 rows in a single worksheet. Active cells - simply a rectangular box that highlights a cell in a spreadsheet. Help identify a cell that we are currently working on. Also referred as cell pointer. Merging - taking two or more groups of data and combining them into a single unified set. Merging cells - a cell with one more cell combined into one cell. Text orientation - allows text to be oriented 90 degrees in either direction up or down. Worksheet - name given to Excel file and contains one or more worksheets. Formula Bar - toolbar at the top of the spreadsheet that lets you enter or view information in a cell. Sheet Tabs - to display the worksheet that a user is currently editing. Cell - holds individual elements such as text, numbers and formulas. Format toolbar of LibreOffice Calc - Includes the direct access of inserting border, style and color of your cell. To access - Click on cells you want to insert and use shortcut key CTRL + 1 To open Format cells - Ctrl + 1 or Right click on cell/s > Select Format cells Creating border on cell - Right click on active cell the select Format Cells > go to tab borders > select sides of borders > select type and/or color > click OK (OR) - Click on cell > Ctrl + 1 > go to borders > select sides of borders> select style and/or color > click OK Adding background color - Select the cell> right click > select Format cells > On Format Cells dialog box, select tab background > Then select “color” button > choose desired color> click OK Adjustment on cell - Put your mouse cursor between two columns then click and drag to adjust its column width Text Orientation - Enter degree value for its adjustment then click OK Merging cells - Highlight cells > right click the highlighted cell > select Merge cells - Notice that merged cell will change and will consider as first cell Module 10 Calc - LibreOffice spreadsheet module. Spreadsheets - consists of several sheets, cels, rows and columns. Cells - hold the individual elements-text, numbers, formulas and so on that make up the data to display and manipulate. Equal signs (=) - it is a symbol used to initiate a formula Mathematical Operators Basic Functions + Addition Sum () - Subtraction Average () * Multiplication Product () / Division Quotient () Data for computation: QTY - number of purchased items Purchase Price - cost of item from supplier Retail Price - selling price in the market Price - sub-total per item. Compute for product of QTY and Retail Price (QTY*Retail Price) Profit - difference between Retail Price and Purchase Price Always write with equal “=” sign in writing formula 1. First calculate price - product QTY and RETAIL PRICE (QTY*RETAIL PRICE) - for calculating the rest hold your mouse cursor to top and drag then enter 2. Second calculate profit - difference of RETAIL PRICE AND PURCHASE PRICE (RETAIL PRICE - PURCHASE PRICE) - for calculating the rest hold your mouse cursor to top and drag then enter 3. To get the total items - C2+C3+C4+C5+C6 Sum () - function that is used to get the total/sum of range of cells. 4. To get the total price - find the product 0.12 (12%) and sum of price [sum(PRICES)*0.12] 5. To get the differences of Total price and 12% VAT - sum (Prices)-12% VAT 6. Amount due - sum(subtotal and 12% VAT) 7. Total Profit - sum (all in column profit) Module 11 Impress - it is the presentation (slideshow) program included in LibreOffice. Create slides contain many different elements, text, bulleted and numbered lists, tables, charts and a graphic objects For first time: 1. Empty presentation, which gives you a blank document 2. From template, presentation designed with a template of your choice 3. Open existing presentation 4. Create to open the main Impress window Slides - are single pages of presentation where all objectives and information are displayed. Slideshow - series of still images on a projection screen or electronic display device typically in prearranged sequence. Custom Animation - animation effect used to animate pictures, graphics and charts Slide Transition - motion effects that occur in slideshow view when you move SHORTCUT KEYS in Module 11 Properties - change font color, highlight first text To insert another slide - go to Slide plain > select New Slide - CTRL + M To change background color - click Slide > select Properties > a dialog box will appear, select Color, then a palette will appear, choose color > then OK Insert date - go to Insert Menu > select Field > choose Date (Fixed) To insert image - go to Insert Menu > select Image > the browse an available image you want To animate a slide - go to Task Pane > select icon for Slide Transition > then choose animation To add animation on text - highlight first your text > click animation icon at task pane > select kind of animation under “effect” > select see it preview Module 12 To select a template - go to Master Slides > scroll and find available use > select a variety of design template To insert/change layout - select Slide > properties > find layouts > select 1. New slide - allows you to add another empty slide 2. Duplicate slide - allows you to add a another slide, same as what you have selected 3. Rename slide - it is used to visually present editing but hidden during slideshow 4. Hide slide - use to visually present for editing but hidden during slideshow 5. Delete slide - use to remote slide To insert audio - select Insert Menu > select Insert audio or video > a dialog box will pop up > Select file > select Open To create hyperlink - drag some objects present in your gallery then make connection on other slide. Module 15 Image manipulation - process of altering a digital image. Cropping - simple and most effective photo manipulation process to fix poorly composed images, tonal balance, color correction and sharpening. Color Balance - process making sure that the colors in an image are accurate and true to life. Brightness and Contrast - Images that look gray, flat and dull can often be brought to life by tweaking the contrast levels. Resizing - allows you to make your image smaller or larger without cutting anything out. Compression - process of encoding or converting an image file in such way that it consumes less spaces than the original file. LOGOS