TECH06013 2022 Technical Communication (Numeric)
This module aims to provide learners with the necessary skills and competence to understand mathematical concepts and investigate a range of common uses for spreadsheets. It aims also to enable students to understand and assess quantitative information presented to them.
Learning Outcomes
On completion of this module the learner will/should be able to;
Demonstrate competence in numerical operations.
Organise data in tabular or graphical form.
Summarise and analyse statistical data.
Solve probability problems.
Create a Spreadsheet - data input, formatting, manipulation & reporting
Teaching and Learning Strategies
The teaching and learning strategy is one which is founded on student-centered active learning. Students will be supported in this module through the use of various virtual learning environments. The student will develop and apply their learning through practical examples, case studies and exercise sheets.
Module Assessment Strategies
Written examination at the end of the semester and quizzes during the semester.
Repeat Assessments
The repeat assessment will involve a Repeat Exam.
Indicative Syllabus
1. Basic Mathematics
- Perform arithmetic operations using fractions
- Perform calculations using percentages and ratios
- Apply the laws of indices to expressions involving indices
- Apply the rules of precedence in evaluating expressions
- Solve insurance related business problems
2. Data Presentation
- Primary and secondary data
- Tabulation of data
- Use various methods of representing data in graphical form
3. Data Summarisation
- Calculate mean, median and mode
- Calculate the range, interquartile range and standard deviation
4. Probability:
- Define and calculate probabilities
- Addition & multiplication laws of probability
- Solving problems involving the Normal Distribution
5. Spreadsheets & Data Analysis
- purpose, features, benefits & drawbacks
- different types of spreadsheets - MS Excel, Open Office, Google docs, MS 365 etc
- data entry & editing
- copying & moving data
- formatting & conditional formatting
- spreadsheet structure/layout/views/quick access toolbar
- 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, sparklines
- freezing panes
- locking & protecting worksheets/workbooks
- inserting new worksheets
- working with multiple worksheets
- inserting headers & footers
- printing
Coursework & Assessment Breakdown
Coursework Assessment
Title | Type | Form | Percent | Week | Learning Outcomes Assessed | |
---|---|---|---|---|---|---|
1 | CA | Coursework Assessment | Assessment | 40 % | OnGoing | 1,2,3,4,5 |
End of Semester / Year Assessment
Title | Type | Form | Percent | Week | Learning Outcomes Assessed | |
---|---|---|---|---|---|---|
1 | Final Exam | Final Exam | Closed Book Exam | 60 % | End of Semester | 1,2,3,4 |
Full Time Mode Workload
Type | Location | Description | Hours | Frequency | Avg Workload |
---|---|---|---|---|---|
Lecture | Online | Lecture | 0.75 | Weekly | 0.75 |
Tutorial | Online | Tutorial | 0.5 | Weekly | 0.50 |
Tutorial | Offsite Facility | Face to Face Tutorial | 1.5 | Twice Per Semester | 0.20 |
Independent Learning | Not Specified | Independent Learning | 2 | Weekly | 2.00 |
Required & Recommended Book List
2018 Business Mathematics
ISBN 0134693329 ISBN-13 9780134693323
For courses in Business Mathematics. Focuses on current issues, real companies, and pragmatic business scenarios Business Mathematics by Clendenen and Salzman teaches students the mathematical skills they need for success in business, emphasizing mastery of business concepts and scenarios that require a mathematical solution. With a strong focus on current issues, real companies, and pragmatic business scenarios, the authors cover the full spectrum of basic business math, placing every concept in context with relevant examples. Along with an updated MyLab(tm) Math course, the 14th Edition has been significantly revised to modernize the text, improve discussions, and make the material more meaningful to students. This revision is packed with data, examples, graphs, photographs, and case studies that demonstrate the material's relevance as it teaches students to interpret data and information. A global perspective is emphasized through examples and exercises that highlight issues in other countries. Also available with MyLab Math By combining trusted author content with digital tools and a flexible platform, MyLab personalizes the learning experience and improves results for each student. Note: You are purchasing a standalone product; MyLab Math does not come packaged with this content. Students, if interested in purchasing this title with MyLab Math, ask your instructor to confirm the correct package ISBN and Course ID. Instructors, contact your Pearson representative for more information. If you would like to purchase both the physical text and MyLab Math, search for: 0135195969 / 9780135195963 Business Mathematics Plus MyLab Math with Pearson eText - Access Card Package Package consists of: 0134693329 / 9780134693323 Business Mathematics, 14e 0134836235 / 9780134836232 MyLab Math with Pearson eText - Access Card - for Business Mathematics, 14/e
![](http://ecx.images-amazon.com/images/I/514tQDg2TIL._SL75_.jpg)
2012-12-31 Statistics for Business and Economics (12th Edition) Pearson
ISBN 032182623X ISBN-13 9780321826237
Statistics for Business and Economics, Twelfth Edition, meets today's business students with a balance of clarity and rigor, and applications incorporated from a diverse range of industries. This classic text covers a wide variety of data collection and analysis techniques with these goals in mind: developing statistical thinking, learning to assess the credibility and value of inferences made from data, and making informed business decisions.
The Twelfth Edition has been updated with real, current data in many of the exercises, examples, and applications. Exercises draw on actual business situations and recent economic events so that students can test their knowledge throughout the course. Statistics in Action case studies open each chapter with a recent, controversial, or high-profile business issue, motivating students to critically evaluate the findings and think through the statistical issues involved. A continued emphasis on ethics highlights the importance of ethical behavior in collecting, interpreting, and reporting on data.
![](http://ecx.images-amazon.com/images/I/41uyoSjZpZL._SL75_.jpg)
2013 Basic Statistics for Business and Economics
ISBN 0073521477 ISBN-13 9780073521473
Used book
![](http://ecx.images-amazon.com/images/I/51NW00PX0QL._SL75_.jpg)
2006-03-24 Using Statistics Gill & Macmillan Ltd
ISBN 0717140229 ISBN-13 9780717140220
This book uses practical worked examples and problems with answers, in an Irish context. It provides an insight into your processes, allowing you to understand them and ultimately improve them. It can be used alone or in conjunction with any statistical package of choice. Web support is provided for lecturers with PowerPoint slides, web links, and data sets for each chapter, which support all statistical software. This book is suitable for undergraduate students of business, science and engineering, post-graduate students, researchers and professionals. Comments from students: "Very well presented. The author made it seem very simple. The examples use real life, are easy to understand and interesting". "The author understands the worries students have, and knows our limits". "Examples are relevant and easy to relate to".
![](http://ecx.images-amazon.com/images/I/51ZxIqqFHTL._SL75_.jpg)
2013-03-04 Excel 2013 Bible Wiley
ISBN 1118490363 ISBN-13 9781118490365
Excel at Excel with the help of this bestselling spreadsheet guide
John Walkenbach's name is synonymous with excellence in computer books that decipher the complexities of Microsoft Excel. Known as "Mr. Spreadsheet," Walkenbach shows you how to maximize the power of Excel 2013 while bringing you up to speed on the latest features. This perennial bestseller is fully updated to cover all the new features of Excel 2013, including how to navigate the user interface, take advantage of various file formats, master formulas, analyze data with PivotTables, and more.
Whether you're an Excel beginner who is looking to get more savvy or an advanced user looking to become a power user, this latest edition provides you with comprehensive coverage as well as helpful tips, tricks, and techniques that you won't find anywhere else.
- Shares the invaluable insight of Excel guru and bestselling author "Mr. Spreadsheet" John Walkenbach as he guides you through every aspect of Excel 2013
- Provides essential coverage of all the newest features of Excel 2013
- Presents material in a clear, concise, logical format that is ideal for all levels of Excel experience
- Features a website that includes downloadable templates and worksheets from the book
Chart your path to fantastic formulas and stellar spreadsheets with Excel 2013 Bible!