TechPro

  • Pre-requisites
    CreativeTech
  • Course duration
    1 Year
  • Weekly lessons
    80 minutes per week
  • Reports
    Every term
  • Recognition
    End of year certificate

Achieve More with Advanced Skills

On this year-long course your child will learn the full scope of 'Office' software tools. They will unlock the vast array of tools to enable them produce high-quality documents in a fraction of the time.

 

  •  Word Processing
  •  Spreadsheets
  •  Databases

About this module

Most Word users are aware of only a fraction of the features that are available. This course teaches your child to produce high calibre, professional documents in a fraction of the time that they would ordinarily use.

By the end of the term your child will have learnt:

  • To create templates, master documents and macros for repeated use
  • To set-up forms and use equations for mathematical and scientific documents
  • To export and import data to and from other applications
  • To co-author or collaborate with others using a single document
  • How to use the vast array of formatting, short cuts, dictation and translation tools

What your child will learn

  • Working with Text and Shortcuts
  • Layouts, Gridlines and Navigation
  • Formatting, Heading Styles, Table of Contents, Table of Authorities
  • Equations
  • Dictionaries
  • Importing & Exporting Data with Spreadsheets and Databases
  • Images, Linking and Embedding, Annotation, Watermarks
  • Collaboration, Co-authoring, Sky Drive
  • Forms
  • Mail Merge
  • Macros
  • Master Documents
  • One Note
  • Dictation
  • Translations

 

 

Course fee and payment plan

£148.50

(10 payments)

Total cost: £1485

 

Additional fees

Assessment Lesson (credited upon enrolment): £35.00 | Enrolment Fee: £55.00 | Catch up lesson: £35 per lesson

About this module

This course starts with the basics and progresses onto advanced concepts. Children undertaking this course will also cover mathematical principles.

By the end of the term your child will have learnt:

  • To use a wide variety of formulae (including conditional and nested statements)
  • To utilise in built functions such as Goal Seek and What-if Analysis
  • To write macros for repeated use
  • How to debug formulae which are incorrect
  • To produce forms, charts, and perform sorting and filtering of data
  • How to export and import data to and from other applications

What your child will learn

  • Worksheet and Workbook Orientation
  • Formatting
  • Short-cuts
  • Sorts and Filters
  • Data Types
  • Cell Referencing
  • Formulae and Functions
  • Conditional Statements and Conditional Nested Statements
  • Validations and Advanced Validations
  • Debugging Formulae
  • Conditional Formatting
  • Pivot Tables and Charts
  • Goal Seek
  • What-if-Analysis
  • Spark-lines, Graphs and Charts
  • Forms
  • Macros
  • Document Inspector
  • CSV Files
  • Information Rights Management

 

 

Course fee and payment plan

£148.50

(10 payments)

Total cost: £1485

 

Additional fees

Assessment Lesson (credited upon enrolment): £35.00 | Enrolment Fee: £55.00 | Catch up lesson: £35 per lesson

About this module

The Database course starts by teaching normalisation and how to create a relational database.

By the end of the term your child will have learnt:

  • How to remove redundant data and create a database schema
  • To create a data table structure with the appropriate relationships between them
  • To add validations and verifications to ensure that the data captured is what is required
  • To create input forms and printable reports
  • To create queries using Crosstabs and SQL (Sequential Query Language) for filtering, updating and appending data
  • To create Macros for repeated use
  • To work with databases over networks, setting up digital signatures

What your child will learn

  • Orientation
  • Prefixes
  • Data, Data Duplication, Redundancy and Normalisation
  • Primary and Secondary Keys
  • Data Types
  • Fields, Records and Files
  • Validations
  • Active X
  • Controls
  • Simple Queries, Complex Queries and Calculated Expressions, Updating and Appending
  • Reports
  • Advanced Normalisation
  • Forms and Sub-Forms
  • Crosstab Queries, SQL
  • Macros and VBA
  • Error Checking
  • Main Menu
  • Shared Network, Permissions, Digital Certificates, Code Sign

 

 

Course fee and payment plan

£148.50

(10 payments)

Total cost: £1485

 

Additional fees

Assessment Lesson (credited upon enrolment): £35.00 | Enrolment Fee: £55.00 | Catch up lesson: £35 per lesson

Virtual learning, real results

 

We’re redefining the way children learn by using the latest virtual tools. Our state-of-the-art virtual learning platform enables tutor-led home study through innovative business-grade tools.

Your child can log in from anywhere and attend scheduled lessons using virtual tools to communicate with their tutor and class friends.

Learn more

The FunTech Methodology

 

A learning
journey

 

We assess each child as an individual and recommend a tailored tech learning path that will enable them to unlock their full potential. 

Designed
to engage

 

Engagement and technology are at the core of our teaching strategies, with small class sizes guided by technology subject specialists.

Curriculum
is the key

 

We have a structured, project-based curriculum that’s continuously refined by our in-house development team to keep it ahead of the curve.

Virtual learning,
real results

 

Using a state-of-the-art virtual learning platform, we deliver tutor-led classes in real-time with a 1:8 tutor student ratio.

FAQs

What does a virtual class mean?

A virtual class is a scheduled interactive online lesson delivered by FunTech.

All our virtual software is Citrix driven and so extremely safe

How does the virtual class work?

All students receive a virtual orientation lesson before the start of their course.

For each lesson, your child will receive an email invitation containing a link allowing them to log onto our virtual classroom. We schedule a maximum of eight students who are predominately based in the UK, however, a few of our students have moved abroad due to parents work commitments and therefore log in from further afield.

The lessons themselves are the exact same as is delivered in our physical classroom. Through our virtual classroom environment, your child has the option to raise their hand, ask questions and also speak to the other students in their class (though we do have a mute all option '- just in case!)

FunTech teachers are able to pass control of their monitor to an individual student or share it amongst all the students. With permission, we can take control of a students' monitor to demonstrate concepts, share common mistakes or outstanding work as we would in a physical classroom.

All our virtual software is Citrix driven and so extremely safe

What do we need to join a virtual class?

Good internet connection, headphones with a microphone and a computer.

All our virtual software is Citrix driven and so extremely safe

See all FAQs


Pupil Tutor Ratio


Ofsted Registered


Structured Learning


Year's Experience