Info+Tech+II

Introductory Microsoft Office 2007 (Word & Excel) Course Technology, Cengage Learning, 2008 "The learner will . . ." || **Standard(s)** || **No. of Days** || **Vocabulary Terms** || **Resources** || **Student Learning Activities** || **Assessment** ||
 * Teachers **** : **** Lori McKenney **
 * Textbook: **
 * ~ (1) ||~ (2) ||~ (3) ||~ (4) ||~ (5) ||~ (6) ||~ (7) ||~ (8) ||~ (9) ||
 * **Obj #** || **Unit** || **Objective:**
 * 1-11 || ** Microsoft **
 * Access Unit ** || # Understand databases and database terminology.
 * 1) Start Access, open a database, and open an object.
 * 2) Identify the parts of the Access screen.
 * 3) Navigate a datasheet.
 * 4) Edit a record and undo a change.
 * 5) Select records and fields.
 * 6) Delete a record.
 * 7) Cut, copy, and paste data.
 * 8) Change the appearance of a datasheet.
 * 9) Preview and print a table.
 * 10) Close an object and exit Access. || Students will synthesize database management concepts to manage, evaluate, and organize information in an effective manner.

Explain the components of the database. || 5 || Best fit Compacting Database Database management system)DBMS) Datasheet Datasheet selector Datasheet view Field Field name Field selector Field value Navigation Pane Record Record selector || Textbook & Data Files Microsoft Office 2007 Step-by- Steps, Projects || Review questions, workbook questions, Test ||
 * Chapter 1**
 * Access ** || Lecture,
 * 1-7 || ** Microsoft **
 * Access Unit ** || # Create a database.
 * 1) Design, create, and save a table in Datasheet view.
 * 2) Set a field
 * 3) s data type in Datasheet view.
 * 4) Add, delete, rename, and move fields in Design view.
 * 5) Change field properties in Design view.
 * 6) Set field properties in Design view || Create and format a database.

Create and design a database to inventory a collection of personal items.

Create a database that will manage inventory (e.g., business, home, classroom, sports equipment). || 5 || Alphanumeric data AutoNumber Blank Database template Data type Default Value property Description property Design grid Field Properties pane Field property Field Size property Format property Primary key Required property Template || Textbook & Data Files Microsoft Office 2007 Step-by- Steps, Projects || Review questions, workbook questions, Test ||
 * Chapter 2**
 * Access ** || Lecture,
 * 1-7 || ** Microsoft **
 * Access Unit ** || # Create a query using a Wizard.
 * 1) Sort and filter data in a datasheet.
 * 2) Create a query in Design view.
 * 3) Create relationships in a database.
 * 4) Create a table based on more than one table.
 * 5) Use operators in a condition in a query.
 * 6) Calculate data using a query. || Define database terminology (e.g., tables, fields, records, keys, field types, views).

Create database objects (e.g., tables, forms, queries).

Query and filter desired information from the statistical database created. || 5 || And operator, Ascending, AutoFilter, Calculated field, Common field, Condition, Criteria Criterion, Descending, Detail query, Exact match condition, Expression, Filter Filter By Form, Filter By Selection, Foreign key, Join line, Matching field, Multitable query, One-to9-many relationship, Or operator, Primary table, Query, Rang-of-Values condition, Referential integrity, Related table, Relationship, Run, Simple Query Wizard, Sort, Subdatasheet, Summary query, Total row || Textbook & Data Files Microsoft Office 2007 Step-by- Steps, Projects || Review questions, workbook questions, Test ||
 * Chapter 3**
 * Access ** || Lecture,
 * 1-9 || ** Microsoft **
 * Access Unit ** || # Create a form using different form tools.
 * 1) Create a form using the Form Wizard.
 * 2) Navigate records using a form.
 * 3) Use a form to find and replace data.
 * 4) Use a form to update and delete data.
 * 5) Create and modify a form in Layout view.
 * 6) Resize and move controls in a form.
 * 7) Add an unbound control to a form in Design view.
 * 8) Preview and print a form. || Create database objects (e.g., tables, forms, queries).

Modify or enter records, create reports, and/or sort data.

Inventory a second collection of items using an existing database. || 5 || AutoFormat Bound control Control Control layout Datasheet tool Detail section Field List pane Find Form Form Footer section Form Header section Form tool Form view Form Wizard Layout new Multiple Items tool Record source Split Form tool Unbound control || Textbook & Data Files Microsoft Office 2007 Step-by- Steps, Projects || Review questions, workbook questions, Test || Label Wizard Line tool Print preview Read-only Report Report selector Report tool Report Wizard || Textbook & Data Files Microsoft Office 2007 Step-by- Steps, Projects || Review questions, workbook questions, Test ||
 * Chapter 4**
 * Access ** || Lecture,
 * 1-6 || ** Microsoft **
 * Access Unit ** || # Create a report using the Report tool, the Label Wizard, and the Report Wizard.
 * 1) Modify a report in Layout view.
 * 2) Modify a report in Design view.
 * 3) Add a line, label, and picture to a report.
 * 4) Move a control in a report.
 * 5) Set a report's properties. || Create a report from previously established data. || 5 || Grouping level
 * Chapter 5**
 * Access ** || Lecture,
 * 1-5 || ** Microsoft **
 * Access Unit ** || # Import data from other Office programs into a database.
 * 1) Export data from a database to other Office programs.
 * 2) Create a form letter.
 * 3) Merge a form letter with a data source.
 * 4) Edit a data source to print specific form letters. || Compare and contrast methods for storing, organizing, and retrieving data.

Analyze and draw conclusions about trends and relationships in data.

Modify, enter, and/or sort previously established data. || 5 || Comma-separated values (CSV) Data source Delimited data Delimiter Export Form letter Import Main document Merge field || Textbook & Data Files Microsoft Office 2007 Step-by- Steps, Projects || Review questions, workbook questions, Test ||
 * Chapter 6**
 * Access ** || Lecture,
 * 1-10 || ** Microsoft **
 * Publisher Unit ** || # Start Publisher.
 * 1) Choose a template.
 * 2) Understand the Publisher window and task panes.
 * 3) Create a business information set.
 * 4) Save a publication.
 * 5) Modify a publication.
 * 6) Insert a design gallery object.
 * 7) Use the Design Checker.
 * 8) Print a publication.
 * 9) Close a publication. || Students will use document processing applications to prepare business communications.

Create, edit, and format documents using effective techniques.

Complete formatting activities (e.g., tables, report, letter, email, brochure, multi-page research). || 5 || Business information set Design gallery object Design Checker Logo Publication Types list Task pane Template || Textbook & Data Files Microsoft Office 2007 Step-by- Steps, Projects || Review questions, workbook questions, Test ||
 * Chapter 1**
 * Publisher ** || Lecture,
 * 1-8 || ** Microsoft **
 * Publisher Unit ** || # Understand guides.
 * 1) Enter text.
 * 2) Insert pictures.
 * 3) Work with objects.
 * 4) Use the Content Library.
 * 5) Insert text from a Word document.
 * 6) Use Find and Replace.
 * 7) Check the spelling in a publication. || Students will use document processing applications to prepare business communications.

Create, edit, and format documents using effective techniques.

Complete formatting activities (e.g., tables, report, letter, email, brochure, multi-page research). || 5 || Content Library Layout guides Master page Object Page navigator Panel heading || Textbook & Data Files Microsoft Office 2007 Step-by- Steps, Projects || Review questions, workbook questions, Test || Layout Live Preview Microsoft Office Button Normal view Notes Page view Outline tab PowerPoint presentation Publishing Quick Access Toolbar Ribbon Slide layout Slide pane Slide Show view Slide Sorter view Slides tab Status bar Tab Task pane Thumbnails Title bar Transition Zoom Slider || Textbook & Data Files Microsoft Office 2007 Step-by- Steps, Projects || Review questions, workbook questions, Test ||
 * Chapter 2**
 * Publisher ** || Lecture,
 * 1-13 || ** Microsoft **
 * PowerPoint Unit ** || # Start PowerPoint.
 * 1) Understand the elements of the PowerPoint window.
 * 2) Open an existing presentation.
 * 3) Save a presentation.
 * 4) Navigate through a presentation.
 * 5) Change views.
 * 6) Use the Slides and Outline tabs.
 * 7) Use the Ribbon.
 * 8) Use the Slide pane and Notes pane.
 * 9) Change the layout.
 * 10) Delete a slide.
 * 11) Print a presentation.
 * 12) Exit PowerPoint. || Students will demonstrate effective professional communication skills and practices. || 5 || Animation
 * Chapter 1**
 * PowerPoint ** || Lecture,
 * 1-19 || ** Microsoft **
 * PowerPoint Unit ** || # Create presentations.
 * 1) Insert headers and footers.
 * 2) Apply themes.
 * 3) Use the Slide master.
 * 4) Use the Notes and Handout Master.
 * 5) Edit pictures.
 * 6) Add slides.
 * 7) Find and replace text.
 * 8) Add text to slides.
 * 9) Add notes to slides.
 * 10) Change alignment, spacing, case and tabs.
 * 11) Work with bullets.
 * 12) Change font attributes.
 * 13) Check spelling, style, and usage.
 * 14) Format slides.
 * 15) Add clip art and sounds to slides.
 * 16) Insert hyperlinks.
 * 17) Apply custom animation.
 * 18) Apply slide transitions. || Prepare and develop professional presentations.

Complete an interactive presentation project using a web tool. || 5 || Animation Blank presentation Design template Effects Options Handout Master Hyperlink Layout master Live Preview Motion Paths Notes Master Placeholder Slide Master Slide transitions || Textbook & Data Files Microsoft Office 2007 Step-by- Steps, Projects || Review questions, workbook questions, Test || Cell Chart (graph) Column Datasheet Grouping Handle Organization chart Rotate handle Row SmartArt graphic Table WordArt || Textbook & Data Files Microsoft Office 2007 Step-by- Steps, Projects || Review questions, workbook questions, Test || Comment Custom show Destination file Document Inspector Document properties Embed Format Painter Grid Guides Link Linked object Package for CD Snap to Source file || Textbook & Data Files Microsoft Office 2007 Step-by- Steps, Projects || Review questions, workbook questions, Test ||
 * Chapter 2**
 * PowerPoint ** || Lecture,
 * 1-17 || ** Microsoft **
 * PowerPoint Unit ** || # Insert a SmartArt graphic.
 * 1) Convert text to a Smart Art graphic.
 * 2) Change the style of a SmartArt graphic.
 * 3) Add and format an organization chart.
 * 4) Enter text into a SmartArt graphic.
 * 5) Create and format WordArt
 * 6) Build and format charts.
 * 7) Create a table.
 * 8) Modify a table's style and layout.
 * 9) Draw, select, manipulate, and format an object.
 * 10) Scale and size an object.
 * 11) Copy, move, and group objects.
 * 12) Create a text box on a shape.
 * 13) Animate shapes.
 * 14) Order visual elements on a slide.
 * 15) Insert objects on a slide.
 * 16) Add a header or footer. || Utilize advanced techniques (e.g., timings, animations, master slides, templates). || 5 || Adjustment handle
 * Chapter 3**
 * PowerPoint ** || Lecture,
 * 1-10 || ** Microsoft **
 * PowerPoint Unit ** || # Integrate PowerPoint with other Office programs.
 * 1) Create a new master.
 * 2) Create new layout masters.
 * 3) Format text and objects.
 * 4) Align text and pictures.
 * 5) Insert comments.
 * 6) Set up a slide show.
 * 7) Package a presentation.
 * 8) Save a presentation via e-mail.
 * 9) Create output. || Demonstrate web production and publication, advanced drawing tools, action buttons,media clips, and media incorporated into a presentation. || 5 || Action button
 * Chapter 4**
 * PowerPoint ** || Lecture,
 * || ** Microsoft **
 * PowerPoint Unit ** ||  || Prepare and develop professional presentations.

Utilize advanced techniques (e.g., timings, animations, master slides, templates). || 15 ||  || Textbook Chapters 1-4 Microsoft Office 2007
 * PowerPoint ** || Culminating Project - Create a PowerPoint presentation of your family tree. Using the concepts learned in this Unit. Chart it out and have pictures of as many of your ancestors as possible. || Present to the class. ||
 * || ** Microsoft **
 * PowerPoint Unit ** ||  || Prepare and develop professional presentations.

Utilize advanced techniques (e.g., timings, animations, master slides, templates). || 8 ||  || Textbook Chapters 1-4 Microsoft Office 2007
 * PowerPoint ** || Project - Create a PowerPoint presentation depicting your Freshman year of high school. Describe activities, sports, and schedule of classes. Include pictures of each thing you were involved in. || Present to the class. ||