Flashcards
Programming Techniques 2.2
Cards in this deck (36)
- 1Which best describes a sequence in an algorithm?The order in which tasks are completed
- 2Which best describes iteration in an algorithm?Repeating a task over and over
- 3Which best describes selection in an algorithm?Making a decision
- 4How would you best describe Point 1?Sequence
- 5How would you best describe Point 2?Sequence
- 6How would you best describe Point 3?Selection and iteration
- 7How would you best describe Point 4?Selection and iteration
- 8How would you best describe Point 5?Sequence
- 9What is a variable?A value that may change
- 10What is a constant?A value that does not change
- 11What would best describe lengthInCentimeters in the following example? lengthInMilimeters=10 lengthInCentimeters = lengthInMilimeters/10Constant
- 12What would best describe lengthInCentimeters in the following example? lengthInMilimeters=10 lengthInCentimeters = input("Please enter the length in centimeters ")Variable
- 13Correct the code so that it can read the file: file=open("cars.csv","read")file=open("cars.csv","r")
- 14Correct the code so that it can overwrite a file: writefile = open("filename.csv","write")writefile = open("filename.csv","w")
- 15Correct the code so that it can write to a file, without overwriting the original file: writefile = open("filename.csv","write")writefile = open("filename.csv","a")
- 16What is a database?An organised storage of data
- 17What is a record in a database?Everything about one person or thing
- 18What is a field in a database?One piece of information e.g. First name
- 19What does SQL stand for?Structured Query Language
- 20What is SQL?A language used to manipulate or search a database
- 21What would the following code do? SELECT * FROM CustomersFind all records and fields from the Customers table in a database
- 22Write the 2nd line of code to show all customers above 20 years (age) only: SELECT * FROM Customerswhere age>20
- 23What is an array?Data structures that contain grouped elements of usually the same data type
- 24Name the datatype: number=int(3)integer
- 25Name the datatype (not float): number=float(3.2)real
- 26Name the datatype: colour="Blue"string
- 27Name the datatype: answer=TrueBoolean
- 28Why is an array useful when programming?It can be used to store multiple values to one variable
- 29Why did Heath decide to use an array to store the data?Reduces need for multiple variables
- 30Identify a data type that could be used to store the number of minutes in this arrayInteger
- 31Write the code to output the number of minutes student 0 played computer games on Wednesdayprint(hoursPlayed[0,2])
- 32State the output if Heath runs the code: print (hoursPlayed[2,1])0
- 33State the output if Heath runs the code: print (hoursPlayed[3,1] + hoursPlayed[3,2])80
- 34Identify two variables used in the program (comma and space between the variables e.g. hello, world)radius, area
- 35What data type would 'the amount paid' be?Real
- 36What data type would 'The customer's card number' be?String
Information
- Description
- GCSE Computing Flashcards on Programming Techniques 2.2, created by Grace Horton on 16/03/2018.
- Created by
- Grace Horton
- Views
- 0
- Rating