Transcript Lesson Slides Application Softwarex

SOFTWAR E
AWARE
Recommending the most appropriate software
application for business communications.
Starter
• Log on
• Open Power Point
• Add your name and topic to the
first slide
• Title is “Application Software”
Objectives from the Exam Board
Specification
 know the importance of communicating a message in an appropriate form
to ensure its clarity and accuracy as well as putting across the image
and tone the business wishes to convey
 be able to choose the most appropriate medium of communication, taking
into account the content of the message and the audience
 be able to describe the features of the selected medium and evaluate
its appropriateness to a particular context
• be aware of the characteristics and uses of applications software for
word processing, presentations, web authoring, spreadsheets, databases
(including relational databases), graphics and desk top publishing
Today’s Lesson
• We will create a classroom quiz
using application software keywords.
• Each student will be assigned several keywords.
• Your task is to create pub quiz type questions (picture
round, true/false, odd one out, multiple choice, etc)
relating to the characteristics of uses of application
software.
• be aware of the characteristics and uses of applications software for
word processing, presentations, web authoring, spreadsheets, databases
(including relational databases), graphics and desk top publishing
Charts
1.
Axes
2.
Bar chart
3.
Column chart
4.
Legend
Graphics
16. Crop
17. Edit
18. Freehand
19. Geometric shapes
20. Graphic
21. Resize
22. Shading
Databases I
5.
Data capture form
6.
Data type
7.
Database Field
8.
Field heading
9.
Field name
10. Filter
11. Mail merge
Databases II
23. Primary key
24. Query
25. Record
26. Relational database
27. Report
28. Sort
Presentation
12. Animation
13. Slide sorter
14. Template
15. Transition
Word Processing
28. Flyer
29. Letter
30. Memo(randum)
31. Newsletter
32. Template
Spreadsheets
33.
Autofill
34.
Autosum
35.
Cell referencing
36.
Cells
37.
Columns
38.
Footer
39.
Format
40.
Formula
41.
Header
42.
Rows
Web Authoring
43.
Flash
44.
Home page
45.
HTML
46.
Hyperlink
47.
Navigation
48.
Rollover/mouse over
49.
Site plan
50.
Web page
Base your quiz questions on these spreadsheet
application keywords:
1. Axes
2. Bar chart
3. Column chart
4. Legend
What are the characteristics and uses of
charts in spreadsheet application software?
Base your quiz questions on these database
application keywords:
5. Data capture form
6. Data type
7. Database Field
What are the characteristics and uses of database
application software?
Base your quiz questions on these
database application keywords:
8.
Field heading
9.
Field name
10. Filter
11. Mail merge
What are the characteristics and uses of
database application software?
Base your quiz questions on these presentation
application keywords:
12. Animation
13. Slide sorter
14. Template
15. Transition
.
What are the characteristics of
presentation software and what is it used for?
Base your quiz questions on these graphics
application keywords:
16. Crop
17. Edit
18. Freehand
19. Geometric shapes
20. Graphic
21. Resize
22. Shading
What are the characteristics and uses of graphics
software?
Base your quiz questions on these database
application keywords:
23.Primary key
24.Query
25.Record
26.Relational database
27.Report
28.Sort
What are the characteristics and uses of database
software?
Base your quiz questions on these word processing
application keywords:
28. Flyer
29. Letter
30. Memo(randum)
31. Newsletter
32. Template
What are the characteristics and uses of word
processing software applications?
Base your quiz questions on these spreadsheet
application keywords:
33. Autofill
34. Autosum
35. Cell referencing
36. Cells
37. Columns
What are the characteristics and uses of spreadsheet
software?
Base your quiz questions on these spreadsheet
application keywords:
38. Footer
39. Format
40. Formula
41. Header
42. Rows
What are the characteristics and uses of spreadsheet
software?
Base your quiz questions on these web authoring
application keywords:
43.Flash
44.Home page
45.HTML
46.Hyperlink
What are the characteristics and uses of web
authoring software?
Base your quiz questions on these web authoring
application keywords:
47.Navigation
48.Rollover/mouse over
49.Site plan
50.Web page
What are the characteristics and uses of web
authoring software?
Task – 15 minutes
• You have 15 minutes to create questions that will be used in a
classroom quiz.
• Create at least three questions for each of the key words.
• Use a ppt presentation, put your quesiton on one slide and the
answer on the next slide.
• What kind of questions should you create?
• Picture round
• True /false
• Multiple choice
• Odd one out
• Short answer
Creating the quiz
• Save your presentation with your name and topic
in the filename (JohnJones_Databases)
• Put your presentation into my drop box
• you need to drag it from your area into the drop
box
ICT/Pupil Write/Mrs Jones drop box
Examples from past papers
• This is what questions from the exam board might look
like when they are testing one aspect of your knowledge
of application software.
Sunny Seas
BACKGROUND INFORMATION
ITEM B
• Sunny Seas hotel bookings are made
Sunny Seas is a hotel in a busy seaside
town. Rosie has just taken over the hotel
from her parents. The hotel is large and
old-fashioned but it makes a small amount
of profit each year. Rosie is looking
forward to making improvements to how
the hotel is run. She hopes this will bring in
more customers.
by telephone and recorded in a diary.
Customers’ details are kept on paper in
a filing cabinet. The staff find this
system easy to use. When Rosie
bought a computer, the shop assistant
suggested that she could use a
database to replace the paper records.
She explained that the records in the
customer database would contain a
number of fields, such as title, surname
and first name. Rosie thinks this could
be very useful as she could use the
customer details for future promotions.
However, neither Rosie nor her staff
have used a database before.
Past Paper Jan 11
(6 marks)
2 (b) State two fields which Rosie may have in her customer database,
other than title, firstname and surname. Give reasons for your answers.
Field
...........................................................................................................................
Reason
...........................................................................................................................
..............................................................................................................................
..............................................................................................................................
..............................................................................................................................
.............................................................................................................................
Field
........................................................................................................................
Reason
..........................................................................................................................
..............................................................................................................................
...........................................................................................................................
Past Paper Jan 11
(9 marks)
Rosie is considering using a database to record bookings and to keep customer details.
Do you think she should use a database rather than her paper based system for this
purpose? Give reasons for your answer.
............................................................................................................................................
............................................................................................................................................
............................................................................................................................................
............................................................................................................................................
............................................................................................................................................
............................................................................................................................................
............................................................................................................................................
............................................................................................................................................
............................................................................................................................................
............................................................................................................................................
............................................................................................................................................
............................................................................................................................................
............................................................................................................................................
............................................................................................................................................
............................................................................................................................................
............................................................................................................................................
............................................................................................................................................
............................................................................................................................................
Past Paper Jun 13
(9 marks)
Edachild Q3
Recommend the most appropriate type of software that the
administration assistant will need to use to help to monitor
the success of the voucher scheme. Give reasons for
your choice.