Transcription

2 Advanced Computer Software Systems Page 1 I. Introduction/Overview/Philosophy Advanced Computer Software Systems This course is designed to introduce students to advanced word processing and spreadsheet software packages such as Microsoft Word and Excel. Students will become proficient at using the major functions of these packages including using basic and advanced formatting techniques, enhancing documents, using timesaving features, working with tables, etc. Students will also be introduced to the charting and database capabilities of a spreadsheet program. These various advanced computer software systems will be learned using a hands-on, activity-based approach. The topics covered will mirror the skills needed on the MOUS (Microsoft Office User Specialist) certification exam. This course is intended for all students because it is imperative that all students build a solid understanding of the advanced software applications used at colleges, universities, and in the real world. II. Objectives Course Outline: I. MASTERING WORD PROCESSING A. WORKING WITH TEXT 1. Use the Undo, Redo, and Repeat commands 2. Apply font formats (Bold, Italic, and Underline) 3. Use the Spelling feature 4. Use the Thesaurus feature 5. Use the Grammar feature 6. Insert Page Breaks 7. Highlight text in a document 8. Insert and move text 9. Cut, Copy, Paste and Paste Special, using the Office Clipboard 10. Copy formats using the Format Painter 11. Select and change Font and Font Size 12. Find and Replace Text 13. Apply Character Effects (Superscript, Subscript, Strikethrough, Small Caps and Outline) 14. Insert Date and Time 15. Insert Symbols 16. Create and Apply frequently used text with AutoCorrect 17. Change text direction 18. Format Drop Caps B. WORKING WITH PARAGRAPHS 1. Align text in paragraphs (Center, Left, Right, and Justify) 2. Add Bullets and Numbering 3. Set Character, Line, and Paragraph spacing 4. Apply Borders and Shading to paragraphs 5. Use Indentation Options (Left, Right, First Line, and Hanging Indent) 6. Use Tabs (Center, Decimal, Left, and Right)

7 Advanced Computer Software Systems Page 6 Student Outcomes: After completing this course, the student will demonstrate the ability to: identify parts of an advanced word processing software package screen work with multiple documents use undo, redo, replace, and show/hide tools and commands use templates and wizard use the AutoText, AutoCorrect, and AutoFormat features use the thesaurus, grammar, hyphenation, language, and word count commands insert symbols and special character and understand the use of such characters enter and remove passwords use the page setup command control and apply pagination and character and paragraph formatting add bullets and numbering to lists add borders and shading to paragraphs work with styles format in columns record and run a word processing macro enter page, section, and column breaks format fonts and drop caps work with fields and sorts use the headers, footers, and page number commands create, move, edit, format, and split a table use sort and formula commands in a table use basic and advanced mail merge capabilities insert, format, size, crop, and add borders to graphics insert objects in a document use the drawing toolbar use the outline view identify parts of an advanced spreadsheet software package screen identify and use a range create formulas and use functions create various graphs to interpret data enhance a chart with options turn an existing worksheet into a database use various techniques to improve the appearance of a worksheet change the display and calculation options sort and protect ranges use various techniques to extract data use functions in formulas to look up data work with dates and times link worksheets add annotations to charts, create combination charts, create one-input and two-input data tables create, use, and edit spreadsheet macros work with multiple worksheets link a spreadsheet or chart to a word document

8 Advanced Computer Software Systems Page 7 New Jersey Core Curriculum Content Standards CAREER READY PRACTICES CRP1 Act as a responsible and contributing citizen and employee. CRP2 Apply appropriate academic and technical skills. CRP4 Communicate clearly and effectively and with reason. CRP8 Utilize critical thinking to make sense of problems and persevere in solving them. CRP9 Model integrity, ethical leadership and effective management. CRP10 Plan education and career paths aligned to personal goals. CRP11 Use technology to enhance productivity. TECHNOLOGY 8.1 Educational Technology All students will use digital tools to access, manage, evaluate, and synthesize information in order to solve problems individually and collaboratively and to create and communicate knowledge. Strand A. Technology Operations and Concepts Strand B. Creativity and Innovation Strand C. Communication and Collaboration Strand D. Digital Citizenship Strand F. Critical Thinking, Problem Solving, and Decision-Making 21ST CENTURY LIFE AND CAREERS Standard 9.2: Career Awareness, Exploration, and Preparation Strand C: Career Preparation Standard 9.3: Career and Technical Education BM.1 Business Management and Administration: Utilize mathematical concepts, skills and problem solving to obtain necessary information for decision- making in business. COMMON CORE STANDARDS LANGUAGE ARTS LITERACY CCSS.ELA-Literacy.RI Cite strong and thorough textual evidence to support analysis of what the text says explicitly as well as inferences drawn from the text, including determining where the text leaves matters uncertain. CCSS.ELA-Literacy.SL Make strategic use of digital media (e.g., textual, graphical, audio, visual, and interactive elements) in presentations to enhance understanding of findings, reasoning, and evidence and to add interest. CCSS.ELA-Literacy.L Demonstrate command of the conventions of standard English grammar and usage when writing or speaking.

9 Advanced Computer Software Systems Page 8 COMMON CORE STANDARDS MATHEMATICS High School Number and Quantity N-Q.1 High School Number and Quantity: Quantities Reason quantitatively and use units to solve problems. Use units as a way to understand problems and to guide the solution of multi-step problems; choose and interpret units consistently in formulas; choose and interpret the scale and the origin in graphs and data displays. N-Q.2 High School Number and Quantity: Quantities Reason quantitatively and use units to solve problems. Define appropriate quantities for the purpose of descriptive modeling. III. Proficiency Levels This course is open to grades IV. Methods of Assessment Student Assessment The teacher will provide a variety of assessments. Among them are: quizzes/tests, group projects, simulations, computer projects, homework, and class participation. Curriculum/Teacher Assessment The teacher will provide the subject area supervisor with suggestion for changes. V. Grouping There are no prerequisites for this course. Keyboarding ability is recommended. VI. Articulation/Scope & Sequence/Time Frame This is a half-year course and is offered to grades VII. Resources Resources include but are not limited to: Business Math Using Excel by Sharon Burton and Nelda Shelton, Thomson South-Western, 2005 DDC Learning Computer Applications by Lisa Bucki, Pearson Education Inc DDC Learning Word Processing by Lisa Bucki, Pearson Education Inc DDC Learning Spreadsheets by Lisa Bucki, Pearson Education Inc VIII. Methodologies The following methods of instruction are suggested: lecture, group projects, demonstration, independent student class work, and class presentations.

10 Advanced Computer Software Systems Page 9 IX. Suggested Activities Integrate Internet research into formulating and designing projects utilizing advanced word processing and spreadsheet techniques. X. Interdisciplinary Connections This course incorporates real-world math, literacy, and oral presentation skills as well as computer applications. The course follows the 21 st Century Framework; incorporating life and career skills, the 4 C s (critical thinking, collaboration, communication, and creativity), and information, media and technology skills. XI. Differentiating Instruction for Students with Special Needs: Students with Disabilities, English Language Learners, and Gifted & Talented Students Differentiating instruction is a flexible process that includes the planning and design of instruction, how that instruction is delivered, and how student progress is measured. Teachers recognize that students can learn in multiple ways as they celebrate students prior knowledge. By providing appropriately challenging learning, teachers can maximize success for all students. Examples of Strategies and Practices that Support: Students with Disabilities Use of visual and multi-sensory formats Use of assisted technology Use of prompts Modification of content and student products Testing accommodations Authentic assessments Gifted & Talented Students Adjusting the pace of lessons Curriculum compacting Inquiry-based instruction Independent study Higher-order thinking skills Interest-based content Student-driven Real-world problems and scenarios English Language Learners Pre-teaching of vocabulary and concepts Visual learning, including graphic organizers Use of cognates to increase comprehension Teacher modeling Pairing students with beginning English language skills with students who have more advanced English language skills Scaffolding

11 Advanced Computer Software Systems Page 10 word walls sentence frames think-pair-share cooperative learning groups XII. Professional Development The teacher will continue to improve expertise through participation in a variety of professional development opportunities.

12 Advanced Computer Software Systems Page 11 XIII. Curriculum Map Class September/February October/March November/April December/May January/June Advanced Computer Software Systems Spreadsheets Create a spreadsheet Move within a spreadsheet Print a spreadsheet Enter information in a spreadsheet Work with formulas and quick sums Format a spreadsheet Apply number and date formats Change column widths in a spreadsheet Add and remove columns and rows Spreadsheets Continued Adjust column widths Add borders and shading to a spreadsheet Use copy and move features Use fill feature Enhance a spreadsheet with automatic formats Name spreadsheet ranges Use range names in functions Apply number and date formats Enhance spreadsheets with automatic formats Set up print options Spreadsheets Continued Create charts Create special effects in a worksheet Sort, filter and edit lists Sort records on the contents of one field Sort records on the contents of two or more fields Use custom auto filter with or and searches Link and embed Excel data in a word document Word Processing Work with text Work with paragraphs Work with documents Manage files Word Processing Continued Create tables Modify table structure and rotate tables Perform calculations in tables Link Excel data as a table Work with pictures and charts Use the drawing toolbar Insert graphics into a document Format graphics Use mail merge Create a main document Create a data source Sort records to be merged Word Processing Continued Use advanced features Insert a field Create, apply and edit macros Copy, rename, and delete macros Customize a toolbar

Computer Applications (10004) Rationale Statement: With the growing need for computers in school and business, it is important that South Dakota high school students have an understanding of common application

Creating Newsletters Formatting Text and Paragraphs Start a new document from templates Essential Training Set default line spacing and font for all new documents Display non-printing characters Copy or

COURSE TITLE Investing and the Stock Market LENGTH Half Year Grades 11-12 DEPARTMENT Business Education Barbara O Donnell, Supervisor SCHOOL Rutherford High School DATE Spring 2015 Investing and the Stock

Course Description: Introduction to word processing terminology, editing functions, formatting, and special text options. Learn to create, edit, and print documents such as letters or reports using this

Computer Skills: Levels of Proficiency September 2011 Computer Skills: Levels of Proficiency Because of the continually increasing use of computers in our daily communications and work, the knowledge of

Middle School The goal of the Middle School Computer curriculum is to further develop technology skills for both academic learning and personal productivity in the 21 st century. Students learn the science

Computer Checklist 1 Computer User Levels 1 The following skills checklist is organized according to program title and categorized into three levels of computer literacy:,, and. users demonstrate little

Basic Microsoft Excel 2007 The biggest difference between Excel 2007 and its predecessors is the new layout. All of the old functions are still there (with some new additions), but they are now located

This tutorial was adapted from a tutorial by see its complete version at http://www.fgcu.edu/support/office2000/excel/index.html Excel 2003 Tutorial I Spreadsheet Basics Screen Layout Title bar Menu bar

RUTHERFORD HIGH SCHOOL Rutherford, New Jersey COURSE OUTLINE STATISTICS AND PROBABILITY I. INTRODUCTION According to the Common Core Standards (2010), Decisions or predictions are often based on data numbers

MICROSOFT WORD BASIC FULL DAY COURSE This course is suitable for users with no (or little) previous experience of using Word. Keyboard, mouse and Windows skills are prerequisite for this course. Practice

Excel Lesson 1: Microsoft Excel Basics 1. Active cell: The cell in the worksheet in which you can type data. 2. Active worksheet: The worksheet that is displayed in the work area. 3. Adjacent range: All

Microsoft Office Topics per Course This document contains: List of courses Details of what is covered in each course Registration links Please review prerequisites and topics before registering. MS Office

Microsoft Word 2010 Scavenger Hunt The commands in Microsoft Word 2003 are similar to that of Microsoft Word 2010 except the placement if different. This scavenger hunt will help you get acquainted with

Microsoft Word Home Clipboard : Paste - Paste the contents of the clipboard Cut - cut the selection from the document and put it on the clipboard Copy - copy the selection and put it on the clipboard Font:

Microsoft Office Word 2010: Level 1 Workshop Objectives: In this workshop, you will learn fundamental Word 2010 skills. You will start by getting acquainted with the Word user interface, creating a new

F9D7 04 (ESKWP2): Word Processing Software 2 4 SCQF credit points at SCQF level 5 Description: This is the ability to use a software application designed for the creation, editing and production of largely

RUTHERFORD PUBLIC SCHOOLS ENVIRONMENTAL SCIENCE CURRICULUM GRADE 7 I. INTRODUCTION The overall intent for the environmental studies course is to expose seventh grade students to a multitude of environmental

Microsoft Word 2007 (Getting Started) Screen Layout Menus When you begin to explore Word 2007 you will notice a new look to the menu bar. There are three features that you should remember as you work within

Lower School The goal of the Lower School Computer curriculum is to continue to develop technology skills for both academic learning and personal productivity in the 21 st century. Students learn the science

Beginning Excel 2010 Objective 1: Review Screen Layout Excel 2010 offers the same user interface as 2007. The top portion of the window has a new structure for Excel commands. The band area is called the

Microsoft Windows 7: Level 1 Must have a personal computer with Microsoft Windows 7 installed on their workstation. This class is geared to the student who has little or no knowledge of the Windows environment

DESKTOP PUBLISHING FINAL REVIEW Multiple Choice: 1. Which option is used to compress text horizontally by some percentage of the current size? A. Spacing B. Scale C. Kerning D. Subscripting 2. To stretch

University of Miami Information Technology Word 2013 is fairly similar to Word 2010 but has a few variations. Word 2013, however, still uses the same file extension (.docx) This manual will discuss the

MODULE 3: WORD PROCESSING USING MICROSOFT OFFICE WORD 2007 3.1 OBJECTIVES At the end of this module, students shall be able to: Start and exit the Microsoft Office Word. Create, edit documents and save

April 20, 2012 Publisher 2010 Cheat Sheet Toolbar customize click on arrow and then check the ones you want a shortcut for File Tab (has new, open save, print, and shows recent documents, and has choices

2 What s New in Word 2007 2.1 Overview of Word 2007 Microsoft Office Word 2007 is a word processing program that enables you to create many types of documents including letters, resumes, reports, proposals,

1 Microsoft Excel 2010 Tutorial Excel is a spreadsheet program in the Microsoft Office system. You can use Excel to create and format workbooks (a collection of spreadsheets) in order to analyze data and

Ribbon menu The Ribbon menu system with tabs for various Excel commands. This Ribbon system replaces the traditional menus used with Excel 2003. Above the Ribbon in the upper-left corner is the Microsoft

Microsoft Word 2016 Tutorial For Mac 1 GETTING STARTED Microsoft Word is one of the most popular word processing programs supported by both Mac and PC platforms. Microsoft Word can be used to create documents,

Excel is a spreadsheet program that allows users to organize data, complete calculations, make decisions, graph data, develop professional reports, etc. Unlike a paper spreadsheet, you can set up an Excel

JOB SEARCH TECHNIQUES Job Search Techniques To give clients the tools and confidence to pro-actively search online for job vacancies and hidden opportunities. For clients who can use IT competently already,

Western Wayne School District Curriculum Map Computer Science Grade Level: 8 Marking Period: All Instructional Time: 1hr. 20 minutes every other day for 1 quarter. Days of Instructional Programming Evaluation

SOFTWARE SKILLS - Microsoft Library Catalog The following training modules are included with the Software Skills library. Title Description Courses Duration in Min Intro to Gmail Defines what each Gmail

106 :: Data Entry Operations 6 Basics of Spreadsheet 6.1 INTRODUCTION A spreadsheet is a large sheet having data and information arranged in rows and columns. As you know, Excel is one of the most widely