Hero image

Kevin Savage - IT Resources

Average Rating3.36
(based on 16 reviews)

After 35 years of teaching in IT at all levels I have developed a learning method that works with my students. The process is top down. After a brief overview, students are introduced to a new application through a working exemplar that they can explore. Once they have a concept of what a program can do they then investigate its features. In this way they have a framework to hang the new learning on. All instruction is detailed step-by-step with full images of what they aim to produce.

After 35 years of teaching in IT at all levels I have developed a learning method that works with my students. The process is top down. After a brief overview, students are introduced to a new application through a working exemplar that they can explore. Once they have a concept of what a program can do they then investigate its features. In this way they have a framework to hang the new learning on. All instruction is detailed step-by-step with full images of what they aim to produce.
Adobe Illustrator
kevin_b_savagekevin_b_savage

Adobe Illustrator

(1)
Illustrator is a program that that enables you to create and to work with vector graphics. Suitable for Illustrator CS4, CS5, CS6 and CC on either a PC or a Mac. In these step-by-step activities we investigate: • the Illustrator workspace and basic operations • the difference between raster and vector graphics; common file types of each • fill and stroke • drawing lines and shapes; fill and stroke • selection and direct selection • using the pen, pencil, blob brush and paintbrush tools • the shape builder tool • tracing a line drawing and converting it to a vector graphic • Type tools: text, paragraph, path, and special effects • converting text to a vector shape.
Ofice 2016 Suite
kevin_b_savagekevin_b_savage

Ofice 2016 Suite

10 Resources
The complete solution to bringing the Office 2016 suite to your students. With 300+ pages of step-by-step activities in Word, Excel, Access, PowerPoint and Publisher, these activites go from the very basics right through to advanced concepts.
PowerPoint 2016
kevin_b_savagekevin_b_savage

PowerPoint 2016

(1)
A step-by-step, fully illustrated guide to using Microsoft PowerPoint 2016. Activities include: basic features of PowerPoint and terminology; the four different views in PowerPoint; inserting, rearranging and deleting slides; creating a presentation from scratch; inserting graphics such as clipart; using themes; animating content; the animation pane and effect options; autorun and setting timings for a presentation; transitions; print options; creating a master slide, backgrounds, placeholders, default animation and templates; adding audio and video; and creating a menu using hyperlinks, hotspots or action buttons. All files required for the activities are available as a free download through a link at the bottom of the title page.
Photoshop CC
kevin_b_savagekevin_b_savage

Photoshop CC

(0)
A step by step guide to using Adobe Photoshop CC 2015. Students learn about the Photoshop workspace, cropping, resizing and rotating images, retouching and repairing images, effects and filters, using the selection tools, image transformations, point, paragraph and path type, type transformations, masks and effects, and the use of layers. All files required for the activities are available as a free download through a link at the bottom of the title page.
Excel 2016 3
kevin_b_savagekevin_b_savage

Excel 2016 3

(1)
A step-by-step, fully illustrated guide to using Microsoft Excel 2016 (part 3 of 3 - advanced). Activities include: creating and using macros; assigning a macro to a button; macro security; using filters to investigate and sort large data sets; conditional formatting; worksheet protection; goal seeking; using pivot tables to investigate, display, and summarize information; modifying pivot tables by grouping, rearranging fields, displaying multiple fields, and varying data presentation; importing data to create a pivot table; making pivot charts; and drilling down into a pivot table. All files required for the activities are available as a free download through a link at the bottom of the title page.
Movie Maker
kevin_b_savagekevin_b_savage

Movie Maker

(0)
Windows Live Movie Maker is a free, simple to use, video-editing program from Microsoft. It comes with Windows 7 or can be downloaded as part of Windows Essentials 2012. In these activities we investigate: the Movie Maker interface and controls, loading and arranging video clips, making transitions between clips, splitting and trimming clips, adding background music, inserting titles and credits, including with overlays, loading still images, adding captions, using special effects, and publishing the movie in various formats. All video files required for the activities are available as a free download through a link at the bottom of the title page.
Access 2016 1
kevin_b_savagekevin_b_savage

Access 2016 1

(1)
A step-by-step, illustrated introduction to Microsoft Access 2016 (part 1 of 2 - basics). Activities include: using an Access database; navigating and searching in tables; datasheet and form views; Access terminology, including tables, records, fields and keys; design and layout views; improving the appearance of forms; inserting, deleting, and updating data; sorting data into order; queries and filters; creating a database and tables from scratch; and field type and setting keys. All files required for the activities are available as a free download through a link at the bottom of the title page.
Word 2016 1
kevin_b_savagekevin_b_savage

Word 2016 1

(0)
A step-by-step, fully illustrated guide to using Microsoft Word 2016 (part 1 of 3 - introductory). The activities include:the various parts of the Word screen and the Word 2016 interface; how to set text fonts, size, styles and color; cut, copy, paste and the clipboard viewer; paragraph settings, alignment and hanging indents; page layout and headers and footers; tools such as find and replace, spell check, synonym, and thesaurus; saving, sending as email, and creating PDFs; using columns; inserting and positioning graphics, with text wrapping; shading, lines, shapes, callouts and watermarks; bullets and numbering; using shortcut keys. All files required for the activities are available as a free download through a link at the bottom of the title page.
Fireworks CS6
kevin_b_savagekevin_b_savage

Fireworks CS6

(0)
A step by step guide to using Adobe Fireworks CS6. Students learn about the Fireworks interface, creating animated gifs, animating text, button graphics, buttons, navigation bars and pop-up menus. All files required for the activities are available as a free download through a link at the bottom of the title page.
SQL
kevin_b_savagekevin_b_savage

SQL

(1)
Structured Query Language (SQL) is the most widely used database query language in the world. In this investigation we look at: • the basic syntax of SQL • selecting columns and rows from a table • special operators: IN, BETWEEN, LIKE, etc. • updating an SQL database • subqueries and diagramming subqueries • processing of data in queries: arithmetic operators, functions, sorting, grouping • joining tables, including same-table joins • relational algebra terminology. This unit includes six classroom tested activities involving over 100 query questions (with answers) to reinforce the concepts learnt. The three databases used are avaialble as a free download on the title page.
Access 2013 2
kevin_b_savagekevin_b_savage

Access 2013 2

(0)
A step-by-step, illustrated guide to Microsoft Access 2013 (part 2 of 2). Activities include: developing a form in design view; importing data into tables; criteria searching; using calculations and functions in queries; developing output reports, including summary information; developing a multi-table database; inserting sub-forms into a main form; setting up a navigation pane as a user-friendly interface; and starting a database with the switchboard in place. All files required for the activities are available as a free download through a link at the bottom of the title page.
Word 2013 1
kevin_b_savagekevin_b_savage

Word 2013 1

(0)
A step-by-step, fully illustrated guide to using Microsoft Word 2013 (part 1 of 3 - introductory). The activities include:the various parts of the Word screen and the Word 2013 interface; how to set text fonts, size, styles and color; cut, copy, paste and the clipboard viewer; paragraph settings, alignment and hanging indents; page layout and headers and footers; tools such as find and replace, spell check, synonym, and thesaurus; saving, sending as email, and creating PDFs; using columns; inserting and positioning graphics, with text wrapping; shading, lines, shapes, callouts and watermarks; bullets and numbering; using shortcut keys. All files required for the activities are available as a free download through a link at the bottom of the title page.
Publisher 2013
kevin_b_savagekevin_b_savage

Publisher 2013

(0)
A step-by-step, fully illustrated guide to using Microsoft Publisher 2013. Activities include: templates in Publisher; the use of frames to position page elements; insert, resize, rotate and crop images; WordArt; grouping and ungrouping elements; shapes; using and linking text frames; columns; wrapping text around images; and drop caps. DTP theory is covered including typography, typefaces and style, layout and layout grids, element placement and positioning, and the use of color in documents. All files required for the activities are available as a free download through a link at the bottom of the title page.
Word 2013 2
kevin_b_savagekevin_b_savage

Word 2013 2

(0)
A step-by-step, fully illustrated guide to using Microsoft Word 2013 (part 2 of 3 - intermediate). The activities include: working with tables to display information; the Draw Table tool; formatting a table; using tabs to layout text and images; special tabs; form letters; mail merging; creating address labels; and creating, using and saving templates. All files required for the activities are available as a free download through a link at the bottom of the title page.
Access 2013 1
kevin_b_savagekevin_b_savage

Access 2013 1

(0)
A step-by-step, illustrated introduction to Microsoft Access 2013 (part 1 of 2 - basics). Activities include: using an Access database; navigating and searching in tables; datasheet and form views; Access terminology, including tables, records, fields and keys; design and layout views; improving the appearance of forms; inserting, deleting, and updating data; sorting data into order; queries and filters; creating a database and tables from scratch; and field type and setting keys. All files required for the activities are available as a free download through a link at the bottom of the title page.
DreamWeaver CS5
kevin_b_savagekevin_b_savage

DreamWeaver CS5

(2)
A step by step guide to using Adobe DreamWeaver CS5. Students learn about the Dreamweaver interface and layout, using HTML, entering and formatting text in a web page, links, using style sheets, inserting and positioning images, site creation, site navigation, publishing a site, tables and using templates.. All files required for the activities are available as a free download through a link in the Set Up Guide on page 52 of the activities.
Flash CS5
kevin_b_savagekevin_b_savage

Flash CS5

(0)
A step by step guide to using Adobe Flash CS5. Students learn about the Flash interface, the toolbar and panels, using layers, animating armature motion, frame by frame animation, incorporating sound, motion tweens, using symbols, 3D animation and motion paths, movie clips, ActionScript, interactive buttons, shape tweening, and masking. All files required for the activities are available as a free download through a link at the bottom of the title page.
Photoshop CS5
kevin_b_savagekevin_b_savage

Photoshop CS5

(0)
A step by step guide to using Adobe Photoshop CS5. Students learn about the Photoshop workspace, cropping, resizing and rotating images, retouching and repairing images, effects and filters, using the selection tools, image transformations, point, paragraph and path type, type transformations, masks and effects, and the use of layers. All files required for the activities are available as a free download through a link at the bottom of the title page.
Excel 2013 2
kevin_b_savagekevin_b_savage

Excel 2013 2

(0)
A step-by-step, fully illustrated guide to using Microsoft Excel 2013 (part 2 of 3 - intermediate). Activities include: functions of, sum, average, stdev, max, min, count, counta, today, now; using AutoSum; sorting text and numbers in ascending and descending order; sorting on multiple columns; challenge activity; the use of charts (graphs) in Excel to visually display data; absolute and relative addressing; the use of lookup tables; naming ranges; the if logical function; and practical application of absolute addressing and a lookup table. All files required for the activities are available as a free download through a link at the bottom of the title page.
PowerPoint 2013
kevin_b_savagekevin_b_savage

PowerPoint 2013

(0)
A step-by-step, fully illustrated guide to using Microsoft PowerPoint 2013. Activities include: basic features of PowerPoint and terminology; the four different views in PowerPoint; inserting, rearranging and deleting slides; creating a presentation from scratch; inserting graphics such as clipart; using themes; animating content; the animation pane and effect options; autorun and setting timings for a presentation; transitions; print options; creating a master slide, backgrounds, placeholders, default animation and templates; adding audio and video; and creating a menu using hyperlinks, hotspots or action buttons. All files required for the activities are available as a free download through a link at the bottom of the title page.