1. Resources Home
  2. Elementary School
  3. Computing
  4. Data and information
  5. Interpreting and presenting data
Functional Skills ICT Level 2 Mail merge step by step booklet with activities.

Functional Skills ICT Level 2 Mail merge step by step booklet with activities.

The booklet will give a step by step visual and written guide on how to achieve the following objectives. Excel sheet included. Once you have completed the activities in this booklet you will be able to: 1. Launch the program needed. 2. Save a file with an appropriate file name in an appropriate location. 3. Create an excel spread sheet that will be used as the data source for your mail merged file. 4. Design a document that can be mail merged with the desired data content. 5. Complete the mail merge process with the assistance of the Microsoft Office Mail Merge Wizard. 6. Preview, complete the merge and print merged document.

By rkristina

Virtual Road Trip -Research, Planning & Budgeting Project

Virtual Road Trip -Research, Planning & Budgeting Project

***Want to bring more real-world learning to your classroom?**** This is the perfect project to get kids excited about learning how to research, plan and budget for a road trip. They will choose their destination, the accommodations and three attractions to visit - all while having to stay within their $1000 budget. This project includes math and language arts. Students will answer word problems and balance their budget. They will also write their opinion on attractions they have visited. The final part of the project is creating three virtual postcards from locations your students have "visited". I have provided a template in PPT and a link for the Google Classroom. All you have to do is print this out and the project is ready to go. Complete Student Examples Included for each step of the project. Project rubric included.

By sarah_mcnamara43

Data Representation - Images

Data Representation - Images

An activity that requires the students to have knowledge of how bit-map images are stored as binary and how colour depth increases the number of colours available for each pixel.

By markabatchelor6

More Advanced Challenges Python Bundle

More Advanced Challenges Python Bundle

A bundle of more advanced challenges (SUITABLE FOR A STUDENT’S NON-EXAM ASSESSMENT (NEA) RESOURCE BANK) which allow pupils to practice the following skills in Python: - tuples, - lists, - dictionaries - 2D arrays, - 2D lists, - 2D directories, -writing to and reading from an external text file - writing to and reading from an external .csv file - Using functions - Creating a GUI using the TKinter library An explanation and sample code included along with one possible answer for each challenge. These challenges do assume pupils are familiar with the basic skills such as input, output, If statements, using loops, strings and mathematical operators and using the random library. For challenges which cover these basics skills look at our other bundle (https://www.tes.com/teaching-resource/basic-challenges-python-bundle-11654010) For more lessons and complete units of work visit www.nicholawilkin.com.

By nwilkin

Microsoft Excel Video Guides - School Production

Microsoft Excel Video Guides - School Production

This resource contains 66 videos which take students through how to use the basics and more advanced features of MS Excel. An intro video showing what students will create can be found here. https://drive.google.com/file/d/0B_VegnuzyG2GOGR5NFdxZnFoRUk/view?usp=sharing This is a tried and tested unit which works with a broad range of abilities and usually takes about 8 hours to complete in full. Students need to create a school production spreadsheet which contains IF Statements, charts, vLookups, Macros, Conditional Formatting to name but a few. The pack contains a checklist which students can use to monitor their progress. The checklist also links to all of the videos.

By aglasgow

Dealing with external data in Python

Dealing with external data in Python

3 useful documents to help teach pupils (and teachers) about Tuples, Lists, Directories, writing to and reading from a text file and writing to and reading from a .csv file. SUITABLE FOR A STUDENT’S NON-EXAM ASSESSMENT (NEA) RESOURCE BANK. These handouts help pupils and teacher brush up on Python skills and work well as a handy reference guide. Each document contains an explanation and gives examples of code with easy to follow explanations. Includes a single page of challenges for students to complete which is ideal for photocopying and distributing to students to work through and practice their new skills. There is even a suggested answer to each of the challenges in case you get stuck. The challenges do assume the pupils have an understanding of the basics of Python including variables, If statements, For and While loops. For more lessons and complete units of work visit www.nicholawilkin.com.

By nwilkin

Python writing to and reading from  external CSV files

Python writing to and reading from external CSV files

A useful single document to help teach pupils (and teachers) about writing to and reading from a .csv file using Python. SUITABLE FOR A STUDENT’S NON-EXAM ASSESSMENT (NEA) RESOURCE BANK. This guide gives you an explanation about the theory, it then gives you examples of the code accompanied with a brief explanation about what each of these pieces of code do. There are a number of challenges to allow pupils to try out these skills and finally, screen shots of the possible answers are given. We have also included the original Python files to allow you to run the programs for the possible answers and see how the programs work. Includes 7 challenges. The challenges do assume the pupils have an understanding of the basics of Python including variables, if statements, for and while loops. For more lessons and complete units of work visit www.nicholawilkin.com.

By nwilkin

Getting to grips with arrays and complex data in Python

Getting to grips with arrays and complex data in Python

6 useful documents to help teach pupils (and teachers) about Tuples, Lists, Directories, String Manipulations, 1D Arrays and 2D Arrays, 2D Lists and 2D Directories in Python. It also includes writing to and reading from a text file and writing to and reading from a .csv file. SUITABLE FOR A STUDENT’S NON-EXAM ASSESSMENT (NEA) RESOURCE BANK. These handouts help pupils and teacher brush up on Python skills and work well as a handy reference guide. Each document contains an explanation and gives examples of code with easy to follow explanations. Includes a single page of challenges for students to complete which is ideal for photocopying and distributing to students to work through and practice their new skills. There is even a suggested answer to each of the challenges in case you get stuck. The challenges do assume the pupils have an understanding of the basics of Python including variables, If statements, For and While loops. For more lessons and complete units of work visit www.nicholawilkin.com.

By nwilkin

Data representation: Binary Trees

Data representation: Binary Trees

Teaching Computer Science This is a fantastic resource that students love! KS3 students love playing the game (iPad App optional) and seeing how computers actually store data. GCSE students get a view of how data is stored on computers, and A-level students learn about an essential part of computing. The resource comes with a presentation to run through with the students, and a free optional iPhone / iPad app (free with no adverts or tracking and small download size). You could get students to try the App in their own time at home, use iPads in school or just use the worksheets and Powerpoint resources to present a fantastic lesson. You pick which worksheets to run through, you have the tools for a great lesson and can pick the parts you want! Computer science lessons should be interesting, unexpected and fun. This lesson is all three. App link: https://itunes.apple.com/gb/app/20-questions/id1241872884?mt=8

By studeapps