ICT Flashcards
____________ is the infrastructure and components that enable modern computing.
ICT, or information and communications technology (or technologies)
what are the USES OF ICT IN OUR DAILY LIVES
- COMMUNICATION:
- Job Opportunities:
- Education:
- Socializing:
Nowadays people are in touch with the help of ICT. Through chatting, E-mail, voice mail and social networking people communicate with each other. It is the cheapest means of communication.
COMMUNICATION:
In the employment sector, ICT enables organizations to operate more efficiently, so employing staff with ICT skills is vital to the smooth running of any business.
Job Opportunities:
ICT provides the flexibility and availability of learning materials to all students. While all resources are available in classrooms, students can also access them outside schools.
Education:
Social media has changed the world. The rapid and vast adoption of these technologies is changing how we find partners, how we access information from the news, and how we organize to demand political change.
Socializing:
What are the Positive Impacts of
Information and Communication Technology
- ACCESS TO INFORMATION:
- IMPROVED ACCESS TO EDUCATION:
- NEW TOOLS, NEW OPPORTUNITIES:
- COMMUNICATION:
- INFORMATION MANAGEMENT:
- SECURITY:
- PEOPLE PARTICIPATION:
- DISTANCE LEARNING:
- TESTING AND EXPERIMENTS:
- CREATION OF NEW MORE INTERESTING JOBS:
Examples would be systems analysts, programmers and software engineers, as well as help desk operators and trainers.
CREATION OF NEW MORE INTERESTING JOBS:
ICT facilitates the ability to perform ‘impossible’ experiments’ by using simulations.
TESTING AND EXPERIMENTS:
Students can access teaching materials from all over the world.
DISTANCE LEARNING:
ICT allows people to participate in a wider, even worldwide, society.
PEOPLE PARTICIPATION:
: ICT solves or reduces some security problems, e.g., Encryption methods can keep data safe from unauthorized people, both while it is being stored or while it is being sent electronically.
SECURITY
Data mining of customer information to produce lists for targeted advertising.
INFORMATION MANAGEMENT:
Cost savings by using e.g., VoIP instead of normal telephone, email / messaging instead of post, video conferencing instead of traveling to meetings, e-commerce web sites instead of sales catalogues. Access to larger, even worldwide, markets.
COMMUNICATION:
ICT gives access to new tools that did not previously exist.
NEW TOOLS, NEW OPPORTUNITIES:
Distance learning and online tutorials. New ways of
learning, e.g., interactive multi-media and virtual reality.
IMPROVED ACCESS TO EDUCATION:
All you need is a phone and access to the Internet to find what you need. Thousands of resources are available on various online platforms, making it convenient for someone to search for the information they need.
ACCESS TO INFORMATION:
What are the Negative Impacts of
Information and Communication Technology
- JOB LOSS:
- REDUCED PERSONAL INTERACTION:
- REDUCED PHYSICAL ACTIVITY:
- COST:
- COMPETITION:
____________is a spreadsheet program that help us to store and represent the data in tabular form, manage and manipulate data, create optically logical charts, and more.
Microsoft Excel
Provides you the worksheet to create a new document in it.
Microsoft Excel
it’s used to create grids of text, numbers and formulas specifying calculations.
Microsoft Excel
________are the specific groups of related commands.
TABS:
________it contains multiple commands that divided into groups.
RIBBON:
_______a set of closely related commands normally performed as part of a larger task.
GROUP:
_________a group that brings up more related commands.
LAUNCH BUTTON:
________- are made up of columns and rows.
Spreadsheet
the intersection of rows and columns is called a ______
Cell
A ______ is a group of cells that are together.
range
A _______ is a file that contains one or more worksheets to help us organize data.
workbook
_______ a single page or sheet within the workbook.
Worksheet
Steps in Creating a workbook
- Open the Microsoft excel
- Select blank workbook.
- Select an empty cell.
- Then type any data.
- Save your workbook.
Steps in Modifying a workbook
The two ways to modify a workbook
1. Edit the data itself, such as the labels, numbers, and formulas that make up a spreadsheet.
2. Edit the physical layout of the spreadsheet, such as adding or deleting rows and columns.
Steps in Modifying Worksheet
- Display the worksheet that you want to edit.
- Then save changes you have made and return to the worksheet.
Steps in Merge and unmerge cell
- Merging combines two or more cells into a single cell. It’s a great way to create a label or header that will fit together.
- Unmerge cell get things back to normal.
It’s a great way to create a label or header that will fit together.
Merging
Customize the Excel 2016 app window
You can personalize the ribbon with things like:
- Adding buttons to the Quick Access Toolbar
- Rearrange tabs, in the order you want.
- Creating a new ribbon tab
- Adding group to ribbon tab
______can replicate the same across the remaining cells in the column.
Flash Fill
It recognizes the pattern and completes it.
Flash Fill
How to Move Data within a Workbook
Select the worksheet tab, and drag it to where you want it to move a portion of the data within a workbook.
Sometimes we need to_____ multiple excel cells to make them fit the text content.
expand
Formulas always start with an_________, which can be followed by numbers, math operations, and functions
equal sign (=)
_______ finds the total of values in cells
SUM function
________- allows you to make logical comparisons between a value and what you expect.
IF function
_______is a series of data in a row, column or combination of rows and column
Array
_______ performs calculations on a data in one or more arrays returning a single or multiple results. ________
- Array formula
- ctrl shift enter
How to Find and Correct errors in calculations
- # DIV/0!
- # NAME?
true or false: Adding limit to your worksheet allows you to better analyze your data.
true
_______ is the process of choosing a smaller part of your data set and using that subset for viewing or analysis.
Data filtering
_______ is the changing of data to make it easier to read or be more organized and to display information to users in a more meaningful way based on data formatting defined by a user.
Data manipulation
Define valid sets of values for
ranges of cells
- Sort worksheet data
- Sort data by using custom lists
- Organize data into levels
- Look up information in a worksheet
5.Link to data in other worksheets
and workbooks
