List of public pages created with Protopage

Home

Bookmarks

Bookmarks

Skills, Resources and Universal Credits

Plain sticky notes

Sticky note

Converting Excel to XML Step 1 – Create your Excel spreadsheet. ... Step 2 – Create your XML schema. ... Step 3 – Enable the Developer tab. ... Step 4 – Open the XML Source pane. ... Step 5 – Add an XML Map. ... Step 6 – Drag and drop the XML elements into your spreadsheet. ... Step 7 – Export your XML data.

Go-On Logo

Sorry - the Go-On images are not great for a banner but they are the only ones on the www, It looks like the GO-On Manchester Digital Champion scheme no longer exists - I am still operational.

Rich sticky notes

Welcome

Hello......

I have been registered as a Digital Champion for a few years now but I am seeing very little activity. I continue to do my own thing and have been tutoring IT on a peer to peer basis.

I now have my PTLLS and am actively involved in teaching at a number of locations where I volunteer my services.

BramIT

Mission 

My mission as a Digital Champion is promote Protopage and to support the other Champions that chose to have a web presence.

I will keep a central register of web sites created by the champions to support the community of Manchester.

I have been  a little ahead of you in this game I have been active as a Digita Champion since I joined the Community Guardians scheme.

Photos

Created by Community Guardian BA 019.

LearnIT

Bookmarks

Education

Prototyping

Volunteering

Rich sticky notes

About LearnIT

LearnIT History / Future

Over the course of time I have developed many websites for different communities covering employment and training.

I have now bought them together under under one project and have exposed them here.

I am working on producing a book with all my stuff in it and I may ISBN it and get it published but the intention is to deliver content on-line.

Evolution is my work in progress - I have discovered when migrating folders up to your Google drive that they have version control - they do not update current documents. (this has been removed as it requires attention).

When completed I will upload TrainIT then work on my links - I will have to keep a link register as for sure things will change.

I will Blog which areas I am working on to map my progress and for you to review what I am working on.

Happy reading........

Plan

Plan 
By all means look at my Little LearnIT sites but you will not find supporting documentation.

This will arrive in Evolution then LearnIT in time.

Acme Industies

 

Introduction

 

To support this book there is significant www supporting information. In fact all this document can be found On-Line.

 

The History Of Acme  Industries 

It was a joke – but a joke is not funny if you have to explain, and it was not till I showed my site to my son did I realised he just does not get it.

 

My Acme Industries site is just a phantom name taken from the Road Runner Cartoon -  Acme Corporation. It is a company that does everything and is therefor ideal for the case studies which I want to develop. The web site will be used for protoyping and data modelling, there will be little in discussion narrative, it is a site for your imagination.  I will detail Case Studies but these will be documented outside the site and there will be a singularity link to them.

 

So that is it – in a nutshell it is a phantom company.

 

See Wikipedia below:

 The Acme Corporation is a fictional corporation that features prominently in the Road Runner/Wile E. Coyote cartoons as a running gag featuring outlandish products that fail or backfire catastrophically at the worst possible times. The name is also used as a generic title in many cartoons, films, TV series and comics.

The company name in the Road Runner cartoons is ironic, since the word acme is derived from Greek (ακμή ; English transliteration: akmḗ) meaning the peak, zenith or prime, and products from the fictional Acme Corporation are both generic and failure-prone.

Origin


The name Acme became popular for businesses by the 1920s, when alphabetized business telephone directories such as the Yellow Pages began to be widespread. There was a flood of businesses named Acme, including Acme Brick, Acme Markets, and Acme Boots. Early Sears catalogues even contained a number of products with the "Acme" trademark, including anvils, which are frequently used in Warner Bros. cartoons.[1]

Warner Brothers animator Chuck Jones has said the name Acme was chosen because of its prevalence:

 

Job Club

Bookmarks

General Job Search

Civil Service

Construction

Secretatial/IT/Administration

Media/Public Sector

Engineering and Manufacturing

BBC

Teachers

Middle Management £20k+

University/higher education

Royal Mail

Leisure Industry

Scientists / jobs in nature

Greater Manchester Police

Public Sector / Charity

NHS

Retail

Council Websites

Railway Jobs

Newspaper Job Websites

Graduate Recruitment

General

Volunteer Jobs

Food Industry

Map

Web widgets

Map: Manchester

Word

Rich sticky notes

Word

Introduction

You will not be able to open the documents stated in consolidation documents -  you will have to be inventive and use your imagination. But what you can see are the tasks that are expected of you.

Consolidation Exercise - 1

1. Start Word 
2. Open the document 'stud_info'.
3. In the title, insert the word new between for and students.
4. Correct the spelling of Hartley in the first sentence of the first paragraph, and through at the end of the third sentence.  
5. Insert the word be between will and happy in the last sebtence of the first paragraph.
6. Correct the spelling of pass in the sixth sentence of the second paragraph.
7. Delete the repetition of a in the final sentence of the second paragraph.
9. Delete the words until you are used to the buildings at the end of the second paragraph.
10. Insert the word told between and and key in the second sentence of the third paragraph.
11. Correct the spelling of procedure in the third sentence of the third paragraph.
12. Save your document in your work folder with a suitable name. 


Consolidation Exercise - 2

1. Start Word and open a new blank document.
2. Enter the following text with an unjustifies right margin and a justified left margin.

Seat Belt Regulations

It has been a legal requirement to wear a seat belt in the front seat of the car since 1983. It became law for children under 14 to be restained in the rear seats of cars in 1989. and for adults to wear seat belts when fitted.

Legal requirements today.

Use seat belts if they are available.

Use an appropriate restraint (a suitable baby seat or child's car seat) to carry children under three years of age in the front.

If a child restraint is not fitted in the rear then a child under three years of age must use the restraint fitted in the front.

If a seat belt or child restraint is not available in the rear then children between three ans 11 must use the front seat resraint.

Vehicle Seats Affected

Front seats of all vehicles.

Rear seats of cars and small minibusses.


Restraints should be used if available, but more passengers than there are seat belts can be carried.

In an accident heavy passengers are more likely to injure others if they are not wearing a seat belt. It is safer for a child under three to sit in the back seat wearing an adult seat belt rather than wear no restraint at all.

Guidelines approved:  AJH

3. Check your work, make any corrections you need to make and save your document with the filename  'seatbelt' in you work folder.
4. Centre the title Seat Belt Regulations and make this text bold.
5. Format the hading so that it is larger than the rest of the text.
6. Change the subheadings Legal requirement today and Vehicle seats affected to bold text.
7. Set the final line, Guidelines approves: AJH, as italic text. Change only this line to a different font.
8. Move the paragraph In an accident ... so that it appears after the introductory paragraph, it has been ...
9.Delete the paragraph Restraints should be used if available, but more passengers than there are seat belts can be carried.
10. Using Word's Find and Replace facility, make the following changes:
     - change all references to child to child or infant.
     - change references to car to passenger vehicle except where the context makes this change unsuitable.
11. Save ypur document in your work folder with a suitable name.
12. Close the document and close down Word.
13, When you have completed this exercise, check your work using the model answer.

Consolidation Exercise - 3.

1. Start Word and open a new document.
2. Set the left and right page margins to 2.25cm.
3. Set the alignment of the text so that both the left and right margins are justified.
4. Set the font to Arial 12.
5. Type in the following text.

Starlight School of Performing Arts

The Starlight School of Performing Arts was founded in 1991 and has become one of the most reputable centres in the country for those aspiring to achieve success in the field of expressive arts. Housed in a fine old country mansion, it provides an inspirational setting in which budding superstars can learn their craft and practise their performance. The atmosphere is both exciting and challenging.

A wide range of courses, both full-time and part-time, can be followed at the school.Ballet, tap, musical theatre and street jazz are just some of the styles that can be studied alongside more unusual styles such as ceroc and flamenco.All methods of singing style are studied, e.g. opera, jazz, stage.

For those more interested in the technical side, there is a theatre studies course, which covers all aspect of stage management, including sound and lighting, props and special effects, and front-of-house management.

If you would like further information about the school and the exciting opportunities we offer, please contact us on 12345 678901.

6. Embolden the heading and change the font size to 14,
7. Replace the word founded in the first paragraph with the word established. 
8. Save your fille with the name 'starlight' and print one copy. Check your work using the model answer if you want to.

Now make the following changes to the 'starlight' document.

9. Change the left and right margin settings to 3 cm.
10.  Delete the final sentence of the first paragraph.
11. Insert a paragraph break and one clear line space in the second paragraph after the word flamenco.
12. Insert the following text as a new paragraph before the last paragraph.

Many of our students go on to professional careers in th field of expressive arts although they are always sad to leave the school.

13. Embolden  the paragraph of text you have just entered.
14. Using Word's Find and  Replace facility, change all instances of the word school to academy.
15. Move the second to last paragraph, Many of our students ..., so that it becomes the second paragraph of the document.
16. Set the last paragraph of text in double-line spacing.
17. Change the alignment ot the text so that it has a justified left margin and an unjustified right margin.
18. Centre the heading.
19. Use Save As to save the document with a new filename and print one copy.
20. Close the document and close down Word.
21. When you have completed the exercise, check your work using the model answer. 

 



Excel

Bookmarks

Bookmarks

Rich sticky notes

Rich text note

Code From VBA in Excel Tutorial.
To get an input form update a list of items:

Set up Sheet 1 with B4 Name and B5 Problem
           Sheet 2 with B4 Name and C4 Problem

Add a control button with the following VBA

Private Sub Command Button1_Click()
Dim CustomerName As String, CustomerProblem As Integer
Worksheet(*Sheet1*).Select
CustomerName = Range(*C5*)
Worksheet(*Sheet2*).Select
Worksheet(*Sheet2*).Range(B4).Select
If Worksheet(*Sheet2*).Range(B4).Offset(1, 0) <> ** Then
Worksheet(*Sheet2*).Range(*B4*).End(x1Down).Select
End If
ActiveCell.Offset(1, 0).Select
ActiveCell.Value = CustomerName
ActiveCelll.Offset(0, 1).Select
ActiveCell.Value = CustomerProblem
Worksheet(*Sheet1*).Select
Worksheet(*Sheet1*).Range(C4).Select

End Sub

Rich text note

Converting Excel to XML
  1. Step 1 – Create your Excel spreadsheet. ...
  2. Step 2 – Create your XML schema. ...
  3. Step 3 – Enable the Developer tab. ...
  4. Step 4 – Open the XML Source pane. ...
  5. Step 5 – Add an XML Map. ...
  6. Step 6 – Drag and drop the XML elements into your spreadsheet. ...
  7. Step 7 – Export your XML data.

Excel

Consolidation Exercise - 1 

1. Start Excel
2. Open the spreadsheet 'exercise1' from your examples folder. This has the title of the spreadsheet you are going to create, and the column widths set appropriately so that your text will be fully visible.

3. Starting in cell A3, enter the column labels:
Plant
Height year 1
Height year 2
Change
Height year 3
Change
Total change
Average growth/year

4. Beneath Plant enter these row labels:
A
B
C
D
Average

5. Now enter these figures. Some cells are left blank to hold formulae.

Plant      Height year 1      Height year 2      Height year 3             
A                   13.34                    15.67                    18.75
B                   11.21                    13.45                    15.02
C                   14.44                    16.73                    19.8               
D                   15.19                    17.88                    21.01

6.In the cells in the first column labelled Change, enter a formulae to subtract the height in the first year from the height in the second year for each plant.

In the next Change column, enter a formulae to subtract the height in the second year from the height in the third year for each of the plants A,B,C and D

8. In the Total change column, enter a formulae for each plant to show the total of the change in the second year and in the third year.

9. In the Average growth/year column, enter a formulae for each plant showing the total change divided by the number of years over which change was recorded.  

10. In the final row, add formulae to show the average figures for each column.

11. Save your spreadsheet in you work folder.
12. Close the spreadsheet and close down Excel.
13. When you have completed this exercise, check your work using the model answer.

Consolidation Exercise - 2

1. Open a new blank spreadsheet in Excel.
2. Enter the title Cruise boat hire.
3. Leave a blank row then enter these column labels:
Month
Days rented
£/day
Catering
Total income
Fixed expenses
Staff/fuel
Profit

4. Starting in the first row beneath the label Month,enter these row labels:
April
May
June
July
August
September
October

5. Now enter the following data in the cells: 
Month           Days rented            £/day               Catering             Fixed expenses
April                     11                         120                    0                              300
May                      19                         175                 350                            300
June                     29                         200              1,750                           300  
July                       31                        200               2,200                           400
August                  31                        220               1,800                           400
September          26                        200                   700                           400
October               17                         175                   250                           300

Format all numbers except 'Days rented' as currency. The cells for which there are no values shown will hold formulae.

6. Insert a new  column entitled Total rental between the columns £/day and Catering. In the first cell in the Total rental column, enter a formula to multiply the number of days rented in April by the daily rental figure. Copy the formula into the cells for the remaining months. Check the figures are formatted at currency.

7. In the first Total income cell, enter a formula to add together the income from the rental and the income from catering. Copy the formula into the cells for the remaining months. Check the figures are formatted as currency.

8. In the first cell in the Staff/fuel column, enter a formula to