Question 1

Which of the following methods can be used to convert a string to an integer in Python?

Accepted Answer

int()

Answer

str()

Answer

convert()

Answer

float()

Question 2

Which of the following is a correct way to define a function in Python?

Accepted Answer

def my_function():

Answer

function my function():

Answer

def my_function[]:

Answer

my_function() def:

Question 3

What will be the result of the expression 'Hello' + 'World' in Python?

Accepted Answer

HelloWorld

Answer

Hello World!

Answer

Hello+World

Answer

Hello World

Question 4

What keyword is used to create a loop in Python?

Accepted Answer

for

Answer

repeat

Answer

loop

Answer

iterate

Question 5

In Python, which built-in function can be used to read a line from standard input?

Accepted Answer

input()

Answer

scan()

Answer

getLine()

Answer

readline()

Question 6

Which of the following methods can be used to add an item to a list in Python?

Accepted Answer

append()

Answer

add()

Answer

push()

Answer

insertItem()

Question 7

In Python, what will the expression 3*1** 3 evaluate to?

Accepted Answer

3

Answer

9

Answer

1

Answer

27

Question 8

Which data structure in Python allows you to store key-value pairs?

Accepted Answer

Dictionary

Answer

Set

Answer

Tuple

Answer

List

Question 9

Which of the following data structures is ordered and mutable in Python?

Accepted Answer

List

Answer

Tuple

Answer

Set

Answer

Dictionary

Question 10

What will be the output of the following code: 'print(5 > 3 and 2 < 4)'?

Accepted Answer

True

Answer

False

Answer

Error

Answer

None

Question 11

In Python, which logical operator returns True if at least one of the conditions is True?

Accepted Answer

or

Answer

and

Answer

not

Answer

xor

Question 12

What is the purpose of the 'elif' statement in Python decision structures?

Accepted Answer

To check multiple conditions

Answer

To terminate a loop

Answer

To declare a variable

Answer

To define a function

Question 13

What is the function of the 'IF' statement in a spreadsheet?

Accepted Answer

To make decisions based on conditions

Answer

To format cells

Answer

To sum values

Answer

To count the number of cells

Question 14

Which pedagogical approach emphasizes the use of real-world problems in teaching Computer Science?

Accepted Answer

Project-Based Learning

Answer

Direct Instruction

Answer

Behaviorism

Answer

Constructivism

Question 15

What is the primary benefit of integrating collaborative learning in Computer Science education?

Accepted Answer

Enhances Critical Thinking

Answer

Simplifies Complex Concepts

Answer

Reduces the Need for Resources

Answer

Increases Individual Competition

Question 16

In the context of TPACK, what does the 'P' stand for, which emphasizes the importance of combining content knowledge with pedagogical knowledge?

Accepted Answer

Pedagogical

Answer

Philosophical

Answer

Physical

Answer

Practical

Question 17

Which of the following is a primary benefit of pair programming in a computer science classroom?

Accepted Answer

Enhanced collaborative problem-solving skills

Answer

Faster completion of tasks without discussion

Answer

Increased individual competition

Answer

Reduction in coding errors

Question 18

Which of the following best describes the "Technological Knowledge" component of TPACK?

Accepted Answer

Understanding of how to use technology tools effectively in teaching

Answer

Familiarity with historical computing devices

Answer

Awareness of computer hardware specifications

Answer

Knowledge of software development methodologies

Question 19

What is a key characteristic of computational thinking that distinguishes it from traditional problem-solving methods?

Accepted Answer

Application of logical reasoning and abstraction to solve complex problems

Answer

Reliance on individual effort without collaboration

Answer

Emphasis on the use of digital tools exclusively

Answer

Focus on rote memorization of algorithms

Question 20

What is the primary purpose of a formative assessment in a computer science course?

Accepted Answer

To provide ongoing feedback to improve student learning

Answer

To evaluate student learning at the end of an instructional unit

Answer

To certify competency in programming languages

Answer

To rank students against each other

Question 21

In the context of computer science education, what is the main advantage of using project-based assessments?

Accepted Answer

They allow students to demonstrate practical application of skills

Answer

They require less time than quizzes and exams

Answer

They focus solely on theoretical knowledge

Answer

They are easier to grade than traditional tests

Question 22

What type of assessment would best help identify a student's prior knowledge in algorithms before a new course begins?

Accepted Answer

Diagnostic assessment

Answer

Formative assessment

Answer

Summative assessment

Answer

Portfolio assessment

Question 23

In a computer science classroom, which strategy is most effective for managing group projects to ensure equitable participation among students?

Accepted Answer

Assign specific roles to each group member based on their strengths

Answer

Rotate group members every week without any structure

Answer

Let students work independently without group interaction

Answer

Allow students to choose their own roles randomly

Question 24

Which classroom management technique is most effective in maintaining student focus during a lengthy programming lecture?

Accepted Answer

Incorporate interactive elements such as live coding demonstrations

Answer

Allow students to use their phones throughout the lecture

Answer

Skip breaks and continue for the full duration without pause

Answer

Read slides without engaging the students

Question 25

How can a teacher effectively manage time during a complex computer science project?

Accepted Answer

Set clear deadlines and check-in points throughout the project

Answer

Allow students to set their own deadlines without guidance

Answer

Only review the project at the end without interim assessments

Answer

Provide no structure, allowing students to work at their own pace indefinitely

Question 26

What is the most effective way to create a collaborative environment in a computer science classroom?

Accepted Answer

Encourage peer-to-peer teaching and collaborative problem-solving

Answer

Discourage sharing of ideas to maintain individual focus

Answer

Promote competition between students for grades

Answer

Limit group work to only a few students at a time

Question 27

In a spreadsheet, what is the purpose of using 'conditional formatting'?

Accepted Answer

To apply formatting based on cell values

Answer

To create formulas

Answer

To sort data alphabetically

Answer

To change the layout of the spreadsheet

Question 28

What would be the result of using the VLOOKUP function incorrectly in a spreadsheet?

Accepted Answer

It will display an error message

Answer

It will automatically correct the lookup value

Answer

It will provide a random value

Answer

It will return the correct value

Question 29

Which feature in a spreadsheet allows you to visually represent data?

Accepted Answer

Charts

Answer

Formulas

Answer

Sorting

Answer

Conditional Formatting

Question 30

In a spreadsheet, what does 'sorting' data accomplish?

Accepted Answer

It organizes data in a specific order

Answer

It formats the cells

Answer

It changes the data values

Answer

It removes duplicates

Question 31

In a spreadsheet, which function would you use to calculate the average of a range of cells from A1 to A10?

Accepted Answer

=AVERAGE(A1:A10)

Answer

=SUM(A1:A10)/10

Answer

=AVG(A1:A10)

Answer

=MEAN(A1:A10)

Question 32

What does the formula =COUNTIF(B1:B10, '>5') do in a spreadsheet?

Accepted Answer

Counts the number of cells greater than 5

Answer

Counts all cells in the range

Answer

Sums the cells greater than 5

Answer

Finds the maximum value in the range

Question 33

Which of the following functions would you use to find the highest value in a dataset located in cells B1 through B20?

Accepted Answer

=MAX(B1:B20)

Answer

=TOP(B1:B20)

Answer

=HIGHEST(B1:B20)

Answer

=LARGEST(B1:B20)

Question 34

What is the primary purpose of normalization in database design?

Accepted Answer

To eliminate data redundancy

Answer

To simplify the database schema

Answer

To improve query performance

Answer

To increase data redundancy

Question 35

In SQL, which command is used to remove a table from a database?

Accepted Answer

DROP

Answer

TRUNCATE

Answer

REMOVE

Answer

DELETE

Question 36

Which of the following is a characteristic of a primary key in a relational database?

Accepted Answer

It must be unique for each record

Answer

It can contain duplicate values

Answer

It can be null

Answer

It can be a composite of multiple columns

Question 37

Which of the following SQL clauses is used to filter records in a query?

Accepted Answer

WHERE

Answer

GROUP BY

Answer

HAVING

Answer

ORDER BY

Question 38

In a relational database, what does the term 'foreign key' refer to?

Accepted Answer

A key that uniquely identifies a record in another table

Answer

A key that is used to index data in a database

Answer

A key that defines the primary key of the same table

Answer

A key used for encryption purposes

Question 39

What is the main advantage of using indexes in databases?

Accepted Answer

To speed up data retrieval operations

Answer

To increase the complexity of queries

Answer

To ensure data is stored in a specific order

Answer

To reduce the amount of data stored

Question 40

Which of the following is NOT a type of database relationship?

Accepted Answer

Few-to-Many

Answer

One-to-Many

Answer

One-to-One

Answer

Many-to-Many

Question 41

Who is considered the 'father of the computer' for his design of the Analytical Engine?

Accepted Answer

Charles Babbage

Answer

Alan Turing

Answer

John von Neumann

Answer

Ada Lovelace

Question 42

What was the name of the first electronic general-purpose computer?

Accepted Answer

ENIAC

Answer

Colossus

Answer

UNIVAC

Answer

IBM 701

Question 43

Which programming language was developed in the early 1970s for system programming?

Accepted Answer

C

Answer

Fortran

Answer

Python

Answer

Java

Question 44

Which of the following was a significant development in the history of personal computing in 1970s?

Accepted Answer

The launch of the Apple II

Answer

The introduction of the IBM 360

Answer

The release of Windows 3.1

Answer

The creation of the first mainframe

Question 45

Who is considered the first computer programmer?

Accepted Answer

Ada Lovelace

Answer

John von Neumann

Answer

Alan Turing

Answer

Grace Hopper

Question 46

Which programming language, developed in the 1950s, is known for its use in business and administrative systems?

Accepted Answer

COBOL

Answer

Python

Answer

Java

Answer

C++

Question 47

What major invention is Tim Berners-Lee credited with in 1989?

Accepted Answer

The World Wide Web

Answer

COBOL programming language

Answer

Artificial Intelligence

Answer

The first computer

Question 48

Which mathematician is known for the Turing Test, a criterion for determining if a machine exhibits intelligent behavior?

Accepted Answer

Alan Turing

Answer

Ada Lovelace

Answer

Blaise Pascal

Answer

John von Neumann

Question 49

What is the primary function of the CPU in a computer system?

Accepted Answer

To process instructions and manage operations

Answer

To provide power to the system

Answer

To store data permanently

Answer

To manage input and output devices

Question 50

Which component is responsible for temporarily storing data that is being processed by the CPU?

Accepted Answer

Random Access Memory

Answer

Power Supply Unit

Answer

Motherboard

Answer

Hard Disk Drive

Question 51

Which statement best describes the role of computational thinking in everyday life?

Accepted Answer

It helps in making informed decisions and solving problems

Answer

It has no practical applications outside of computer science

Answer

It is limited to mathematical calculations

Answer

It is only useful for computer scientists

Question 52

What is the purpose of project-based learning in programming education?

Accepted Answer

Providing real-world context for programming concepts

Answer

Encouraging auto memorization

Answer

Focusing on theoretical concepts

Answer

Minimizing student engagement

Question 53

What is the significance of engineering principles in STEM education?

Accepted Answer

Providing opportunities for innovation and creativity

Answer

Ignoring practical applications of knowledge

Answer

Focusing solely on theoretical learning

Answer

Avoiding collaboration among students

Question 54

Which assessment evaluates students' understanding at the end of a unit?

Accepted Answer

Summative assessment

Answer

Continuous assessment

Answer

Diagnostic assessment

Answer

Formative assessment

Question 55

How does STEM education promote interdisciplinary learning?

Accepted Answer

By integrating concepts from different disciplines to solve complex problems

Answer

By focusing solely on memorization of facts

Answer

By avoiding hands-on activities

Answer

By isolating science, technology, engineering, and mathematics subjects

Question 56

What are the roles in pair programming?

Accepted Answer

Driver and navigator

Answer

Coder and debugger

Answer

Leader and follower

Answer

Instructor and student

Question 57

Which is an example of educational software used for collaborative learning?

Accepted Answer

Social media platforms

Answer

Email clients

Answer

Educational games

Answer

Word processing software

Question 58

Which step in computational thinking involves developing a step-by-step solution to a problem?

Accepted Answer

Algorithms

Answer

Abstraction

Answer

Evaluation

Answer

Decomposition

Question 59

What is the purpose of gamification techniques in programming education?

Accepted Answer

Increasing student motivation and engagement

Answer

Avoiding hands-on activities

Answer

Promoting competition among students

Answer

Making learning more challenging

Question 60

What is the purpose of educational software in the TPACK framework?

Accepted Answer

Providing resources for teaching and learning

Answer

Avoiding integration with existing teaching practices

Answer

Enhancing teachers' technological skills

Answer

Ignoring students' individual learning needs

Question 61

How does STEM education foster problem-solving skills?

Accepted Answer

By presenting students with real-world challenges to solve

Answer

By discouraging critical thinking

Answer

By avoiding collaboration among students

Answer

By providing step-by-step solutions to problems

Question 62

How does peer assessment contribute to learning?

Accepted Answer

By promoting self-reflection and critical evaluation

Answer

By discouraging collaboration among students

Answer

By focusing solely on individual performance

Answer

By providing direct answers to all student queries

Question 63

How does computational thinking contribute to critical thinking skills?

Accepted Answer

By encouraging logical reasoning and analysis

Answer

By limiting exposure to diverse perspectives

Answer

By avoiding creative thinking processes

Answer

By discouraging systematic problem-solving

Question 64

Which classroom management technique involves moving around the classroom?

Accepted Answer

Using proximity control

Answer

Positive reinforcement

Answer

Providing choices

Answer

Establishing routines

Related quizzes

Related quizzes