Info+Tech+I

"The learner will . . ." || **Standard(s)** || **No. of Days** || **Vocabulary Terms** || **Resources** || **Student Learning Activities** || **Assessment** || LA 12.1.5.c Independently apply appropriate strategy to determine meaning of unknown words in text.
 * Teachers **** : Lori McKenney **
 * Textbook: ** Introductory Microsoft Office 2007 (Word & Excel) Course Technology, Cengage Learning, 2008
 * ~ (1) ||~ (2) ||~ (3) ||~ (4) ||~ (5) ||~ (6) ||~ (7) ||~ (8) ||~ (9) ||
 * **Obj #** || **Unit** || **Objective:**
 * 1-10 || ** Introduction **
 * Unit ** || # Explain the concept of an integrated software package.
 * 1) Start an Office program from Windows.
 * 2) Explain the features of the program window.
 * 3) Know how to use the Ribbon and contextual tools.
 * 4) Open an existing Office file.
 * 5) Save and close an Office file.
 * 6) Know the shortcuts for opening recently used files.
 * 7) use the Office Help system.
 * 8) Exit an Office program.
 * 9) Use a Web browser to visit a Web site. || LA 12.1.5.a Determine meaning of words through structural analysis, using knowledge of Greek, Latin, and Anglo-Saxon roots, prefixes, and suffixes to understand complex words, including words in science, mathematics, and social studies. LA 12.1.5.b Relate new grade level vocabulary to prior knowledge and use in new situations.

Students will demonstrate positive cyber citizenship by applying industry accepted ethical practices and behaviors. Examine and practice cultural, social, ethical, and legal issues associated with information technology. || 5 || Button, Contextual tab, Dialog box, File extension, Gallery, Group, Home page, Icon, Insertion point, Internet, Link, Live Preview, Menu, Microsoft Office 2007 (Office), Mini Toolbar, Office Button, Program window, Quick Access Toolbar, Ribbon, Screen Tip, Scroll Bar, Shortcut menu, Sizing button, Status bar, Tab, Task pane, Title bar, Toolbar, Uniform Resource Locator (URL), Web browser, Work area, World Wide Web (Web)

Lesson-Private Today, Public Tomorrow

Lesson - Risky Online Relationships || Textbook & Data Files **Chapter 1** Microsoft Office 2007 ** Basics and The Internet **


 * Common Sense Media E-rate Toolkit (Internet Safety) **

www. common sensemedia. org/educators /erate || Lecture, Step-by-Steps, Projects || Review questions, workbook questions, Test ||
 * 1-14 || ** Microsoft Word Unit ** || # Start Word and identify the parts of the opening screen.
 * 1) Understand the five ways to view your document on the screen.
 * 2) Enter text in a document.
 * 3) Navigate a document.
 * 4) Use the Backspace and Delete keys to correct errors.
 * 5) Save a document.
 * 6) Create a folder in which to store your document.
 * 7) Locate and open an existing document.
 * 8) Create a new, blank document.
 * 9) magnify and reduce the document using the Zoom feature.
 * 10) Use Full Screen Reading view and preview a document.
 * 11) Change the page orientation of a document.
 * 12) Print a document.
 * 13) Exit Word. || Students will use document processing applications to prepare business communications.

Create, edit, and format documents using effective techniques || 5 || Draft view, full Screen Reading view, Insertion point, Landscape orientation, Office button, Outline view, Portrait orientation Print Layout view, quick Access Toolbar, Ribbon, Status bar, Toolbar, View buttons, Web Layout view, Word processing, Word wrap, Zoom, Zoom slider || Textbook & Data Files **Chapter 1** Microsoft Office 2007 ** Word ** || Lecture, Step-by-Steps, Projects || Review questions, workbook questions, Test ||
 * 1-10 || ** Microsoft Word Unit ** || # Select text.
 * 1) Show and hide formatting marks.
 * 2) Understand toggle commands.
 * 3) Create paragraphs without blank space between them.
 * 4) Undo, redo, and repeat recent actions.
 * 5) Move and copy text using drag-and-drop and the Clipboard.
 * 6) use the Office Clipboard.
 * 7) Find and replace text.
 * 8) use the Go To command.
 * 9) Identify the number of words in a document or a selection. || Students will use document processing applications to prepare business communications.

Create, edit, and format documents using effective techniques || 5 || Clipboard (system Clipboard), Copy, Cut, Drag, Drag-and-drop, Find, Format, Go To, Office Clipboard, Paste Paste Options, Quick Style, Redo, Repeat, Replace, Select, Show/Hide, Toggle, Undo, Wildcard || Textbook & Data Files **Chapter 2** Microsoft Office 2007
 * Word ** || Lecture, Step-by-Steps, Projects || Review questions, workbook questions, Test ||
 * 1-5 || ** Microsoft Word Unit ** || # Use automatic features including AutoCorrect, AutoFormat As You Type, Quick Parts, and AutoComplete.
 * 1) Insert the current date and time.
 * 2) Check the spelling and grammar in a document.
 * 3) Use the Thesaurus.
 * 4) Insert symbols. || Students will use document processing applications to prepare business communications.

Create, edit, and format documents using effective techniques || 5 || AutoComplete, AutoCorrect, AutoFormat As You Type, Automatic grammar checking, Automatic spell checking, Building block, Contextual spell checking, Format, Quick Part, Quick Style, Superscript, Thesaurus || Textbook & Data Files **Chapter 3** Microsoft Office 2007
 * Word ** || Lecture, Step-by-Steps, Projects || Review questions, workbook questions, Test ||
 * 1-9 || ** Microsoft Word Unit ** || # Change the font.
 * 1) Change the size, color, and tyle of text.
 * 2) Use different underline styles and font effects.
 * 3) Highlight text.
 * 4) Copy formatting using the Format Painter.
 * 5) Understand styles and apply Quick Styles.
 * 6) Change the theme.
 * 7) Create new Quick Styles.
 * 8) Clear formatting. || Apply digital design stategies to design professional documents (e.g., graphic design, layout, typography, font face, font style). || 5 || Attribute, Color palette, Font, font effect, Font size, Font style, Format Painter, Point, Style, Theme || Textbook & Data Files **Chapter 4** Microsoft Office 2007
 * Word ** || Lecture, Step-by-Steps, Projects || Review questions, workbook questions, Test ||
 * 1-10 || ** Microsoft Word Unit ** || # Show and hide the ruler.
 * 1) Set the margins of a document.
 * 2) Align text.
 * 3) Adjust paragraph indents.
 * 4) Adjust line and paragraph spacing.
 * 5) Change vertical alignment.
 * 6) Set and modify tab stops.
 * 7) Create and modify bulleted and numbered lists.
 * 8) Create an outline numbered list.
 * 9) Organize a document in Outline view. || Standard 2 - Students will use document processing applications to prepare business communications.

Benchmark 2.3 Apply digital design strategies to design professional documents.

Performance Indicator 2.3.1 Create and publish a newsletter.

Performance Indicator 2.3.2 Create documents with a professional appeal. || 5 || Alignment, Bullet, Center, First-line indent, Hanging indent, Indent, Inside margin (gutter margin), Justify, Leader, left-align, Margin, Mirrored margins, Multilevel list, Negative indent (outdent), Outline numbered list, Outside margin, Right-align, Tab stop (tab), Vertical alignment || Textbook & Data Files **Chapter 5** Microsoft Office 2007
 * Word ** || Lecture, Step-by-Steps, Projects || Review questions, workbook questions, Test ||
 * 1-12 || ** Microsoft Word Unit ** || # Create columns.
 * 1) Add borders and shading.
 * 2) Understand objects and how to use them in documents.
 * 3) Insert Clip Art and pictures.
 * 4) Insert, resize, and move inline objects.
 * 5) Change an inline object to a floating object.
 * 6) Recolor graphics.
 * 7) Draw and modify shapes.
 * 8) Add text to drawings.
 * 9) Create callouts.
 * 10) Create and modify SmartArt.
 * 11) Create and modify WordArt. || Create documents with a professional appeal (e.g., flyer, brochure, invitation).

Standard 2 Students will use document processing applications to prepare business communications.

Standard 3 Students will demonstrate effective professional communication skills and practices. || 5 || Aspect ratio, Callout, Chart, Clip art, Crop, Diagram, Floating object, Graphic, Inline object, Keyword, Object, Pull quote, Rotation handle, Selection rectangle, Sidebar, Sizing handle, SmartArt, Text box, WordArt || Textbook & Data Files **Chapter 6** Microsoft Office 2007 Document Information Panel, Footer Gridline, Header, Orphan Page break, Property, Section, Sort, Table, Widow || Textbook & Data Files **Chapter 7** Microsoft Office 2007 Complete mail merge activity (e.g., holiday letter, sports camp, alumni communication, graduation labels). Problem solve during mail merge process. || 5 || Data source, Mail merge, Main document, Merge field, Template, Track Changes, Workgroup collaboration || Textbook & Data Files **Chapter 8** Microsoft Office 2007
 * Word ** || Lecture, Step-by-Steps, Projects || Review questions, workbook questions, Test ||
 * 1-11 || ** Microsoft Word Unit ** || # Insert page breaks.
 * 1) Understand content controls.
 * 2) Insert and modify headers and footers.
 * 3) Insert page numbers.
 * 4) Modify document properties.
 * 5) Insert predesigned cover pages.
 * 6) Create a section with formatting that differs from other sections.
 * 7) Use the Research tool.
 * 8) Insert, modify, and format tables.
 * 9) Convert text into tables.
 * 10) Sort text. || Create documents with a professional appeal (e.g., flyer, brochure, invitation). || 5 || Cell, Content control
 * Word ** || Lecture, Step-by-Steps, Projects || Review questions, workbook questions, Test ||
 * 1-9 || ** Microsoft Word Unit ** || # Use and create templates.
 * 1) Use mail merge.
 * 2) Create and print envelopes and labels.
 * 3) Understand workgroup collaboration.
 * 4) Insert, view, edit, and print comments.
 * 5) Track changes.
 * 6) Accept and reject changes and delete comments.
 * 7) Combine different versions of of a document.
 * 8) Customize Word. || Prepare and troubleshoot merged documents (e.g., envelopes, mailings, labels).
 * Word ** || Lecture, Step-by-Steps, Projects || Review questions, workbook questions, Test ||
 * 1-11 || ** Microsoft Excel Unit ** || # Define the terms //spreadsheet// and //worksheet//.
 * 1) Identify the parts of a worksheet.
 * 2) Open an existing workbook.
 * 3) Save a workbook.
 * 4) Move the active cell in a worksheet.
 * 5) Select cells and enter data in a worksheet.
 * 6) Edit data in cells.
 * 7) Find and replace data.
 * 8) Zoom in a worksheet.
 * 9) Preview and print a worksheet.
 * 10) Close a workbook. || NE Standard 1: Students will demonstrate positive cyber citizenship by applying industry accepted ethical practices and behaviors.

Examine and practice cultural, social, ethical, and legal issues associated with information technology.

Evaluate safety and security measures for protecting information and developing digital footprints. Explore one's digital footprint. Discuss risks of sharing personal information. Explore identity theft scenarios. || 5 || Active cell, Active worksheet, Cell, Cell reference, Column, Formula, Formula Bar, Microsoft Office Excel 2007 (Excel), Name Box, Range, Range reference, Row, Sheet tab, Spreadsheet, Workbook, Worksheet

Lesson - College Bound

Lesson - Taking Perspectives on Cyberbullying || Textbook & Data Files **Chapter 1** Microsoft Office 2007 ** Excel **

​
 * Common Sense Media E-rate Toolkit (Internet Safety) **

www. common sensemedia. org/educators /erate || Lecture, Step-by-Steps, Projects || Review questions, workbook questions, Test ||
 * 1-7 || ** Microsoft Excel Unit ** || # Change column widths and row heights.
 * 1) Position data within a cell by aligning, wrapping, rotating, and indenting.
 * 2) Change the appearance of cells using fonts, font sizes, font styles, colors, and borders.
 * 3) Designate the number format used for data stored in a cell.
 * 4) Use the Format Painter to copy formatting from one cell to another.
 * 5) Apply and clear cell styles.
 * 6) Find and replace cell formats. || NE Standard 4: Students will employ spreadsheet applications to organize and manipulate data. || 5 || Alignment, AutoFit, Border, Cell style, Clear, Column heading, Editing mode, Fill, Font Font size, Font style, Format Painter, Indent, Live Preview, Merge, Number format, Orientation, Points, Row heading, Style, Theme, Truncate, Wrap text || Textbook & Data Files **Chapter 2** Microsoft Office 2007
 * Excel ** || Lecture, Step-by-Steps, Projects || Review questions, workbook questions, Test ||
 * 1-8 || ** Microsoft Excel Unit ** || # Copy and move data to other cells.
 * 1) Use the drat-and-drop method and Auto Fill options to add data to cells.
 * 2) Insert and delete rows, columns, and cells.
 * 3) Freeze panes in a worksheet.
 * 4) Split a worksheet window.
 * 5) Check spelling in a worksheet.
 * 6) Prepare a worksheet for printing.
 * 7) Insert headers and footers. || Preview printing and correct potential error (e.g., page orientation, files larger than paper size, printing formulas, grid lines, fit to page, print selection). || 5 || Automatic page break, Copy, Cut, Fill, Fill handle, Footer, Freeze pane, Header, Landscape orientation, Manual page break, Margins, Normal view, Office Clipboard (Clipboard), Page Break Preview, Page Layout view, Paste, Portrait orientation, Print area, Print title, Scale, Split || Textbook & Data Files **Chapter 3** Microsoft Office 2007
 * Excel ** || Lecture, Step-by-Steps, Projects || Review questions, workbook questions, Test ||
 * 1-7 || ** Microsoft Excel Unit ** || # Enter and edit formulas.
 * 1) Distinguish between relative, absolute, and mixed cell references.
 * 2) Use the point-and-click method to enter formulas.
 * 3) Use the Sum button to view summary calculations.
 * 4) Preview a calculation.
 * 5) Display formulas instead of results in the worksheet.
 * 6) Manually calculate formulas. || Enter, modify worksheet data, structure, format data, and problem solve in a worksheet. || 5 || Absolute cell reference, Formula, Manual calculation, Mixed cell reference, Operand, Operator, Order of evaluation, Point-and-click method, Relative cell reference, Sum button || Textbook & Data Files **Chapter 4** Microsoft Office 2007
 * Excel ** || Lecture, Step-by-Steps, Projects || Review questions, workbook questions, Test ||
 * 1-8 || ** Microsoft Excel Unit ** || # Identify the parts of a function.
 * 1) Enter formulas with functions.
 * 2) Use functions to solve mathematical problems.
 * 3) Use functions to solve statistical problems.
 * 4) Use functions to solve financial problems.
 * 5) Use logical functions to make decisions with worksheet data.
 * 6) Use functions to insert times and dates in a worksheet.
 * 7) Use text functions to format and work with cell contents. || Utilize gradebook spreadsheet to sort grades high to low.

Create a formula to calculate average grades.

Create a variety of appropriate charts representing grades.

Use the RATE function to calculate the interest rate for a loan. || 5 || Argument, Date and time functions, Financial functions, Formula AutoComplete, Function, Logical functions, mathematical functions, Statistical functions, Text functions, Trigonometric functions || Textbook & Data Files **Chapter 5** Microsoft Office 2007 Active sheet, Destination, Sheet tab, Source, Worksheet range || Textbook & Data Files **Chapter 7** Microsoft Office 2007 Chart Chart area Chart sheet Chart style Column chart Data label Data marker Data series Data source Data table Embedded chart Exploded pie chart Legend Line chart Pie chart Plot area Scatter chart Selection box Sizing handles || Textbook & Data Files **Chapter 8** Microsoft Office 2007
 * Excel ** || Lecture, Step-by-Steps, Projects || Review questions, workbook questions, Test ||
 * 1-12 || ** Microsoft Excel Unit ** || # Sort data in a worksheet.
 * 1) Use AutoFilter to display only specified data in a worksheet.
 * 2) Apply conditional formatting to highlight data.
 * 3) Hide worksheet columns and rows.
 * 4) Insert a shape in a worksheet.
 * 5) Insert a SmartArt graphic in a worksheet.
 * 6) Insert a picture in a worksheet.
 * 7) Use a template to create a new workbook.
 * 8) Insert a hyperlink in a worksheet.
 * 9) Save a workbook in a different file format.
 * 10) Insert, edit, and delete comments.
 * 11) Use the Research task pane. || Sort data, manipulate data using formulas and functions, and create charts. || 5 || Ascending sort, Auto Filter, Comment, Conditional formatting, Descending sort, Filter, Filter arrows, Hyperlink, Object, Picture, Research task pane, SmartArt graphic, Sort, Template || Textbook & Data Files **Chapter 6** Microsoft Office 2007
 * Excel ** || Lecture, Step-by-Steps, Projects || Review questions, workbook questions, Test ||
 * 1-11 || ** Microsoft Excel Unit ** || # Move between worksheets in a workbook.
 * 1) Rename worksheets.
 * 2) Change the color of sheet tabs.
 * 3) Reposition worksheets.
 * 4) Hide and unhide worksheets.
 * 5) Insert and delete worksheets.
 * 6) Create cell references to other worksheets.
 * 7) Create 3-D references.
 * 8) Print all or part of workbooks.
 * 9) Arrange multiple workbooks in the program window.
 * 10) Move and copy worksheets between workbooks. ||   || 5 || 3-D reference,
 * Excel ** || Lecture, Step-by-Steps, Projects || Review questions, workbook questions, Test ||
 * 1-12 || ** Microsoft Excel Unit ** || # Identify the purpose of charting worksheet data.
 * 1) Identify the types of charts you can create in Excel.
 * 2) Create a chart embedded in a worksheet.
 * 3) Move a chart to a chart sheet.
 * 4) Update a data source.
 * 5) Select chart elements.
 * 6) Choose a chart layout and style.
 * 7) Create a 3-D chart.
 * 8) Display or hide chart elements.
 * 9) Format and modify a chart.
 * 10) Edit and format chart text.
 * 11) Change the chart type. || Sort data, manipulate data using formulas and functions, and create charts. || 5 || Axis
 * Excel ** || Lecture, Step-by-Steps, Projects || Review questions, workbook questions, Test ||
 * ||  ||   ||   ||   ||   || Textbook ||   || Semester Test - Creating "Real-Life" documents used in running a ranch. ||

 l Start Word and identify the parts of the opening screen  l Understand the five ways to view your document on the screen  l Enter text in a document  l Navigate a document  l Use the Backspace and Delete keys to correct errors  l Save a document  l Create a folder in which to store your document  l Locate and open an existing document  l Create a new, blank document  l Magnify and reduce the document using the Zoom feature  l Use Full Screen Reading view and preview a document  l Change the page orientation of a document  l Print a document  l Exit Word