Integrated Business Applications Syllabus Title of Course: Integrated Business Applications Syllabus Teacher: Mrs. Ferrato, (843)706-8059, email@example.com Grade Level: 9-12 Pre-requisite(s): Length of Course: 1 Year Credits: 1 Textbook: Microsoft Office 2003 – Introductory, MicroTypePro software, Microsoft Office software Course Description: This course of study is designed to teach the student advanced computer concepts as related to processing data into useful information needed in business situations by using advanced database, spreadsheet, word processing, and presentation software capabilities. Because the design of this course is to prepare students for Microsoft Office Specialist (MOS) Certification, the emphasis is on the advanced components of the Microsoft Office software. The student will be able to successfully complete the standards necessary for MOS Certification for Access 2003, PowerPoint 2003, Word 2003 and Excel 2003. ATTENDANCE: Students are expected to be present and punctual for all scheduled classes and labs. Students must be present 170 days out of 180 schools days (85 out of 90 A-Days). All work missed due to absence must be turned in within two school days after absents for credit. GRADING: Each student will be graded in the following three categories: Classwork 50% Tests 30% Work Ethic 20% GRADE ACHIEVEMENT LEVELS ARE AS FOLLOWS: Grade Range A 93%+ B 85-92% C 78-84% D 70-77% F 0-69% CLASSROOM ETIQUETTE: Please show courtesy to the class by restricting conversation to in-class topics, and raise your hand to gain attention when asking a question or raising a point of discussion. CLASSROOM RULES: ACT FRIENDLY PAY ATTENTION FOLLOW DIRECTIONS TURNING IN WORK: Be sure to include your name, class period and the date on all work to be turned in. Place it in the proper bin for class. DO NOT HAND WORK TO ME OR PLACE ON MY DESK. LATE COURSEWORK: All assignments are to be turned in on the due date. Late work may be accepted at the instructor’s discretion. UNITS OF INSTRUCTION: The units of instructions are derived from the state competencies and the schools scope and sequence. I will monitor and adjust the units of instruction throughout the year based on students’ previous knowledge and their ability to master the objectives. Supplemental materials will be added as needed to reinforce the standards and competencies. Levels of instruction will be monitored and review for student performance. Basic skills will be added to units as needed. All students will have equal opportunity for success in my classroom. Unit I: Keyboarding / Windows Review Time: 5 weeks Resources/Materials: Textbook, Microsoft Office software, MicroTypePro software Unit Objectives: Each student will set a word per minute typing goal above 25 words per minute. Learn and be able to use correct terminology for the computer in business situations Learn and develop a level of proficiency with Microsoft windows, including file management. Standards: Explain steps in the information processing Describe the steps in purchasing a personal cycle. computer. Identify and explain the components of a Demonstrate both cold and warm boots. computer system. Define path, prompt, root directory, sub- Categorize software according to function directory, and wildcard. (system and application). Identify basic functions and terminology Identify functions of input/output devices. associated with operating systems and system Categorize storage as primary or secondary. software (such as boot, MacIntosh, MS Define basic computer terminology (hardware, Windows, multitasking, GUI, icon, WYSIWYG, software, program, pixel, resolution, binary, mouse, minimize, and maximize). RAM, ROM, bit, and byte). Define characteristics of LANs, WANs, and Identify characteristics and limitations of various MANs. computers based on size and capabilities. Identify network hardware components. List examples of computer use in business, education, government, industry, and the home. Identify terms commonly found in personal computer advertisements. Unit II: Word Processing Time: 8 weeks Resources/Materials: Textbook, Microsoft Office software Unit Objectives: Learn and become proficient with different components of desktop publishing. This will include working with clip art and other various forms of graphics. Learn and become proficient at producing professional documents including multiple page flyers and newsletters. Understand and become proficient using the mail merge feature. Standards: Use the Undo, Redo, and Repeat Insert page numbers. command. Set page orientation. Apply font formats (bold, italics, and Set margins. underline). Use GoTo to locate specific elements in a Use the SPELLING feature. document. Use the THESAURUS feature. Create and modify page numbers. Use the GRAMMAR feature. Create and modify headers and footers. Insert page breaks. Align text vertically. Highlight text in document. Create and use newspaper columns. Insert and move text. Revise column structure. Cut, copy, paste, and paste special using Prepare and print envelopes and labels. the clipboard. Apply styles. Copy formats using the Format Painter. Create sections with formatting that differs Select and change font and font size. from other sections. Find and replace text. Use click and type. Apply character effects (superscript, Use save. subscript, strikethrough, small caps, and Locate and open an existing document. outline). Use Save As (different name, location, or Insert date and time. format). Insert symbols. Create a folder. Create and apply frequently used text with Create a new document using a wizard. AutoCorrect. Save a document as a Web page. Align text in paragraphs (center, left, right, Use templates to create a new document. and justified). Create hyperlinks. Add bullets and numbering. Use the Office Assistant. Set character, line, and paragraph Send a Word document via e-mail. spacing options. Create and format tables. Apply borders and shading to paragraphs. Add borders and shading to tables. Use indentation options (left, right, first Revise tables (insert and delete rows and line, and hanging). columns, and change cell formats). Use TABS command (center, decimal, Modify table structure (merge cells and left, and right). change height and width). Create an outline style numbered list. Rotate text in a table. Set tabs with leaders. Use the drawing toolbar. Use print preview. Insert graphics into a document (WordArt, Print a document. clip art, and images). Use Web Page Preview. Navigate through a document. Unit III: Spreadsheet Time: 8 weeks Resources/Materials: Textbook, Microsoft Office software Unit Objectives: Learn advanced formulas and functions Learn to create charts Learn advanced formatting techniques Standards: Use Undo and Redo. Set page margins and centering. Clear cell content. Insert and remove a page break. Enter text, dates, and numbers. Set print and clear a print area. Edit cell content. Set up headers and footers. Go to a specific cell. Set print titles and options (gridlines, print Insert and delete selected cells. quality, and row and column Cut, copy, paste, paste special, and move headings). selected cells; use the Office Clipboard. Insert and delete rows and columns. Use Find and Replace. Hide and unhide rows and columns. Clear cell formats. Freeze and unfreeze rows and columns. Work with series (AutoFill). Change the zoom setting. Create hyperlinks. Move between worksheets in a workbook. Use Save. Check spelling. Use Save As (different name, location, and Rename a worksheet. format). Insert and delete worksheets. Locate and open an existing workbook. Move and copy worksheets. Create a folder. Link worksheets and consolidate data Use templates to create a new workbook. using 3D References. Save a worksheet/workbook as a Web Enter a range within a formula by page. dragging. Send a workbook via E-mail. Enter formulas in a cell, and use the Use the Office Assistant. formula bar. Apply font styles (typeface, size, color, and Revise formulas. styles). Use references (absolute and relative). Apply number formats (currency, percent, Use AutoSum. dates, and comma). Use Paste Function to insert a function. Modify size of rows and columns. Use basic functions (AVERAGE, SUM, Modify alignment of cell content. COUNT, MIN, and MAX). Adjust the decimal place. Enter functions using the formula palette. Apply AutoFormat. Use date functions (NOW and DATE). Use the Format Painter. Use financial functions (FV and PMT). Apply cell borders and shading. Use logical functions (IF). Merge cells. Preview and print charts. Rotate text and change indents. Use chart wizard to create a chart. Define, apply, and remove a style. Modify charts. Preview and print worksheets and Insert, move, and delete an object workbooks. (picture). Use Web Page Preview. Create and modify lines and objects. Print a selection. Change page orientation and scaling. Unit IV: Database Time: 4 weeks Resources/Materials: Textbook, Microsoft Office software Unit Objectives: Learn formatting techniques for accessing data in a database Learn the concepts behind a relational database Standards: Determine appropriate data inputs for a Navigate through records in a table, database. query, or form. Determine appropriate data outputs for a Create a database (using a wizard or in database. Design View). Create table structure. Create tables by using the Table Wizard. Establish table relationships. Set primary keys. Use the Office Assistant. Modify field properties. Select an object using the Objects Bar. Use multiple data types. Print database objects (tables, forms, Modify tables using Design View. reports, and queries). Use the Lookup Wizard. Use the input mask wizard. Unit V: Presentation Software Time: 8 weeks Resources/Materials: Textbook, Microsoft Office software Unit Objectives: Focus on components of PowerPoint a business or organization would need like tables and organization charts. Learn how to jump, skip, and merge different presentations Develop a level of proficiency delivering presentations before an audience Standards: Create a presentation from a template Create a text box for entering text. and/or a wizard. Use the wrap text in text box feature. Create a blank presentation. Promote and demote text in slide and Create a specified type of slide. outline panes. Navigate among different views (slide, Add a picture from the ClipArt Gallery. outline, sorter, and tri-pane). Apply formatting. Delete slides. Scale and size an object including clip Change the order of slides using Slide art. Sorter view. Add slide transitions. Change the layout for one or more Animate text and objects. slides. Preview presentation in black and white. Modify slide sequence in the outline Print slides in a variety of formats. pane. Start a slide show on any slide. Apply a design template. Use screen navigation tools. Check spelling. Save changes to a presentation. Change and replace text fonts Save as a new presentation. (individual slide and entire presentation). Use Office Assistant. Enter text in tri-pane view. Change the text alignment. Unit VI: Integration / Review / MOS Test Time: 3 weeks Resources/Materials: Textbook, Microsoft Office software Unit Objectives: Use skills learned from the 4 different types of software to produce an integrated project Use practice software to review for MOS Test Standards: Produce documents integrating word processing, spreadsheet, database, and/or presentation files. Apply problem solving and critical thinking skills to projects and/or simulations.
Pages to are hidden for
"Business Computer Applications Syllabus - DOC"Please download to view full document