460100 Technology Design and Applications Revised: 05/07/2013
Edited: 05/21/2013
2012 – 2013
Arkansas Department of Career Education
Model Framework
Course Title: Technology Design and Applications
Career Cluster: Business Management & Administration
/ Secondary – Business/Marketing Technology /Course Number / 460100
Credit / 1
CIP Number / (Program area responsibility to insert CIP code(s)/titles http://nces.ed.gov/ipeds/cipcode/Default.aspx?y=55 )
Grade Level / 9-12
Prerequisite / 377910 Information and Communications Technology or 492120 Computerized Business Applications
Course Type / Core
Teacher Certification / Business
CTSO / FBLA / DECA / Choose an item.
Facility Requirements / http://arkansasfacilities.arkansas.gov/SchoolFacManual.aspx
Industry Certifications / (Program area responsibility to insert web address of certification site(s))
Course Description
This course is designed to prepare students for the transition from school to work. This course was developed to advance and strengthen the skills mastered in the 5th through 8th grades. It includes project based learning in areas of word processing, spreadsheets, database, and presentations. The students will apply tool software skills to business projects and use projects to develop competencies for national certification. The course is designed to provide opportunities for independent and collaborative work. It is a year-long course.
Program Purpose/Structure
The purpose of this course is to meet the technology requirements outlined in the Common Core State Standards (CCSS) adopted by Arkansas. This course is designed to be taught in a computer lab setting.
Laboratory Activities
Click here to enter text.
Special Notes
Click here to enter text.
Career and Technical Student Organization (CTSO)
FBLA, DECA
BAA Link for project/task/activity ideas (http://www.fbla-pbl.org/BAA3/default.asp?p=about)
Performance Indicator 1.1
Identify the critical factors of project management. / Recommended Application/Activity / CCSS Standards / CCTC Standards / National Standards for Business Education
1.1.1 Define the common components of project management: integration, scope, time, cost, quality, resources, communication, risk, and procurement. / · Construct a project detailing the common components and processes of project management, using a brochure, presentation, table, or spreadsheet format.
PROJECT MANAGEMENT PPT ACTIVITY / SL9-10.2
SL9-10.5
SL11-12.2
SL11-12.5
W9-10.8
W11-12.8 / BM-MGT7
CRP11 / MGT11
1.1.2 Define the common processes of project management: initiating, planning, executing, monitoring, and closing.
Performance Indicator 1.2
Investigate current and emerging productivity, collaboration and delivery methods / Recommended Application/Activity / CCSS Standards / CCTC Standards / National Standards for Business Education
1.2.1 Evaluate online resources and software used in business/industry. / · Research and compile a list of productivity tools.
· Research and compile a list of collaboration tools.
· Research and compile a list of delivery methods.
· Research and compile a list of industry certifications.
COLLABORATION, PRODUCTIVITY, DELIVERY METHODS, AND INDUSTRY CERTIFICATIONS PPT ACTIVITY / SL9-10.2
SL11-12.2
R9-10.9
R11-12.7
W9-10.4
W9-10.6
W9-10.8
W11-12.4
W11-12.6
W11-12.8 / BM-MGT1
IT3 / COM1
EPF6
1.2.2 Examine industry certifications/qualifications.
Performance Indicator 1.3
Describe appropriate and responsible behavior in the classroom and the workplace. / Recommended Application/Activity / CCSS Standards / CCTC Standards / National Standards for Business Education
1.3.1 Examine ethical situations encountered in the workplace. / · Develop a code of ethics for the class based on research of actual codes of business/industry.
· Develop a presentation explaining the importance of high ethical standards in the preparation of financial statements and what FBLA/PBL goal that this could tie to (Suggested resource FBLA Business Achievement Award—Business Activity 15). / SL9-10.5
SL11-12.5
L9-10.6
L11-12.6
R9-10.4
R11-12.4
SL9-10.4
SL11-12.4
R9-10.9
R11-12.9
W9-10.6
W11-12.6 / IT4
CRP1
CRP9
IT-WD10 / BL1
ENT8
IT16
1.3.2 Explain intellectual property and copyright as they apply to computing. / · Create posters describing intellectual property issues such as fair use, copyright law, trademark, public domain, royalty-free, plagiarism, etc.
· Research real world cases of ethics violations and present to the class.
· Locate sources for royalty-free and public domain media.
Standard 2.0 Tools for project-based learning using productivity software
Performance Indicator 2.1
Explain the purposes and uses of tables / Recommended Application/Activity / CCSS Standards / CCTC Standards / National Standards for Business Education
2.1.1 Examine various table formats. / · Insert a table with titles/captions into a report.
· Embed a table in a presentation.
· Use mathematical formulas in a table.
· Create a table using online software.
· Export/Import (Integrate) a table to/from various sources.
· Convert a table to text/text to table.
· Export to a pdf.
· Create a nested table.
MLA research paper activity incorporating skills above. / W9-10.2a
W11-12.2a
W9-10.6
W11-12.6 / BM5
BM1
CRP11 / IT6
2.1.2 Discuss the software options for creating a table.
2.1.3 Discuss and design a complex table.
Performance Indicator 2.2
Explain the purposes and uses of forms / Recommended Application/Activity / CCSS Standards / CCTC Standards / National Standards for Business Education
2.2.1 Examine existing forms used in business/industry. / · Create a form using a template.
· Design and create an original form.
· Design, create, and administer an online survey. / SL9-10.1
SL9-10.1a
SL9-10.1c
W9-10.6
W9-10.7
SL11-12.1
SL11-12.1a
SL11-12.1c
W11-12.6
W11-12.7 / BM-MGT7
IT2
CRP11 / IT2
IT6
2.2.2 Discuss the software options for creating a form.
2.2.3 Discuss the design and formatting of forms.
Performance Indicator 2.3
Explain the purpose of a table of contents and an index / Recommended Application/Activity / CCSS Standards / CCTC Standards / National Standards for Business Education
2.3.1 Examine the layout of existing tables of contents and indexes. / · Format a document with appropriate styles to automatically generate a table of contents and index.
Cookbook Activity / SL9-10.1
W9-10.4
W9-10.6
SL11-12.1
W11-12.4
W11-12.6 / CRP2 / IT6
2.3.2 Discuss the software options for creating a table of contents or an index.
2.3.3 Discuss the design and formatting of tables of contents and indexes.
Performance Indicator 2.4
Examine acceptable formats for research projects / Recommended Application/Activity / CCSS Standards / CCTC Standards / National Standards for Business Education
2.4.1 Identify different formatting guidelines for research papers and presentations. / · Create a presentation comparing and contrasting the MLA, APA and Chicago formatting guidelines, citing sources appropriately.
· Format a research paper according to appropriate guidelines, and citing sources appropriately.
**See MLA Report from above.
Purdue Owl Style chart for citation comparisons / R9-10.1
R9-10.9
W9-10.2
W9-10.2a
W9-10.2b
W9-10.2c
W9-10.6
R11-12.1
R11-12.9
W11-12.2
W11-12.2a
W11-12.2b
W11-12.2c
W11-12.6 / CRP2 / IT2
2.4.2 Format sources for a research project.
Performance Indicator 2.5
Examine advanced spreadsheet features / Recommended Application/Activity / CCSS Standards / CCTC Standards / National Standards for Business Education
2.5.1 Examine the formatting features of a professional spreadsheet. / · Prepare a spreadsheet with appropriate formatting, i.e. number formatting, color, fonts, general layout, audience appropriate, alignment, borders, etc.
Holiday Dinner Spreadsheet Activity / W9-10.4
W9.10.6
W11-12.4
W11-12.6 / BM1
BM5
BM-MGT2
BM-MGT8
FN1
CRP11 / IT2
IT7
2.5.2 Examine the appropriate use of charts. / · Critique the use of charts in various media.
· Embed a chart in a document.
· Link a chart to a document.
Modify MLA report to include chart. Discuss difference between embedded and linked charts and which is more appropriate.
2.5.3 Implement mathematical functions and special formatting elements using IF, PMT, LOOKUP, and conditional formatting. / · Format and apply the following features in various spreadsheet projects: IF, PMT, LOOKUP, conditional formatting, and macros.
2.5.4 Explain the benefits of using macros.
2.5.5 Examine how filters are used to extract data. / · Use specific criteria to perform data searches (i.e. spreadsheet, database, online).
· Filter data in a spreadsheet and extract to another document, i.e., text document, another spreadsheet, presentation, email, etc.
Performance Indicator 2.6 Examine the resources for creating presentations / Recommended Application/Activity / CCSS Standards / CCTC Standards / National Standards for Business Education
2.6.1 Discuss the software options for creating presentations. / · Create an online presentation comparing and contrasting the benefits of using online resources vs. traditional resources.
Prezi, Animoto, et. / SL9-10.1
SL9-10.2
SL9-10.4
L9-10.6
R9-10.9
W9-10.2
W9-10.2c
W9-10.2d
W9-10.2e
W9-10.4
W9-10.6
SL11-12.1
SL11-12.2
SL11-12.4
L11-12.6
R11-12.9
W11-12.2
W11-12.2c
W11-12.2d
W11-12.2e
W11-12.4
W11-12.6 / CRP2
CRP6 / IT6
IT8
2.6.2 Investigate types of media to include in a presentation: video, music, hyperlinks, narration and sound effects. / ·
· Create presentations that incorporate the following: video, music, hyperlinks, narration, and sound effects.
·
Music PowerPoint
Group Project: It’s Game Time!
2.6.3 Examine components of a professional presentation. / · Create a presentation on the components of an effective professional presentation using an original design template.
2.6.4 Identify methods for delivering professional presentations. / · Export a presentation in different file formats (i.e., .mov, .pdf, .jpg, etc.).
· Make a presentation to the class and print a handout for the instructor.
· Publish a presentation to the web.
Performance Indicator 2.7 Examine the resources for creating professional websites / Recommended Application/Activity / CCSS Standards / CCTC Standards / National Standards for Business Education
2.7.1 Identify the options for developing and publishing a professional website. / · Research and compile a list explaining the options for designing and creating a website (i.e., writing the code, using web design software, using an online website builders, outsourcing to a professional web designer, and web hosting). / L9-10.6
R9-10.1
R9-10.4
R9-10.7
R9-10.9
W9-10.2d
W9-10.2e
W9-10.4
W9-10.5
W9-10.6
L11-12.6
R11-12.1
R11-12.4
R11-12.7
R11-12.9
W11-12.2d
W11-12.2e
W11-12.4
W11-12.5
W11-12.6 / IT4
IT8
IT-WD2
IT-WD4
IT-WD6
IT-WD7
IT-WD9
IT-WD10
CRP8
CRP6 / IT2
IT3
IT8
IT9
IT11
2.7.2 Examine the features of a website. / · Analyze websites to collect statistics on the following: templates, thumbnails, banner, photo gallery, tables, hover/rollover buttons, forms, image map/hot spots, site map, and hyperlink.
2.7.3 Discuss design considerations and planning steps in developing an effective website. / · Critique websites for effective layout (i.e., ease of navigation, readability, timeliness, browser compatibility, layout, and purpose).
· Develop a navigational structure for a multi-page website using a storyboard or organizational chart.
2.7.4 Construct a multi-page website. / · Create a multi-page website using basic components.
· Publish a multi-page website.
Standard 3.0 Project-based Learning
Performance Indicator 3.1
Apply the basic concepts of productivity software / Recommended Application/Activity / CCSS Standards / CCTC Standards / National Standards for Business Education
3.1.1 Examine career choices and required employment documents. / · Research and prepare a one-page paper on a business career.
· Prepare resume, cover letter, and job application applying for a career of your choice.
· Create an electronic portfolio (Suggested resource FBLA Electronic Career Portfolio Competitive Event).
Cover Letter Format guide
Resume Outline Worksheet
Madison’s Electronic Portfolio / W9-10.2
W9-10.2a
W9-10.2b
W9-10.2c
W9-10.2d
W9-10.2e
W9-10.4
W9-10.5
W9-10.6
W11-12.2
W11-12.2a
W11-12.2b
W11-12.2c
W11-12.2d
W11-12.2e
W11-12.4
W11-12.5
W11-12.6 / CRP2
CRP5
CRP7
CRP10 / CD1
CD2
3.1.2 Examine materials related to business activities. / · Prepare materials for a professional conference including: database for registration, registration form, name tags, program, promotional items, signs, etc.
· Create a business plan (Suggested resource FBLA Business Plan Competitive Event).
· Create a commercial promotional package (Suggested resource FBLA Digital Design and Production Competitive Event).
· Design recruitment materials for a local student organization. Create publications such as posters, brochures, bulletin boards, news release with photos, print ad, podcast, invitations, social media posts, etc.
· Make an oral presentation about a local student organization to your class, the school board or a local civic group.
· Design a multi-page publication, such as a cookbook or handbook, which will include a cover (front/back), table of contents, index and binding. Research the publishing options and compare/contrast the results in a spreadsheet. Choose a publishing option and justify your decision in a presentation to the class. / W9-10.2
SL9-10.2
SL9-10.4
SL9-10.5
L9-10.6
W11-10.2
SL11-12.2
SL11-12.4
SL11-12.5
L11-12.6 / BM3
BM4
BM5
BM-ADM2
BM-ADM3
BM-MGT7 / ENT9
IT8
3.1.3 Develop a research project. / · Create a report that may include table with formulas, styles, bibliography, hyperlinks, mail merge, cover page, table of figures, graphics, exporting to web page (Suggested resource Microsoft IT Academy Word 2010 Capstone Projects).
· Write a one-page report on a service organization in your community and present it.
· Research community service grants that are available and present your findings and any recommendations on grants to pursue.
· Research volunteer organizations or service businesses in or near your community and prepare a written proposal and presentation concerning partnering with them on a project.
· Prepare promotional materials for a local service project, i.e., presentation, flyers, photos, news release, script for PA announcement, T-shirt design, etc.
· Research and create a brochure on a foreign country. Include basic information on the country’s economy, demographics and government. Also include a map of the country as well as the country’s flag. Use the colors of the flag as the color scheme for the project. (Suggested source for information: https://www.cia.gov/library/publications/the-world-factbook/).
· Research and create a travel advertisement about the Future Business Leaders of America National Leadership Conference (FBLA NLC) destination and include the following: facts about the city, how to get around the city, historical information or a map, at least four points of interest, at least four photos of the city, a brief FBLA NLC promotion and other information for the traveler. / W9-10.2
W9-10.6
SL9-10.1c
SL9-10.2
SL9-10.4
SL9-10.5
W11-12.2
W11-12.6
SL11-12.1c
SL11-12.2
SL11-12.4
SL11-12.5 / CRP7
HT-TT1
HT-TT2
HT-TT6
HT-TT7 / MGT8
Glossary
Standard 1.0 Project Management
Project Management – the discipline of planning, organizing and managing resources to bring about the successful completion of specific project goals and objectives
Integration – a project management component that coordinates the various interrelated processes of the project
Scope – a project management component that includes the project details such as the project name and stakeholders. It also include the major objectives of the project as well as the budget (time and money)