Napier-F11-ITEC1001-18-Test2-Objectives

From GGCWiki
Jump to: navigation, search

Contents

Test Logistics for ITEC 1001 Section 18, MWF 9:30-10:45

Test 2 will be Friday, November 11

  • Textbook and Presentation content will be tested using multiple choice, short answer, matching, and true/false questions
  • Excel skills will be tested by having students complete an activity using myITLab simulation.

Presentation Topics

Links to slides are provided

  • Mac vs. PC - Pros and Cons [1]
  • How is IT used in Education? [2]
  • Medical Technology [3]
  • How is IT used in Healthcare? [4]
  • Mobile applications [5]
  • How is IT used in Sports? [6]
  • How is IT used in Music Industry? [7]
  • Identity theft awareness [8]

Chapter 1

Read and study the examples under the following headings

  • Retail: Working in a Data Mine
  • Education: Teaching and Learning
  • Law Enforcement: Put Down that mouse -- You're under arrest
  • Military Careers: Drive that drone
  • Medicine Technologies of Today and Tomorrow
  • Knowledge is Power -- Bridging the Digital Divide (p. 22)
  • Key terms: data mining, microexpressions, UAVs, drones,computer forensics, RFID, patient simulator, digital divide

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 is available online?

  • NOTE: For each of the categories of software, be able to identify some of the names of the software. For example, word processing --> MS Word, OpenOffice Writer, etc.
  • Key terms: animation software, application software, audio editing software, cell, course management software, database software, digital video editing software, drawing software, financial planning software, formula, function, image editing software (photo editing software), integrated help, integrated software application, macro, multimedia software, notetaking software, open source software, personal information manager (PIM) software, presentation software, productivity software, program, proprietary software, software, software suite, spreadsheet software, system software, table, template, Web-based application software, wizard, word-processing software, worksheet

Excel Skills

  • Entering Data
    • NOTE: Use CTRL+Enter to enter data and maintain the current cell address
  • Editing a Worksheet
    • Deleting columns and rows
    • Inserting columns and rows
    • Merging cells
    • Using wrap text
    • Using find and replace (Home --> Find & Select --> Replace)
  • 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
      • Be able to modify one column or row at a time
      • Be able to modify multiple columns or rows at a time
    • 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
  • 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
    • Changing color of the tab in a worksheet
    • Insert and delete worksheets
    • Move and copy worksheets
  • Tables
    • Sorting a column in a table
      • Ascending: smallest to largest
      • Descending: largest to smallest
    • Filtering a column in a table
  • Printing
    • Defining part of the worksheet as the print area
    • Adding custom headers and footers
Personal tools