Chippewa Valley Technical College



?Chippewa Valley Technical College103-102 Microsoft Office SuiteCourse DesignCourse InformationDescriptionThe goal of this course is to provide an introduction to Microsoft Office Suite and how it is used in academic and business environments. The students will become familiar with the Office user interface and use it as they work with Word, PowerPoint, Excel, and Access.Instructional LevelAssociate DegreeTotal Credits2.00Total Hours48.00Types of InstructionInstruction TypeCredits/HoursIndependent, online instruction2/48Purpose/GoalsUse basic Microsoft Word, Excel, PowerPoint and Access features, plus use Windows and the Internet.Target PopulationRequired in CIS, CNS, Accounting and Marketing program. Taken by other students wishing a knowledge of Microsoft Office suite and pre-program students.Pre/CorequisitesPrerequisiteBasic experience in navigating Windows including starting programs.PrerequisiteBasic mouse skills.PrerequisiteKeyboarding skill.TextbooksSAM Course Pack bundle, Cengage Learning, ISBN: 9781305315884Learner Suppliesfloppy disk.?Quantity: 1.?Required.?Program Outcomes1.Apply technology skills to business and administrative tasksCourse Competencies1.Create and manage Windows files and folders.Assessment Strategies1.1.Product CriteriaPerformance will meet expectations when:1.plete file management assignment using screen capture.1.2.Use the snipping tool function in Windows.1.3.Create folders and subfolders.1.4.Zip and unzip files.1.5.Save files/documents in folders.Learning Objectives1.a.Create, move, and rename folders1.b.Copy, move, rename, and delete files1.c.Find files and folders1.d.Access documents on the CVTC student Network (N:) drive1.e.Extract data files from a compressed (zipped) folder1.f.Create a screen capture (using the Snipping Tool)2.Use Microsoft Word to create documents.Assessment Strategies2.1.Product CriteriaPerformance will meet expectations when:2.plete Word tasks using the instructions and rubric criteria established for each learning plan assignment.2.pare your finished product to the instructor's solution at the end of each learning plan.2.plete a final Word capstone project using the rubric criteria established.Learning Objectives2.a.Manage Word documents2.b.Manipulate text2.c.Format bullets and numbering2.d.Add borders and shading2.e.Format images3.Use Microsoft Excel to create spreadsheets.Assessment Strategies3.1.Product CriteriaPerformance will meet expectations when:3.plete Excel tasks using the instructions and rubric criteria established for each learning plan assignment.3.pare your finished product to the instructor's solution at the end of each learning plan.3.plete a final Excel capstone project using the rubric criteria established.Learning Objectives3.a.Manage spreadsheets3.b.Use formulas and functions3.c.Edit spreadsheet data3.d.Apply formatting to spreadsheets3.e.Insert charts4.Use Microsoft Access to create databases. Assessment Strategies4.1.Product CriteriaPerformance will meet expectations when:4.plete?Access tasks using the instructions and rubric criteria established for each learning plan assignment.4.pare your finished product to the instructor's solution at the end of each learning plan.4.plete a final?Access capstone project using the rubric criteria established.Learning Objectives4.a.Manage databases4.b.Create related tables4.c.Create queries4.d.Create forms4.e.Create reports4.f.Manipulate data5.Use Microsoft PowerPoint to create presentations.Assessment Strategies5.1.Product CriteriaPerformance will meet expectations when:5.plete?Power Point?tasks using the instructions and rubric criteria established for each learning plan assignment.5.pare your finished product to the instructor's solution at the end of each learning plan.5.plete a final?Power Point?Capstone project using the rubric criteria established.Learning Objectives5.a.Manage PowerPoint files5.b.Manipulate slide text and themes5.c.Format images5.d.Use charts and tables5.e.Apply transitions, timings, and animationsCourse Learning Plans and Performance Assessment TasksLP 1 - File Management & Common Features Overview/PurposeWe begin our textbook activities by learning more about the operating system used on our computer and about how to manage files within that system.Target Competencies1.Create and manage Windows files and folders.Assessment Strategies1.1.Product CriteriaPerformance will meet expectations when:1.plete file management assignment using screen capture.1.2.Use the snipping tool function in Windows.1.3.Create folders and subfolders.1.4.Zip and unzip files.1.5.Save files/documents in folders.Learning Objectives1.a.Create, move, and rename folders1.b.Copy, move, rename, and delete files1.c.Find files and folders1.d.Access documents on the CVTC student Network (N:) drive1.e.Extract data files from a compressed (zipped) folder1.f.Create a screen capture (using the Snipping Tool)Learning Activities1.Read Getting Started with Window and Understanding File Management.2.Review power points on key concepts.Learning MaterialsGetting Started with Windows 8 Windows8UnitAPPTPresentation.pptUnderstanding File Management Windows8UnitBPPTPresentation.ppt3.You will be creating an MOS (Microsoft Office Suite) class folder on your home computer, school network drive. The instructions for this are included in the content items below.4.Within this MOS folder, please create additional folders for each learning plan in your course (LP). Name them as they appear in your lessons list of E360. This is what you see when you click the LESSONS button in the left navigation pane.5.Once these are created, please take a screen snip (instructional videos below) of the folders or a print screen and save to submit within the dropbox linked below.6.Watch video on Snipping Tool.Learning MaterialsYou Tube Video on Snipping Tool Tube Snipping Tool for Windows 8 a new MOS Folder.Point at New, and then click Folder.(OR instead of the first two steps, simply click the New folder button (located at the top of your screen as one of the menu items).Type in the name MOS for the new folder.Press Enter.Open the MOS folder. Within that folder, create the following subfolders (just like you created the?MOS folder):LP01 File ManagementLP02 Intro SAM and Word BasicsLP03 Editing Word DocumentsLP04 Word Formatting TextLP05 Word Formatting DocumentsLP06 Excel BasicsLP07 Excel Forumlas and FunctionsLP08 Excel Formatting WorksheetsLP09 Excel ChartsLP_10 Access BasicsLP_11 Access QueriesLP_12 Access FormsLP_13 Access ReportsLP_14 PowerPoint CreatingLP_15 PowerPoint Finishing Presentation8.Practice using compressed files.9.View video on how to zip files.Learning MaterialsYou Tube on How to Zip and Unzip Files Windows 8 skills learned so?far in the unit.11.Participate in Check-in Discussion - Use of Microsoft Applications.Assessment Activities1.Submit File Management Assignment using Screen Capture.plete Discussion and Post to Rubric Requirements.LP 2 - Introduction to SAM and Word Basics Overview/PurposeWhat are 3 ways you will use Microsoft Word once employed in your chosen field of study?(program area)? In this unit, we will cover Word Basics and get you prepared for using SAM. SAM is the software that houses all of our practice exercises we use in class.??Target Competencies1.Use Microsoft Word to create documents.Assessment Strategies1.1.Product CriteriaPerformance will meet expectations when:1.plete Word tasks using the instructions and rubric criteria established for each learning plan assignment.1.pare your finished product to the instructor's solution at the end of each learning plan.1.plete a final Word capstone project using the rubric criteria established.Learning Objectives1.a.Manage Word documents1.b.Manipulate text1.c.Format bullets and numbering1.d.Add borders and shading1.e.Format imagesLearning Activities1.Participate in a Check-In discussion on Microsoft Basics.2.Show how to use SAM - Skills Assessment Manager.3.Set up a SAM account.4.Review SAM manual to familiarize self for class projects.5.Read Microsoft Word 2013 Unit A 1-17.6.Watch video on New Features of Office 2013.Learning MaterialsNew Features in Office 2013 video on Getting to Know Word.Learning MaterialsWord 2013 Getting to Know Word video on Creating and Opening Documents.Learning MaterialsWord 2013 Creating and Opening Documents SAM Word Basic activity.plete Illustrated Word 2013 Unit A in SAM.Learning MaterialsHow to Check Your Scores in SAM ToviewyourTrainingandProjectresults.plete Independent Challenge 1 (Taylor Letter) on page Word 21 of your text.Learning MaterialsIndependent Challenge Taylor Letter Rubric LP02_Independent_Challenge_RubricWDATaylorLetter.docxAssessment Activities1.Turn in Independent Challenge - Taylor Letter.Learning MaterialsSolution for Taylor Letter WDATaylorLetter.docxLP 3 - Editing Word Documents Overview/PurposeWe will continue to explore Microsoft Word and really focus on editing documents.Target Competencies1.Use Microsoft Word to create documents.Assessment Strategies1.1.Product CriteriaPerformance will meet expectations when:1.plete Word tasks using the instructions and rubric criteria established for each learning plan assignment.1.pare your finished product to the instructor's solution at the end of each learning plan.1.plete a final Word capstone project using the rubric criteria established.Learning Objectives1.a.Manage Word documents1.b.Manipulate text1.c.Format bullets and numbering1.d.Add borders and shading1.e.Format imagesLearning Activities1.Read Word 2013 Unit B on pages Word 26-41.2.Watch video on Formatting Text in Word.Learning MaterialsYou Tube Word 2013 Formatting Text video on Check Spelling and Grammar.Learning MaterialsYou Tube Word 2013 Spelling & Grammar video on Hyperlinks.Learning MaterialsYou Tube Word 2013 Hyperlinks Word SAM activity Word Editing Unit B.6.Participate in a discussion on using SAM and what you have learned so far.plete Illustrated Word 2013 Unit B.plete Independent Challenge 1 activity on page Word 45 of your text.Learning MaterialsIndependent Challenge Theatre Letter Rubric LP03_Independent_Challenge_RubricWDBTheatreFundraisingLetter.docx9.Practice making a cover letter (replicate with model/sample).Learning MaterialsCopy Cat Rubric for Cover Letter LP03COPYCATRubricWDBCoverLetter.docxAssessment Activities1.Turn in Independent Challenge - theatre letter.Learning MaterialsSolution for Independent Challenge - Theatre Letter WDBTheatreFundraisingLetterSolution.docx2.Turn in Replication/Copy Cat cover letter.LP 4 - Formatting Text & Paragraphs Overview/PurposeThis unit of Word will take us into formatting text and paragraphs.Target Competencies1.Use Microsoft Word to create documents.Assessment Strategies1.1.Product CriteriaPerformance will meet expectations when:1.plete Word tasks using the instructions and rubric criteria established for each learning plan assignment.1.pare your finished product to the instructor's solution at the end of each learning plan.1.plete a final Word capstone project using the rubric criteria established.Learning Objectives1.a.Manage Word documents1.b.Manipulate text1.c.Format bullets and numbering1.d.Add borders and shading1.e.Format imagesLearning Activities1.Read Word 2013 Unit C pages Word 50-67.2.Watch video on Indents and Tabs.Learning MaterialsYou Tube Word 2013 Indents and Tabs video on Line and Paragraph Spacing.Learning MaterialsYou Tube Word 2013 Line & Paragraph Spacing video on Pictures and Text Wrapping.Learning MaterialsYou Tube Word 2013 Pictures and Text Wrapping SAM Word Formatting Text & Paragraphs activity.plete SAM Illustrated Word 2013 Unit C.plete Independent Challenge on Word 72 of your text.Learning MaterialsChallenge Data File WDC3.docxChallenge Solar Home Rubric LP04IndependentChallengeRubricWDCSolarHome.docx8.Practice Word by recreating a menu (sample to copy provided).Learning MaterialsCopy Cat Rubric on Menu LP04CopyCatRubricWDCJPCafeMenu.docxAssessment Activities1.Turn in Independent Challenge - Solar Home.Learning MaterialsSolution for Independent Challenge - Solar Home WDCSolarHomeChallenge.docx2.Turn in Copy Cat Activity - Menu Recreate.LP 5 - Formatting Documents Overview/PurposeAs we continue to work with Word, we will focus on formatting documents in this unit. We will also have a capstone project at the end of this unit to utilize all of your new Word document skills.Target Competencies1.Use Microsoft Word to create documents.Assessment Strategies1.1.Product CriteriaPerformance will meet expectations when:1.plete Word tasks using the instructions and rubric criteria established for each learning plan assignment.1.pare your finished product to the instructor's solution at the end of each learning plan.1.plete a final Word capstone project using the rubric criteria established.Learning Objectives1.a.Manage Word documents1.b.Manipulate text1.c.Format bullets and numbering1.d.Add borders and shading1.e.Format imagesLearning Activities1.Read Word 2013 Unit D pages Word 78-95.2.Watch video on Tables.Learning MaterialsYou Tube Word 2013 Tables video on Breaks.Learning MaterialsYou Tube Word 2013 Breaks video on Headers, Footers, and Page Numbers.Learning MaterialsYou Tube Word 2013 Headers, Footers, Page Numbers SAM activity on Formatting Documents Unit D.plete SAM project Illustrated Word Unit D.plete Independent Challenge Word 100 of your text.Learning MaterialsData File for Banquet Menu WDD3 Banquet Menu.docxChallenge Rubric for Village Catering LP05_Independent_Challenge1_Rubric_WDD_VillageCatering.docx8.Participate in Discussion wrapping up Word techniques for creating quality documents.plete Copy Cat on parking permit.Learning MaterialsCopy Cat Activity Rubric - Parking Permit LP05CopyCatRubricWDDParkingFAQ.plete Word Capstone ProjectLearning MaterialsWord Capstone Rubric LP_05WordCapstoneRubric_Revised.docxWord Capstone Data CS2 PAT Word.docxAssessment Activities1.Turn in Independent Challenge - Banquet/CateringLearning MaterialsChallenge Catering Solution WDDVillageCateringSolution.docx2.Turn in Copy Cat - Parking3.Turn in Word PAT - Final Capstone ProjectLearning MaterialsPAT Word Capstone Project Solution CWMStaffNewsSolution.docxLP 6 - Excel Basics Overview/PurposeSo far in this course you have explored and mastered Word document functions. Now let's go to the next piece of Microsoft Office Suite to explore using Excel spreadsheets. In this first unit, we will cover the Basics of Excel.Target Competencies1.Use Microsoft Excel to create spreadsheets.Assessment Strategies1.1.Product CriteriaPerformance will meet expectations when:1.plete Excel tasks using the instructions and rubric criteria established for each learning plan assignment.1.pare your finished product to the instructor's solution at the end of each learning plan.1.plete a final Excel capstone project using the rubric criteria established.Learning Objectives1.a.Manage spreadsheets1.b.Use formulas and functions1.c.Edit spreadsheet data1.d.Apply formatting to spreadsheets1.e.Insert chartsLearning Activities1.Participate in a discussion about experience with Excel?or how you might use it in your field of study.2.Read Excel 2013 Unit A Excel 1-17.3.Watch video on Getting to Know Excel.Learning MaterialsYou Tube Video on Excel 2013 Getting to Know Excel video on Creating and Opening Workbooks.Learning MaterialsYou Tube Excel 2013 Creating and Opening Workbooks video on Cell BasicsLearning MaterialsYou Tube Excel 2013 Cell Basics video on Printing WorkbooksLearning MaterialsYou Tube Excel 2013 Printing Workbooks SAM activity Excel Basics Unit A.plete SAM project Illustrated Excel 2013 Unit A.plete Independent Challenge on page Excel 21 of text.Learning MaterialsChallenge Rubric - Property Listings LP06IndependentChallenge1RubricEXAPropertyListings.plete Copy Cat spreadsheet activity.Learning MaterialsCopy Cat Activity Rubric - Prestige Import Motors LP06_Copy_CatRubricEXAPrestigeImportMotors.docxAssessment Activities1.Turn in Independent Challenge - Property ListingsLearning MaterialsChallenge Solution for Property Listings EXAPropertyListingsSolution.xlsx2.Turn in Copy Cat Activity - Prestige MotorsLP 7 - Excel Formulas and Functions Overview/PurposeExcel formulas and functions are the next thing we will cover in Excel. Setting up formulas is really critical to your end product, so practice, practice, practice.Target Competencies1.Use Microsoft Excel to create spreadsheets.Assessment Strategies1.1.Product CriteriaPerformance will meet expectations when:1.plete Excel tasks using the instructions and rubric criteria established for each learning plan assignment.1.pare your finished product to the instructor's solution at the end of each learning plan.1.plete a final Excel capstone project using the rubric criteria established.Learning Objectives1.a.Manage spreadsheets1.b.Use formulas and functions1.c.Edit spreadsheet data1.d.Apply formatting to spreadsheets1.e.Insert chartsLearning Activities1.Read Excel 2013 Unit B pages Excel 25-41.2.Watch video on Excel Functions.Learning MaterialsYour Tube Excel 2013 Functions video on Complex Formulas.Learning MaterialsYou Tube Excel 2013 Complex Formulas video on Excel Cell References.Learning MaterialsYou Tube Excel 2013 Cell References SAM activity on Excel Formulas and Functions.plete SAM project on Illustrated Excel 2013 Unit B.plete Independent Challenge on page Excel 45 of text.Learning MaterialsChallenge Data EXB3 Data file.xlsxRubric for Challenge LP07IndependentChallengeRubricEXBExpressOilChangeExpenses.plete Copy Cat spreadsheet activity.Learning MaterialsCopy Cat Rubric for Dog Care LP07CopyCatRubricEXBDogDays.docxAssessment Activities1.Turn in Independent Challenge - Oil Change2.Turn in Copy Cat - Dog CareLearning MaterialsCopy Cat Solution EXBDogDaysDayCareCenterFinancesSolutionChallenge.xlsxLP 8 - Excel Formatting Worksheets Overview/PurposeAre you up for a new challenge? In this unit, we will work on formatting worksheets in Excel.Target Competencies1.Use Microsoft Excel to create spreadsheets.Assessment Strategies1.1.Product CriteriaPerformance will meet expectations when:1.plete Excel tasks using the instructions and rubric criteria established for each learning plan assignment.1.pare your finished product to the instructor's solution at the end of each learning plan.1.plete a final Excel capstone project using the rubric criteria established.Learning Objectives1.a.Manage spreadsheets1.b.Use formulas and functions1.c.Edit spreadsheet data1.d.Apply formatting to spreadsheets1.e.Insert chartsLearning Activities1.Read Excel 2013 Unit C pages 51-69.2.Watch the Conditional Formatting video.Learning MaterialsYou Tube Excel 2013 Conditional Formatting Excel Formatting Worksheet activity in SAM.plete Illustrated Excel 2013 Unit C in SAM.plete the Independent Challenge on pages Excel 73-74 of your text.Learning MaterialsData to Complete Challenge EXC3 Data for Pen & Paper.xlsxChallenge Rubric LP08ExcelUnitCIndependentChallengeRubric.plete Copy Cat activity to continue practicing skills.Learning MaterialsCopy Cat Activity Rubric LP08CopyCatRubricEXCPrestigePress.docxAssessment Activities1.Turn in Independent Challenge assignment.Learning MaterialsSolution for Pen & Paper Challenge EXCPenPaperOfficeSupplyInventorySolution.xlsx2.Turn in Copy Cat assignment.LP 9 - Excel Working with Charts Overview/PurposeLet's have a creative look at making charts using Excel.Target Competencies1.Use Microsoft Excel to create spreadsheets.Assessment Strategies1.1.Product CriteriaPerformance will meet expectations when:1.plete Excel tasks using the instructions and rubric criteria established for each learning plan assignment.1.pare your finished product to the instructor's solution at the end of each learning plan.1.plete a final Excel capstone project using the rubric criteria established.Learning Objectives1.a.Manage spreadsheets1.b.Use formulas and functions1.c.Edit spreadsheet data1.d.Apply formatting to spreadsheets1.e.Insert chartsLearning Activities1.Read Excel 2013 Unit D pages 79-95.2.Watch video on Excel Charts.Learning MaterialsYou Tube Video Excel 2013 Charts Excel Working with Charts activity in SAM.plete Illustrated Excel 2013 Unit D SAM Project.plete the Independent Challenge 2 on page Excel 101 of text.Learning MaterialsData for Challenge EXD4 Doggie Data.xlsxChallenge Rubric LP09ExcelUnitDIndependentChallengeRubric.docx6.Participate in discussion on Excel challenges.plete Copy Cat Activity.Learning MaterialsCopy Cat Rubric LP09CopyCatRubricEXDProjectedProjectExpenses.docxAssessment Activities1.Turn in Independent Challenge.Learning MaterialsSolution for Challenge EXDBarkBarkBarkDoggieDaySpaSolution.xlsx2.Turn in Copy Cat activity.3.Turn in PAT on Excel.LP 10 - Access Basics - Introduction to Databases Overview/PurposeWe have just completed two big pieces of Microsoft Office Suite. Have you heard about Access or?observed?others using this product? In this unit, we will explore some basic principles on databases.Target Competencies1.Use Microsoft Access to create databases. Assessment Strategies1.1.Product CriteriaPerformance will meet expectations when:1.plete?Access tasks using the instructions and rubric criteria established for each learning plan assignment.1.pare your finished product to the instructor's solution at the end of each learning plan.1.plete a final?Access capstone project using the rubric criteria established.Learning Objectives1.a.Manage databases1.b.Create related tables1.c.Create queries1.d.Create forms1.e.Create reports1.f.Manipulate dataLearning Activities1.Participate in Discussion on how you would use Access.2.Read Access 2013 Unit A pages Access 1-17.3.Watch Introduction to Access video.Learning MaterialsYou Tube Access Introduction to Databases Getting Around in Access video.Learning MaterialsYou Tube Getting Around in Access 2013 Access Basics SAM activity.plete Illustrated Access project in SAM.plete Independent Challenge?3 on page Access 24 of your text.Learning MaterialsData for Challenge BusinessContactsA Data.accdbRubric for Challenge LP_10AccessUnitAIndependentChallenge3RubricBusinessContactsA.plete Copy Cat Access table and relationship activity.Learning MaterialsCopy Cat Rubric LP_10CopyCatRubricRealEstateMarketingA.docxAssessment Activities1.Turn in Challenge assignment.Learning MaterialsSolution for Challenge BusinessContactsASolution1.accdb2.Turn in Copy Cat assignment.LP 11 - Access Building and Using Queries Overview/PurposeIn this unit, we will explore how to build and use queries. This is a powerful feature for pulling data out of Access to create end products or reports.Target Competencies1.Use Microsoft Access to create databases. Assessment Strategies1.1.Product CriteriaPerformance will meet expectations when:1.plete?Access tasks using the instructions and rubric criteria established for each learning plan assignment.1.pare your finished product to the instructor's solution at the end of each learning plan.1.plete a final?Access capstone project using the rubric criteria established.Learning Objectives1.a.Manage databases1.b.Create related tables1.c.Create queries1.d.Create forms1.e.Create reports1.f.Manipulate dataLearning Activities1.Read Access 2013 Unit B on pages Access 27-43.2.Watch video on Designing a simple Query.Learning MaterialsYou Tube Access 2013 Designing a Simple Query video on Modifying a Query.Learning MaterialsYou Tube Access 2013 Modifying Queries a video on Creating a Totals Query.Learning MaterialsAccess 2013 Creating a Totals Query Access Building and Using Queries SAM activity.plete Illustrated Access 2013 Unit B SAM project.plete the Independent Challenge activity on page 48 of text.Learning MaterialsData for Challenge MembershipB Data.accdbRubric for Challenge LP_11AccessUnitBIndependentChallenge1RubricMembershipB.plete Copy Cat activity on tables and query.Learning MaterialsRubic for Copy Cat LP_11CopyCatRubric.docxAssessment Activities1.Turn in Independent Challenge.Learning MaterialsSolution for Independent Challenge MembershipBSolution.accdb2.Turn in Copy Cat activity.LP 12 - Access Forms Overview/PurposeDid you know Access can help you create forms? We will be taking a closer look at that in this unit.Target Competencies1.Use Microsoft Access to create databases. Assessment Strategies1.1.Product CriteriaPerformance will meet expectations when:1.plete?Access tasks using the instructions and rubric criteria established for each learning plan assignment.1.pare your finished product to the instructor's solution at the end of each learning plan.1.plete a final?Access capstone project using the rubric criteria established.Learning Objectives1.a.Manage databases1.b.Create related tables1.c.Create queries1.d.Create forms1.e.Create reports1.f.Manipulate dataLearning Activities1.Read Access 2013 Unit C pages 53-69.2.Watch video on Creating Access Forms.Learning MaterialsYou Tube Access 2013 Creating Forms video on Formatting Access Forms.Learning MaterialsYou Tube Access 2013 Formatting Forms video on Customizing Access Form Settings.Learning MaterialsYou Tube Access 2013 Customizing Form Settings Access Using Forms Unit C SAM activity.plete Illustrated Access 2013 Unit C SAM project.plete Independent Challenge 1 on page Access 73 of text.Learning MaterialsChallenge Data DivesCData.accdbChallenge Rubric LP_12AccessUnitCIndependentChallenge1RubricDivesC.plete Visual Workshop activity on page Access 78 of text.Learning MaterialsVisual Workshop Rubric LP_12AccessUnitCVisualWorkshopRubricBaseballC.docxAssessment Activities1.Turn in Independent Challenge.Learning MaterialsChallenge Solution DivesCSolution.accdb2.Turn in Visual Workshop activity.LP 13 - Access Reports Overview/PurposeNow that you have learned how to put the data into Access, we will learn how to pull it out to create reports in this unit.Target Competencies1.Use Microsoft Access to create databases. Assessment Strategies1.1.Product CriteriaPerformance will meet expectations when:1.plete?Access tasks using the instructions and rubric criteria established for each learning plan assignment.1.pare your finished product to the instructor's solution at the end of each learning plan.1.plete a final?Access capstone project using the rubric criteria established.Learning Objectives1.a.Manage databases1.b.Create related tables1.c.Create queries1.d.Create forms1.e.Create reports1.f.Manipulate dataLearning Activities1.Read Access 2013 Unit D pages Access 79-95.2.Watch video on Creating Reports in Access3.Watch video on Access Report Wizard.4.Watch video on Printing Reports in Access.plete Access Using Reports Unit D activity in SAM.plete Illustrated Access 2013 Unit D SAM project.plete Independent Challenge 1 activity on page Access 100 of text.plete PAT for Access.9.Participate in?a reflective discussion about your Access experience.LP 14 - Power Point - Creating & Modifying a Presentation Overview/PurposeWow, where has the time gone? We are to our final?software topic?within Microsoft Office Suite. In this unit, we will explore Power Point to create and modify a presentation.Target Competencies1.Use Microsoft PowerPoint to create presentations.Assessment Strategies1.1.Product CriteriaPerformance will meet expectations when:1.plete?Power Point?tasks using the instructions and rubric criteria established for each learning plan assignment.1.pare your finished product to the instructor's solution at the end of each learning plan.1.plete a final?Power Point?Capstone project using the rubric criteria established.Learning Objectives1.a.Manage PowerPoint files1.b.Manipulate slide text and themes1.c.Format images1.d.Use charts and tables1.e.Apply transitions, timings, and animationsLearning Activities1.Read PowerPoint 2013 Units A and B pages 1-17 and 25-41.2.Watch video on Getting to Know PowerPoint.Learning MaterialsYou Tube PowerPoint 2013 Getting to Know PowerPoint video on Creating and Opening Presentations.Learning MaterialsYou Tube PowerPoint 2013 Creating and Opening Presentations video on Applying Themes in PowerPoint.Learning MaterialsYou Tube Power Point 2013 Applying Themes PowerPoint Basics Unit A SAM activity.plete?Illustrated PowerPoint 2013 Unit A SAM project.plete Independent Challenge 1 on PowerPoint 21 of text.Learning MaterialsChallenge Rubric LP_14PPTUnitAIndependentChallenge1RubricBroadband.plete PowerPoint Modifying a Presentation Unit B SAM activity.plete Illustrated PowerPoint 2013 Unit B SAM project.plete PowerPoint B Independent Challenge 1 on page 46 of text.Learning MaterialsChallenge Data PPTB3Data.pptxChallenge 1 Rubric LP_14PPTUnitAIndependentChallenge1RubricBroadband.plete PowerPoint B Independent Challenge 3 on page 47 of text.Learning MaterialsChallenge Rubric LP_14PPTUnitBIndependentChallenge1RubricPPTBCenter.docxAssessment Activities1.Turn in Independent Challenge 1.Learning MaterialsChallenge Solution PPTABroadbandSolution.pptx2.Turn in Independent Challenge 3.Learning MaterialsChallenge Solution PPTBNaturalFoodsSolution3.pptxLP 15 - PowerPoint Inserting Objects & Finishing a Presentation Overview/PurposeThis is our last learning plan together. We will be polishing up our presentations in PowerPoint with some editing techniques to wow your audiences.Target Competencies1.Use Microsoft PowerPoint to create presentations.Assessment Strategies1.1.Product CriteriaPerformance will meet expectations when:1.plete?Power Point?tasks using the instructions and rubric criteria established for each learning plan assignment.1.pare your finished product to the instructor's solution at the end of each learning plan.1.plete a final?Power Point?Capstone project using the rubric criteria established.Learning Objectives1.a.Manage PowerPoint files1.b.Manipulate slide text and themes1.c.Format images1.d.Use charts and tables1.e.Apply transitions, timings, and animationsLearning Activities1.Read PowerPoint 2013 Units C and D pages 49-65 and 73-89.2.Watch video on Charts in PowerPoint.Learning MaterialsYou Tube PowerPoint 2013 Charts video on Tables in PowerPoint.Learning MaterialsYou Tube PowerPoint 2013 Tables PowerPoint Inserting Objects Unit C SAM activity.plete Illustrated PowerPoint 2013 Unit C SAM project.plete Independent Challenge 1 on page 68 of your text.Learning MaterialsData 1 for Challenge PPT C-9 Data.pptxData 2 for Challenge PPT C-10 Data.pptxRubric for Challenge LP_15PPTUnitCIndependentChallenge1RubricPPTCCR.docx7.Watch video on Applying Transitions in PowerPoint.Learning MaterialsYou Tube PowerPoint 2013 Applying Transitions PowerPoint Finishing a Presentation Unit D SAM activity.plete Illustrated PowerPoint 2013 Unit D SAM project.plete the Independent Challenge 1 on page 93 of text.Learning MaterialsData for Challenge PPT D-7.jpgData for Challenge PPT D-6 Data2.pptxChallenge Rubric LP_15PPTUnitDIndependentChallenge1RubricPPTDPacific.docx11.Watch video on Shapes and WordArt.Learning MaterialsYou Tube PowerPoint 2013 Shapes and WordArt PAT for PowerPoint.Learning MaterialsPAT Instructions LP_15PPTPATInstructions.docxPAT Rubric LP_15_PowerPoint_PAT_Rubric.docx13.Participate in the discussion about your favorite Microsoft Office Suite application.Assessment Activities1.Turn in Challenge 1.Learning MaterialsChallenge Solution PPTCCR Solution.pptx2.Turn in Challenge 2.Learning MaterialsChallenge 2 Solution PPTDPacific Solution.pptx3.Turn in PowerPoint PAT. ................
................

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

Google Online Preview   Download