COMPUTERIZED BUSINESS APPLICATIONS CURRICULUM MAP COUNTY LINE HIGH SCHOOL – BUSINESS DEPARTMENT Grade Level: 09-12 Revision Date: August 2013 Content Skills Activities/Assessment Unit 1: Hardware and Software 1.1 Define terminology related to hardware and software. 1.2 Identify hardware components of a computer system 1.3 Identify Operating System Software 1.4 Identify Application Software 1.5 Review file management features Unit 1 Vocabulary Apply terminology related to hardware and software Label and define hardware components of a computer system Explain the care and handling of disks Analyze criteria for purchasing a computer system Explain how to boot the computer system-proper procedures for starting and shutting down Explore new technology Discuss operating system with emphasis on your specific system Use operating system for various functions and applications (e.g., format disk, disk copy, directory, maximize, minimize, etc.) Discuss types of application software Create a folder and document Move and copy a folder Rename or delete folder Introduction to Computers--PPT Understanding Computers--Worksheet Hardware and Software--PPT Hard and Software Game Hardware and Software Review Quiz Set up folders on network drive Computer Basics Worksheet 2 9 3
Microsoft IT Academy Microsoft Office Academy Course (MOAC) Setting up a Mail Merge Executing a Mail Merge MOAC Word Chapter 11: Performing Mail Merges Microsoft IT Academy Microsoft Office Academy Course (MOAC) Arranging Document Views Working with Templates MOAC Word Chapter 12: Maintaining Documents and Working with Templates Microsoft IT Academy Microsoft Office Academy Course (MOAC) Applying Protection to a Document Managing Document Versions Sharing Documents MOAC Word Chapter 13: Protecting and Sharing Documents 7 Microsoft IT Academy Microsoft Office Academy Course (MOAC) Inserting bookmarks into a document Customizing Word Changing Research Options MOAC Word Chapter 14: Using Advanced Options Microsoft IT Academy Microsoft Office Academy Course (MOAC) Combining Word Tools to Create a Project MOAC Word Circling Back 1-4 2nd Article Summary Due CCStandards: Integrate and evaluate content presented in diverse formats and media. SLE Standard Comprehension Students shall apply a variety of strategies to read and comprehend printed material CCS 1, 2, 3, 7 SLE 9.9.8 SLE 9.10.7 SLE 9.11.6 SLE 9.12.7 First Nine Weeks Review/Tests Unit 2 Review AR CBA Unit 2 Word Processing (40 terms) www.studystack.com/flashcard-937221 Quizlet .com StudyStack.com Unit 5: Presentations 5.1 Define terminology related to presentation software 5.2 Create a presentation 5.3 View and print a presentation 3
Microsoft IT Academy Microsoft Office Academy Course (MOAC) Building Charts Formatting Charts with Quick Styles Modifying Chart Data and Elements Manually Formatting a Chart MOAC PPT Chapter 6: Using Charts in a Presentation Microsoft IT Academy Microsoft Office Academy Course (MOAC) Adding SmartArt to a Slide Modifying SmartArt Converting SmartArt to Formats MOAC PPT Chapter 7: Creating SmartArt Graphics Microsoft IT Academy Microsoft Office Academy Course (MOAC) Adding a Picture to a Slide Formatting Graphical Elements Adding Shapes to Slides Organizing Objects on a Slide Creating a Photo Album Presentation MOAC PPT Chapter 8: Adding Graphics to a Presentation Microsoft IT Academy Microsoft Office Academy Course (MOAC) Setting up Slide Transitions Animating your slides Adding clips to a presentation MOAC PPT Chapter 9: Using Animation and Multimedia 2 Microsoft IT Academy Microsoft Office Academy Course (MOAC Working with comments Merging changes from multiple copies of a presentation Protecting a presentation Saving a presentation in different formats Creating a video MOAC PPT Chapter 10: Securing and sharing a presentation Microsoft IT Academy Microsoft Office Academy Course (MOAC Adjusting slide orientation and size Customizing audience handouts Choosing slides to display Rehearsing your delivery Setting up a slide show Working with presentation Broadcasting a presentation Recording a presentation Packaging a presentation for CD delivery MOAC PPT Chapter 11: Delivering a presentation 9 Unit Review AR CBA Unit 5 Presentation (13 www.studystack.com/flashcard-937461 Quizlet .com StudyStack.com
4th Article Summary Due CCStandards: Integrate and evaluate content presented in diverse formats and SLE Standard Comprehension Students apply a variety of strategies to read and comprehend printed material CCS 1, 2, 3, 7 SLE 9.9.8 SLE 9.10.7 SLE 9.11.6 SLE 9.12.7 Semester Exams Units 1, 2, & 5 Vocab Content Skills Activities/Assessment Unit 3: Spreadsheet 3.1 Define terminology related to spreadsheets 3.2 Examine spreadsheet components 3.3 Create and edit a spreadsheet 3.4 Perform mathematical calculations using spreadsheet software 3.5 Illustrate data using a chart/graph Unit Vocabulary Microsoft IT Academy Microsoft Office Academy Course (MOAC) Starting Excel Working in the Excel Window Changing Excel’s View Working with an Existing Workbook Working with Excel’s Help System MOAC Excel Chapter 1: Overview Microsoft IT Academy Microsoft Office Academy Course (MOAC) Accessing and using backstage view Printing with backstage Changing the excel environment in backstage Accessing and using excel templates MOAC Excel Chapter 2: Using Backstage Microsoft IT Academy Creating Workbooks Entering and Editing Data in a worksheet Using Data Types to populate a worksheet MOAC Excel Chapter 3: Working with Microsoft Excel 6
Microsoft Office Academy Course (MOAC) Cutting, copying, and pasting data Editing a workbook’s keywords Saving the Workbook Microsoft IT Academy Microsoft Office Academy Course (MOAC) Inserting and deleting cells Manually formatting cell contents Copying cell formatting with the format painter Formatting cells with styles Working with hyperlinked data Applying conditional formatting to cells Clearing a cell’s formatting MOAC Excel Chapter 4: Formatting Cells and Ranges 5th Article Summary Due CCStandards: Integrate and evaluate content presented in diverse formats and media. SLE Standard Comprehension Students shall apply a variety of strategies to read and comprehend printed material CCS 1, 2, 3, 7 SLE 9.9.8 SLE 9.10.7 SLE 9.11.6 SLE 9.12.7 Microsoft IT Academy Microsoft Office Academy Course (MOAC) Working with rows and columns Using themes Modifying a worksheets onscreen and printed appearance Inserting headers and footers Preparing a document for printing MOAC Excel Chapter 5: Formatting worksheets Microsoft IT Academy Microsoft Office Academy Course (MOAC) Organizing worksheets Working with multiple worksheets Using zoom and freeze to change the onscreen view Finding and replacing data MOAC Excel Chapter 6: Managing worksheets Microsoft IT Academy Microsoft Office Academy Course (MOAC) Ensuring your data’s integrity Sorting data Filtering data Subtotaling data Setting up data in a table format MOAC Excel Chapter 7: Working with Data Microsoft IT Academy Microsoft Office Academy Course (MOAC) Building Basic Formulas Using cell references in formulas Using cell ranges in formulas Summarizing data with functions Using formulas to create subtotals Controlling the appearance of formulas MOAC Excel Chapter 8: Using Basic Formulas and Functions
3 4.4 Create database objects Microsoft IT Academy Microsoft Office Academy Course (MOAC) Getting Started Working in the Access Window Using the On-Screen tools Using the Backstage View Using the Microsoft Office Access help button Defining data needs and types MOAC Access Chapter 1: Database Essentials Microsoft IT Academy Microsoft Office Academy Course (MOAC) Creating a Database Creating a Table Saving a database object MOAC Access Chapter 2: Create Database Tables Microsoft IT Academy Microsoft Office Academy Course (MOAC) Navigating among Records Entering, Inserting, Editing, and Deleting Records Working with primary keys Finding and replacing data Attaching and detaching documents Sorting and filtering data and setting field viewing options within a table Understanding table relationships MOAC Access Chapter 3: Working with Tables and Database Records 7th Article Summary Due CCStandards: Integrate and evaluate content presented in diverse formats and SLE Standard Comprehension Students apply a variety of strategies to read and comprehend printed material CCS 1, 2, 3, 7 SLE 9.9.8 SLE 9.10.7 SLE 9.11.6 SLE 9.12.7 Microsoft IT Academy Microsoft Office Academy Course (MOAC) Modifying a database table Creating fields and modifying properties MOAC Access Chapter 4: Modify Tables and Fields Microsoft IT Academy Creating Sorting and filtering data within a form MOAC Access Chapter 5: Create Forms 4.4.2
Microsoft Office Academy Course (MOAC) Microsoft IT Academy Microsoft Office Academy Course (MOAC) Creating Reports Applying a Theme Working with Reports MOAC Access Chapter 6: Create Reports Microsoft IT Academy Microsoft Office Academy Course (MOAC) Creating a Query Modifying a Query Sorting and Filtering data within a query MOAC Access Chapter 7: Create and Modify Queries Unit Review AR CBA Unit Database (13 www.studystack.com/flashcard-937435 Quizlet .com StudyStack.com Spring Break Microsoft IT Academy Microsoft Office Academy Course (MOAC) Adding Bound and Unbound Controls Defining control tab order Formatting controls Arranging control layout Arranging control alignment, size and position MOAC Access Chapter 8: Use Controls in Reports and Microsoft IT Academy Microsoft Office Academy Course (MOAC) Creating a custom table Using the table analyzer Summarizing table data MOAC Access Chapter 9: Advanced Tables Microsoft IT Academy Microsoft Office Academy Course (MOAC) Creating advanced forms Using application parts to create blank forms Creating a navigation form MOAC Access Chapter 10: Advanced Forms Microsoft IT Academy Microsoft Office Academy Course (MOAC) Defining groups Creating aggregate fields Creating the print layout Using the label wizard MOAC Access Chapter 11: Advanced Reports Microsoft IT Academy Microsoft Office Academy Course (MOAC) Creating crosstab queries Creating a subquery Saving a filter as a query Creating action queries Understanding advanced query modification MOAC Access Chapter 12: Advanced Queries Microsoft IT Academy Creating a chart using the chart wizard Formatting a MOAC Access Chapter 13: Display and Share Data