1st Sem Finals - ICT PDF

Lesson 1: Developing ICT Content INTEGRATING IMAGES - refers to an application program for manipulating text-based documents; for Specific Purposes the electronic equivalent of pape...

Lesson 1: Developing ICT Content INTEGRATING IMAGES - refers to an application program for manipulating text-based documents; for Specific Purposes the electronic equivalent of paper, pen, typewriter, PRODUCTIVITY TOOLS - It refers to the software eraser, and most likely, dictionary and thesaurus. that people use to create and produce documents, presentations, databases, charts, and graphs. - Word processors run the scope from simple - Productivity tools help you with through complex, but all ease the tasks presentation, graphics, and more. associated with editing documents (deleting, inserting, rewording, and so on). COMMON PRODUCTIVITY TOOLS: ELECTRONIC SPREADSHEET - spreadsheet is 1. Microsoft word probably the most useful general-purpose software 2. Microsoft Excel for the microcomputer user 3. Microsoft PowerPoint 4. LibreOffice - spreadsheets are now packaged in combination with other applications, such as MAIL MERGE - a Word's way of generating mass database system and graphic capabilities mailings. - It is an application program commonly used for budgeting, inventory management, It involves combining a list of names and decision making, forecasting and other addresses to individually address each finance-related tasks. person / receiver on the list. - It replaces the traditional financial modeling You can use Mail Merge to create tools, the accountant's columnar pad, pencil envelopes or address labels, as well as and calculator form letters. Mail Merged involved the following COMMON ERROR VALUES THAT YOU CAN documents: ENCOUNTER FROM FAULTY FORMULAS: 1. Main document - this document contains text and graphics. Example body of the 1. #DIV/0 - appears when entering a formula letter. that performs explicit division by zero (0) 2. Mailing list - this is your data source that is 2. ##### - appears when the column is not used to populate information in the letter. It wide enough to display the content and/or contains names and addresses of the dates and times are negative numbers. recipients. 3. #NAME? Appears when the formula refers 3. Merged document - this document the to a range name that doesn't exist in the combination of the main document worksheet. 4. #N/A - An inappropriate value was given for CUSTOM ANIMATION - a simulation of movement the lookup_value. created by displaying a series of pictures, or 5. #NULL! Appears most often when you insert frames. a space (where you should have used a comma) to separate cell references used as - Animation on computers is one of the chief arguments for functions. ingredients of multimedia presentations. 6. #NUM! Appears when Excel encounters a problem with a number in the formula HYPERLINK - or simply a link, is a reference data 7. #REF! Appears when Excel encounters an that the reader can directly follow either by clicking invalid cell reference, such as when you or tapping delete a cell referred to in a formula 8. #VALUE! Appears when you use the wrong - found in nearly all Web pages, allowing type of argument or operator in a function users to click their way from one page to another Lesson 1: Interactive Multimedia and ICT as Platform for Change III. Yolanda People Finder INTERACTIVE MULTIMEDIA - any computer- - During typhoon Yolanda, the People Finder delivered electronic system that allows the user to was a vital tool for people across the globe control, combine, and manipulate different types of to track the situation of their relatives. media, such as text, sound, video, computer IV. Million People March graphics, and animation. - Though dubbed as the Million People March, the number of total attendees was MULTIMEDIA CONTENT: only around 400,000. The organizers and 1. Videos - through video hosting sites, you promoters of the protest used Facebook can take a video and show it to the entire and Change.org as their mediums world. ICT AS MEDIUM FOR ADVOCACY 2. Sound, Music or Audio - If videos are too 1. CHANGE.ORG - dubbed as the “world’s much for you, you can always record platform for change” where anyone from an sounds. You can share your sound bites to online community can create a petition and the entire world. ask others to sign it. 3. Online games - Game developers now - gives access to more people by create what is called “browser-based allowing the online community to games.” You do not need to install these affix their digital signatures on a games to your computer as they run in most petition. updated web browsers. - mission is to help people from 4. Online Tests - Online survey forms and tests around the world create the change that automatically display the results when 2. DIGITAL CITIZENSHIP finished (Online IQ and Personality Tests). - referring to the utilization of 5. Courseware - Online courses that simulate information technology (IT) in order the classroom online (e.g., E-learning to engage in society, politics, and Courses using a Learning Management government. K. Mossberger, et al. System) define digital citizens as "those who 6. Podcasts - An episodic series of audio or use the Internet regularly and text files streamed online (e.g., Stuff You effectively" Should Know, TED Talks, The Starters, Ear Biscuits). Lesson 1: Collaborative ICT 7. Vodcasts - An episodic series of video Development streamed online (e.g., YouTube series/shows like Video Game High School, Web Page - is a document written in HTML Good Mythical Morning). (Hypertext Markup Language) that can be made accessible through the use of the internet or using ICT AS PLATFORM FOR CHANGE: an Internet browser. - A web page is accessed through the use of I. EDSA (People Power Revolution) a URL (Uniform Resource Locator) address - A major protest that took place along EDSA and may contain text, graphics, and from February 22 to 25, 1986 involving 2 hyperlinks to other web pages and files. million Filipinos from different sectors - can be in the form of an online publication, II. EDSA Dos (2001 EDSA Revolution) online newsletter (such as advertisements - It was fueled after 11 prosecutors of then or write ups) containing news of interest President Joseph Estrada walked out of the chiefly to a specific group. impeachment trial. As a result, the people in - A web page is the primary source for EDSA grew over the course of a few days information dissemination in the web through text brigades community. Through it, different platforms are made to make users and viewers share  information and build 2. Who wrote the article? collaboration-connection to one another 3. What is the purpose of the document and why was it produced? ONLINE COLLABORATIVE TOOLS - comes in 4. When was the document published and different kinds of platforms used for ICT updated? development. - These platforms enable users and admins Lesson 4: Advanced Techniques to promote interpersonal communication, enhance interactivity, establish common using Microsoft Word goals that will result in greater outcome of WORD PROCESSOR - an application that allows ICT readiness on an individual or group. users to create, edit, and print documents. - It is developed by Microsoft and was Lesson 3: Contextualized Online released on October 25, 1983. MICROSOFT WORD - complex program which Search and Research Skills people use to perform various functions such as TIPS ON IMPROVING SEARCH AND RESEARCH composing and editing, formatting and saving, and SKILLS: printing. Online search and research are more than KINDS OF MATERIALS - There are various kinds just ‘googling’ – typing a word in Google and of materials Microsoft Word is capable of then clicking the search button. integrating to make your documents richer, more It is a skill that every Internet user should impressive, and more informative know to do smart searching and this starts 1. Pictures - these are electronic, “soft copy”, with improving search and research skills to or digital pictures you have saved in any get better results. local storage device. Three common types 1. When searching online, narrow your topic. of picture files: 2. Put the word “AND” between each keyword a..JPG – pronounced as “jay-peg”. to create a search string. Short term for Joint Photographic 3. Identify synonyms of the key words. Experts Group. This type of image 4. Review the first pages returned. file can support 16.7 million colors. 5. Use the plus (+) sign for more specific Suitable for use when working with search. full color photographic images. 6. Use the minus (-) sign for more specific b..GIF – This stands for Graphics search. Interchange Format. This type of 7. Use wildcards for broader search. image file is capable of displaying 8. Use quotation marks to find phrases or transparencies and animation. It only names. supports 256 colors. 9. Use several search engines. c..PNG – It stands for Portable Network Graphics. It is capable of EVALUATING WEBSITES: displaying transparencies but not 1. What is the domain type of the website? animation. It supports only 16 million (if its a personal website, you should further colors evaluate it) 2. Clipart - This is generally a.GIF type; line art drawings or images used as generic representation for ideas and objects that you might want to integrate in your document. 3. Shapes - - These are printable objects or materials that you can integrate in your document to enhance its appearance or to allow you to have some tools to use for  composing and representing ideas or MAX - returns the largest value in a set of messages. values. 4. SmartArt - Generally, these are predefined AVERAGE - return the average (arithmetic sets of different shapes grouped together to mean) of the arguments. form ideas that are organizational or SUMIF - adds the cell specified by a given structural in nature. condition or criteria. 5. Chart - Another type of material that you ○ Range - range of cells that you want can integrate in your Word document that to evaluate based on a given criteria allows you to represent data characteristics ○ Criteria - determines which cells will and trends. be added. 6. Screenshots - creating reports or manuals ○ Sum_Range - cells containing for training or procedure will require the numeric values and the cells to add integration of a more realistic image of what if the condition is met. you are discussing on your report or manual AVERAGEIF - Returns the average (arithmetic mean) of all the cells in a range Lesson 5: Advanced Techniques that meet a given criteria. ○ Range - range of cells that you want using Microsoft Excel to apply the criteria. SPREADSHEET - It is a software application that ○ Criteria - determines which cells to enables a user to save, sort and manage data in an average. arranged form of rows and columns. ○ Average_Range - These are the Columns - identified with alphabetic cells containing numeric values and headings the actual set of cells to average. Rows - identified with numeric headings COUNTIF - Counts the number of cells Cells - are intersection of rows and columns within a range that meet a single criterion Cell Reference - also known as cell address that you specify. that identifies a cell on a worksheet ○ Range - the range of cells to count. Active Cell - the currently selected cell in a ○ Criteria - criteria that determines spreadsheet and is indicated by a bold which cells to be counted outline that surrounds the cell IF - t can perform a logical test and returns Texts or Labels - identifies the purpose of a one value if TRUE, and another value if cell, can be brief instruction, a title or FALSE. captions. ○ Logical Test - A value or logical Number data or Constant - a value that expression that can be evaluated as does not change and is directly inserted into True or False. a cell ○ Value if True - The value to return if Formula - an expression that calculates the the logical test or logical expression value of a cell evaluates to TRUE Mathematical Operators - MS Excel uses ○ Value if False - The value to return if standard operators for formulas. the logical test or logical expression Functions - these are pre–defined formulas evaluates to FALSE. that are already available in MS Excel. ○ Lesson 6: Advanced Techniques COMMONLY USED EXCEL FUNCTIONS: SUM - adds all the numbers in a range of using Microsoft PowerPoint cells. MICROSOFT POWERPOINT - powerful COUNT - counts the number of cells that presentation software that helps you produce an contain numbers. effective presentation in the form of on-screen MIN - returns the smallest number in a set slides. of values. TERMS, VIEWS, AND FUNCTIONS IN 6. Contrast - Use light font on dark background MICROSOFT POWERPOINT: or vice versa Slide - is a single page of a presentation collectively, a group of slides may be known Lesson 8: Imaging and Design for as a slide deck. - The shortcut key to insert a new the Online Environment slide is Ctrl+M. PHOTOSCAPE - There are plenty of image Design Template - are pre-designed graphic manipulation programs but if you are going to styles that you can apply to your slides create a website, you have to use the one which is Slide Show Button - a collection of pages efficient. PhotoScape is a good tool because it is arranged in sequence that contain text and feasible for beginners and advanced users alike. images for presenting to an audience. FEATURES OF PHOTOSCAPE: - You may press F5 if you want to 1. Viewer – as the name implies, is a picture start your presentation from the viewer with features the same with the most beginning of the slides or you may image viewers like changing image click orientation. Transition - are motion effects that when in 2. Editor - alters the appearance of a single Slide Show view add movement to your image. slides as you advance from one slide to 3. Batch Editor – alters the appearance of another. multiple images Presentation Views - These are the buttons 4. Page – arranges several photos to create a that you use to change views into normal, single one; similar to a mosaic outline, slide sorter, notes page, and 5. Combine – links several images together to reading views. form a bigger image Normal Views - a simplified layout of the 6. Animated GIF – allows you to create an page so you can quickly key, edit, and animated GIF from several pictures format the text. 7. Print – readies pictures for printing Notes Page View - displays your slides on 8. Splitter – divides a single photo into multiple the top portion of the page, with the speaker parts notes for each slide in the notes pane on 9. Screen Capture – captures the screen and the bottom of the pane. saves it Outline View - displays all of the text in a 10. Raw Converter – converts RAW images PowerPoint slide show in outline form (uncompressed images usually from digital regardless of the design, objects and camera to JPEG. animations. 11. Color Picker – grabs a pixel from your Slide Sorter View - allows you to see screen to be used in editing thumbnails of all the slides in your 12. Rename – allows you to rename batch of presentation to easily rearrange them photos 13. Paper Print – useful tool for printing your TIPS IN CREATING AN EFFECTIVE own calendars, sheets, lined paper, graph PRESENTATION: paper, etc. 1. Minimize - Keep slide counts to a minimum to maintain a clear message and to keep PRINCIPLES AND BASIC TECHNIQUES OF the audience attentive IMAGE MANIPULATION: 2. Clarity - Use a font style that is easy to read 1. Cropping - process of removing unwanted 3. Simplicity - Use bullets or short sentences parts of the image, focusing only on the 4. Visuals - Use graphics to help in your subject. presentation but not too many to distract the 2. Color Balance – In any image manipulation audience program, this command will allow you to 5. Consistency - Make your design uniform make changes in the mixture of colors in an image.  3. Adjusting Brightness and Contrast – This 5. Zenfolio – It is an online image-hosting site command is the most basic technique when that not only allows you to upload images adjusting the image tone (highlights, but also lets you create an online image shadows, and midtones). website for your images. 4. Compression and Resizing - is an important aspect in image manipulation. Images to be Lesson 9: Nature and Purposes of uploaded on the web must be of the standard resolution of 72 dpi Online Platforms and Applications 5. Color Blending - Use the different special ONLINE PLATFORMS - technologies that are effects buttons available in the different grouped to be used as a base upon which other image editing software. You can combine applications processes or technologies are colors and commands that will give you a developed more dynamic image result. 6. Combining Multiple Images - Compositions EXAMPLES OF ONLINE PLATFORMS: must be planned and conceptualized first so A. Presentation / Visualizations - that you will be able to render the best communicates information clearly and image and message possible. efficiently via statistical graphics, plots and information graphics ONLINE GRAPHIC SOFTWARE: B. Cloud Computing - the practice of using a 1. BeFunky - you can play with hundreds of network of remote servers hosted on the amazing photo effects that you can't find internet to store, manage, and process data, anywhere else, like our world famous rather than a local server or a personal Cartoonizer®, oil painting, and pop art computer effects. C. Social Media - are computer-mediated tools 2. Fotor -. It is a multiplatform photo editing that allow people, companies and other website. It offers a wide range of effects and organizations to create, share, or exchange tools for editing images information, career interests, ideas, and 3. Pixlr - It is also a multiplatform image editing pictures/videos in virtual communities and program. You can choose between the networks editor for editing images or creating an D. Web Page Creation - encompasses a original image right through the browser. number of important elements including color, layout, and overall graphical IMAGE HOSTING SITES: appearance 1. Imgur – It is a free image hosting site E. File Management - is the storing, naming, wherein you can upload images from your sorting and handling computer files computer. You can also edit your images Examples of File Management before posting it online. F. Mapping - a transformation taking the points 2. Flickr – It is an image social networking site. of one space into the points of the same or You can save and manage your photos for it another space. offers a 1 TB storage capacity in your account. CONTENT MANAGEMENT SYSTEM - is a 3. Photobucket – It has almost similar features computer application (sometimes online or browser with Flickr as you can upload and share based) that allows you to publish, edit and your images over the internet through your manipulate, organize and delete web content. CMS account. is used in blogs, news websites, and shopping 4. SlickPic – It is an online image-hosting BLOGS - is a discussion or informational website service that allows you to upload and store published on the web consisting of discrete, often an unlimited number of photos online. You informal diary-style text entries ("posts"). Posts are can create as many albums, and it also typically displayed in reverse chronological order, offers professional editing of images. so that the most recent post appears first, at the top of the web page Lesson 10: Web Page Design Using Google Adwords - an online advertising service that enables advertisers to compete Templates and Online WYSIWYG to display brief advertising copy to web users. Platforms Reddit - allows you to gather feedback and WYSIWYG - an editor that allows you to create and advice. design web pages without any coding knowledge. Facebook Ads - an ad network platform to - Jimdo is a WYSIWYG web hosting service test and validate ideas. offering free and paid services. Jimdo has tools that will allow you to sell your products online. Lesson: Principles of Interactivity - Create your own photo gallery, videos, and and Rich Content in the Context of many more. You can also maximize the search engine by properly tagging your site. Web 2.0 WEB 2.0 - is the interactive version of web-based WEBSITE TEMPLATE - is a predesigned communities and social networking websites like webpage, simply by adding your text and facebook and video sharing sites as wikis, blogs, customization to create your desired web page. It is mashups, etc. usually built with HTML and CSS code. - It allows the user to interact with the page WYSIWYG editor- It allows you to create and known as dynamic page; instead of just design a web page without any coding knowledge. reading a page, the user may be able to - What You See Is What You Get comment or create a user account. - Dynamic page refers to the web pages that Lesson 11: How to manage an online are affected by user input or preference. The user cannot only receive information, ICT Project for Social Change? but also contribute and modify the available WORDPRESS - a free and open source content content. management system based on PHP and MySQL. KEY FEATURES OF WEB 2.0: MICROSOFT OFFICE SERVER - a project Folksonomy - This allows users to management server solution made by microsoft categorize and classify/arrange information that allows you to view and upload documents. using freely chosen keywords (e.g. tagging). FILE MANAGER - an uploading tool web interface Popular social networking sites such as that allows you to manage all your files. Twitter, Instagram, Facebook, etc. use tags WEBSITE MANAGEMENT - is an integrated set of that start with a pound sign (#) or hashtag. tools and services that allows teams to create, Rich User Interface - The content is design, develop, launch, manage, administer, and dynamic and is responsive to user’s input. monitor website contents. An example would be a website that shows local content. In the case of social PROMOTION, TRACTION, AND TRAFFIC networking sites, when logged on, your MONITORING: account is used to modify what you see on PROMOTION: their website. Use multimedia User Participation - The owner of a website Use various online tools is not the only one who is able to put Use images content. Others are able to place a content Use blogs on their own by means of comments, Collaborate reviews, and evaluation. Update Long Tail - Services are offered on demand TRACTION TOOLS: rather than on a one-time purchase. LinkedIn - a business-oriented social networking service.