Text Options for the Visually Impaired Font Size: a- A+ Color: A A A Revert 
Close vision bar
Open vision bar
Integrated Business Applications 2

 

March, 2017

INTEGRATED BUSINESS APPLICATIONS 2 COURSE CODE: 5021

PAGE 6

Microsoft Office 2013, 2016, or higher (MOS) Expert Certification Preparation Course

COURSE DESCRIPTION: This course is designed to provide advanced instruction in Microsoft Office applications that will lead to Core and Expert national certifications. The applications covered include advanced levels of MS Word, MS Excel, MS PowerPoint, and MS Access. Students will learn the features and benefits of the application programs and apply their knowledge in various problem-based and critical thinking activities.

OBJECTIVE: Given the necessary equipment, supplies, and appropriate software, the student will be able to successfully complete the standards necessary for national credentials.

Note: Refer to the www.microsoft.com website to obtain skills standards for each certification exam.

COURSE CREDIT: 1 unit

PREREQUISITE: Successful completion of Integrated Business Applications

1

COMPUTER REQUIRED: one computer per student with Microsoft Office Suite

2013 or higher installed

A. SAFETY

Effective professionals know the academic subject matter, including safety as required for proficiency within their area. They will use this knowledge as needed in their role. The following accountability criteria are considered essential for students in any program of study.

1. Review school safety policies and procedures.

2. Review classroom safety rules and procedures.

3. Review safety procedures for using equipment in the classroom.

4. Identify major causes of work-related accidents in office environments.

5. Demonstrate safety skills in an office/work environment.

B. STUDENT ORGANIZATIONS

Effective professionals know the academic subject matter, including professional development, required for proficiency within their area. They will use this knowledge as needed in their role. The following

March, 2017

PAGE 6

accountability criteria are considered essential for students in any program of study.

1. Identify the purpose and goals of a Career and Technology Student Organization (CTSO).

2. Explain how CTSOs are integral parts of specific clusters, majors, and/or courses.

3. Explain the benefits and responsibilities of being a member of a CTSO.

4. List leadership opportunities that are available to students through participation in CTSO conferences, competitions, community service, philanthropy, and other activities.

5. Explain how participation in CTSOs can promote lifelong benefits in other professional and civic organizations.

C. TECHNOLOGY KNOWLEDGE

Effective professionals know the academic subject matter, including the ethical use of technology as needed in their role. The following accountability criteria are considered essential for students in any program of study.

1. Demonstrate proficiency and skills associated with the use of technologies that are common to a specific occupation.

2. Identify proper netiquette when using e-mail, social media, and other technologies for communication purposes.

3. Identify potential abuse and unethical uses of laptops, tablets, computers, and/or networks.

4. Explain the consequences of social, illegal, and unethical uses of technology (e.g., piracy; illegal downloading; licensing infringement; inappropriate uses of software, hardware, and mobile devices in the work environment).

5. Discuss legal issues and the terms of use related to copyright laws, fair use laws, and ethics pertaining to downloading of images, photographs, documents, video, sounds, music, trademarks, and other elements for personal use.

6. Describe ethical and legal practices of safeguarding the confidentiality of business-related information.

7. Describe possible threats to a laptop, tablet, computer, and/or network and methods of avoiding attacks.

D. PERSONAL QUALITIES AND EMPLOYABILITY SKILLS

Effective professionals know the academic subject matter, including positive work practices and interpersonal skills, as needed in their role. The following accountability criteria are considered essential for students in any program of study.

1. Demonstrate punctuality.

2. Demonstrate self-representation.

March, 2017

PAGE 6

3. Demonstrate work ethic.

4. Demonstrate respect.

5. Demonstrate time management.

6. Demonstrate integrity.

7. Demonstrate leadership.

8. Demonstrate teamwork and collaboration.

9. Demonstrate conflict resolution.

10.Demonstrate perseverance.

11. Demonstrate commitment.

12. Demonstrate a healthy view of competition.

13. Demonstrate a global perspective.

14. Demonstrate health and fitness.

15. Demonstrate self-direction.

16. Demonstrate lifelong learning.

E. PROFESSIONAL KNOWLEDGE

Effective professionals know the academic subject matter, including positive work practices and interpersonal skills, as needed in their role. The following accountability criteria are considered essential for students in any program of study.

1. Demonstrate effective speaking and listening skills.

2. Demonstrate effective reading and writing skills.

3. Demonstrate mathematical reasoning.

4. Demonstrate job-specific mathematics skills.

5. Demonstrate critical-thinking and problem-solving skills.

6. Demonstrate creativity and resourcefulness.

7. Demonstrate an understanding of business ethics.

8. Demonstrate confidentiality.

9. Demonstrate an understanding of workplace structures, organizations, systems, and climates.

10. Demonstrate diversity awareness.

11. Demonstrate job acquisition and advancement skills.

12. Demonstrate task management skills.

13. Demonstrate customer-service skills.

F. ADVANCED MICROSOFT WORD

Business professionals demonstrate efficiency and effectiveness in using advanced word processing software as needed in their role. The following accountability criteria are considered essential for students in Business program of study pursuing MOS Core or Expert certification in Microsoft.

1. Demonstrate usage of shortcut keys/commands.

2. Sort lists, paragraphs, and tables.

3. Create and modify page borders.

March, 2017

PAGE 6

4. Create and modify styles.

5. Create and modify watermarks.

6. Use find and replace with formats, special characters, and non- printing elements.

7. Balance column length using column breaks.

8. Work with master documents and subdocuments.

9. Update a table of contents.

10. Create cross-references.

11. Create and modify an index.

12. Create and modify a table with sorting, styles, and calculations.

13. Import Excel data by embedding and modifying worksheets in a table.

14. Link document with Excel or Access data.

15. Create and modify charts.

16. Create mail merge documents.

17. Sort records to be merged.

18. Merge a document using alternate data sources.

19. Insert a merge field.

20. Finish and merge documents to prepare for printing or e-mailing.

21. Create catalogs and directories.

22. Define, create, apply, edit, copy, rename, and delete a macro.

23. Create online forms.

24. Use advanced text alignment features with graphics.

25. Customize the Quick Access toolbar, status bar, and Word Options.

26. Protect documents.

27. Create bookmarks and captions.

28. Create and modify templates.

29. Create and secure a digital signature.

30. Create a document map.

31. Use the Research task pane.

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

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

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

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

G. ADVANCED MICROSOFT EXCEL

Business professionals demonstrate efficiency and effectiveness in using advanced electronic spreadsheet software as needed in their role. The following accountability criteria are considered essential for students in Business program of study pursuing MOS Core or Expert certification in Microsoft.

1. Discuss shortcut keys/commands.

2. Import and export data to and from other applications.

3. Create and modify templates.

4. Create and modify styles.

March, 2017

PAGE 6

5. Create and modify linked workbooks.

6. Create and modify custom data formats.

7. Create a named range and use in a formula.

8. Use Lookup Functions (Hlookup or Vlookup).

9. Customize the Quick Access toolbar, status bar, and Excel Options.

10.Create custom ribbon or add Developer ribbon.

11. Record, run, and edit macros.

12. Assign a macro to a command button.

13. Work with the Formula Auditing.

14. Trace errors (find and fix errors).

15. Trace precedents (find cells referred to in a specific formula).

16. Trace dependents (find formulas that refer to a specific cell).

17. Apply conditional formatting (creating, editing, and managing rules, multiple conditions).

18. Locate and evaluate valid/invalid data and formulas.

19. Perform multi-level sorts.

20. Consolidate and extract data for data validation.

21. Create and manipulate pivot charts, tables, and reports.

22. Use data analysis and PivotTables.

23. Create interactive PivotTables for the Web.

24. Add fields to a PivotTable using the Web browser.

25. Perform what-if analysis (e.g., Goal Seek and Solver).

26. Create, edit, and remove comments.

27. Apply and remove cell, worksheet, and workbook protections.

28. Create a Workspace or shared workbook.

29. Consolidate data.

30. Track changes (highlight, accept, and reject).

31. Merge workbooks.

32. Structure workbooks using XML.

33. Publish and edit Web worksheets and workbooks.

34. Create complex formulas and functions (e.g., nested functions, time/date math, etc.).

35. Convert data types.

36. Link data across multiple workbooks.

37. Complete a comprehensive electronic spreadsheet project with instructor approval that applies the skills learned in this section, integrating critical thinking and problem solving skills.

H. ADVANCED MICROSOFT ACCESS

Business professionals demonstrate efficiency and effectiveness in using electronic database software as needed in their role. The following accountability criteria are considered essential for students in Business program of study pursuing MOS Core or Expert certification in Microsoft.

1. Demonstrate usage of shortcut keys/commands.

2. Create and name Access databases.

March, 2017

PAGE 6

3. Create and modify tables using datasheet and design views.

4. Define and modify field names, data types, and field properties.

5. Set primary keys.

6. Enter, add, delete, modify, and navigate through records and fields using datasheet and design views.

7. Cut, copy, paste, and paste append data/records.

8. Find and replace data/records.

9. Sort and/or filter records.

10. Define table relationships.

11. Print database relationships.

12. Enforce referential integrity.

13. Create, save, and print queries, forms, and reports using multiple methods.

14. Modify queries, forms, and reports in various views.

15. Use the Control Toolbox to add controls to various objects.

a. Move and modify controls (e.g., font, style, font size, color, and caption).

b. Create and use a Calculated Control on a form and a report.

16. Modify the design of forms and reports in various views.

a. Use form sections (headers, footers, and detail).

b. Use report sections (headers, footers, and detail).

17. Specify criteria and sorts in a query (e.g., using wildcard keys).

18. Create and modify a multi-table select query.

19. Display related records in a sub data sheet.

20. Import and export data to and from Access.

21. Save database objects as file types, i.e. Web page.

22. Publish a database to the Web.

23. Print preview and print database objects.

24. Compact and repair a database.

25. Use the Backstage view.

26. Use the Help feature.

27. Customize the Quick Access Toolbar (QAT).

28. Customize the Mini-toolbar.

29. Customize ribbons.

30. Integrate with other applications to create unique documents.

I. ADVANCED MICROSOFT POWERPOINT

Business professionals demonstrate efficiency and effectiveness in using advanced electronic presentation software as needed in their role. The following accountability criteria are considered essential for students in Business program of study pursuing MOS Core or Expert certification in Microsoft.

1. Demonstrate usage of shortcut keys/commands.

2. Create a new presentation from existing slides.

3. Create a new presentation from existing Word document.

4. Create a presentation using the AutoContent Wizard.

March, 2017

PAGE 6

5. Insert sound and/or music on slides, following copyright laws.

6. Insert video clips on slides, following copyright laws.

7. Create and modify themes.

8. Export an outline to Word.

9. Create and modify action buttons.

J. INTEGRATING SOFTWARE APPLICATIONS

Effective business professionals demonstrate efficiency and effectiveness in using various Microsoft applications to complete tasks that involve critical thinking and problem solving. The following accountability criteria are considered essential for students in Business program of study pursuing MOS Core or Expert certification in Microsoft.

1. 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.

2. 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.

Course Materials and Resources

Course Academic Standards and Indicators