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

Standard 1C - Syllabus

COURSE SYLLABUS

 

School Year:

2017-2018

H.S. Credits:

School Name:

Montgomery County ATC

Program:

Business Education

Montgomery County ATC Course Name:

Microsoft Office Specialist (070750)

Instructor:

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

 

 

 

Prerequisite(s) 

Digital Literacy CIS 101

Or tested out of Digital Literacy CIS 105

 

KDE Course Description -

This course is an extension of Computer and Technology. Students will have the opportunity to increase their computer skills. Advanced functions and integration of Microsoft Word, Excel, Access, and PowerPoint will be taught. Students will work toward MOS Certification in one or more of the Microsoft areas. In addition, students will utilize Internet access to complete various projects. Leadership development will be provided through FBLA.

 

Materials Used

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

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

https://abarker.coursesites.com is used to manage all units/assignments/exam schedules

 

COURSE SYLLABUS and ASSIGNMENT INFORMATION via the Web

 

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

 

 

Students participating in the Dual Credit program should:

  • Have a GPA of 3.0 or higher and a minimum 18 ACT composite score.  A 21 PLAN composite can be used for admission purposes but will need qualifying benchmark scores to come from some other assessment such as KYOTE, Compass or ACT;
  • Have a junior or senior class standing;
  • Meet any course requirements or prerequisites such as ACT scores or increased scores set by the school district;
  • Complete the MSU Early College Application and Registration Form;
  • Follow the policies and procedures of MSU and Montgomery County High School;
  • Attend class on a regular basis;
  • Maintain a HS GPA of 3.0 or higher and a MSU GPA of 2.5 or higher to continue enrolling in MSU classes as an Early College student; and
  • Purchase any required books, educational supplies or materials that are not supplied by district’

 

MSU CATALOG COURSE DESCRIPTION:                                                                  MSU Undergraduate Catalog

Prerequisite: basic computer competency. This course prepares students to be proficient in problem solving through the application of spreadsheet and database tools. In addition, students gain experience with microcomputer hardware, operating systems and file management.

 

MSU TEACHING AND LEARNING:

In this course students solve progressively more-complex problems which require them to understand problem specifications, create applications using the appropriate software, and solve problems that arise while building the solutions.  The instructor participates directly in the student’s work on assignments.  In other words, the instructor provides a weekly guide to the unit(s); responds to student questions in a forum available for review by all students; and provides instruction that illustrates effective practices, strategies and solutions.
 

MSU STUDENT LEARNING OUTCOMES:

Upon successful completion of this course each student should be able to:

  1. Demonstrate proficiency in creating spreadsheet applications to successfully organize and present data and information to meet organizational and business-related requirements.
  2. Demonstrate and apply business application tools to successfully organize and present information to meet organizational and business-related requirements.
  3. Demonstrate competency in using problem solving and analytical reasoning skills related to business processes.
  4. Identify effective design and meaningful interpretation of spreadsheets that solve quantitative problems, evaluate alternative solutions, and introduce what-if analysis for decision making.
  5. Use multimedia (electronic presentation software) to integrate information from various platforms.
  6. Demonstrate the ability to create and design presentations for digital delivery.

     

MSU ACHIEVEMENT of STUDENT LEARNING OUTCOMES

Learning is assessed in weekly assignments and in exams, which directly measure the course outcomes identified.  Refer to: Syllabus, Content Coverage

Student Learning Outcomes

 Course Assignments 

Course Exams

1, 3, 4

Excel Units #1—5, Excel #7

Exams – Excel Level I, Level II, Level III

2, 3

Introduction to Databases

Access Units #1-2,

Exams – Access Level I, Level II and Level III

1,5,2, 6

PowerPoint Presentations Units #1--#3

Exams PowerPoint Level I, Level II and Level III

 

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.

 

KDE Content/Processes

 

Students will:

  1. Use and apply a repertoire of technology skills regularly in the preparation of content assignments and authentic projects.
  2. Utilize Windows Operation System, Internet resources, and industry-standard hardware and software.
  3. Perform advanced functions using Microsoft Word, Access, Excel and Power point.
  4. Create real-world documents and publications using word, access, excel, and power point to demonstrate formatting techniques used in text, graphics, and text boxes.
  5. Insert and modify tables, diagrams and charts.
  6. Create bulleted list, numbered lists, and outlines.
  7. Insert and modify tables, diagrams, and charts.
  8. Insert and modify hyperlinks in all types of documents.
  9. Create new documents and presentations using templates.
  10. Save documents in appropriate formats for different uses.
  11. Insert and format pictures, shapes, and graphics in a power point presentation
  12. Understand how to customize slide templates in a power point presentation.
  13. Create a slide show for an oral presentation.
  14. Demonstrate how to export a presentation to another Microsoft office program.
  15. Enter and edit cell content when using excel
  16. Insert and modify formulas when using excel.
  17. Create, modify, and position diagrams and charts based on worksheet data when using excel.
  18. Apply and modify cell formats and cell styles in excel.
  19. Demonstrate advanced skills to apply financial and database functions to spreadsheets including formulas, data tables, sorting, and queries.
  20. Demonstrate advanced skills using a spreadsheet program to create and work with templates, wizards, and multiple spreadsheets and workbooks.
  21. Create access databases.
  22. Create and modify queries, forms, and reports using access.
  23. Import data to access and export data from access.
  24. Demonstrate how to back up a database.
  25. Identify individual work habits/ethics and explain their importance in the workplace.
  26. Research and analyze career opportunities for an individual that has the MOS/MCAS certification

 

MSU STUDENT LEARNING OUTCOMES:

Upon successful completion of this course each student should be able to:

  1. Demonstrate proficiency in creating spreadsheet applications to successfully organize and present data and information to meet organizational and business-related requirements.
  2. Demonstrate and apply business application tools to successfully organize and present information to meet organizational and business-related requirements.
  3. Demonstrate competency in using problem solving and analytical reasoning skills related to business processes.
  4. Identify effective design and meaningful interpretation of spreadsheets that solve quantitative problems, evaluate alternative solutions, and introduce what-if analysis for decision making.
  5. Use multimedia (electronic presentation software) to integrate information from various platforms.
  6. Demonstrate the ability to create and design presentations for digital delivery.

     

    Grading

    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

     

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

 

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.abarker.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.

 

 

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 365 Fall Semester

Introduction to Coursesites Fall Semester

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

Microsoft Excel 2016: Units 1-6 Fall Semester

Microsoft Word 2016: Units 1-3 Spring Semester

Microsoft PowerPoint 2016:   Units 2-4 Spring Semester

Microsoft Access 2016: Units 1-3 Spring Semester

 

COURSE POLICIES:

 

  1. Attendance is required.  ONLINE This requires working regularly (checking discussions, new assignments, feedback) on the Bb course site and monitoring email daily, for course-related broadcasts or critical information.

Regular attendance is a major contributor to student success in a course.  Students who do not complete their work regularly (weekly) will not be successful in the course.  On our Bb course site, there is a new unit of work assigned each week; it includes homework, deadlines, helpful guides, Bb participation, and feedback.

  1. Students are urged to contact the instructor as soon as they have an interruption in course attendance (illness, job-related, pc-related). 

The instructor will help the student identify campus resources that may assist them with their problems, and where appropriate, the instructor will provide an alternative due date or assignment.

  1. Assignments must be submitted according to the due dates.  Once the correct solution has been released for students, late files are not accepted.  

Assignments are not accepted late unless announced by the instructor, or agreed upon in advance. 

  1. Students should retain a copy of all files (on your PC and/or flash drive) until completion of the semester.

Students may be asked to produce their original file, or to use that file in a later assignment.

  1. Any form of cheating – copying, sharing files, submitting the work of another as your own – is not permitted.  The SAM software has built-in plagiarism detection.

Students who participate in any form of cheating will fail the assignment and/or the course. Information source:
http://www.moreheadstate.edu/dsl/eaglehandbook/?id=1028

 

 

 

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. Students should familiarize themselves with emergency response protocols at: www.moreheadstate.edu/emergency.

 

Academic Honesty:  All students at Morehead State University are required to abide by accepted standards of academic honesty.  Academic honesty includes doing one’s own work, giving credit for the work of others, and using resources appropriately.  Guidelines for dealing with acts of academic dishonesty can be found in the academic catalog.

 

Americans with Disabilities Act (ADA)
Students with disabilities are entitled to academic accommodations and services to support their access and safety needs. The Office for Disability Services in 109-J Enrollment Services Center coordinates reasonable accommodations for students with documented disabilities.  Although a request may be made at any time, services are best applied when they are requested at or before the start of the semester. Please contact Disability Services at 606-783-5188, e.day@moreheadstate.edu, or visit their website at www.moreheadstate.edu/disability for more information.
 

 

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

Contact Us

© 2017 Montgomery County Schools