Checkfu

Standard set

Computer Applications

CTE (2020-)Grades 08, 09, 10, 11, 12CSP ID: BCB4138A4294438F88B797A3FEE0936CStandards: 70

Standards

Showing 70 of 70 standards.

Filter by depth

Depth 0

Communication Networks, the Internet, and Technology Operations

Depth 0

Word Processing and Publishing

Depth 0

Spreadsheet Applications

Depth 0

Database Applications

Depth 0

Presentation Software

Depth 0

Digital Citizenship

Depth 0

Electronic Communication and Collaboration

1

Depth 1

Research recent developments in information technology affecting the supply/demand characteristics of the job market, including career pathways and occupational outlooks for occupations in business and finance that require information technology expertise. Synthesize findings into a presentation highlighting the typical roles and responsibilities of professionals in high-growth occupations.

2

Depth 1

Identify, connect, and demonstrate the correct usage of elements of a typical home computer, including a monitor, keyboard, mouse, network cable, and USB devices (such as camera, memory, or scanner). Perform basic troubleshooting as needed for situations involving these components (e.g., if the computer does not recognize a device).

3

Depth 1

Correctly and safely execute basic file management operations on a typical personal computer and shared storage media, including the opening, creating, copying, moving, deleting, and renaming of files and folders, as well as searching for a specified file or folder on local or networked storage media. 

4

Depth 1

Research effective use of cloud storage, online digital collaboration platform, and file sharing applications. Recommend and effectively employ the appropriate file storage and sharing solution for a given project.

5

Depth 1

Describe and demonstrate the correct connections and setup for a new wireless router in a home computing environment. Discuss the impact of network speeds, wireless communication, firewalls, and gateways on individual and societal productivity. 

6

Depth 1

Describe the steps necessary to retrieve, download, and safely install new applications, updates, and plug-ins from the Internet.

7

Depth 1

Compare and contrast the accessibility of the Internet through a home router versus through a public wi-fi access point. Discuss the risks and advantages of using secure home networks versus publicly accessible networks.

8

Depth 1

While preparing materials and assignments in this course, use a browser to access and download Internet resources by uniform resource locator (URL), hyperlink, or favorite/bookmark.

9

Depth 1

Use a word processing program to create and format documents with academic and business styles (e.g., memos, letters, agendas, reports, tabular lists) to communicate the results of research, meetings, lab reports, and relevant assignments in this course.

10

Depth 1

Craft documents using word processing program features and methods such as:

11

Depth 1

Enhance documents by including graphic arts components such as borders and shaded elements, graphs and charts from other programs, watermarks, and imagery imported from technology devices and drives as well as sources retrieved from the Internet, including adding citations and/or captions for each element when appropriate.

12

Depth 1

Create, format, and edit documents suitable for print or electronic distribution, both fourcolor and two-color (black and white).

13

Depth 1

Critique and edit existing documents with standard proofreading and editing marks to conform to a standard business style guide (e.g., fonts, colors, line spacing). Practice the use of electronic revision marks and comments, where supported. 

14

Depth 1

Complete a comprehensive word-processing project with instructor approval that applies the skills acquired in this section. For example, prepare a contract, MLA-style report, business proposal, or budget report from a student organization.

15

Depth 1

Use a spreadsheet program to create and format academic and business documents for the purposes of tabulating and calculating numerical and/or textual data (e.g., statistics, historical data, measurements), such as budget calculations, sales reports, lab data, and related analyses. 

16

Depth 1

Craft documents using a spreadsheet program using features and methods such as:

17

Depth 1

Create new formulas to analyze data by calculating with, extracting from, presenting, and/or summarizing, including:

18

Depth 1

Create and format for optimal clarity a variety of types of graphs and charts, including bar charts, line charts, pie charts, and X-Y graphs, based on tabulated data. 

19

Depth 1

Retrieve a spreadsheet template (from those installed with the program or from the Internet) and customize it for a particular assignment approved by the instructor. For example, prepare a “timecard” of one’s daily hours spent on a month-long job assignment. 

20

Depth 1

Use a database program to interpret the structure of an existing database (found in teaching resources or teacher-created), identifying tables, fields, key fields, queries, forms, and reports.

21

Depth 1

Using an existing database (found in teaching resources or teacher-created), create and run a database report based on basic queries. For example, retrieve the relevant information to answer a customer product inquiry during a mock customer service phone call. 

22

Depth 1

Using an existing database (found in teaching resources or teacher-created), create, modify, and perform basic queries through a form to create a new table/view in a database.

23

Depth 1

Design, create, and deliver an oral presentation for a selected audience on a topic approved by the instructor. Using a specified slide number and duration, include the following elements: 

24

Depth 1

Design, create, and deliver a self-running electronic slideshow for a selected audience on a topic approved by the instructor. Using a specified slide number and duration, include the following elements:

25

Depth 1

Research, summarize, and deliver (via presentation, document, spreadsheet data/chart, or other format) a summary of the various perspectives and ramifications surrounding an ethical issue related to modern-day electronic communications, as approved by the instructor. Develop and strengthen claim(s) and counterclaim(s) about the issue, citing supportive evidence. Potential issues include spam, flaming, cyberbullying, libel, slandering, and mining of personal data for profit.

26

Depth 1

Research, summarize, and deliver (via presentation, document, spreadsheet data/chart, or other format) a summary of the various perspectives and ramifications surrounding an ethical issue related to intellectual property rights, as approved by the instructor. Develop and strengthen claim(s) and counterclaim(s) about the issue, citing supportive evidence. Potential issues include copyright infringement, piracy, plagiarism, art licensing, creative commons, and the state/federal laws that govern them.

27

Depth 1

Explain, furnish examples, and demonstrate technical literacy with the following terms:

28

Depth 1

Employ skills covered in this course (document processing, spreadsheet applications, electronic presentations, databases, Internet fluency) to complete a cross curricular project approved by the instructor. 

10.a

Depth 2

Paragraph formatting (line spacing, justification, indentations)

10.b

Depth 2

Bulleted and numbered lists

10.c

Depth 2

Tables of multiple columns, with and without borders

10.d

Depth 2

Margins, headers, footers, page numbers, and footnotes

10.e

Depth 2

Typeface fonts and weights, including hyperlinks

10.f

Depth 2

Capitalization, punctuation, number expression, grammar

10.g

Depth 2

Printing orientation, one- or two-sided, to a selected printer

10.h

Depth 2

Bibliographies and tables of contents

10.i

Depth 2

Saving to a file that can be shared and/or transported, including saving to cloudbased or external sources

16.a

Depth 2

Cells, columns, and rows

16.b

Depth 2

Formulas and functions

16.c

Depth 2

Copy, move, delete, and fill 

16.d

Depth 2

Cell-value formats (numerical and text) and alignment

16.e

Depth 2

Column and row width/height, insert/delete, move

16.f

Depth 2

Printing to a selected printer

16.g

Depth 2

Saving with a file format that can be shared and/or transported

17.a

Depth 2

Basic arithmetic calculations

17.b

Depth 2

Basic mathematic (e.g., SUM, AVG, MIN, MAX) and text (e.g., LEN, LEFT, RIGHT, MID) functions

17.c

Depth 2

Copying formulas that include both relative and absolute cell references

17.d

Depth 2

Sorting in ascending/descending order

17.e

Depth 2

Filtering data to retrieve specific values

17.f

Depth 2

Basic conditional formatting (e.g., red for negative values)

23.a

Depth 2

A selected theme (colors, background, fonts, etc.) 

23.b

Depth 2

Bulleted text based on a chosen style

23.c

Depth 2

Photographs and other imagery 

23.d

Depth 2

Charts and graphs 

23.e

Depth 2

Video and animated graphics

23.f

Depth 2

Animated transitions of slides and components within a slide 

24.a

Depth 2

A selected theme (colors, background, fonts, etc.)

24.b

Depth 2

Photographs and other imagery

24.c

Depth 2

Video and animated graphics

24.d

Depth 2

Animated transitions of slides Save the file in a format that can be tran

27.a

Depth 2

The Internet, World Wide Web, and various browsers

27.b

Depth 2

Network speeds, wireless communication, firewalls, and gateways

27.c

Depth 2

Domains, hyperlinks, homepages, favorites/bookmarks, plugins, tabs, and downloads/uploads

Framework metadata

Source document
Computer Applications
License
CC BY 4.0 US