Revision Flashcards

1
Q

Describe 2 conventions we follow when setting out a spreadsheet.

A

Text left aligned
Numbers right aligned
Totals double underlined
3 Tier Heading

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

What are possible benefits of following appropriate conventions on webpage?

A

Usability

Users returning to the page

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

What are the disadvantages of not following conventions?

A

Reduced usability

Harder to navigate

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

Describe 3 benefits of using CSS styling for webpages.

A

Less clutter on the webpages
Can change a style across multiple pages by changing once in a style sheet
Easier page layout

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

What are the 2 purposes of creating a site in Dreamweaver?

A

Enables use of created site templates

Can make bulk changes to multiple pages

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

“Validation does not ensure accurate data”. Explain this.

A

Validation looks to ensure appropriate data in format and range, but cannot ensure accuracy

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

Give 3 ways we could validate data using a web form.

A

Dropdown combo box
checkbox
radio button

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

What could be 2 organizational goals for a company that sells cars?

A

Increase sales value by 20%

Increase number of customers by 10%

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

Describe 4 features of good webpages.

A
Fast loading 
Consistent page layout
Readable fonts
Good whitespace
Easy to navigate
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

What are the benefits of fast loading and consistent page layouts

A

Better user experience
Return visits
Increased interactions from users

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

Give 2 formats which might be used in a webpage.

A

Left-aligned text
Coloured background with colored text
Results in the form of a graph or sales formatted as a table

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

Identify and justify the data type used to store phone numbers in a database

A

Text – leading zeros are removed if numeric is used

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

Write the steps to follow to test that a spreadsheet is carrying out calculation of averages correctly.

A

Enter some simple data

Use a calculator to double check each of the calculations and averages produced

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

When testing a query 500 < cost < 600 the most appropriate test data would be

A

500 555 600

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

Validation is best described as

A

ensuring appropriateness.

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

When presenting information, conventions are used to?

A

Ensure it is conveyed in a consistent manner.

17
Q

List 3 data types

A

Boolean, numeric, text

18
Q

Explain the difference between an ordinary cell reference and an absolute cell reference.

A

Absolute does not change when copied relative uses cells relative to any new position when copied