# CTE Resource Center - Verso - Office Administration Microsoft Imagine Academy Resources Correlation by Task

CTE Resource Center - Verso

Virginia’s CTE Resource Center

Microsoft Imagine Academy Resources Correlation by Task

In this course, the following tasks/competencies reinforce the standards listed beside them. Teachers may identify additional reinforcements in locally developed instructional materials.

Task/Competency Number Task/Competency Statement Standards
34 Identify Internet safety issues and procedures for complying with acceptable use standards. Microsoft Imagine Academy Resources: [2.011] Microsoft Digital Literacy: Internet and the World Wide Web
41 Demonstrate etiquette skills while transmitting and receiving electronic communications. Microsoft Imagine Academy Resources: [2.014] Microsoft Digital Literacy: Internet and the World Wide Web—Lesson 3
42 Prepare business correspondence, including electronic formats. Microsoft Imagine Academy Resources: [2.018] Microsoft Digital Literacy: Productivity Programs—Lesson 2 ♦ [2.019] Microsoft Digital Literacy: Productivity Programs—Lesson 3
43 Prepare documents using scanning and production software for presentation. Microsoft Imagine Academy Resources: [2.019] Microsoft Digital Literacy: Productivity Programs—Lesson 3
49 Identify emerging technology related to telecommunications. Microsoft Imagine Academy Resources: [2.015] Microsoft Digital Literacy: Internet and the World Wide Web—Lesson 4
53 Maintain workstation, equipment, materials, and supplies. Microsoft Imagine Academy Resources: [2.006] Microsoft Digital Literacy: Computer Basics—Lesson 1 ♦ [4.068] Windows 7: Installing Windows 7—Lesson 2 ♦ [5.176] Windows 7 Higher Education: Lesson 2—Exercise 1
58 Troubleshoot computer hardware and software problems. Microsoft Imagine Academy Resources: [3.125] Windows 7 Essentials II—E-Learning Module 2 ♦ [4.070] Windows 7: Using Disks and Devices—Lesson 4 ♦ [4.072] Windows 7: Resource Sharing—Lesson 6
69 Maintain an alphabetical filing system. Microsoft Imagine Academy Resources: [2.009] Microsoft Digital Literacy: Computer Basics—Lesson 4
70 Maintain subject filing system. Microsoft Imagine Academy Resources: [2.009] Microsoft Digital Literacy: Computer Basics—Lesson 4
72 Maintain a manual or electronic chronological file system. Microsoft Imagine Academy Resources: [4.011] Introduction to Microsoft Office 2010: Office Lesson Plan—Managing Files ♦ [5.022] Intro Windows 7: Lesson 2—Project 1
74 Retrieve information from manual and electronic files. Microsoft Imagine Academy Resources: [2.009] Microsoft Digital Literacy: Computer Basics—Lesson 4
75 Maintain contact information. Microsoft Imagine Academy Resources: [3.060] OneNote 2010: Beginner Skills—E-Learning Module 1
77 Access electronic resources (e.g., Internet, Intranet). Microsoft Imagine Academy Resources: [2.012] Microsoft Digital Literacy: Internet and the World Wide Web—Lesson 1 ♦ [2.044] Finding and Evaluating Resources on the Web—Lesson 1 ♦ [2.045] Finding and Evaluating Resources on the Web—Lesson 2
78 Produce complex business documents. Microsoft Imagine Academy Resources: [3.006] Access 2010: Advanced Skills—E-Learning Module 1 ♦ [3.012] Excel 2010: Intermediate Skills—E-Learning Module 2 ♦ [3.074] PowerPoint 2010: Advanced Skills—E-Learning Module 1 ♦ [3.179] Developing Microsoft® .NET Applications for Windows: E-Learning Module 2 ♦ [4.024] Access 2010: Entire Access 2010 Lesson Plan ♦ [4.033] Excel 2010: Entire Excel 2010 Lesson Plan ♦ [4.049] PowerPoint 2010: Entire PowerPoint 2010 Lesson Plan ♦ [4.114] Word 2010: Entire Word 2010 Lesson Plan
81 Prepare documents for electronic distribution. Microsoft Imagine Academy Resources: [3.063] OneNote 2010: Beginner Skills—E-Learning Module 4 ♦ [3.065] OneNote 2010: Intermediate Skills—E-Learning Module 2 ♦ [3.066] OneNote 2010: Advanced Skills—E-Learning Module 1 ♦ [3.067] OneNote 2010: Advanced Skills—E-Learning Module 2
82 Enhance documents using formatting features. Microsoft Imagine Academy Resources: [2.019] Microsoft Digital Literacy: Productivity Programs—Lesson 3 ♦ [3.136] Word 2010: Beginner Skills—E-Learning Module 1 ♦ [3.137] Word 2010: Beginner Skills—E-Learning Module 2 ♦ [4.109] Word 2010: Working with Graphics—Lesson 7 ♦ [4.106] Word 2010: Revising the Document Layout—Lesson 4 ♦ [4.105] Word 2010: Formatting Text—Lesson 3 ♦ [5.255] Word 2010 Secondary Schools: Lesson 3—Project 1
83 Create tables. Microsoft Imagine Academy Resources: [2.019] Microsoft Digital Literacy: Productivity Programs—Lesson 3 ♦ [3.142] Word 2010: Intermediate Skills—E-Learning Module 3 ♦ [4.111] Word 2010: Organizing Content—Lesson 9 ♦ [5.261] Word 2010 Secondary Schools: Lesson 9—Project 1
85 Create macros. Microsoft Imagine Academy Resources: [3.006] Access 2010: Advanced Skills—E-Learning Module 1 ♦ [3.015] Excel 2010: Advanced Skills—E-Learning Module 1
86 Find/replace text and data. Microsoft Imagine Academy Resources: [3.136] Word 2010: Beginner Skills—E-Learning Module 1
87 Merge text and data. Microsoft Imagine Academy Resources: [3.139] Word 2010: Intermediate Skills—E-Learning Module 1 ♦ [4.112] Word 2010: Mail Merge and Reviewing Documents—Lesson 10 ♦ [5.262] Word 2010 Secondary Schools: Lesson 10—Project 1
89 Develop a spreadsheet. 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
90 Edit a spreadsheet. 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
91 Enhance a spreadsheet by using formatting features. Microsoft Imagine Academy Resources: [2.020] Microsoft Digital Literacy: Productivity Programs—Lesson 4 ♦ [3.009] Excel 2010: Beginner Skills—E-Learning Module 2 ♦ [4.026] Excel 2010: Format a Workbook—Lesson 2 ♦ [4.025] Excel 2010: Understanding Microsoft Office Excel 2010—Lesson 1 ♦ [5.065] Excel 2010 Secondary Schools: Lesson 2—Project 1
92 Create a database. Microsoft Imagine Academy Resources: [2.020] Microsoft Digital Literacy: Productivity Programs—Lesson 4 ♦ [3.001] Access 2010: Beginner Skills—E-Learning Module 1 ♦ [4.018] Access 2010: Create Database Tables Using Access—Lesson 2 ♦ [5.034] Access 2010: Project 2
93 Exhibit use of data functions. Microsoft Imagine Academy Resources: [2.022] Microsoft Digital Literacy: Productivity Programs—Lesson 6 ♦ [3.001] Access 2010: Beginner Skills—E-Learning Module 1 ♦ [4.018] Access 2010: Create Database Tables Using Access—Lesson 2 ♦ [5.034] Access 2010: Project 2
94 Create queries. Microsoft Imagine Academy Resources: [2.022] Microsoft Digital Literacy: Productivity Programs—Lesson 6 ♦ [3.004] Access 2010: Beginner Skills—E-Learning Module 4 ♦ [4.022] Access 2010: Query a Database—Lesson 6 ♦ [5.038] Access 2010: Project 6
95 Manipulate data. Microsoft Imagine Academy Resources: [2.022] Microsoft Digital Literacy: Productivity Programs—Lesson 6 ♦ [3.003] Access 2010: Beginner Skills—E-Learning Module 3 ♦ [4.019] Access 2010: Modify Database Tables—Lesson 3 ♦ [5.035] Access 2010: Project 3
96 Generate a database report. Microsoft Imagine Academy Resources: [2.022] Microsoft Digital Literacy: Productivity Programs—Lesson 6 ♦ [3.003] Access 2010: Beginner Skills—E-Learning Module 3 ♦ [4.021] Access 2010: Creating Reports—Lesson 5 ♦ [5.037] Access 2010: Project 5
97 Format a datasheet. Microsoft Imagine Academy Resources: [2.022] Microsoft Digital Literacy: Productivity Programs—Lesson 6 ♦ [3.001] Access 2010: Beginner Skills—E-Learning Module 1 ♦ [4.019] Access 2010: Modify Database Tables—Lesson 3 ♦ [5.035] Access 2010: Project 3
98 Integrate database, spreadsheet, and word processing activities. Microsoft Imagine Academy Resources: [4.030] Excel 2010: Working with Charts and Graphics—Lesson 6 ♦ [4.038] Expression Web 4: Using Hyperlinks on a Webpage—Lesson 5 ♦ [4.109] Word 2010: Working with Graphics—Lesson 7 ♦ [5.068] Excel 2010 Secondary Schools: Lesson 6—Project 1 ♦ [5.099] Expressions Web 4 Higher Education: Lesson 5—Exercise 1
99 Prepare presentation visuals and handouts. Microsoft Imagine Academy Resources: [2.021] Microsoft Digital Literacy: Productivity Programs—Lesson 5 ♦ [3.076] PowerPoint 2010: Advanced Skills—E-Learning Module 3 ♦ [4.043] PowerPoint 2010: Formatting a Presentation for Printing—Lesson 3 ♦ [5.111] PowerPoint 2010 Secondary Schools: Lesson 3
103 Maintain appointment calendar, work schedules, and leave/vacation balances for employees. Microsoft Imagine Academy Resources: [3.062] OneNote 2010: Beginner Skills—E-Learning Module 3
104 Coordinate travel arrangements for employees. Microsoft Imagine Academy Resources: [3.062] OneNote 2010: Beginner Skills—E-Learning Module 3
105 Coordinate meetings, events, training, and activities for employees. Microsoft Imagine Academy Resources: [3.064] OneNote 2010: Intermediate Skills—E-Learning Module 1
106 Design a physical layout of the office. Microsoft Imagine Academy Resources: [2.003] Microsoft Digital Literacy: First Course—Lesson 2 ♦ [2.004] Microsoft Digital Literacy: First Course—Lesson 3
114 Explain the importance of confidentiality in the workplace. Microsoft Imagine Academy Resources: [2.023] Microsoft Digital Literacy: Computer Security and Privacy
119 Research professional and personal development opportunities. Microsoft Imagine Academy Resources: [2.010] Microsoft Digital Literacy: Computer Basics—Lesson 5 ♦ [2.058] Student Career Portal—Get Started
121 Participate in the development of a code of ethics for job-specific information systems. Microsoft Imagine Academy Resources: [2.028] Microsoft Digital Literacy: Computer Security and Privacy—Lesson 5
126 Develop a career plan. Microsoft Imagine Academy Resources: [2.061] Student Career Portal—Microsoft Student Career Job Roles
131 Update portfolio, including a résumé in a format suitable for print and online posting. Microsoft Imagine Academy Resources: [2.040] Writing a Great Résumé by Using Microsoft Office Word 2007—Lesson 1 ♦ [2.041] Writing a Great Résumé by Using Microsoft Office Word 2007—Lesson 2 ♦ [2.042] Writing a Great Résumé by Using Microsoft Office Word 2007—Lesson 3 ♦ [2.043] Writing a Great Résumé by Using Microsoft Office Word 2007—Lesson 4