SpreadSheets
Explain what is a spreadsheet?
A spreadsheet is a digital tool used to organize, calculate, and analyze data.
Describe what a database is.
A database is an organized collection of data that can be easily accessed, managed, and updated.
The roll function in Sphero makes the robot move at a specified speed and direction.
highlight the data, then click on the home tab select conditional formatting and choose which style.
Define what a table is.
A table is a collection of data organized in rows and columns, where each row is a record and each column is a field.
Angles are used in Sphero coding to control the robot’s direction. They specify the heading (e.g., 0° for forward, 90° for right), allowing precise movement and navigation.
What is data cleaning and why is it important?
Data cleaning is the process of fixing errors and inconsistencies in a dataset to ensure accuracy and reliability.
Importance - It ensures that analysis is based on accurate data, leading to more reliable results and better decision-making.
Explain why it is important to choose the right datatype.
Choosing the right datatype is important for accuracy, efficiency, and error prevention. It ensures data is stored correctly, optimizes storage and performance, and avoids errors like incorrect data entries.
Explain why a loop function is very important in code.
A loop function is important in code because it allows repetitive tasks to be performed efficiently without writing the same code multiple times. It runs a set of instructions repeatedly based on a condition, saving time and reducing errors. Loops are essential for tasks like continuously checking inputs, moving objects, or processing data until a specific condition is met.
Justify what is a pivot table
A pivot table is a tool that summarizes and organizes large datasets, allowing you to analyze data by grouping and aggregating it based on specific criteria. It helps quickly identify trends and patterns.
Compare a query and a filter.
A query in Access is similar to a filter in Excel, but a query is more powerful. It can search, manipulate, and combine data from multiple tables, while a filter in Excel simply sorts and displays data based on specific conditions.
What is the purpose of a flowchart when coding?
A flowchart is used to visually represent the logic and flow of a program or algorithm. It helps developers plan and organize their code by breaking down processes into steps, decisions, and loops. Flowcharts make it easier to understand the program’s structure, identify potential issues, and communicate the logic to others before actual coding begins.