Hero image

PDT10's Shop

I am a teacher of Computer Science with a focus on programming languages, web development, spreadsheets & databases, Adobe Photoshop & Flash and encryption. The primary focus of my shop is to showcase computing resources and assessment tracking tools to support classroom teachers. Additionally, I hope to pursue my personal interests such as History with topics including Papal History, Kings Queens and PM's, Crusaders, The Black Death, American/British History and 20th Century History.

I am a teacher of Computer Science with a focus on programming languages, web development, spreadsheets & databases, Adobe Photoshop & Flash and encryption. The primary focus of my shop is to showcase computing resources and assessment tracking tools to support classroom teachers. Additionally, I hope to pursue my personal interests such as History with topics including Papal History, Kings Queens and PM's, Crusaders, The Black Death, American/British History and 20th Century History.
Tracking Document Dashboard
pdt10pdt10

Tracking Document Dashboard

(0)
The tracking document is a macro-enabled excel workbook that allows you to add up to 35 students and track their progress through seven separate units of work. The dashboard feature of the workbook displays data graphically to give a clear indication of each students progress. Attached with the resource is an Overview document that shows each of the accessible worksheets.
Desktop Publishing - Magaizine Task
pdt10pdt10

Desktop Publishing - Magaizine Task

(0)
Computing - Desktop Publishing (DTP): Magazine Lesson Task AIM: Recreate the magazine cover as accurately as possible in publisher using your DTP skills Images can be taken from the internet All text and shapes must be made using publisher Students should make use of the master page, font styles/colour, shape tools, layering and alignment INCLUDE: 10-15 printed copies for students who struggle to see the board
Using MySQL in Microsoft Access
pdt10pdt10

Using MySQL in Microsoft Access

(0)
Using MySQL in Microsoft Access This resource includes two worksheets containing nine tasks, a template evidence document for the students to print-screen and explain the work they have done and an excel export of the YouthOrg Access Database. You will need to create a new Access document and import the spreadsheet data in order to use the resource. This is an engaging task that works well as both an independent activity and in small groups. To complete the worksheet tasks and update the evidence document can take between 2-3 lessons.
JavaScript ID Maker
pdt10pdt10

JavaScript ID Maker

(0)
JavaScript ID Maker This simple program will generate an alphanumeric string that can be used as a password generator, unit code or as a starter task for a Computing lesson. When you load the script you will be prompted to enter the number of characters you would like displayed. When you press enter the random ID is displayed on screen.
PowerPoint Quiz Using VBA
pdt10pdt10

PowerPoint Quiz Using VBA

(0)
Create an Interactive Quiz using PowerPoint and VBA Included in this download is … Full Lesson Plan Starter Activity Worksheet VBA_Quiz_START which should be made available to students at the beginning of the lesson VBA_Quiz_SlideShow_MACRO is the lesson presentation detailing each step of the Quiz VBA_Quiz_Code_WS is a support worksheet for students who are struggling with the task (full code) VBA_Quiz_FINAL is a completed VBA Quiz with a name request, 3 questions and a results page … Fun and Informative Lesson … I have delivered this lesson multiple times and it is always a popular activity, with students able to choose their own quiz topic and design their own questions. Most of the time this activity has stretched over 2 lessons, allowing students who struggle with coding to catch-up, whilst the more gifted students are able to develop and enhance their quiz.
Assessment Tracking Workbook
pdt10pdt10

Assessment Tracking Workbook

(0)
Worksheet Images Store Tab - Here you enter student data - max: 92 students / 4 classes Data Tab - Here you can edit the Grade Boundaries Dashboard Tab 1 - You can view results filtered by class Dashboard Tab 2 - You can view results filtered by student - single or multiple selection Dashboard Tab 3 - You can view results filtered by grade PLC Tab - You can select by class, then by student to view a complete overview with graph Using the Resource I primarily use this resource for assessments - entering student details, the assessment title and the students grade for each question in the STORE TAB - from here everything is automated! I often use this during department meetings, annual reviews, when writing reports and at parents evenings. Additionally, it is very useful to have data and graphs for each unit assessment to keep students and parents up-to-date with either a printed Personal Learning Checklist (PLC) or digitally via email.
Parents Evening - Student Grade Visualisation
pdt10pdt10

Parents Evening - Student Grade Visualisation

(0)
Parents Evening - Student Grade Visualisation This spreadsheet has two worksheets - Data and Display. The Data worksheet is where you can add students first and last names - in adherence with GDPR these names are edited with a formula to display the first name and initial only - as well as the effort, behaviour and homework scores for each student. The scores are in the 1-4 format where 1 is the highest grade. In addition the students current and target grade are entered to allow the spreadsheet to calculate how much progress they have made towards their target. The Display spreadsheet has a drop-down box with all of the students names. Here you can select a student to view the data as well as a graphical display of their progress. This has been a valuable resource during parents evenings and for 1:1 discussions with students.
Creating a VBA User Form
pdt10pdt10

Creating a VBA User Form

(0)
Learning Objectives: Understand how to control Excel using VBA Be able to update and change the VBA code Test how effective your completed user form is Resource Image Links: TES Resources - VBA Lesson: Excel Spreadsheet TES Resources - VBA Lesson: User Form Interface TES Resources - VBA Lesson: VBA Code How to Use this Resource: Resource Description Differentiation Opportunities: The level of difficulty (1-9) for completing the various tasks are provided in the link below: TES Resources - VBA Lesson: Differentiation
Online Image Editing - Lesson 4
pdt10pdt10

Online Image Editing - Lesson 4

(0)
OIE - Lesson 4: Using the DRAWING tool to create an Olympic Rings Poster Lesson 4 of 6 - Students will use the drawing tool as well as skills practiced in previous lessons to create an Olympic Rings poster. Emphasis should be placed on managing files & folders as well as using consistent naming procedures - in all examples provided, snake-case is used. Peer discussion and support via email from both peer & teacher is encouraged to allow students to continue with their work outside of the classroom, further developing the images.
Online Image Editing - Lesson 3
pdt10pdt10

Online Image Editing - Lesson 3

(0)
OIE - Lesson 3: Using LAYERS, CUTOUT and ADJUSTMENTS to create a contrasting image Lesson 3 of 6 - Students will use images sourced from the web (or their own if available); manipulating the image using layers, cutouts and adjustments to create a contrasting image. In this instance a contrasting image involves joining a black & white version of an image with a color element of the image shown - similar to the masking feature in Photoshop. Emphasis should be placed on managing files & folders as well as using consistent naming procedures - in all examples provided, snake-case is used. Peer discussion and support via email from both peer & teacher is encouraged to allow students to continue with their work outside of the classroom, further developing the images.
Online Image Editing - Lesson 1
pdt10pdt10

Online Image Editing - Lesson 1

(0)
OIE - Lesson 1: Using CUTOUTS and ADJUSTMENTS to create a COMPOSITE IMAGE Lesson 1 of 6 - Students will aim to create a simple composite image and then use cutouts and adjustments to manipulate the image. Emphasis should be placed on managing files & folders as well as using consistent naming procedures - in all examples provided, snake-case is used. Peer discussion and support via email from both peer & teacher is encouraged to allow students to continue with their work outside of the classroom, further developing the images.
Online Image Editing - Lesson 2
pdt10pdt10

Online Image Editing - Lesson 2

(0)
OIE - Lesson 2: Applying TEXT EDITING to create a BANNER Lesson 2 of 6 - Students will make use of different software to create a digital banner for a social media profile. Emphasis should be placed on managing files & folders as well as using consistent naming procedures - in all examples provided, snake-case is used. Peer discussion and support via email from both peer & teacher is encouraged to allow students to continue with their work outside of the classroom, further developing the images.
Online Image Editing - Project
pdt10pdt10

Online Image Editing - Project

(0)
OIE - Unit Overview Assessment Criteria - Provides an overview of the 6 lesson unit, with brief details of lessons 1-4 (available on my TES Shop) and a full breakdown of the lesson 5 & 6 Infographic project task. What is an Infographic? Additionally, I have included a detailed criteria interactive marksheet with a demonstration example. The marksheet covers all 6 lessons of the OIE unit.
My Passwords - Log Book
pdt10pdt10

My Passwords - Log Book

(0)
Passwords … It is so important to regularly update and change your password, and schools now require you to include uppercase, lowercase and symbols into a password that can be as long as 30 characters! These are easy to forget and you need to place to store them. Time Consuming … Remembering multiple complex passwords is very difficult - especially if you are using unique alphanumeric strings. What takes the most time is creating the password - not wanting it to be too common or easy to guess but not so difficult that it is impossible to remember. The My Passwords Log Book has a Random Password Generator which will create and record the string, saving you time. All the Applications … There are so many applications that you use as a teacher - the number of times I have not only forgotten the password but also the name of the application is almost embarrassing! With My Passwords Log Book you can store the application name, include a hyperlink taking you directly to the site as well the required password.
Online Image Editing Bundle
pdt10pdt10

Online Image Editing Bundle

5 Resources
An 6 lesson introduction to Online Image Editing using the Pixlr X web application. Pixlr X is a free service with no login requirements, a good range of editing functionality for beginners and easy to use download options. In addition to the OIE features the software provides students with experience in managing files and folders, accessing downloads and suitable file naming procedures – all file naming throughout the OIE Bundle examples follows ‘snake-case’ syntax, providing an opportunity to review the two main naming methodologies (snake-case and camel-case). The course is designed for beginners with extension opportunities for more experienced users. * (UK) Year 7 & 8 * (US) Grade 6, 7 & 8 Included is an interactive marksheet, designed to record the progress of an individual student through the unit. Features include date-picker, student level identifers and Internal Assessment Recording. A full demonstration example is provided.