Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

Ict Igsce OL > CHAPTER 5 > Flashcards

CHAPTER 5 Flashcards

1
Q

Data types

A

numeric
- integer
- decimal
currency
text
date
Boolean

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

advantages of flat file database

A

all records are stored in one table
easier to understand
easier to sort and filter data
easier to set up

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q
A
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

check to minimize errors

A

validation and verification

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

validation

A

make sure data entered is logic
prevents: illogical entries
does not prevent: incorrect logic entries
done by: computer

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

verification

A

make sure data entered is: identical to data source
prevents: copying
does not prevent: errors in data source
done by: user

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

verification checks

A

double data entry: user enters data twice and computer compares the two entries to make sure they are identical

visual check: user visually compares data entered with data source to make sure they are identical

proof-reading is not verification check
reading the document after typing to check for speeling,grammar,punctuation mistakes

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

range check

A

description:
make sure numbers entered are within specific limits

examples:
numeric fields
data fields

in practical
between 0 and 100

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

length check

A

description: make sure the exact correct number of characters have been entered; not more and not less
examples: telephone no
candidate no
Centre no

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

format check

A

make sure letters,numbers,specific symbols are in their specified positions

example:
Centre number

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

look up check

A

make sure data entered is one of specified options

example:
gender M or F

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

presence check

A

make sure the field is not left blank

key fields
in practical:
NOT NULL

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

type/character check

A

type check allows only numbers to be entered character checks allows certain characters

example
price can only contain numbers
email address can only contain certain characters

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

check digit

A

certain calculation performed in the numbers of a barcode and the result must be equal to the check digit

example
barcode

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

formula vs function

A

formula:
can be simple calculations
can be easily typed by suer
can contain a function
function:
built into the software
have a pre-defined name

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

naming cells

A

easily referring to cells
simplifies formulas
easily to refer to cells without using cell references
don’t have to set absolute cell manually

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

absolute cell reference $A$2

A

when replicated the cell reference will not change.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q

absolute file path

A

displays file name and path means files are not saved in same folder
will only work on one computer as other computers will not have the same file path

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
18
Q

web development layers

A

content layer (htm) images,tables,text,hyperlinks
presentation layer colours,fonts,borders
behavior layer interaction of website

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
18
Q

relative cell reference (A2)

A

when replicated the cell reference will change

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
19
Q

relative file path

A

displays only file name
means all files are saved in same folder
files should be saved in one folder to be ready for publishing the website

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
20
Q

anchor

A

a position on the webpage that a hyperlink will point to

20
Q

bookmark

A

saved shortcut to direct the user to certain website

21
Q

hyperlink

A

a link from text or image to redirect the user to another position on the same page, another webpage, an email.

22
Q

class

A

it is defined in a stylesheet using dot
it is used in adding or changing properties without having to create new style

23
Q

head section of htm contains

A

page title
stylesheet link
default target frame
metadata

24
Q

body section of htm

A

tables
images
hyperlinks
videos
text

25
Q

attached stylesheets

A

-separate from the webpage; can be applied to multiple pages
-edited in one file
-placed in the head section of the webpage
-lower priority

26
Q

gutter

A

extra margin on one side to allow for biding or stapling a book

26
Q

inline styles

A

-within each web page
-edited by changing each webpage
-can be anywhere in the webpage higher priority

27
Q

orphan

A

when the first line of ap paragraph is separated on the previous page

28
Q

widow

A

when the last line of ap paragraph is separated on the next page

29
Q

page break

A

when inserted the text after will be pushed to the next page

30
Q

next page

A

when inserted the text is pushed to next page and diff formatting can be applied before and after the break

31
Q

master slide

A

ensures consistency
saves time of repeating formats adjustments on diffrent slides

32
Q

evaluate persentation postive points

A

font colour contrast with background colour
font size is big enough to be easily read
titles centre aligned and in larger font
text displayed as bullets not paragraphs
not too much text on one slide
presence of animation and transition makes presentation interactive
title font larger than bullet font
presence of title slides as first slide (title and subtitle)
consistency of slides

33
Q

richt text format (.rtf)

A

A file format used for text that contains formatting ; can contain tables,images,etc
can be opened in any word processor

34
Q

text file (.txt)

A

A file format used for plain text that contains no
formatting, no images or tables
can be imported into any text editor/word processing/DTP package

35
Q

comma separated values (.csv)

A

a file format used to hold tabular data e.g. spreadsheet or database table. It stores it as text file using commas or (semicolons) to seperate data items

can be imported into any spreadsheet or database

36
Q

hypertext markup (.htm)

A

file containing design of the webpage created using hyper text markup language

can be opened by any web browser and on web-design software”’

37
Q
A
38
Q

cascading stylesheet (.css)

A

contains style definitions (to define how to display HTML elements) can be attached to each webpage to avoid including style in HTML

can be opened in any text editor and on web-design software

39
Q

joint photographic expert group (.jpeg)

A

the most common image format used mostly in websites,as it loads quickly because of its low capacity.(24 bit; 8 bits per channel)

can be opened in any image editing software

40
Q

portable network graphics (.png)

A

image format that can be easily sent via email (48 bit)

can be opened in any image editing software

41
Q

graphics interchange format (.gif)

A

file format moving images

can be opened in any document format reader device

42
Q

portable document format (.pdf)

A

make it possible to display formatted text and graphics in the same layout on any device screen

can be opened in any document format reader on any device

43
Q

archive file formats (.zip) (.rar)

A

container that holds any type of data stored in compressed format

used to save storage in the computer and reduce attachment sizes on email

44
Q

benefits of corporate house style

A

consistency
brand recognition
reduces time spent in formatting documents
reduce errors off typing

45
Q

corporate house style

A

is way a company is presented to customers; including color scheme,font,logo,etc. these items are applied to all company’s documents,presentations,webpages,emails

46
Q

the design of any ICT product is affected by the audience targeted

A

different size
clear font color for title
text well distributed
contrasting colors for font and background colour
up-to date information

47
Q

audience need if they are children

A

simple language
bright colors
cartoons
small amount of text

48
Q

audience need if they are teenagers

A

compatibility with mobile devices
attractive colors
relaying on media rather than text
casual tone of speech

48
Q

audience need if they are elderly

A

basic contrasting colors
large, bold text
not to much text
simple interface
access to help

48
Q

audience need if they are adults

A

pastel colors
formal language
compatibility with mobile devices

Ict Igsce OL (5 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2024 Bold Learning Solutions. Terms and Conditions