COURSE OUTLINE: Chapters 3-17 will be covered in the fall and winter blocks.  We will be covering word processing, spreadsheets, database, desktop publishing, PowerPoint presentations and access.  Lesson Plans for the course will be posted on the internet (www.kennedyhighschool.org)

 

Chap 3  introduction in Word processing: Creating, editing, opening, closing, and printing will be discussed.  The interface of word will be described.  Using the menus and toolbars will be elaborated on. Wordwrap will be explained

Chap 4  Formatting Word processing documents:  Fonts, size, style, color, paragraph indention, margins, alignments and line spacing.  Headers and footers, tab stops, and putting page numbers will be taught.  There are many ways to achieve a goal in word and those different methods will be demonstrated.

Chap 5  Word Processing Features:  Finding and replacing text, copy, moving, and deleting text.  Short-cut keys will be covered.  Using the thesaurus, word count, bullet lists, footnotes and endnotes, adding graphics to a document, and creating columns of text are issues covered in this chapter.

Chap 6  Advanced Word Processing Features:  Inserting Tables and formatting these tables, inserting special characters, hyphenating text, using special styles, creating table of contents and having them link to other sections of the document like bookmarks, and finally creating section breaks within a document

Chap 7  Introducing Spreadsheets: what is a spreadsheet?  Understanding the structure of excel.  Basic functions like entering data (numbers, labels, and formulas), saving, printing, previewing, headers and footers, column widths, formatting data and introducing three functions: SUM, ROUND, AVERAGE.  Shortcuts will used to show the simplicity of a spreadsheet.

Chap 8  Spreadsheet Techniques Planning a spreadsheet. Cut, copy paste.  Functions learned will be: MAX, MIN, and IF.  Inserting and deleting rows and columns.  Absolute cell referencing and relational operators.  Printing large spreadsheets by changing margins, fit to one page, and orientation

Chap 9  Worksheets and Charts: Creating working on multiple sheets within one workbook. Creating, modifying, and printing pie, line, bar charts.  Series, legends, axis, font, formatting of charts will be discussed

Chap 10 Advanced Spreadsheet Techniques Sorting information. Functions learned will be CHOOSE, VLOOKUP, and PMT. Freezing cells, amortization tables, creating hyperlinks, and printing only selected parts of the spreadsheet.

Chap 11 Integrating the Word Processor and Spreadsheet copying data and text between multiple files either word or excel. OLE object link embedded, creating excel in word and putting a word object into excel. Create linked objects

Chap 16 Making Presentations with PowerPoint Creating a presentation. Different views. Creating textboxes, inserting images, backgrounds, sounds, editing text, slide transitions, animation, and changing slide order.  A Presentation project will be assigned, in which planning and research will be required

Chap 17 Desktop Publishing with Publisher What is desktop publishing. Creating a publication. Placing images into a newsletter, creating background and foreground, viewing and connecting text frames, creating layouts appropriately, using guides, changing margins.  A newspaper project will be assigned, with various articles pictures, advertisements, and much more.

Chap 12 Introducing The Relational Database (Access) Creating relational databases, what they are, defining fields and records, creating and saving tables, creating forms, entering information, saving and printing records, filtering

Chap 13 Relational Database Techniques Modifying records, deleting and sorting information, creating relationships, creating queries (and, or)

Chap 14 Database Reports and Advanced Database Techniques

GRADING: Your grade will be the result of accumulated points for the semester.  These points will come from several sources.  Points will come from homework assignments, usually 10-30 pts, from quizzes (announced or surprised (usually 20-30 pts), chapter tests (usually 100 points) and projects that will be done by each student (usually 100 pts and extra credit).  Also points will be given everyday for bringing the four items mentioned above and small writings will done during the week dealing with computers (3-5 points); these points cannot be made-up.  Attendance will be important!!  Some of the projects will include newsletters, research documents, stock portfolios, and PowerPoint presentations.  Most of the work will be done in class on the computers, so attendance is extremely important.  When assignments are late, you have a maximum of three days to get it turned in.  However, every day it is late, you will lose 10% of the points awarded to that assignment per day.  Sixty percent of all the points must be earned in order to pass this class.  ALL GRADES ARE POSTED WEEKLY IN CLASS TO LET THE STUDENTS KNOW HOW THEY ARE DOING!

Grading Scale               100       A+                    92-99    A                     90-91    A-

                                    88-89    B+                    82-87    B                     80-81    B-

                                    78-79    C+                    72-77    C                     70-71    C-

                                    69          D+                    68-66    D                     65          D-

CLASSROOM RULES: You will be expected to behave in an appropriate manner, respectful of the rights of others.  Any abuse of hardware or software in this class will be dealt with severely and reported immediately to administration.  This will be discussed more thoroughly in class.  Food and liquids are forbidden in class, DO NOT bring any at all.  Class will be over when the bell rings, and you will remain in your seats until then.  Students are allowed to have cell phones but they are not to be used in class.  If I see a cell phone in class, it will be confiscated and given to the principal.