Text Options for the Visually Impaired Font Size: a- A+ Color: A A A Revert 
Close vision bar
Open vision bar



School Year:


 H.S. Credits:







College Credits:


School Name:




Business Education

Montgomery Co. ATC Course Name:

Office Administration CIT 130

Course Code 070743


Angela Barker
Phone:  859 498 1103 ext. 3115

Email: angela.barker@montgomery.kyschools.us
Office Location:  Bldg. 4 Room 402

Office Hours:  8:00 a.m. – 4:00 p.m.

Class website:  https://abarker.coursesites.com




Digital Literacy CIS 105

OST 100/OST 105 Computer & Technology Applications credit or tested out of Digital Literacy CIS 105.


Course Description

This course is designed to provide students an advanced-level of experiences that will propel them into the 21st century business world as they serve in positions such as college interns, administrative assistants, graduate assistants, assistant managers, etc. While using high levels of technology learned in previous classes, students will be taught fundamental business procedures such as records management, human resource management, time management software, workstation management, travel planning, financial reporting, payroll, mail procedures, effective communication skills, and ethical decision making skills. A heavy emphasis will be placed on employability skills. Students should regularly be using word processing, spreadsheet, presentation, database, desktop publishing, and email software.


Materials Used

Students are responsible for: folder (issued by school) & acceptable behavior

Software: Microsoft Office 2016, SAM (Skill Assessment Manager) 2016, GMetrix

Students must safeguard their personal assignment files throughout the semester, protecting against loss or accidental destruction.



Students will:

  1. Identify, describe, and use different types of electronic communications and apply business communications and netiquette skills to create, send, receive, and reply to electronic communication, including e-mail and telephone.
  2. Demonstrate employability and social skills relative to the career cluster (includes cell phone, Internet netiquette, introductions, and grammar).
  3. Compose and illustrate an oral report using appropriate visual aids (presentation software, etc.).
  4. Demonstrate advance computer applications to create, edit, save, revise, and print word processing documents, spreadsheets and related charts, database files, reports, and presentations.
  5. Show advanced software integration skills to create new documents through the use of word processing, spreadsheets and related charts, database files, reports, and presentations.
  6. Demonstrate advanced skills to design, create, edit, save, and print desktop publishing documents which include text, graphics, borders, shadings, watermarks, columns, and nameplates using principles of layout and design.
  7. Demonstrate advanced skills to utilize the mail merge feature of a software program.
  8. Demonstrate advanced skills to apply financial and database functions to spreadsheets including formulas, data tables, sorting, and queries.
  9. Demonstrate advanced skills using a spreadsheet program to create and work with templates, wizards, and multiple spreadsheets and workbooks.
  10. Demonstrate advanced skills using a database program to create enhanced reports.
  11. Demonstrate advanced skills using presentation software to include diagrams, color and graphic modifications, animation schemes, custom backgrounds, action buttons, hyperlinks, sound, video, and speaker notes.
  12. Demonstrate advanced skills using word processing, spreadsheet, database, and presentation software to complete workgroup collaboration to include inserting and reviewing comments.
  13. Research and analyze career opportunities, participate in a job interview, and develop an employment portfolio (letter of application, resume, and follow-up letter).
  14. Develop FBLA projects using a variety of software applications.
  15. Utilize activities of FBLA as an integral component of course content, leadership development, and service learning.
  16. Analyze various hardware, software, operating systems, and emerging technologies used by business and industry, such as speech recognition and personal digital assistants.





90-100 A                                             Daily Assignments:                                         10% of grade

80-89   B                                             Exams/Quizzes:                                               35% of grade

70-79   C                                             Excel, PowerPoint & Access Assignments     55% of grade

60-69   D        

59 below F


Procedures for Makeup Work/Tests

Each student is responsible to complete and submit assignments from any excused absence from class.  See ‘Attendance Policy’ below for definition of ‘excused absence’.  www.angela.barker.coursesites.com is utilized to manage most units and should be consulted first for any missing work.  Mrs. Barker is available for clarification of missed work.  Students are provided the same number of school days absent plus one school day for make-up work to be turned in to the teacher.  It is the student’s responsibility to coordinate make-up time before or after school.  Communication may be made with Mrs. Barker by phone (859) 498-1103 ext. 3115 by e-mail angela.barker@montgomery.kyschools.us , or by appointment M-F 8:00 a.m. to 4:00 p.m.


Attendance Policy/Withdrawal Policy

Students are expected to be in class every day.  An excused absence is defined as any day that the student misses school for reasons outlined by the Student Handbook (doctor or parent note illness, approved school field trip/college visit, etc.).  An excused absence may also occur with permission from Mrs. Barker to participate in a school related activity (FBLA activity or assistance for another teacher) ONLY if the permission is obtained BEFORE start of the class period that the student will miss.  In order to withdraw from class you must obtain an add/drop form from Mrs. Barker and have all required information and signatures completed.



  • No exemptions from Final Exams


Class Expectations/Rules


  1. Be on time and organized for class:  including materials, books and homework.
  2. No eating or drinking around any electronic equipment.
  3. Be responsible for your own work area and equipment. (This means trash too!)
  4. Follow all school Internet and network rules.
  5. Use courteous, respectful behavior toward yourself, teachers and classmates at all times.
  6. Two tardies to class is automatic 30 minute detention.

Class Consequences:


  1. Warning
  2. 2nd Warning – lose weekly draw for good behavior
  3. Student Conference after class
  4. Detention with me before school
  5. Administration/Parent/Student Conference

Course Outline


Introduction to Outlook Live

Introduction to Blackboard

Windows 7 and Internet Explorer:  Essential Concepts and Skills (basic file management, searching for, and saving information, and how to effectively use Internet Explorer)         

Microsoft Word 2016:                                                         

Chapter 2:  Creating a Research Paper with Citations and References

Chapter 5:  Creating a Business Letter with a Letterhead and Table, Cover Letter and Resume


Microsoft Excel 2016:                                                          

Chapter 1:  Creating a Worksheet and an Embedded Chart

Chapter 2:  Formulas, Functions and Formatting

Chapter 3:  What-If Analysis, Charting, and Working with Large Worksheets

Chapter 4:  Financial Functions, Data Tables, and Amortization Schedules

Chapter 5:  Creating, Sorting, and Querying a Table.
Chapter 6:  Working with Multiple Worksheets and Workbooks.
Chapter 8:  PivotTables, PivotCharts, and Trendlines.

Microsoft Access 2016:                                                        

Chapter 1:  Databases and Database Objects:  An Introduction

Chapter 2:  Querying a Database

Chapter 3:  Maintaining a Database

Chapter 4:  Customizing a Database, OLE Objects, and fields with URL’s                                                                              

Microsoft PowerPoint 2016:                                                           

Chapter 2:  Enhancing a Presentation with Pictures, Shapes, and Word Art

Chapter 3:  Reusing a Presentation and Adding Media

Chapter 4:  Creating a Power Point Web Page                                                                                        



Instructional resources, including the syllabus and assignment information with links to data files, are on the course website located at https://abarker.coursesites.com


Campus Safety Statement: 

Emergency response information will be discussed in class.  Students should familiarize themselves with the nearest exit routes in the event evacuation becomes necessary.  You should notify your instructor at the beginning of the semester if you have special needs or will require assistance during an emergency evacuation.


Academic Honesty Policy


  1. All lab assignments must include an electronically produced student name and assignment identifier.

The instructor specifies how to prepare your assignment’s identification. 

  1. Any form of cheating – copying, sharing files, submitting the work of another as your own – is not permitted. 

Students who participate – either as givers or receivers - in any form of cheating will fail the assignment and/or the course.  If you are not sure what constitutes academic dishonesty, read The Student Handbook or ask your instructor.  For example: Copying information from the Internet is plagiarism if appropriate credit is not given.


Accommodations for Individuals with Disabilities and Equal Employment Opportunities (EEO)

The Education Cabinet, the Department for Workforce Investment and the Office of Career and Technical Education does not discriminate on the basis of race, color, national origin, sex, religion, age, or disability in educational services and/or employment.  The Education Cabinet provides, upon request, reasonable accommodations including auxiliary aids and services necessary to afford an individual with a disability an equal opportunity to participate in all services, programs and activities.  To request materials in an alternative format, contact the Civil Rights Compliance Coordinator in OCTE or Norb Ryan at NorbJ.Ryan@ky.gov.  Persons with hearing-and speech- impairments can contact the agency by sing the Kentucky Relay Service, a toll-free telecommunication device for the deaf (TDD).  For voice to TDD, call 1-800—648-6057.  For TDD to voice, call 1-800-648-6056.


The Office of Career and Technical Education does not discriminate on the basis of race, color, national origin, sex, disability, age, marital status, or religion in admission to education programs, activities, and employment practices in accordance with Title VI of the Civil Rights Act of 1964, Title VII of the Civil Rights Act of 1964, Title IX of the Educational Amendments of 1972, Section 504 of the Rehabilitation Act of 1973 (revised 1992), and the Americans with Disabilities Act of 1990 and shall provide, upon request by a qualified disabled individual, reasonable accommodations including auxiliary aids and services necessary to afford individuals with a disability an equal opportunity to participate.


For more information, contact Mr. William Denton, Office of Career and Technical Education, 20th Floor CPT, Frankfort, Kentucky 40601, (502) 564-4286.  Mr. Denton can also be reached through his e-mail address:  WilliamJ.Denton@ky.gov.



______________________________ ___________  ___________________________________ _____

Student Signature                                Date                 Parent/Guardian Signature                            Date



Equal Education and Employment Opportunities M/F/D


Contact Us

© 2018 Montgomery County Schools