# Tech4all's Shop

Average Rating3.63
(based on 5 reviews)

6k+Views

(0)

(0)

(0)

#### Introduction to Excel

(1)
Learn the basics of Excel with this innovative resource. Complete lessons are provided – no teacher prep needed. It is great for beginners or revision at the beginning of a course. The learner works in editable workbooks that teach and provide comprehensive activities the same time - an efficient way to learn. My students learn a lot quickly and say that they like the self-paced activities and feel quite competent afterwards. This resource provides lessons for both classroom teachers or self-learners. All of these resources can be digital for a paper free classroom. 90 pages A PDF slideshow instructable – made with PowerPoint - a reference that explains The Excel screen and ribbons What a workbook and worksheets are The Excel screen layout Cells in a worksheet Status bar and views Backstage view Workbook 1 - Formatting 1: Teaches and provides comprehensive learner activities (editable Excel document) About Excel, ribbons and saving Mouse pointer, formatting text, views Cell references, selecting and moving around in cells Adjusting and merging cells Adding borders and cell styles Workbook 2 - Formatting 2: Teaches and provides comprehensive learner activities (editable Excel document) Text wrapping and formatting cells Copy, pasting, moving and formatting cells Inserting and deleting columns Autofill and flash fill Number formatting Sorting data Adding pictures Tables Entering data Workbook 3 - Calculating: Teaches and provides comprehensive learner activities (editable Excel document) Formula bar View and create formulas Arithmetic calculations, autosum, averages, percentages Autofill, using formulas Completing calculations for multiple spreadsheet tables Workbook 4 - Charts: Teaches and provides comprehensive learner activities (editable Excel document) Types of charts Parts of a chart Resizing, moving, properties, copying, live update Creating column, bar, line, area and pie charts Shape effects, create sparklines and revision Solution for all Workbook activities Excel Basic Reference Sheets Pages of quick reference for all the main need to know actions for Excel – a great help and invaluable reference for learners. Copyright Tech 4 All®. All rights reserved by author. This product is to be used by the original downloader only. Copying for more than one teacher, classroom, department, school, or educational provider is prohibited. It may not be edited, sold or distributed as paper or digital format. In digital format it may only be available for your classroom – do not post digital files where there is public access. It is for use for one teacher for one class only. If you wish to use it again you must buy it again or purchase multiple copies. If your colleagues would like to use this resource please ask them to download their own copy. Tech 4 All® is an independent publisher and is neither affiliated with, nor authorized, sponsored, or approved by, Microsoft Corporation.

(0)

#### Excel Essentials

(0)
Excel Essentials covers the core skills that need to be learned to become a functional user of Excel. This unit also covers the skills that are required for competency in the MOS certification exam. There are instructional slideshows, a student workbook, editable Excel workbooks, puzzles and a quiz to consolidate proficiency. Excel Essentials is a complete unit with solutions for all activities – no teacher prep needed. It is suitable for teacher directed learning or self-paced or remote learning. All of these resources are digital for a paper free classroom. The teacher is able to print as well if necessary. Time frame (5 to 8 weeks depending on learner skill level). Pre-requisites Competent computer skills, experience with Microsoft applications would be desirable. No previous experience with Excel is required but would be helpful. Competent reading skills with ability to follow instructions is required for this unit. Student needs digital access to files and Internet for videos and quiz. The learner needs Microsoft Excel and PowerPoint for digital completion of puzzles. 7 slideshows – made with PowerPoint – references with clear graphic explanations and that cover all the Excel skills required – some slides link to videos for extra knowhow. Excel Basics Formatting Managing Worksheets File Tab Managing Data Calculations Charts and Illustrations Student Workbook - can be printed or viewed digitally - provides all the learner activities which cover: Ribbons, backstage view, formatting cells and data, saving, entering data, borders, pasting data, autofill, Sheet tabs, locating data, page setup, headers &amp; footers, importing data, comments, notes Hyperlinks, properties, issues, exporting, printing, Excel tables, sorting data, sparklines Conditional Formatting, calculations, formulas, function builder, quick analysis tool, Text strings formulas, IF function, relative, absolute and mixed references, naming ranges, Calculations in tables, creating and formatting charts, alt text, pictures 3 Editable Excel Workbooks with solutions – workbooks and solutions are editable The learner completes the Excel activities in the 3 workbooks that are set up with activities and ready to go. Puzzles and Quiz with solutions – both PDF for printing and digital versions in PowerPoint are supplied. Excel Screen Label Excel Functions Puzzle Excel Commands Quiz Excel Icon Matchups Quiz

(0)

(0)

#### File Management

(0)
This File Management resource is a complete learning and hands on activities unit with 2 puzzles and a Google Quiz assessment. There are 2 versions Windows 10 and Windows 11. (107 pages) The unit (3 – 4 weeks: depends on student skill level) covers all the essential skills for managing folders and files in Windows 10 or Windows 11. The unit is completely digital and is offered on 2 platforms –PowerPoint and Google Slides – you choose which one suits your students’ needs best. A solution for all activities is provided. This resource can be completely paper free. Pre-Requisites: Reasonable computer skills, experience with navigating around a computer, switching screens and internet savvy would be desirable. Competent reading skills with ability to follow instructions is required for this unit. The student needs access to Microsoft Word, PowerPoint, Windows 10 File Explorer and the internet. Student Activities covered in the unit – (Student answers questions or uses drag and drop and performs folder and file activities in their own file explorer on their computer. They create several files using Word and PowerPoint.) What are Folders and Files? What is file management? Windows 10 folders and devices Working with File explorer – screen, views, libraries, navigating, File types, file icons, Folders and files – opening, creating, renaming, deleting Recycle Bin Folder and file naming conventions Copying, cutting, pasting folders and files Selecting files Searching for folders or files Shortcuts Folder tree hierarchies, file paths Folder and file properties Compressing folders and files Backing up Solution for Activities 2 Puzzles with solutions Google Quiz Copyright Tech 4 All. All rights reserved by author. This product is to be used by the original downloader only. Copying for more than one teacher, classroom, department, school, or educational provider is prohibited. It is for use for one teacher for one class only. If you wish to use it again you must buy it again or purchase multiple copies. Tech 4 All is an independent publisher and is neither affiliated with, nor authorized, sponsored, or approved by, Microsoft Corporation.

#### Python Turtle

(0)
Python Turtle is a great way to introduce students to coding. The language is easy to learn with most commands having easy to understand English wording. The unit level is suitable for Grade 6 to 10. (140 pages) This is a comprehensive unit (5 – 8 weeks) to teach learners how to use Python Turtle using easy and accessible online software. There is an instructional teacher slideshow to explain how to use Python Turtle with introductory activities, a comprehensive student activity booklet with graded tasks, a sample student portfolio and 3 digital coding puzzles and all activities and puzzles have solutions. Skills learnt from this unit would enable the learner to start gaining programming knowhow and lay the base for future coding with Python. It is also suitable for students who have some experience with early coding and need to consolidate or revise their skills. No teacher prep needed. Teacher directed learning would be best, but this unit is suitable for self-paced or remote learning. The Activity booklet can be printed or viewed digitally. The unit can be completely paperless. Pre-Requisites: Competent computer and internet skills would be desirable. Good reading skills with ability to follow instructions is required for this unit. The internet is needed for using the online Python Turtle Sandbox, access to digital files and MS PowerPoint is needed for the portfolio and puzzles. There are Google Slides versions of all puzzles and the portfolio for students who use Chromebooks. Python Turtle Slideshow with introductory activities Origins? What is it? Where to Start? How to access and use the online software Typing code and errors Saving your online code Commands for movement and turning Commands for circles, dots Set pen width and color How to define color Draw and fill with color – also background Stamping, positioning the turtle adding text If, while and color loops Nested loops Defining functions Using random numbers Troubleshooting Python Turtle Student Activity Booklet Overview of using the online software Making a portfolio of code and designs Start coding with movement and turning commands Draw polygons, straight-line shapes, circles, dots – fill shapes and background with color Turtle shape &amp; stamp – hide &amp; show turtle Using loops and nested loops Defining functions, random numbers Create pictures, change existing code Challenges

(0)

#### Copy Cut & Paste in Microsoft Word

(0)
An ideal starter lesson for learners who are novices with Word or who need revision of Word at the start of a semester. Students may know how to copy and paste but do they know all the available options? Learners work within editable Word documents to practise these skills. There is a handout information sheet which covers all of the skills that are needed - this can be digital or printed. Check the learner skills with a quiz in Word. This activity will help increase the speed and accuracy of mouse skills and Word commands knowledge. **A Copy Cut &amp; Paste information sheet ** that explains the 4 methods of copying and pasting How to view and clear the clipboard Variety of pasting methods Copy, Cut &amp; Paste Activities which cover Working in an editable word document Practicing with the clipboard, right click, keyboard shortcuts and Ctrl drag methods to copy, cut and paste. Clearing the clipboard Pasting using different options Quiz – multiple choice about copying, cutting and pasting Solution for activities and quiz Copyright Tech 4 All. All rights reserved by author. This product is to be used by the original downloader only. Copying for more than one teacher, classroom, department, school, or educational provider is prohibited. It is for use for one teacher for one class only. If you wish to use it again you must buy it again or purchase multiple copies. Tech 4 All is an independent publisher and is neither affiliated with, nor authorized, sponsored, or approved by, Microsoft Corporation.

#### Microsoft Publisher

(0)

3 Resources
Bibliographies with slideshow instructions and 3 activities for bibliographies, footnotes and endnotes. MailMerge with 3 slideshow instructions and 3 comprehensive activities for letters, envelopes and labels. Table of Contents with slideshow and comprehensive activity. (141 pages)

#### The Ribbons in PowerPoint

(0)
An ideal starter lesson with a difference for learners who are new to PowerPoint or who need revision of PowerPoint at the start of a semester. A great hands-on start in this innovative 'ready to go editable PowerPoints’ about learning how to use the ribbon commands to help the learner increase skills to create effective presentations. All activities are digital for a paperfree classroom. (142 pages) Pre-Requisites: Previous MS office experience like Word skills, familiarity with text skills, good mouse skills and the ability to copy, cut and paste. A complete lesson/s to remind or teach learners about the PowerPoint Screen and using the most helpful commands in PowerPoint. No teacher prep necessary. Great for teacher directed or self-paced learning. Learner needs digital access to PowerPoint files and the internet. Other activities can be printed. A PDF slideshow that explains the what PowerPoint is how it looks PowerPoint screen how to add items to the slides ribbon features and groups dialog box launchers copying, adding and reordering slides commands shortcuts quick access toolbar show and hide ribbon or ruler status bar backstage view views in PowerPoint

(0)

#### An introduction to Digital Photography

(0)
A comprehensive introductory unit (6 – 8 weeks) to teach digital photography entry level basics. The unit is designed to create familiarity with photography terminology, understand file formats, take and edit photos for clarity and effect. Student photos are showcased in presentations. There are slideshows, student booklet, provided photos, assignment activities, a quiz and solutions. Online software that is available to everyone is used – no Photoshop, though this could be incorporated if the teacher thinks it’s helpful. No teacher prep necessary. Teacher directed is best but suitable for self-paced learning. Learner needs digital access to Word, photo and video files and the internet. Activity booklet can be printed. Pre-Requisites: Previous MS office experience and competency with Word and PowerPoint skills. Competent reading skills with ability to follow instructions is required for this unit. A digital camera to take photos or could be phone. Access to internet for research and digital access for student required files. Digital Photography Introduction Slideshow that includes Brief history of film cameras How digital cameras work Popularity of digital cameras Advantages/disadvantages of digital cameras and smart phones Camera types and capabilities Memory cards, batteries, camera uses Photography terminology Photographic tips &amp; techniques EXIF &amp; ITPC Video Presentation or slideshow that explains Digital images basics – pixels, measurement, viewing photo files, opening &amp; inserting files, photo file extensions , file formats and their uses, editing photos, vector, raster, scaling, resizing, printing &amp; compressing. Student Activity Booklet (2 versions – print and digital version) Digital cameras vs phone cameras Camera uses Camera settings eg. Flash, HDR Internet research activities Photo tools in Microsoft office – use them to upskill in image management Camera and photography terminology eg macro, aperture, ISO, white balance Photo sizes and ratio Metadata, geotagging, EXIF – search for photo attributes using EXIF info Image file formats – jpg, png, tiff etc Resizing and compressing photos Uploading photos from one device to another Editing photos with online software for improvement – using tools to edit vibrance, saturation, contrast, clone etc How to take a good photo Take many photos of various genres Image terminology – rule of thirds, depth of field, bokeh, etc Photography conditions – night, cloudy, angle etc View professional photography Edit photos with online software for creative effects – such as posterize, text, vignette, overlays, clone out unwanted objects, create transparent background, repair photos, add art effects, create animation

#### Shapes in Microsoft Word

(0)
A complete lesson to teach learners about adding and formatting shapes for to their Word documents. No teacher prep necessary. Can be a paperless lesson. Great for self-paced or teacher directed learning. Comprehensive instructions and activities. (Resource 40 pages) **A PDF slideshow instructable ** that explains How to insert shapes Altering shapes Types of shapes Shape fills Shape outlines Shape effects Aligning and grouping shapes Editing shapes The drawing canvas Shapes Activities that cover Adding multiple types of shapes Filling and outlining shapes Creating drawings with shapes Aligning and ordering shapes Filling shapes with pictures Editing shapes The drawing canvas Solution N/A Copyright Tech 4 All. This product is to be used by the original downloader only. Copying for more than one teacher, classroom, department, school, or educational provider is prohibited. It may not be edited, sold or distributed in any form. It is for use for one teacher for one class only. Tech 4 All is an independent publisher and is neither affiliated with, nor authorized, sponsored, or approved by, Microsoft Corporation.

(0)

#### Mail Merge for Microsoft Word

(0)
Mail Merge can help you produce multiple documents for businesses and personal use very easily – learn how this process works for letters, envelopes and labels. This resource is a detailed complete lesson or lessons with no teacher prep necessary. It can be used for a paperless classroom. The 3 slideshow instructables and the 3 activities documents which are bundled together can be digital or printed. They are ideal for either teacher directed or self-paced learning for anyone who needs to develop Word skills. (80 pages) A PDF slideshow instructable for Mail Merge – made with PowerPoint this is an instructional reference for how to work with Mail Merge that explains What mail merge is The 3 main steps How to prepare for a mail merge How to create the data source How to create the main document How to perform the merge Mail Merge Activities – learner creates letters using mail merge with clearly identified steps using an activity instructions document which can be digital or a printed task document. A PDF slideshow instructable for Envelopes – made with PowerPoint this is an instructional reference for how to work with Envelopes that explains How to address a single envelope Steps to set up the printer and print the envelope How to use mail merge to print multiple envelopes with different addresses Envelope Activities – learner creates envelopes using both the single option and mail merge with clearly identified steps using an activity instructions document which can be digital or a printed task document. A PDF slideshow instructable for Labels – made with PowerPoint this is an instructional reference for how to work with Labels that explains What labels are used for Templates for labels – how to use How to use mail merge to print multiple labels with different data Label Activities – learner creates labels using both Word templates and mail merge with clearly identified steps using an activity instructions document which can be digital or a printed task document. Copyright Tech 4 All®. All rights reserved by author. This product is to be used by the original downloader only. Tech 4 All® is an independent publisher and is neither affiliated with, nor authorized, sponsored, or approved by, Microsoft Corporation.

#### Make the BEST passwords ever that you can easily remember

(0)
Clear instructions on how to make secure passwords with practice about how to check the password strength. Can be used for a paperless classroom. The slideshow instructable and the activities document can be digital or printed. Ideal for either teacher directed or self-paced learning for anyone who needs to wise up on internet safety. (10 pages) A PDF slideshow instructable – a comprehensive reference for creating charts that explains • Why you need a strong password • What is required for safety in a password? • How to check the strength of your passwords • Make a very secure password that is easy to remember • How your passwords get stolen • How to run an on-screen keyboard Copyright Tech 4 All®. All rights reserved by author. This product is to be used by the original downloader only. Copying for more than one teacher, classroom, department, school, or educational provider is prohibited. It may not be edited, sold or distributed as paper or digital format. In digital format it may only be available for your classroom – do not post digital files where there is public access. Tech 4 All® is an independent publisher and is neither affiliated with, nor authorized, sponsored, or approved by, Microsoft Corporation.

#### Watermarks in Microsoft Word

(0)
A complete lesson to teach learners about adding watermarks to their Word documents. Suitable for any learner who needs instruction and practice with adding Watermarks to Word documents. The lesson can be paperless or can be printed. Suitable for teacher directed or self paced learning. (Resource 10 pages) No teacher prep necessary. **A PDF instructable ** that explains What a watermark is Samples of watermarks Why they are used Different types of watermarks How to add them How to edit them How to remove them Which views allow watermarks to be seen A Watermarks Activity - learner needs to open an editable Word document that covers Adding a text watermark Re-coloring a watermark Adding a picture as a watermark Washout and full color Solution for watermark activities Tech 4 All is an independent publisher and is neither affiliated with, nor authorized, sponsored, or approved by, Microsoft Corporation. This resource may not be sold in any form.

#### Selecting Text in Microsoft Word

(0)
Do you know the easiest ways to select text? This is a mini lesson with no teacher prep necessary. The slideshow instructable can be digital or printed. Great for either teacher directed or self-paced learning for anyone who needs to develop mouse skills for Word. I have found that many students although using Word regularly, are unsure of different ways to select text. (12 pages) A PDF slideshow instructable with learner activities that explains how to select a word a group of words a line of text a number of lines of text a sentence text that is not next to each other a paragraph vertical text a whole document Copyright Tech 4 All®. All rights reserved by author. This product is to be used by the original downloader only. It is for use for one teacher for one class only. Tech 4 All® is an independent publisher and is neither affiliated with, nor authorized, sponsored, or approved by, Microsoft Corporation.