Business and Marketing Technology: Survey of Business

Recognize and discuss the academic and professional benefits of participating in a CTSO.

Develop employability skills for success in business careers (soft skills).

Develop a plan for marketing yourself.

Demonstrate effective and safe online practices within each of the business and marketing programs of study: Accounting, Banking, Entrepreneurship, Hospitality and Tourism, Management, Marketing, Office Administration, Medical Office Administration, Social Media and Communications, Web Technologies, and Securities, Investments, Risk and Insurance.

Use the features of the operating system for efficient file management and to increase productivity in the workplace.

Develop professional word processing skills.

Revise and enhance documents using basic features.

Create business documents in appropriate format that would be used in the business and marketing programs of study: Accounting, Banking, Entrepreneurship, Hospitality and Tourism, Management, Marketing, Office Administration, Medical Office Administration, Social Media and Communications, Web Technologies, and Securities, Investments, Risk and Insurance.

Employ advanced word processing features.

Develop fundamental spreadsheet skills.

Revise and enchance a spreadsheet. 

Incorporate basic functions and formulas into spreadsheets that could be used in the business and marketing programs of study: Accounting, Banking, Entrepreneurship, Hospitality and Tourism, Management, Marketing, Office Administration, Medical Office Administration, Social Media and Communications, Web Technologies, and Securities, Investments, Risk and Insurance.

Develop basic database skills.

Incorporate basic database features

Use productivity software for communication purposes. 

Develop basic presentation skills.

Create professional presentations in deliverable format.

Employ advanced presentation software skills to create presentations that would be used in the business and marketing programs of study: Accounting, Banking, Entrepreneurship, Hospitality and Tourism, Management, Marketing, Office Administration, Medical Office Administration, Social Media and Communications, Web Technologies, and Securities, Investments, Risk and Insurance.

Develop effective presentation skills that would be used in the business and marketing programs of study: Accounting, Banking, Entrepreneurship, Hospitality and Tourism, Management, Marketing, Office Administration, Medical Office Administration, Social Media and Communications, Web Technologies, and Securities, Investments, Risk and Insurance. 

Explore cloud-computing applications as they relate to word processing, spreadsheets, database, and presentations.

Utilize various cloud storage options that would be used in the business and marketing programs of study: Accounting, Banking, Entrepreneurship, Hospitality and Tourism, Management, Marketing, Office Administration, Medical Office Administration, Social Media and Communications, Web Technologies, and Securities, Investments, Risk and Insurance.

Research the Career and Technical Student Organizations and draw connections between participation and success. Identify and discuss successful professionals and their involvement in either FBLA or DECA.

Discuss and evaluate CTSO activities which reinforce and connect real world application to the curriculum taught in the classroom. Research CTSO competitive events and identify sources to help prepare for success in competitive events.

Demonstrate effective communication skills through writing, speaking, listening and reading

Comprehend and explain the importance of punctuality and attendance.

Describe integrity, ethical leadership, and the importance of these in one’s career and business; evaluate real-world scenarios and discuss the ethical considerations involved in those situations.

Understand the concept of teamwork in the workplace.

Participate in quarterly work skills evaluations (Evaluations should be similar to employee performance reviews used in the workplace)

Understand, explain, and demonstrate the concept and importance of digital presence.

Prepare career-oriented documents and practice related activities, such as a letter of application, resume, follow-up letter, job interview strategies, digital portfolio, etc. Explore and utilize online resume builders and apps. 

Understand and explain the risk (economic and security) viruses and malware, hacking, phishing, and identity theft.

Explain digital citizenship and contrast good and bad digital citizenship.

Describe cyber bullying and discuss ways to prevent it 

Explain the importance of efficient and organized file management.

Create, delete, sort, copy, move, search, and maintain folders, paying attention to hierarchy of main folders and subfolders. 

Move, copy, delete, sort and search for files.

Discuss and utilize primary operating system functions: date/time, notification area, printer status notification, connectivity notification, print screen, calculator, snipping tool (if available), etc.

Apply document formatting such as page numbering, columns, breaks, page alignments, headers & footers, orientations, page size, margins, page setup, themes. 

Apply document formatting such as page numbering, columns, breaks, page alignments, headers & footers, orientations, page size, margins, page setup, themes.

Demonstrate save, save as, save as alternative file types, print all parts of a document; assign file properties, use different document views.

Demonstrate editing features such as cut, copy and paste; drag and drop; find and replace; spelling and grammar check; thesaurus; show/hide formatting marks; keyboard shortcuts.

Manipulate a document using images, text boxes, graphics, symbols, special characters. 

Apply word processing skills to create business documents (e.g., block style business letters, memos, reports, resumes, and cover letters).

Practice desktop publishing skills to prepare business documents (e.g., newsletters, flyers, brochures, business cards, invoice, receipt, greeting card, press release, order form, bill of sale, meeting minutes, etc.) applicable to business and marketing programs of study. 

Create a template from a blank document and use it to create subsequent documents.

Create, format and print envelopes and mailing labels, name tags, inventory tags, etc. 

Apply advanced formatting in documents: hyperlinks, captions, watermarks, borders and shading to paragraphs and documents, citations, protect documents, endnotes/footnotes, bookmarks; add alternative titles/text.

Create and format tables: apply borders and shading, convert text to tables, convert tables to text, use formulas, merge/split cells, etc.

Produce documents using mail merge (expert level).

Identify and locate the parts of the spreadsheet (rows, columns, cells, ranges, worksheets, workbooks)

Categorize the types of data in a spreadsheet (labels, values)

Employ basic formatting such as font, font size, font style and color, format painter, format numbers, cell styles, insert/delete cells, wrap text, cell alignment, etc. 

Design and arrange a worksheet by utilizing formatting features such as insert/delete rows and columns, adjust height and width, merge cells, hide/unhide rows and columns, headers and footers, rename tabs, change worksheet tab color, add/delete a worksheet, copy/move worksheets, views, split and freeze panes.

Demonstrate save, save as, saving alternative file types; file properties.

Use print features such as print all or part of a workbook (print area, print selection, etc.) print titles, print scaling, and page setup.

Demonstrate editing features such as cut, copy, and paste; drag and drop; find and replace; spelling and grammar check; autofill series.

Design a worksheet that contains pictures and other graphics; format pictures and graphics in the worksheet. 

Insert and format charts such as adding/modifying chart elements, adding additional data series, move charts, apply chart layouts and styles.

Distinguish between operators and operands.

Explain and practice the mathematical order of operations and utilize it in creating spreadsheet formulas.

Devise formulas using relative and absolute cell referencing; autofill formulas.

Create spreadsheets as they would be used in each of the business and marketing programs of study, (e.g., income statements, balance sheets, payroll registers, inventory logs, stock portfolio tracking, etc.)

Identify and locate the parts of a database (e.g., tables, forms, queries, reports, data types, fields, records, primary key).

Import and export data from and into a database.

Identify information needs specific to each business and marketing program of study. Discuss ethical, privacy, and even financial concerns involved in managing data.

Construct queries to find specific information (use AND, OR, , =).

Generate reports displaying information in a usable format.

Use an email application, such as Microsoft Outlook, to create and format email messages in a variety of text formats (e.g. RTF, HTML, Plain Text). 

Use productivity software to manage contacts, create distribution lists, and schedule email messages to be sent at a later date. 

Compose email messages that contain attachments.

Employ basic slide formatting features using slide layouts; apply formatting and styles to text; create bulleted and numbered lists; format into columns; insert text boxes, images, and graphics; format background; apply templates; change slide size; alignment, reorder slides.

Utilize save, save as, save as different file types; file properties

Create presentations using integration features such as import slides from an outline and other presentations, create a presentation from an outline in a word processing program, link to a spreadsheet graph, etc. 

Manage and customize file properties.

Use various view and print options; normal view, slide show view, slide sorter view, presenter view; print slides, handouts, notes, outlines, print in color, grayscale, black and white.

Demonstrate consistency and simplicity by incorporating the 7x7 rule, professional style fonts, and appropriate backgrounds to effectively communicate the presentation’s purpose.

Create slide shows that employ appropriate transitions and animations and that use automatic and rehearsed timings.

Use the slide master feature to modify slides. Complete the appropriate lessons/activities in the GCFGlobal PowerPoint Tutorial

Insert slide headers, footers, and page numbers.

Create presentations with hyperlinks that link to other slides and to external files and/or web pages. 

Organize and enhance the planning of presentations using features such as create and rename sections, create and modify slide layouts, modify handout and notes master, insert and review comments, inspect and protect a presentation, export to other formats, configure slide show options, create custom slide shows, reorder animations, and hide/unhide slides. 

Create slideshow with multimedia and graphics such as audio and video, images, charts and tables.

Configure playback options for audio and video. 

Manage images and objects by changing the order/stacking, aligning and group objects.

Deliver effective presentations using proper body language and verbal and written communication techniques.

Prepare a presentation so that it can be presented effectively without the use of a projector, sound, etc. (i.e. know the content, know the audience, be prepared with handouts of presentation)

Discuss and use available cloud computing applications (e.g., Google, Office 365, Prezi, etc.).

Create various projects using cloud applications.

Collaborate with a team to create a cloud based project.

Compare and contrast cloud storage options such as Google Drive, OneDrive, and Dropbox.

Identify apps that can be used to manage time, tasks, and projects. 

Explain the pros and cons of cloud computing and discuss potential security and privacy concerns especially with regards to syncing devices.