COMP06279 2020 Spreadsheets: Skills and Techniques in Health Sciences
Full Title
Spreadsheets: Skills and Techniques in Health Sciences
Transcript Title
Spreadsheets: Skills and Techn
Code
COMP06279
Attendance
N/A %
Subject Area
COMP - 0613 Computer Science
Department
HEAL - Health & Nutritional Sciences
Level
06 - Level 6
Credit
05 - 05 Credits
Duration
Semester
Fee
€
Start Term
2020 - Full Academic Year 2020-21
End Term
9999 - The End of Time
Author(s)
Akinlolu Akande
Programme Membership
SG_SINFO_B07 202000 Bachelor of Science in Health and Medical Information Science
SG_SINFO_C06 202000 Higher Certificate in Science in Health and Medical Information Science
Description
This module provides a comprehensive study of electronic spreadsheets. Using data derived from real-world health sciences, students will learn how to use appropriate spreadsheet software features to organise, analyse and present data.
Learning Outcomes
On completion of this module the learner will/should be able to;
1.
Create complex formulae and advanced charts
2.
Use a wide range of Excel functions – Mathematical / Statistical / Financial / Text / Lookup / Date & Time
3.
Create Tables, PivotTables and PivotCharts
4.
Model problems using advanced features in spreadsheet software.
5.
Apply and manage conditional formatting (advanced conditional formatting)
Teaching and Learning Strategies
The module will also adopt some principles of universal design for learning by using a combination of online lectures, self-study, problem-solving exercises and computer-based learning. It will also employ a "flipped classroom" approach where students will engage with Moodle based notes, videos and quizzes.
Module Assessment Strategies
Students will be assessed in a variety of ways with feedbacks enhanced by technology. The module will be assessed by means of practical activities during the weekly practical sessions, assignments in the word processing and presentations section which will be completed during the students independent learning. There will also be a computer laboratory-based assessment at the end of the module to ensure the student has met the learning outcomes and has taken on board the feedback given during the weekly practical sessions and the assignments already completed.
Repeat Assessments
Where the module mark is below 40%, the student will be asked to resubmit assignments for re-evaluation or repeat a practical continuous assessment.
Indicative Syllabus
Advanced Charting
Applying different trend lines
Applying secondary axes, error bars, etc.
Lookup and Information Functions
Vertical Lookup (VLOOKUP)
Horizontal Lookup (HLOOKUP)
INDEX, MATCH & OFFSET
Logical Functions
IF Statements
Nested If / Ifs
Nesting IF WITH AND, OR
Database / List Management
Sorting Data (By Values, By Cell Colour, By Font Colour, By Cell Icons)
Multi Column Sort
Filter (By Values, By Cell Colour, By Font Colour, By Cell Icons)
Multi Column Filter
Freeze Panes
Format as Table Feature
PivotTables and PivotCharts
Creating a Pivot Table
Updating the Table
Changing the Table Structure
Formatting the Pivot Table
AutoFormats
Creating Charts from the Data
Calculated Items
Applying and Managing Conditional Formatting
Data Bars
Colour Scales
Icon Sets
Top / Bottom
Creating Formula based Conditional formatting
What If Analysis Tools
Scenarios
Goal seek
Solver
Coursework & Assessment Breakdown
Coursework & Continuous Assessment
100 %
Coursework Assessment
| Title | Type | Form | Percent | Week | Learning Outcomes Assessed | |
|---|---|---|---|---|---|---|
| 1 | Practical Evaluation Weekly activities | Coursework Assessment | Practical Evaluation | 20 % | OnGoing | 1,2,3,4,5 |
| 2 | Online Quizzes | Coursework Assessment | Multiple Choice/Short Answer Test | 20 % | OnGoing | 1,2,3,4,5 |
| 3 | Advanced Charting | Practical | Practical Evaluation | 20 % | Week 7 | 1,2,3 |
| 4 | Assignment | Project | Individual Project | 20 % | Week 11 | 1,2,3,5 |
| 5 | End of Module Assessment | Coursework Assessment | Practical Evaluation | 20 % | Week 13 | 4,5 |
Full Time Mode Workload
| Type | Location | Description | Hours | Frequency | Avg Workload |
|---|---|---|---|---|---|
| Online Lecture | Online | Lecture | 1 | Weekly | 1.00 |
| Supervision | Online | Practical | 2 | Weekly | 2.00 |
| Independent Learning | Not Specified | Self Study | 4 | Weekly | 4.00 |
Total Full Time Average Weekly Learner Contact Time 3.00 Hours
Required & Recommended Book List
Required Reading
2019-07-15 New Perspectives Microsoft Office 365 & Excel 2019 Comprehensive
ISBN 0357025768 ISBN-13 9780357025765
2019-07-15 New Perspectives Microsoft Office 365 & Excel 2019 Comprehensive
ISBN 0357025768 ISBN-13 9780357025765
Develop the Microsoft Office 365 and Excel 2019 skills students need to be successful in college and beyond with the emphasis on critical-thinking, problem-solving, and in-depth coverage found in NEW PERSPECTIVES MICROSOFT OFFICE 365 & EXCEL 2019 COMPREHENSIVE. Updated with all-new case scenarios, this edition clearly applies the skills students are learning to real-world situations to make concepts even more relevant across the applications and reinforces critical skills to make them successful in their educational and professional careers. NEW PERSPECTIVES MICROSOFT OFFICE 365 & EXCEL 2019 COMPREHENSIVE demonstrates the importance of what students are learning while strengthening your skills and helping students transfer those skills to other applications and disciplines for further success. In addition, MindTap and updated SAM (Skills Assessment Manager) online resources are available to guide additional study and ensure successful results.
Required Reading
15/03/2019 Exploring Microsoft Office Excel 2019 Comprehensive Pearson
15/03/2019 Exploring Microsoft Office Excel 2019 Comprehensive Pearson