Course Syllabus

Central Academy of Technology and Arts

Course Syllabus

Microsoft Excel and Access

School Year 2017-2018

 

Instructor:                         Beth Lingle

Email:                                beth.lingle@ucps.k12.nc.us

Phone:                              704-296-3088

Classroom:                       Room #117

Cougar Time:                   Tuesdays/Thursdays 10:17 – 10:47

Tutoring:                           Tuesday mornings 8:15 – 8:40

                                          Thursdays afternoon 3:30 – 4:00.

Course Description:   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. The first part of the 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. In the second part of the class, students will learn how to create and work with a database and its objects by using the new and improved features in newest version of Microsoft Access. Students will learn how to create, modify, and locate information as well as how to create programmable elements and share and distribute database information. Mathematics is reinforced. Work-based learning strategies appropriate for this course include internship, service learning, and job shadowing. Apprenticeship is not available for this course. Content in this course aligns with the following industry credential: the Microsoft Office Specialist (MOS) in Excel and/or Access, and  http://www.microsoft.com/learning/en/us/certification/mos.aspx.

COMPETENCIES AND OBJECTIVES

	Microsoft Excel Unit A
	1.00 Understand basic and intermediate spreadsheet software skills using Microsoft Excel 2016.     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
	Microsoft Access Unit B
	2.00 Understand basic database software skills using Microsoft Access 2016.     2.01 Database Essentials   2.02 Creating Database Tables   2.03 Working with Tables and Database Records   2.04 Modifying Tables and Fields   2.05 Creating Forms   2.06 Creating Reports   2.07 Creating and Modifying Queries   2.08 Using Controls in Reports and Forms   2.09 Advanced Tables   2.10 Advanced Forms   2.11 Advanced Reports   2.12 Advanced Queries   2.13 Displaying and Sharing Data   2.14 Importing and Exporting Data   2.15 Database Tools

 

Canvas:  The majority of 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.  Therefore, students and parents should always check their child’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. A = 100 - 90

                                B =   89 - 80

                                C =   79 - 70

                                D =   69 - 60

                                F =   60 - and below

Course Resources:  EmpowerEd Family Portal, MOAC Excel and Access Textbooks are available by lesson for each student to access.  (More to follow)

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:

1. Verbal warning with 3rd Tardy
2. Parent Call with 4th Tardy
3. Parent Call and Classroom Assignment with 5th
4. Referral to the Administration with 6th

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 (This includes plate lunches, drinks, candy, etc. whether opened or not.)
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 and necessary equipment. However, students are welcome to use 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: The streaming of audio and/or video, playing games on the computer without permission, the use of chat rooms, Facebook, YouTube, instant messenger, email, proxy servers or using the Internet for non-educational purposes is prohibited. You must comply with both the CATA and UCPS Computer Usage Rules and Regulations at all times while using school equipment. Verbal warnings will not be given. Violators will be logged off immediately and referred to administration. To obtain credit for computer classes, your computer privileges must remain intact. All computer usage forms must be completed, signed and returned before a student will be permitted to use the Internet.

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. These acts are considered cheating and students will be disciplined as such. 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 Mrs. Lingle’ Syllabus and Classroom Procedures Document, please sign, date and return this section below.

 

This is a contractual agreement between me, Mrs. 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-17__

 

Student signature_________________________________   Date____________

 

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