National Workshop on ICT for Productivity and Workplace Empowerment (IPWE 2015) University of Ibadan, Nigeria. 21-25 April, 2015
Introduction The National Workshop on ICT for Productivity and Workplace Empowerment (IPWE 2015) aims to ensure that people have the updated knowledge and skills to utilise the latest computer and internet technologies for personal and corporate benefits. The 21st century generation has witnessed rapid increase in the adoption of technology by organizations and individuals in order to perform daily duties in an increasingly digitized manner. with expert step-by-step guidance by carefully selected seasoned instructors, participants will learn exactly what it takes to “Optimize the potentials of computers and internet in a rapidly changing world of technological innovations” Target Audience: Business professionals, Secretaries, Educators, admin personnel and individuals who want to update their IT knowledge. (participants should have prior fundamental knowledge of computer applications & operations).
COURSE DETAILS
The workshop is in two phases. Phase 1 ( intermediate modules) is meant for those who have prior basic skills of computer operations while phase Phase 2(advanced modules) is meant for those who already have the intermediate skills and would want to improve to advanced stage. Participants can register for either or both modules, depending on their current IT literacy level.
1) Intermediate Modules (April 21-23 2015) a) Intermediate PowerPoint presentation skills, working with the outline tab, Speaker Notes, slide format & layout; print slides and handouts, move, duplicate and sort slides; set Slide Transitions, run and navigate Slide Show. creating charts & tables; adding special effects, editing presentation masters, notes masters, handout masters and saving a Custom Template.
b) Intermediate Excel store, organize and analyze large data sets; create basic formulas and functions, absolute references, ranges; Advanced chart formatting of Gridlines, Axis, Secondary Axis, Trendline, and user defined Charts; Worksheet & workbook Protection
c) Intermediate Word Processing Advanced document formatting using Ms Word; Mail Merge; using AutoFormat, AutoCorrect, AutoText, Using Find and Replace, and Thesaurus. automating Table of Contents, Bookmarks, footnotes & endnotes
d) Intermediate Social Media & Web Use Facebook and Twitter to create and maintain an attractive personal and company profile, build your network professionally; Showcase your products and services on Facebook & Twitter; sharing photos, news and comments; Attracting traffic to your social media profiles; creating and joining groups; targeting who to follow, building followers; handling complaints and criticism. Understanding who to connect to, and how to avoid problems. Concepts of blogging using Bloggger. Creating personal and corporate blog pages; Maintaining your blog pages, attracting traffic to your blog, measuring your blog traffic;
2) Advanced Modules (April 23-25 2015) a) Advanced PowerPoint set up slides with Special Effects, Animation, Sound and Video. Presenting to a wider audience, Action Buttons, jumping to another Presentation. working with secondary screen, editing and importing charts; creating custom charts, using organization charts and diagrams, exporting outlines and presentation slides
b) Advanced Word Processing create Master Documents; Adding Footnotes, Endnotes, and Citations; Managing Sources; Inserting a Bibliography; using Outline view, Diagrams and Hyperlinks; Collaborative editing, Adding & reviewing Comments, Tracking & reviewing Changes, macros and Macro Buttons
c) Advanced Excel Financial Functions, IF, AND, OR Logic Functions, VLOOKUP, HLOOKUP, and ISERROR. Scenarios, Goal Seek, Data Tables and Custom Views; Comments; Formula Auditing; Edit Macro Commands using the VBA window, Relative & Absolute References; Macro shortcut-Keys, macro buttons
d) Advanced Social Media & Web building professional & personal and corporate profiles on Linkedin; Designing, hosting and maintaining complete website in minutes using drag and drop systems; Getting targeted traffic to your web pages; Integrating Facebook, Linkedin and Twitter in web pages; Internet advertising & search engine optimization; Google analytics; Monitoring blog and website traffic; Peer documents hosting and editing using Google Docs; optimizing Google search results using boolean query