What topics are covered?
You will learn and extend your knowledge of spreadsheet tools, including functions and formulae, sorting and filtering, linking of datasheets and creating charts to present data appropriate to the intended audience.
Who is the course aimed at?
For those that need to develop Spreadsheet skills to create effective spreadsheets for work or leisure use.
What are the entry requirements?
No requirements, just an interest in IT.
What qualifications will I gain?
OCR ITQ Level 2 Spreadsheets and Charts.
Who is the awarding body?OCR (Oxford, Cambridge & RSA)
How will I learn?
Workbooks, practice assignments and 1:1 tuition and support as necessary.
What hours will I be in college?
Dates and times of classes are flexible; you need to attend four hours per week. Sessions run Wednesday & Friday. Attendance is flexible and can be arranged with your tutor on application.
How will I be assessed?
OCR set exam assignment
What can I do after this course?
OCR ITQ Level 2 Spreadsheets and Charts
Are there any additional costs?
No further costs. The exam fees are included in course cost as well as the workbook which will be a valuable reference after the course completion.
Where will I need to go on my first day?
Main Reception at the Bath Campus
What do I need to bring?
A note pad, pen and a memory stick.
What else do I need to know?To avoid disappointment, please make sure you apply for your chosen course early. Decisions regarding running or cancelling a course are made one week prior to the start of the course. If a course is cancelled, you will be informed and your course fees refunded in full. Please see Terms and Conditions of Enrolment.
The course will not run on bank holidays or during half term. Please check here for term dates.
Where can I find out more information?
For more information please contact Lorraine.firstname.lastname@example.org
How do I apply?Online: Click the "Apply" button and fill out an online application form.
By post: Download the Part-time Learning Agreement and send to Student Advice Centre, Bath College, Avon Street, Bath BA1 1UP.
In person: Visit the Student Advice Centre in either of our campuses.
Microsoft Excel Exercises
David J. Houston
Adobe Acrobat Reader: Adobe Acrobat Reader is needed for viewing PDF files. If it is not installed on your computer, you can download a free copy from this site. Click on the link to "Free Adobe Acrobat Reader" at the top of the page.
- Grade Sheet Exercise: Illustrates how to create a basic spreadsheet by entering text, numbers, and formulas.
- Checkbook Exercise: Introduces formatting of cells and columns.
- Mortgage Exercise: See how functions can be used to create a spreadsheet to perform "what if?" calculations.
- Using ChartWizard: Demonstrates the ease of creating charts.
- Sorting Exercise: Learn how to sort data and print portions of a worksheet.
- Special Formats and Exporting Exercise: Illustrates how to dress up a table using special formats and how to export a table or chart into a Microsoft Word document.
- Cost-Benefit Analysis Exercise: Demonstrates a basic cost-benefit analysis using Excel.
- Linking Exercise: Learn how to consolidate several worksheets into one and to link several worksheets to a master worksheet.
- Regression Exercise: Illustrates the use of analysis tools for conducting bivariate regression and forecasting.
- Statistical Analysis Exercise: Use a worksheet to calculate descriptive statistics (e.g., mean, standard deviation, skewness, kurtosis, frequency distribution, correlation).
- Bivariate Regression Exercise: Estimate a bivariate regression equation and related summary statistics.
David J. Houston
Revised -- September 14, 1999