COMP06279 2020 Spreadsheets: Skills and Techniques in Health Sciences
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.
On completion of this module the learner will/should be able to;
Create complex formulae and advanced charts
Use a wide range of Excel functions – Mathematical / Statistical / Financial / Text / Lookup / Date & Time
Create Tables, PivotTables and PivotCharts
Model problems using advanced features in spreadsheet software.
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.
Where the module mark is below 40%, the student will be asked to resubmit assignments for re-evaluation or repeat a practical continuous assessment.
Applying different trend lines
Applying secondary axes, error bars, etc.
Lookup and Information Functions
Vertical Lookup (VLOOKUP)
Horizontal Lookup (HLOOKUP)
INDEX, MATCH & OFFSET
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
Format as Table Feature
PivotTables and PivotCharts
Creating a Pivot Table
Updating the Table
Changing the Table Structure
Formatting the Pivot Table
Creating Charts from the Data
Applying and Managing Conditional Formatting
Top / Bottom
Creating Formula based Conditional formatting
What If Analysis Tools
Coursework & Assessment Breakdown
|Title||Type||Form||Percent||Week||Learning Outcomes Assessed|
|1||Practical Evaluation Weekly activities||Continuous Assessment||Practical Evaluation||20 %||OnGoing||1,2,3,4,5|
|2||Online Quizzes||Continuous Assessment||Multiple Choice||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||Continuous Assessment||Practical Evaluation||20 %||Week 13||4,5|
Full Time Mode Workload
|Independent Learning||Not Specified||Self Study||4||Weekly||4.00|
Required & Recommended Book List
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.
15/03/2019 Exploring Microsoft Office Excel 2019 Comprehensive Pearson