IT for Administration

Course details

This module will introduce the core IT skills required for the business administration environment, covering the following applications - file management, Internet/email, presentations and spreadsheets. The module also incorporates significant technology trends that affect computing and everyday life. This theory component is delivered online, using the Blackboard Learning System.

Description/Learning Outcomes

1. Understand and apply technology in their personal and professional lives.
2. Use Internet, email and presentation tools to facilitate communication.
3. Create and maintain a correct computerised filing system.
4. Prepare spreadsheets to an intermediate level.

Learning Strategies

• Small classes with close supervision in a computer-based laboratory situation.
• The students's ability to apply learning will be enhanced through working with practical examples in class.
• The theory will be delivered online, which provides flexibility and convenience. Course materials can be easily accessed by students and studied at their own pace and time.

Content

Theory Content

Computers and Digital Basics

• All Things Digital
• Digital Devices
• Digital Data Representation
• Digital Processing
• Password Security

Computer Hardware

• Personal Computer Basics
• Microprocessors and Memory
• Storage Devices
• Input and Output Devices
• Hardware Security

Computer Software

• Software Basics
• Popular Applications
• Buying Software
• Installing Software and Upgrades
• Security Software

Operating Systems and File Management

• Operating System Basics
• Today's Operating Systems
• Fifle Basics
• File Management
• Backup Security

The Web and E-mail

• Web Technology
• Search Engines
• E-Commerce
• Internet Services

Managing Computers and Files

Windows Explorer

• File Data/status/extensions/icons
• File Sorting/searching/copying/moving/renaming/deleting/recycle bin
• File compression/extraction
• Creating/moving/deleting folders
• Folder structures/grouping
• Primary and secondary storage/memory keys
• Formatting for secondary storage
• Viruses/installing new software
• Setting default printer
• Help facility
• Print screen facility

The Internet/Email

Internet

• Connecting/Browsers/ISPs
• URLs/Links/Browser toolbar
• Saving a web page/graphics
• Search engines/Searching the WWW
• History/Favourites/Bookmarks
• Setting Home Page
• Image blocking
• Copying into documents
• Downloading files
• Safety & Security

Email

• Addresses/global address list
• Safety and security
• Toolbar/inbox/outbox/sent/trash/
• Customising Folders
• Composing and sending
• Spell check/print/marking messages for priority
• Attachments/opening/saving
• Replying/forwarding/moving messages
• Copy and paste
• Contacts list
• Group lists
• E-mail Etiquette
• Presentations
• Presentation screen/slide layout/screen views
• Saving/Opening/Closing presentations
• Custom slide shows
• Drawing tools/clipart
• Copying/rearranging/templates slides
• Transitions/animation/smartart graphics/design
• Master Slides
• Spell check
• Adding notes to slides
• Inserting Video and Audio content
• Presentation controls

Introduction to Excel Environment

Creating a new workbook

• Column/row formatting/freezing rows and columns
• Formulas/sum/average/max/min/count/counta
• If function//Date/Time
• Copy/wrap/merge/delete data
• Replicate & Fill series
• Sort & Custom sorts
• Cell styles/borders/headers & footers
• Absolute and Relative cell addressing
• Cell and Range names
• Naming & linking worksheets
• Screenshot
• Charts and graphs
• Excel tables
• Data visualisation • sparklines, data bars, icon sets
• Conditional formatting
• H and V lookup functions
• Filtering
• VBA Macros, security and macro buttons

Assessment Strategies

• Practical Continuous Assessment in class
• Lab based practical assessment
• Lab based Online Theory assessment
• The Repeat Exam is to be a final Scheduled Practical and Written Exam covering all elements (including theory) of the module.