CHAPTER 5 Flashcards
Data types
numeric
- integer
- decimal
currency
text
date
Boolean
advantages of flat file database
all records are stored in one table
easier to understand
easier to sort and filter data
easier to set up
check to minimize errors
validation and verification
validation
make sure data entered is logic
prevents: illogical entries
does not prevent: incorrect logic entries
done by: computer
verification
make sure data entered is: identical to data source
prevents: copying
does not prevent: errors in data source
done by: user
verification checks
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
range check
description:
make sure numbers entered are within specific limits
examples:
numeric fields
data fields
in practical
between 0 and 100
length check
description: make sure the exact correct number of characters have been entered; not more and not less
examples: telephone no
candidate no
Centre no
format check
make sure letters,numbers,specific symbols are in their specified positions
example:
Centre number
look up check
make sure data entered is one of specified options
example:
gender M or F
presence check
make sure the field is not left blank
key fields
in practical:
NOT NULL
type/character check
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
check digit
certain calculation performed in the numbers of a barcode and the result must be equal to the check digit
example
barcode
formula vs function
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
naming cells
easily referring to cells
simplifies formulas
easily to refer to cells without using cell references
don’t have to set absolute cell manually
absolute cell reference $A$2
when replicated the cell reference will not change.
absolute file path
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
web development layers
content layer (htm) images,tables,text,hyperlinks
presentation layer colours,fonts,borders
behavior layer interaction of website
relative cell reference (A2)
when replicated the cell reference will change
relative file path
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
anchor
a position on the webpage that a hyperlink will point to
bookmark
saved shortcut to direct the user to certain website
hyperlink
a link from text or image to redirect the user to another position on the same page, another webpage, an email.
class
it is defined in a stylesheet using dot
it is used in adding or changing properties without having to create new style
head section of htm contains
page title
stylesheet link
default target frame
metadata
body section of htm
tables
images
hyperlinks
videos
text
attached stylesheets
-separate from the webpage; can be applied to multiple pages
-edited in one file
-placed in the head section of the webpage
-lower priority
gutter
extra margin on one side to allow for biding or stapling a book
inline styles
-within each web page
-edited by changing each webpage
-can be anywhere in the webpage higher priority
orphan
when the first line of ap paragraph is separated on the previous page
widow
when the last line of ap paragraph is separated on the next page
page break
when inserted the text after will be pushed to the next page
next page
when inserted the text is pushed to next page and diff formatting can be applied before and after the break
master slide
ensures consistency
saves time of repeating formats adjustments on diffrent slides
evaluate persentation postive points
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
richt text format (.rtf)
A file format used for text that contains formatting ; can contain tables,images,etc
can be opened in any word processor
text file (.txt)
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
comma separated values (.csv)
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
hypertext markup (.htm)
file containing design of the webpage created using hyper text markup language
can be opened by any web browser and on web-design software”’
cascading stylesheet (.css)
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
joint photographic expert group (.jpeg)
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
portable network graphics (.png)
image format that can be easily sent via email (48 bit)
can be opened in any image editing software
graphics interchange format (.gif)
file format moving images
can be opened in any document format reader device
portable document format (.pdf)
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
archive file formats (.zip) (.rar)
container that holds any type of data stored in compressed format
used to save storage in the computer and reduce attachment sizes on email
benefits of corporate house style
consistency
brand recognition
reduces time spent in formatting documents
reduce errors off typing
corporate house style
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
the design of any ICT product is affected by the audience targeted
different size
clear font color for title
text well distributed
contrasting colors for font and background colour
up-to date information
audience need if they are children
simple language
bright colors
cartoons
small amount of text
audience need if they are teenagers
compatibility with mobile devices
attractive colors
relaying on media rather than text
casual tone of speech
audience need if they are elderly
basic contrasting colors
large, bold text
not to much text
simple interface
access to help
audience need if they are adults
pastel colors
formal language
compatibility with mobile devices
