CAPP06041 2016 Computer Applications 1

General Details

Full Title
Computer Applications 1
Transcript Title
Computer Applications 1
Code
CAPP06041
Attendance
N/A %
Subject Area
CAPP - Computer Applications
Department
BUS - Business
Level
06 - NFQ Level 6
Credit
10 - 10 Credits
Duration
Semester
Fee
Start Term
2016 - Full Academic Year 2016-17
End Term
9999 - The End of Time
Author(s)
David O'Halloran
Programme Membership
SG_BBUSO_C06 201600 Higher Certificate in Business
Description

The aim of this module is to provide the learner with the skills to create a word documents, spreadsheet & manipulate a database effectively plus a review of the basic computer skills, file management and internet manipulation.

 

Learning Outcomes

On completion of this module the learner will/should be able to;

1.

Manage folders and files

2.

Create wordprocessing documents

3.

Operate in - house email software

4.

Manipulate the Internet

5.

Creating a Spreadsheet , data input, formatting, data manipulation, reporting generation

6.

Using a Database, creating forms, queries generation, reports generation

7.

Theoretical Investigation into Modern Computing, Buy appropriate Hardware and software, IT Security, Information Systems, Business Ethics and Legal
Issues

Teaching and Learning Strategies

The class will be a combination of a 2.5 hour slot at night. Both Practical and theory will be taught.

Module Assessment Strategies

The is will be 60% continuous assessment with 40% final exam. The 60% will primarily asssess the the practical component of the course while the 40% will address the theoretical elements

Indicative Syllabus

1. File Management

  • file/folder creation, deletion, moving, renaming, etc
  • different file formats (eg docx, xlsx, html, etc)
  • familiarisation with IT Sligo network - eg H drive, S drive, etc

2. Word Processing

  • define software - uses, purposes, etc
  • different types - MS Word, Cloud Computing, etc
  • data entry & editing· formatting (font, size, line spacing, orientation, etc)
  • importing/exporting data
  • layout/structure - tables, columns
  • spellcheck
  • headers/footers,footnotes & endnotes
  • charting & inserting images
  • table of contents & indexing
  • styles
  • forms
  • mail merge
  • printing
  • find/replace
  • tracking modifications

3. Electronic Communication

  • different types - MS Outlook, Gmail, Hotmail, etc
  • email etiquette
  • creating, deleting, forwarding, replying to emails
  • proper use of subject line, cc and bcc
  • attachments
  • formatting
  • signature line
  • out of office reply
  • calendar, appointments (using & syncing)
  • contacts - individuals & groups
  • forwarding email to other email software
  • features - accessing productivity software via email (eg Office365)

 

4. Creating a Spreadsheet

  • purpose, features, benefits & drawbacks
  • different types of spreadsheets − MS Excel, Open Office, Google docs, MS 365 etc
  • software environment
  • data entry & editing
  • copying & moving data
  • formatting & conditional formatting
  • spreadsheet structure/layout/views
  • inserting/deleting/modifying columns/rows
  • formulae − building ( , −, etc) & correct use of
  • functions − SUM, AVERAGE, MIN, MAX, COUNT, IF, LOOKUP
  • relative & absolute cell addressing
  • range naming
  • creating charts
  • freezing panes
  • locking & protecting worksheets/workbooks
  • inserting new worksheets
  • working with multiple worksheets
  • inserting headers & footers

5. Using a Database
(the purpose of this topic is primarily database query & report generation − NOT database design & development)

  • purpose, features, benefits & drawbacks
  • different types of databases − MS Access, Open Office, Google docs, etc
  • creating forms for inserting/editing data − labels, textboxes, command buttons, formatting, etc
  • creating queries to manipulate data − simple (single/multiple fields), criteria, user−specified, calculations, sort, filter
  • creating reports based upon tables and queries
  • exporting and importing from access to other software

 

6. Computer Theory

  • IT security − purpose, threats, prevention, social engineering
  • Information Systems – a study of IS in the business world eg banking, education, customer service, resource planning, etc and the identification of their components, procedures, data, benefits/drawbacks, costs, etc
  • Business Ethics − definitions, approaches, ethical analysis using case studies.
  • Legal issues − data protection, freedom of information, intellectual property rights, social networking, policy andprocedures
  • Introduction to digital / social media marketing – traditional versus modern marketing (eg billboard versus Facebook)

Coursework & Assessment Breakdown

Coursework & Continuous Assessment
60 %
End of Semester / Year Formal Exam
40 %

Coursework Assessment

Title Type Form Percent Week Learning Outcomes Assessed
1 WordProcessing and File Management Practical Practical Evaluation 10 % Week 3 1,2,4
2 Excel Assessment and E. Communication Continuous Assessment Practical Evaluation 25 % Week 8 1,3,5
3 Access Exam Practical Practical Evaluation 25 % Week 12 1,3,6

End of Semester / Year Assessment

Title Type Form Percent Week Learning Outcomes Assessed
1 Final Exam Final Exam Written Report 40 % Week 13 7
             
             

Module Resources

Non ISBN Literary Resources

Harvey, G. (2010) Microsoft Excel 2010 for Dummies. Microsoft Press.
Laudon, K.C., Laudon, J.P. (2010) Management Information Systems: Managing the Digital Firm. Pearson. 11th edition.
Lehtinen, R., Russell, D., Gangemi, G.T. (2006) Computer Security Basics. O Reilly Media, Inc.
Murray, K. (2010) Microsoft Word 2010 Inside Out. Microsoft Press.
Shoup, K. (2010) Teach Yourself Visually Microsoft Office 2010. Visual.
Turban, E., Volonino, L. (2010) Information Technology for Management: Transforming Organisations in the Digital Economy.
Wiley. 7th edition.
Module Other Resources
Lecturer Notes available via Moodle


URL Resources

http://www.howstuffworks.com
http://www.youtube.com
http://www.openup.ie

http://www.gcflearnfree.org/mobileapps