MONTOGOMERY CO. ATC
Montgomery Co. ATC Course Name:
Office Administration CIT 130
Course Code 070743
Phone: 859 498 1103 ext. 3115
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.
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.
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.
- 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.
- Demonstrate employability and social skills relative to the career cluster (includes cell phone, Internet netiquette, introductions, and grammar).
- Compose and illustrate an oral report using appropriate visual aids (presentation software, etc.).
- Demonstrate advance computer applications to create, edit, save, revise, and print word processing documents, spreadsheets and related charts, database files, reports, and presentations.
- Show advanced software integration skills to create new documents through the use of word processing, spreadsheets and related charts, database files, reports, and presentations.
- 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.
- Demonstrate advanced skills to utilize the mail merge feature of a software program.
- Demonstrate advanced skills to apply financial and database functions to spreadsheets including formulas, data tables, sorting, and queries.
- Demonstrate advanced skills using a spreadsheet program to create and work with templates, wizards, and multiple spreadsheets and workbooks.
- Demonstrate advanced skills using a database program to create enhanced reports.
- 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.
- Demonstrate advanced skills using word processing, spreadsheet, database, and presentation software to complete workgroup collaboration to include inserting and reviewing comments.
- Research and analyze career opportunities, participate in a job interview, and develop an employment portfolio (letter of application, resume, and follow-up letter).
- Develop FBLA projects using a variety of software applications.
- Utilize activities of FBLA as an integral component of course content, leadership development, and service learning.
- 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
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 email@example.com , 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
- Be on time and organized for class: including materials, books and homework.
- No eating or drinking around any electronic equipment.
- Be responsible for your own work area and equipment. (This means trash too!)
- Follow all school Internet and network rules.
- Use courteous, respectful behavior toward yourself, teachers and classmates at all times.
- Two tardies to class is automatic 30 minute detention.
- 2nd Warning – lose weekly draw for good behavior
- Student Conference after class
- Detention with me before school
- Administration/Parent/Student Conference
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
COURSE SYLLABUS and ASSIGNMENT INFORMATION via the Web
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
- All lab assignments must include an electronically produced student name and assignment identifier.
The instructor specifies how to prepare your assignment’s identification.
- 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