CPSC 203: Concepts And Skills Applied

MS-Word

Assumed student skills coming into this course:

• Start Word

• Creating a new document

• Enter/editing text

• Saving a document

• Printing

• Quitting Word

Assignment 1:

• (Rudimentary skills such as: opening/saving documents that students are either assumed to already have or can quickly pick up on their ownaren't explicitly listed).

• Editing headers: insert page count

• Aligning text

• Choosing fonts and font sizes

• Inserting page breaks

• Adding an automatically generated table of contents

• Inserting footnotes

• Creating and using citations

• Adding a bibliography

• Text styles: creating and using a new style

• Automatically captioning (and updating) images

• Creating a master document out of existing sub-documents

• Using the mail merge filter in Word, creating rules in order to filter results in the merged document

MY-IT lab (content of simulation training but not simulation exams)

• This is an approximate overview, for specific details go to the MY-IT lab website for Pearson: https://www.pearsonmylabandmastering.com/northamerica/

• Chapter 1: Introduction to Word, organizing a document

  • How to change tabs in the Office ribbon

  • Customizing the ribbon

  • Opening existing documents

  • Create a new document

  • Hard vs. soft returns

  • How to edit headers and footers

  • Zooming into a document

  • Changing margins

  • Insert pictures

    • From your computer

    • From online

    • Searching for images with different copyright (as specified by the creative common license)

  • Inserting text (from an existing Word document)

  • Saving/saving as documents

  • Modifying text (select and edit text)

  • Relocating text (cut, copy and paste in/out of the Office Clipboard)

  • Running a spelling and grammar check on a document

  • Running a Word count (and other counts) on a Word document

  • Converting an older Word document to 2016

  • Checking a document for issues with an older version of Word

  • Printing a document

  • Seeing a print preview of a document

  • Viewing and changing the document properties

• Chapter 2: Document Presentation: Editing and Formatting

  • Font options: font type, font appearance

  • Formatting paragraphs: alignment, paragraph spacing, indenting

  • Tabs

  • Borders and shading

  • Bulleted and numbered lists

  • Using document themes (include coordinating fonts, colors and special effects)

  • Breaking a document into sections e.g. headline with center alignment while the rest of the article is divided into 2 columns of text

  • Creating new styles, adding a new style to documents based on this template, using the format painter

  • Changing document views

  • Outline view: changing to, benefits (need to use 'heading' styles)

  • Print layout view

  • Inserting objects (e.g. online images, screenshots, from the computer)

  • Images: moving, aligning and resizing

  • Wrapping text and images

  • Word art: text with special effects such as colors, shading, gradients, 3D effects (stands out but cannot be formatted as regular text)

• Chapter 3: Document Productivity, Working with Tables and Mail Merge

  • Tables:

    • inserting, drawing, modifying tables

    • merge/split cells

    • auto fit cells to text size

    • wrapping text

    • design->table styles

    • text alignment

    • format table text

    • change column & row height & width

    • Inserting formulas into tables (layout->data->formula)

    • Borders and shading of tables

    • Converting: text->table, table->text

    • Auto captioning tables

  • Using mail merge to create a customized letter

• Chapter 4: Collaboration and research Communicating and Producing Professional Papers

  • Formatting a document to conform to common style requirements (e.g. text alignment, line spacing, margins, indenting, font type and space, header formatting).

  • Applying writing styles (e.g. APA) references, style

  • References

    • Bibliography

    • Footnotes

    • Table of contents

    • Index

    • Cover page

    • Managing reference sources

  • Collaboration tools

  • Creating PDF and XPS documents

  • Document comments

  • Change tracking

MS-Excel

• Assignment 2:

  • Formatting text: merging cells, changing fonts, (possibly changing aligning text)

  • Defining custom formulas (e.g. calculating a weighted term grade point)

  • Defining a lookup table (to be used with a lookup function)

  • Using pre-created functions: MIN, MAX, AVERAGE, COUNTIF, VLOOKUP, IF, AND

  • Absolute vs. relative cell references

  • Visualizing data using a graph (bar chart)

  • Employing the data validation feature of Excel to prevent errors, specifying custom messages to prevent errors and to react to errors when they have occurred

  • Using conditional formatting to highlight data

   

• MY-IT lab (content of simulation training but not simulation exams)

  • This is an approximate overview, for specific details go to the MY-IT lab website for Pearson: https://www.pearsonmylabandmastering.com/northamerica/

  • Chapter 1: Introduction to Excel, what is a spreadsheet?

    • Entering text, values, dates, clearing cell contents

    • Using cell references in formulas & applying the order of operation (precedence)

    • Inserting/deleting columns and rows

    • Hiding columns

    • Adjusting column width and height

    • Copy and pasting a range

    • Applying a cell style, merging cells

    • Changing cell alignment

    • Increasing cell indent

    • Applying a border and a fill color

    • Applying number formats and changing the number of decimal places displayed

    • Copy, move, rename worksheets

    • Setting page orientation, scaling and margins

    • Creating headers

    • View in print preview and print

  • Chapter 2: Formulas and functions

    • Absolute and relative cell references

    • Functions: AVERAGE, SUM, MEDIAN, MIN, MAX, COUNT, VLOOKUP, PMT, IF

  • Chapter 3: Charts, depicting data visually

    • Charts: Clustered column, bar, pie, combo

    • Moving and resizing charts

    • Edit and format chart titles

    • Add and format axis titles and format axes

    • Add and format data labels

    • Format the chart area and a data point

    • Apply a chart style & chart filters

    • Insert and customize sparklines

  • Chapter 4: Datasets and tables, managing large volumes of data

    • Freezing rows and columns

    • Managing page breaks

    • Set and clear a print area

    • Print titles

    • Creating a table

    • Add and delete fields

    • Adding a record

    • Removing duplicate rows

    • Applying a table style

    • Sorting one field, by multiple fields

    • Applying text filters

    • Applying a number filter

    • Creating structured references in formula

    • Creating a custom sort

    • Applying a data filter

    • Add a total row

    • Highlight cell rules

    • Specify top/bottom rules

    • Display data bars

    • Using a formula in conditional formatting

  • Chapter 9: Multiple-Sheet Workbook Management: Ensuring Quality Control

    • Group/ungroup worksheets and fill information across worksheets

    • AutoSum ranges

    • Accounting number format

    • Applying borders to cells

    • Applying Fill handles

    • Inserting hyperlinks into cells

    • Opening and arranging worksheets

    • Inserting worksheet references (a cell in one worksheet referring to a cell in another worksheet)

    • Insert 3D formulas

    • Setting auto column widths

    • Linking workbooks with relative cell references

    • Tracing dependencies & precedents in cell references

    • Checking for errors, repair circular references with respect to cell references

    • Setting up watch windows

    • Creating validation rules, specify inputs and alerts

VBA programming in Word