Timmdrake

This Genetics 214 Tutorial Package (2024) offers a complete set of four Tutorials and Memorandums from Stellenbosch University, providing comprehensive coverage of advanced genetics principles for effective student revision.

This document is the Tutorial 4 and Memorandum for the Genetics 214 (Genetika 214) course at Stellenbosch University, which integrates core principles of Quantitative and Population Genetics. The tutorial requires students to analyze breeding data for multiple traits (e.g., goldfish fin size and disease resistance) to calculate the heritability (specifically narrow-sense heritability) and the response to selection to determine the potential success of a continued selective breeding program. Furt...

This document is the Tutorial 3 and Memorandum for the Genetics 214 (Genetika 214) course at Stellenbosch University, focusing on population genetics and the Hardy-Weinberg equilibrium. The tutorial requires students to calculate allele and genotype frequencies in different populations, test for deviations from Hardy-Weinberg equilibrium using the Chi-square test, analyze the effects of selection on allele frequencies over generations, and apply methods to estimate the frequency of a heterozygou...

This document is the Tutorial 2 and Memorandum for the Genetics 214 (Genetika 214) course at Stellenbosch University, focusing on advanced quantitative and transmission genetics. The tutorial primarily covers linkage and chromosome mapping, requiring students to analyze test cross data to calculate recombination frequencies, determine gene order in three-point crosses, construct accurate chromosome maps with distances in centimorgans (cM), and calculate both the Coefficient of Coincidence and In...

This document is the Tutorial 1 and Memorandum for the Genetics 214 (Genetika 214) course at Stellenbosch University, covering core Mendelian inheritance and its complex extensions. The tutorial tests students ability to deduce modes of inheritance like Incomplete Dominance and Recessive Epistasis, apply Mendel's four postulates to experimental data, validate a non-Mendelian hypothesis (specifically Dominant Epistasis) using a Chi-square test, and explain complex genetic phenomena such as recess...

This is the definitive resource for anyone serious about mastering Microsoft Excel. We've bundled four in-depth, professional guides into one essential package to take you from core fundamentals to advanced data wizardry. Start with the "Formulas & Functions" guide to build a rock-solid foundation in calculation and automation. Then, learn to struc

This comprehensive guide delivers an expert-level walkthrough of Excel's most powerful data analysis tools: PivotTables, Scenarios, and Solver. It provides step-by-step instructions for mastering PivotTables, from creation and layout customization to using slicers, timelines, and calculated fields for dynamic data exploration. The document further delves into advanced techniques like drilling down into details, using the GETPIVOTDATA function, and building multi-table data models with Power P...

This document provides a detailed, step-by-step guide to effectively using Excel's Conditional Formatting and Data Validation tools to enhance data clarity, accuracy, and visual impact. It covers how to apply dynamic visual cues like Data Bars, Icon Sets, and Highlight Cells rules to instantly identify trends, outliers, and duplicates. The guide also thoroughly explains how to create and manage Data Validation rules to control user input, including setting up input messages and custom error a...

This document provides a comprehensive, step-by-step guide to mastering fundamental and intermediate Excel functions and formulas. It covers essential skills such as creating formulas with absolute, relative, and mixed cell references, using arithmetic operators, and understanding the order of operations. The guide also delves into a wide array of critical functions including SUM, AVERAGE, COUNT, IF, VLOOKUP, HLOOKUP, and modern alternatives like XLOOKUP (implied via IFS, SWITCH), as well as tex...

This document offers a comprehensive, step-by-step tutorial covering essential to advanced features for enhancing data management and analysis. It provides clear, task-oriented instructions on fundamental skills such as renaming worksheets, using Goal Seek, and creating data tables, while also delving into more complex functionalities like building and formatting PivotTables, managing scenarios, utilizing Solver for optimization, and integrating Power Pivot to create relationships between multip...