Objective:
This section introduces you to databases and gives you practice using a relational database management system. After finishing this section, you should be able to:
- Describe
the purposes of a relational database.
- Define
basic relational database terminology, including fields, records, primary keys,
foreign keys, and one-to-many relationships.
- Describe
the basic functions of a non-relational database.
- Describe
the purpose of a database management system.
- Use
Microsoft Access to explore database objects and create table relationships.
Links:
Key Terms:
- Database A structured set of data held in a computer, usually in a way that that is accessible in multiple ways.
- Relational Database A database that is structured to recognize relationships between items of information.
- Table A container in a relational database that is comprised of fields (columns) and records (rows).
- Field A single attribute of each record in a table.
- Record A single instance of an object stored in a database table.
- Primary Key A field in a table that uniquely identifies a row.
- Foreign Key A field in a second table that matches the primary key in another table.
- Query A method of asking questions about the data stored in a database.
- Form A graphical interface that allows users to query a database by filling in information on the form.
- Report An easy-to-read listing of the results of a query.
- Structured Query Language (SQL) A computer language used by most relational databases for creating queries.
- Structured Data Data that can be divided into discrete categories.
- Unstructured Data Data that doesn’t follow a clear pattern.
- Semi-Structured Data Data that has some discrete categories but also other information that doesn’t follow a clear pattern.
- Database Management System (DBMS) Software that allows users to define, manipulate, retrieve, and manage data stored in a database. Examples are Microsoft SQL Server, Oracle Database, MySQL, and Microsoft Access.
Topics Discussed:
- What
databases do you interact with in your everyday life?
- What
are the advantages to storing data in a relational database? Are there
disadvantages?
- What
is the purpose of a database management system?
Assignment:
- Access the TestOut Courseware through the provided link.
- Study Section 3.1: Databases, and achieve a score of 80% or higher on the 14 question Exam to complete the Section.
Assigned: December 4th, 2019
Teacher Pacing Due Date: December 6th, 2019
Objective:
This
section introduces you to operating systems and gives you practice using the
Windows user interface. After finishing this section, you should be able to:
- Identify
and describe different types of system software.
- Identify
common operating systems.
- Identify
and describe components of the Windows 10 operating system.
- Change
display settings in Windows.
- Use
the Settings app to view system information.
- Configure
a screen saver through the Settings app.
- Recognize
and use utility software.
- Use
Windows Device Manager to update drivers.
- Use
Windows Task Manager to prevent applications from running at system startup.
Links:
Key Terms:
- Operating System A computer program that makes it so people, hardware, and software can interface with each other in a meaningful way.
- Graphical User Interface An operating system interface that allows a user to interact with the computer by displaying pictures, icons, and other images on a screen to represent files, folders, and system controls and by accepting input from a mouse or a touch screen.
- Command Line Interface An operating system interface that allows a user to interact with the computer by displaying text on a screen and accepting input from the keyboard. The input is entered as commands. The command line is used primarily by IT and other tech professionals.
- Disk Management A role of the operating system that helps keep storage devices well organized and maintained.
- Application Management A role of the operating system that manages applications or programs that are installed on a system. Applications are run, configured, and deleted through application management.
- Service Management A role of the operating system that runs processes or programs automatically in the background. These programs are services that perform functions like indexing files for better searches, verifying that software is up to date, and backing up files.
- Device Management A role of the operating system that determines the hardware that is connected to the system, interprets instructions from the hardware, and sends instructions to it. Device management includes managing device drivers.
- Access Control/Protection A role of the operating system that requires users to log in with their credentials before accessing sensitive information on the computer. It also manages antivirus and antimalware software to prevent malicious files from accessing the computer.
- Utility Software Software that analyzes, configures, and optimizes the computer including backup software, compression software, disk cleaners, and antivirus software.
- Device Drivers Software that allows an operating system to communicate with hardware devices, such as printers, video cards, scanners, and cameras.
- Firmware Preinstalled, read-only software on a device that tells it how to work.
- Windows Settings App In Windows 10, an application that organizes the settings and customizes how the computer looks and functions.
Topics Discussed:
- What
is the difference between hardware, system software, and application software?
- What
is the purpose of an operating system?
- How
can the Windows operating system be configured through the Settings app?
Assignment:
- Access the TestOut Courseware through the provided link.
- Study Section 1.5: Software, and achieve a score of 80% or higher on the 12 question Exam to complete the Section.
Assigned: September 16th, 2019
Teacher Pacing Due Date: September 17th, 2019
It's dangerous to go alone!
