1 / 11

CSEC IT

CSEC IT. Section 2. Introduction. This section tests your knowledge of Word, Excel and/or Access Two questions will be asked The section is worth 15 marks These marks are added to your SBA for your Productivity Tools profile. Microsoft Word Terms. Formatting features

hachi
Download Presentation

CSEC IT

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. CSEC IT Section 2

  2. Introduction • This section tests your knowledge of Word, Excel and/or Access • Two questions will be asked • The section is worth 15 marks • These marks are added to your SBA for your Productivity Tools profile

  3. Microsoft Word Terms • Formatting features • Fonts, colours, bold, italics, underline etc. • Paragraph alignment • Left, center, right, justify (lined up evenly on both sides) • Cut and paste / copy and paste • Margins • Space around the edge / border of your page

  4. Microsoft Word Terms • Headers and footers • Header: text in the top margin of the page • Footer: text in the bottom margin of the page • Endnote and footnote • Endnote: reference at end of document • Footnote: reference at the bottom of page • Page break: text goes to another page • Column break: text goes to next column

  5. Microsoft Word Terms • MAIL MERGE • Sending one document to multiple persons • Main document: original document/letter • Data source: list of recipients / persons • Merged document: final document

  6. Microsoft Excel • Formatting features • Fonts, colours, bold, italics, underline etc. • Currency, percentage, comma, decimals • Sorting (ascending / descending) • Formula • Example: = A6 * B2 • Ranges • Example: (B10:B20)

  7. Functions = SUM(B10:B20) = AVERAGE(A6:E6) =COUNT(F3:F7) =MAX(C3:C10) =IF(A1>75, “Pass”, “Fail”) June 2011, 7a: =IF(C2=Junior, “100”, “200”)

  8. Access -Database • Tables • Fields and records • Datatypes • Text, number, date/time, currency, yes/no • Primary Key • Field which is unique to each record • Join / relationships • Similar field which links two tables together

  9. Access - Queries • Must have the name of the field(s) • Must have the needed “criteria” • Example

  10. Access –Calculated query • Write a query which creates a calculated field to calculate VAT, give that vat is equal to the price * 0.15. • Calculation -> VAT = price * 0.15 • In Access -> VAT : [price] * 0.15

  11. Access - Reports • Used to print data • Grouping means to put similar items together • Example: Group by gender means • All males printed together • All females printed together

More Related