Highlighted from revison

Question 1

Databases vs Spreadsheets

Answer 1

Databases can store and handle very large amounts of data, ideal for companies and businesses. E.g. Microsoft access

Spreadsheets are for storing a moderate/small amount of data, good for individual or small team use, good for mathematical calculations. E.g. Microsoft Excel

Question 2

Purpose of a design tool

Answer 2

Design tools are used to represent the functionality and appearance of your solution.

Design tools help show what you solution will do and look like.

Question 3

Appearance design tools

Answer 3

Appearance design tools improve the appearance (looks) of the tool

E.g. Mock-ups, layout designs

Question 4

Functionally design tools

Answer 4

Functionally design tools change how a tool may work

Question 5

IPO charts

Answer 5

Stands for Input-processing-output. Shows what data needs to be input, how that data is changed (mathematical or sorting), output to show the user.

Question 6

Define Format

Answer 6

Formats are related to the font type and size selected, background colour used and any
other change of appearance

Question 7

Define convention

Answer 7

Conventions are general rules that are followed when using a particular format.

Question 8

Format vs convention

Answer 8

Formats are factors that govern appearance (font size, colour).

Conventions are general rules or standards about what should be included and where they appear

For example, a line chart is the format and that x and y axes should be labelled is the
convention.

Question 9

scope creep

Answer 9

When the client adds more functional or non-functional requirements to the design before the solution has been completed.

Question 10

solution constraints

Answer 10

Solution constraints are the limitations or restrictions that affect how a solution can be designed, developed, and implemented.
-Technical
-Economic (cost, deadline)
-Usability (friendly to users)
-Social
-Legal (laws)

Question 11

Data types

Answer 11

Different types of data displayed
-Characters e.g. (“i”)
-String (str) e.g. (“apple”)
-Integer e.g. (“137”)
-Floating point e.g. (“1.232”)
-Boolean e.g. (‘false”, “true”) OR (“1”,0”)
-Dictionary e.g. [“socks”: 30, “tables” :34, “swing sets”:12]
-Array (list with the same types of data. e.g. [1.232, 22.23, 3.34]