Introduction
- Teacher: Raymund O’Connor
- Email: raymund.oconnor@corketb.ie
IT Rule & Regulations
- See Student Handbook at your campus
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)
- Your Microsoft 365 account expires at the end of each the academic year. Hence I recommend you backup your personal data or data you require to your own cloud storage (eg Google Drive, OneDrive, iCloud, Dropbox, etc)
- Outlook basics (attachments / calendar / etc)
- Create PDF using OneDrive app(or camera app)
- Moodle (logging in and submitting assessments)
Assessment
- Project – 50%
- Practical Examination – 50%
Resources
- Google and YouTube
- Microsoft Excel Tutorial – Full Course YouTube – Video
- MOOCs (Coursera, Udacity, etc)
- AI (eg Copilot, Gemini, Perplexitiy, Chat GPT)
- Free eBooks – https://goalkicker.com/
- AI for Excel – https://numerous.ai/
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