Pery Square Business College :: Business Training and Computer Courses Limerick :: ECDL :: QQI :: ICS.
Self Study Options
Your placement cannot be guaranteed until full payment has been made or funding has been approved
Purpose
Gain an understanding of key web publishing concepts and learn the core skills required to design, create and maintain a website. You will also learn a range of web design skills from HTML to cascading style sheets (CSS).
Learn about web development & editing without having to commit to the time and expense of a professional-level web design programme.
By explaining the basics and cutting through the jargon of web site design, ECDL Web Editing gives you the skills you need.
General Aims
Learners who successfully complete this course will:
- Understand key web concepts and terms
- Know about the basic principles of HTML and use common HTML mark-up tags to modify the layout of a web page
- Use a web authoring application to design and format web pages, format text, and work with hyperlinks and tables
- Recognise and use common web image formats and create forms in a web page
- Understand and use cascading style sheets (CSS)
- Be able to prepare web pages for publishing to a web server
Course Details
Course Content
- Web Concepts
- HTML
- Web Authoring
- Using Objects
- Styles
- Prepare Upload
(Click this link for full course details)
Entry Requirements
Applicants must have:
- Proficiency in internet and e-mail use (including attachments)
- Word processing
Assessment
Award(s): ECDL Foundation Certificate in Web Editing
You will complete an online test which must be taken at Pery Square Business College.
You will have 45 minutes to complete the online test. Tests are Automated Online Exams with instant marking notification. *subject to pass mark of 75% or more
Exams held on Friday Afternoons from 2pm - Must book in Advance.
Purpose
ECDL Advanced
The ECDL Advanced gives candidates the opportunity to be certified at an 'expert level' in the use of the specific application type, acquiring skills sets over and above the routine features of the software. Each ECDL Advanced module is a stand-alone certification. An ECDL Advanced certificate (e.g. ECDL Advanced Word Processing) is awarded to candidates who pass each specific module test. Training can be provided prior to testing, although candidates may forego training if they wish, assuming they already have advanced-level skills. Ideal follow-on to the ECDL course or a QQI Level 4 computer course.
Expert Certification
Candidates who successfully complete 3 of the 4 ECDL Advanced modules are awarded the ECDL Expert certification, which signifies expert-level computer competence.
Entry Requirements: All Prospective candidatesshould ideally have the ECDL certification and/or previous experience using computers and common software applications.
Assessment: Each module is assessed by a one-hour test.
Course Details
ECDL Advanced Word Processing skills can:
- Apply advanced text, paragraph, column and table formatting.
Convert text to a table and vice versa
- Work with referencing features like footnotes, endnotes and captions.
Create tables of contents, indexes and cross-references
- Enhance productivity by using fields, forms and templates
- Apply advanced mail merge techniques and work with automation features, such as macros
- Use linking and embedding features to integrate data
- Collaborate on and review documents. Work with master documents and sub-documents.
Apply document security features
- Work with watermarks, sections, and headers and footers within a document
|
ECDL Advanced Spreadsheets skills can:
- Produce higher quality information
- Pinpoint key information quicker and more easily
- Provide more sharply-defined analysis
- Produce more sophisticated reports
- Use advanced editing, data handling, functions and analysis features
- Use macros within the spreadsheets application
|
ECDL Advanced Presentation certified skills can:
- Plan and design more effective presentations that have greater impact
- Use advanced features to customise layout and shows
- Use and manipulate pictures, images and drawn objects, charts/graphs in presentations
- Add sophisticated multimedia elements to presentations
- Use the powerful relating tools to link information to other applications
|
ECDL Advanced Database skills can:
- Produce better reports with deeper data analysis
- Produce higher quality management information
- Use advanced features in table, query, form and report design
- Use macros within the database application
- Import, export and link data
|
Purpose
ECDL (European Computer Driving Licence Course)
Need to learn computer and Internet skills to get that job? Move ahead in your career?
Return to education? Or maybe start that little business you have always dreamt of?
Whatever your goal in work, education or life, ECDL can help you get there.
Move forward with the world’s most popular IT user certification.
- ECDL is the certification most widely recognised and highly valued by Irish employers
- ECDL equips you with practical computer and Internet skills.
- ECDL offers you a wide range of subject modules.
- ECDL offers flexible study options, including online learning.
Included in price: Access to Notes, our own training videos and Online Learning, Test & sample tests for each module.
Do this to keep up with all the changes in Microsoft Office. Ideal as a refresher or a back to work or college course.
Course Detail
This extremely popular course consists of 7 subjects called Modules.
Module 1 - Computer Essentials: Discover the essential concepts and skills relating to the use of devices, file creation and management, networks, and data security. This Module covers everything from hardware to software to malware . Module 2 - Online Collaboration: Discover the concepts and skills relating to the setup and use of online collaborative tools, such as storage, productivity applications, calendars, social media, web meetings, learning environments, and mobile technology.
Module 3 - Word Processing: Learn how to use word processing software to accomplish everyday tasks. Discover how to create and format letters and short documents, work with different page sizes, control font and other settings, and insert images in a document.
Module 4 - Excel / Spreadsheets: Discover how to develop, modify and use a spreadsheet for typical data management and analysis tasks. Learn how to use formulas and functions for performing calculations, and create graphs and charts based on spreadsheet data.
Module 5 - PowerPoint / Presentations: Learn how to create, format, modify and prepare presentations for display and printed distribution. Discover how to create presentation templates, control fonts and background settings, and insert tables, images and charts.
Module 6 - Access / Databases: Gain the knowledge and skills to create and modify tables, queries, forms and reports. Learn how to relate tables, and how to retrieve and manipulate information from a database by using query and sort tools.
Module 7 - Online Essentials: Learn about security and safety on the web, and about online communities and communications. This new ECDL Module covers the basics of going online, including web browsing, effective search engine use, online communication and email
Requirements
To complete this course successfully you must have good basic computer skills and knowledge of at least Word Processing with saving, formatting text, cut/copy/paste and also good use of Internet & Email.
If unsure please ring the college and speak to a trainer who can assess your suitability.
ECDL Online Learning is ONLY available for Microsoft Office 2007, 2010 or 2013.
(MS Office 2016 is not currently available in ECDL learning or testing.)
You MUST have access to a Laptop or PC with a relevant Microsoft Office version (see above) installed in order to complete the online learning and sample practice tests at home.
Contact college to arrange setup and introduction to your ECDL Learning Software.
YOU MUST INFORM US WHEN BOOKING WHAT VERSION OF MICROSOFT OFFICE YOU WILL BE USING.
Resits and extra sample tests available at extra cost.
Assessment
Assessment: You will complete an online test for each of the 7 ECDL Modules which must be taken at Pery Square Business College. You will have 45 minutes to complete each online test. Exams held on Friday Afternoons from 2pm - Must book in Advance.
All Tests are Automated Online Exams, with instant marking notification.
* subject to pass mark of 75% or more
Certification: European Computer Driving Licence (ECDL) on successful completion of all 7 Modules.
It is recommended that even if you have an existing ECDL certificate that you update your skills every five years at a minimum.
Outline
Microsoft Office Specialist - Access
This course is aimed at participants who wish to gain an industry qualification in the Access database environment. Candidates should have an understanding of the Windows environment and be relatively comfortable Managing Files and Folders, Searching for Files and Folders, Using the Control Panel, and Viewing System Information.
Course Details
|
Understanding Databases
• Starting and Opening an Existing Database
• Moving Around in Access
• Understanding Datasheet View & Design View
• Using the Mouse Pointer to Navigate
• Using the Keyboard to Navigate
|
Creating Tables
• Creating a Database
• Creating a Table Using the Wizard
• Creating and Modifying a Table
• Adding Fields to Tables
• Adding and Editing Records
• Printing Tables
• Moving and Deleting Fields
• Deleting Records
|
|
Working With Tables
• Formatting a Table
• Modifying Field Properties
• Sorting Records in a Table
• Finding Records in a Table
• Using Filters with a Table
• Establishing Relationships Between Tables
• Creating Subdatasheets
• Importing Records From an External Source
|
Creating and Using Queries
• Creating and Running a Query
• Specifying Criteria in a Query
• Using Comparison Operators
• Creating a Calculated Field
• Creating a Multiple-Table Query
• Printing a Query
|
|
Designing a Form
• Creating a Form Using AutoForm
• Creating a Form Using the Form Wizard
• Adding Controls to a Form
• Modifying Control Properties
• Resizing and Moving Controls
• Entering Records into a Form
• Creating Calculated Controls
|
Designing a Report
• Creating a Report Using AutoReport
• Creating a Report Using Report Wizard
• Adding a Control to a Report
• Formatting a Report
• Resizing and Moving Controls
• Creating Calculated Controls
• Previewing and Printing
|
Outline
Microsoft Office Specialist - Excel
This course is aimed at participants who wish to gain an industry qualification in the Excel environment. Candidates should have an understanding of the Windows environment and be relatively comfortable Managing Files and Folders, Searching for Files and Folders, Using the Control Panel, Viewing System Information.
Course Details
|
Learning Worksheet Fundamentals
- Creating Workbooks
- Magnifying and Shrinking a Worksheet on Screen
- Understanding MS Excel Window Environment
- Hiding and Unhiding Rows & Columns
- Selecting a Range of Cells
- Freezing and Unfreezing Rows & Columns
- Entering Text/Numbers/Dates in a Worksheet
- Moving Between Worksheets in a Workbook
- Entering a Range of Data
- Adding and Deleting Worksheets in a Workbook
- Editing Cell Contents
- Creating a Three-Dimensional Formula
- Moving Between Worksheets
- Linking Workbooks
- Naming and Saving Workbooks
- Opening Workbooks
- Renaming Worksheets
- Closing Workbooks and Quitting Excel
|
Editing and Formatting Worksheets
- Formatting Numbers
- Creating Charts Using the Chart Wizard
- Adjusting the Size of Rows and Columns
- Moving/Resizing/Deleting Charts
- Aligning Cell Contents
- Modifying Chart Titles and Adding Axis Labels
- Creating and Applying Conditional Formats
- Moving and Formatting Chart Elements
- Finding and Replacing Cell Content
- Changing the Chart Type & Organising Source Data
- Inserting and Deleting Cells/Rows/Columns
- Updating Data and Formatting the Axes
- Cutting/Copying/Pasting/Clearing Cells
- Adding Gridlines and Arrows
- Using Additional Paste Features
|
|
Formatting Cells
- Formatting Text
- Building/Editing/Copying Formulas
- Formatting Numbers as Currency
- Using the Sum Function and AutoSum
- Using Format Painter
- Using the Formula Palette
- Adding Borders/Shading to Cells
- Using the Date Functions
- Using AutoFormat
- Using Absolute and Relative Cell References
- Creating and Applying Styles
- Using Basic Statistical Functions
- Merging Cells
|
Changing Print Options
- Adding Headers and Footers
- Using the PMT Function to Forecast Loan Payments
- Changing Margins and Centering a Worksheet
- Calculating Cumulative Interest
- Changing the Orientation and Scale
- Computing Investment Value
- Adding and Deleting Page Breaks
- Using the IF Function
- Setting and Clearing a Print Area
|
|
Rows/Columns/Worksheets/Workbooks
- Magnifying and Shrinking a Worksheet on Screen
- Understanding MS Excel Window Environment
- Hiding and Unhiding Rows and Columns
- Selecting a Range of Cells
- Freezing and Unfreezing Rows and Columns
- Entering Text/Numbers/Dates in a Worksheet
- Moving Between Worksheets in a Workbook
- Entering a Range of Data
- Adding and Deleting Worksheets in a Workbook
- Editing Cell Contents
- Creating a Three-Dimensional Formula
- Moving Between Worksheets
- Linking Workbooks
|
Working with Charts
- Creating Charts using the Chart Wizard
- Adjusting the Size of Rows and Columns
- Moving/Resizing/Deleting Charts
- Aligning Cell Contents
- Modifying Chart Titles and Adding Axis Labels
- Creating and Applying Conditional Formats
- Moving and Formatting Chart Elements
- Finding and Replacing Cell Content
- Changing the Chart Type & Organising Source Data
- Inserting and Deleting Cells/Rows/Columns
- Updating Data and Formatting the Axes
- Cutting/Copying/Pasting/Clearing Cells
- Adding Gridlines and Arrows
- Using Additional Paste Features
- Previewing and Printing a Chart
|
|
Performing Basic Calculations
- Building/Editing/Copying Formulas
- Formatting Numbers as Currency
- Using the Sum Function and AutoSum
- Using Format Painter
- Using the Formula Palette
- Adding Borders/Shading to Cells
- Using the Date Functions
- Using AutoFormat
- Using Absolute and Relative Cell References
- Creating and Applying Styles
- Using Basic Statistical Functions
- Merging Cells
- Using Numbered Series and AutoFill
|
Using Basic Financial and Logical Functions
- Using the PMT Function to Forecast Loan Payments
- Changing Margins and Centering a Worksheet
- Calculating Cumulative Interest
- Changing the Orientation and Scale
- Computing Investment Value
- Adding and Deleting Page Breaks
- Using the IF Function
|
|
Using Excel with the Internet
- Creating and Editing Hyperlinks
- Saving Workbooks and Worksheets as Webpages
- Sending Workbooks via E-Mail
|
Outline
Microsoft Office Specialist - Outlook
This course is intended for Administrative and Office professionals, Consultants, Executives/Managers, Help desk personnel, Instructors/Trainers, Marketing personnel, Product developers, Sales, Students, and other members of the general population working in a business environment who have intermediate or expert knowledge of the Microsoft Office suite.
Course Details
|
Managing the Outlook Environment
- Apply and manipulate Outlook program options.
- Manipulate item tags.
- Arrange the Content Pane.
- Apply search and filter tools.
- Print an Outlook item.
|
Creating and Formatting Item Content
- Create and send email messages.
- Create and manage Quick Steps.
- Create item content.
- Format item content.
- Attach content to email messages.
|
|
Managing Email Messages
- Clean up the mailbox.
- Create and manage rules.
- Manage junk mail.
- Manage automatic message content.
|
Managing Contacts
- Create and manipulate contacts.
- Create and manipulate contact groups.
|
|
Managing Calendar Objects
- Create and manipulate appointments and events.
- Create and manipulate meeting requests.
- Manipulate the Calendar pane.
|
Working with Tasks, Notes and Journal Entries
- Create and manipulate tasks.
- Create and manipulate notes.
- Create and manipulate Journal entries
|
Outline
Microsoft Office Specialist - PowerPoint
This course is aimed at participants who wish to gain an industry qualification in the PowerPoint environment. Candidates should have an understanding of the Windows environment and be relatively comfortable Managing Files and Folders, Searching for Files and Folders, Using the Control Panel, Viewing System Information.
Course Details
|
Creating a Presentation
- Creating a Presentation Using a Wizard
- Viewing and Choosing a Colour Scheme
- Exploring and Moving around a Presentation
- Changing Colours in a Colour Scheme
- Changing Text in the Outline Pane, Slide Pane
- Creating a New Scheme
- Reversing one or more Actions
- Adding New Colours to Colour Menus
- Changing Presentation Views, Properties
- Adding a Background
- Previewing Slides and Saving Presentations
|
Working with a Presentation
- Using the Design Template
- Drawing, Editing, Copying and Moving an Object
- Entering Text into Slide/Outline/Notes Pane
- Changing the Shape of an Object
- Creating a New Slide
- Modifying Object Attributes
- Editing in Normal View
- Aligning, Connecting Objects
- Entering Speakers’ Notes
- Adding 3-D Effects to Objects
- Rearranging Slides in Slide Sorter View
- Changing, Rotating, Flipping Objects
- Showing Slides
|
|
Printing a Presentation
- Inserting a Table
- Moving Around and Selecting Cells
- Merging Table Cells
- Inserting and Deleting Columns & Rows
- Resizing a Table
- Adding Shading to a Table
- Modifying Table Borders
|
Outlining Your Ideas
- Creating a Blank Presentation
- Navigating in Slide Show View
- Viewing and Entering Text
- Annotating Slides During a Slide Show
- Inserting an Outline from MS Word
- Setting Text Transitions
- Changing the View of an Outline
- Animating Slides
- Selecting, Rearranging, Slides, Paragraphs & Text
- Hiding a Slide during a Slide Show
- Sending an Outline or Notes to Word
|
|
Adding and Modifying Text
- Selecting and Deselecting Objects
- Inserting Sound, Movies
- Adding and Formatting Text to Slides
- Setting Slide Timings
- Adjusting the Position of Text Objects
- Rehearsing Slide Timings
- Changing Text Alignment and Spacing
- Recording a Narration
- Checking Spelling, Presentation Styles
|
Applying and Modifying Templates
- Understanding PowerPoint Masters
- Creating an Agenda Slide or Home Page
- Changing the Display using the Master
- Creating a Hyperlink to a Slide/Excel Chart/Web site
- Modifying Master Placeholders
- Creating an Action Button
- Formatting Master Text
- Previewing a Presentation as a Web Page
- Reapplying a Slide Layout
- Saving and Publishing a Web Page as a Presentation
- Hiding Master Objects
- Accessing the Internet from PowerPoint
- Saving a Template
|
|
Using a Colour Scheme
- Viewing and Choosing a Colour Scheme
- Exploring and Moving around a Presentation
- Changing Colours in a Colour Scheme
- Changing Text in the Outline Pane, Slide Pane
- Creating a New Scheme
- Reversing one or more Actions
- Adding New Colours to Colour Menus
- Changing Presentation Views, Properties
- Adding a Background
- Previewing Slides and Saving Presentations
- Copying a Colour Scheme
|
Drawing and Modifying Objects
- Drawing, Editing, Copying and Moving an Object
- Entering Text into Slide/Outline/Notes Pane
- Changing the Shape of an Object
- Creating a New Slide
- Modifying Object Attributes
- Editing in Normal View
- Aligning, Connecting Objects
- Entering Speakers’ Notes
- Adding 3-D Effects to Objects
- Rearranging Slides in Slide Sorter View
- Changing, Rotating, Flipping Objects
- Showing Slides
- Grouping and Ungrouping Objects
|
|
Inserting Information into PowerPoint
- Inserting a Clip Art Image
- Previewing Slides in Black and White
- Scaling an Image
- Adding a Header and a Footer
- Re-colouring a Clip Art Image
- Changing the Page Setup
- Inserting and Formatting a Table
- Choosing a Printer
- Inserting a Graph, Excel, Organisational Chart
- Printing Slides, Audience Handouts, Speaker Notes
- Inserting and Modifying a Picture
|
Producing a Slide Show
- Navigating in Slide Show View
- Viewing and Entering Text
- Annotating Slides During a Slide Show
- Inserting an Outline from MS Word
- Setting Text Transitions
- Changing the View of an Outline
- Animating Slides
- Selecting, Rearranging, Slides, Paragraphs & Text
- Hiding a Slide during a Slide Show
- Sending an Outline or Notes to Word
- Creating and Editing a Custom Slide Show
|
|
Creating a Multimedia Presentation
- Inserting Sound, Movies
- Adding and Formatting Text to Slides
- Setting Slide Timings
- Adjusting the Position of Text Objects
- Rehearsing Slide Timings
- Changing Text Alignment and Spacing
- Recording a Narration
- Checking Spelling, Presentation Styles
- Using the Projector Wizard
|
Creating an Internet Presentation
- Creating an Agenda Slide or Home Page
- Changing the Display using the Master
- Creating a Hyperlink to a Slide/Excel Chart/Web site
- Modifying Master Placeholders
- Creating an Action Button
- Formatting Master Text
- Previewing a Presentation as a Web Page
- Reapplying a Slide Layout
- Saving and Publishing a Web Page as a Presentation
- Hiding Master Objects
- Accessing the Internet from PowerPoint
- Saving a Template
- Presenting a Show on Two Monitors
|
|
Reviewing and Sharing a Presentation
- Sending a Presentation
- Taking Notes during a Presentation
- Broadcasting a Presentation over a Network
- Using the PowerPoint Viewer
- Hosting and Participating in an Online Broadcast
- Using the Pack and Go Wizard
- Using Online Collaboration, Online Meeting
- Holding a Web Discussion
|
|
Outline
Microsoft Office Specialist - Word
This course is designed to advance existing Word users and help them take advantage of the powerful features available in Word. Would be suitable as a follow-on course to the ECDL. The course is geared towards users requiring a detailed knowledge of the package in order to produce professional publications and further streamline and automate repetitive office tasks.
Self study manual comes with online training material, sample tests and a free resit – if required (note: the free resit must be done within a month)
Course Details
Getting Started with Word
Exploring the Word window
Using Standard/Personalised Menus
Using the Office Assistant
|
Editing a Document
Inserting Text in a Document
Selecting, Deleting and Restoring Text
Creating a Folder/Saving alternatively named files
|
Working with Tables
Inserting a Table/Merging Table Cells
Inserting and Deleting Columns & Rows
Resizing /Adding Shading/Modifying Borders
|
Formatting Text
Aligning, Moving and Copying Text/Applying Styles
Creating a Paragraph Border, Adding Shading
Previewing/Printing a Document
|
Using Automated Formatting
Setting AutoFormat Options/ Borders
Create Automatic Bulleted/Numbered List
Multiple Attributes with Format Painter
Creating/Inserting an AutoText Entry
Creating and Printing a Mailing List
|
Using Editing and Proofing Tools
Checking Spelling/Grammar/Thesaurus
Finding/Replacing Specific Text
Creating AutoCorrect Entries & Exceptions
Inserting Date & Time, Special Characters
|
Working with Graphics
Insert a Picture from a File/Clipart Gallery
Creating WordArt/Drawing a Shape/Resizing
|
Working with Columns
Creating Columns, changing Column Width
Inserting a Column Break/Vertical Lines
|
Using Templates and Wizards
Using a Word Template
Creating your own Template
Using a Wizard
|
Word and the Web
Inserting a Hyperlink to a Web Page
Sending a Document as an E-mail Message
Saving or viewing as a Web Page
|
Outline
Mos Excel Expert 2013
This course is aimed at Expert-level candidates for Excel 2013 who will gain an advanced understanding of the Excel environment and the ability to guide others in the proper use of features in Excel 2013.
Candidates will be able to create, manage and distribute professional spreadsheets for a variety of specialised purposes and situations, and they will learn how to customise their Excel environment to meet needs and enhance productivity.
Course Details
Excel 2013 Expert Part One
(Exam 77-427)
|
Excel 2013 Expert Part Two
(Exam 77-428)
|
Manage & Share Workbooks
Manage workbook changes
- Track changes, manage comments, identify errors, troubleshoot with tracing, display all changes, retain all changes
|
Manage & Share Workbooks
Manage multiple workbooks
- Modify existing templates, merge multiple workbooks, manage versions of a workbook, copy styles from template to template, copy macros from workbook to workbook, link to external data
|
Apply Custom Formats & Layouts
Apply advanced conditional formatting and filtering
- Write custom conditional formats, use functions to format cells, create advanced filters, manage conditional formatting rules
Prepare a workbook for internationalisation and accessibility
- Modify tab order among workbook elements and objects, display data in multiple international formats, modify worksheets for use with accessibility tools, utilise international symbols, manage multiple options for +Body and +Heading fonts
|
Apply Custom Formats & Layouts
Apply custom data formats
- Create custom formats (Number, Time, Date), create custom accounting formats, use advanced Fill Series options
Apply custom styles & templates
- Create custom colour formats, create and modify cell styles, create and modify custom templates, create form fields
|
Create Advanced Formulas
Look up data with functions
- Use the LOOKUP function, use the VLOOKUP function, use the HLOOKUP function, use the TRANSPOSE function
Apply advanced date and time functions
- Use the NOW and TODAY functions, use functions to serialise dates and times
|
Create Advanced Formulas
Apply functions in formulas
- Use the IF function in conjunction with other functions, use AND/OR functions, use nested functions, use SUMIFS, AVERAGEIFS and COUNTIFS functions
Create scenarios
- Use the watch window, consolidate data, enable iterative calculations, use What-If analysis tools (including Goal Seek), use the Scenario Manager, use financial functions
|
Create Advanced Charts & Tables
Create advanced chart elements
- Add trendlines to charts, create dual axis charts, create custom chart templates, view chart animations
Create and manage PivotTables
- Create new PivotTables, modify field selections and options, create a slicer, group records, utilise calculated fields, format data, utilise PowerPivot, manage relationships
|
Create Advanced Charts & Tables
Create and manage Pivot Charts
- Create new Pivot Charts, manipulate options in existing Pivot Charts, apply styles to Pivot Charts
|
Candidate roles might include accountants, anyone working in the world of finance, data analysts, commercial bankers and others.
See Our Calendar.
Contact Details.
-
Pery Square Business College & Staff Agency.
Limerick, Ireland.
-
Telephone: +353 (0)61 3270125
Email: This email address is being protected from spambots. You need JavaScript enabled to view it.
- Call or Email to discuss the right course for you.
