Introduction
- Teacher: Raymund O’Connor
- Email: raymund.oconnor@csn.ie
IT Rule & Regulations
- From Student Handbook on www.csn.ie
File Management
- Active Directory – Logging in and out of CSN college network using computers on campus
- Create a folder for each component (files and folders)
- As Office365 expires when you finish in CSN I recommend to Backup to Google Drive, iCloud, Dropbox, etc
- Outlook basics (attachments / calendar / etc)
- Create PDF using OneDrive and camera app
- Moodle (logging in and submitting assessments)
- Video Recording(screen capture) on your smartphone
Assessment
- Project – 50%
- Practical Examination – 50%
Resources
- Google and YouTube
- Microsoft Excel Tutorial – Full Course YouTube – Video
- MOOCs (Coursera, Udacity, etc)
- Free eBooks – https://goalkicker.com/
Component
Useful Websites
Useful website: https://excel-practice-online.com/ and https://excel-practice-online.com/functions/sum-function/
Class Notes and Exercises
Videos of exercises are available from my YouTube channel: (223) Spreadsheets – YouTube
Video for Exercise 11 http://youtu.be/w8PLQTz3rRw
- Formula/Functions (IF(AND)/Hlookup/Vlookup/percentages/maths formula/max/min/average/etc)
- Borders / Shading
- Delete/Insert row/column
- Sort
- Filter
- Graph
Practical Exam will be held 3/2/2022 (2 hour exam) in Room 102 Time: 9:00 to 11:00
Videos
Video demo of 20 Hotel Room Bookings Exercise
Project
Given: 17/2/2022 Deadline: 4/4/2022