Excel 2010 Review and Advanced Excel Multiple Sheet Workbooks, Excel 4 Weeks – Tables, Protection, Functions, Data Tables, & Testing. Access 2010 Review and Advanced Access Design, Macros, 3.5 - 4 Weeks – Switchboards, Advanced Queries, Custom Forms and Reports, and Testing. PowerPoint 2010 1 1.5 weekWeeks – Comprehensive Project 1.5 Weeks Final Exam .5 Weeks TOTAL (approximately) 16 Weeks CIS 125 Task List Students will be engaged in project-based learning that strengthens their understandings and achievements, and allows them to communicate more productively and make decisions on important information and its interpretation, using the following tools: WORD PROCESSING COMMUNICATIONS Word Chapter 4 and Word Review Task List Custom Tab and Various Types of Indent Insert SmartArt and WordArt and Format Settings Attractively Apply Borders of Various Colors, Thicknesses Insert Watermarks into a Word document and Styles Insert a Section Break Review Various Section and Page Breaks Create a multi-level list Review Creation, Formatting and Layout Change Theme Fonts Insert Headers and Footers Word Chapter 6 - Generate Mail Merge Documents Review block format business letters Merge all or a selection of records and print Explain and perform the merge process form letters Use the Mail task pane and the Mailing tab Generate and print mailing labels and on the Ribbon envelopes Create, edit and sort a data source Generate mail merge documents Insert merge fields into the main document Utilize an IF statement in the main document Use current date fields in the main document Word Chapter 7 Creating a Newsletter with a Pull-Quote and Graphics – Add color, dropped caps, shading and spacing Insert and modify a graphic by cropping and to characters rotating Add an outside border with color to a Create and format WordArt drawing objects paragraph, text or table Insert section breaks and column breaks
Excel 2010 Review and Advanced Excel – Multiple Sheet Workbooks, Excel Tables, Protection, Functions, Data Tables, & Testing. 4 Weeks Access 2010 Review and Advanced Access – Design, Macros, Switchboards, Advanced Queries, Custom Forms and Reports, and Testing. 3.5 - 4 Weeks PowerPoint 2010 1 – 1.5 weekWeeks Comprehensive Project 1.5 Weeks Final Exam .5 Weeks TOTAL (approximately) 16 Weeks CIS 125 Task List Students will be engaged in project-based learning that strengthens their understandings and achievements, and allows them to communicate more productively and make decisions on important information and its interpretation, using the following tools: WORD PROCESSING COMMUNICATIONS Word Chapter 4 and Word Review Task List Custom Tab and Various Types of Indent Settings Apply Borders of Various Colors, Thicknesses and Styles Review Various Section and Page Breaks Review Creation, Formatting and Layout Insert SmartArt and WordArt and Format Attractively Insert Watermarks into a Word document Insert a Section Break Create a multi-level list Change Theme Fonts Insert Headers and Footers Word Chapter 6 - Generate Mail Merge Documents Review block format business letters Explain and perform the merge process Use the Mail task pane and the Mailing tab on the Ribbon Create, edit and sort a data source Insert merge fields into the main document Use current date fields in the main document Merge all or a selection of records and print form letters Generate and print mailing labels and envelopes Generate mail merge documents Utilize an IF statement in the main document Word Chapter 7 – Creating a Newsletter with a Pull-Quote and Graphics Add color, dropped caps, shading and spacing to characters Add an outside border with color to a paragraph, text or table Insert and modify a graphic by cropping and rotating Create and format WordArt drawing objects Insert section breaks and column breaks