AC1103 Information Technology

1
AC1103 - Information Technology

• Revision

2
Exams

• Class exam
• 17th Jan (Monday) 1.30-2.30pm Sports Centre
• One sitting ONLY
• Students with special needs - if unsure contact
  Louisa
• Notification of illness or other non-attendance
  needed
• Results as soon as possible

3
General exam points

• 1 hour paper
• Covering everything from this course,i.e.
  lectures/practicals/assignments
• Cannot leave during the exam
• Late arrivals may not be allowed in
• READ THE INSTRUCTIONS, especially split DB/VB
• Read questions carefully
• Re-read your answers

4

• Note the words in the question
• briefly, in more detail, give THREE reasons ...
• List, Describe, Detail, Explain
• Check how many marks allocated to different
  parts of question
• Amount you write should relate to the marks
  allocated
• Plan answers re-read them
• Use pen

5
Rest of the course

• AC1103 finishes after the class exam
• AC1204 (for most of class) starts in week 3, same
  times as AC1103
• AC1103 has a degree exam
• May or June
• 2 hour paper
• Covers same topics as class exam

6
Coursework

• Collect marked work from Rhonda (9.30-11.30)
• Check against printed list in Jam Factory
• Exemption list will be posted during week 4
• Resubmit ALL coursework (files on disk and
  marksheets) when requested in summer term for
  external examiners
• Any outstanding coursework, contact RP THIS WEEK

7
Excel Revision

• Whats a spreadsheet for?
• A system for manipulating, modelling, analysing
  presenting data

8
Excel 97

• Cells referenced by Row Column - e.g. B3
• Range of cells e.g. B3D5
• Enter data - numerical/text
• Formatting cells - e.g. currency
• Worksheets - may be interlinked

9
Calculations - Formulae Functions

• Arithmetic e.g. B1B2/3
• Functions e.g. SUMMAXIFSUMIF, e.g.
  SUM(B1,C1,C2)
• SUM via Autosum button
• Paste Function button

10
Copying Formulae

• For repetitive calculations
• Use Fill handle Copy paste CTRL C/V ..
• Absolute v. Relative cell referencing naming
  cells

11
Useful Features (1)

• What-if analysis see effect of changing an
  important quantity (e.g. exchange rate VAT rate
  wage rate, .)
• Creating Charts - Wizard
• Creating Tables - Pivot Table

12
Useful Features (2)

• Filter data - some flat file database features
• Sort
• Mail merge

13
Exam question (1)

• The following spreadsheet has been created using
  Excel 97 to process the accounts data for a small
  bus company

14
(a) Write down
(i) an appropriate formula for cell B8, using a
function
SUM(B3B7)
15
(ii) an appropriate formula for cell B13
B11-B8
16
(b) Describe two alternative methods for copying
the formula from cell B13 to cells C13E13
Fill handle Copy Paste CTRL C/V
17
(c) Give the step-by-step directions for adding
another category of expenditures, say Road
Tolls, to the spreadsheet, ensuring that its
values are included in the subsequent
calculations.
Insert new row (e.g. at row 7) adjust TOTAL
row. PROFIT row updates automatically.
18
(d) Suggest two different ways in which the
appearance of the spreadsheet could be made more
attractive and meaningful, and how you would
achieve these.
Formatting - currency size style of font
autoformat Table lines borders colour text
alignment comments etc.
19
(e) How would you produce a graph to illustrate
the changes in profits for the four months shown?
Describe the Excel facilities you would use, and
briefly sketch the graph that would appear.
Chart Wizard line (or column) chart data in
rows month on x-axis, profit on y-axis.
20
(No Transcript)
21
Exam Question (2)

• See IT100 Exam, May/June 1999.
• Qu 3 - covers
• What a spreadsheet is can do
• Relative/Absolute referencing
• Arithmetic/Formulae across two worksheets
• Using Pivot Table

22
Sept '99

• 2. a) Explain briefly what each of the following
  are used for in Microsoft Word 97
• i) Outline view
• ii) Styles
• iii) AutoCorrect
• iv) Fields
• v) Sections
• 10 marks

23

• i) Viewing headings at different levels to add
  organising a document.
• ii) Saving a combination of paragraph formatting
  for easy application again and again
• iii) Automatically applying spelling corrections
  and/or shortcuts, eg. ppt for PowerPoint
• iv) Many facilities for automatically adding data
  to a word document, eg. today's date, the
  author's name, a figure number.
• v) Partitioning the document so that each bit has
  its own formatting, eg. columns, or one page in
  portrait when the rest is landscape.

24
Sept '99, q2 contd.

• b) Describe, step by step, how you would convert
  a Word 97 file so that it can be used by
  PowerPoint 97. 5 marks
• Use standard headings in word (heading1 for slide
  headings, heading 2 for high level bullet points
  etc)
• Save As RTF
• Open in PowerPoint

25
Question 4

• b) Briefly describe the various steps that you
  can take in order to prevent important files from
  being lost or destroyed. 4 marks
• - Backing up (make multiple copies of files)
• - Store backups in different places (e.g., have
  two copies on a hard drive, have two more copies
  on two separate floppy disks).
• - Making files Read Only.
• - Write-protecting floppy disks.

26
Question 4

• c) Describe the main ways in which companies can
  control who gets to access their computer
  system 4 marks
• 1 mark for the following main method
• Username and password must be supplied.
• Up to 3 marks for the remaining points
• Controlling who gets into computer rooms via PIN
  number keys, identity badges, swipe cards.
• Using biometrics to control who gets into
  computer rooms and who can log on, e.g., Retinal
  Scan, Voice Recognition, finger prints.

27
Question 4

• d) Briefly state what a computer virus is.
• 2 marks
• A virus is a tiny program which may or may not
  cause other programs to malfunction.
• A virus infects other programs by reproducing
  itself.