Database management systems (DBMS) using Microsoft Access
- Database management systems (DBMS) essentials such as importing text files, creating tables, adding fields and records, validating data, etc.
- Searching through data sets using queries and SQL criteria to produce useful reports.
- Generating and printing reports.
- Creating forms and switchboards to control the DBMS.
- Describe the structure and function of a database, using related terms appropriately.
- Perform simple operations in a database (i.e., browse, sort, filter, search on selected criteria, delete data, enter data).
- Plan and develop database reports to organize and display information.
Computer Networks, threats, and security methods
- Theoretical knowledge of computer networks and how to secure them against common threats.
- Identify probable types and locations of Web sites by examining their domain names, and explain that misleading domain names are sometimes created in order to deceive people (e.g., .edu, .com, .org, .gov, .au).
- Explain and correctly use terms related to networks (e.g., LANs, WANs, servers, and routers) and Internet connectivity (e.g., DSL, VDSL).
- Explain the potential risks associated with using networked digital information (e.g., Internet, mobile phones, wireless, LANs).
- Provide examples of safe and unsafe practices for sharing personal information via e-mail and the Internet.
- Explain why computers, networks, and information need to be protected from viruses, intrusion, and vandalism.
- Explain terms associated with the safe, effective, and efficient use of telecommunications/Internet (e.g., password, firewalls, spam, security, Acceptable Use Policy.
- Describe how cyberbullying can be blocked.
High-level programming and problem-solving using Python 3.6 IDLE
- Understanding the purpose of High-level programming constructs such as top-down design, inputs/outputs, iteration, selection, etc.
- Independently use appropriate technology tools to define problems and propose hypotheses.
