In todays lesson we spent the first half of the lesson listening to Mr.Cavill talking about macros and how we can use them in our individual project to make our markbook.
From the internet website:
wordnet.princeton.edu/perl/webwnthe definition of a macro is:
a single computer instruction that results in a series of instructions in machine language
With the use of macros to help in the creation of the markbook, we are able to create a new class button. It makes the creation of the markbook more complex but easier for the people who are going to use the markbook.
In my markbook we have to include
- Introduction page
- Template page
- Instruction page
With a number of codes created by the macro and experimenting around hopefully i will be able to create a markbook that people would be able to use easily.
researching macros and how to use them:
a website i found that tells me how to use and edit a macro in excel is:
http://www.taltech.com/support/sw_tricks/exmacros.htmA PDF about with an introduction to the use of macros in excel :
http://www.dur.ac.uk/resources/its/info/guides/39Excel2003Macros.pdfIn todays lesson i learnt how to use a macro and how to use a combination of different buttons in excel which would make using excel to create a markbok easier.
note:
(this would when creating a new class allow users to edit the name)
edit macro
sheets("template") .Copy After:=Sheets (3)
ActiveSheet. Name = InputBox ("Give name")
TALK @ 10:24 AM