# CTE Resource Center - Verso - Office Specialist III--Preparation Task 1754130520

CTE Resource Center - Verso

Virginia’s CTE Resource Center

Create a worksheet.

Definition

Creation of a worksheet requires an understanding of worksheets' uses and structural elements (i.e., cells, rows, columns) and includes
  • setting properties for cells, rows, and columns (e.g., data type, font, height, width)
  • entering the data
  • creating charts to display the data
  • using basic formulas and functions (e.g., sum, average, min, max, count).

Related Standards of Learning

English

11.6

The student will write in a variety of forms, to include persuasive/argumentative, reflective, interpretive, and analytic with an emphasis on persuasion/argumentation.
  1. Apply components of a recursive writing process for multiple purposes to create a focused, organized, and coherent piece of writing to address a specific audience and purpose.
  2. Produce arguments in writing developing a thesis that demonstrates knowledgeable judgments, addresses counterclaims, and provides effective conclusions.
  3. Organize claims, counterclaims, and evidence in a sustained and logical sequence.
  4. Adapt evidence, vocabulary, voice, and tone to audience, purpose, and situation.
  5. Use words, phrases, clauses, and varied syntax to create a cohesive argument.
  6. Blend multiple forms of writing including embedding narratives to produce effective essays.
  7. Revise writing for clarity of content, accuracy and depth of information.
  8. Write and revise to a standard acceptable both in the workplace and in postsecondary education.

11.7

The student will self- and peer-edit writing for capitalization, punctuation, spelling, sentence structure, paragraphing, and Standard English.
  1. Use complex sentence structure to infuse sentence variety in writing.
  2. Use verbals and verbal phrases correctly to achieve sentence conciseness and variety.
  3. Distinguish between active and passive voice.

12.6

The student will write in a variety of forms to include persuasive/argumentative reflective, interpretive, and analytic with an emphasis on persuasion/argumentation.
  1. Apply components of a recursive writing process for multiple purposes to create a focused, organized, and coherent piece of writing to address a specific audience and purpose.
  2. Produce arguments in writing that develop a thesis to demonstrate knowledgeable judgments, address counterclaims, and provide effective conclusions.
  3. Use a variety of rhetorical strategies to clarify and defend a position organizing claims, counterclaims, and evidence in a sustained and logical sequence.
  4. Blend multiple forms of writing including embedding a narrative to produce effective essays.
  5. Adapt evidence, vocabulary, voice, and tone to audience, purpose, and situation.
  6. Use words, phrases, clauses, and varied syntax to connect all parts of the argument creating cohesion from the information presented.
  7. Revise writing for clarity of content, depth of information, and technique of presentation.
  8. Write and revise to a standard acceptable both in the workplace and in postsecondary education.
  9. Write to clearly describe personal qualifications for potential occupational or educational opportunities.

12.7

The student will self- and peer-edit writing for Standard English.
  1. Use complex sentence structure to infuse sentence variety in writing.
  2. Edit, proofread, and prepare writing for intended audience and purpose.
  3. Use a style manual, such as that of the Modern Language Association (MLA) or the American Psychological Association (APA), to apply rules for punctuation and formatting of direct quotations.

Mathematics

A.1

The student will
  1. represent verbal quantitative situations algebraically; and
  2. evaluate algebraic expressions for given replacement values of the variables.

COM.1

The student will design and apply computer programs to solve practical problems in mathematics arising from business and applications in mathematics.

COM.7

The student will select and call library functions to process data, as appropriate.

COM.10

The student will design and implement the input phase of a program, which will include designing screen layout, getting information into the program by way of user interaction and/or file input, and validating input.

COM.12

The student will design and implement computer graphics to enhance output.

COM.14

The student will select and implement appropriate data structures, including arrays (one- and/or two-dimensional) and objects.

Other Related Standards

FBLA Competitive Events and Activities Areas

Business Skills and Knowledge

 

Computer Applications

 

Database Design & Applications

 

Spreadsheet Applications

 

Word Processing

 

Microsoft Imagine Academy Resources

[2.020] Microsoft Digital Literacy: Productivity Programs—Lesson 4

[3.008] Excel 2010: Beginner Skills—E-Learning Module 1

[4.025] Excel 2010: Understanding Microsoft Office Excel 2010—Lesson 1

[5.064] Excel 2010 Secondary Schools: Lesson 1—Project 1

NBEA Achievement Standards for Communication

Integrate functions of word processing, databases, spreadsheets, and presentation applications to various workplace scenarios.

  

NBEA Achievement Standards for Information Technology

Identify productivity software appropriate for specific tasks.

 

Use productivity software to create documents, research topics and take notes, categorize data, and perform calculations to improve academic achievement across the curriculum.