SC12-WEEK23-DATABASES AN PROGRAMMING BASICS

Databases an programming basics

Objectives

Start

Introduction

Overview

• Purpose: To understand the use of Boolean logic in searches, identify and describe databases, collect and analyze data, develop and debug programs, and effectively communicate using technology tools.​

• Scope: Includes search techniques, databases, data handling, programming, and publishing digital content

Enhancing Searches with Boolean Logic

Definition: Boolean logic uses operators to refine and specify search queries

Key Operators:​

Definition

Key Operators:​

Boolean Logic Basics

AND: Retrieves records containing all specified terms (e.g., "science AND technology").​

OR: Retrieves records containing any of the specified terms (e.g., "technology OR innovation").

Key Operators:​

Key Operators:​

NOT: Excludes records containing the specified term (e.g., "technology NOT outdated").

Search Engines: Improve search results by using Boolean operators

Application

Databases: Refine search queries to find specific information

Identifying and Describing Everyday Databases

Library Catalogs: Indexes books, journals, and other resources available in a library.​

School Records: Contains student information, grades, and attendance records

Examples of Databases

Telephone Directories: Lists contact information for individuals and businesses.

Contact Lists: Stores personal or professional contact details in devices or applications.

Organization: Store and manage large amounts of information efficiently

Applications in Science and Engineering

Accessibility: Retrieve specific data quickly and accurately.

Data Collection and Analysis

Identification: Choose a topic, issue, problem, or question

Collecting a Data Set

Research: Gather data using age-appropriate technologies (e.g., surveys, online tools)

Data Management: Use databases or spreadsheets to organize data.​

Organizing and Analyzing Data

Analysis: Interpret data to answer specific questions or make decisions

Graphing: Create visual representations of data (e.g., bar charts, pie charts).​

Spreadsheets: Excel, Google Sheets for organizing and analyzing data

Tools

Databases: Access or MySQL for storing and querying data.​

Keyboarding Skills

Techniques

Importance

Touch Typing: Using all fingers and keeping proper posture.

Practice: Regular exercises to improve speed and accuracy

Accuracy: Reduce errors in typing and data input

Efficiency: Speed up data entry and communication

Creating and Modifying Programs

Block-Based Languages: Scratch, Blockly for visual programming.​

Graphical Programming Environments

Components: Blocks represent commands, loops, and conditionals.

Purpose: Simplify programming concepts and make learning engaging

Arithmetic Operators: Perform calculations (e.g., +, -, *, /).

Program Elements

Repetition: Repeat actions (e.g., “for” loops).​

Conditionals: Make decisions (e.g., “if” statements).

Initialization: Set starting values for variables or game scores (e.g., initializing a counter to zero).

Initial Conditions

Communicating and Publishing with Technology

Tools: Word processors, presentation software for creating documents and slides.

Writing and Publishing Activities

Communication: Share findings, reports, or projects with others.

Individual Projects: Create and present digital products on topics, concepts, or skills.

Digital Presentation

Collaborative Projects: Work with others to produce and present digital content

Debugging Programs

• Types of Errors:​
• Syntax Errors: Incorrect code structure.​
• Logical Errors: Flaws in program logic.​
• Runtime Errors: Errors occurring during program execution.​

Detecting Errors

• Interactive Debugging: Use debugging tools to step through code and identify issues.
• Modification: Adjust code to fix errors related to arithmetic operators, conditionals, and repetition.

Correcting Errors

QUIZ

TRIVIAL

as read above

start

Question 1/3

question 2/3

question 3/4

¡Quiz finished!

Great job!

See you next time

12TH-DATABASES AN PROGRAMMING BASICS-EN © 2024 by CASURID is licensed under CC BY-NC-ND 4.0

SC.35.CS-CP.1.1 Explain that searches may be enhanced by using Boolean logic (e.g., using “not”, “or”, “and”). SC.35.CS-CP.1.2 Identify and describe examples of databases from everyday life (e.g., library catalogs, school records, telephone directories, and contact lists). SC.35.CS-CP.1.3 Identify, research, and collect a data set on a topic, issue, problem, or question using age-appropriate technologies. SC.35.CS-CP.1.4 Collect, organize, graph, and analyze data to answer a question using a database or spreadsheet. SC.35.CS-CP.2.1 Perform keyboarding skills for communication and the input of data and information. SC.35.CS-CP.2.2 Create, test, and modify a program in a graphical environment (e.g., block-based visual programming language), individually and collaboratively.

SC.35.CS-CP.2.3 Create a program using arithmetic operators, conditionals, and repetition in programs. SC.35.CS-CP.2.4 Explain that programs need known initial conditions (e.g., set initial score to zero in a game, initialize variables, or initial values set by hardware input). SC.35.CS-CP.2.5 Detect and correct program errors, including those involving arithmetic operators, conditionals, and repetition, using interactive debugging. SC.35.CS-CP.3.1 Write, communicate and publish activities using technology tools. SC.35.CS-CP.3.2 Present digitally created products, either individually and collaboratively, where a topic, concept, or skill is carefully analyzed or thoughtfully explored.