Communications Software Flashcards
What is a search engine
A search engine allows a user to enter keywords or phrases to locate relevant websites
What does URL stand for
Uniform Resource Locator
Http =
Protocol
Www. =
World Wide Web
Ccea =
Domain name
/ICT
Folder
Org
TLD
.uk
Country code
What does TLD stand for
Top level Domain
Four main features of Email software
- Inbox
- Date and Time
- The Subject box
- The Address Book
What does Cc stand for
Carbon copy
What does Bcc stand for
Blind carbon copy
What does VLE stand for
Virtual Learning Environment
3 advantages of VLE
- Shared resources for teaching and learning
- Access to multimedia
- An organises central storage method
Services available to pupils on VLE
- Ability to upload files
- Access to a personal timetable
- Participation in online discussion forms
Services for teachers on VLE
- Tools for administration
- Reporting on pupil progress
- Tracking tools that allow teachers to monitor work
Test you should conduct on a presentation
- To ensure that there are no grammar or spelling mistakes
- To ensure that all pictures are present
- To ensure that all hyperlinks and buttons link to the correct slides
Define Query
A query facility allows users to search or select r cords from the database which fit certain criteria
What does CSV stand for
Comma-separated variable
4 features of a spreadsheet
- They perform calculations
- They allow results to be displayed in tabular or graphical format
- They consist of a table divided into rows and columns to produce cells
- They consist a number of worksheets
Conditional formatting
Conditional formatting allows you to apply cell shading or front colour to a cell if a specified is condition is true
Definition + example of SUM function
The SUM function calculates the total of a Group of selected cl, values
E.g =SUM(C5:H5)
Average function
the average function calculates the average of a group of selected cell values
E.g =AVERGAE(C5:C16)
MAX function
The max function finds the largest value stored in group of cells
E.g =MAX(15:16)
IF function
The IF function sets the cell value depending on the result of examining a condition
E.g teachers wanted to give a score over ‘95’ “excellent” and the rest “well done”
If Grand total > THEN ‘Excellent’ ELSE ‘Well done’
Define Absolute Cell Reference
A cell reference that does not change when copied and will automatically update relevant formula to the new row or column
E,g $F$3
Spreadsheet tests
- It meets the user requirements
- The formulas Work
- recalculation are automatic
