Napier-FALL09-ITEC1001-Test2-Objectives

From GGCWiki
Jump to: navigation, search

Finalized by Nannette Napier, 10:31 AM, 31 October 2009

Test 2 covers Excel (25 points) plus selected material from Chapters 4 and Chapter 5 (25 points). Main objectives from the textbook are below. In addition to these pages, anything we discussed in class or covered in the warm-up assignments may be on the test.


Excel Skills

  • Entering Data
  • Editing a Worksheet
    • Deleting columns and rows
    • Inserting columns and rows
    • Merging cells
  • Selecting cells and ranges
    • Using Cut, Copy, Paste
  • Formatting Worksheets
    • Changing fonts and font sizes
    • Applying different number formats such as Accounting, Currency, and Comma
    • Using cell styles. Changing Workbook theme
    • Adding borders, shading, and colors to cells
    • Modifying column widths and row heights
    • Hiding and unhiding columns and rows
    • Applying Bold, Italic, and Underline
  • Using Formulas and Functions
    • Entering and editing formulas
    • Using operators in formulas (*, /, +, -, <>)
    • Using relative & absolute references in a formula
  • Using functions properly
    • SUM, AVERAGE, MAX, MIN, COUNT
    • IF, COUNTIF, AND, OR
  • Working with Charts
    • Inserting a new chart
    • Modifying and formatting a chart (chart title, axis titles, data labels, legend)
    • Moving a chart to new worksheet
  • Managing Worksheets
    • Renaming worksheets
    • Insert and delete worksheets
    • Move and copy worksheets
  • Printing
    • Defining part of the worksheet as the print area
    • Adding custom headers and footers
  • Create a simple Pivot Table
    • Be able to change the calculated value to Average, Sum, Count, Min, Max, etc.

Chapter 4

Selected Chapter 4 Learning Outcomes

Study the pages associated with the following learning objectives:

4.1 What’s the difference between application software and system software?

4.2 What kinds of applications are included in productivity software I might use at home?

4.3 What are the different types of multimedia software?

4.7 What kinds of software do small and large businesses use?

4.8 Where can I go for help when I have a problem with my software?

  • Key terms (see p. 202): application software, course management software, database software, digital video editing software, financial planning software, image editing software (photo editing software), integrated help, integrated software application, macro, multimedia software, open source software, personal information manager (PIM) software, presentation software, productivity software, program, software, software suite, spreadsheet software, system software, tax preparation software, template, Web-based application software, wizard, word-processing software

Chapter 5

Selected Chapter 5 Learning Outcomes

Study the pages associated with the following learning objectives:


5.4 How does the operating system provide a means for users to interact with the computer?

5.8 What are the main desktop and window features?

5.9 How does the operating system help me keep my computer organized?

5.10 What utility programs are included in system software, and what do they do?

  • Key terms (see p. 250): application software, command-driven interface, desktop, directory, Disk Cleanup, disk defragmenter, extension (fie type), file, file compression utility, file management, file path, foler, graphical user interface (GUI), menu, menu-driven interface, multitasking, multiuser operating system, operating system, path separator, Plug and Play (PnP), real-time operating system, Recycle Bin, System restore, system software, Task Manager utility, Task Scheduler utility, thrashing, user interface, utility program, virtual memory, Windows Explorer, Winzip
Personal tools