COMPUTERIZED BUSINESS APPLICATIONS Curriculum Content Frameworks

(1)

Peggy Wakefield, Program Advisor, Business/Marketing Technology, Arkansas Department of Career Education

COMPUTERIZED BUSINESS APPLICATIONS

Curriculum Content Frameworks

Prepared by

Kathy Woodcock, Conway West High School

Tim Johnston, Program Advisor, Business/Marketing Technology, Arkansasa Department of Career Education LaTrenda Jackson, Program Advisor, Business/Marketing Technology, Arkansas Department of Career Education

Carla James, Batesville High School

Edited by

Jim Brock, Program Manager, Business/Marketing Technology, Arkansas Department of Career Education

Please note: All assessment questions will be taken from the knowledge portion of these

frameworks.

Ginger Fisher, Program Advisor, Business/Marketing Technology, Arkansas Department of Career Education Jimmy Stroud, Hector High School

Michael Lentz, Marmaduke High School

Di i t d b

Arkansas Department of Career Education Career and Technical Education

Development/Revision Began: 4/12/2010 Placed on the Web:

Disseminated by

(2)

Page

Unit 1: Hardware and Software ₁

Unit 2: Word Processing

2

Unit 3: Spreadsheet ₄

Unit 4: Databases

5 Course Description: Computerized Business Applications is a two-semester course designed to prepare students with an introduction to business applications that are necessary to live and work in a technological society. Emphasis is given to hardware, concepts, and business uses of applications. The business applications covered are word processing, database, spreadsheet, telecommunications, presentation, and Web page design.

Table of Contents

COMPUTERIZED BUSINESS APPLICATIONS

Curriculum Content Frameworks

Grade Levels: 9, 10, 11, 12 Course Code: 492120

Prerequisite: Keyboarding

Unit 5: Presentations ₆

Unit 6: Integrating Software

7

Unit 7: Telecommunications ₈

Glossary

(3)

1.1 1.1.1

1.2 1.2.1

1.2.2

1.2.3

1 3 1 3 1

Knowledge Application

Discuss operating system with emphasis Identify Operating System

Identify hardware components of a computer system

Foundation

Hours: 3

Unit 1: Hardware and Software

Foundation Apply terminology related to hardware and

software Define terminology related to

hardware and software

CAREER and TECHNICAL SKILLS What the Student Should be Able to Do

ACADEMIC and WORKPLACE SKILLS

Terminology: Application software, Central Processing Unit (CPU), File management, File type, Input device, Logon/Login, Memory, Operating system, Output device, Peripheral, Save, Save As, Storage device, System software, System unit

Explain the proper procedures for starting and shutting down the system unit

What the Instruction Should Reinforce

Skill Group Skill Description

Explain the care and handling of storage devices

Label and define hardware components of a computer system: System unit and Peripherals Thinking 1.3 1.3.1 1.4 1.4.1 1.5 1.5.1 1.5.2 1.5.3 1.5.4 Thinking Review file management

features

Create a folder and document Move and copy a folder

Thinking

Identify Application Software Foundation

Discuss operating system with emphasis on the specific system used in classroom.

Foundation

Rename or delete folder Identify Operating System

software

Thinking Foundation Personal Management

Identify application file types: Word processing, Spreadsheet, Database, Presentation

Discuss types of application software: Word processing, Spreadsheets, Database, Presentation, E-mail, Accounting

Computerized Business Applications 1

(4)

2.1 2.1.1

2.2 2.2.1

2 2 2 Knowledge

Foundation Review business document formats:

Letter, Memo, Report, and Table

Thinking

Unit 2: Word Processing

Hours: 40

Define terminology related to word processing

Apply terminology related to creating a word processing document

Foundation Listening

CAREER and TECHNICAL SKILLS

What the Student Should be Able to Do What the Instruction Should Reinforce

Skill Group Skill Description

Edit a document using basic features:

Listening Speaking Open/Create and edit one-page

and multipage documents

Application

Terminology: Alignment, Ascending, Automatic Page Break, Borders, Bullets and Numbering, Clip Art, Columns, Copy and Paste, Cut and Paste, Descending, Desktop Publishing, Drag and Drop, Edit, Find and Replace, Font, Footer, Format, Graphic, Header, Indent, Landscape Orientation, Line Spacing, Manual Page Break, Margins, Point Size, Portrait Orientation, Print Preview, Shading/Fill, Sort, Spell Check, Tab Stop, Table, Template, Thesaurus, View, Word Processing, Word Wrap, Wrap Text, Word/Text Art

Personal Management

Responsibility Writing

Seeing Things in the Mind's Eye

2.2.2

2.2.3

2.2.4

2.2.5 Examine onscreen document layouts (View); Save, preview, and print document

Thinking Creative Thinking

Format document layout: Margins, Alignment (Left, Rght, Center, Justified, Top, Bottom), Indent, Tab Stops (Left, Right, Center, Decimal), Line Spacing, Paragraphs, Page Breaks

Use advanced features: Borders and Shading, Bullets and Numbering, Table, Template, Header, Footer, Sort

Edit a document using basic features: Font, Point Size, Copy and Paste, Cut and Paste, Drag and Drop, Find and Replace, Spell Check, Thesaurus

(5)

2.3 2.3.1

2.3.2

Speaking Create a document using desktop

publishing features: Clip Art, Graphics, Columns, Word/Text Art

Discuss desktop publishing Examine desktop publishing documents: Newsletter, Flyer, Brochure

Foundation Listening

Knowledge Application Skill Group Skill Description

ACADEMIC and WORKPLACE SKILLS CAREER and TECHNICAL SKILLS

(6)

3.1 3.1.1

3.2 3.2.1

3.2.2

3.3 3.3.1

3.3.2

Unit 3: Spreadsheet

Hours: 40

Foundation Define terminology related to

spreadsheets

Foundation Knowledge

Create and edit a spreadsheet

Open a spreadsheet Application

Examine spreadsheet components

What the Instruction Should Reinforce Skill Group

Apply terminology related to spreadsheets

Edit and format a spreadsheet: alignment, fill freeze sort

Enter data in a spreadsheet: labels, values, text

Identify the parts of a spreadsheet: active cell, cell, cell reference, column, label, range, row, value, workbook, worksheet

Terminology: Absolute cell reference, Active cell, Alignment, Argument, Ascending, Autosum, AVERAGE, Cell, Cell reference, Chart/Graph, Column, Column chart, COUNT, Descending, Fill, Format, Formula, Freeze, Function, Label, Line chart, MAX, MIN, Mixed cell reference, Operand, Operator, Order of operation, Pie chart, Range, Relative cell reference, Row, Sort, Spreadsheet, SUM, Value, What-if analysis, Workbook, Worksheet

Foundation

Skill Description

CAREER and TECHNICAL SKILLS What the Student Should be Able to Do

3.3.3

3.4 3.4.1

3.4.2

3.5 3.5.1 Thinking

3.5.2 Edit and print a chart/graph

Create mathematical functions: SUM, AVERAGE, COUNT, MAX, MIN

Create mathematical formulas using cell references: operators, operands, order of operations, absolute reference, relative reference, mixed reference

Use spreadsheet data to create a chart/graph: line, pie, column Illustrate data using a

chart/graph

View and print a spreadsheet

Perform mathematical

calculations using spreadsheet software

(7)

4.1 4.1.1

4.2 4.2.1

4.2.2

4.3 4.3.1 Name and save a database file

4.3.2

4.3.3

4 4 4 4 1

Examine database components Open a database

Create and edit a database file

Enter and edit data in a table

Create database objects Generate and run a query

Identify database parts: field, record, primary key, table

Design a database table: field name, data type

Unit 4: Databases

Hours: 15

Terminology: Ascending, Database, Data type, Descending, Field, Field name, Form, Primary key, Query, Record, Report, Sort, Table

Define terminology related to databases

Apply terminology to create a database document

Thinking

Skill Group Skill

Foundation CAREER and TECHNICAL SKILLS

Foundation Foundation Thinking

Personal

Description

4.4 4.4.1

4.4.2

4.4.3 Thinking

Enter and display data in a form Produce a report

Create database objects Generate and run a query Personal

Management

(8)

5.1 5.1.1

5.2 5.2.1

5.3 5.3.1

CAREER and TECHNICAL SKILLS ACADEMIC and WORKPLACE SKILLS

Plan and format a presentation: transitions, graphics, animations, design template/theme, slide layout

Thinking Thinking

Skill Description

Unit 5: Presentations

Hours: 20

Terminology: Animation, Design template/Theme, Graphic, Handouts, Normal view, Notes page, Outline view, Placeholder, Presentation, Slide layout, Slide show view, Slide sorter view, Transition

Define terminology related to presentation software

Knowledge Application Skill Group

Create a presentation

View and print a presentation Use various view and print options: slides, handouts, notes, outlines, normal view, slide show view, slide sorter view

Foundation Use terminology related to presentation

software

Thinking Foundation

(9)

6.1 6.1.1

6.2 6.2.1

Unit 6: Integrating Software

Hours: 5

Terminology: Destination/source file, Embedded file, Integration, Linking, Merge

Define terminology related to integrating software

Foundation

Thinking

Description

Thinking Use terminology related to integrating

software

Skill Group Skill

Explain software integration Create a merged document: letter, memo Foundation

(10)

7.1 7.1.1

7.2 7.2.1 Access and explore available resources Foundation

through the Internet

Thinking Explain the Internet

Unit 7: Telecommunications

Hours: 3

Terminology: Electronic mail (e-mail), Fax, Internet, Intranet, Local Area Network (LAN), Network, Online, Protocol, Stand alone, Telecommunications, Uniform Resource Locator (URL), World Wide Web (WWW)

Define terminology related to telecommunications

Foundation

Knowledge Application Skill Group Skill

Use terminology associated with telecommunications

Thinking

(11)

1.

2.

3.

4.

5 Input device – data entered into the computer through a variety of devices such as a keyboard, microphone, scanner, flash drive, or mouse

6.

7

8.

Unit 1: Hardware and Software

File management – A program on a computer that allows the user to create, edit, view, print, rename, copy, or delete files, folders, or an entire file system

Central Processing Unit (CPU) – executes commands from a computer's hardware and software; the principal computer chip that contains several processing components, which determines the computer's operating speed; the "brain" of a computer

Memory - computer chips that store data and programs while the computer is working; often called RAM or Random Access Memory

Glossary

Application software – computer software created to allow the user to perform specific a job or task Examples: Word processing, Spreadsheets, Database, and Graphics software

i.e., Word files end in .doc and Excel files end in .xls

File type – an extension at the end of a file name, indicating which application was used to create a document

Logon – the action of gaining access to a computer or a network by entering a username and password; also called Login/Sign In

Operating system - system software that acts as a "go-between", allowing computer hardware and other software to communicate with each other

9.

10.

11.

12.

13.

14.

15.

Storage device – external hardware used to store and retrieve data, such as a disk drive, CD/DVD drive, flash drive, or tape drive

System unit – a computer case that contains the CPU, power supply, memory, and storage Examples: BIOS, Microsoft Windows, Mac OS X, Linux, or utility software

System software – software responsible for the general operation of a computer system, including the operation of hardware, running application software, and file management

Output device – allows the user to view or listen to the data a computer processes such as a monitor, printer, headphones, or speakers

Peripheral – additional hardware that isn't necessary for a computer to function, but does enhance how the computer can be used

Save – storing data for later use

Save As – a feature that allows the user to change the attributes of a file (such as location, file name, or file type) before saving it Examples: Scanner, Webcam, Computer joystick

Computer Business Applications 9

(12)

1.

2.

3.

4.

5.

6.

7.

8.

9.

Ascending – sort order arranging text or numbers from A to Z, from smallest to largest, or from earliest to latest

Unit 2: Word Processing

Automatic Page Break – a feature that automatically generates a new page, allowing text to flow to the new page when space runs out on the previous one; also known as a Soft Page Break

Borders – lines around the edge(s) of text, a page, a cell, or a table

Bullets and Numbering – a feature in a word processing application that allows the user to create outlines or itemized lists with either icons or numbers

Cut and paste – a feature that allows a user to select text or a graphic, remove it from its current location and place it in another location within a document

Copy and Paste – a feature that allows a user to select text or a graphic, duplicate it and place it in another location within a document Alignment – how the edges of a line, paragraph, object, or table are positioned horizontally and vertically between the margins or on a page

Clip Art – a feature that includes pre-made illustrations, drawings, pictures, and other graphic that can be inserted into a document

Column – one of two or more vertical sections of printed material on a page; usually separated by margins

10.

11.

12.

13.

14.

15.

16.

17.

Descending – sort order arranging text or numbers from Z to A, largest to smallest, or latest to earliest

Drag and Drop – a feature that allows a user to select text using a mouse or pointing device, and quickly move (drag) it to a different location

Edit – to make changes by adding, deleting, or modifying text, graphics, or other items in a document

Font – the size, style, and design of text

Format – in word processing, to utilize features that enhance the appearance and overall layout of text, graphics, tables within a document

Desktop publishing – through the use of a personal computer, combining text and graphics to produce a high-quality documents, such as newsletters, flyers, brochures, etc.

Footer – text appearing at the bottom of each page, separate from the main body of a text

Find and Replace – a feature that scans a document, searches for occurrences of specific text, symbols or formatting, and allows a user to replace it with new text, symbols or formatting

(13)

21. 22. 23. 24. 25. 26. 27. 28. 29. 30. 31.

32. Tab Stop – a formatting feature that allows the user to control where a line of text will be entered and how the text will be aligned; so that when the tab key is pressed, the insertion point will move to that location

Print Preview - a feature that allows the user to view a document onscreen and make necessary formatting changes prior to printing it

Point size – the measurement, or size of a font (text); each point is approximately 1/72 of an inch

Portrait Orientation – a page layout in which documents are printed across the width of a page, making the page taller than it is wide

Shading/Fill – the background color of a cell, table, or page

Sort – to arrange a list alphabetically (text) or numerically (numbers), in ascending or descending order Line spacing – the amount of space between lines of text

Manual Page Break – a page break the end user forces into a document, creating a new page at a specific location; also known as a Hard Page Break

Margins – the white space surrounding the content of a page at the top, bottom, left and right sides, defining where a line of text begins and ends

Spell Check – a feature used to automatically locate and correct spelling errors

Indent – to move text horizontally away from the left or right margin, setting it apart from surrounding text

Landscape orientation – a page layout in which documents are printed across the length of a page, making the page wider than it is tall

33. 34. 35. 36. 37. 38. 39. 40.

Example: Normal view, Page Layout, Web Layout, etc. key is pressed, the insertion point will move to that location

Table – a set of data arranged in a grid of rows and columns

Thesaurus – a feature that allows the user to view synonyms and antonyms, and automatically replace words for enhanced writing

View - a feature that allows the user to view the current page of a document onscreen in a different ways

Template – a feature that includes pre-made documents that allow the user to fill-in-the blanks to create new documents, such as calendars, invoices, reports, resumes, etc.; enhances user's efficiency and creativity

Word processing – the use of software application to create, edit, format, print and save text-based documents, such as letters, reports, and memos

Wrap Text - a feature that allows text to be included with pictures, shapes, or tables without covering or hiding under the image, giving the user control over how the text is position

Word Wrap – also called a soft return; a feature that automatically moves text to the next line when the previous line is full without the user pressing the enter key

Word/Text art – text created as a graphic image

Unit 3: Spreadsheet

Computer Business Applications

11

(14)

1.

2. Active cell – a selected worksheet cell that is ready for data entry

3. Alignment – the position of data within a cell

4. Argument – value, cell reference, range, or text that acts as an operand in a function formula

5.

6. Autosum – a function that automatically adds the values in the cells directly above or to the left of the active cell

7. AVERAGE – returns the average (arithmetic means) of its arguments

8. Cell – the space formed by the intersection of a row and a column; the basic unit of a worksheet

9. Cell reference – a unique identifier for a cell which is formed by combining the cell's column letter and row number

10. Chart/graph – a graphic representation of values and their relationships: pie, line, column, bar, scattered

11. Column – a vertical group of cells in a worksheet identified by letters

12. Column chart – a chart that uses bars of varying height to illustrate values in a worksheet

13 COUNT returns the number of cells in a range that contains numbers

Ascending – sort order arranging text or numbers from A to Z, from smallest to largest, or from earliest to latest Absolute cell reference – cell reference that does not adjust to the new cell location when copied or moved

13. COUNT – returns the number of cells in a range that contains numbers

14.

15. Fill – to copy a cell's contents and/or formatting into an adjacent cell or range

16. Format – arranging the shape, size, type, and general makeup of a cell or group of cells

17. Formula – an equation that calculates a new value using values currently on a worksheet

18. Freeze – keeps selected rows or columns visible on the screen as the rest of the worksheet scrolls

19. Function – a prewritten formula that makes it easy to perform common calculations

20. Label – alphanumeric text that will not be used in calculations

21. Line chart - a chart that uses points connected by a line to illustrate values in a worksheet

(15)

26. Operator – a symbol that indicates what mathematical operation to perform on the operands: plus (+), minus (-), multiply (*), divide (/)

27. Order of operation – the mathematical rules used for calculating the value of a formula

28. Pie chart - a chart that shows the relationship of a part to a whole

29.

30. Relative cell reference – cell reference that adjusts to a new location when copied or moved

31. Row – a horizontal group of cells in a worksheet identified by numbers

32.

33. Spreadsheet – a grid of rows and columns containing numbers, text, and formulas used to perform calculations

34. SUM – adds all the numbers in a range of cells

35. Value – numeric characters that can be used in a calculation

36. What-if analysis – process of changing values in cells to see how those changes affect the outcome of formulas in the worksheet

37. Workbook – a collection of related worksheets

Range – selected group of cells on a worksheet identified by the cell in the upper left corner and the cell in the lower right corner, separated by a colon

Sort – to arrange a list of words or numbers in ascending or descending order

38. Worksheet – the workspace made up of columns and rows where data is entered to create an electronic spreadsheet

(16)

1.

2.

3.

4.

5.

6.

7.

8.

9.

10.

11.

Unit 4: Databases

Query – a question presented in a way that allows the database to process and generate specific data from one or more tables Primary key – a field that uniquely identifies a record in a table

Form – a database view that allows the user to see all fields for one record and enter them one at a time

Record – a collection of fields that appear as a row in a database or table

Report – a document that uses data from tables and/or queries; the user controls which items in the database will apear in the report and how it is Ascending – sort order arranging text or numbers from A to Z, from smallest to largest, or from earliest to latest

Field name – a name that identifies a field

Data type – indicates the type of data that can be stored in a field

Descending – sort order arranging text or numbres from Z to A, from largest to smallest, or from latest to earliest Database – a collection of organized data that allows access, retrieval, and use of data

Field – a single characteristic of data that appears in a table as a column

12.

13. Table – a database view of information arranged in a grid of rows and columns Sort – to arrange a list of words or numbers in ascending or descending order

Report a document that uses data from tables and/or queries; the user controls which items in the database will apear in the report and how it is filtered or sorted

(17)

1. Animation – the way text and objects move on and off a slide during a slide show

2. Design template/theme – prepared designs that can be applied to presentation slides that include patterns, formatting, and color schemes

3. Graphic – an image or object created or inserted into a document that illustrates the text or makes the page more attractive

4.

5. Normal view – the default view in a presentation, which contains the slide pane, the outline pane, the task pane, and the notes pane

6. Notes page – printouts that contain the slide image in the top half of the page and the speaker's notes in the lower half of the page

7. Outline view – a view that displays text in an outline format

8. Placeholder – a boxed outline on a slide that can be used to insert text or an object when clicked

9. Presentation – an application that allows the user to create and save slides to use as a slide show

10. Slide layout – the arrangement of placeholders on a slide

Handouts – a print option that allows you to choose the number of slides displayed per page and places a thumbnail, or small picture, of each slide on the page

Unit 5: Presentations

11. Slide show view – runs slides as they will appear during a presentation

12. Slide sorter view – a view that displays all slides simultaneously in miniature form

13. Transition – a feature that can be applied in presentations to control the way slides move on and off the screen

(18)

1. Destination/source file – the file that an object is embedded in or linked to

2. Embedded file – a file that becomes part of the current file but is a separate object that can be edited using the application that created it

3. Integration – the sharing or combining of data between applications

4. Linking – placing a copy of an object or data in a destination file that will update when changes are made to the source file

5. Merge – a feature that combines a data document with a main document to mass produce personalized letters or other documents

(19)

1. Electronic mail (e-mail) – transmission of messages and files using a computer network

2. Fax – a document generated by using a facsimile machine

3. Internet – a vast network of computers linked to one another

4. Intranet – a company's private network of computers

5. Local Area Network (LAN) – a computer network that covers a small area

6. Network – computers that are connected to each other

7. Online – computers that are connected and ready to receive and/or transmit data

8. Protocol – the rules that must be observed for two electronic devices to communicate with each other

9. Stand alone – a computer that is not connected to a network

10. Telecommunications – transmitting information and communicating electronically

11. Uniform Resource Locator (URL) – Internet address that identifies hypertext documents

Unit 7: Telecommunications

( ) yp

12. World Wide Web (WWW) – a system of computers that share information by means of links on web pages