Course Syllabus

Central Academy of Technology and Arts

Microsoft Office Specialist - Excel Core and Excel Expert

Course Syllabus

School Year 2019-2020

 

Instructor:	Ms. Lingle	Phone:	704-296-3088
Classroom:	Room #117	Email:	beth.lingle@ucps.k12.nc.us
Cougar Time:	Tuesdays/Thursdays 10:17 – 10:47	Tutoring:	Tuesday 8:10 - 8:40 a.m. Thursday 3:30 - 4:15 p.m. Available for appointments.

 

Course Description:  

This curriculum is designed to supplement the content of course 40392: Microsoft Excel 2016 and 40396: Microsoft Excel 2016 Expert. Students will study the program by using the associated Microsoft Imagine Academy course or other available curriculum, including but not limited to resources available on the Microsoft Office website, Microsoft Press books or e-books such as the MOS Study Guides, Microsoft Official Curriculum (MOC) courses, Microsoft Official Academic Curriculum (MOAC) courses. The curriculum extends the learning process to ensure that students have the opportunity to explore all areas of a program pertinent to the corresponding MOS certification objectives, or that have been identified as most important for users to understand, through the completion of individual activities. Through this extended practice, the curriculum provides a significant opportunity for the hands-on program experience that is expected and required of a successful certification candidate or power user. Students in Microsoft Imagine Academies benefit from world-class Microsoft curriculum and cutting edge software tools to tackle real-world challenges in the classroom environment. This class is designed to help you use the newest version of Microsoft Excel interface, commands, and features to present, analyze, and manipulate various types of data. Students will learn to manage workbooks as well as how to manage, manipulate, and format data. Mathematics is reinforced. This curriculum supports students in preparing for Microsoft Office Specialist (MOS) exam 77-727: Microsoft Excel 2016 and 77-728: Microsoft Excel 2016 Expert.

COMPETENCIES AND OBJECTIVES 

	Excel 2016 Core and Expert:  The Learner will be able to:	100%
Unit 1.00	Understand basic and intermediate spreadsheet software skills using Microsoft Excel 2016.	70%
	1.01 Overview 1.02 Working with Microsoft Excel 2016 1.03 Using Office Backstage 1.04  Using Basic Formulas 1.05 Using Functions 1.06 Formatting Cells and Ranges 1.07 Formatting Worksheets 1.08 Managing Worksheets 1.09 Working with Data and Macros 1.10 Using Advanced Formulas 1.11 Securing Workbooks 1.12 Creating Charts 1.13 Adding Pictures and Shapes to a Worksheet
Unit 2.00	Understand advanced spreadsheet software skills to  achieve Microsoft Excel Expert 2016.	30%
	2.01 Managing and Protecting Workbooks 2.02 Applying Custom Formatting and Layouts 2.03 Using Advanced Functions and Analyzing Data 2.04 Working with Advanced Charts and Pivot Tables

 

Assessments and Assignments:  The majority of assessments and assignments will be submitted on our learning platform, Canvas.  Assignments can be submitted a variety of ways including, uploading files, typing into text boxes, and sharing Google documents/presentations.  Students not having used Canvas before should alert the teacher and they will be shown how to submit assignments on Canvas.  Individual assignments will indicate which method of submission on Canvas is expected.  If students need a refresher or have questions, they can access the Canvas Student Guide for specific instructions.  It is the student's responsibility to ensure assignments are submitted on time and to contact the instructor if there is a problem.  The Canvas Learning Platform logs every student log-in on Canvas which provides teachers with a list of when students log-in to Canvas using their user id. 

Canvas Grading: Canvas is used to grade assignments as well, however, the grades in Canvas, while accurate to that assignment, are NOT the teacher’s gradebook.  The teacher’s gradebook includes categories of assignments that may be weighted differently and may include grades for assignments that did not use the Canvas Learning Platform.  Late work that cannot be made up at all is recorded as a 0. If a student has the opportunity to make up work then, the grade is recorded as a 1. 

If the assignment is not turned in the 1 becomes a 0. Therefore, students and parents should always check their student’s true average on the Parent Portal on Powerschool. 

Grading:

1.   Your course grade is based on the following:

                                First 6-week Grading Period         25%

                                Second 6-week Grading Period    25%

                                Third 6-week Grading Period        25%

                                Final Exam                                                25%

2.   Each 6-week grade is based upon:

                                Objective & Performance Tests                                45%

                                Lab Work, Classwork, Projects & Quizzes         40%

                                Practice Tests                                                                      10%                       

                                Portfolio/File Management                                        5%

3. Grading Scale

                                A = 100 - 90

                                B =   89 - 80

                                C =   79 - 70

                                D =   69 - 60

                                F =   60 - and below

School Attendance Policy

• The attendance policy, as well as, other policies outlined in the CATA Student Handbook will be followed.
• If a student is late to class, he/she must report to the office for a tardy pass.

Classroom Attendance Policy: Due to the nature of the classroom environment and this fast paced course, attending class regularly is essential to learning the material. Absent from class: Missed work must be completed no later than 5 school days after the student returns to school to avoid a grade reduction

Tardy to class: Only students with a Tardy Pass will be admitted after the tardy bell rings for first period.

1st/2nd Tardy:  Warning from an administrator in the front office (1st period) and the teacher in the classroom (all periods)

3rd Tardy:  Warning from an administrator in the front office (1st period) and the teacher in the classroom (all periods).  The teacher will contact the parent on the third tardy by phone.  

4th/5th Tardy:  Warning from an administrator in the front office (1st period) and the teacher in the classroom (all periods). The teacher will submit a discipline referral to the administration and 1 day ASD with administration.  The administration will contact the parent.  

6th/7th Tardy:  Warning from an administrator in the front office (1st period) and the teacher in the classroom (all periods).  The teacher will submit a discipline referral to the administration and 2days ASD with administration.  The administration will contact the parent.  

8th Tardy: Warning from an administrator in the front office (1st period) and the teacher in the classroom (all periods).  The teacher will submit a discipline referral to the administration and 3 days ASD.  The administration will set up a parent conference, create a written plan, and possible additional consequences. 

Classroom Rules for Conduct:

1. Come to class on time. You must be INSIDE the classroom when the bell rings to be counted on time.
2. This is a beverage and food free classroom. Students may not bring in food.  This includes plate lunches, drinks, candy, etc. whether opened or not. There is absolutely no food allowed in the classrooms.  
3. Use polite speech and body language. Unkind teasing, profanity and impolite behavior is unacceptable.
4. Respect all property (This includes school, personal and other’s property.
5. Follow all other rules list in the Student CATA Handbook

Course Supplies: I do not list any course supplies as I will provide any necessary equipment. However, students are welcome to bring their own ear buds or head phones. Flash drives, thumb drives and any portable memory devices are not required or wanted in this classroom unless specified for student accommodations.

Internet Usage: Career and Technical Education curricula and 21st Century Skills require students to use many technologies, including the Internet. Each school should have an Internet use policy, and all students should sign the school Internet policy prior to beginning any class that uses such technologies. Students who violate the school’s Internet policy must be held accountable for his/her actions and face appropriate consequences deemed necessary by the school in accordance with the school’s policies.   Teachers must use extreme caution when assigning Internet activities to students. Teachers must preview sites, which can change daily, prior to ANY activity. If the teacher determines a website used in an activity is inappropriate, or students are not mature enough to behave properly and according to the school’s Internet policy, the teacher should make alternate arrangements for completing the activity.

Honor Code: Students will refrain from copying, downloading, or otherwise claiming work of others to be their own. Sharing of flash drives is unacceptable. Students shall not cheat on test/examinations, copy the work of another, download or complete any type of academic assignment in a dishonest or deceptive manner. The work that you submit represents your learning, and so it represents you.  Therefore, your work must demonstrate both your integrity and honor.  These acts are considered cheating and students will be disciplined as such. Anyone caught cheating or plagiarizing on any assignment, from homework to exams, will face strict penalties. Students shall not forge parents/guardians/teachers signatures or make fraudulent use of official school documents.

Computer Lab: The Business and Information Technology Education curricula and 21st Century Skills require students to use many technologies, including the Internet. Each student and parent must sign the school Internet policy prior to beginning any class that uses such technologies. Students who violate the school’s Internet policy must be held accountable for their actions and face appropriate consequences deemed necessary at the school in accordance with the school’s policies. Teachers use extreme caution when assigning Internet activities to students. Teachers preview sites, which can change daily, prior to ANY activity. If the teacher determines that a website used in an activity is inappropriate, or that students are not mature enough to behave properly and according to the school’s Internet policy, the teacher will make alternate arrangements for completing the activity.

After reading Ms. Lingle’s Syllabus and Classroom Procedures Document, please sign, date and return this section below.

______________________________________________________________________________________________________

This is a contractual agreement between me, Ms. Lingle, the student as primary agent and the parent(s) and/or guardian(s) of the student as secondary agents. Your signature below indicates that you have read and understand this document, as stated above, and are committed to adherence and enforcement of said policy.  Please detach this portion, sign, date and return to Ms. Lingle.

Teacher signature __Ms. Lingle________             Date__8-21-2018__

 

Student signature_________________________________          Date____________

 

Parent(s)/Guardian(s) signature_______________________      Date ___________