EMC Publishing



Excel Section 1 Skills Reviews Grading RubricsReview 1: Creating Labels, Values, and FormulasES1-R1-WBQtrlyIncome.xlsxStepsTasksCriterion/CriteriaValueScore1Folder/File ManagementCreate folder named Excel EOS22Creating/TypingCreate worksheet, text indented in Row 8, 13, and 1743FormattingAccounting Number cell format E6:H1714Creating FormulasCreate formulas E8 =e6-e7 E13 =sum(e10:e12) E15 =e8-e13 E16 =e15*22% E17 =e15-e1655CopyingCopy and paste as directed from column E to F and G36 & 7Creating FormulasUse AutoSum feature in H6 for E6:G6, copy down38Organization Save file as ES1-R1-WBQtrlyIncome.xlsx in Excel EOS folder2 TOTAL POINTS: 20Review 2: Improving the Appearance of the Worksheet; Previewing and PrintingES1-R1-WBQtrlyIncome.xlsxStepsTasksCriterion/CriteriaValueScore1-3Modifying WorksheetMerge and center A through H, E5:H5 aligned right24Using HelpSearch for info on changing decimal places15FormattingCells E6:H17 one decimal place16 & 7Printing in Backstage ViewWorksheet printed with changes28PrintingWorksheet printed with cell formulas displayed29 & 10Organization Save file as ES1-R1-WBQtrlyIncome.xlsx in Excel EOS folder2 TOTAL POINTS: 10Assessment 1: Adding Values and Formulas to a WorksheetES1-A1-MPTravelCosts.xlsxStepsTasksCriterion/CriteriaValueScore1OrganizationOpen file from folder, rename file22 & 3Entering DataValues from data entered under Unit Cost64 & 5Creating FormulasFormulas for extended cost in column G, sum in G1046FormattingFormatting selected to improve appearance27Organization Save file as ES1-A1-MPTravelCosts.xlsx, printed copy1 TOTAL POINTS: 15Excel Section 1 Skills Assessments Grading RubricsAssessment 2: Creating a New WorkbookES1-A2-PTCostumeCont.xlsxStepsTasksCriterion/CriteriaValueScore1Organization, Entering Data & Creating FormulasCreate new workbook using Table 1.3, formulas show projected revenue102FormattingFormatting selected to improve appearance53Using FeaturesCities sorted ascending24 & 5Organization Save ES1-A2-PTCostumeCont.xlsx in Excel EOS folder, print3 TOTAL POINTS: 20Assessment 3: Creating a New WorkbookES1-A3-WEGGProjRev.xlsxStepsTasksCriterion/CriteriaValueScore1 & 2File Management,Entering Data &Creating FormulasCreate new workbook using information, contract price calculated formulas show projected revenue, total summed below rental and alteration fees53FormattingFormatting selected to improve appearance24 & 5Organization Save ES1-A3-WEGGProjRev.xlsx in Excel EOS folder, print3 TOTAL POINTS: 10Assessment 4: Finding Information on SortingES1-A4-WBInventory.xlsxStepsTasksCriterion/CriteriaValueScore1-4Using Help, File Management & Using FeaturesSearch Help for info, open file from folder, sort items ascending, rename file, print65 & 6Using FeaturesSort supplier name ascending, print27Organization Save ES1-A4-WBInventory.xlsx2 TOTAL POINTS: 10Assessment 5: Creating a School BudgetES1-A5-SchoolBudget.xlsxStepsTasksCriterion/CriteriaValueScore1 & 2Using Search Engines, Entering Data &Using FormulasEstimated budgetary items organized logically, totalled using sum, save file53FormattingWorksheet enhanced with formatting34 & 5Organization Print (possibly landscaped), save ES1-A5-SchoolBudget.xlsx2 TOTAL POINTS: 10Excel Section 1 Marquee Challenges Grading RubricsChallenge 1: Preparing an International Student Registration ReportES1-C1-NPCIntlRegRpt.xlsxStepsTasksCriterion/CriteriaValueScore1Entering DataInformation from Figure 1.4 entered correctly52Using FormulasColumn I contains tuition fees, totalled using SUM33FormattingColumn I contains appropriate number format24Entering DataCurrent date row 4, name row 1925Using FeaturesPage orientation landscaped16 & 7Organization Save ES1-C1-NPCIntlRegRpt.xlsx in Excel EOS folder, print2 TOTAL POINTS: 15Challenge 2: Preparing a Theatre Arts Target Enrollment ReportES1-C2-NPCTargetEnrolRpt.xlsxStepsTasksCriterion/CriteriaValueScore1Entering DataInformation from Figure 1.5 entered correctly52 & 3Using FormulasColumn titled target contains formula projecting target enrolment, totalled using SUM34 & 5Formatting/ Using FeaturesAligned as directed, name in row 8, date in row 9, format Target column zero decimal places, landscaped page56 & 7Organization Save ES1-C2-NPCTargetEnrolRpt.xlsx in Excel EOS folder, print2 TOTAL POINTS: 15 ................
................

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

Google Online Preview   Download