Popular languages and their uses in Intro to Computing - Cheat Sheet & Quick Revision

Recall & Review

beginner

What is Python commonly used for?

Python is widely used for web development, data analysis, artificial intelligence, scientific computing, and automation because of its simple syntax and powerful libraries.

beginner

Which language is best known for building interactive web pages?

JavaScript is best known for creating interactive and dynamic web pages. It runs in web browsers and allows websites to respond to user actions.

beginner

What is Java mainly used for?

Java is mainly used for building large-scale enterprise applications, Android apps, and server-side software because of its portability and robustness.

beginner

Why is SQL important in computing?

SQL (Structured Query Language) is important because it is used to manage and query databases, helping to store, retrieve, and manipulate data efficiently.

beginner

What is HTML used for in web development?

HTML (HyperText Markup Language) is used to create the structure and content of web pages, like headings, paragraphs, images, and links.

Which language is best for data analysis and AI?

A SQL

B JavaScript

C HTML

D Python

Python has many libraries like pandas and TensorFlow that make it ideal for data analysis and AI.

What language runs directly in web browsers to make pages interactive?

A Java

B JavaScript

C Python

D SQL

JavaScript runs in browsers and allows web pages to respond to user actions.

Which language is used to structure content on web pages?

A SQL

B JavaScript

C HTML

D Python

HTML defines the structure and content of web pages.

Which language is commonly used for Android app development?

A Java

B HTML

C SQL

D JavaScript

Java is widely used to build Android applications.

What is SQL mainly used for?

A Managing and querying databases

B Writing software for mobile apps

C Creating web page layouts

D Making web pages interactive

SQL is the language used to manage and query databases.

Explain the main uses of Python, JavaScript, and Java in simple terms.

Think about what each language is famous for in everyday technology.

Describe how HTML and SQL differ in their roles in computing.

One builds what you see on websites, the other handles data behind the scenes.

Practice

1. Which programming language is best known for web page structure and content?

easy

A. HTML

B. Python

C. Java

D. C++

Solution

1. Step 1: Understand the role of HTML

   HTML is used to create the structure and content of web pages, like the skeleton of a building.

2. Step 2: Compare with other languages

   Python is for general programming, Java for apps, C++ for system software, but none create web page structure.

3. Final Answer:

   HTML -> Option A

4. Quick Check:

   Web page structure = HTML [OK]

Hint: HTML is the language that builds web page content [OK]

Common Mistakes:

• Confusing HTML with Python
• Thinking Java creates web page structure
• Mixing C++ with web design

2. Which of the following is the correct way to start a Python program?

easy

A. System.out.println('Hello');

B. function main() {}

C. console.log('Hello')

D. print('Hello, world!')

Solution

1. Step 1: Identify Python syntax

   Python uses print() to display text, so print('Hello, world!') is correct.

2. Step 2: Check other options for language mismatch

   function main() {} is JavaScript style, C uses console.log, and D is Java syntax.

3. Final Answer:

   print('Hello, world!') -> Option D

4. Quick Check:

   Python output uses print() [OK]

Hint: Python programs print output with print() [OK]

Common Mistakes:

• Using JavaScript or Java syntax in Python
• Missing parentheses in print
• Confusing function declaration with print

3. What is the main use of SQL in computing?

medium

A. Managing databases

B. Creating mobile apps

C. Styling web pages

D. Writing operating systems

Solution

1. Step 1: Understand SQL's purpose

   SQL is a language designed to manage and query databases, like a librarian organizing books.

2. Step 2: Eliminate unrelated uses

   Mobile apps are built with languages like Java or Swift, styling web pages uses CSS, and operating systems use C or C++.

3. Final Answer:

   Managing databases -> Option A

4. Quick Check:

   SQL = Database management [OK]

Hint: SQL is for database queries and management [OK]

Common Mistakes:

• Confusing SQL with CSS
• Thinking SQL builds apps
• Mixing SQL with system programming

4. Identify the error in this JavaScript code snippet:

let x = 5
if x > 3 {
  console.log('Yes')
}

medium

A. Using let instead of var

B. Missing parentheses around condition in if statement

C. console.log should be console.print

D. No error, code is correct

Solution

1. Step 1: Check JavaScript if syntax

   JavaScript requires parentheses around the condition: if (x > 3).

2. Step 2: Verify other parts

   Using let is correct, console.log is the right function, so no errors there.

3. Final Answer:

   Missing parentheses around condition in if statement -> Option B

4. Quick Check:

   JavaScript if needs (condition) [OK]

Hint: If conditions in JS always need parentheses [OK]

Common Mistakes:

• Omitting parentheses in if
• Confusing console.log with console.print
• Thinking let is wrong syntax

5. You want to build a fast, interactive website with animations and user actions. Which combination of languages should you choose?

hard

A. C++ for structure, HTML for style, Python for interactivity

B. Python for structure, SQL for style, Java for interactivity

C. HTML for structure, CSS for style, JavaScript for interactivity

D. Java for structure, CSS for interactivity, SQL for style

Solution

1. Step 1: Identify roles of each language in web development

   HTML builds the page structure, CSS styles it visually, and JavaScript adds animations and user interactions.

2. Step 2: Evaluate other options for mismatches

   Python and SQL are not used for web page structure or style; C++ and Java are not typical for front-end web design.

3. Final Answer:

   HTML for structure, CSS for style, JavaScript for interactivity -> Option C

4. Quick Check:

   Web = HTML + CSS + JavaScript [OK]

Hint: Web pages need HTML, CSS, and JavaScript together [OK]

Common Mistakes:

• Mixing backend languages for frontend tasks
• Confusing SQL with styling
• Using C++ or Java for web page design