42 www.cityofglasgowcollege.ac.uk
WORKSHOP TITLE WORKSHOP CONTENT DURATION*
Introduction to
Web Development
• The Autotomy of a web page
- The main parts of a Page
- HTML Tags, Images, Links, Videos
• Styling your Page
- CSS
- Colours , Fonts, Shapes
- Style sheets, Common Frameworks
- Layouts /Grids
- Animation
• Interactivity
- JavaScript, JSON, Forms
• Common Components.
- Menus, Drops Downs, Accordions,
Tabs, Dialogs, Breadcrumbs,
Buttons, Calendars, Tables,
Toggles, Sliders
18 hours
NEW FOR YEAR 4
Inventory Valuation
• Principles of Inventory Valuation
• First in First Out Method of Valuation
• Average Cost Method of Valuation
6 hours
Microsoft Excel:
Introductory
• Creating a simple spreadsheet
• Cell ranges
• Changing column and row size
• Formatting text
• Adding borders to a spread sheet
• Formatting
• Copying/moving data
• Inserting rows/columns
• Changing column width/row height
• Hiding rows/columns
• Basic formulas and functions
6 hours
Microsoft Excel:
Intermediate
• Formulas and functions
• Copying formulas
• Headers and footers
• Freezing panes/splitting screen
• Sheet tabs
• Printing
• Linking workbooks
• Charts
• Conditional formatting
• Hyperlinks
• Sorting and filtering data
6 hours
Microsoft Excel: Advanced • Advanced charts
• Sharing and protecting workbooks
• Formulas and functions
• Pivot tables and charts
• Macros
• Command
• List and combo boxes
• Advanced printing
6 hours