Lower Dauphin School District / Welcome to Lower Dauphin



Curriculum MapCourse Title:Computer Applications Grade: 9th Unit (Name/Number): Microsoft ExcelPacing: 15 class periodsEssential Question(s): Unit: How are spreadsheets used effectively in business as well as your personal life? Lesson: How can I enter data into Excel and use the Excel ribbon to create a useful, efficient spreadsheet? Lesson: What are representations of different formulas? Lesson: What are effective ways to apply formatting to cells and data? Lesson: How is Microsoft Excel used in business and personal life?Content/Key ConceptsStandardsKey VocabularyLearning Activities/ResourcesEvidence of Learning(Assessments; Performance Tasks)Parts of the Excel Screen and Navigating in Excel15.4.8.D.SpreadsheetCell/active cellColumns/column headingsRowsFormula barName boxSheet tabsCell referenceCell rangeMerged cellFormula tabStudent laptopsComputer Apps. WorkbooksPractice sheetsVocabulary note guidesProject Excel screen; students locate on laptopsCheck student laptop screens Excel Formulas15.4.8.D.FunctionsFormulasAutosum Average functionMin/max functionsStudent laptopsComputer Apps. WorkbooksStudents produce basic spreadsheets using very basic sum formulasStudents produce spreadsheets using the correct function keys and formulas for spreadsheets that increase in difficultyStudent created spreadsheets Basic Formatting 15.4.8.D.Numbers groupCurrencyDecimalsShading, borders, alignmentStudent laptopsComputer Apps. WorkbooksIntroduce formatting features Student created spreadsheets with required formatting featuresPurposes for Excel15.1.8.Z.Personal budgetBusiness: Charts for scheduling, product sales, customer data, etc.Student laptopsComputer Apps. WorkbooksStudents open budget templates and google images/examples of excel spreadsheetsDiscussion ................
................

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

Google Online Preview   Download