Transfers ToNot transferableDescriptionA comprehensive study of the principles and practices of merchandising management of product/services, with emphasis on store location analysis, layout, customer services, buying, sales promotion, consumer credit, and understanding consumer needs and wants. Course includes practical applications related to start-up of a new business and legal constraints of organizing, selling, advertising, consumer relations and personnel practices. Business - Office Technology Administrative Assistant Certificate of Achievement and Associate in Science Program Description This program is designed to develop technical and communication skills required for management support. Computer literacy, keyboarding skills, document formatting, proofreading and grammatical skills, presentation skills, spreadsheet, and organizational skills are emphasized. Ther Certificate of Achievement can be obtained by completing the 18.5 unit major. The Associate in Science Degree can be obtained upon completion the major, general education requirements and electives. All courses for the major must be completed with a minimum grade of C or a P if the course is taken on a Pass/No Pass basis. Students who complete the Administrative Assistant Certificate of Achievement/Associate in Science will be able to: 1.Demonstrate a high degree of competency and a broad knowledge of skills as they relate to general office procedures. 2.Demonstrate mastery of the modern (QWERTY/alphanumeric) typewriting keyboard under timed conditions with established speed and accuracy. 3.Demonstrate professional level document processing skills related to the development, formatting, and use of standard business correspondence. REQUIRED COURSES: .............................................Units (listed in recommended sequence) BUS 092 Business Communication ................................. 3 BUS 097 Work Readiness ............................................. 1.5 BSOT 106 MS Outlook..................................................... 1 CIS 050 Microcomputer Applications ............................. 3 Consult with your counselor for guidance on custom course pathway CIS 066 Microsoft Word .................................................. 3 CIS 073 Microsoft Excel .................................................. 3 OT 054A Beginning Keyboarding A .............................. 1.5 OT 054B Beginning Keyboarding B .............................. 1.5 OT 162 Ten-Key ............................................................... 1 Required Major Total Units: ................................18.5 Medical Administrative Assistant Certificate of Achievement Program Description The goal of this program is to prepare students to enter the health care industry at an entry-level position in two semesters. The Certificate of Achievement can be obtained upon completion of the 20-unit major. All courses must be completed with a minimum grade of C or a P if the course is taken on a Pass/No Pass basis. Program Outcomes Students who complete the Medical Administrative Assistant Certificate of Achievement will be able to: 1.Demonstrate alpha and numeric keyboarding skills at 40 wpm with established accuracy. 2.Demonstrate computer literacy and word processing skills related to formatting business documents. 3.Use medical terminology for human diseases. 4.Demonstrate the differences in medical insurance and explain the duties of a medical office assistant, HIPPA. 5.Demonstrate ability to type medical documents and facility at using medical software such as Medisoft. 6.Employ the necessary soft skills to apply and find employment and keep it. REQUIRED COURSES: ...............................................Units Semester 1: ..............................................................Units NURS 111 Medical Terminology...................................... 3 OT 060 Administrative Medical Assistant........................ 3 CIS 066 Microsoft Word. .................................................. 3 OT 054A Beginning Keyboarding A............................... 1.5 OT 054B Beginning Keyboarding B............................... 1.5 CIS 091 Microsoft Outlook........................................... 1.5 Semester 2: ..............................................................Units BUS 097 Work Readiness. ............................................. 1.5 OT 056 Business Grammar and Proofreading................. 2 OT 061 Health Insurance................................................. 3 Required Major Total Units. ....................................20 BSOT - Office Technology/Business Information Worker BSOT 105 Computer Literacy 1.0 Unit An introduction to computer terminology and fundamental hardware and software applications. Topics include industry standard Microsoft Office (word processing, spreadsheet, and presentation) application programs, file management, email, instant messaging, and internet browsing and searching. BSOT 106 MS Outlook 1.0 Unit Keyboarding 30 wpm and BSOT 105, CIS 001, or CIS 050 Explores personal management software and use of Microsoft Outlook functions. Topics include management of e-mail, organization of contacts, creation and scheduling of events using the calendar, and creating and managing tasks for personal and business use. Customization of Outlook features is also covered. BSOT 110 Keyboarding I 1.0 Unit Covers effective keyboarding skills with an emphasis on building correct touch-typing techniques for alphanumeric, symbol, and punctuation keys. Provides a foundation for developing keyboarding speed and accuracy. Successful completion of this class results in a minimum keyboarding speed of 15 net words per minute on a two-minute timed writing. BSOT 111 MS Word I 1.0 Unit and CIS 001 or CIS 050 Provides an introduction to word processing with Microsoft Word including basic document creation, formatting, and editing. Students create, edit, and format business letters, multiple-page reports, newsletters, and cover letters. This course begins preparation for the Microsoft Office User certification exam for Word. BSOT 112 MS Excel I 1.0 Unit keyboarding 30 wpm and BSOT 105, CIS 001, or CIS 050 Provides a basic understanding of Microsoft Excel beginning with spreadsheet design, creation, revision, formatting, and printing a workbook. Basic formulas, functions, and syntax are introduced along with an introduction to using charts and graphs. Problem solving for Excel solutions is also emphasized. This course begins preparation for the Microsoft Office Certification exam for Excel. BSOT 113 MS Access I 1.0 Unit and CIS 001 or CIS 050 Provides a basic understanding of fundamental relational database design and management. Introduces building and editing basic tables, forms, queries, and reports. This course begins preparation for the Microsoft Office Specialist exam for MS Access. BSOT 114 MS PowerPoint I 1.0 Unit and CIS 001 or CIS 050 Introduces the process of planning, creating, editing, viewing, and printing PowerPoint presentations. Topics include adding text, graphics, and multimedia elements and creating master pages and templates. Integration with other Microsoft programs is also covered. BSOT 120 Keyboarding II 1.0 Unit Covers intermediate keyboarding with correct touch- typing techniques, including alphanumeric, and symbol keyboarding and 10-Key numeric keypad. Skill-building includes introductory formatting of documents using Microsoft Word. Successful completion of this class results in a minimum keyboarding speed of 30 net words per minute on a three-minute timed writing. BSOT - Office Technology/Business Information Worker BSOT 121 MS Word II 1.0 Unit Keyboarding 30 wpm and BSOT 111 Covers an intermediate level of word processing with Microsoft Word, including complex document creation, mail merge, columns, formatting, plus integration with other applications, and collaborating on documents using Microsoft Word. Themes, templates, and styles are also covered. This course continues preparation for the Microsoft Office User Exam for Microsoft Word. BSOT 122 MS Excel II 1.0 Unit Keyboarding 30 wpm and BSOT 112 Provides an intermediate understanding of Microsoft Excel. Analyzing data, working with multiple worksheets and functions, pivot tables, resolving conflicts, tracking changes, data validation, chart formatting, templates, and macros are covered. Problem solving for Excel solutions is also emphasized. This course continues preparation for the Microsoft Office Certification exam for Excel. BSOT 123 MS Access II 1.0 Unit Keyboarding 30 wpm and BSOT 113 Provides an intermediate understanding of database design and management. Advanced Queries, table design, custom forms and reports as well as integration of Access with the web and other programs are covered. This course continues preparation for the Microsoft Office Specialist exam for MS Access. BSOT 124 MS PowerPoint II 1.0 Unit Keyboarding 30 wpm Covers the use of PowerPoint as a tool for designing, producing, and controlling visual elements to build and deliver effective presentations. Topics include creating templates, customizing, protecting, and publishing presentations as well as inserting audio, video, and animations and integrating with other programs. BSOT 125 Adobe Acrobat 1.0 Unit BSOT 105, BSOT 110, and CIS 001 or CIS 050 An introduction to the basic components of Adobe Acrobat software. Topics include creating portable document files (PDF), working with PDF files, annotation and editing of files plus interactive forms. Distribution and management of PDFs is also covered. BSOT 130 Keyboarding III 1.0 Unit 3 minute timed writing Provides advanced keyboarding techniques that build on intermediate touch-typing techniques including alphanumeric, and symbol keyboarding as well as 10- Key numeric keypad. Skill-building includes document production with advanced formatting using MS Word, and individualized remedial drills. Successful completion of this class results in a minimum net keyboarding speed of 45 words per minute on a five-minute timed writing. BSOT 131 MS Word III 1.0 Unit An advanced level of word processing with Microsoft Word, including creation of templates, macros, advanced table formatting, and use of long documents and subdocuments. Customizing and automating work and online forms are also covered. This course completes preparation for the Microsoft Office User exam for Word. BSOT 132 MS Excel II 1.0 Unit Provides an advanced understanding of Microsoft Excel. Financial and what-if analysis, data tables, scenario management, importing and exporting data, enhancing with Visual Basic, sub-routines, modifying default settings, and problem-solving tools are covered. Problem solving for Excel solutions is also emphasized. This course completes preparation for the Microsoft Office Certification exam for Excel. BSOT - Office Technology/Business Information Worker Business - OT - Office Technology 