If you would like to view the following syllabus as a Word document, click here:

ppotasnik_Basic Computer Applications II.docx

GJHS Course Syllabus

 

Course Name:         Basic Computer Applications II

Instructor:               Mrs. Potasnik—JHS Room C111    (814)533-5601 Ext. 3111

                                    ppotasnik@gjsd.net

Course Overview:

            The Basic Computer Applications II course is an advanced class relying on and enhancing the information learned in the Computer Applications I class.

            The Computer Applications II class starts off with a review of the units learned in the beginning course. The reviews will consist of completing various documents in the four programs learned previously. In Word, students will complete documents using editing, formatting, charts, tables, and tabulations. In Excel, students will complete printouts using numeric values, calculations, formulas, functions, charts, and other analytical tools. In PowerPoint, the students will complete a small presentation using graphics, clip art, and a soundtrack. In Access, the students will review quantitative data such as product inventories or employee records, pricing, and quantities.

            Once the students have mastered the review of the four programs, attention will be given to integrating the programs together. The integrated projects allow the student to apply the knowledge they have gained about the programs in the Office suite to produce a variety of documents and files.

            Computers are essential tools in almost all kinds of activity in school and in the business world. Every program reviewed and mastered in Office will help the student as they continue their education or enter the work force after graduation from high school.

Course Objectives:

      Review and understand the meaning of the vocabulary used in each software program.

      Read all material/directions before beginning to work.

      Review the Word program window while being able to start, save, and print a document.

      Format text in Word while using the toolbars checking for spelling and grammar errors.

      Enhance documents in Word with fonts, color, indentions, highlights, and style.

      Add page numbers, headers and footers, and insert tables and clip art.

      Review the Excel program window while being able to enter and edit formulas.

      Create complex formulas by copying formulas with relative cell references and absolute cell references.

      Plan an effective presentation using the PowerPoint software.

      Edit and check spelling in the PowerPoint presentation.

      Customize the background style for the presentation.

      Understand relational databases.

      Create and modify queries.

      Integrate the programs to apply the knowledge gained about the programs.

Classroom Rules:

• Attendance

      It is absolutely necessary that you attend class every day. This course, like any course, will follow a rigorous and continuous schedule in which fundamentals and new concepts are introduced and reviewed every day. By missing one class, you will lose valuable learning that will affect your future work.

 

      Granted, sometimes sickness or family emergencies enter into the picture, in which case, it is your responsibility to see me in the mornings (7:15-7:30) on the day you come back to school so that I can explain the material that you missed. Do not wait until class to ask “What did I miss?” I cannot stop class to explain to you individually all that you missed. That would not be fair to the other students. Missed assignments will be kept in an “absentee folder” for you to gather.

 

      If you are absent the day an assignment is due, that assignment is due the day you return. If you are absent on the day of a quiz or a test, be prepared to take that quiz or test on the day of your return. All makeup work must be completed within three (3) days of your return to school, or you will receive a zero.

 

      If you are absent, you must visit your academy office to get an excusal slip from the secretary. Do not enter the classroom without an excusal slip. Should you “forget” to get the excusal slip, you will be given only one chance to go to your academy office to pick up your excusal slip without having teacher detention. If you “forget” to get your excusal slip on the 2^nd, 3^rd, 4^th, etc., you will be assigned my teacher detention. Should you refuse to come for the teacher detention, a discipline log will be sent to your academy office. This policy will drastically cut down the number of students in the hall and will assure that you are in my room for instruction the entire class period. An unexcused absence will result in a zero for any assignments, quizzes, tests, or activities performed that day.

• Behavior:

      We are all mature individuals in this room and are expected to behave accordingly. I expect you to come to class promptly every day and have all your materials (text, pencils/pens, folders, notebooks, assignments, if any). Pencils should be sharpened before class begins. Responsible and respectful behavior is expected at all times. Putting your head down on the table/desk and sleeping will not be tolerated. You must concentrate on the material or directions being presented by the teacher. Pay close attention to the points listed in the Code of Conduct Contract that will follow.

 

• Tardiness to Class:

      You must arrive to class on time! This does not mean “running in the door and saying that you made it.” I expect you to have your text and materials and be seated ready to begin class when the late bell rings. I will begin the class promptly when the late bell rings.

 

      Coming to class late is a disruption in the educational process of others. Accurate records of “lates” will be kept in a notebook. If you are late to class two (2) times, a phone call will be made to your home. If you are late to class three (3) times, you will be assigned “teacher detention”. If you refuse to take my teacher detention, a discipline log will be written and sent to your academy office and another phone call will be made to your home. If you are late to class 4, 5, etc. times, additional discipline logs will be written.

 

      If a teacher, secretary, administrator, or anyone else causes you to be late for my class, make sure you ask them for an admit. Verbally telling me that they held you up will not erase the fact that you were late. Again, it is extremely important that you are on time every day to class.

 

• Dismissal from Class:

This class is not a study hall. Your attendance is mandatory. Please do not ask if you can go to another teacher’s room, the gym, or any other activity in the building while my class is going on. You need to be here! Restroom privileges should not be abused. Should I see that occurring, I will notify the nurse who will then call your home. For safety reasons, stay seated until the dismissal bell rings to move on to your next class.

Course Materials:

(Students will need these items everyday in class.)

      Microsoft Office 2007 textbook (Books will be found at each numbered computer in the classroom for student use. Books will not be taken out of the classroom.)

      Microsoft Office Supplemental Assignments (handouts) taken from other textbooks and supplied to the students for practice material on software programs.

      Folders (Students will receive a folder with their name on it to keep in their slot in the cabinet to store printouts and handouts.)

      Pencils/Pens (One pencil will be provided during each marking period—students may bring others.)

      Erasers

Course Text & Readings:

• Text—Microsoft Office 2007, Illustrated Series, Beskeen, Cram, Duffy, Friedrichsen, Reding.
• Supplemental Text—500 Computer Basic Projects, Reproducible Projects for Word Processing, Spreadsheets, Databases, and Presentation Graphics, Minta Berry.
• Supplemental software—“Microtype 3.0” (review keyboarding program for those that need extra practice).
• Supplemental software—“Micropace Pro 2.0” (5-minute timed writing program to check for speed and accuracy).

Assessments:

Grades can be determined at any time throughout the year using the following grading scale:

                                                                        93% - 100%     A

                                                                        82% - 92%       B

                                                                        70% - 81%       C

                                                                        60% - 69%       D

                                                                        0% - 59%         F

Your final grade will be determined by four (4) 9-week grades and the final exam. Each 9-week grade is worth 20%, and the final grade is worth 20%. Even if you pass all 9-week marking periods, but fail the final exam, you may still fail the course. It is imperative that you take the final exams seriously.

Grading Policy & Procedures:

• Grading Scale:

Grades can be determined at any time throughout the year using the following grading scale:

 

                                                                  93% - 100%     A

                                                                  82% - 92%       B

                                                                  70% - 81%       C

                                                                  60% - 69%       D

                                                                  0% - 59%         F

 

• Academic Dishonesty:

Any act of academic dishonesty (cheating on quizzes, tests, documents, plagiarism of homework, etc) will not be tolerated and will result in the following:

 

1)      a zero on the work involved.

2)      a phone call home to parent/guardian.

3)      a discipline log sent to the office.

If you need help on any assignment or in studying for a quiz or test, please see me in the mornings (7:15-7:30) or after school (2:35-3:00), and I will be more than happy to help you. Therefore, there is no reason for any dishonesty.

 

• Quizzes / Tests:

      Quizzes will be given throughout the chapters and may be announced or unannounced. The purpose of quizzes is to help me see what areas of difficulty you may be experiencing with the material prior to taking a large chapter test. Therefore, we can correct any mistakes you are making and remediation can take place before you take the chapter test.

 

      Tests will occur at the end of each chapter. Tests will be announced at least two (2) to three (3) days in advance. A review for the test will occur before the test. This will give you a chance to ask questions of any material that you may not completely understand. If absent on the day of a test, you will need to make arrangements to take a makeup test.

 

      Progress reports will be sent home in the middle of the 9-week period for those students who are not achieving at least a “C” average.

 

• Homework:

Normally, there is no homework in this class except in studying for quizzes and tests. Work at the computer is done in class so observations can be made and credit given to the student. If a student is absent, they can make arrangements with the instructor for makeup time before or after school.

Course Outline:

The topics that we will cover in Basic Computer Applications II include the following:

 

      Reviewing Creating Documents with Word 2007

      Editing Documents in Word 2007

      Enhancing Text and Paragraphs Using Various Formats in Word 2007

      Review Working with Excel 2007

      Working with Formulas and Functions in Excel 2007

      Formatting a Worksheet Using Excel 2007

      Working With Charts in Excel 2007

      Integrating Word 2007 and Excel 2007

      Review the Access 2007 Program

      Building and Using Queries in Access 2007

      Using Forms in Access 2007

      Using Reports in Access 2007

      Integrating Word 2007, Excel 2007, and Access 2007

      Creating a Presentation in PowerPoint 2007

      Modifying a Presentation in PowerPoint 2007

      Inserting Objects Into a Presentation Using PowerPoint 2007

      Finishing a Presentation in PowerPoint 2007

      Integrating Word 2007, Excel 2007, Access 2007, and PowerPoint 2007

 

Wishing you a great year in this class—Mrs. Potasnik

 

 

 

Code of Conduct Contract

Mrs. Potasnik

v All Greater Johnstown High School regulations, responsibilities, and disciplinary options stated in the Code of Student Discipline book will be understood and followed by every student in this classroom.

v Point values will be assigned for each infraction.

1. 1.     Respect yourself, classmates, teachers, administrators, all other staff, and property of Johnstown High School. Treat others as you wish to be treated!
2. 2.     Students will be on time for class! Sleeping or not doing work in class will not be tolerated.
3. 3.     Students will remain seated at all times.
4. 4.     Students will raise their hands to talk.
5. 5.     Students need to be prepared for each time in class. No one will be permitted to leave the classroom after the bell rings for the start of class unless they have an admit from an administrator excusing them for a legitimate reason.
6. 6.     Students are expected to do their own work. Plagiarism and cheating will result in disciplinary action as stated in the Greater Johnstown School Handbook and could result in a failing grade for the year.
7. 7.     Students are expected in class every day! When absent, you are responsible for any make-up work.
8. 8.     Do not bring food, candy, or drinks to class.
9. 9.     All electronic devices are prohibited in this classroom. Specifically, cell phone possession is severely restricted. Students caught with cell phones in their possession will have them confiscated, and they must be picked up by a parent/guardian in the Main Office.

 

 

 

Please return this paper to (Mrs. Potasnik) no later than (date will be given verbally and written here by the student).

 

I have read and understand the overall course structure as well as the student requirements and responsibilities.   I have also read the rules in the Code of Conduct Contract and understand them and the consequences that result if not followed. 

 

Student Name:
Student Signature :		Date:
Parent/ Guardian Name:		Relation:
Parent / Guardian Signature		Date:
Class Period =	Name of Class =	Date =

 

 

Parent/Guardian Contact Information:  (Please mark information below neat/legibly.)

Address (including zip code)__________________________________

Home telephone number____________________________________

Cell phone number_________________________________________

Email address______________________________________________