Empowerment Technology Q1 Exam 2024 - CCSHS - FERMAT

EMPOWERMENT TECHNOLOGY 1st Quarter Exams Grade 11 | CCSHS | FERMAT ‘24 INTRODUCTION TO ICT FEATURES OF WEB 3.0 Information and Communication 1. Software as a service Technology - Al...

EMPOWERMENT TECHNOLOGY 1st Quarter Exams Grade 11 | CCSHS | FERMAT ‘24 INTRODUCTION TO ICT FEATURES OF WEB 3.0 Information and Communication 1. Software as a service Technology - Allows you to “rent” a software for a minimal - Provides access to information through fee telecommunication that deals with the use of different communication technologies to 2. Mass Participation locate, save, and edit information. - Universal web access diverse information through web sharing Information - Knowledge obtained from investigation, study, or 3. User Participation instruction. - Users can add their own content to the website and is not limited to only the owner. Communication - Imparting or exchanging information or news. 4. Rich User Experience - Signing Up/Using Cookies - Content is responsive to the user’s input Technology - Machinery or equipment developed from the application of 5. Folksonomy scientific knowledge. - Using Hashtags - Allows users to classify information using Philippines freely chosen keywords - “ICT Hub of Asia” - TIME Magazine’s “The Selfiest Cities around 6. Long Tail the world.” - Services that are offered on demand rather than on a one-time purchase CURRENT STATE OF ICT TECHNOLOGIES PROBLEMS OF WEB 3.0 1. Microsoft Word - data processing 2. Microsoft Excel - spreadsheets 1. Compatibility 3. MS Powerpoint - presentations 2. Security 4. MS Outlook - emails 3. Vastness 5. Adobe Photoshop - photo editing 4. Vagueness 5. Logic WORLD WIDE WEB TECHNOLOGY TOOLS World Wide Web - System that enables you to access hypertext 1. Google Glass documents and other files over the internet. 2. Apple Watch - Proposed by Tim Berners Lee (1989) 3. Fitbit Charge 2 4. VR Headset 5. Microsoft Hololens EVOLUTION OF WEB 6. 3D Printer Web 1.0 (STATIC) - Pages are “as is” TRENDS IN ICT - Cannot be manipulated by the user 1. Convergence Web 2.0 (DYNAMIC) - Synergy of technological advancements to - Users can see the websites differently from work on a similar goal or task others; Interactive 2. Social Media Web 3.0 (SEMANTIC) - Computer-mediated tools/website that enables - W3C: World Wide Web Consortium web users to create, discuss, modify, and - The stage where the internet services for exchange information. websites and applications that will focus on using a machine-based understanding of data. 1  TYPES OF SOCIAL MEDIA 4. Assistive Media - Designed to help people who have visual and reading impairments Social Networks - Allow you to connect with other people with 5. Cloud Computing the same interests or background - On-demand availability of computer system - Facebook, Google resources services especially data storage. Bookmarking Sites - Cloud storage - Store or manage links to various websites and resources - Pinterest ONLINE SAFETY AND NETIQUETTE Social News Internet Safety - Allow users to post their own news items or - Online safety of people and their information links to other news sources when using the internet - Reddit, Digg, Quora - Act of maximizing user’s awareness of personal safety Media Sharing - Allow users to upload and share media Netiquette content like images, music, and video. - Internet Netiquette - Youtube, Instagram - Rules of online courtesy, proper manners, and behavior online Microblogging - Sites that focus on short updates from the ACRONYMS TO REMEMBER user. - X, Tumblr YAHOO - Yet Another Hierarchical Officious Blogs and Forums Oracle - Allows users to post their content. VIRUS - Vital Information Resource Under - Reddit Siege QR Code - Quick Response Code CVC - Card Verification Code REMEMBER! OTP - One Time Password SMS - Short Message Service Mark Zuckerberg - Facebook (2014), Instagram ($1B in 2014), INTERNET THREATS and WhatsApp [Meta platform]\ Jawed Karim 1. Malware - Malicious Software - First YouTuber - “Me at the Zoo” on November 24, 2005 Virus - Local networks or data storage (USB, Flash Jack Dorsey Drives) - Sold Twitter to Elon Musk (44 Billion) in October 2022 Worm - Uses a computer network to spread Weibo - China’s Facebook ILOVEYOU (Love Bug Worm) - Created by Onel de Guzman 3. Mobile Technologies - May 5, 2000 - Consists of portable two-way communication and computing devices like computer Trojan capabilities and the network technology that - Disguised as a useful program but once connects them with the use of mobile phones. downloaded or installed, it leaves your PC unprotected. DIFFERENT MOBILE OPERATING SYSTEMS Spyware - Runs in the background without you knowing it IOS - Apple - Monitor what you are currently doing and Android typing through keylogging Symbian - Nokia Blackberry OS Keylogging WebOS - TVs - Used to record the keystroke done by Windows Mobile the user. 2  Adware PARTS OF A LETTER - Sends ads, mostly pop-ups 1. Letter Heading - Located in the upper left/right corner of the 2. Spam page - unwanted email mostly from bots or ads, it can - It introduces the recipient and provides key be used to send malware details [ name, address, phone number, email, date] 3. Phishing - Done by sending an email that will direct the 2. Date user to visit a website and share personal - Indicates the date the letter was written or sent information 3. Inside Address Pharming - Includes the recipient’s information, starting - More complicated way of phishing with their name, job title, and complete where it exploits the DNS (Domain address Name Service) System 4. Salutation 4. Identity Theft - The words used at the beginning of a letter or - Impersonate individuals usually for financial speech [to whom it may concern, dear…] gain. 5. Body 5. Hacking - Content of the letter - Gain access to security password used to see data stored and steal important information 6. Complimentary Close - Concludes the business letter with a 6. Cyberbullying professional closing like "Sincerely," or "Best - Form of bullying that involves behavior or acts regards, by the use of technology LETTER STYLES MAIL MERGE 1. Full Block Style Internet Safety - The standard for official business letters - Allows you to create documents and merge - No paragraph indentions, left-aligned them with another document or data file - Used when sending out advertising materials 2. Block Style to various recipients - Body and addresses are left-aligned and single spaced. Label Generation - Date and closing are on the right - Creates a blank form that stimulates either a blank label or envelope of predefined size 3. Semi-block Style - Uses the data file that you select to print the - Least used style information - Each paragraph is indented by 5 spaces COMPONENTS OF MAIL MERGE INTEGRATING IMAGES & EXTERNAL MATERIAL IN WORD PROCESSORS 1. Form Document - Contains the main body of message Word Processor - The creation, editing, formatting, storage, and Placeholders output of both printed and online or electronic - Data files or merge fields. documents - Marks the position on your formed - Most used business Application document where individual data or information will be inserted.txt - text files.doc /.docx - word files - Marked by double-headed arrows.rtf - rich text files. xml - xml files () on each side.html /.htm - html files 2. List of Data File - Where individual information or data is placed and maintained. 3  KINDS OF MATERIALS USES OF MS EXCEL 1. Pictures Financial Analysis - Electronic or digital pictures, images, Data Management photographs such as logos and scanned Project Management pictures Inventory Management Data Analysis.jpeg Reporting - Joint Photographic Experts Group Personal use - More compatible and portable through the internet PARTS OF MS EXCEL - Supports 16.7 million colors, but does not support transparency 1. Workbook - Entire excel file.png - Portable Network Graphics 2. Worksheet - Faster image transfer on the internet - A single sheet in the workbook - Supports 16 million colors and transparency, but does not support 3. Quick Access Toolbar animations - Add commands that are related to excel to your program.gif - Graphics Interchange Format 4. Title Bar - Displays simple animation - It displays the active document’s name - Better for logos, drawings, small text, B&W images and art decors 5. Toolbar/Ribbon - Contains commands 2. Clip Art - generally in.gif file format 6. Sheet Tabs - Line art drawing of images used as generic - Displays the worksheet that is being edited by representations the user in real time 3. Shapes 7. Menu Bar - Printable objects or materials that you can use - Includes the group of related commands to enhance the appearance of your document - Useful for layouts in graphics or posters 8. Name Box - Gives the name of a table or cell 4. Smart Art - Predefined sets of different shapes grouped 9. Formula Bar together that are organizational or structural in - Where you enter your data/formula nature 10. Navigation Buttons 5. Chart - Helps users to comprehend the layout of - Presents data characteristics and trends workbook easily 6. Screenshot 11. Cells - Snipping tool: WINDOWS+SHIFT+S - Intersection of a row and column where data is - Whole screen: WINDOWS+PRTSC entered and displayed - 1048576 rows and 16384 columns, a total of CREATING ADVANCED AND COMPLEX 17,179,869,184 cells FORMULA IN MS EXCEL 12. Worksheet Window Excel - Includes commands to display, edit, encode, - Spreadsheet software for organizing, and save data analyzing, and visualizing data - Performs calculations using predefined FORMULAS formulas by specific values called “arguments” in a particular order called “syntax” Formulas Founders: Doug Klunder, Charles Simonyi, - Help in operating calculations on values easier Bill Gates, Jabe Blumenthal and quicker First release: 1985 (Mac); 1987 (Windows) 4  Average Syntax: VLOOKUP(lookup_value, - Calculates the sum of all the numbers in a table_array, col_index_num, specified range, and the sum is divided by the [range_lookup]) total count of those numbers - =AVERAGE(number1,number2…) lookup_value: value you want to search for in the first column of the CountIF table - Used to count cells that meet a specific condition table_array: the table or range of cells - =COUNTIF(range,criteria) where you want to perform the lookup. SumIF col_index_num: the column number - Adds up values in a range within certain in the table from which you want to conditions or criteria retrieve the corresponding value - =SUMIF(range,criteria,[sum_range]) [range_lookup]: an optional Addition argument specifying whether you want - =A1 + A2 an exact (0 or FALSE) or approximate match (1 or TRUE) Subtraction - =A2 - A1 MATCH Function - Return the number of the row or column where Multiplication the input information is found. - =A1 * A2 - The MATCH function used within the VLOOKUP formula gives it a name of the Division column to search rather than just a fixed - =A2 / A1 number of the column to search. - Dynamic function Exponent - =A2 ^ A1 (^ - caret) CUSTOM ANIMATION AND TRANSITION Autosum Animation - Helps in adding ranges of cells automatically - Set of effects applied to objects in PowerPoint - =SUM(number1, number2…) so that they will animate in the Slide Show PowerPoint SHORTHAND COMMANDS - Can be added under the custom animation function Ctrl + E - Automatically perceive patterns in adjacent Animation Triggers columns and fill the current column - Allows animators to apply effects that can be triggered when a specific object on Slide Show Ctrl + K is clicked - Displays the insert hyperlink or the edit - Basis for the majority of PowerPoint games hyperlink dialog box Motion Path Ctrl + Q - Lets you animate objects moving along curves - Displays the Quick Analysis options for your and complex shapes. data when you select cells with data - Defined by setting anchor points which are then connected by straight or curved lines VLOOKUP AND OTHER SHORT COMMANDS Hyperlink - Allows users to advance from one slide to VLOOKUP another when they click on a predetermined - Searches for the value in the first column of a word, shape, or image range (table or array) and returns a corresponding value in the same row from a PRINCIPLES OF GRAPHICS AND LAYOUT specified column - The "V" in VLOOKUP stands for "Vertical," Graphics indicating that it searches vertically - Visual images, pictorial representation of data (downward) in a table Layout - Process of planning and arranging graphics 5  ELEMENTS OF GRAPHIC DESIGN COMMON TYPES OF FILE FORMATS 1. Balance Vector Files - Can be symmetrical or asymmetrical 1. Drawing Interchange Format (DXF) - Visual weight of objects, texture, colors, space - Used in computer-aided design software 2. Emphasis 2. Encapsulated Post Script (EPS) - Area in design that may appear different in - Used in desktop publishing software programs size, texture, shape, color that attracts the viewer’s attention 3. Shapefile (SHP) - Uses vector coordinates to store 3. Movement non-topological geometry and attribute - Visual elements that guide the viewer’s eyes information for features around the screen Text Files 4. Consistency 1. Document file (doc/docx) - Pattern: repetition of several elements of a - Easily edited design that work in conjunction with one another 2. Text file (txt) - Repetition: series of similarly curved lines or a - Commonly used by programmers recurring motif - Rhythm: sense of movement in a design 3. Portable Document Format (pdf) 5. Proportion 4. HTML (htm/html) - Refers to relative size and scale of various elements in design UPLOADING, SHARING, AND IMAGE HOSTING 6. Unity Uploading - Distance and closeness between elements - Transmission of a file from the user’s computer that shows connection to another 7. Variety Sharing - Uses several design elements - Allowing data to be accessed by other users INFOGRAPHICS Downloading - From internet source to the user’s computer Information Graphics - graphical representation of information, data, Image Hosting or knowledge intended to present information - Creating albums and slideshows, ability to add notes, edit images Characteristics: Unique, Creative, Informative/Persuasive, Attractive, Simple/Concise Apps for Infographics: Canva, Venngage, Visme, Piktochart When is it used? - Display survey data - Concept - show comparisons Online file formats - Edit Photos: store images as collection of pixels - Create digital paintings (Vector graphics) 6