Learning Objectives – Intro to Excel 2016

Learning Objectives

Module 1 Learning Objectives
Given a standard IBM-compatible personal computer with Microsoft Excel 2016 installed, after reading the assigned study guide pages as well as watching the instructor-led video(s), at the end of the section the student will be able to:

  • Identify the major milestones in the evolution of the electronic spreadsheet as shown in the study guide and directed by the instructor
  • Identify the versions of the binary-based first generation of Excel as shown in the study guide and directed by the instructor
  • Identify the features of the XML-based second generation of Excel as shown in the study guide and directed by the instructor
  • Identify the versions of the XML-based second generation of Excel as shown in the study guide and directed by the instructor
Module  2 Learning Objectives
Given a standard IBM-compatible personal computer with Microsoft Excel 2016 installed, after reading the assigned study guide pages as well as watching the instructor-led activity of describing the subject matter on the classroom monitor screen, at the end of the section the student will be able to:

  • Identify the methods used to start Excel using the desktop Excel version and the online Excel version
  • Identify the important features of the various Excel screens, including the Start Screen, the New Screen, and the Open Screen
  • Identify the basic parts of the Excel Start Screen as shown in the study guide and directed by the instructor
  • Identify the major parts of the Excel Backstage View
  • Imitate the instructor’s action in accessing the major parts of the Backstage View using a mouse
  • Identify the major parts of an Excel worksheet
  • Imitate the instructor’s action in accessing the major parts of an Excel worksheet using a mouse
  • Identify the major parts of an Excel worksheet Ribbon, including the tabs and icons
  • Imitate the instructor’s action in accessing various Ribbon tabs and icons using a mouse
Module 3 Learning Objectives
Given a standard IBM-compatible personal computer with Microsoft Excel 2016 installed, after reading the assigned study guide pages as well as watching the instructor-led activity of describing the subject matter on the classroom monitor screen, at the end of the section the student will be able to:

  • Identify the important metrics of Excel worksheet specifications as shown in the study guide and directed by the instructor
  • Identify the basic navigation keys used as shown in the study guide and directed by the instructor
  • Imitate the instructor’s action in performing basic navigation on an Excel worksheet using the basic navigation keys
  • Identify the basic mouse symbols that are viewed on an Excel worksheet as shown in the study guide and directed by the instructor
  • Imitate the instructor’s action in recreating the various mouse symbols encountered on an Excel worksheet.
  • Identify the basic default icons on the Quick Access Toolbar on an Excel worksheet.
  • Imitate the instructor’s steps and actions in adding additional icons to the Quick Access Toolbar on an Excel worksheet
Module 4 Learning Objectives
Given a standard IBM-compatible personal computer with Microsoft Excel 2016 installed, after reading the assigned practice exercise step and/or observing the instructor’s demonstration on the classroom monitor screen, at the end of the section the student will be able to:

  • Imitate the instructor’s action in basic navigation movements among the columns, rows, and cells on an Excel worksheet using a keyboard and a mouse (Practice Ex. 1)
  • Imitate the instructor’s action in data entry into a worksheet cell using a keyboard and observe the cell interaction with the formula bar (Practice Ex. 2)
  • Imitate the instructor’s action in adjustments to the worksheet’s column widths and row heights using a mouse (Practice Ex. 3)
  • Imitate the instructor’s action in adjustments to the worksheet’s column widths and row heights using icons on the Ribbon (Practice Ex. 4)
  • Imitate the instructor’s action in changes to recent steps made using the Undo and Redo icons on the Quick Access Toolbar (Practice Ex. 5)
  • Imitate the instructor’s action in insertion and deletion of columns on a worksheet using icons on the Ribbon (Practice Ex. 6)
  • Imitate the instructor’s action in insertion and deletion of columns on a worksheet using a mouse (Practice Ex. 6)
  • Imitate the instructor’s action in various cell formatting changes to data in worksheet cells using the Ribbon Font and Alignment sections (Practice Ex. 7)
  • Imitate the instructor’s action in entering the SUM, AVERAGE, MAX, MIN formulas with AutoFill & AutoSum features (Practice Ex. 8)
  • Imitate the instructor’s action in entering absolute referencing with formulas to calculate salesperson % of total quarterly sales (Practice Ex. 9)
Module 5 Learning Objectives
Given a standard IBM-compatible personal computer with Microsoft Excel 2016 installed, after reading the assigned practice exercise step and/or observing the instructor’s video(s), at the end of the module the student will be able to:

  • Imitate the instructor’s action in the creation of an Excel chart on an Excel worksheet produced from an Excel range (Practice Ex. 10)
  • Imitate the instructor’s action in the formatting of numbers using the Ribbon on an Excel worksheet (Practice Ex. 11)
  • Imitate the instructor’s action in the saving of an Excel workbook to a folder (Practice Ex. 12)
  • Imitate the instructor’s action in the addition of a header and footer on an Excel worksheet (Practice Ex. 13)
  • Imitate the instructor’s action in pre-printing activities using Page Setup on an Excel worksheet (Practice Ex. 14)
  • Imitate the instructor’s action in pre-printing activities using Print Preview on an Excel worksheet (Practice Ex. 14)
  • Imitate the instructor’s action in pre-printing activities using Page Break Preview on an Excel worksheet (Practice Ex. 14)