Sofware Development

High Level Languages
+ Written in an English like Language, means they are easier to understand than Low Level Languages - like 1010101's
+ Portable, means they can be used on different platforms (different Operating Systems, Processors)
+Must be translated before they can be executed

Translators
Interpreter
Translates and executes one line of code at a time
+ excellent for debugging, as it stops when an error is found and will not move beyond that line
- needs to be always running in memory

Compiler
Translates and executes the full program at once
+ gives an executable file once the program has been successfully translated
- not great for debugging as it returns all the errors at once (could be loads!)

Tutoring

If you or anyone you know if looking for tutoring for all levels
Standard Grade, Higher and Intermediate 2 Computing then give me a mail at

cmcalpine@hamilton.s-lanark.sch.uk

Programming

Four variable types??

String - "Corey#.1"

Integer - 1,2,3,4,5,6

single - 0.95

boolean - true/false

PRINTING IN A PICTURE BOX

dim yourname as string
yourname = inputbox("Enter your name")

pctinfo.print "Name you entered: " & yourname

Spreadsheets

What are spreadsheets used for - Calculations!

What makes up a spreadsheet - Cell

What is a vertical run of cells called? - Column

What is a horizontal run of cells called? - Row

What do we call (A1:D9) - Range of Cells

What three things can go in a Cell? - Number, Text and Formula

Spreadsheets allow us to replicate formulas, What does Replicate mean - Copying!

5 functions in spreadsheets
= average()
= sum()
= min()
= max()
= if(B2 >= 18, "Go Dancing", "away hame")
= if(b2 >= 35, "Hit the Overs, old git", if(b2 >=18, "Hit the dancing", "Away to unders"))

There are two types of Replication ($$$)

$$$ - Absolute - formula DOES NOT change!
No dollars - Relative - formula changes to suit the new cells

Merge Ahead!

There are a few steps in completing a mail merge operation

1. Create a Standard Letter

2. Create a Database of Personal Information

3. Insert the merge fields into the Standard Letter

4. Merge the two together

What is a Standard Letter?

A Standard letter is a letter with no personal information that we can use to complete a Mail Merge

Loads of Word Processor Stuff!

OCR

Optical Character Recognition
Scanner & OCR Software
Scans and recognises words on a document


Standard Paragraph
document which is already typed and saved
insert into many documents again and again
dont have to re-type or spell check

Four Alignments of Text
Left, Right, Centre and Fully Justified


Word Wrap Vs Text Wrap
Word Wrap automagically takes a new at the end of a paragraph
Text Wrap is used to wrap text around graphics!

Formatting Text Styles
Bold, Italic, Underline
Shadow, Strike Through, SuperScript, SubScript, Colour, The Size, The actual Font

Grammar Checker
checks the format of text making sure of punctuation !words of order!
underlines in green

Search and Replace
allows you to "search" for one word and "replace" it with another
need to be careful you dont change the wrong words
Selective - you choose, Global - does them all!

Integrated Packages

Integrated Packages????

a package with more than one GPP (General Purpose Package)

Advantages

dont need to buy each GPP separately - saving money
Common HCI
Link between tasks (to transfer data between them)
can several different documents open at the same time


Disadvantages

some features may have been removed