-
Recent Posts
Recent Comments
- Brian on How to plot multiple UK addresses (by postcode) on a Google Map
- Mark on How to plot multiple UK addresses (by postcode) on a Google Map
- Mark on How to plot multiple UK addresses (by postcode) on a Google Map
- Brian on Interview advice for PGCE ICT with Computing at KCL / IOE
- Brian on Blatant racist discrimination in advertisements
Tag Cloud
abstract accommodation array bursary Chrome date email enumerated type exam Excel fields finance generics Google greenfoot GTP GTTR hardware ICT interview Java KCL laptop linux literature review LMC London network news object OOP Oracle PGCE primary programming QTS QTS tests SER shortcut SSA static travel ubuntu UML variablesArchives
Categories
Meta
Tag Archives: Excel
Microsoft Excel starts but document doesn’t open
When I double-click an Excel spreadsheet file (*.xlsx) Microsoft Excel 2007 starts but the document doesn’t open. Instead, the following error message appears: The Microsoft Support website says this problem can be corrected by changing a setting within Microsoft Excel … Continue reading
Using formula tracing to learn about relative and absolute cell referencing
I have been using formula tracing in Microsoft Excel to help my students understand why some formulas “go wrong” when using Fill Down and relative cell references. This is good for explaining and helping students diagnose problems in their own … Continue reading
Tracing formulas and cell references for a KS3 spreadsheet modelling class
I’m now at my second placement school and this week I had to teach spreadsheet basics to students in YR7 and YR8. In the previous week I noticed how some students were typing values where they should have typed formulas, … Continue reading
Download LMC simulation v.1.5.2 (requires Microsoft Excel)
The Little Man Computer simulates machine code programming using a simple instruction set and 100 memory addresses (labelled 00 to 99). This implementation was created to teach students in year 9 studying OCR Computing GCSE. As you can see, it … Continue reading
New version of the Little Man Computer (MS Excel simulation)
Since using the LMC simulation with my students, I have made a few changes to the interface to make it easier to understand. Some students didn’t notice the program counter (even though it is animated and highlighted) therefore I have … Continue reading
Little Man Computer simulation using Microsoft Excel / VBA
It is now week 10 of my PGCE course and tomorrow I will be teaching GCSE Computing to my year 9 class. This is my favourite course so far — infinitely better than OCR Nationals ICT — and it gives … Continue reading
MOS Exam – Microsoft Office Excel 2007
Great news! Today I took the Microsoft Office Specialist (MOS) Microsoft Office Excel 2007 exam and passed with a score of 962/1000. Viewed on the Certiport website, my score report showed the following sections: Creating and manipulation data Formatting data … Continue reading
Posted in Uncategorized
Tagged certification, Excel, Microsoft, MOS, Office, training
Leave a comment
Microsoft Certified Application Specialist (MCAS) Excel
I’ve got some free time before I start my PGCE Secondary ICT course later this year so I thought it would be a good idea to brush up on my Microsoft Office skills and familiarize myself with any changes since … Continue reading