Information and Communication Technology (ICT) deals with the use of different communication technologies such as mobile phones, telephone. Internet, etc. to locate, save, send and edit information.
When the World Wide Web was invented, most web pages were static. Static in the sense that the page is “as is” and cannot be manipulated by the user. The content is also the same for all users. This is referred as Web 1.0.
Web 2.0 is the evolution of Web 1.0 by adding dynamic web pages– the user is able to see a website differently than others. Examples of Web 2.0 include social networking sites, blogs, wikis, etc. Web 2.0 allows users to interact with the page. Most websites that we visit today are Web 2.0.
Folksonomy – it allows users to categorize and classify/arrange information using freely chosen keywords (e.g. hashtagging).
Rich User Experience – content is dynamic and is responsible to user’s input.
User Participation – the owner of the website is not the only one who is able to put content. Others are able to place a content of their own by means of comments, reviews, and evaluation.
Long Tail – services that are offered on demand rather than on a one-time purchase.
Software as a Service – users will subscribe to a software only when needed rather than purchasing them.
Mass Participation – diverse information sharing through universal web access.
Web 3.0 is a concept of the World Wide Web that is designed to cater to the individual user. The aim of Web 3.0 is to have machines (or servers) understand the user’s preference to be able to deliver web content specifically targeting the user.
Compatibility
Security
Vastness
Vagueness; and
Logic
Convergence – it is the synergy of technological advancements to work on a similar goal or task.
Social Media – they are websites, applications, or online channel that enables web users to create, co-create, discuss, modify, and exchange user-generated content. There are six types of social media which are Social Networks, Bookmarking Sites, Social News,Media Sharing,Microblogging and Blogs and Forums
Mobile Technologies – The popularity of smartphones and tablets over the years This is Largely because of the devices’ capability to do tasks that were originally found in personal computers. Mobile devices use different operating systems such as: iOS, Android, Blackberry, Windows Phone OS, Symbian, WebOS, Windows Mobile
Assistive Media – it is a nonprofit service designed to help people who have visual and reading impairments.
The Internet is defined as the information superhighway. this means that anyone has access to this highway, can place information, and can grab that information. Any information, even things that you have set privately, can be accessed one way or another. This is why social networking sites like Facebook continue to improve their security features. The threat of cybercrime is very real. While you may not experience the threat now, whatever information we share today could affect our future.
-Malware – stands for malicious software
Virus – a malicious program designed to replicate itself from one computer to another.
Worm – a malicious program that transfers itself to one computer to another.
Trojan – a malicious program that is disguised as a useful program but once downloaded or installed, leaves your PC unprotected and allows hackers to get your information.
Rogue Security Software – tricks the user into posing that it is a security software. It asks the user to pay to improve his/her security but in reality, they are not protected at all.
Spyware – a program that runs in the background without you knowing it.
Keyloggers – used to record keystrokes done by users.
Adware – a program desinged to send you advertisements, mostly as pop-ups.
– Spam – unwanted email mostly from bots or advertisers. It can be used to send malware.
– Phishing – Its goal is to aquire personal information. This is done ny sending you an email that will direct the user to visit a website abd be asked ti update his/her username, password, etc.
– Pharming – it’s phishing but it involves exploiting the DNS system.
Once you post something over the Internet, search engines keep them in their archives for search results. This makes anything you post to last forever even if you delete it in your page. Something you and your friends find funny today may be something that could harm someone’s reputation later.
Here are some things you might want to consider before posting something over the internet:
Before you post something on the web, ask these questions to yourself: Would you want your parents or grandparents to see it? Would you want your future boss to see it? Once you post something on the web, you have no control of who sees your posts.
Your friends depend on you to protect their reputation online. Talk to your friends about this serious responsibility.
Set your post to “private”. In this way, search engines will not be able to scan that post.
If you feel that a post can affect you or other’s reputation, ask the one who posted it to pull it down or report it as inappropriate.
If you create something– an idea, an invention; a form of literary work, or a research, you have the right as to how it should be used by others. This is called intellectual property. In other words, the copyright law includes your rights over your work, and anyone who uses it without consent is punishable by law.
As a responsible user of the internet, you have to consider that not everything out there is free for you to use. Just like your own, contents that you see from websites have their respective copyrights. There are several instances where employees or business owners face copyright infringement and are sentenced to a huge fine due to reckless copying of materials.
Here are some tips that could help you avoid copyright infringement:
Understand.
Be responsible
Be creative
Know the law
In the professional world, sending out information to convey important information is vital. Because of ICT, things are now much faster than the traditional newsletters or posted mail. You can now use the Internet to send out information you need to share. What if we could still do things much faster — an automated way of creating and sending uniform letters with different recipients? Would that not be more convenient?
In this particular part of this lesson, we will learn one of the most powerful and commonly used features of MS Word called “Mail Merge.” As the name suggests, this feature allows you to create documents and combine or merge them with another document or data file. It is commonly used when sending out advertising materials to various recipients.
The simplest solution for the scenario above is to create a document and just copy-paste it several times then just replace the details depending on whom you send it to. But what if you have hundreds or thousands of recipients? What if you have a small database of information where you can automatically generate those letters?
Mail Merge is a useful tool that allows you to produce multiple letters, labels, envelopes, name tags, and more using information stored in a list, database, or spreadsheet.
The mail merge process has three documents involved in creating and printing letters and emails, or labels and envelopes.
Your main document
This document contains text and graphics (a logo or an image, for example) that are identical for each version of the merged document. An example of identical content is the return address on the envelope or in the body of a letter or an email message.
Your mailing list
This document contains the data that is used to fill in information in your main document. For example, your mailing list contains the addresses to be printed on the labels or envelopes. Usually an Excel workbook.
Your merged document
This document is a combination of the main document and the mailing list. Information is pulled from your mailing list and inserted in your main document, resulting in the merged document—the letter, email, labels, or envelopes—personalized for different people on the mailing list.
Here’s a video done by Kippi Harraid on how to create a Mail Merge:
Integrating or inserting pictures in your document is fun and it improves the impression of your document. A common use of inserting a picture on a document is when you are creating you resume. Though seemingly simple to do, your knowledge on the different kinds of materials that you can insert or integrate in a Word document and its characteristics can help you create more efficient, richer document not only in content but also in physical form. A better inderstanding of the physical form of your document as well as tje different materials you integrate in it would allow you to be more efficient and versatile in using MS Word.
The screenshot above shows the kinds if materials that can be integrated or inserted in your MS Word Document. One can easily get excited anad instead create a collage of what is generally called images and arts rather than an enriched tect document. One important thing to remember is that images and other materials are not to be inserted as images for design purposes only, but they are used to enhance or improve the effectiveness of the message you want to convey. Let us describe them:
Pictures – generally, these are electronic or digital pictures or photographics you saved in any local storage device. These are the three most commonly used types of picture types. you can identify them by the extension on their file names: Joint Photographic Experts Group (or .jpg), Grahpics Interchange Format (or .gif). Portable Network Graphics (or .png)
Clip Art – 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.
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 messages.
Smart Art – generally these are predefined sets of different shapes grouped together to form ideas that are organizational or structural in nature.
Chart – this is quite useful when you are ==preparing reports that correlate and present data in a graphical manner.
Screenshot – MS Word provides a snipping tool for your screenshots so you can select and display only the part that you exactly like to capture on your screen.
sources:
Whether you wirk in the field of accounting or not, the truth is whatever you do should be accounted for. This is because the resources you use cost you expenses. Whether you become a scientist, an engineer, a yoga instructor, etc. it is important ti understand how a company spends to be able to deliver a product or service. These factors could be easily be computed using spreadsheet programs like MS Excel or Google Spreadsheets.
If you need to sum a column or row of numbers, let Excel do the math for you. Select a cell next to the numbers you want to sum, click AutoSum on the Home tab, press Enter, and you’re done.
When you click AutoSum, Excel automatically enters a formula (that uses the SUM function) to sum the numbers.
Here’s an example. To add the January numbers in this Entertainment budget, select cell B7, the cell immediately below the column of numbers. Then click AutoSum. A formula appears in cell B7, and Excel highlights the cells you’re totaling.
Press Enter to display the result (95.94) in cell B7. You can also see the formula in the formula bar at the top of the Excel window.
The Microsoft Excel AVERAGE function returns the average (arithmetic mean) of the numbers provided.
The AVERAGE function is a built-in function in Excel that is categorized as a Statistical Function. It can be used as a worksheet function (WS) in Excel. As a worksheet function, the AVERAGE function can be entered as part of a formula in a cell of a worksheet.
The syntax for the AVERAGE function in Microsoft Excel is:
AVERAGE( number1, [number2], ... [number_n] )
number1, number2, … number_n
Numeric values that can be numbers, named ranges, arrays, or references to numbers. There can be up to 30 values entered.
Let’s look at some Excel AVERAGE function examples and explore how to use the AVERAGE function as a worksheet function in Microsoft Excel:
Applies To: Excel 2016 Excel 2013 Excel 2010 Excel 2007 Excel 2016 for Mac More…
The COUNT function counts the number of cells that contain numbers, and counts numbers within the list of arguments. Use the COUNT function to get the number of entries in a number field that is in a range or array of numbers. For example, you can enter the following formula to count the numbers in the range A1:A20: =COUNT(A1:A20). In this example, if five of the cells in the range contain numbers, the result is 5.
Here’s a link to a video explaining the COUNT function:
https://support.office.com/en-us/article/COUNT-function-a59cd7fc-b623-4d93-87a4-d23bf411294c
COUNT(value1, [value2], …)
The COUNT function syntax has the following arguments:
value1 Required. The first item, cell reference, or range within which you want to count numbers.
value2, … Optional. Up to 255 additional items, cell references, or ranges within which you want to count numbers.
NOTE: The arguments can contain or refer to a variety of different types of data, but only numbers are counted.
Arguments that are numbers, dates, or a text representation of numbers (for example, a number enclosed in quotation marks, such as “1”) are counted.
Logical values and text representations of numbers that you type directly into the list of arguments are counted.
Arguments that are error values or text that cannot be translated into numbers are not counted.
If an argument is an array or reference, only numbers in that array or reference are counted. Empty cells, logical values, text, or error values in the array or reference are not counted.
If you want to count logical values, text, or error values, use the COUNTA function.
If you want to count only numbers that meet certain criteria, use the COUNTIF function or the COUNTIFS function.
sources:
https://www.techonthenet.com/excel/formulas/average.php
https://support.office.com/en-us/article/COUNT-function-a59cd7fc-b623-4d93-87a4-d23bf411294c
Designing your presentation is the fun part of creating a report fir it gives you a chance to be creative. Placing animations, transitions, and art could be on your mind right now. But whether or not these features would help is generally up to you. Sometimes, these things could actually distract your audience rather than help you. Here are some quick tips in creating an effective presentation:
Minimize – keep slide counts to a minimum to maintain a clear message and to keep the audience attentive. Most information should still come from the reporter.
Clarity – Avoid being fancy by using a font style that is easy to read. Make sure that it is also big enough to be read by the audience.
Simplicity – Use bullets or short sentences. Summarize the information on the screen to have your audience focus on what the speaker is saying rather than on reading the slide. Limit the content to six lines and seven words per line.
Visuals – Use graphics to help in your presentation but not too many to distract the audience. In addition, instead of using a table of data, use charts and graphs.
Consistency – Make your design uniform. Avoid having different font styles and backgrounds.
Contrast – Use light font on dark background or vice versa. This is done so that it is easier to read. In most instances, it is easier to read on screen if the background is dark. This is due to the brightness of the screen.
Creating a web page is like creating a work of art. There are certain things that you need to consider in order to get your message across. In Lesson 5: Advanced Presentation Skills , you learned some tips on how to create an effective PowerPoint presentation. Some of those tipscan help you in graphics and design layout.
1. Balance – it is the visual weigh of objects, texture, colors, and space is evenly distributed on the screen.
source: https://www.pinterest.co.uk/brandyn_xavier/balance/
2. Emphasis – an area in the design that may appear different in size, texture, shape or color to distract the viewer’s attention.
source: https://www.pinterest.com/pin/545850417307142708/
3. Movement – how the eye moves through the composition leading the attention of the viewer from one aspect to another.
source: https://www.craftsy.com/blog/2015/02/drawing-movement/
4. Pattern, Repetition, and Rhythm – these are the repeating visual element on an image or layout to create unity in the layout or image. Rhythm is achieved when visual elements create a sense of organized movement.
source: https://www.123rf.com/photo_6777821_weave-pattern-showing-repetition-useful-as-background.html
5. Proportion – visual elements create a sense of unity where they relate well with one another.
source: http://www.phimatrix.com/web-site-design-golden-ratio/
6. Variety – this uses several design elements to draw a viewer’s attention
source: https://www.researchgate.net/figure/289645410_fig1_Figure-1-Thumbnails-of-the-LTTO-episodes-showing-the-variety-of-topics-covered-in-the
Visual presentations of information that ise the element of design to display content.
Express complex messagesto viewers in a way that enhances their comprehension.
Basically using pictures, objects, and images in a way for the viewers to easily understand the message of a topic.
To communicate a message
To present in a way that is compact and easy to comprehend.
To analyze data in order to discover cause-and-effect relationships.
To periodically monitor the route of certain parameters.
Visual Elements which includes color coding, graphics, and reference icons.
Content Elements which includes time frames, statistics and references; and
Knowledge Elements which consist of facts.
Cause and Effect Infographics – infograpics that show the cause and effects of certain topics.
Chronological Infographics – usually used to show a topic in a chronological or a step-by-step sequence.
Quantitive Infographics – used to show statistics like charts, bar graphs, etc.
Directional Infographics – similar to chronological infographics where you use arrows to direct the viewers attention to another aspect of the infographic.
Product Infographics – used to promote products and services.
Simplicity Rocks. Keep the infographic simple so it wont be an eyesore to the viewers
Nothing takes effect without a cause. This just means that you need to show the viewers the cause of the topic before discussing the effect of said topic.
Draw your Boundaries. Just don’t overdo the pictures or images or it will look like a collage that looks like vomit.
Think in Color. Match the colors in your infographic like making the text in white in a dark background and vice versa.
Layout is not just Typography.
Make it Appealing. Of coarse make it look good so it would attract and keep the viewer’s attention.
Be Verifiable. And finally, the facts in the infographic should be verified and confirmed that the they are indeed true.
We will asls focus on platforms that will allow us to share our own content to the rest of the world. We will also create a few of them to experience what is it like to use all of them.
Social Media Platforms – Websites like Facebook allow you to create not only personal accounts but also pages and groups where you can share content. The only downside of this is that you are restricted to Facebook’s “one-size-fits-all” design.(note:It has low customization but backed up by popularity.)
Blogging Platforms – Websites like WordPress, Tumblr, and Blogger focus on content and design. It typically looks like a newsletter where you are given options to change the design to your liking. Though you can manipulate the design, social media platform’s popularity is still unrivaled. The amount of customization in blogs is also unrivaled depending on the content management system implemented by the provider.(note: it has high customization, popularity depends to the user to maximize the use of blogs.)
A Content management System (CMS) is a computer application (sometimes online or browser-based) that allows you to publish, edit and manipulate, organize and delete web content. CMS is used in blogs, news websites, and shopping.
So what I have also learned from this lesson is the difference between the two platforms. In social media platforms, you can only post a status about a topic or a headlineonly but in blogging platforms is where you can explain the topic more in-depth than the social media platforms.
People use HTML codes to create pages and CSS codes to design them. If you have taken up these coding skills before, it will help you in creating pages using WYSIWYG. If you have not, WYSIWYG is designed for everyone who has not or does not have prior coding skills
WYSIWYG is the acronym for What You See Is What You Get. This means that whatever you type, insert, draw, place, rearrange, and everything you do on a page is what the audience will see. Like using the MS Word, WYSIWYG shows and prints whatever you type on the screen.
Dial-up connection – is established when two or more communication devices use a public switched telephone network (PSTN) to connect to an Internet service provider (ISP).
DSL provides high-speed networking over ordinary phone lines using broadband modem technology. The technology behind DSL enables Internet and telephone service to work over the same phone line without requiring customers to disconnect either their voice or Internet connections.
Cable internet uses the existing lines for your cable TV to provide fast, reliable service, meaning you can browse the web and watch your favorite TV shows at the same time, all over a single cable and through a single provider.
Wireless Internet enables wireless connectivity to the Internet via radio waves rather than wires on a person’s home computer, laptop, smartphone or similar mobile device.
A Dedicated line is a telecommunications path between two points that is available 24 hours a day for use by a designated user (individual or company). It is not shared in common among multiple users as dial-up lines are. A dedicated line can be a physical path owned by the user or rented from a telephone company, in which case it is called a leased line.
Balance – symmetrical and asymmetrical arrangements of the text and objects of the web page.
Proximity – proper arrangement of related elements would facilitate user interaction.
Focus – a web page must have a focal point that you want the user to focus and remember.
White Spaces – -literary blank spaces to allow readability of important texts and draw attention to images on the web site.
Unity – it is achieve by using the same company logo, font color, font style, composition and other elements.
Alignment – it is the proper arrangement and positioning of the elements of the web site.
sources:
In this lesson, we only need to know what and how to use online collaborative tools to effectively monitor tasks and understand how important these tools are.
A web portal is a website that contains information from different sources an place them in one location in a uniform way.
An example of a web portal is Yahoo!
source:http://mashable.com/2016/07/26/yahoo-history/
These web portals were created with the help of Online Collaborative Tools. So what are online Collaborative Tools?
Working together dos not necessarily mean you have to be physically together. Simply put, online collaboration lets a group of people work together in real-time over the internet. Those engaged in online collaboration can work together on word processor documents, PowerPoint Presentations and even for brainstorming, all without needing to be in the same room at the same time. There are many great online collaboration tools available which can help your team accomplish its goals.
There are plenty of online collaborative tools:
You can use Facebook groups to create a group page that will allow people in your group to communicate your ideas.
WordPress also allows you to have multiple contributors for a single blog.
Google Drive and Microsoft Office Online allow multiple people to work on different office files and even have their own group’s cloud storage.
Microsoft Yammer offers companies to have their own social network that allows sharing and managing content.
Sites like Trello offer an online to-do checklist for your entire team.
Here are some things you need to consider to decide if it is a good collaborative tool:
Easy to use and to set-up.
Have the features that will fit your purpose.
Ability to upload documents.
Has security features.
So here in this lesson, we need to know what is multimedia and how does its effects in terms of education. But first, we need to know the term Interactive Multimedia.
Interactive Multimedia- products and services on computer-based systems which respond on the user’s actions by presenting content.
Videos. Through video hosting sites, you can take a video and show it to the entire world (e.g., YouTube).
Sound, Music, or Audio. If videos are too much for you, you can always sounds. You can how share your sound bites to the entire world (e.g. Soundcloud).
Online games. Game developers now create what is called “browser-based games.” You do not need to install these games to your computer as they run the most updated web browsers (e.g., Adventure Quest, Farmville, Candy Crush)
Online tests. Online survey forms and tests that automatically display the results when finished (e.g.,Online IQ and Personality Tests).
Courseware. Online courses that simulate the classroom online (e.g., E-learning Courses using a Learning Management System).
Podcasts. An episodic series of audio or text files streamed online (e.g, Stuff You Should Know, TED talks, The Starters, Ear Biscuits).
Vodcasts. An episodic series of video and streamed online (e.g. Youtube, series/ shows like Video Game High School, Good Mythical Morning).
Now that we know what are some multimedia contents you can find, we can now know what can be the use of this in terms of education.
POTENTIALS OF MULTIMEDIA IN TERMS OF EDUCATION:
Fast
Cheap
Private
Safe
Private
Safe
Strong Foundation
Tool to make remembering longer and easier
More Information faster
It’s Fun
IMPACT OF INTERACTIVE MULTIMEDIA IN EDUCATION:
Change in Student and teacher roles.
Increased motivation and Self-Esteem.
Technical Skills.
Accomplishment of more complex tasks.
More collaboration with peers.
Increased use of outside sources.
Improved design skills.
WHEN TO USE INTERACTIVE MULTIMEDIA?
Lecture Presentation
Collaborative Learning
Individualized Learning
Creating Reports of Presentations
Assessment
Pros:
The ability to change outcomes based on input.
The learning style is individual and exclusive.
Learners take more productive role.
Cons:
Using instructional technologies requires great quantity of resources.
Learner Control Problems.
In this lesson, we will learn to understand the importance of ICT as a platform for social change and understand the events that ICT helped realize, and use prior ICT knowledge in planning a campaign using online resources.
Throughout recent history, the Philippines has been one of a few nations that demonstrates unity fir a call to action or social change. These campaigns for social change would have been successful if it were not for ICT.
EDSA (People Power Revolution). The People Power Revolution lasted from 1983 to 1986. During a radio broadcast of Radyo Veritas,Cardinal Sin encouraged the Filipinos to help end the regime of then President Ferdinand Marcos. A major protest took place along EDSA from February 22-25, 1986 involving two million Filipinos from different sectors. These included civilians, political parties, the military, and religious groups. The radio broadcast helped change the course of history. Without it, Filipinos would not have been moved into action.
EDSA Dos. This is also known as the 2001 EDSA Revolution, happened during January 17-21,2001. It was also fueled after 11 prosecutes of then President Joseph Estrada walked out of the impeachment trial. As a result, the crowd in EDSA grew over the course of a few days through text brigades. Like the first People Power Revolution, Edsa Dos would not have been successful without the text brigades.
Million People March. This is a series of protests that mainly took place in Luneta Park from August 22 to 26, 2013. there were also several demonstrations that happened around key cities in the Philippines and some locations overseas. It was to condemn the misuse of the Priority Development Assistance Fund(PDAF). Though dubbed as the Million people March, the number of total attendees was only around 400.00. Despite that, it was still considered a success and clearly demonstrated how powerful social media campaigns are. The organizers and promoters of the Million People March used Facebook and Change.org as their medium.
Yolanda People Finder. Recent storms in the Philippine history gave birth to the People finder database powered by Google. During typhoon Yolanda, the People Finder was a vital tool for people across the globe to track the situation of their relatives. This proved to be successful and is now adapted by more organizations to help people track relatives during calamity.
source: http://guide.change.org/
Change.org is dubbed as the “world’s platform for change” where anyone from the online community can create a petition and ask other to sign it. During the past time petitions are only done through singing a paper, usually done by a group asking for signature via travel. Change.org gives access to more people by allowing the online community to affix their digital signatures on a petition.
Change.org‘s mission is to help people from around the world create the change they want to see. For years, Change.org hosted several petition that help solve the following problems: economic problems, criminals injustice, abuse of human rights, lack of education, environmental concerns, animal abuse, human health concerns, and world hunger.
Social Change refers to an alteration in the social order of a society. Social Change may include social institutions, social behaviors, or social relations. It can be done in any form of multi-media.
You can make social changes through the use of campaigns. Campaigns are a work in an organized and active way toward a particular goal; typically a political or social one. A campaign will help you promote and organize your project properly.
Planning —> Development —> Release and Promotion —> Maintenance
1. Planning – involves the following task (but not limited to):
Conceptualizing your project project
Researching on available data about your topic
Setting deadlines and meetings
Assigning people to various tasks
Finding a web or blog host
Creating a site map for tour website
Listing down all applications, that you need including web apps
Funding (If applicable)
Creating a Concept Paper
REPORT THIS AD
Before starting your project, your group should be able to do the necessary paperwork. This allows experts to see if your project is doable over the time frame that was given and if it is significant enough to be made into reality.
A concept paper is a document used to convince a panel of potential funders to help a product, program, or service to become a reality.
There are five elements of a concept paper:
1.Introduction-includes tour group’s mission and vision and a brief introduction of your project.
Purpose-includes the reasons why this project is worth your group and your sponsor’s time, effort and money.
3.Description-includes all the necessary information about the project. In ICT, it involves the sites you are going to produce and the purpose of each and how they work in unison.
4.Support-contains the budget needed for the project. Some concept papers do not specify any amount requested from the sponsor.
5.Contact information-includes information on how the group be contacted.
2. Development – involves the actual creation of the website(s), involves the production of images, infographics, etc.
Medias you can use:
Text
Videos
Pictures
Audio
Websites
3. Release and Promotion – involves the actual release of the website for public view and promoting it. Promotion typically starts before the actual release.
4. Maintenance – involves responding to feedback of your site visitors and continuing to improve your website.