Common Planner
K–12 Standards

Advanced Computer Applications

Other Tennessee CTE sets

Secure Technology Operations

  • 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 hard drives, removable storage, or networked storage media. Build upon this knowledge to effectively use cloud storage and/or online digital collaboration platforms and file sharing applications. Appraise file storage needs for a given project, recommend and effectively employ the appropriate file storage and sharing solution given project characteristics. 1

  • 2

    Correctly and safely import and export digital files (such as text, audio, video, and picture files in a variety of formats) from local and networked devices, choosing and employing the correct cables, removable storage media, and/or hardwired or wireless network connections. Perform basic troubleshooting as needed for enhancing productivity and optimizing performance of devices such as cameras, scanners, printers, and tablets. Perform basic operations to change file types for effective use in typical software applications. For example, connect an iPad via a wireless network, download photos from the device, and change the format of the photos from .jpg to .png format for use in a presentation application. 2

Word Processing and Publishing

  • 3

    Building on standards from Computer Applications, create and manage professional documents of business activities to communicate with internal and external stakeholders. Fluently navigate word processing software to complete the following: 3

    1. a

      Create a document from a blank document, template, imported file, or non-native document imported into word processing software 3.a

    2. b

      Search for text within a document, insert hyperlinks, create bookmarks and use “Go To” functionality efficiently3.b

    3. c

      Modify page setup, select and employ appropriate document themes and style set(s) for a given project and insert headers, footers, page numbers, and watermarks3.c

    4. d

      Customize viewing options to effectively navigate a project using application tools such as zoom, toolbars, ribbons, macros, and shortcut keys3.d

    5. e

      Configure documents to scale, print, and save effectively, including maintaining backwards compatibility with previous software versions and password protecting if necessary3.e

  • 4

    Effectively review, revise, and format text, paragraphs, and sections for a specific type of word processing file (such as a company report, memo, or invoice) by completing the following skills fluently:4

    1. a

      Revise documents using find and replace, copy and paste, AutoCorrect, and inserting special characters where needed4.a

    2. b

      Edit documents by changing font attributes, using format painter tools, highlighting where needed, and using WordArt4.b

    3. c

      Effectively determine and update paragraph, line, and character spacing4.c

    4. d

      Discriminate between appropriate and inappropriate ordering and grouping of text, objects, and sections, creating a professional document by preventing paragraph “widows” and “orphans,” inserting breaks in pages and sections, utilizing columns where appropriate, and modifying object formatting for smooth flow of text 4.d

  • 5

    Choose, employ, and manipulate text structure tools such as tables and lists to convey specific information accurately, demonstrating understanding of categories or hierarchies in the information, by completing the following skills fluently:5

    1. a

      Create a table by converting text, importing data from another application, defining table dimensions and labeling appropriately 5.a

    2. b

      Review and modify existing tables using styles, fonts, sorting and formula capabilities, and cell margin and table dimension configurations 5.b

    3. c

      Create and modify lists by employing bullets, numbering, and outlines and editing indention, spacing, and levels5.c

  • 6

    Gather relevant information from multiple authoritative print and digital sources, assessing the strengths and limitations of each source, and integrate the source accurately into the document using citations, references, and footnotes. Select appropriate notation formatting for a given style, such as Modern Language Association (MLA), American Psychological Association (APA), or the Chicago Manual of Style.6

    1. a

      Integrate information into the text selectively to maintain the flow of ideas, avoid plagiarism, and over-reliance on any one source6.a

    2. b

      Insert, manage the locations, and auto-update endnotes, footnotes, citations, and bibliographies following a standard format6.b

    3. c

      Add and modify the font, format, location, and position of captions6.c

  • 7

    Integrate multiple sources of information presented in diverse formats and media in order to address a question or solve a problem. 7

    1. a

      Insert quick parts, textboxes, and customizable building blocks 7.a

    2. b

      Insert and format simple shapes and SmartArt, formatting their properties (color, size, shape) and text wrapping to seamlessly integrate into document7.b

    3. c

      Insert and format image files, including modifying with effects and updating properties to ensure effective integration with text and other objects 7.c

Spreadsheet Applications

  • 8

    Building on standards from Computer Applications, use a spreadsheet application to create and manage worksheets and workbooks for business functions such as invoices, financial statements, data review and summarization, and statistical analysis. 8

    1. a

      Create new workbooks from blank worksheets, templates, imported and nonnative files8.a

    2. b

      Navigate through existing workbooks by searching for specific data, inserting hyperlinks, changing worksheet order and using “Go To” and “Name Box” functions8.b

    3. c

      Format worksheets and workbooks using colors, page setup options, columns and rows, themes, watermarks, headers and footers, and setting data validation8.c

    4. d

      Customize options and views for workbooks, including hiding columns, rows, and worksheets, editing toolbars, ribbons, and macros, freezing panes and utilizing short cut keys8.d

    5. e

      Configure worksheets and workbooks for effective printing and saving, including setting print area, changing file formats, setting print scaling, and maintaining backwards compatibility if needed 8.e

  • 9

    Given a specific document purpose, accurately create cells and ranges to effectively manage data, draw conclusions from analysis, and structure for ease of readability.9

    1. a

      Insert, review, and append data in cells and ranges using find and replace, copy and paste, AutoFill, expanding data across cells, and inserting and deleting cells 9.a

    2. b

      Format cells and ranges for a given purpose, including merging cells, modifying alignment, font, wrap-text, and indentation and employing WordArt and number formatting when appropriate9.b

    3. c

      Order and group cells and ranges by applying conditional formatting, inserting sparklines, transposing columns and rows, creating named ranges, inserting subtotals, and collapsing groups of data9.c

  • 10

    Translate quantitative or technical information between text, visuals, data, and equations by accurately creating and using tables. 10

    1. a

      Effectively navigate between tables and ranges, adding or removing cells and defining titles 10.a

    2. b

      Modify styles and format of a table to convey meaning, including applying styles, banding rows and columns, and inserting totals or averages10.b

    3. c

      Filter and sort information effectively, including filtering records, sorting data on multiple columns, changing sort order to highlight specific information, and removing duplicates to enhance analysis 10.c

  • 11

    Accurately determine appropriate calculations (formulas and functions) for analysis to draw conclusions about sets of data, including: 11

    1. a

      Utilize cell range and references (relative, mixed, absolute) to complete functions accurately based on specific question sought to address, including accurate understanding of order of operations11.a

    2. b

      Summarize data with functions such as sum, average, minimum, maximum, and count11.b

    3. c

      Utilize conditional logic in functions (if-then statements) to accurately discriminate data for analysis11.c

    4. d

      Format and modify text with functions11.d

  • 12

    Analyze needed structure and objects (such as charts and graphs) to convey particular meaning or draw conclusions from a dataset. 12

    1. a

      Create charts and graphs that summarize appropriate data series, including differentiating between rows and columns in source data12.a

    2. b

      Format charts and graphs by modifying legends, sizes, parameters, layouts and styles and positioning12.b

    3. c

      Insert and format an object (such as a textbox, SmartArt or image) and format its border, positioning, properties, styles and effects and colors12.c

Presentation Software

  • 13

    Building on standards from Computer Applications, use presentation software to create and manage clear and coherent multimedia presentation materials for a given audience, task, purpose, and length of presentation. Fluently navigate software to: 13

    1. a

      Create new presentations from blank slides, templates, and important files and/or file content (such as outlines or text from word processing files) 13.a

    2. b

      Format a presentation to achieve a style appropriate to a given audience and industry by applying slide masters, layouts, background images, page numbers, headers and footers, and presentation themes13.b

    3. c

      Customize presentation options and views to ensure accurate page setup, printing (color/grayscale), and navigation13.c

    4. d

      Configure presentations to print for handouts or notes and save to maintain appropriate settings by determining most applicable handout print options, package presentations for CD, save presentations as webpages, and maintain backwards compatibility where needed13.d

    5. e

      Configure and present slideshows in a public speaking setting, paying close attention to slide timing, resolution, annotations, options, and appropriate views for a given presentation venue13.e

  • 14

    For a given content, select and employ appropriate structure to convey meaning and organize information into categories and hierarchies appropriately, including:14

    1. a

      Add slide layouts, duplicate, hide, and delete slides, and modify slide backgrounds and styles14.a

    2. b

      Insert and format shapes, including applying borders, resizing, and applying styles to both custom and template shapes14.b

    3. c

      Order and group shapes and slides by inserting section headers, modifying slide order, aligning and grouping shapes, and displaying gridlines14.c

  • 15

    Create slide content that is clear and coherent, in which the development, organization, and style are appropriate to a given task, purpose, and audience, including: 15

    1. a

      Insert and format text such as WordArt, columns, hyperlinks, and bulleted and numbered lists 15.a

    2. b

      Insert and format tables and charts, including modifying rows, columns, and legends, applying styles, modifying parameters and importing from external sources15.b

    3. c

      Insert and format SmartArt and images, including adding shapes, changing colors, adding and moving text, resize, crop, and apply styles15.c

    4. d

      Insert and format appropriate media, including video and audio clips, by adjusting window size, setting start/stop times, setting options, and linking to external sources15.d

  • 16

    Effectively employ transitions and animations to convey meaning without distracting from slide content.16

    1. a

      Insert transitions between slides, manage multiple transitions, and modify transition effect options16.a

    2. b

      Animate slide content including applying animations to shapes and paths and modifying animation properties16.b

    3. c

      Set timings for transitions and animations to ensure appropriate duration, order, and start/stop times for effects 16.c

  • 17

    Develop, manage, and strengthen content by planning, revising, and editing presentations, including: 17

    1. a

      Merge content from multiple presentations and reuse appropriate slides with separate or similar formatting17.a

    2. b

      Track changes and resolve differences (such as discarding changes or managing comments) to focus on what is most significant for a specific purpose and audience17.b

    3. c

      Protect and share presentations using encryption, passwords, media compression, and permissions, while ensuring accessibility and compatibility are maintained for a given situation or scenario17.c

Information Management & Integration

  • 18

    Throughout the course, conduct a sustained research project to answer a question or solve a problem. Synthesize research into an argument that is established, developed, and supported with multiple sources of data and evidence. Demonstrate authentic technical skills in word processing, presentations, and spreadsheet applications, effectively combining functionality of multiple software applications to present a coherent final project, including a report (with imported data, appendixes, etc.) and presentation with appropriate citations from text. Use selected technology to produce, publish, and update final projects. 18

  • 19

    Select a historical event, scientific procedure, or technical process to narrate in a comprehensive report and presentation, practicing effective word processing, spreadsheet, and presentation skills. Develop and strengthen writing and data organization through planning, revising, peer-review, editing, and rewriting throughout the course.19

Frequently asked questions

What grade levels do these standards cover?
Grade 11 and Grade 12
Where can I read the official document?
Advanced Computer Applications

Keep exploring

Keep exploring CTE standards

Sibling grade bands, other subjects in this jurisdiction, and the same subject across other states.

More Tennessee CTE sets

CTE