CTE Standards and Benchmarks

CTE Standards and Benchmarks
Demonstrate knowledge of safety and privacy practices for online communication. The student will be able to:
|
Define “privacy” and relate it to the term “digital footprint.”
|
Describe the risks of communicating on social networking sites (e.g. Facebook, Twitter, Instagram) and identify ways to communicate safely.
|
Distinguish between copyright infringement, plagiarism and fair use in an educational setting and in relation to school projects, especially with music and pictures.
|
Describe online communication practices that contribute to cyberbullying.
|
Practice safe online communication techniques with Internet searches, email, chat rooms, and other social network Web sites.
|
Follow an Acceptable Use Policy (AUP) when accessing the Internet.
|
Develop and apply fundamental spreadsheet skills. – The student will be able to:
|
Define “spreadsheet” and describe ways it may be used.
|
Identify the parts of the spreadsheet display, including cells, columns and rows, cell references, cell range.
|
Create and navigate through multiple spreadsheets in a file.
|
Insert and format various types of data (text, numeric, date/time) in a spreadsheet cells.
|
Select multiple cells, including adjacent and non-adjacent ranges, using mouse and keyboard techniques.
|
Cut, copy, and paste information from one or more cells to another part of the spreadsheet.
|
Use the undo and redo tools in a spreadsheet.
|
Apply and modify cell formatting for currency, date and percentage values.
|
Resize column width and row height in a spreadsheet.
|
Insert and delete columns and rows in a spreadsheet.
|
Merge and unmerge cells in a spreadsheet.
|
Apply shading and borders to a spreadsheet.
|
Describe the purpose of a table and how it relates to a spreadsheet.
|
Create and print a table and/or range that displays and sums the values of different data types.
|
Identify various types of charts (e.g., line, bar, pie, scatter) and common chart components (e.g., vertical axis, horizontal axis, legend), and explain when to use each chart type.
|
Create a chart from existing data and format the pieces (data set), change the background color, and add appropriate titles and a legend.
|
Use the auto sum function to calculate the values of multiple cells.
|
Insert common functions (SUM, AVERAGE, COUNT, MAX, MIN) and simple mathematical formulas which include addition, subtraction, multiplication, or division into a spreadsheet.
|
Distinguish between absolute and relative cell references in a spreadsheet.
|
Use the sort function to organize information numerically or alphabetically, including multiple levels of sorting.
|
Use the filter function to display spreadsheet data based on specific criteria.
|
Use conditional formatting to highlight text in a spreadsheet.
|
Develop and apply database skills. – The student will be able to:
|
Define database and describe real-world uses (e.g. search engines, schools, drivers licenses & car registrations, hospitals, retail, law enforcement).
|
Distinguish between databases and spreadsheets.
|
Identify advantages of using a database instead of alternatives (e.g., spreadsheets, electronic documents, paper).
|
Define “Big Data” and describe how it is used in advertising.
|
Identify the components of a database.
|
Distinguish between fields and records in a database.
|
Describe the basic data types and formats used in a database.
|
Distinguish between a table and a query.
|
Identify database keys, including primary and foreign.
|
Identify the relationships between tables in databases (i.e., one-to-one, one-to-many, many-to-many).
|
Distinguish between a query and a report.
|
Identify various report types.
|
Describe Structured Query Language (SQL) and discuss its use with databases.
|
Identify and compare various database applications, including Microsoft Access, MySQL, Oracle.
|
Create a database table that uses multiple data types.
|
Add, Edit, and Delete records from a database table.
|
Sort records in a database query or table.
|
Troubleshoot common database errors, including data type errors, query syntax errors.
|
Create a basic select query in one table.
|
Create an action query to manipulate data.
|
Create a query using primary and foreign keys.
|
Create a simple table join.
|
Import and export data from a database into a spreadsheet.
|
Create relevant reports from a database.
|
Demonstrate skill in using video editing software and equipment. – The student will be able to:
|
Demonstrate ability to operate a video camera (e.g., Flip camera, cell phone).
|
Write storyboards to depict a one minute video segment.
|
Determine appropriate lighting needs.
|
Create video shots sufficient to produce a one minute video.
|
Identify the functions and benefits of the digital video software interface.
|
Demonstrate ability to edit, cut, erase, and insert video.
|
Edit video as needed to achieve desired message and length.
|
Describe a first complete run-through of the video production process.
|
Characterize the qualities of effective communication in a completed video.
|
Upload finished video files to a website.
|
Demonstrate proficiency in using audio editing software (e.g., Audacity). – The student will be able to:
|
Identify the functions and benefits of the audio editing software interface.
|
Demonstrate ability to edit, cut, erase, and insert audio.
|
Edit audio as needed to achieve desired message and length.
|
Prepare a 30 second to 1 minute audio commercial project.
|
Demonstrate proficiency locating, gathering, and preparing textual, graphical, and image-based web content. – The student will be able to:
|
Define the elements of a webpage and what makes a good webpage.
|
Describe effective text and image content for Web pages based on how visitors use the Web.
|
List guidelines and conventions for effective text on Web page.
|
Explain the inverted pyramid model of newspaper journalism and how it applies to Web content.
|
Use word-processing software to create effective written content for a Web page.
|
Create and/or edit message-driven image content for a Web page using graphics software.
|
Access graphics through various recourses (e.g., scanner, digital camera, CD-ROM, clipart, copyright-free online graphics).
|
Plan the content and design of a basic Web page using strategies for effective Web communication, including brainstorming, determining audience, choosing content and media types, using white space.
|