Course Syllabus

 

Central Academy of Technology and Arts

Course Syllabus

BP20 – SAS Programming I

School Year 2017-2018  

Instructor:	Ms. Lingle	Phone:	704-296-3088
Classroom:	Room #117	Email:	beth.lingle@ucps.k12.nc.us
Cougar Time:	Tuesdays/Thursdays	Tutoring:	Tuesday mornings 8:15 – 8:40 Thursdays afternoon 3:30 – 4:00

 Course Description:   6428 SAS Programming I is the entry point for students to learn SAS programming and is a prerequisite for the second SAS programming course. Students will learn how to plan and write SAS programs to solve common data analysis problems. Instruction provides practice running and debugging programs. The emphasis is placed on reading input data, creating list and summary reports, defining new variables, executing code conditionally, reading raw data files and SAS data sets and writing the results to SAS data sets.  Work-based learning strategies appropriate for this course include entrepreneurship, internship, mentorship, service learning, and job shadowing. Cooperative education is not available for this course.  Community service and leadership activities provide the opportunity to apply essential standards and workplace readiness skills through authentic experiences.

COMPETENCIES AND OBJECTIVES

A	SAS PROGRAMMING FUNDAMENTALS	53%
1.00	Apply SAS Base programming concepts.	27%
	1.01   Apply basic Base procedures to access libraries and enhance readability. (9%)
	1.02   Apply editing and debugging techniques to programming procedures. (3%)
	1.03   Apply DATA STEP programming to create and debug data sets. (10%)
	1.04   Apply an understanding of the fundamentals of SAS Syntax and rules of SAS programming to successfully run a program. (5%)
2.00	Apply techniques to create basic and advanced reports.	26%
	2.01   Apply PROC PRINT with options to create basic reports. (10%)
	2.02   Apply PROC FORMAT, PROC REPORT, PROC MEANS, PROC SORT AND PROC FREQ to generate advanced reports. (11%)
	2.03   Utilize Output Delivery System (ODS) to create, customize and manage output. (5%)
B	ADVANCED DATA MANIPULATION TECHNIQUES	47%
3.00	Apply advanced programming techniques to manipulate data sets.	17%
	3.01   Apply decision structure methods to conditionally assign values when creating and managing variables. (5%)
	3.02   Apply modifying options to manipulate output. (7%)
	3.03   Apply advanced programming methods to combine and manipulate data sets. (5%)
4.00	Apply advanced programming techniques to manipulate data.	9%
	4.01   Apply functions to manipulate and convert data. (4%)
	4.02   Apply iterative processing and SAS arrays. (5%)
5.00	Apply advanced techniques to read data into SAS and manipulate records.	21%
	5.01   Apply SAS programming methods to read and handle standard and non-standard numeric data as well as standard and non-standard fixed-field data. (9%)
	5.02   Apply SAS formats and informats to handle SAS date and time values. (6%)
	5.03   Apply advanced SAS programming methods to read multiple records sequentially and non-sequentially to create a single record as well as to create multiple observations from a single record. (3%)
	5.04   Apply advanced SAS programming procedures to read hierarchical files (3%)

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%

               

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. Letter %             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. 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 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 ___________