ICT (Y11) REVISION
ICT (Y11) REVISION
Computer Environment
Define 'Computer Ethics'
What are Computer Ethics?
Computer ethics is the set of commonly agreed principles that govern the use of computers. Like ethics more generally, computer ethics is essentially a set of philosophical guidelines or moral standards that aim to influence behaviour and prevent harm. While computer ethics work to ward off technology misuse by computer scientists, programmers, and other decision-making individuals within the field, they can also help to steer social conduct and user interactions when using computer systems – particularly where the internet is concerned.
Computer Ethics Issues: common concerns and considerations
There are a number of ethical concerns that have arisen within computing and information technology (IT), particularly following the rise of the internet, social media, artificial intelligence and advanced machine learning algorithms.
Computer crime
Cybercrime is a threat that evolves as rapidly as new technology does. Through hacking, malware, viruses, worms, phishing, Trojan horses, and so on, cybercriminals and hackers can steal money and data, commit fraud, traffic in illegal content and intellectual property, and commit identity theft.
Privacy and security
Digital security, anonymity, information ethics, and information privacy online can be hugely important to people. However, threats abound, from companies secretly tracking – and selling – online activity, to individual people cyberbullying and doxing other people.
Intellectual property
Theft or the unauthorised distribution of digital content, copyrighted content, and intellectual property is an ongoing issue online, with everything from art and entertainment media to software and innovative products shared illegally online.
What is netiquette?
Netiquette is the correct way of conducting yourself while communicating online.
The word netiquette was derived by combining “net” and “etiquette.”
10 rules of netiquette
Rule 1: Remember the human
Rule 2: Adhere to the same standards of behaviour online that you follow in real life. Rule 3: Know where you are in cyberspace
Rule 4: Respect others’ time and bandwidth
Rule 5: Make yourself look good online
Rule 6: Share expert knowledge
Rule 7: Help keep flame wars under control
Rule 8: Respect one another's privacy
Rule 9: Don't abuse your power
Rule 10: Be forgiving of other people's mistakes
Activity
What is computer ethics?
What are the 3 main common issues of computer ethics?
Give at least 3 examples of computer crimes
Privacy and Security is a common issue in the computer environment. Briefly expand on this.
Define "netiquette"
Give at least 5 rules of netiquette
Microsoft Office
Microsoft Word
Word Processor
A word processor is an application that allows you to create a variety of documents, including letters, resumes, and more. An example is Microsft Word 2016, Word 2013 and Word 2010.
Word Interface
An interface is a program that allows a user to interact with computers in person or over a network.
Some features that you will see first in a Word interface are: the Ribbon, Quick Access Toolbar, and Backstage view, plus other features such as, Information Gap, Class discussion & Questioning
When you open Word for the first time, the Start Screen will appear. From here, you'll be able to create a new document, choose a template, and access your recently edited documents. From the Start Screen, locate and select Blank document to access the Word interface.
The main purpose of a word processor is to allow users to create, edit, format, and print documents:
Create: Word processors allow users to write and modify text.
Edit: Word processors allow users to edit text.
Format: Word processors allow users to format text, including adding images, tables, and other multimedia elements.
Print: Word processors allow users to print out their documents
Window features:
When you open a "Window" you will see some Window features such as Title Bar, Menu Bar, Standard Toolbar, Formatting Toolbar, Ruler, Task Pane, View Buttons, Status Bar, Word Wrapping, Spell Checker, Thesaurus, WYSIWYG, Font Type, Propositional and Fixed Spacing.
Activity
What is a Word Processor?
What is the main purpose of a Word processor?
Give two examples of Word processors
Define a Word Interface.
What are some features in an 'interface'?
What are some features you will see when you open "Windows"?
Create a Table for the features of a 'Word'interface' (5) and 'Windows' (,15) and describe their functions
Microsoft Excel
What is a Spreadsheet?
Also known as a 'Worksheet;' is a file made of rows and columns that help sort, organize, and arrange data efficiently, and calculate numerical data.
Example: Some features in the MS Excel include: the "Quick Access Toolbar", that you'll see on the "Ribbon". The Ribbon is divided into "Tabs". The 'Tabs' are also known as "Menus". The 'Tabs' include: File, Home, Insert, Page Layout, Formulas, Data, Review, View and Developer.
Activity: Complete the labels of the MS Excel 2016 Spreadsheet below.
What are 'Built-in functions' and How to use them
Activity
Give an example of how to use the "SUM" functiom.
Give the description of the "AVERAGE" function
The formula =Max(D2:D21) is the function of?
Complete the Table below
Types of Charts and Graphs in MS Excel
Activity: Write the correct name of the following charts and graphs
Microsoft PowerPoint
PowerPoint is a presentation program that allows you to create dynamic slide presentations. These presentations can include animation, narration, images, videos, and much more.
PowerPoint environment, include the Ribbon, Quick Access Toolbar, and Backstage view.
The PowerPoint interface
When you open PowerPoint for the first time, the Start Screen will appear. From here, you'll be able to create a new presentation, choose a template, and access your recently edited presentations. From the Start Screen, locate and select Blank Presentation to access the PowerPoint interface.
Microsoft Access