Brainscape's Knowledge GenomeTM

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


See full index

IT X > Unit 1: Tools & Applications > Flashcards

Unit 1: Tools & Applications Flashcards

1
Q

What is a search engine?

Example?

A

Allows a user to enter keywords/phrases to locate relevant phrases. Includes advanced search facility.
Google.

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

Give 4 examples of searching techniques.

A

Put keywords in order of importance, Use + and - (- not included), use wildcards (* e.g. colo*r for color or colour) and use quotation marks if it must contain the phrase.

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

What is a URL?

What is it made up of?

A

Uniform Resource Locator

Protocol, domain name, top level domain (TLD) + country code.

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

Example:

  • Protocol
  • Domain Name
  • TLD
  • Country Code
A

http
ccea
.org
.uk

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

What are browsers?

Example?

A

Software programs that allow you to access information on websites.
Microsoft Internet Explorer

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

Features of web browsers? (8)

A

Back + forward buttons - Visit previous/next page.
Refresh button - Update downloaded webpage taking account of any changes.
Home Button - Return to home page.
Search Button - Search webpage.
Favorites - Store addresses of frequent websites.
History - See past websites accessed (to a date)
Print - Print current webpage.
Edit - Launches common piece of software (wordprocessor) to edit contents of information.

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

Features of an email client? (12)

A

Inbox - Displays emails sent (arranged by date)
Date + Time - View emails by date or time.
To/Cc/Bcc - Enter relevant email addresses.
Subject - Enter title for message.
Textbox - Enter message.
Address Book - Store contacts’ email addresses.
Signature - Save personal details 4 automatic inclusion
Distribution Lists - Group Emails
Attachment - Send copies of files.
Send/Reply/Forward/Delete - Send email/
Message Options - Priority, track email, date + time for delivery.
Folders

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

What is a VLE?
What are the main advantages? (4)
Example?

A

Software tool that can be used in school for online courses.
Central shared storage for resources, access to multimedia for different learning styles, 24/7 access for beyond the classroom learning + personalised learning.
LearningNI

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

What can a student access and do on a VLE? (8)

A

Access current courses, electronic resources, create a personal web page, receive announcements, access emails, upload files, access personal timetable + participate in forums.

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

What can a teacher do and access on a VLE? (3)

A

Administration tools, reporting on pupil progress + monitor pupil progress.

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

What is a presentation package?

Other name?

A

Combines text, graphics, sound + video.

Multimedia.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q 
In a presentation package:
How is text formatted?
What does animation allow users to do?
What do templates help with?
What can headers + footers include?
What do slide notes enable?
A

Font options
Add moving images, add a path + effects for objects entering + leaving a slide.
Develop presentations more quickly.
Date + slide number
Include details that can be read/referred to when presenting info.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q 
In a presentation package:
What do backgrounds and themes do?
What do navigation buttons + hyperlinks allow?
What do master slides contain?
How can you print slides?
What does a slide transition do?
A

Change text colours + background graphics.
Select different pathways through presentation.
Items that appear on every page.
Variety of layouts. Handout - three slides per pages with lines beside for writing.
How slide appears on screen. (Sound, speed, timings + advance slide)

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

What is a linked object,

What is an embedded object?

A

Not part of presentation. Must be copied with file.

Become part of presentation once saved. Don’t need to be copied.

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

What should you do to plan a presentation? (4)

A

Define purpose of presentation.
Identity target audiences + special requirements.
Produce storyboard.
Collect digital assets and other files for presentation.

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

What should you test a presentation for? (7)

A 
Ensure no grammar/spelling mistakes.
Ensure all pictures present.
Ensure all hyperlinks + buttons work.
Ensure embedded + linked files work.
Ensure special effects work.
Rehearse timings set.
Check all slides are present.
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q

How should you evaluate a presentation? (6)

A

Comment on ease of navigation.
Ensure suitable for target audience.
Consider how well it communicates the message.
Consider how well it uses multimedia assets.
Identify strengths + weaknesses.
Identify areas of improvement.

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

What is an information handling package?

A

Allows users to collect + structure data which is structures into records + fields.

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

What are 4 data types in a database?

A

Numeric
Text
Date
Boolean (yes and no)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
20
Q 
What are tables made up of?
What are records separated into?
What is a record?
What is a key field? Also known as?
What are 2 ways of formatting dates?
What is an input mask?
A

Records
Set of fields
A value that uniquely identifies a record in a table.
A primary key.
Medium Date/Short Date -> 24-May-11 OR 24/05/11
Defines format of data being entered. E.g. Postcode

21
Q

What does validation do?

A

Ensures data is present, in the correct range and format.

22
Q

What are 5 validation checks?

A

Presence, length, type, range + format.

23
Q

What is a relationship?
What is the advantage of them?
What are the 3 types?

A

A link between 1 tables using a common field.
Reduces data stored + makes searching + sorting easier.
One-to-one, one-to-many + many-to-many.

24
Q

What is a wizard?

A

Software that helps a user to complete a task step by step.

25
Q

What is a mail merge?

A

Users create standard documents and merge records from a database onto the documents.

26
Q

How would you use mail merge to create a customised letter and send it to many people?

A

Create standard letter with merge fields, select data source, select merge fields + include on letter, merge data from source onto letter + print.

27
Q

What does a query facility allow?

A

Users to search or select records from database which fit certain criteria.

28
Q

How do you carry out a query?

A

Select a table, select fields from table, enter criteria, run query + view results.

29
Q 
What do each of these symbols mean in a query? 
=
<
<=
>
>=
A 
Equal to
Less than
Less than or equal to
Greater than
Greater than or equal to
30
Q

How can criteria be combined in a query?

3 examples?

A

Logical operators

AND, OR, NOT.

31
Q

Logical operators: What do these mean?

  • AND
  • OR
  • NOT
A

Must fulfil both criteria (Male AND over 40)
Must fulfil at least 1 criteria (Female OR over 30)
Mustn’t fulfil the criteria (Child NOT male)

32
Q

Can a query be carried out on data in 2 tables?

A

Yes as

Yes as long as the tables are related.

33
Q

How can reports be created?
What is a report designed for?
Can it be viewed on screen?
Can data in reports be grouped and sorted?

A

Using data in tables or results of a query.
Designed for printing.
Can be viewed on screen.
Yes

34
Q

How can users edit data in a database?
Can a user import data from other sources? If so, how?
How could you plan to create a database?

A

Table view in database or data capture form.
Yes, through a wizard from a spreadsheet or CSV file.
List user requirements in input, processing + output (reports, queries + forms also) identify tasks user will perform (adding, deleting, editing records) identify data which needs to be collected.

35
Q

How could you appropriately structure data in a database?

A

Organise data into fields, records + tables, select suitable data types, identify validation and formatting requirements, identify key field, identify relationships between tables, identify queries for output + design data capture forms + reports.

36
Q

How might you test a database solution?

A

Use user requirements from planning to ensure everything has been completed, test data capture forms to ensure data is valid and forms are user friendly, run queries to ensure it is accurate + efficient + check reports are accurate + in suitable format.

37
Q

How could you evaluate a database solution?

A

Assess how it meets user requirements, identify strengths + weaknesses (user friendly data capture forms + reports, effective queries) + identify areas of improvement.

38
Q

What are the common features of a spreadsheet?

A

Perform calculations automatically, allow results to be displayed in tabular or graphic format, consists of tables divided into rows + columns to produce cells + consist of a number of worksheets.

39
Q

What are the different data formats in a spreadsheet? (7)

How can cells be further formatted?

A

Number, currency, general, short date, long date, time, percentage.
Specifying aspects e.g. decimal places, font size + style, data alignment, add borders + shading.

40
Q

What does conditional formatting allow?

A

Apply cell shading or font colour to a cell if a specified condition is true.

41
Q

What does data validation allow?

  • Input Message
  • Error Message
A

Control the values which are input into a given cell.
Change to guide user.
Stop, warning or information.

42
Q

What are the arithmetic functions in a spreadsheet? (4)

A

SUM (add values in cells)
AVERAGE (calculate average of cells)
MAX (find max value of cells)
MIN (fin min value of cells)`

43
Q

What are 2 other functions a spreadsheet can perform?

A 
IF function (sets cell value depending on result of a condition) 
Fill command (replicate formula from one cell to other cells)
44
Q

Give an example of an IF equation?

A

=IF(C2=”Yes”,1,2

45
Q

How do you create an absolute cell reference?

Why?

A

I5 = $I$5

To ensure when copying the formula to other cells, it will stay the same.

46
Q

What is a lookup table?
With what function can it be used?
What does it do?

A

Provides information to be used elsewhere in the spreadsheet.
VLOOKUP function
Takes value in particular cell + finds it in 1st column of lookup table, then returns the value in the next value.

47
Q

In a spreadsheet, what does the wizard allow you do in terms of a graph?

A

Create a graph, select data value range, labels for each axis, title for graph + colour.

48
Q

How might you test a spreadsheet?

A

Meets user requirements, formulas work, calculations are automatic when a cell value changes, data is correctly formatted, data validation rules work, graphs are designed accurately + links work.

49
Q

How could you evaluate a spreadsheet?

A

Appearance suitable for target audience, labels + text correctly spelt, use of font styles + formatting, use of data formats + text alignment, use of functions + formulas, strengths + weaknesses, presentation, areas of improvement.

IT X (13 decks)

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