Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
18 Cards in this Set
- Front
- Back
|
What is an example of manual validation when developing a spreadsheet solution? |
Proofreading data to look for errors |
|
|
What is an example of electronic validation when developing a spreadsheet solution? |
Using a validation rule (<100) |
|
|
What are four differences between Excel and Google Spreadsheets? |
- Excel costs money, Spreadsheets is free - Excel is installed on a user's computer, Spreadsheets is stored on a cloud - Excel saves files locally, Spreadsheets saves them on an online cloud - Google has motion charts, Excel doesn't |
|
|
What are two advantages of using Google Spreadsheets rather than Excel? |
- Excel is expensive, Google is free - Google has motion charts, Excel doesn't |
|
|
What are two disadvantages of using Google Spreadsheets rather than Excel? |
- Excel has more functions than Google - Google can be slow, dependent on internet access |
|
|
How would you go about comparing the percentage of females in employment and the percentage of males in employment for a range of countries over the last 50 years? |
- Download data from a reliable data source (Gapminder) - Paste the data into spreadsheet software (Google Spreadsheets) - Transpose the data: First column = country, second column = year, third column = male percentage, fourth column = female percentage - Select the data and insert a motion chart |
|
|
What five things need to go on a website storyboard? |
- Header - Navigation links - Indication of content (eg, description of issues) - Footer with date and author - Formatting labels (colour, font, size) |
|
|
Name two tests that you can perform on a website |
- Test that a certain hyperlink goes to a certain page - Test that an image loads |
|
|
What two things can be used to evaluate the effectiveness of a website? |
- Number of hits - Success of purpose (eg. increased awareness, increased responsibility) |
|
|
What are two reasons it is important to test programs before they go live? |
- It's easier to fix problems later on - The program won't work as expected |
|
|
What does a 'dim...decimal' statement do? |
Create a storage for location for values that contain decimal numbers |
|
|
What does an 'end' statement do? |
Stop the program |
|
|
What does the statement 'length = Val(TxtLength.Text) do? |
Converts an inputted text value into a number and stores it as a decimal |
|
|
What does the statement 'area = 6*length^2' do? |
Performs calculations |
|
|
What does an IF statement do? |
Performs specific functions if a certain condition is met, and other functions if not |
|
|
What does the statement 'LblAns.Text = area' do? |
Displays answers to calculations in a label |
|
|
What two things need to be at the start of an NS Diagram? |
- display title screen - declare variables |
|
|
What statement needs to be at the start of pseudocode? |
Dim ___ as ____ |
