15920 - IT Workshop

Learning outcomes

WORD

.......
.......

EXCEL

This module requires the candidate to understand the concept of spreadsheets and to demonstrate the ability to use a spreadsheet application on a computer. The candidate shall understand and be able to accomplish tasks associated with developing, formatting, modifying and using a spreadsheet8 of limited scope ready for distribution. He or she shall also be able to generate and apply standard mathematical and logical formulas using standard formulas and functions. The candidate shall demonstrate competence in creating and formatting graphs/charts

Course contents

WORD

........
........


EXCEL

General Concepts

• Open (and close) a spreadsheet application
• Save a spreadsheet to a location on a drive
• Save a spreadsheet under another name
• Save a spreadsheet in another file type such as: text file, HTML, template, software specific file extension, version number
• Switch between worksheets, open spreadsheets
• Use available Help functions
• Close a spreadsheet
• Use magnification/zoom tools
• Display, hide built-in toolbars
• Freeze, unfreeze row and/or column titles
• Modify basic options/preferences in the application: user name, default directory/ folder to open, save spreadsheets

Cells

• Enter a number, date, text in a cell
• Select a cell, range of adjacent cells, range of non-adjacent cells, entire worksheet
• Select a row, range of adjacent rows, range of non-adjacent rows
• Select a column, range of adjacent columns, range of non-adjacent columns
• Insert rows, columns in a worksheet
• Delete rows, columns in a worksheet
• Modify column widths, row heights
• Insert additional cell content, replace existing cell content
• Use the undo, redo command
• Duplicate9 the content of a cell, cell range within a worksheet, between worksheets, between open spreadsheets
• Use the autofill tool/copy handle tool to copy, increment data entries
• Move10 the contents of a cell, cell range within a worksheet, between worksheets, between open spreadsheets
• Delete cell contents
• Use the search command for specific content in a worksheet
• Use the replace command for specific content in a worksheet
• Sort a cell range by one criterion in ascending, descending numeric order, ascending, descending alphabetic order.

Worksheets

• Handling Worksheets
• Insert a new worksheet
• Rename a worksheet
• Delete a worksheet
• Duplicate a worksheet within a spreadsheet, between open spreadsheets
• Move a worksheet within a spreadsheet, between open spreadsheets

Formulas and Functions

• Arithmetic Formulas
• Generate formulas using cell references and arithmetic operators (addition, subtraction, multiplication, division)
• Recognize and understand standard error values associated with using formulas
• Understand and use relative, mixed, absolute cell referencing in formulas

Formatting

• Numbers/Dates
• Format cells to display numbers to a specific number of decimal places, to display numbers with, without commas to indicate thousands
• Format cells to display a date style.
• Format cells to display a currency symbol.
• Format cells to display numbers as percentages.
• Change cell content appearance: font sizes, font types.
• Apply formatting to cell contents such as: bold, italic, underline, double underline.
• Apply different colours to cell content, cell background.
• Copy the formatting from a cell, cell range to another cell, cell range.
• Align contents in a cell, cell range: left, centre, right, top, bottom.
• Centre a title over a cell range.
• Adjust cell content orientation.
• Add border effects to a cell, cell range.

Graphs

• Create different types of charts/graphs from spreadsheet data: column chart, bar chart, line chart, pie chart.
• Add a title, label to the chart/graph. Remove a title, label from the chart/graph.
• Change the background colour in a chart/ graph.
• Change the column, bar, line, pie slice colours in the chart/graph.
• Change the chart/graph type.
• Duplicate, move charts/graphs within a worksheet, between open spreadsheets.
• Resize, delete charts/graphs.

Prepare Outputs

• Change worksheet margins: top, bottom, left, right.
• Change worksheet orientation: portrait, landscape. Change paper size.
• Adjust page setup to fit worksheet contents on one page, on a specific number of pages.
• Add, modify text in Headers, Footers in a worksheet.
• Insert fields: page numbering information, date, time, file name, worksheet name into Headers, Footers.
• Understand the importance of checking spreadsheet calculations and text before distribution.
• Preview a worksheet.
• Turn on, off display of gridlines, display of row and column headings for printing purposes.
• Apply automatic title row(s) printing on every page of a printed worksheet.
• Print a cell range from a worksheet an entire worksheet, number of copies of a worksheet, the entire spreadsheet, a selected chart.

Pivot Table

Readings/Bibliography

Every Microsoft Word and Microsoft Excel guide

Teaching methods

WORD

.............
.............

EXCEL

There are three steps:

- Course introduction and explanation module

1. General concepts
2. Cells
3. Spreedsheat
4. 
   

Assessment methods

Teaching tools

Personal Computer

Office hours

See the website of Matteo Scheda