Www.quia.com



Professor- Mr. Luis F. Carias

Grade Breakdown, Syllabus, and Field Trip

Microsoft Office Applications 2008

OVERALL OBJECTIVE/GOALS

Students will learn about the skills, concepts and procedures of Microsoft Office Applications 2007-(Word, Excel, PowerPoint, Access, and Outlook) that can be used in real-life situations and also improve their typing speed and skills through practical daily activities that could include:

1) Online typing practice exercises at website school..

2) Notes, Procedures, and Exercises from the textbook, Learning Microsoft Office 2007 and notes produced with class participation.

3) Online Quizzes at website pages/microsoftofficeapps.html.

4) Completing Surveys for reporting typing scores and rating of understanding of concepts found at the class website.

5) Multiple Choice Paper Tests/Concept Tests after each Major Chapter.

GRADE BREAKDOWN

I. Section In-Class/Homework Exercises- From the Book 40%

II. Project Based Assessments- Teacher Created 20%

• Replication of a Restaurant Menu-

o “ Daisy May’s BBQ Restaurant Menu” 5%

• Creation of a Personal Resume 5%

• Creation of a PowerPoint Presentation 5%

• Creation of an Excel Database 5%

III. Online Typing Pal Practice Exercise with Surveys- 15%

IV. Paper Test- 15%

• Pre-Test- Full Credit (5%)

• Post Test- Graded (5%)

• Chapter Paper Test/Concept Test- Graded (5%)

V. Practice Online Quizzes/In-Class and for Homework- 10%

Total 100%

CLASS PHILOSOPHY- MISSION

The class mission is in line with the School’s mission in that the class will strive to educate students by providing the Microsoft Office concepts and skills that will prepare our diverse class to become invested, productive citizens and members of American society who ultimately give back to family and community. We will accomplish this through excellence in teaching and learning in partnership with the community and by fostering a safe and compassionate learning environment.

MICROSOFT OFFICE APPLICATIONS SYLLABUS 09/2008

|Week |Course Topic |Textbook pages |Curriculum Objective- SWBATs |

| | |Introductions, Pre-Test, All-School Assembly, Student Book Purchases, Student Handbook, |Getting Started with |SWBAT |

| | | |Microsoft Office Word|Students use menus, commands, ribbon, access keys, office |

|1 |9/1 |Teacher Created following activity as a diagnostic of student comprehension level. |2007 |button, quick access toolbar, mini toolbar, dialog box |

| | | |(Pages 1-30) |options, short cut menu, task panes, and window controls |

| | |Objectives 09/01-09/04 | |(Page 2 of Curriculum Map) |

| | |Objective(s) for the day- | |Create and type a new document |

| | |Format the contents of a personal letter document in the following way: | |Select and replace text |

| | |Opening a blank document. | |Align text horizontally and vertically |

| | |Typing and inserting text with correct font style and font size. | |(Page 3 of Curriculum Map) |

| | |Creating a bulleted or numbered lists. | | |

| | |Justifying text alignment. | | |

| | |Saving a document to the correct folder and with a correct name. | | |

| | |Differentiation for Advanced Students- They can complete the whole handout. | | |

| | |Formatting paragraphs- changing spacing in a paragraph from single to double spaced. | | |

| | |Removing an automatic hyperlink. | | |

| | |Insert picture as a watermark. | | |

| | | | | |

| | |Word Knowledge Survey to check off those procedures that they feel most comfortable in completing. | | |

| | |Students will type up two paragraphs of a personal letter with specific instructions as shown in the | | |

| | |handouts provided to be able to: | | |

| | |Font Size and Font Type | | |

| | |Bullets | | |

| | |Paragraph-Text Alignment- Justify | | |

| | |Differentiation for Advanced Students- They can complete the whole handout. | | |

| | |Line Spacing | | |

| | |Hyperlink | | |

| | |Watermark | | |

| | | | | |

| | | | | |

| | | | | |

| | | | | |

| | |09/04 Objectives- | | |

| | |Use your Books, pages (10-15) and page 33 to understand The Location and Function for the following: | | |

| | |ribbon | | |

| | |TABS/contextual tabs | |SWBAT(same as above |

| | |quick access toolbar | |Students use menus, commands, ribbon, access keys, office |

| | |menu( Font Menu)- | |button, quick access toolbar, mini toolbar, dialog box |

| | |Command button (Underline)- | |options, short cut menu, task panes, and window controls |

| | |Dialog Box | |(Page 2 of Curriculum Map) |

| | |Task Pane | |Create and type a new document |

| | |Office Button | |Select and replace text |

| | | | |Align text horizontally and vertically |

| | | | |(Page 3 of Curriculum Map) |

| | | ( Mon/Tues 09/08 and 09/09) |Microsoft Office Word|SWBAT |

| | |Exercise 1- pages 31-41 |2007 |Start Word and discuss word window, change word window. |

|2 |9/8 |Understand Default, View, Elements, Paragraph Mark, |Pages 31-60 |Create and type in a new document; |

| | |In Class Quiz as Posted Above(09/09) | |Use Undo, redo and repeat |

| | | | |Save and close a document and exit Word |

| | |Exercise 2- pg.41-46 (Wed. 09/10) | |Display Nonprinting characters, position and move the |

| | |Use the Thesaurus | |insertion point. |

| | |Select nonprinting characters to display; | |Correct spelling and grammar, use the Thesaurus |

| | |Position and move with the insertion point; | |Slect and replace text. |

| | |Use Quickprint to print with the Default Settings; | |Align text horizontally and vertically |

| | |Preview a Document. | |Set up a memo and format a business letter. |

| | |In Class Quiz as Posted Above(09/10) | |(Page 3 of the Curriculum Map) |

| | | | | |

| | |Exercise 3- pg.47-51 (Thurs. 09/11) | | |

| | |Correct Spelling as you Type; | | |

| | |Correct Grammar as you Type; | | |

| | |Check Spelling and Grammar; | | |

| | |Use the Thesaurus | | |

| | |In Class Quiz as Posted above(09/11) | | |

| | | | | |

| | | | | |

| | | | | |

| | | | | |

| | |Monday SWBAT- 09_15_2008 and 09/16/2008 |Microsoft Office Word|SWBAT |

|3 |9/15 |Objectives- Exercise 4- pg.53-59 |2007 |Align text vertically and horizontally |

| | |Use Autocorrect Options; |Pages 31-60 |Display Nonprinting characters, position and move the |

| | |Highlight Contiguous and Noncontiguous text; | |insertion point |

| | |Use Line Spacing (Previously covered); | |Save and close a document and exit Word |

| | |Use Paragraph Spacing; | |(Page 3 of Curriculum Guide) |

| | |Align Text Horizontally(Previously covered); | | |

| | |Align Text Vertically. | | |

| | |In Class Quiz as Posted Above(09/15) | | |

| | |In Class Quiz as Posted Above(09/16) | | |

| | | | | |

| | | | | |

| | |Activites 09/17/2008 | | |

| | |Go online to school.. and register with an account let me know. Exercise your typing | | |

| | |skills. | | |

| | |Elect Student Goverment Representative- (5-10 minutes) | | |

| | |Talk about Goal Setting and Set our Goals. (10-20 minutes) | | |

| | |Open the document below called "Summary of Required and Extra Credit Exercises." It is found at the | | |

| | |bottom of the webpage.Go over the required and extra credit assignments.Student’s work to catch up on | | |

| | |completing assignments. | | |

| | | | | |

| | |9/18 Practice Quiz- Teacher Created- Practice Quiz as Posted Above | | |

| | |and Finish Exercise 4 Activity on page 58 and Complete any other Exercises Missing. | | |

| | | | | |

| | | | | |

| | | | | |

| | |09/22 and 09/23- Objectives- Exercise 5 | |SWBAT |

| | |Students will be able to format a Full Block business letter. | |Format a business letter |

|4 |9/22 |Students will be able to identify the parts of a business letter. | |Create Envelopes and labels |

| | |Students will be able to insert the date and time manually or as a field. | |Insert the date and time |

| | |Students will be able to change the case of the font and understand each type of case. | |Change case in a document |

| | |Students will be able to use the shrink to one page option in print preview. | |Set Tabs |

| | |Students will be able to use the Editing Feature to replace text with different format. | |Apply font styles and underlines |

| | | | |Apply software and application skills to demonstrate |

| | |09/24 and 09/25- Objectives - Exercise 6 and Exercise 7 | |levels of mastery of the skills |

| | |Activity Handout, Teacher Created- “Warmup Example of Tabs for 09/24” | |(Page 4 of Curriculum Guide) |

| | |Practice Quiz- Teacher Created- “Practice Quiz on Tabs and Other Topics 09/24” | | |

| | |Students will be able to use the Editing Feature to replace text with different format. | | |

| | |Students will be able to create an Envelope for a business letter. | | |

| | |Students will be able to hide/show the horizontal and vertical ruler. | | |

| | |Students will be able to describe what is a tab and what it is used for. | |SWBAT(same as above) |

| | |Students will be able to access the tab dialog box. | |Format a business letter |

| | |Students will be able to identify the default setting for tab stops. | |Create Envelopes and labels |

| | |Students will be able to identify and modify the five different types of tabs. | |Insert the date and time |

| | |Students will be able to identify and activate a tab leader. | |Change case in a document |

| | |Students will be able to format a Modified-Block business letter. | |Set Tabs |

| | | | |Apply font styles and underlines |

| | | | |Apply software and application skills to demonstrate |

| | | | |levels of mastery of the skills |

| | | | |(Page 4 of Curriculum Guide) |

| | | | | |

| | | | | |

| | | | | |

| | |09/29 and 09/30- Objectives | |SWBAT |

| | |In class Practice Quiz as Posted Above 09/29” | |Identify various types of business documents |

|5 |9/29 |In class Practice Typing Pal Entry Level Pre-Test- 09/29 | |Correct spelling and grammar, use the Thesaurus |

| | | | |Set up a memo and format a business letter |

| | |Students will apply their knowledge of Tabs, Fonts and Formatting a Personal Business Letter to create| |Create envelopes and labels |

| | |the following documents: | |(Page 3 and 4 of Curriculum Map) |

| | |a) Resume (Exercise 7); | | |

| | |b) Create a Letter with an Envelope and a Label(Exercise 8) | | |

| | |c) Restaurant Flyer(Exercise 8); | | |

| | | | | |

| | |10/01 and 10/02- Objectives Completing Exercise 8 and Exercise 9 | | |

| | | | | |

| | |In Class Quiz as Posted Above- 10/01 | | |

| | | | | |

| | |In class Practice Typing Pal Entry Level Post-Test- 10/02 | | |

| | |In-class Cumulative Paper Test given on 10/02- Teacher Created- | | |

| | |Concept Test on 10/02 | | |

| | | | | |

| | | | | |

| | | | | |

| | |Objectives for 10/06 and 10/07- Exercise 10 |Formatting Basics- |SWBAT |

|6 |10/6 | |page 124-139 |Open multiple documents at the same time |

| | |Identify Common Proofreading Marks | |Compare documents side by sde |

| | |Open a Saved Document using Types of Files | |Use copy and paste, drag and drop editing to move text |

| | |Insert Mode vs. Overtype Mode | |Use the Clipboard |

| | |Move Text | |Open document as read only and use document properties |

| | |Use Cut and Paste | |features |

| | |Use the Clipboard Task Pane | |Learn different file types |

| | |Use Drag and Drop Editing | |Print and Preview a closed document |

| | |Select Paste Formatting Options | |(Page 5 of Curriculum Map) |

| | |a)Keep Source Formatting | | |

| | |b)Match Destination Formatting | | |

| | |c)Keep Text Only | | |

| | |d)Set Default Paste | | |

| | |Move a Paragraph | | |

| | | | | |

| | |Objectives for 10/08 and 10/09- Exercise 11 | | |

| | |In class quiz given as posted above- 10/08 | | |

| | |Demonstrate moving text in a paragraph, copy and paste, cut and paste text, move and copy, drag and | | |

| | |drop, and how to use the clipboard. | | |

| | |Discuss split screen and switch windows procedures and View side by side | | |

| | |Review document properties | | |

| | |Preview and print a closed document. | | |

| | | | | |

| | |Demonstrate how to sort lists or paragraph text. |Formatting Basics- |SWBAT |

|7 |10/13 |Demonstrate how to use the Format Painter |page 139-152 |Sort lists and paragraphs |

| |(3 days this |Discuss the 5 types of indent. | |Insert and format symbols |

| |week) |Discuss the use of bulleted and numbered lists and how to change bullets using the Bullet Library | |Use the Format Painter |

| |Due to Columbus |Demonstrate how to apply font color, highlight text, use the highlight color palette | |Create bulleted and numbered lists |

| |Day |Discuss the use of symbols in a document | |(Page 6 of Curriculum Map) |

| | |Differentiate between line spacing and paragraph spacing. | | |

| | | | | |

| | |Use Styles Gallery to Format Headings, Titles, and Paragraphs |Formatting Basics- |SWBAT |

| | |Discuss Ways to improve the appearance of a document. |page 139-152 |Apply create and edit a style |

|8 |10/20 |Explain margins | |Reapply Direct Formatting elsewhere in a document |

| |(2.5 days this |Discuss page orientation | |Apply a default Word Style |

| |week) |Explain the difference between paragraph and character format. | |Set margins and page orientation |

| |Due to Teacher | | |Format a report, highlight text |

| |Conference and | | |Understand various stages of document production |

| |Faculty | | |Use Autoformat, AutoCorrect, and themes |

| |Meeting | | |Remove all formatting from selected text |

| | | | |(Page 7 of Curriculum Map) |

| | |Demonstrate creating tables using table grid, Insert Table dialogue box, and the Quick Tables Gallery |Working With Tables- |SWBAT |

| | |Explain how to create a table and present data in a column and row format |pages 191- 218 |Create a table and enter data in a table, sort rows |

|9 |10/27 |Explain two contextual tabs on the Ribbon when table is active | |Select a table, change table structure, and format a |

| | |Discuss setting alignments in table cells, setting cell margins, aligning a table on a page, and | |table |

| | |adjusting row heights and column width | |Set Alignments within table cells and set margins in table|

| | |Demonstrate the use of the Table Tools Layout Tab | |Align a table on a page |

| | |Demonstrate the selection of columns, rows or individual celles | |(Page 9 of Curriculum Map) |

|10 |11/03 |Review calculating in a table using all options, number formats, applying cell borders, and shading |Working With Tables- |SWBAT |

| | |Demonstrate how to draw a table moving and resizing a table, merging and splitting cells and rotating |pages 191- 218 |Use number formats |

| | |and wrapping text, sorting in a table | |Sort rows |

| | |Discuss table properties dialog Box, and the Table Tools Layout | |Change column width and row height |

| | |Demonstrate how to create a formula in a cell using the Formula dialog box | |Draw table, move and resize table, merge and split cells |

| | |Explain sort in a table | |Merge cells, rotate text, wrap text and calculate in a |

| | | | |table. |

| | | | |Use Cell Borders and shading |

| | | | |Calculate in a table, number formats and sort rows in a |

| | | | |table. |

| | | | |(Page 9 and 10 of Curriculum Map) |

|11 |11/10 |Create edit, collapse, expand and number Outline |Creating and Editing |SWBAT |

| | |Use Page and section breaks to improve the layout and readability of a document. |Long Documents- pages|Create and edit an outline |

| | |Use footnotes and endnotes to add supplementary information to a document. |251-300 |Set different margins in multiple page documents |

| | |Use the Find and Replace commands, along with the Go-To commands | |Insert page and section breaks |

| | |Create Headers and Footers | |Insert headers and footers |

| | |Insert Page numbers | |Insert page numbers |

| | | | |View Word Count |

| | | | |Create footnotes and endnotes |

| | | | |Use Find and Replace, and Go to |

| | | | |Insert bookmarks |

| | | | |Select Browse Objects |

| | | | |Use Full Screen Reading View |

| | | | |Use Document Map |

| | | | |Use Thumbnails |

| | | | |Preview Multiple Pages |

| | | | |Copy or Move Text from one page to another |

| | | | |(Page 13 of Curriculum Map) |

|12 |11/17 |Create edit, collapse, expand and number Outline |Creating and Editing |SWBAT |

| | |Use Page and section breaks to improve the layout and readability of a document. |Long Documents- pages|Insert Comments |

| | |Use footnotes and endnotes to add supplementary information to a document. |251-300 |Track Changes |

| | |Use the Find and Replace commands, along with the Go-To | |Customize Revision Marks |

| | |Create Headers and Footers | |Compare and Combine documents |

| | |Insert Page numbers | |Accept/Reject Changes |

| | | | |(Page 14 of Curriculum Map) |

|13 |11/24 |Explain the Worksheet, navigating the worksheet, switching between worksheets, understanding worksheet|Getting Started with |SWBAT |

| | |views. |Microsoft Excel 2007 |Work in the Excel Window and Interface |

| | |Demonstrate how to create a new workbook, use a template, or another workbook |Pages 357-393 |Navigate the Worksheet and Views |

| | |Demonstrate entering numeric labels, values, and dates creating a series, changing data alignment, and| |Create a new workbook and create a workbook from a |

| | |changing column width | |Template |

| | |Discuss the difference between labels and values | |Enter labels and make simple corrections |

| | |Explain cell reference and name box | |Undo, Redo, and delete cell content |

| | |Explain default alignments to labels and values | |Save and close a Workbook |

| | | | |Open workbook, change from workbook to workbook, compare |

| | | | |workbooks |

| | | | |Use AutoComplete, pick from list, AutoCorrect and spell |

| | | | |check |

| | | | |Enter Numeric labels and Values |

| | | | |(Page 17 of Curriculum Map) |

|14 |12/01 |Explain the parts of a formula |Working with Formulas|SWBAT |

| | |Demonstrate the selecting of ranges and use them in a formula |and Formatting in |Enter dates and create a series |

| | |Demonstrate how to copy and paste formulas |Excel |Change data alignments and adjust column widths |

| | |Discuss how to use either relative or absolute cell references to make sure formulas use the correct |Pages 395-426 |Enter simple formulas and edit a formula |

| | |cell references after being pasted | |Select ranges and use collapse button |

| | |Insert columns and rows in the worksheet | |Choose a theme |

| | |Demonstrate how to insert, delete and print worksheets | |Apply font and number format |

| | |Demonstrate how to group sheets | |Copy and Paste Data |

| | | | |Copy Formats |

| | | | |Use Relative cell references |

| | | | |Use Absolute cell references |

| | | | |Preview and Print worksheets |

| | | | |Insert and delete columns or rows |

| | | | |Move data (cut and paste) |

| | | | |(Page 18 of Curriculum Map) |

|15 |12/08 |Explain relationship between functions and charts |Working with |SWBAT |

| |(First two days)|Define the required elements of a function |Functions, Formulas |Use Drag and drop editing |

| | |Demonstrate how to type a function manually or use the Insert Function dialog box |and Charts in Excel |Insert, delete, copy, move and Rename worksheets |

| | |Demonstrate the Autocalculate feauture with a range of cells to show the temporary calculation |Pages 427-472 |Change tab color, hide sheets, and group sheets, Format |

| | |Explain the difference between Functions and charts | |worksheets |

| | |Demonstrate how to name a range and use the named range in a formula | |Understand and use Functions |

| | |Demonstrate the use of Conditional Statements If then functions | |Identify common functions |

| | |Explain the function library | |Insert functions and comments |

| | | | |Name ranges |

| | | | |Understand Conditional Statement IF Functions |

| | | | |Insert Conditional Statement IF Functions |

| | | | |Use Nested IF Functions |

| | | | |Use= SUMIF() and = SUMIFS() Functions |

| | | | |Use= COUNTIF() and = COUNTIFS() Functions |

| | | | |(Page 19 of Curriculum Map) |

|15 |12/08 |Demonstrate how to use Nested IF Functions |Working with |SWBAT |

| |(Last two days) |Explain the use of comments in a worksheet |Functions, Formulas |Understand Chart basics |

| | |Discuss basic chart types |and Charts in Excel |Select chart data |

| | |Identify basic Chart Elements |Pages 427-472 |Create a chart and change chart type |

| | |Use the Chart Wizard to create a chart | |Select a chart |

| | |Demonstrate how to change the chart type, size, copy, move, or delete a chart | |Change data series orientation |

| | |Explain axis terms category and value | |Format a chart |

| | |Explain Chart Tools tabs | |Resize, copy, move delete chart or chart object |

| | |Demonstrate how to improve chart appearance | |Enhance chart background |

| | | | |Format category and value axes |

| | | | |Format chart background |

| | | | |Publish chart to Internet |

| | | | |Use Paste Special to control paste options |

| | | | |(Page 20 of Curriculum Map) |

|16 |12/15 |Discuss options for printing in the Print dialog box |Advanced Printing, |SWBAT |

| | |Demonstrate the Page Setup dialog box by creating and formatting headers and footers |Formatting and |Link a chart, embed char in work document, edit a linked |

| | |Discuss inserting page breaks, setting print area, repeating rows and column labels |Editing in Excel |or embedded chart |

| | |Demonstrate combining date with copy and paste special, transpose date in a worksheet |Pages 473-534 |Print Workbook |

| | |Discuss dragging and dropping and Linking Workbooks | |Set Print Area |

| | | | |Insert Header and Footer |

| | | | |Insert Page Breaks and preview |

| | | | |Use Paste Special to transpose data |

| | | | |Freeze labels, and split workbooks into panes |

| | | | |Drag and drop data between open workbooks |

| | | | |Link workbooks |

| | | | |(Page 21 of Curriculum Map) |

|17 |12/22 |Discuss Powerpoint 2007 features. Creating a presentation from scratch, adding slides, selecting slide|Powerpoint Basics- |SWBAT |

| | |layout, and saving a presentation. |Pages 721-758 |Understand Powerpoint and the Powerpoint Window |

| | |Discuss opening an existing presentation, moving from slide to slide, applying a theme, changing the | |Create a Presentation from a Blank Presentation |

| | |slide layout, and spell checking the presentation | |Work with Placeholders and add slides to Presentations |

| | |Demonstrate inserting clip art, positioning clip art, changing them colors and fonts, and changing | |Select a Slide Layout and save a presentation |

| | |background style | |Open an existing presentation |

| | |Explain creating a presentation from a Template, working with Powerpoint views, copying, duplicating, | |Move from slide to slide, Apply a theme, change slide |

| | |deleting slides | |layout, work with Normal view panes and spell check a |

| | | | |presentation |

| | | | |Insert Clip art, resize and position clip art |

| | | | |Use, Undo, Redo, change theme color |

| | | | |(Page 28 of Curriculum Map) |

|18 |01/05 |Demonstrate selecting text and placeholders, changing text appearance, use Autofit Options, copying |Working with Text and|SWBAT |

| | |text formatting, and creating New theme fonts |Graphic Elements in |Select Text and Placeholders |

| | |Explain working with bulleted and numbered lists, aligning text, adjusting paragraph spacing, moving |PowerPoint |Change the Appearance of text using Autofit Options, copy |

| | |and copying texts and adjusting and formatting placeholders |Pages 759-816 |text formatting and create new theme fonts |

| | |Explain inserting symbols, inserting and formatting a textbox, creating a column text in a text box, | |Work with Bulleted and numbered list |

| | |and inserting and formatting WordArt | |Align text, adjust paragraph spacing move, and copy text, |

| | |Show how to insert a table, formatting a table, and inserting or linking an Excel worksheet data | |adjust and format Placeholders |

| | | | |Insert Symbols |

| | | | |Insert and format a text, create a column text in a text |

| | | | |box, insert and format WordArt |

| | | | |Insert Table, format or modify a table and insert or link |

| | | | |Excel Worksheet Data |

| | | | |(Page 30 of Curriculum Map) |

|19 |01/12 |Explain using rulers, guides, and gridlines; drawing and formatting obkects, chaing fill, outline and |Working with Text and|SWBAT |

| |(first two days)|effect; adding text to objects and arranging and ordering objects |Graphic Elements in |Change fill, outline and effects |

| | |Explain inserting a picture from a file, formatting pictures, inserting a movie, and inserting sounds |PowerPoint |Add text to objects, arrange objects, group and ungroup |

| | |and music |Pages 759-816 |objects, and position objects |

| | | | |Insert and format a picture from a file, use special |

| | | | |picture effects, insert a movie, and insert sounds and |

| | | | |music |

| | | | |(Page 31 of Curriculum Map) |

| | | | | |

|19 |01/12 |Explain adding slide transitions, controlling slide advance, animating text and objects, and |Prepare and Present a|SWBAT |

| |(last two days |rehearsing timing |Slide Show in |Add slide transitions, control slide advance, animate text|

| | |Explain the Custom animation Task Pane |Powerpoint |and objects, and rehearse timing |

| | |Demonstrate how to create a custom show, insert link on slides, and insert an Action button |Pages 817-840 |Create a Custom Show, insert links on slides, and insert |

| | |Explain sending a presentation for review, finalizing a presentation, packaging a presentation for CD,| |an Action button |

| | |and using other output options | |Hide slides, set slide show options, control slides during|

| | |Discuss inserting a Hyperlink on a slide | |presentation, and annotate slides during presentation |

| | | | |Send a Presentation for review |

| | | | |Finalize a Presentation |

| | | | |Package for CD |

| | | | |Use other output Options |

| | | | |Send Speaker Notes to Word |

| | | | |Export to overhead transparencies |

| | | | |(Page 32 of Curriculum Map) |

|20 |01/19 |Define a database system |Getting Started with |SWBAT |

| | |Discuss how an Access database is organized |Access |Understand the purpose of Access Software |

| | |Explain working with the Navigation pane |Pages 585-618 |Understand how an Access database is organized |

| | |Demonstrate saving a copy of a database, opening and closing database objects, and sorting records | |Understand how Access tables are related |

| | |Explain planning and creating a database, creating a table from a datasheet, save changes to a table | |Copy data files and deselect the read only attribute |

| | |design, rename and delete fields in a datasheet | |Start Access, open a database, work with Navigation pane, |

| | |Explain entering and editing records, selecting records, deleting records and printing datasheets and | |open and close objects in a database, move through a |

| | |forms. | |datasheet or form and sort records |

| | | | |Navigate in a database and sort record |

| | | | |Enter, edit, select, delete records |

| | | | |Print datasheets and forms |

| | | | |(Page 22 of Curriculum Map) |

|21 |01/26 |Print Preview |Getting Started with |SWBAT |

| | |Plan a database |Access |Discuss opening a database file, creating a table with a |

| | |Create a database |Pages 585-618 |template or from Design View. |

| | |Create a table from a datasheet | |Demonstrate how to select a Wizard |

| | |Save changes to a table design | |Create tables in Table Design and Datasheet view |

| | |Rename a field in a datasheet | |Demonstrate how to rename, add, delete and reorder fields |

| | |Delete a field from a datasheet | |in the Table Design view field list |

| | |Open a database file | |Introduce concept of Field properties |

| | |Create a table with a template | |Discuss plain text and delimited fields |

| | |Create a table in design view | |Adjust column width |

| | |Select a field for the primary key | | |

| | |Open a database exclusively | | |

| | |Set a database password | | |

| |` |CLASS FIELD TRIP | | |

| | |FINAL EXAMS | | |

Microsoft Office Applications- FIELD TRIP-2008

For a Class Field Trip we will plan ahead of time with a Manager of a Kinko’s or Staples Office Store so that they can give us a tour of their store and explain how their workers have to use their knowledge of Microsoft Office 2007 to complete their job duties and help the customers. The Manager at Staples could also show us what Services are provided in Customer Service and perhaps students can purchase the CD for Microsoft Office 2007 or buy a printer or computer while visiting. By this time we will also have completed some Projects that could be bound into Spiral Notebooks or brochures. We can then display the projects at School. This field trip will allow students to see how Microsoft Office is applied for use in the real world on a daily basis.

................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download