Right click here to print this page.
Computer Application Class Sylabus
8/4/2017

SYLLABUS

Microsoft Office 2013: Introductory

Instructor: Lisa Marshall

Phone: (423) 798-2636

Email: Lisa.Marshall@gcstn.org

Website: cdhs.greenek12.org

 

 

 

 

Course Description:

 

This course provides an overview of microcomputer applications including Microsoft Office 2013, Microsoft Word 2013, Microsoft Excel 2013, and Microsoft PowerPoint 2013. No experience with a computer is assumed.

 

Course Outcomes:

The objectives of this offering are to:

·       To teach the fundamentals of Microsoft Word 2013, Microsoft PowerPoint 2013, and Microsoft Excel 2013

·       To expose students to practical examples of the computer as a useful tool

·       To acquaint students with the proper procedures to create documents, presentations, and worksheets suitable for coursework, professional purposes, and personal use

·       To help students discover the underlying functionality of Office 2013 so they can become more productive

·       To develop an exercise-oriented approach that allows learning by doing

 

Text/Materials/Web:

Text: Microsoft Office 2013:Introductory (978-1-285-16602-5)

Handouts: Additional handouts may be required. Instructor will provide information on obtaining this material.

Online Materials:

www.freetypinggame.net

A typing program for the students to practice their touch typing skills.

www.everfi.com

            A program for students’ learning to be reinforced about technology.

 

Teaching Methods:

1.     Lectures: Important material from the text and outside sources will be covered in class. Students should plan to take careful notes as not all material can be found in the texts or readings. Discussion is encouraged as is student-procured outside material relevant to topics being covered.

2.     Assignments: End of chapter activities and online activities will be assigned weekly to reinforce material in the text. These assignments may require the application of various software packages.

3.     Quizzes: Occasional unannounced quizzes will be given to help ensure students keep up with assigned material.

4.     Exams: Exams will be given after each unit, at Midterm and at the End of the Semester. The exams will be closed book/notes and will test assigned readings and material discussed in class. Review sheets will be provided prior to the exam day. The midterm and final exam will be comprehensive in nature. However, the instructor reserves the right to retest on material that was not appropriately comprehended. These items will be noted on exam review sheets.

5.     Bell Ringers and Exit Slips will be done daily. Besides ones dealing with ACT/EOC Practice, the students will be doing touch typing practice and reinforcing class competencies.

6.     Participation: Student participation will be graded by the level of class participation and attendance. 

 

Grading:

 

Lab (Daily Work/Homework)    40%

Tests and Quizzes                     40%

Bell Ringers/Exit Slips              10

Participation                             10%

           

Course Policies:

 

Rules

 

Besides the rules found in the student handbook, the following apply to the Keyboarding Lab.

 

1. Cell Phones/Other Electronic Devices will not be needed for this class so please leave them in your backpack, pocket, and purse and off according to the school board policy and student handbook. If it becomes a problem, I will collect cell phones/electronic devices at the beginning of class and return them at the end of class.

 

2. ABSOLUTELY NO FOOD, GUM, CANDY, AND/OR DRINKS. (Unless Doctor Statement on File)

 

3. Signing out for bathroom/etc. Once you have signed out the pass will be given to you by the teacher (substitute) if needed to go to the restroom or anywhere else.You have one out per week excluding tardies and leaving early. Going to the restroom, locker, office, or another teacher cannot be when any instructing is taking place. This is when the teacher is talking, an instructional video is being played, or a guest speaker is speaking. Once your pass has been used for the week, do not ask to leave the classroom. Passes do not rollover to next week. You are here to learn not roam the halls. Only exception is a doctor statement on file in the office. Books cannot be taken home so it is important to be in class so you do not have to come in after school to make up missed work. (You must have your handbook to sign out.)

 

4. No Purses or Backpacks. All you need for this class is a pen or pencil and your homework.

 

5. NO HORSE PLAYING, PRIMPING, MESSING WITH ANOTHER’S COMPUTER OR BELONGINGS.  Remember the Golden Rule: Do unto others as you would want done to you. Respect is a two way street: you must give it to get respect.

 

6. Cheating will not be tolerated. If you are typing up someone else’s homework, print off an extra copy for them to put their name on it, save your work to their folder or use the internet to look up answers instead of the textbook, these are classified as cheating and all involved will get a zero for the assignment.

 

 

Violations

1st Violation is a warning.

 

2nd Violation is a 300 word report or after school detention.

 

3rd Violation is a referral to office or parent conference.

 

Some violations of the rules will result in automatic referral to the office. Examples: in email or games, on internet without permission, and/or inappropriate websites.

 


 

Make-Up Work

See me the last 15 minutes of class to arrange for your make up work. I usually arrive at school approximately 7:15 am and stay until 3:30 pm each day. I will post on the board days that I can stay until 4:30 pm for students to make up missed work, if they cannot get caught up during class time. We do have a full schedule so there are no free days in the classroom.  If the arrangement or work is not completed within one week from the day of the absence it will result in a 0 for the missed work.

 

 

Lab Fee and Supplies

Writing Utensil

$5.00 Lab Fee. Extra Credit given to student if paid within the first month of the class. The lab fee is used to buy needed materials for the Computer lab. Examples of materials are toner for the printer, any needed equipment, and/or supplies for the students to use in the classroom.

 

Course Outline

 

Assignment Descriptions:

Checkpoint exercises review key terms and concepts presented in the chapter.

 

How To: Your Turn present general guidelines for fundamental skills when using a computer or mobile device and then require that students to determine how to apply these general guidelines to a specific program or situation.

 

Internet Research exercises broaden students’ understanding of chapter concepts by requiring that they search for information on the web.

 

Problem Solving exercises extend knowledge of chapter concepts by seeking solutions to practical problems with technology that students may encounter at home, school, or work.

 

Critical Thinking exercises challenge student assessment and decision-making skills by presenting real-world situations associated with chapter concepts.

Apply Your Knowledge is an assignment that helps students reinforce their skills and apply the concepts learned in this chapter.

Extend Your Knowledge is an assignment that challenges students to extend the skills learned in this chapter and to experiment with new skills. Students may need to use Help to complete the assignment.

Analyze, Correct, Improve is an assignment that asks students to analyze a document, correct all errors, and improve the design.

In the Labs is a series of assignments that ask students to design and/or format a document.

Consider This: Your Turn is a series of assignments in which students apply creative thinking and problem-solving skills to design and implement solutions.

Learn Online is a series of online activities and resources that reinforce students’ knowledge of chapter content and key terms.


 

Week

Reading

Lab

Assignments/Homework

1

Introduction to Class

 

 

 

 

 

Introduction to Technology

·       Get to Know your Classmates/Teacher/Class/Textbook

·       Technology Unplugged video

·       How Computers Work video

·       Safety Video/Discussion/Test

·       How To: Your Turn

·       Internet Research exercises

Critical Thinking exercises

·       Rules and Competency sent home for parents to read and sign.

·       Pretest

·       Video Summaries

·       Safety Test

·       Checkpoint exercises

·       Choose two Problem Solving exercises

2

Microsoft Word Chapters 1, 2, and 3.

·       Extend Your Knowledge

·       Analyze, Correct, Improve

·       In the Labs

·       Chapter Questions

·       Apply Your Knowledge

·       Two Consider This: Your Turn exercises of your choosing

·       Learn Online

3

Microsoft Word Chapters 1, 2, and 3 continued.

·       Extend Your Knowledge

·       Analyze, Correct, Improve

·       In the Labs

·       Apply Your Knowledge

·       Two Consider This: Your Turn exercises of your choosing

·       Learn Online

·       Exam Review

·       Exam

4

Microsoft PowerPoint Chapters 1, 2, and 3.

·       Extend Your Knowledge

·       Analyze, Correct, Improve

·       In the Labs

·       Chapter Questions

·       Apply Your Knowledge

·       Two Consider This: Your Turn exercises of your choosing

·       Learn Online

5

Microsoft PowerPoint Chapters 1, 2, and 3 continued.

·       Extend Your Knowledge

·       Analyze, Correct, Improve

·       In the Labs

·       Apply Your Knowledge

·       Two Consider This: Your Turn exercises of your choosing

·       Learn Online

·       Exam Review

·       Exam

6

Microsoft Excel Chapters 1, 2, and 3.

·       Extend Your Knowledge

·       Analyze, Correct, Improve

·       In the Labs

·       Chapter Questions

·       Apply Your Knowledge

·       Two Consider This: Your Turn exercises of your choosing

·       Learn Online

7

Microsoft Excel Chapters 1, 2, and 3 continued.

·       Extend Your Knowledge

·       Analyze, Correct, Improve

·       In the Labs

·       Apply Your Knowledge

·       Two Consider This: Your Turn exercises of your choosing

·       Learn Online

·       Exam Review

·       Exam

8

Office 365 Essentials

·       Extend Your Knowledge

·       Analyze, Correct, Improve

·       In the Labs

·       Apply Your Knowledge

·       Two Consider This: Your Turn exercises of your choosing from both chapters

·       Learn Online

9

REVIEW

REVIEW

FINAL EXAM

 


 

Teacher Expectations/Extra Credit Opportunities

 

Bell Ringers

Bell ringers are to be done as soon as the bell rings. You have 5 minutes to do them in. They will be written on the left hand side of the white board.

 

Exit Slips

Exit Slip instructions will be written underneath the bell ringer information on the left hand side of the white board. Make sure you listen to instructions. The Exit Slip basket is on the three shelf basket for any work to be placed in that isn’t saved to the computer.

 

Assignments

I expect you to do your work; not to cheat; talk/goof off. Classroom work is important and it cannot be taken home so you must do it in class. If you want to get an A, I expect you to do A work. You get the grade that you earn by doing the assigned work. Class attendance is important. High School is to prepare you for post-secondary training and jobs where attendance is important.  Daily work consists of reading, answering questions, practices (following steps), outlining chapters, vocabulary and command knowledge, and exercises. Journal entries will be done at least once a week.

 

Future Business Leaders of America

The vocational student organization that goes along with our class is FBLA. There is a $15.00 registration fee to join FBLA. We will be having meetings during KnightTime and after school. Any class member that joins FBLA will receive 15 extra credit points.

 

Mock Trial

A venture organization of Boy Scouts of America, where the students act out a trial in front of judges as a competition against other area schools. The students will work with a lawyer to learn how to be a lawyer or a witness. The competition is in February. We will have meetings during KnightTime and after school. Two years in mock trial earns a speech credit for the student. Extra credit will be given for any class member that joins Mock Trial.

 

Extra Credit

Lab Fee if paid by first month of semester.

Midterms signed and returned within 5 days of them being given out.

Study Guides—completed and turned in.

Joining and paying registration for Mock Trial and FBLA.

Other Extra Credit opportunities may be given throughout the class. Don’t wait for end of the grading period and think you’re going to turn in extra credit or missing assignments to bring your grade up.

 


 


 

 

Standards and Competencies for Computer Applications (Course # 5891) 2016-17

 

Begin-End Yr

Standard 1 - Research recent developments in information technology affecting the supply/demand characteristics of the job market, including career pathways and occupational outlooks for occupations in business...

2014 - 

 

    

1.1 - Research recent developments in information technology affecting the supply/demand characteristics of the job market, including career pathways and occupational outlooks for occupations in business...

2014 - 

 

Standard 2 - Identify, connect, and demonstrate the correct usage of elements of a typical home computer, including a monitor, keyboard, mouse, network cable, and USB devices (such as camera, memory...

2014 - 

 

    

2.1 - Identify, connect, and demonstrate the correct usage of elements of a typical home computer, including a monitor, keyboard, mouse, network cable, and USB devices (such as camera, memory...

2014 - 

 

Standard 3 - Correctly and safely execute basic file management operations on a typical personal computer and shared storage media, including the opening, creating, copying, moving, deleting, and renaming...

2014 - 

 

    

3.1 - Correctly and safely execute basic file management operations on a typical personal computer and shared storage media, including the opening, creating, copying, moving, deleting, and renaming...

2014 - 

 

Standard 4 - Describe and demonstrate the correct connections and setup for a new wireless router in a home computing environment. Discuss the impact of network speeds, wireless communications, firewalls...

2014 - 

 

    

4.1 - Describe and demonstrate the correct connections and setup for a new wireless router in a home computing environment. Discuss the impact of network speeds, wireless communications, firewalls...

2014 - 

 

Standard 5 - Describe the steps necessary to retrieve, download, and safely install new applications, updates, and plug-ins from the Internet.

2014 - 

 

    

5.1 - Describe the steps necessary to retrieve, download, and safely install new applications, updates, and plug-ins from the Internet. 

2014 - 

 

Standard 6 - Compare and contrast the accessibility of the Internet through a home router versus through a public wi-fi access point. Discuss the risks and advantages of using secure home networks versus...

2014 - 

 

    

6.1 - Compare and contrast the accessibility of the Internet through a home router versus through a public wi-fi access point. Discuss the risks and advantages of using secure home networks versus...

2014 - 

 

Standard 7 - While preparing materials and assignments in this course, use a browser to access and download Internet resources by uniform resource locator (URL), hyperlink, or favorite/bookmark.

2014 - 

 

    

7.1 - While preparing materials and assignments in this course, use a browser to access an download Internet resources by uniform resource locator (URL), hyperlink or favorite/bookmark.

2014 - 

 

Standard 8 - Use a word processing program to create and format documents with academic and business styles (e.g., memos, letters, agendas, reports, tabular lists) to communicate the results of research...

2014 - 

 

    

8.1 - Use a word processing program to create and format documents with academic and business styles (e.g., memos, letters, agendas, reports, tabular lists) to communicate the results of research...

2014 - 

 

Standard 9 - Craft documents using word processing program features and methods such as: a. Paragraph formatting (line spacing, justification, identations) b. Bulleted and numbered lists c. Tables of multiple...

2014 - 

 

    

9.1 - Craft documents using word processing program features and methods such as: a. Paragraph formatting (line spacing, justification, identations) b. Bulleted and numbered lists. c. Tables of multiple...

2014 - 

 

Standard 10 - Enhance documents by including graphic arts components such as borders and shaded elements, graphs and charts from other programs, watermarks, and imagery imported from technology...

2014 - 

 

    

10.1 - Enhance documents by including graphic arts components such as borders and shaded elements, graphs and charts from other programs, watermarks, and imagery imported from technology...

2014 - 

 

Standard 11 - Create, format, and edit documents suitable for print or electronic distribution, both four-color and two-color (black and white).

2014 - 

 

    

11.1 - Create, format, and edit documents suitable for print or electronic distribution, both four-color and two-color (black and white).

2014 - 

 

Standard 12 - Critique and edit existing documents with standard proofreading and editing marks to conform to a standard business style guide (e.g., fonts, colors, line spacing). Practice the use of electronic...

2014 - 

 

    

12.1 - Critique and edit existing documents with standard proofreading and editing marks to conform to a standard business style guide (e.g., fonts, colors, line spacing). Practice the use of electronic...

2014 - 

 

Standard 13 - Complete a comprehensive word-processing project with instructor approval that applies the skills acquired in this section. For example, prepare a contract, MLA-style report, business...

2014 - 

 

    

13.1 - Complete a comprehensive word-processing project with instructor approval that applies the skills acquired in this section. For example, prepare a contract, MLA-style report, business 

2014 - 

 

Standard 14 - Use a spreadsheet program to create and format academic and business documents for the purposes of tabulating and calculating numerical and/or textual data (e.g., statistics, historical data...

2014 - 

 

    

14.1 - Use a spreadsheet program to create and format academic and business documents for the purposes of tabulating and calculating numerical and/or textual data (e.g., statistics, historical data...

2014 - 

 

Standard 15 - Craft documents using a spreadsheet program using features and methods such as: a. Cells, columns, and rows b. Formulas and functions c. Copy, move, delete, and fill d. Cell-value formats...

2014 - 

 

    

15.1 - Craft documents using a spreadsheet program using features and methods such as: a. Cells, columns, and rows b. Formulas and functions c. Copy, move, delete, and fill d. Cell-value formats...

2014 - 

 

Standard 16 - Create new formulas to analyze data by calculating with, extracting from, presenting, and/or summarizing, including: a. Basic arithmetic calculations b. Basic mathematic (e.g., SUM, AVG, MIN, MAX)...

2014 - 

 

    

16.1 - Create new formulas to analyze data by calculating with, extracting from, presenting, and/or summarizing, including: a. Basic arithmetic calculations b. Basic mathematic (e.g., SUM, AVG, MIN, MAX)...

2014 - 

 

Standard 17 - Create and format for optional clarity a variety of types of graphs and charts, including bar charts, line charts, pie charts, and X-Y graphs, based on tabulated data.

2014 - 

 

    

17.1 - Create and format for optional clarity a variety of types of graphs and charts, including bar charts, line charts, pie charts, and X-Y graphs, based on tabulated data.

2014 - 

 

Standard 18 - Retrieve a spreadsheet template (from those installed with the program or from the Internet) and customize it for a particular assignment approved by the instructor. For example, prepare...

2014 - 

 

    

18.1 - Retrieve a spreadsheet template (from those installed with the program or from the Internet) and customize it for a particular assignment approved by the instructor. For example, prepare...

2014 - 

 

Standard 19 - Use a database program to interpret the structure of an existing database (found in teaching resources or teacher-created), identifying tables, fields, key fields, queries, forms, and reports.

2014 - 

 

    

19.1 - Use a database program to interpret the structure of an existing database (found in teaching resources or teacher-created), identifying tables, fields, key fields, queries, forms, and reports.

2014 - 

 

Standard 20 - Using an existing database (found in teaching resources or teacher-created), create and run a database report based on basic queries. For example, retrieve the relevant information to answer...

2014 - 

 

    

20.1 - Using an existing database (found in teaching resources or teacher-created), create and run a database report based on basic queries. For example, retrieve the relevant information to answer...

2014 - 

 

Standard 21 - Using an existing database (found in teaching resources or teacher-created), create, modify, and perform basic queries through a form to create a new table/view in a database.

2014 - 

 

    

21.1 - Using an existing database (found in teaching resources or teacher-created), create, modify, and perform basic queries through a form to create a new table/view in a database.

2014 - 

 

Standard 22 - Design, create, and deliver an oral presentation for a selected audience on a topic approved by the instructor. Using a specified slide number and duration, include the following elements:...

2014 - 

 

    

22.1 - Design, create, and deliver an oral presentation for a selected audience on a topic approved by the instructor. Using a specified slide number and duration, include the following elements...

2014 - 

 

Standard 23 - Design, create, and deliver a self-running electronic slideshow for a selected audience on a topic approved by the instructor. Using a specified slide number and duration, include the following... 

2014 - 

 

    

23.1 - Design, create, and deliver a self-running electronic slideshow for a selected audience on a topic approved by the instructor. Using a specified slide number and duration, include the following...

2014 - 

 

Standard 24 - Research, summarize, and deliver (via presentation, document, spreadsheet data/chart, or other format) a summary of the various perspectives and ramifications surrounding an ethical issue related...

2014 - 

 

    

24.1 - Research, summarize, and deliver (via presentation, document, spreadsheet data/chart, or other format) a summary of the various perspectives and ramifications surrounding an ethical issue related...

2014 - 

 

Standard 25 - Research, summarize, and deliver (via presentation, document, spreadsheet data/chart, or other format) a summary of the various perspectives and ramifications surrounding an ethical issue related...

2014 - 

 

    

25.1 - Research, summarize, and deliver (via presentation, document, spreadsheet data/chart, or other format) a summary of the various perspectives and ramifications surrounding an ethical issue related...

2014 - 

 

Standard 26 - Explain, furnish examples, and demonstrate technical literacy with the following terms: a. The Internet, World Wide Web, and various browsers b. Network speeds, wireless communication, firewalls...

2014 - 

 

    

26.1 - Explain, furnish examples, and demonstrate technical literacy with the following terms/ a. The Internet, World Wide Web, and various browsers b. Network speeds, wireless communication, firewalls... 

2014 - 

 

Standard 27 - Employ skills covered in this course (document processing, spreadsheet applications, electronic presentations, databases, Internet fluency) to complete a cross curricular project approved by...

2014 - 

 

    

27.1 - Employ skills covered in this course (document processing, spreadsheet applications, electronic presentations, databases, Internet fluency) to complete a cross curricular project approved by...

2014 - 

 

27 Competencies