Business - Office Technology
17 courses · Solano Community College · 2025-2026 Catalog
BSOT 105 Computer Literacy
- Units
- 1
- Hours
- 1 hours lecture weekly, 18 contact hours total
- Advisory
- Keyboarding skills at 30 wpm
- C-ID
- BSOT 105X
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
- Units
- 1
- Hours
- 1 hours lecture weekly, 18 contact hours total
- Advisory
- Keyboarding skills at 30 wpm. and BSOT 105 (Computer Literacy) or CIS 050 (Microcomputer Applications) or CIS 001 (Introduction to Computer Science)
- C-ID
- BSOT 106X
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
- Units
- 1
- Hours
- 1 hours lecture weekly, 18 contact hours total
- Advisory
- BSOT 105 (Computer Literacy)
- C-ID
- BSOT 110X
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
- Units
- 1
- Hours
- 1 hours lecture weekly, 18 contact hours total
- Advisory
- BSOT 105 (Computer Literacy) and BSOT 110 (Keyboarding I) or equivalent skills; Keyboarding 30 wpm. and CIS 001 (Introduction to Computer Science) or CIS 050 (Microcomputer Applications)
- C-ID
- BSOT 111X
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
- Units
- 1
- Hours
- 1 hours lecture weekly, 18 contact hours total
- Prerequisite
- BSOT 105 (Computer Literacy)
- Advisory
- Keyboarding speed of 30 wpm. and CIS 050 (Microcomputer Applications) or CIS 001 (Introduction to Computer Science)
- C-ID
- BSOT 112X
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
- Units
- 1
- Hours
- 1 hours lecture weekly, 18 contact hours total
- Advisory
- BSOT 105 (Computer Literacy) and BSOT 110 (Keyboarding I) and CIS 001 (Introduction to Computer Science) or CIS 050 (Microcomputer Applications)
- C-ID
- BSOT 113X
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
- Units
- 1
- Hours
- 1 hours lecture weekly, 18 contact hours total
- Advisory
- BSOT 105 (Computer Literacy) and BSOT 110 (Keyboarding I) and CIS 001 (Introduction to Computer Science) or CIS 050 (Microcomputer Applications)
- C-ID
- BSOT 114X
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
- Units
- 1
- Hours
- 1 hours lecture weekly, 18 contact hours total
- Advisory
- BSOT 110 (Keyboarding I) and BSOT 105 (Computer Literacy)
- C-ID
- BSOT 120X
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 121 MS Word II
- Units
- 1
- Hours
- 1 hours lecture weekly, 18 contact hours total
- Advisory
- BSOT 111 (MS Word I) and Keyboarding speed of 30 Wpm
- C-ID
- BSOT 121X
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
- Units
- 1
- Hours
- 1 hours lecture weekly, 18 contact hours total
- Advisory
- BSOT 112 (MS Excel I) and Keyboarding speed of 30 wpm
- C-ID
- BSOT 122X
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
- Units
- 1
- Hours
- 1 hours lecture weekly, 18 contact hours total
- Advisory
- BSOT 113 (MS Access I) and Keyboarding speed of 30 wpm.
- C-ID
- BSOT 123X
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
- Units
- 1
- Hours
- 1 hours lecture weekly, 18 contact hours total
- Prerequisite
- BSOT 114 (MS PowerPoint I)
- Advisory
- Keyboarding speed of 30 wpm.
- C-ID
- BSOT 124X
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
- Units
- 1
- Hours
- 1 hours lecture weekly, 18 contact hours total
- Advisory
- BSOT 105 (Computer Literacy) and BSOT 110 (Keyboarding I) and CIS 001 (Introduction to Computer Science) or CIS 050 (Microcomputer Applications) and Keyboarding speed of 30 wpm.
- C-ID
- BSOT 125X
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
- Units
- 1
- Hours
- 1 hours lecture weekly, 18 contact hours total
- Prerequisite
- Keyboarding speed of 30 wpm with 4 errors or less on a 3 minute timed writing.
- Advisory
- BSOT 120 (Keyboarding II)
- C-ID
- BSOT 130X
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
- Units
- 1
- Hours
- 1 hours lecture weekly, 18 contact hours total
- Prerequisite
- BSOT 121 (MS Word II)
- Advisory
- Keyboarding speed of 30 wpm
- C-ID
- BSOT 131X
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 III
- Units
- 1
- Hours
- 1 hours lecture weekly, 18 contact hours total
- Prerequisite
- BSOT 122 (MS Excel II)
- Advisory
- Keyboarding speed of 30 wpm.
- C-ID
- BSOT 132X
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 133 MS Access III
- Units
- 1
- Hours
- 1 hours lecture weekly, 18 contact hours total
- Advisory
- BSOT 123 (MS Access II) and Keyboarding speed of 30 wpm
- C-ID
- BSOT 133X
Covers advanced database design and management. Action Queries, table relationships, and automating tasks with macros are covered. Visual Basic for Applications is introduced to enhance database construction and functionality. Managing replication and synchronization is included.