Hero image

PS Training Services' Shop

Average Rating4.29
(based on 10 reviews)

Welcome to the PS Training Services resource shop. There are a mixture of English Language, English Literature and Mathematics resources in this shop. These resources have been developed throughout my teaching career, which has included: * Secondary School teaching (English Language, Literature, Mathematics) in the UK and New Zealand * Private Tutor for 4+ years (ages 8 - adult) * Adult Education Teacher for 5+ years A variety of resources are available, including paper based and digital.

109Uploads

31k+Views

4k+Downloads

Welcome to the PS Training Services resource shop. There are a mixture of English Language, English Literature and Mathematics resources in this shop. These resources have been developed throughout my teaching career, which has included: * Secondary School teaching (English Language, Literature, Mathematics) in the UK and New Zealand * Private Tutor for 4+ years (ages 8 - adult) * Adult Education Teacher for 5+ years A variety of resources are available, including paper based and digital.
Functional Skills ICT Self Assessment
pstrainingservicespstrainingservices

Functional Skills ICT Self Assessment

(0)
Level 1 FS ICT - quick self assessment sheet Useful for teaching multi level groups to get a quick idea of common strengths and weaknesses Skills matched to the L1 FS ICT Curriculum Could also be used at KS2/KS3 for new or supply teachers to determine what a class has already covered or developed competency in.
Merging Cells in Excel
pstrainingservicespstrainingservices

Merging Cells in Excel

(0)
Simple PDF demonstrating how to merge cells in Microsoft Excel. Designed for low ICT literacy adult learners completing Functional Skills ICT at Level 1 and Level 2
Gridlines in Excel
pstrainingservicespstrainingservices

Gridlines in Excel

(0)
Simple PDF demonstrating how to add gridlines to a Microsoft Excel sheet. Developed for low ICT literacy adult learners completing Functional Skills ICT qualifications at L1 and L2.
IF Statements and Absolute Cell References
pstrainingservicespstrainingservices

IF Statements and Absolute Cell References

(0)
PowerPoint resource to cover IF statements and Absolute Cell references. These two are often assessed in combination by the Pearsons ICT Functional Skills (L2) assessments and combining them within one set of training seemed like a good idea. The PowerPoint breaks down the process of writing an IF statement, including a refresher on brackets, and then incorporates an absolute cell reference to use at the end . Encourage learners to create their own version of the Excel sheet displayed on the screen and to type in the functions to see how they work. Uses colour coding and builds up the IF statement one section at a time. Ideal for visual learners. Used to teach ICT Functional Skills to adults who have not yet mastered using Excel spreadsheets.
Excel Training Documents
pstrainingservicespstrainingservices

Excel Training Documents

(0)
These interactive spreadsheets have been designed to teach Excel from the basics upwards. They cover: +-/* functions cell references addition, subtraction, multiplication and division with two cells SUM function IF statements The read only one is designed for students to use, allowing them to enter information into the spreadsheet without overwriting the original copy. The spreadsheet is programmed to give notifications if the learners enter in the formulae and answers correctly. There is also an editable copy to allow you to make changes to the master sheet, if you wish to adapt it for further use. Designed for Functional Skills ICT (Level 1 and Level 2) and used to teach adults who were barely ICT literate, or novices at Microsoft excel. Makes use of colour coding to direct learners around the spreadsheet. Separate tabs for each function to allow for separating out individual skills for revision.
Writing a Formula in Excel
pstrainingservicespstrainingservices

Writing a Formula in Excel

(0)
This worksheet breaks down the process of writing a SUM formula in MS Excel. It explains the uses of brackets, colons, cell references and the equals sign within the formula. Colour coded and annotated, ideal for visual learners.
Cell References in Excel
pstrainingservicespstrainingservices

Cell References in Excel

(0)
Simple handout explaining how cell references work in MS Excel. Ideal for ICT beginners and people who are new to Microsoft Excel in particular. Designed for adult learners taking Functional Skills courses (ICT L1 and L2) Inspired by my father and his references to cell block H, this resource encourages people to think of the cells as prison cells, and the data inside them as prisoners. Excellent for visual learners.
Microsoft Excel - what do the buttons do?
pstrainingservicespstrainingservices

Microsoft Excel - what do the buttons do?

(0)
Resource which reviews the Microsoft Excel buttons (MS 2013 + ) Useful for Functional Skills L1 and L2, as well as introduction to Excel courses, ICT training and CPD up-skilling. Highlights the uses of the common 'HOME' tab buttons and explains how they can be used within Excel.