Course Syllabus

Jump to Today

B20 Honors Microsoft Excel

 Mrs. Patti Griffin ~ Room 117

Course Syllabus

 

Email: patti.griffin@ucps.k12.nc.us

Phone: 704-296-3088

 

Planning: 2nd block

Tutoring Hours: Fridays 11:00 in MS Teams 

Office Hours: Fridays 9 am - 12 noon

Course Overview

By completing Honors Microsoft Excel, students will be able to:

  • Optimize the ways you organize ideas and information
  • Gain valuable insights into the ways you can filter and present data
  • Create spreadsheets that deliver their targeted data to the intended audiences clearly and effectively
  • Apply Microsoft Excel 2019 to improve personal productivity and be ready to use Excel in the world of work and life beyond school
  • Create and work with Excel spreadsheets to improve the ways ideas and information are organized, gain valuable insights to filter and present data, and create spreadsheets that clearly and effectively deliver targeted data and computations to the intended audiences
  • Prepare for the MOS certification exam

 

Course Outline

(Part 1)

   Module 1 – Introduction

   Module 2 - Managing worksheets and workbooks

   Module 3 - Formatting cells

   Module 4 - Managing tables and range data

   Module 5 - Using formulas and functions

   Module 6 - Getting and transforming data

   Module 7 - Visualizing data

   Module 8 - Preparing to print and checking for issues

   Certification Exam (Students must qualify for this exam by completing work and earning an 80 or better on two Practice Tests).  More info below.

(Part 2, Expert)

Module 1 – Managing and formatting data

Module 2 – Using advanced formulas

Module 3 – Validating and auditing data

Module 4 – Analyzing data

Module 5 – Using simple macros

Module 6 – Using Microsoft PivotTables and Microsoft PivotCharts

Module 7 – Collaborating with other people

Certification Exam (Students must qualify for this exam by completing work and earning an 80 or better on two Practice Tests).  More info below.

 

 

All course work will be using the web-based platform, TestOut (LabSim).

Grading:

50% ~ Homework & Classwork (Class Work may include in text practice, group work, worksheets, outside reading, or other assignments aimed at providing extra practice and reinforcement of the ideas covered in class).

50% ~ Section Quizzes, Labs, Tests

     Certification Exam will count as two test grades.  Students must earn 80& or better to receive the certification.

      Final Exam is 25% of course grade

  • All work is expected by its due date; however, late work will be accepted up to one week from its due date. Late work will result in a 10 point penalty. 
  • Report Cards every 6 weeks and Progress Reports around week 3, 9, 15. Canvas & TestOut is used to grade assignments as well, however, the grades in these platforms, 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. Therefore, students and parents should always check their child’s true average on the Parent Portal on Powerschool.

 

Internet Policy

Students will use the school network and Internet on a daily basis to access instructional websites and project resources. All students are expected to abide by the UCPS Acceptable Use policy (page 62 of the UCPS High School handbook) when using the school network. The streaming of audio and/or video, playing games on the computer without permission, the use of chat rooms, social media, YouTube, instant messenger, email, proxy servers or using the Internet for non-educational purposes is prohibited (page 75 of the UCPS High School handbook). Violations will result in disciplinary action.

 

Work Ethic

Work Ethic is a set of values based on character and hard work.  Now is the time to develop these skills, such as honesty & integrity, attendance & punctuality, productivity, attitude, appearance, organizational skills, and team work.  Please make good choices and refresh yourself with the Honor Code in the UCPS High School Handbook (page 39).  Cheating and plagiarism will not be tolerated. 

“Winners never cheat and cheaters never win.” ~ Jon M. Huntsman Sr.

 

Classroom Procedures & Expectations

Entering Classroom

1.     Enter through designated door & sit at your assigned student desk/computer. 

2.     Read board & be ready when class starts.

Questions/Help

1.     Always read instructions before asking for help.

2.     Ask your neighbor if the teacher is with another student

3.     When using Microsoft Teams (virtual) use the raise hand option or chat your question.

Equipment

*All computers are the property of UCPS; therefore, you are expected to use proper care.

1.     Use only the equipment assigned to you.

2.     Leave computer settings alone, they are not to be changed.

3.     Handle equipment with extreme care, you may be held responsible for repairs.

4.     Check your computer at the beginning of class and let me know immediately if something is missing or not working.

5.     Intentionally damaging or causing disruptions with equipment will result in disciplinary actions. 

Supplies

Earbuds/headphones for class.  I do have sets that can be used.  You will be responsible for checking those out & returning them.

Talking

1.     Please have respect for teacher or person presenting & do not talk.  You have a few minutes at the beginning & end of class for personal conversations.   

Leaving the Classroom

1.     COVID-19:  This is limited to emergencies only!!! You need to obtain teacher permission to leave, teacher will sign you out.

2.     NON-COVID-19:  Get permission from the teacher before leaving the classroom.

3.     Sign out on the clipboard AND take a hall pass when you leave the classroom.

Cheating

1.     Students cheating will receive a 0 on the assignment(s) with no option to redo.  Parents will be contacted and will result in an office referral (if cheating on test or exam).

Missed Work

1.     Each student is responsible for getting missed assignments when absent.

2.     Missed assignments must be made up within 2 school days.

3.     Missed tests/quizzes must be rescheduled within 2 school days.

4.     Daily assignments are posted on the class Canvas page and in the classroom.

5.     Please communicate with teacher for any extensions needed.

End of Class

1.     You may logout during the last 2 minutes of class or when instructed, not earlier.

2.     Remain at your desk until the bell rings. Remember I dismiss you, not the bell.

3.     Please use designated door to leave classroom.

Fire Drills, Tornado Drills, Lockdowns

1.     Follow the teacher’s instructions and take all safety drills seriously.

2.     Fire drill - exit to the front of the school, follow the sidewalk to the right and go to the far side of teacher parking lot and remain with your class.

3.     Tornado drill – kneel down facing the wall in the hallway just outside the classroom.

4.     Lockdown – sit in the front of the classroom and remain completely silent.  If you sit near a window, please close blinds.

CANVAS Classroom Online-Learning Platform & Resources

1.     Warm-ups, assignments, quizzes and uploading files will be done through Canvas:

https://ucps.instructure.com/courses/1938035

2.     Check due dates. It is the responsibility of each student to submit work on time.

3.     Canvas logs every student submission with a date and time.

4.     Grades in canvas reflect only the specific assignment grade and are NOT the teacher’s gradebook. Check the Parent Portal on PowerSchool for student’s true grade for each course.

5.     Link to Student Guide for Canvas questions: https://guides.instructure.com/m/4212 

6.     Link to EmpowerEd Family Portal:  https://www.ucps.k12.nc.us/page/6333

7.     Students will use Testout-LabSim for this course, which is online. 

This link: https://labsimapp.testout.com/v6_0_370/index.html is accessible from the classroom Canvas page. Quizzes and Chapter TESTS will be in Canvas & LabSim.

 

Course Summary:

Date Details Due